Candidates About

 

Nishanth B

SR Data Modeler/Data Analyst

 

EXECUTIVE SUMMARY:

 

Ø  Over 8 years of working experience as a Data Modeler and Data Analyst with high proficiency in requirement gathering and data modeling including design and support of various applications in OLTP, Data Warehousing, OLAP and ETL Environment. 

Ø  Excellence in delivering Quality Conceptual, Logical and Physical Data Models for Multiple projects involving various Enterprise New and Existing Applications and Data Warehouse. 

Ø  Experienced in identifying entities, attributes, metrics, and relationships; also assigning keys and optimizing the model. 

Ø  Experience in designing star schema, Snowflake schema for Data Warehouse, ODS architecture by using tools like Erwin Data Modeler, Power Designer, Embarcadero E-R Studio and Microsoft Visio. 

Ø  Having good knowledge in Normalization and De-Normalization techniques for optimum performance in relational and dimensional database environments. 

Ø  Strong experience working with conceptual, logical and physical Data Modeling considering Meta data standards.

Ø  Experience working with Agile and Waterfall data modeling methodologies. . 

Ø  Proficient in data mart design, creation of cubes, identifying facts & dimensions, star & snowflake schemes and canonical model.

Ø  Experience in a formal Software Development, agile environment 

Ø  Extensive experience in using ER modeling tools such as Erwin and ER/Studio, Teradata, BTEQ, MLDM and MDM 

Ø  Excellent SQL programming skills and developed Stored Procedures, Triggers, Functions, Packages using SQL/PL SQL. Performance tuning and query optimization techniques in transactional and data warehouse environments. 

Ø  Involved in the maintenance of the repositories for the metadata. 

Ø  Generation and testing of ddl from CASE tool 

Ø  Experience in logical/physical database design and review sessions to determine and describe data flow and data mapping from source to target databases coordinating with End Users, Business Analysts, DBAs and Application . 

Ø  Experience in generating DDL scripts and creating indexing strategies. 

Ø  Oracle administration on 10g, 9i versions. Backup and Recovery strategies using RMAN, Cold\Hot backups, Replication and other data migration strategies. 

Ø  Proficient in data Cleansing and data Profiling based on standards. 

Ø  Experience in Oracle EBS suite and AR 

Ø  Excellent analytical and communication skills with clear understanding of business process flow, SDLC life cycle and facilitated JAD sessions. 

Ø  Good interpersonal and human relation skills to interact with clients and co-workers.

 

Core Competencies:

 

Data Modelling Languages	Erwin r7.1/7.2, Erwin r8.2, Erwin r9.1/9.5/9.6 Embarcadero ER/Studio, Oracle Designer, Sybase, Power Designer.
OLAP Tools	Microsoft Analysis Services, Business Objects, Crystal Reports9.
Programming Languages	SQL, T-SQL, PL/SQL, Base SAS, HTML,XML VB.NET, C, C++, UNIX and Shell Scripting
Database Tools	Microsoft SQL Server 200/2005/2008/2012/2014, MySQL, Oracle 11g/10g/9i/8i, DB2, and Teradata V2R6.1
Packages	Microsoft Office Suite, Microsoft Project 2010, SAP and Microsoft Visio.
ETL Tools	Informatica 7.1/6.2 , Data Junction, DataStage SSIS, BODS.
Other Tools	SAS Enterprise Guide, SAP ECC and Panorama Web Service, Code Flow/TFS

 

Professional Experience:

 

THE VANGUARD GROUP INC- MALVERN, PA                                                          OCT2015-Present

Sr. DATA MODELER/DATA ANALYST

Responsibilities:

Ø  Created conceptual, logical and physical models based on requirements gathered through interviews with the business users. 

Ø  Updated existing models to integrate new functionality into an existing application. Conducted one-on-one sessions with business users to gather warehouse requirements. 

Ø  Analyzed database requirements in detail with the project stakeholders by conducting joint Requirement Development sessions. 

Ø  Developed normalized Logical and Physical database models to design OLTP system 
Created dimensional model for the reporting system by identifying required dimensions and facts using Erwin. 

