SUMMARY

• Over 7 Years of IT experience as Senior Data and Business Analyst, Data Modeling, ETL Developer and handling Big data projects. On various domains like Health care, Insurance, Financial and Retail.
• Strong experience in Business and Data Modeling/Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Governance, Data Integration, MDM, NoSQL and Metadata Management Services and Configuration Management.
• Extensive experienced on ER Modeling, Dimensional Modeling (Star Schema, Snowflake Schema) and Datawarehousing and OLAP using Erwin tool.
• Proficiency, including architecture, with different RDBMS platforms likes Oracle, Teradata and SQL Server.
• Very proficient with DataAnalysis, mapping source and target systems for Datamigration efforts and resolving issues relating to Datamigration.
• Performed Datacleansing and Dataprofiling for detecting and correcting in accurate Datafrom the databases and to track Dataquality and to assess the risk involved in integrating Datafor new applications.
• Experience on working Big data technologies like HADOOP HDFS, Hive, Impala.
• Designed Data Model for Hive platform
• Implemented Slowly Changing Dimensions Type2 and Type3 for accessing history of Data changes
• Extensive experience working with enterprise level data warehouses, writing advanced SQL queries including OLAP functionality using both OVER CLAUSE(PARTITION BY and ORDER BY) and OLAP functions to perform Ad - Hoc analysis and reporting
• Hand on ETL tools like Informatica and DataStage; Created source to target mapping documents for the ETL developers and helped them understand complex transformations
• Worked with ETL Team to load sequential files (flat files, text files, CSV files) in Datastageand Worked on Implementing the Slowly Changing Dimension inDatastage
• Experience with Tableau in analysis and creation of dashboards
• Expertise handling all the domain and technical interaction with application users / stakeholders, analyzing client business processes, and documenting business requirements (BRD)
• Extensive experience of building stakeholder relationships, managing communications plans, tracking, assessing, and reporting on the analysis process
• Excellent communication and interpersonal skills, improved greatly as a result of daily interaction with BAs, DAs and stakeholders in defining and clarifying projects/business needs
• Strong knowledge of Software Development Life Cycle (SDLC) including Waterfall and Agile methodologies

TECHNICAL SKILLS

Data Modeling Tools: ERWIN, ER Studio, UML 2.x, MS Visio, & Power Designer.

Defect Tracking and Testing Tools: Quality Center, JIRA, HP ALM, Service Now

Office Applications: MS Office Suite, Visio, SharePoint

Databases: Teradata 13, MS SQL Server 2008 R2,DB2, Oracle 11g

DB Tools: SQL Developer, Teradata SQL Assistant, Toad, CA Erwin DM

Programming languages: Java, SQL, T-SQL, PL/SQL, SAS

PROFESSIONAL EXPERIENCE

Confidential, Newark, New Jersey

Sr. Data Analyst / Sr. Data Modeler

Responsibilities:

• Involvement in SDLC which includes gathering of business requirements, architecture, design document, planning, development
• Gathering and analyzing the business and technical requirements.
• Conducted sessions with business SME and development teams to understand the Change Requests (CR’s), and effects caused on the system by the change requests. Analyzed existing Logical and Physical data models and altered them using Erwin to support enhancements.
• Determined data rules and conducted Logical and Physical design reviews with business users and SMEs for completion and documenting requirements
• Responsible for data mapping, metadata maintenance and enhancing existing Logical and Physical data models.
• Conducted walkthroughs with the Business Analysts, Development teams and DBA to convey the changes made to the data models.
• Worked with Big Data Architects for setting up Big Data Platform in organization and on Hive platform to create Hive Data Models
• Implemented SQL Scripts to modify the data to resolve assigned defects.
• Worked with the ETL team to document the source to target mapping transformation rules for data migration from OLTP to Warehouse environment for Data migration
• Created tables, views, indexes, Partitions and generated SQL scripts using Erwin Forward Engineering for physical implementation.
• Reverse Engineered databases schema into Erwin Physical Data Model for reusability and enhancements and then forward engineered them to Teradata using Erwin.
• Resolved the data inconsistencies between the source systems and the target system by performing Data profiling.
• Designed the data sourcing, data staging and ETL process. Mapped the data between the source and targets

Environment: ERWIN 9.5, oracle 11g, SQL, Hadoop, MapReduce, Hive, Hbase, MS Excel, Tableau, TOAD, Crystal reports 9.

Confidential, Wilmington Delaware

Sr. Data Analyst / Sr. Data Modeler

Responsibilities:

