SUMMARY

• Highly skilled software professional with over 7 years of experience in Data Modeling and Data Analysis as a Proficient in gathering Business requirements and handling requirements management.
• Expert in handling healthcare data and have a hands - on experience over 4 years in healthcare industry.
• Excellent ability to understand business needs and data to generate end to end Business Solutions.
• Having good experience with Normalization (1NF, 2NF and 3NF) and De-normalization techniques for improved database performance in OLTP, OLAP, Data Warehouse and Data Mart environments.
• Experienced in designing the Conceptual, Logical and Physical data modeling using ERWIN, Power Designer and ER Studio Data modeling tools.
• Proficient in System Analysis, ER/Dimensional Data Modeling, Database design and implementing RDBMS specific features.
• Experience in Data vault modeling identified and created Hub’s, Satellite tables by analyzing different source systems and created a data vault
• Expert in creating XML and json Schemas for SQL and NO-SQL databases.
• Experience in modeling with both Online Transactional processing (OLTP) and Online Analytical Processing (OLAP) systems.
• Strong knowledge in Enterprise Data Warehousing concepts including Metadata management (MDM) and Data Marts.
• Understanding of Teradata FSDM models.
• A good familiarity and experience in the work environment consisting of Business analysts, Production/ Support teams, Subject Matter Experts, Database Administrators and Database developers.
• Played a critical link between the Subject Matter Experts (SME) providing the business requirements and the rest of the team trying to construct the solution.
• Extensive experience in QA manual testing, development, functional testing and data migration, data analysis and data profiling type of projects.
• Experienced in Software Analysis, Requirements Management and Quality Assurance.
• Expert in user interface designing and creating screenshots using wire frames and comps, and expert in using tools like MS Project and MS Visio.
• Knowledge of Ralph Kimball and Bill Inmon’s approaches to Data Warehousing.
• Proficient in identifying Facts and Dimensions, Star Schema and Snow Flake Schema and ODS architecture for modeling a Data warehouse in Relational, Dimensional and multidimensional modeling.
• Experience in Data Scrubbing/Cleansing, Data Quality, Data Mapping, Data Profiling, Data Validation in ETL.
• Very good understanding of Software Development Life Cycle and Software Testing Methodologies.
• Experience with the software deployment methodologies like Water Fall, Agile and SCRUM.
• Good scripts writing knowledge in SQL, Teradata, and Informatica Analyst.
• Excellent ability in database capacity planning, replication strategies, security, backup, and recovery of various RDBMS/NoSQL databases.
• Experience in designing and developing reports.
• Worked with Unix shell scripting for checking weather informatica servers are up or not and to check ETL schedule tables.
• Strong experience in migrating other databases to Snowflake.
• Expertise in SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS).
• Extensive experience in development of T-SQL, DTS, OLAP, PL/SQL, Stored Procedures, Triggers, Functions, Packages, performance tuning and optimization for business logic implementation.
• Participated in the development, improvement and maintenance of snowflake database applications.
• Well versed with Data profiling, Data Migration and Data Conversions.
• Recognized for partnering with business leaders and technical teams to plan, integrate, document, and execute complex project plans on time and on budget.
• Excellent Communication skills, Self-starter with ability to work with minimal guidance.

TECHNICAL SKILLS

Data Modeling Tools: ERWIN, Power Designer, Toad Designer, Embarcardero ER Studio, IBM Rational Software Architect, MS Visio, ER Studio.

Reporting Tools: Business Objects, Crystal reports, Business Intelligence, SSRS, Qlikview, Tableau, Cognos, Informatica.

Programming Languages: SQL,Java, .NET based C# and VB, C,C++, HTML,PHP, JavaScript, JQuery, Python, R.

ETL Tools: Informatica, SSIS.

Operating System: Windows, MacOS .

Databases and Tools: Oracle,MS SQL Server, MS Access, Teradata, DB2, Sybase, NoSQL, Aqua Data Studio, SQL Server Management Studio, AWS, Microsoft Azure.

Other tools: MS Office (Word, Excel, Power Point), MS Project.

PROFESSIONAL EXPERIENCE

Confidential, Dallas,Tx

Sr.Data Analyst/Data Modeler/Data Architect

Environment: ERWIN, Windows 10, SQL Server, Google Cloud Platform, Microsoft Azure, AWS, Altova XMLSpy, SourceTree, Bitbucket, Oracle, Microsoft Excel, Reports, SSIS, Informatica, Python, R. JIRA

Responsibilities:

