SUMMARY

• Over 10 years of diversified experience in all phases of the Software Development Life Cycle (SDLC). Have worked with requirements elicitation and analysis, database design and development, data analysis, application development, testing, implementation, and support. I have worked extensively with Relational Database Management Systems (RDBMS); performed data collection, mapping, modeling, analysis, profiling, and migrate complex data sets from Oracle, SQL Server, and flat file data sources and targets. Have worked with Data Warehouse/ETL tools (Informatica, RAP DI, and Data Stage) & Hands on experience with Oracle, Toad & Erwin Data modeling tools.
• Good experience on interfaces, Data Migration, Data Analysis and Data Conversion.
• Activities include eliciting and analyzing Business Rules and Information Requirements.
• Hands on experience in project life cycle including Requirement gathering and Analysis, Database design, Database development, Application development, Test, Implementation & Support.
• Data Conversion from one or more systems to a centralized system.
• Complex data mapping skills from one source system to another.
• Understand and translate business needs into data models supporting long - term solutions.
• Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models (CDM).
• Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Maintain Conceptual, Logical and Physical data models along with corresponding Metadata/Data Dictionary.
• Optimize and update logical and physical data models to support new and existing projects.
• Develop best practices for standard naming conventions and coding practices to ensure consistency of data models. Ensuring data models defined as per the company standards.
• Analyze data-related system integration challenges and propose appropriate solutions.
• Perform reverse engineering of physical data models from databases and SQL scripts.
• Evaluate data models and physical databases for variances and discrepancies.
• Validate business data objects for accuracy and completeness.
• Experience in Oracle9i/10g/11g, database tools like Toad 12 and SQL Developer.
• Primary responsibility is to work with Business to orchestrate, capture outcomes and process map new Data Governance models.
• Additionally, will work closely with Requirements Analyst, Developers, and Enterprise Data Governance Advocate to ensure data is captured, transformed, and consumed in manner necessary to provide information to the business as required by the proposed solution.
• Accountable for managing the transition of data requirements to the lines.
• Identifying data attributes across multiple applications, document and resolve anomalies and gaps across data sources.
• Working with subject matter / technical experts on a team involved with the development, implementation, administration, and operation of new business and system processes and strategies, which may include multiple functions, product lines, technology platforms, and business activities.
• Responsible for data discovery, analysis, data mapping / profiling. Contributing to Data Modeling and technical solution approach.
• Elicits and delivers Information / data requirements to project stakeholders to create / lead data conversion and data implementation activities.
• Achieves and maintains a solid understanding of the business environment as a whole, including business practices, processes and strategy.
• Facilitates requirements workshops (JAD Sessions) with Subject Matter Experts (SMEs).
• Performs individual aspects of the requirements specification function, including requirements prioritization and functional and non-functional specification development.
• Interfaces with business SMEs & end users to develop Business Process Models (as-is and to-be) and perform Gap Analysis.
• Create Business Requirements and Functional Requirements Specifications (use cases/stories), business rules and identifies user interface requirements.
• Works with project architects, development leads & user interface designers to translate requirements to design.
• Provides traceability of requirements ensuring solution will meet the business need.
• Works with testing team and business SMEs to validate the solution(Acceptance Criteria-GHERKIN); define user acceptance strategies, plans data scenarios.
• Good technical background and prior experience allows me to analyze existing applications (and data elements/quality), document their functionality and help to design improvements.
• As needed generates screen mockups or visualization of requirements using VISO.
• Manages requirements volatility, integrity and continuity via change management and reprioritization.
• Exposure in ETL tool RAP DI, IBM Data Manager, IBM Data Stage.
• Extensive knowledge of Relational Database Management Systems (RDBMS).
• Sound capabilities and solid experience of creating DB Objects, PL/SQL packages, Procedures, Functions, Triggers and scheduled jobs to manipulate and migrate complex data sets in Oracle Databases.
• Experience in Query Optimization, Debugging, Tuning and improvising database performance, using the Explain plans, Bulk collects, SQL Trace and Indexing, Partition etc.
• Involved in query level performance tuning using Explain Plan and SQL Trace and tuned them by redefining query logic, remodeling database structure, creating/modifying indexes, using hints to suggest preferred execution plans etc.
• Well versed in OLTP Data Modeling, ETL and Data warehousing concepts
• Working knowledge of data warehouse techniques and practices, experience including ETL processes, dimensional data modeling (Star Schema, Snow Flake Schema, FACT & Dimension Tables) and OLAP.
• Flexible to work with any Data Warehousing Tool (ETL).
• Domain Experience: Banking, Finance, Health Care and Manufacturing (MES).
• Developed ETL Mappings, ETL functional and Technical documents.
• Strong problem solving/analytical skills and capable of working under pressure and with minimum supervision.
• Experience in Analysing user needs and software requirements to determine feasibility of design within time and cost constraints.
• Requirements gathering from all functional leaders, understanding and consolidating it to make a System Requirement Specification document (SRS).
• Excellent communication/interpersonal skills, quick learner, self-motivated, ability to work individually and as well as in a team environment with good team spirit.
• Ability to work under pressure and manage (Multiple) project tasks with changing priorities and tight deadlines and can work either independently or as a part of a team.