Ø  Created DDL scripts for implementing Data Modeling changes. Created ERWIN reports in HTML, RTF format depending upon the requirement, Published Data model in model mart, created naming convention files, co-coordinated with DBAs to apply the data model changes 

Ø  Used forward engineering to create a Physical Data Model with DDL that best suits the requirements from the Logical Data Model. 

Ø  Maintaining and implementing Data Models for Enterprise Data Warehouse using ERWIN. 

Ø  Create and maintain Metadata, including table, column definitions. 

Ø  Worked with Database Administrators, Business Analysts and Content Developers to conduct design reviews and validate the developed models. 

Ø  Responsible for defining the naming standards for Data warehouse. 

Ø  Possess strong Documentation skills and knowledge sharing among Team, conducted Data modeling review sessions for different user groups, participated in sessions to identify requirement feasibility. 

Ø  Extensive experience in PL SQL programming Stored Procedures, Functions, Packages and Triggers 

Ø  Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement. 

Ø  Massaged the existing model to create new logical and physical models that formed the basis for the new application. 

Ø  Eliminated errors in ERwin models through the implementation of Model Mart (a companion tool to ERwin that controls the versioning of models). 

Ø  Used Erwin for reverse engineering to connect to existing  and ODS to create graphical representation in the form of Entity Relationships and elicit more information 
Developed Data Migration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW). 

Ø  Identified the most appropriate data sources based on an understanding of corporate data thus providing a higher level of consistency in reports being used by various levels of management. 

Ø  Verified that the correct authoritative sources were being used and that the extract, transform and load (ETL) routines would not compromise the integrity of the source data. 

Environment:  Erwin r8, Windows XP NT 2000, SQL Server 2008, Teradata, Oracle11g, DB2, Informix, MS Excel, Mainframes MS Visio, Rational Rose, Requisite Pro.

 

 

TOYOTA- TORRANCE,CA                                                                                     NOV2012- AUG2015

 DATA MODELER / DATA ANALYST

Responsibilities:

Ø  Worked with Business users for requirements gathering, business analysis and project coordination. 

Ø  Developed a Conceptual Model and Logical Model using Erwin based on requirements analysis. 

Ø  Created various Physical Data Models based on discussions with DBAs and ETL developers. 

Ø  Worked on data mapping process from source system to target system. 

Ø  Created dimensional model for the reporting system by identifying required facts and dimensions using Erwin. 

Ø  Extensively used Star and Snowflake Schema methodologies. 

Ø  Developed and maintained data Dictionary to create Metadata Reports for technical and business purpose. 

Ø  Worked on Performance Tuning of the database which includes indexes, optimizing SQL Statements. 

Ø  Used Model Mart of Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement. 

Ø  Implemented Forward engineering to create tables, views and SQL scripts and mapping documents. 

Ø  Prepared data dictionaries and Source-Target Mapping documents to ease the ETL process and user's understanding of the data warehouse objects 

Ø  Translated business concepts into XML vocabularies by designing XML Schemas with UML. 

Ø  Used Normalization (1NF, 2NF & 3NF) and Denormalization techniques for effective performance in OLTP and OLAP systems. 

Ø  Good understanding and experience with the entire data Migration process from analyzing the existing data, cleansing, validating, translating tables, converting and subsequent upload into new platform. 

Ø  Created documentation and test cases, worked with users for new module enhancements and testing. 

Ø  Worked with business analyst to design weekly reports using combination of Crystal Reports. 

Ø  Understood existing data model and documented suspected design affecting the performance of the system. 

Ø  Extracted data from databases like Oracle, SQL server and DB2 using Informatica to load it into a single repository for data analysis. 

Ø  Involved in development and implementation of SSIS, SSRS and SSAS application solutions for various business units across the organization. 

Ø  Experienced in  migration and cleansing rules for the integrated architecture (OLTP, ODS, DW) 

Ø  Wrote DDL and DML statements for creating, altering tables and converting characters into numeric values.

Environment: Oracle SQL Developer, Oracle Data Modeler, Teradata, SSIS, Business Objects, Teradata, Oracle12c, SQL server 2012, SQL Assistant 13.11, data stage 8.1, DB2, Informatica Power Center 9.5.

 

L.A. CARE, LOS ANGELES,CA                                                                                SEP2010 – JUNE2012