• Involved in the critical design reviews discussions, analysis of business requirements and design implementation of the business requirements.
• Created Source and Target Table structures and developed SQL Scripts.
• Created Conceptual, Logical, and physical models using Erwin Designer.
• Migrated data from source systems(Google Cloud Platform) to new core Platforms/ Solutions (Netezza).
• Creaed source and created Source-to-Target mapping documents.
• Created Load order reports for ETL.
• Loaded data into tables using Informatica power center.
• Tested the data after loading them into the tables and prepared unit testing documents.
• Migrated the code to QA and Production Environments using Source Tree and Bit Bucket.
• Managed the offshore team and conducted regular review sessions with the team.
• Coordinated Data Profiling/Data Mapping with Business Subject Matter Experts, Data Architects and ETL Developers.
• Used Erwin Designer for creating tables using Forward Engineering.
• Participated in Architectural discussions while creating solutions and framework
• Highly responsible for Data warehouse and data marts Structure, Design and Development
• Involved in Business meetings for requirement gathering, Business Documentation and Data Warehouse Planning, Design, Development, Implementation.
• Used Erwin Designer for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Created OLTP, ODS and OLAP architectures.
• Developed data warehouse model in snowflake.
• Deployed SQL code to different environments, worked on SQL Backup/recovery models and alerts.
• Used Star Schema for Data warehouse and data marts and worked with snowflake schema models.
• According to the requirements created HTML, PDF format reports by using Erwin Designer.
• Created Fact and Dimension tables used for Reports.
• Worked in 2weeks sprints and regularly reported progress to the business teams using JIRA.

Confidential, Chicago, IL

Sr.Data Analyst/Data Modeler/Data Architect

Environment: Toad Dara Modeler 7.3, Power Designer (R) 17.1, ERWIN r9, Windows 10, SQL Server, MongoDB, Microsoft Azure, AWS, Altova XMLSpy 2018, Visio 2019, Oracle 11g, Microsoft Excel, Crystal Reports, SSIS, Informatica 7.3, Python, R.

Responsibilities:

• Responsible for the analysis of business requirements and design implementation of the business solution.
• Created Conceptual, Logical, and physical models using Toad and Erwin Designer.
• Designed and implemented effective database solutions and models to store and retrieve the company data.
• Migrated data from legacy systems to new core Platforms/ Solutions.
• Architected new solutions and framework.
• Identified source and created Source-to-Target mapping documents.
• Created data sheets for ETL to load the data.
• Created Load order reports for ETL.
• Created ER diagrams for No SQL database models and reviewed them.
• Coordinated Data Profiling/Data Mapping with Business Subject Matter Experts, Data Architects and ETL Developers.
• Used DataStage as an ETL tool to extract data from sources systems, loaded the data into the ORACLE database.
• Used Erwin Designer for creating tables using Forward Engineering
• Highly responsible for Data warehouse and data marts Structure, Design and Development
• Involved in Business meetings for requirement gathering, Business Documentation and Data Warehouse Planning, Design, Development, Implementation.
• Used Erwin Designer for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Created different Database Schemas, Tables, Views, Stored Procedures, Functions.
• Created OLTP, ODS and OLAP architectures.
• Developed data warehouse model in snowflake.
• Deployed SQL code to different environments, worked on SQL Backup/recovery models and alerts.
• Build the Logical and Physical data model for snowflake as per the changes required
• Used the DataStage Designer to develop processes for extracting, cleansing, transforming, integrating and loading data into staging tables.
• Used Star Schema for Data warehouse and data marts and worked with snowflake schema models.
• According to the requirements created HTML, PDF format reports by using Erwin Designer.
• Created Fact and Dimension tables used for Reports.
• Worked with Metadata Definitions, Import and Export of Datastage jobs using Data stage Manager.
• Involved in the critical design review of the finalized database model.
• Involved in the study of the business logic and understanding the physical system and the terms and condition for database.

Confidential, Chicago, IL

Sr. Data Analyst/Data Modeler/Data Architect

Environment: Power Designer (R) 16.6, ERWIN r9, Windows 7, SQL Server, MongoDB, Altova XMLSpy 2018, Visio 2013, Oracle 11g, Microsoft Excel, Crystal Reports, SSIS, Informatica 7.3, Python, R.

Responsibilities:

