SUMMARY

• 7+ years of experience in System Analysis, Design, Development, and implementation of Client Server applications using different database technologies.
• Involved in various phases ofSoftware Development Life Cycle i.e. Requirement Analysis, Design, Implementation and Testing.
• Experience in OLTP, OLAP Data warehouse and Business Intelligence modeling.
• Expertise in creating Conceptual, Logical and Physical data models in OLTP and dimensional models, star schemas data marts and cubes for data warehouse.
• Experience in working with Logical and Physical data mapping from source to target.
• Experience in gathering and validating reporting requirements and designed optimized reports.
• Experience in working on the testing and condition of data and validation of the data.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a corporate - wide-ETL Solution
• Good Data Warehousing concepts including Meta data and Data Marts.
• Extensive experience in project management best practices, processes, & methodologies.
• Strong knowledge and understanding of structured analysis and technical design techniques.
• Experience in Gap analysis and Gap Resolution process succeeding the Logical data mapping.
• Expert in writing SQL queries and analysis of the data patterns.
• Experience in Data Augmentation, Data Scrubbing, Data Quality, Data Profiling and Data Cleansing.
• Experience in the implementation of the Data Management Standards for the projects.
• Facilitated the model walkthrough sessions with Business users and Developers.
• Experience with data modeling tools like ER studio and Power Designer.
• Extensive experience on Excel, Word, PowerPoint, MS Project, MS Visio, and Rational Suite.
• Strong team-oriented interpersonal and communication skills.
• Ability to effectively adapt to rapidly changing technology and apply it to business needs.
• Strong analytical and problem-solving skills.

TECHNICAL SKILLS

Modeling Tools: ER Studio, Erwin, Power Designer

ETL Tools: Informatica, Data stage

Reporting Tools: Business Objects, Micro Strategy, Cognos, Tableau

Databases: Netezza, Teradata, Oracle, SQL server, IBM Db2, SAP-Sybase.

Methodologies: RUP, UML, Waterfall, Agile, SOA

Process Modeling: MS Visio, Rational Rose

Operating Systems: Windows XP, Win 7, Win 8 LINUX

PROFESSIONAL EXPERIENCE

Confidential, WINSTON SALEM, NC

DATA MODELER / DATA ANALYST

Responsibilities:

• Involved in the projects from requirement analysis to better understand the requirements and support the development team with the better understanding of thedata.
• Interacted with business users to understand their business requirements and Liaised with business and functional owners during project scoping and planning to identify the high-level requirements for the project.
• Involved in gathering complete requirements by organizing and managing meetings with Business Analysts, Data Stewards and subject matter experts on a regular basis.
• Performed gap analysis of business rules, business and system process flows, user administration, and requirements. Worked with the functional owners to bridge the gaps.
• Reverse-Engineered numerous existing database schemas to get an understanding of existing database architecture.
• Involved in the data profiling activities for the column assessment and natural key study.
• Performed complex data analysis in support of ad-hoc, standard, and project related requests.
• Identified and resolved data related issues.
• Performed Data Mining to analyze the patterns of the data sets.
• Developing data validation and file validation rules for application.
• Developed Data quality completeness and policy rules for the application and ETL team to cleanse and transform the data.
• Created logical data models based on requirement and captured metadata
• Worked with the business to gather reporting requirements to support dashboards, canned reports and adhoc query ability for the users
• Worked on Gap analysis and Gap Resolution process succeeding the Logical data mapping.
• Designed Logical and Physical data models for Business Intelligence Enterprise Data Warehousing team.
• Worked on source to target mapping between source and target data model for ETL team
• Conducted data model review meetings with development, and data team to communicate business requirements.
• Work with offshore team to handle data warehouse, ETL and Business Intelligent development.
• Created and updated metadata in the data model repository.
• Extensively used SQL to verify that data has been moved from transactional system to Data warehouse reporting system in accordance with requirements.
• Provided support to the development and testing teams during the lifecycle of the project.