DATA MODELER/DATA ANALYST

Responsibilities:

Ø  Implemented dimension model (logical and physical data modeling) in the existing architecture using ER Studio. 

Ø  Created ER diagrams using Open Sphere Model and implemented concepts like Star-Schema Modeling, Snowflake Schema Modeling, Fact and Dimension tables. 

Ø  Designed and Developed Oracle PL/SQL Procedures LINUXand UNIX Shell Scripts for data Import/Export and data Conversions. 

Ø  Designed the ER diagrams, logical model (relationship, cardinality, attributes, and, candidate keys). 

Ø  Written Procedures and Functions using Dynamic SQL and written complex SQL queries using joins, sub queries and correlated sub queries. 

Ø  Generated DDL statements for the creation of new ER/studio objects like table, views, indexes, packages and stored procedures. 

Ø   Experience in designing a canonical model

Ø  Generate DDL scripts for database modification, Macros, Views and set tables. 

Ø  Developed logical and physical data models and mapping logical entities to the enterpriseData Model. 

Ø  Designed and developed star schema model for target database using ER/Studio. 

Ø  Extensively worked in SQL, PL/SQL, SQL Plus, SQL Loader, Query performance tuning, DDL scripts, database objects like Tables, Views Indexes, Synonyms and Sequences. 

Ø  Handled multiple projects simultaneously and manage the projects to accomplish desired results. 

Ø  Applied appropriate level of abstraction in designs and confirmed that data designs support the integration of data  and information flow across systems and platforms. 

Ø  Analyzed and made recommendations on the impact of  designs as they related to common conceptual models. 

Ø  Updated and enforced data architecture policies, standards and procedures. 

Ø  Provided data SME knowledge to both IT and business users to promote a common understanding and the appropriate usage of the bank's data assets. 

Ø  Worked in generating and documenting Metadata while designing OLTP and OLAP systems environment. 

Ø  Ensured data objects adhere to defined standards and best practices. 

Ø  data Promoted data models into production metadata environments. 

Ø  Worked with both relational and dimensional data modeling,  data standards and data  model practices. 

Ø  Performed maintenance of current data diagrams and metadata to enable further enhancements. 

. 

Ø  Provided Level of Efforts, activity status, identified dependencies impacting deliverables, identified risks and mitigation plans, identified issues and impacts. 

Ø  Designed database solution for applications, including all required database design components and artifacts.

 

Environment: Data modeler, SSAS, T-SQL, SQL Server, LINUX, MDM, PL/SQL, ER/Studio, ETL, Normalization and De-normalization, Metadata, Star-Schema Modeling, UNIX, Snowflake Schema Modeling etc.

 

 

 

ONE TECHNOLOGIES- HYDERABAD, INDIA                                       JUNE 2009 – AUG 2010

DATA ANALYST

Responsibilities:

Ø  Involved in gathering user requirements along with the Business Analyst. 

Ø  Participated in creating the logical model of an online processing system for a large financial institution using Erwin. 

Ø  Worked with DBAs to generate physical model. 

Ø  Worked on Bill inmon methodologies for modeling. 

Ø  Created tables, views, procedures and SQL scripts and mapping documents. 

Ø  Worked on slowly changing dimensions (SCD) and hierarchical dimensions 

Ø  Worked on conversion process of data, which is stored in flat files into oracle tables. 

Ø  Designed and Developed SQL procedures, functions and packages to create Summary tables. 

Ø  Generating ad-hoc reports using crystal reports 9. 

Ø  Developed database backup and restore policy. 

Ø  Expertise in Creating Report Models for building Ad-hoc Reports Using SSRS. 

Ø  Expertise in Generating Reports using SSRS and Excel Spreadsheet. 

Ø  Expertise in Creating various Parameterized, Cascaded, Linked, Drill-through and Drill-down Reports. 

Ø  Hands on Experience in creating ETL Packages using SQL Server 2005 Integration Services (SSIS). 

Ø  Good Understanding in Database and Data Warehousing Concepts. 

Environment: Oracle8i, SQLServer, SSIS, SSRS, ERWIN, HTML, Crystalreports9, MSOFFICE, Windows XP.