• Responsible for End-to-End development cycle for Data modeling.
• Responsible for the analysis of business requirements and design implementation of the business solution.
• Created Conceptual, Logical, and physical models using Power Designer.
• Created XML and json schemas to populate the reference data.
• Designed and implemented effective database solutions and models to store and retrieve the company data.
• Migrated data from legacy systems to new core Platforms/ Solutions.
• Architected new solutions and framework.
• Supported data quality issue analysis and remediated strategic data.
• Identified source and created Source-to-Target mapping documents.
• Created data sheets for ETL to load the data.
• Created Load order reports for ETL.
• Created ER diagrams for No SQL database models and reviewed them.
• Developed Enterprise Data Dictionary for reusable objects like domains, attachments, defaults, reference values, User data types and reusable procedural logic.
• Coordinated Data Profiling/Data Mapping with Business Subject Matter Experts, Data Architects and ETL Developers.
• Used Power Designer for creating tables using Forward Engineering
• Highly responsible for Data warehouse and data marts Structure, Design and Development
• Involved in Business meetings for requirement gathering, Business Documentation and Data Warehouse Planning, Design, Development, Implementation.
• Used Power Designer for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Worked with Data query, MSQuery for querying data.
• Created different Database Schemas, Tables, Views, Stored Procedures, Functions.
• Created OLTP, ODS and OLAP architectures.
• Deployed SQL code to different environments, worked on SQL Backup/recovery models and alerts.
• Used Star Schema for Data warehouse and data marts and worked with snowflake schema models.
• According to the requirements created HTML, PDF format reports by using Power Designer.
• Created Fact and Dimension tables used for Reports.
• Developed process methodology for the Reverse Engineering phase of the project.
• Involved using ETL tool Informatica to populate the database, data transformation from the old database to the new database using Oracle.
• Involved in the critical design review of the finalized database model.
• Involved in the study of the business logic and understanding the physical system and the terms and condition for database.
• Created documentation and test cases, worked with users for new module enhancements and testing.

Confidential, Chicago, IL

Sr. Data Analyst/Data Modeler

Environment: ERWIN r9, Windows 7, SQL Server, Oracle 11g, Microsoft Excel, Crystal Reports, SSIS, Informatica 7.3.

Responsibilities:

• Gathered and translated business requirements into detailed, production-level technical specifications, new features, and enhancements to existing technical business functionality.
• Created OLTP, ODS and OLAP architectures.
• Extensively studied the existing OLTP system(s) to create data mart and warehouse systems using the facts, dimensions, and star schema.
• Wrote user requirement documents, created technical specs and design documents for various projects.
• Responsible for the analysis of business requirements and design implementation of the business solution.
• Developed Conceptual, Logical and Physical data models for central model consolidation.
• Worked with DBAs to create a best fit physical data model from the logical data model.
• Conducted data modelling JAD sessions and communicated data-related standards.
• Used ERWIN for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Normalized the tables/relationship to arrive at effective relational schemas without any redundancies.
• Redefined many attributes and relationships in the reverse engineered model and cleansed unwanted tables/ columns as part of data analysis responsibilities.
• Involved in forward/reverse engineering tools and target database schema conversion process by using ERWIN.
• Improved process methodology for the Reverse Engineering phase of the project.
• Involved using ETL tool Informatica to populate the database, data transformation from the old database to the new database using Oracle.
• Designed and developed Use Cases, Activity Diagrams, Sequence Diagrams, OOD (Object Oriented Design) using UML and Visio.
• Defined the naming standards for data warehouse.
• Involved in database design, normalization, de-normalization in building the Data Warehouse and Reporting systems.
• Presented the Dashboard to Business users and cross functional teams, define KPIs (Key Performance Indicators), and identify data sources.
• Experienced in using DDL Triggers (After and Instead of Triggers) to keep track of data manipulations using Audit functionalities.
• Involved in development, deployment, scheduling, and troubleshooting SSIS packages.

Confidential

Data Analyst/Data Modeler/SQL Developer

Environment: SQL Server, Erwin r9, Microsoft Excel, Oracle, TOAD, Windows 7

Responsibilities:

• Documented all data mapping and transformation processes in the Functional Design documents based on the business requirements.
• Involved in modifying various existing packages, Procedures, functions, triggers according to the new business needs.
• Normalized the data up to 3 rd Normal form.
• Assisted in defining, prioritizing, and driving tasks/projects required to maintain unavailable and resilient database environment.
• Managed Architecture involving OLTP, ODS and OLAP.
• Performed the data source mapping.
• PK, FK relationships across the entities and across subject areas are identified.
• Reverse engineered all the Source Databases using ERWIN.
• Gathered requirements, analyzed, and wrote the design documents.
• Prepared High Level Logical Data Models using ERWIN, and later translated the model into physical model using the Forward Engineering technique.
• Documented logical, physical, relational, and dimensional data models.
• Created dimensional model based on star schemas and designed them using ERWIN.
• Identified/documented data sources and transformation rules required to populate and maintain data warehouse content.
• Created Data Stage Server jobs to load data from sequential files, flat files, and MS Access.
• Assisted developers, ETL, BI team and end users to understand the data model.
• Involved in the Data Mart (BMDM) system stores marketing data in an Oracle relational database and is interrogated using the end-user reporting tools.
• Performed Data Profiling to identify data issues upfront, provided SQL prototypes to confirm the business logic provided prior to the development.