SUMMARY:

• Over 11+ 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 created database objects, PL/SQL packages, procedures, functions, triggers and scheduled jobs to manipulate 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 in project life cycle including Requirement gathering and Analysis, Database design, Database development, Application development, Test, Implementation & Support.
• Experience in Oracle9i/10g/11g, database tools like Toad 12 and SQL Developer.
• Good Hands on experience in PL/SQL.
• 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.
• Good experience on interfaces, Data Migration, Data Analysis and Data Conversion.
• Experience in Query Optimization, Debugging, Tuning and improvising database performance, using the Explain plans, Bulk collects, SQL Trace and Indexing, Partition etc.
• Migrated data from csv files to Oracle database using SQL Loader.
• 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 Analyzing 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, SAP Power Designer

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

Responsibilities:

• Data Analyst defines, drive, and manage enterprise Data Strategy and Roadmap for the organization.
• Conducting requirement gathering meetings with the stakeholders.
• Defining the data flow diagrams using Microsoft Visio Professional.
• Involved in sprint planning for all the phases.
• Creating the project plan based on the project scope.
• Involved in setting up the STE environment (Dev/UAT/PROD) for the application with respect to the technology stack.
• Coordinating with the respective Confidential internal supporting teams to establish the application needs & make them available in all environments for developers, testers and business users/clients.
• Creating the sprint tasks in JIRA according to the timeline & assigning them to the appropriate resources.
• Scheduling the sprint meetings on daily basis and monitoring all the sprint tasks on timely basis.
• Defining the Fund Accounting data traceability matrix by each entity & spectra code wise.
• Complex data mapping skills from one source system to another.
• 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.
• Followed the Agile methodology. Attended stand-up meetings, analyzed the requirements, and estimated the effort.
• 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. Utilized Star Schema and SAP Power Designer for data modeling.
• Developed SQL scripts for Oracle databases.
• 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.

Environment: SQL Server (Data Base), Oracle 11g, Xceptor, SVN, REVPORT Billing Application. SAP Power Designer 16.0, Velocity Reporting, and Talend ETL tool.

Confidential

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.
• Provided data analysis support to the Informatica ETL, 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.
• 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. 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.

Environment: CA Erwin r9.5, SQL Server (Data Base), Share point, IBM Mainframe, SVN, MS Visio

Confidential, Columbus, OH

Sr Data Analyst

Responsibilities:

• 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 Nationwide 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

Project Lead

Responsibilities:

• 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.
• 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).
• Tools used RAP DI (ETL Tool), BIDS (Business Intelligence Development Studio), Microsoft SQL Server as a backend.

Confidential, Detroit

Project Manager

Responsibilities:

• Involved in Development & Review of Data stage Parallel Jobs.
• 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 Environment Windows NT & Tools Oracle, IBM Data stage, Unix

Confidential

Project Lead

Responsibilities:

• 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)

Confidential

Programmer

Responsibilities:

• Involved in identifying the system requirements, preparing the estimations, developing Confidential 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.