Environment: Power Designer, Informatica, Netezza, DB2, Flat Files, TOAD, Microsoft Visual Studio, MSSQL Server 2012, Micro Strategy, Tableau.

Confidential, GRAND RAPIDS, MI

DATA ANALYST

Responsibilities:

• Working with the Business and Development team members and the Data Architect of the various components.
• Worked with project teams to collect database requirements and scope them to create logical data model
• Developed data quality rules for the application and ETL team to cleanse and transform the data.
• Involved in Data migration of legacy customer accounts, products data into the new collateral management application.
• Worked in the Data migration approach of loading into target on incremental approach.
• Designed staging tables for Data migration to load and transform legacy data.
• Interacting with the customers to understand the requirements.
• Involved in Creation of Data dictionary for collateral management application
• Worked with test team for writing scripts and validate data and fix database errors in database
• Creating the data requirements for the shared program data stores and generate the Necessary DDLs for creating the database objects (tables, views, stored procedures, triggers)
• Worked on source to target mapping between legacy and target data model
• Create scripts and execute them to perform data migration between environments.
• Work with the Change Management team for migrating database objects to production environment
• Performed data investigation to find out the data issues in the underlying feeds and databases
• Created and updated metadata in the data model repository.
• Facilitated metadata walkthrough sessions with application and data governance team.
• Worked in the development of end to end data flows for the application
• Worked on Design, report and layout with Reporting team
• Developed Quality Assurance plans as data cleansing and data quality rules.
• Worked in the validation of test data and data conditioning to support the testing.
• Worked on the documentation of entities and attributes and metadata.
• Worked in evaluating and implementing tool sets for data profiling
• Worked with data conditioning and test cases for supporting testing phase

Environment: ER studio, Data Stage, Teradata, DB2, Flat Files, Teradata SQL Assistant, Micro soft Visual Studio, Sybase 12.5, MSSQL Server 2012, Micro Strategy.

Confidential, WARREN, NJ

BUSINESS ANALYST/DATA ANALYST

Responsibilities:

• Designing Logical and Physical data models for Data Acquisition and Product Risk Rating system.
• Working with the Business and Development team members and the Data Architect of the various components.
• Developed data validation and file validation rules for application.
• Developed Data quality completeness and policy rules for the application and ETL team to cleanse and transform the data.
• Created logical data models based on requirement and captured metadata
• Worked with the business to gather reporting requirements for RDIP to support dashboards, canned reports and adhoc query ability for the users
• Involved in the documentation of the use cases and interacted with the business intelligence team, management team and user community.
• Involved in the creation of the report prototypes with the reporting team.
• Developed integrated MDM solutions for operational efficiency and data quality standards for customer, product and locations.
• Worked on Gap analysis and Gap Resolution process succeeding the Logical data mapping.
• Worked on source to target mapping between source and target data model for ETL team
• Work with offshore team to handle data warehouse, ETL and Business Intelligent development.
• Created and updated metadata in the data model repository.
• Documented and updated Data dictionary for RDIP Data model for ERWIN.
• Involved in creation and maintenance of ER Diagrams.
• Worked in the development of end to end data flows for the application
• Developed QA Plans for Retails distribution of investment products
• Developed rules for data cleansing and for transformations
• Worked on Design, report and layout with Reporting team
• Worked in the validation of test data and data conditioning to support the testing.
• Worked on the documentation of entities and attributes and metadata.
• Worked with quality center tool for defect tracking and resolution
• Involved in creating the data naming conventions and standards and implemented them.
• Supported teams from various regions as a part of Country integration testing for Data Acquisition.
• Worked with QTP tool to identify defects and generated reports.

Environment: Oracle 11g, PL SQL, Erwin, Visio, Teradata, Ab Initio GDE 1.15, Cognos, HP quality center10.0, UNIX, QTP 10.00, MicroStrategy 9.0, Netezza 6.0.5