Summary:

• Over 7 years of experience as a Data Analyst / ETL/ BA, with Progressive responsibilities in data analysis with focus on financial reporting, and Data warehouse DW , business intelligence BI .
• Accomplished Senior IT professional with a background in business intelligence, reporting systems, data quality including ETL , and full life-cycle development.
• Hands on experience on complete Software Development Life Cycle SDLC for the projects using methodologies like Agile, RUP, Waterfall, and hybrid methods.
• Extensive experience on interaction with system users in gathering business requirements and involved in developing projects.
• Designed and developed database models for the operational data store, data warehouse, and federated databases to support client enterprise Information Management Strategy.
• Chaired and conducted JAD sessions with business and technical teams.
• Vast experience of working in the area of data management including data analysis, gap analysis and data mapping.
• Worked extensively with Erwin, Visio and ER Studio for Dimensional Modeling and Data Migration projects.
• Adept at writing Data Mapping Documents, Data Transformation Rules and maintaining Data Dictionary.
• Created and executed Test Plan, Test Scripts, and Test Cases based on Design document and User Requirement document for testing purposes using HP Quality center.
• Extensive experience in User Acceptance Testing UAT , functional testing, system testing, and defect tracking using various tools.
• Coordinated and prioritized outstanding defects and system requests based on business requirements.
• Acted as a liaison between the development team and the management team to resolve any conflicts in terms of requirements.
• Experience with SQL, PL/SQL, and Performance Tuning.
• Expert in TSQL, creating and using Stored Procedures, Views, User Defined Functions, implementing Business Intelligence solutions using SQL Server 2000/2005/2008.
• Excellent experienced in data Extraction, Transformation and Loading ETL using various tools such as SQL Server Integration Services SSIS , DTS, Bulk Insert and Bulk Copy Program utility, SQL Replication and Log Shipping.
• Worked extensively in Query Optimization and Performance Tuning using tools SQL Profiler, Index Tuning Wizard and database Engine Tuning Advisor.
• Interacted with all levels of the project development team, from end users to Software Architects, Technical Lead, Database Administrators, and System Administrators.
• Capable of managing project while leading cross-functional teams to meet and exceed overall IT initiatives.
• Excellent technical, time management, communication, interpersonal and presentation skills.

Skill Sets:

UML, IBM Rational Requisite Pro, SDLC, RUP, Waterfall, Agile, Scrum, MS SQL Server 2000/2005/2008, MS Access. Oracle, SQL, TSQL, PL/SQL, SSIS, SSAS, SSRS, Microsoft Visio, Microsoft Project, MS Office, Interpersonal and Managerial skills.

Professional Experience:

Confidential

Data Analyst/ETL /BA

Responsibilities:

• Conducted brainstorming and JAD sessions with stakeholders and end-users for requirement analysis and documented the same.
• Created EDI documents for EDI maps to generate requirement documents, and logical design documents for EDI transactions and code sets.
• Developed database objects like Tables, Triggers, and Indexes using T-SQL Management Studio.
• Designed SSIS Packages to transfer data between servers, load data into database on SQL Server 2005 environment and deploy the data.
• Created packages using SSIS from heterogeneous sources like Access Database, Flat Files, Excel and CSV, SQL Server database sources handling Outbound Member Files, Inbound Claims File and Inbound Provider Files.
• Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping and Metadata.
• Implemented various tasks and transformations for data cleansing like Script Task, ExecuteSQLTask, ExecutePackageTask and Data Flow Task.
• Experience in calling a Web Service, through SSIS Package through the transformation, and wherein you declare a variable with its URL link
• Created Master child packages as an ETL strategy to populate dimensions and facts
• Configured SSIS packages to incorporate slowly changing dimensions for tracking historical data
• Expert in TSQL, creating and using Stored Procedures, Views, User Defined Functions, implementing Business Intelligence solutions using SQL Server.
• Created Data profiling stored procedures using dynamic SQL as well as generating complex scripts to schedule various maintenance tasks
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Followed 2NF/3NF standards to create database for OLTP databases.
• Responsible for transforming data from OLTP to OLAP data sources using SSIS.
• Used UML during requirements gathering and created Use Case Models and Use Case Diagrams for the purpose of stakeholders in the project to help them understand the workflow of the system associated with the requirements.
• Worked on HIPAA ANSI X-12 EDI series such as 270/271, 276/277, 278, 834, 835, 837 and version 5010 of this transaction.
• Developed, implemented and executed test methodologies and plans to ensure software product quality as per the RATIONAL UNIFIED PROCESS RUP methodology. Test some of the Extensions in Facets application manually.
• Analyzed, coordinated, documented and managed project processes and procedures and its changes throughout the software development lifecycle.
• Involved in creating sample mappings for the conversion of EDI X12 transactions code sets version 4010 to 5010 and translation of ICD 9 codes into ICD 10 codes.
• Performed Requirements Analysis and traceability using Test Director and MS Word.
• Involved in writing test plans, defining test cases, test scenarios and data sets analyzed bugs and interacted with development team in fixing the errors.
• Worked with Subject Matter Experts SME , project team members business and technical , to define technology application for the business and system requirements. Also worked with the QA Team Lead to develop QA standards and ensured compliance with all regulatory requirements.
• Created Gantt charts and project charters, and followed the Software Development Life Cycle SDLC methodology to complete projects on time and within budget.
• Used SQLs to test various reports and ETL load jobs in development, QA and production.