TECHNICAL SKILLS

Data Analyst Skills: Data Collection, Analysis, Data Modeling, Data Mapping, Data Profiling; Data Extraction, Transformation, Loading (ETL); Star and Snowflake Schema; Data Objects Creation (tables, functions, sequence); Stored Procedures and Triggers; Simple and Complex Queries

Databases: Oracle 11g/10g, SQL Server 20008 R2

Data Modeling tools: Oracle Data Modeler, ERwin

Data Warehousing TOOLS: IBM Data Stage, RAP DI, Data Manager

LANGUAGES: SQL, PL/SQL

Development Tools: TOAD, SQL Developer, Putty

Reporting tools: Microsoft SSAS, Flexnet

Requirement tools: RRC, RTC

Bug Tracking Tool: IBM Rational Clear Quest

Domain: Insurance, Banking, Finance, Health Care, Manufacturing

Version Control tools: Subversion (SVN) and ClearCase

Desktop Software: Microsoft Office (Word, PowerPoint, Excel)

Methodologies: Agile, Waterfall, Lean Six Sigma

PROFESSIONAL EXPERIENCE

Confidential, Columbus, OH

Sr Data Modeler & Analyst

Responsibilities:

• Data Analyst defines, drive, and manage enterprise Data Strategy and Roadmap for the organization.
• Responsible and accountable for the design and management of data models for the purpose of staging operational data into the EDW.
• Recommending and designing system architectures to align with organizational strategic business objectives.
• Data Conversion from one or more systems to a centralized system.
• Complex data mapping skills from one source system to another.
• Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
• Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Maintain conceptual, logical and physical data models along with corresponding metadata/Data Dictionary.
• Develop data models according to company standards.
• Responsible for leading data conversion sessions with the stakeholders as needed and performing analysis that include the following: prepare data mapping/load order documents, recommend data cleansing strategies, and develop conversion output in the form of success / failure statistics for further analysis.
• Part of the team that elicited and defined the functional and non-functional requirements.
• Provided data analysis support to the Informatica ETL, Java development, and business teams.
• Actively participated in the Data Management and Analytics team knowledge-sharing, peer review meetings and Three Amigos meetings that included the Informatica ETL and Java teams.
• Developed the requirements documents, Use Cases, and User Stories. Decomposed the requirements into Story Card format.
• Followed the Agile methodology. Attended stand-up meetings, analyzed the requirements, and estimated the effort.
• Evaluated the business requirements, analyzed the existing reporting system, reviewed the current and future state process flows, and performed gap analysis. Identified redundant reports in the existing system.
• Facilitated sessions to identify attributes and entities to develop the database tables and also to build the traceability matrixes. Led meetings to capture high level transformation rules, produce features, define metrics and User Interface Design Document acceptance.
• Helped the Java development and ETL teams in data analysis, data modeling, data profiling, and data mapping. Conducted data analysis of various sources and targets. Got data from different source systems and converted to Confidential standards to maintain data quality rules.
• Utilized Star Schema and ERwin for data modeling.
• Developed SQL scripts for Oracle databases.
• Provided input to the development leads, testers, and project architects.
• Prepared the testing strategy and test plans.
• Developed the Production Handoff and related documents and handled post-deployment related activities, providing 24x7 monitoring and support. Worked closely with the stakeholders to resolve issues; identified and fixed bugs and issues in production.
• Was responsible for determining the requirements methodology as well as the development strategy and approach. Established and monitored the processes for defect management, change management, and quality management.
• Worked closely with the Project Manager to prepare project plans and technical design documents, such as TDD, SRS, and Database Design.