• Understanding the specification and analysed data per the client requirement.
• Conducting requirement gathering sessions with Report Owners/SMEs to understand the current process flow of report generation and identifying the Risk Data elements.
• Created dimensional model for the reporting system by identifying required dimensions and facts using ERWIN.
• Worked on the Snow-flaking the Dimensions to remove redundancy.
• Maintained warehouse metadata, naming standards and warehouse standards.
• Ensured the quality, consistency, and accuracy of data in a timely, effective and reliable manner.
• Identified the Facts and Dimensions.
• Interact with the customer and the SME(s) to identify the relationship between the data element and the business rule to document the data.
• Worked on Hive platform to create Hive Data Models and Impala Models setting up Source, Standard and Conformed zones.
• Back-tracking of Risk Data elements to its source system and capturing all the calculation/derivation logic involved in underlying SAS/SQL codes.
• Mapping the Risk Data elements to the Authoritative Data Source and documenting the Schema, Database, Table details for data modeling purpose.
• Participated in review Sessions with the DM review team by presenting the designed data models and explained how we followed the standards while designing the models.
• Prepared Conceptual Model Use Cases for representing the various dimensions and measures involved in recreation of critical reports.
• If any discrepancy is observed in the data, in depth analysis is done (whether the defect is due to coding issue or due to requirement change) and the defects are logged in ALM.

Environment: ORACLE, Teradata SQL assistant 12.0, Hadoop, Hive, Impala, Windows Server 2012, MS SQL 2012, UNIX, Erwin 7x, Crystal Reports8, Informatica 9x, TOOD, SQL Developer.

Confidential, Hartford, CT

Data Analyst / Data Modeler

Responsibilities:

• Created a logical design of the central relational database using Erwin
• Extensively worked with DTS to load the data from source systems, and run in periodic intervals.
• Worked with data transformations in both Normalized and De-normalized data environments.
• Involved in data manipulation using stored procedures and Integration Services.
• Worked on query optimization, stored procedures, views, and triggers.
• Assisted in OLAP and Data Warehouse environment when assigned.
• Created tables, views, stored procedures and indexes.
• INMONN methodologies were used for architecture.
• Designed and implemented database replication strategies for both internal and Disaster Recovery.
• Performed extensive data analysis and data validation on Teradata.
• Metadata repository was updated and maintained per change requests.
• Experienced in master data management (MDM), Metadata management, and data quality.
• Worked with the Implementation team to ensure a smooth transition from the design to the implementation phase.

Environment: Erwin, ORACLE, Teradata SQL assistant 12.0, Windows Server 2012, UNIX, TOAD.

Confidential

Data Analyst / Data Modeler

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Developed logical and physical data models for central model consolidation..
• Conducted data modeling JAD sessions and communicated data-related standards.
• Used Erwin r7.0 for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/columns as part of data analysis responsibilities
• Designed different type of STAR schemas like detailed data marts and Plan data marts, Monthly Summary data marts using Erwin with various Dimensions Like Time, Services, Customers and various FACT Tables.
• Used reverse engineering to connect to existing database and create graphical representation (E-R diagram).
• Involved using ETL tool Informatica to populate the database, data transformation from the old database to the new database using Oracle
• Involved in different team review meetings.
• Involved in the creation, maintenance of Data Warehouse and repositories containing Metadata.
• Worked with report developers for building OLAP Cubes for ad hoc reporting.
• Performed unit testing and tuned for better performance.
• Involved in the critical design review of the finalized database model.
• Created documentation and test cases, worked with users for new module enhancements and testing. Environment: Erwin r7.0, Informatica 7.1.3, Teradata v2R5/v2R6, Windows XP/NT/2000 servers, Oracle8i, SQL Server 2000/2005, MS Excel, MS Visio, DB2, Microsoft Transaction Server, Crystal Reports, MS-SQL server analysis manager.

Confidential

SQL Developer / Data Modeler

Responsibilities:

• Responsible for data mapping, data migration and enhancing existing Conceptual and Physical data models.
• Designed the conceptual data model and worked with the Business analysts and technical teams to design and update the logical data model in various iterations. Involved in the entire System study, AnalysisandDesign.
• Involved in conducting walkthroughs with business and development teams to validate end-to-end data mapping across various systems.
• Reverse Engineered DB2 databases and then forward engineered them to Teradata using Erwin.
• Worked on data cleansing techniques to make sure no duplicates are present in the data.
• Developed source to target mapping documents to support ETL design.
• Created tables, views, indexes, constraints and generated SQL scripts for physical implementation.
• Implemented SQL Scripts to modify the data to resolve assigned defects.
• Designed Informatica mappings, enabling the extract, transform and loading of the data into target tables.
• Responsible for data validation and writing validation scripts once the data is loaded from source to target.
• Resolved the data type inconsistencies between the source systems and the target system using the Mapping Documents.
• Designed the data sourcing, data staging and ETL process. Mapped the data between the source and targets.

Environment: ERWIN, Informatica Power Centre, SQL Developer, Oracle 11g, ER Studio, HP ALM, Flat files, Toad, Business Objects, OBIEE.