Environment: MS SQL Server 2005/2008, MS SQL Integration Services SSIS , Access Database, MS Excel, Window XP, MS Word , Visual Studio 2008/2005, Agile, MS Project, Microsoft Power Point, Rational Clear Quest, Rational ClearCase, Rational requisite pro.

Confidential

Data Analyst/ETL/BA

Hardware/Software:

MS SQL Server 2008/2005, MS SQL Integration Services, Microsoft Visio, Report Builder, MS SQL Reporting Services, MS Excel, MS Word , Visual Studio 2008/2005

Responsibilities:

• Helped conduct meetings with the end users and performed interviews to gather the requirements from them and to convert those requirements into Requirements document for the development and testing teams.
• Analyzed the business requirements to get a thorough understanding of the testing requirements and developed test plans and created test cases in Rational Test Manager for extensive coverage of the requirements during testing.
• Worked with the developers to understand the ERD Entity Relationship Diagram and thus create comprehensive test plans, following the RUP model, for the applications and also gather test data for the data driven test cases.
• Worked extensively on BI SSIS Packages for extracting the data of the customers from OLTP, transform that data and load it into the OLAP.
• Extensively involved in using BI tools like Import and Export Wizard for developing the packages.
• Provided the sequence and flow diagrams for various modules in the project using Rational Rose.
• Investigated, documented and monitored the defects in Rational Clear Quest.
• Participated in weekly review meetings to report the documented test metrics and defects found in the System. Closed bug reports once they are resolved and verified.
• Involved in Training and Documentation.
• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Gather requirements and design of data warehouse and data mart entities.
• Used SQL to perform data analysis and generating reports for management discussion
• Managed Traceability matrix to trace Business Requirements, Functional Requirements, and Use Cases.
• Identified opportunities for business process improvement and initiated efforts to make improvements.
• Assisted in designing test plans, test scenarios and test cases for integration, regression and user acceptance testing.

Environment: Rational Suite, ASP, VB, HTML, C , SQL Server, and Windows

Confidential

Data Analyst / Business Analyst

Responsibilities:

• Designed the business requirement collection approach based on the project scope and SDLC methodology.
• Conducted controlled brainstorming sessions with project focus groups.
• Documented business requirements with wireframes and mockups to explain in detail the business implications and impacts.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams, Dataflow Diagrams in MS Visio.
• Prepared functional requirements to define the system rules by creating Use Cases, Interface design and data dictionaries.
• Analyzed various resource files being used to generate the report and documented data mapping and data source interface documents to assist the development team.
• Worked with the Business Objects developers to provide input for generating automated and adhoc Business reports.
• Used SQL for querying and analysis purposes on various source tables and conditions applied and Wrote SQL joins, sub queries.
• Used SQL Server Reporting Services SSRS to schedule reports to be generated on predetermined time.
• Built up and maintain a strong data warehousing system for the organization
• Helped the testing team in creating the test plans and test scripts. Assisted the users in UAT testing by providing test scenarios and test data.
• Assigned problems to appropriate software development team for fixes.
• Authored progress and completion reports, which were then submitted to project management on a weekly basis.
• Stored and modified requirements in MS - Word.

Environment: Oracle 11g, Oracle SQL Developer, Adobe Flex, MS Word, MS Excel, MS PowerPoint, MS Access, MS Projects, MS Visio, Adobe Flash, MS SharePoint.

Confidential

Business/Systems Analyst

Responsibilities:

• Extracted the Business Requirements from the end users keeping in mind their need for the application and prepared Business Requirement Documents BRD using Rational RequisitePro.
• Reviewed Design Documents, Requirements Analysis Specifications with Project Lead, Business Owners and the Technical Lead
• Participated in JAD sessions to resolve critical issues
• Created the business process model using MS Visio for better understanding of the system and presented it to Project Manager and other team members for validation.
• Created and managed Project Templates, Use Case Project Templates, Requirement Types and Traceability Relationships in RequisitePro.
• Participated in requirements meetings, writing requirements in CaliberRM, converting requirements from Caliber RM to HP Quality Center
• Involved in creating automated Test Scripts representing various Transactions, Documenting the Load Testing Process and Methodology. Created meaningful reports for analysis and integrated the Performance Testing in the SDLC.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing data. Various versions of the documents generated during the project were maintained and managed using Rational ClearCase and performed defect tracking using Rational ClearQuest.
• Tested the final application for Usability testing to verify whether all the User Requirements were catered to by the application.

Environment: Rational Clear Case, Doors, IBM WebSphere, XML, HP Quality Center, Java, RUP, MS Visio, SQL Server Reports, WinRunner, LoadRunner, Quick TestPro

Confidential

Business Analyst

Hardware/Software:

MS SQL Server 2000, T-SQL, MS Excel, MS Access 2000, Erwin, Windows NT.

Responsibilities:

• Gathered user requirements.
• Identified high-level requirements for developing and documenting detailed business requirements
• Involved in meetings with SME subject matter experts and users for requirements gathering.
• Revised and updated the technical feasibility documents and created sequence diagrams.
• Utilized RUP Rational Unified Process to create use cases, activity, class diagrams and workflow process diagrams.
• Extensive development providing data integrated solutions using VB 5.0.
• Responsible for providing database solutions using MS Access/ SQL Server/ Oracle database.
• Proficient use of T-SQL/ PL/SQL in creating tables, views, triggers, stored procedures.
• Created reports using Crystal Reports and Oracle Forms/Report.
• Provided technical/Functional support to end user.

Environment: MS SQL Server 6.5/7.0/2000, Oracle 8.0/9.0, Visual Basic 5.0, TSQL, PLSQL, Windows NT /2000