Confidential, Columbus,IN

Sr Data Modeler & Analyst

Responsibilities:

• Data Analyst defines, drive, and manage enterprise Data Strategy and Roadmap for the organization.
• Responsible and accountable for the design and management of data models for the purpose of staging operational data into the EDW.
• Recommending and designing system architectures to align with organizational strategic business objectives.
• Responsible for leading data conversion sessions with the stakeholders as needed and performing analysis that include the following: prepare data mapping/load order documents, recommend data cleansing strategies, and develop conversion output in the form of success / failure statistics for further analysis.
• Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
• Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Maintain conceptual, logical and physical data models along with corresponding metadata/Data Dictionary.
• Develop data models according to company standards.
• Prepared Technical Design Documents like TDD, SRS, and DWH Design.
• Involved in Development & Review of ETL Jobs & Master Packages.
• Coordinated with client managers, business architects and data architects for various sign offs on data models, ETL design docs.
• Involved in data modelling activities for project.
• Data Conversion from one or more systems to a centralized system.
• Complex data mapping skills from one source system to another.
• Involved in creating different data base objects like Tables, Functions, Sequences required for the current Modules like NSPT (Non Serialized Part Tracking), Assembly and Machining.
• Understanding the existing business functionality & prepared the requirement documents.
• Involved in resolving the client issues spontaneously without any delays.
• Preparation of the status reports on daily basis & participated client meetings on regular basis.
• Onsite and Offshore coordination with the team as well as offshore and onsite mangers.
• Project Plan creation and executing the modules as per the timelines, keep on monitoring the specific tasks as per the deadlines.
• Involved in testing & deployment activities.
• Involved in Solution Environment Flexnet 9.6.2 upgrade (From 9.6.1).
• Toolsused RAP DI (ETL Tool), BIDS (Business Intelligence Development Studio), Microsoft SQL Server as a backend.
• Experienced in analyzing business requirements and specifications. Worked with development team and Business Stakeholders to analyze the test scenarios and ensure that test requirements are correct and complete.
• Experienced in creation and execution of test plans, test scripts and test cases using both manual and automated testing techniques.
• Well versed with System testing, Integration testing, Functional testing, Regression testing and User Acceptance Testing.
• Experienced in Manual/Automation Testing of ETL loads, preparation of source test data, and preparation of optimized SQL queries from ETL loads.

Confidential, Detroit

Data Architect (Techno functional)

Responsibilities:

• Data Analyst defines, drive, and manage enterprise Data Strategy and Roadmap for the organization.
• Responsible and accountable for the design and management of data models for the purpose of staging operational data into the EDW.
• Recommending and designing system architectures to align with organizational strategic business objectives.
• Work with the Application Development team to implement data strategies, build data flows and develop conceptual data models.
• Create logical and physical data models using best practices to ensure high data quality and reduced redundancy.
• Maintain conceptual, logical and physical data models along with corresponding metadata/Data Dictionary.
• Develop data models according to company standards.
• Responsible for leading data conversion sessions with the stakeholders as needed and performing analysis that include the following: prepare data mapping/load order documents, recommend data cleansing strategies, and develop conversion output in the form of success / failure statistics for further analysis.
• Prepared Technical Design Documents like LLD, HLD, and FDD.
• Involved in Development & Review of Data stage Parallel Jobs.
• Data Conversion from one or more systems to a centralized system.
• Complex data mapping skills from one source system to another.
• Worked on the development as well as enhancement activities.
• Coordinated with client managers, business architects and data architects for various sign offs on data models, ETL design docs, testing docs, migrations and end user review specs.
• Involved in data modelling activities for ADP Payroll project.
• Involved in creating different data base objects like Tables, Functions, Sequence and Views.
• Involved in creating DB Scripts for all modules.
• Understanding the business functionality & Analysis of business requirements.
• Involved in resolving the client issues spontaneously without any delays.
• Prepared the status reports on daily basis & participated more on client meetings.
• Solution EnvironmentWindows NT & Tools Oracle, IBM Data stage, Unix.
• Experienced in analyzing business requirements and specifications. Worked with development team and Business Stakeholders to analyze the test scenarios and ensure that test requirements are correct and complete.
• Experienced in creation and execution of test plans, test scripts and test cases using both manual and automated testing techniques.
• Well versed with System testing, Integration testing, Functional testing, Regression testing and User Acceptance Testing.
• Experienced in Manual/Automation Testing of ETL loads, preparation of source test data, and preparation of optimized SQL queries from ETL loads.

Confidential

Project Lead

Responsibilities:

• Experienced in analyzing business requirements and specifications. Worked with development team and Business Stakeholders to analyze the test scenarios and ensure that test requirements are correct and complete.
• Experienced in creation and execution of test plans, test scripts and test cases using both manual and automated testing techniques.
• Well versed with System testing, Integration testing, Functional testing, Regression testing and User Acceptance Testing.
• Experienced in Manual/Automation Testing of ETL loads, preparation of source test data, and preparation of optimized SQL queries from ETL loads.
• Involved in creating Different Packages like DLE, DME & DGE.
• Involved in creating different data base objects like Tables, Functions, Sequence and Procedures.
• Involved in creating different Package’s & Trigger’s.
• Understanding the business functionality & Analysis of business requirements.
• Resolving the client issues spontaneously without any delays.
• Keep on updating the current issues with client.
• Preparation of SLA reports.

Confidential

Programmer

Responsibilities:

• Migrated Views From SQL Anyware to Oracle 9i.
• Migrated Stored Procedures and Functions From SQL Anyware to Oracle 9i.
• Migrated Tables From SQL Anyware to Oracle 9i.
• Migrated Triggers From SQL Anyware to Oracle 9i.
• Daily Morning & Evening Backups using import & export command.
• Maintaining All objects in VSS.
• Migrating complex SQL queries from SQL Anyware to Oracle 9i.
• Giving Support for Java Developers.
• Tools TOAD, PL/SQL Developer, SQL Anyware 5.5 VSS (for source code control)
• Experienced in analyzing business requirements and specifications. Worked with development team and Business Stakeholders to analyze the test scenarios and ensure that test requirements are correct and complete.
• Experienced in creation and execution of test plans, test scripts and test cases using both manual and automated testing techniques.
• Well versed with System testing, Integration testing, Functional testing, Regression testing and User Acceptance Testing.
• Experienced in Manual/Automation Testing of ETL loads, preparation of source test data, and preparation of optimized SQL queries from ETL loads.

Confidential

Programmer

Responsibilities:

• Involved in identifying the system requirements, preparing the estimations, developing HLD documents.
• Played key role in system design, construction and Implementation.
• Developed Unit test cases for all the functional flows in the application.
• Provided support during the different phases of application testing.
• Coordinated multiple teams onsite and offshore to accomplish tasks within the time lines.
• Analysed and understood the existing legacy system and map them to the business requirements and implemented them using various technologies.
• Developed PL/SQL procedures to extract required data from DB tables.