SUMMARY OF QUALIFICATIONS

• Over 6 years of IT experience in all phases of Software Development Life Cycle SDLC of Data warehousing, including requirement gathering from business users, data architecture, analysis, design, creation of mapping documents, specification writing, development, testing, and implementation
• Well-versed in SQL, T-SQL and PL- SQL concepts.
• Profound knowledge and ability to write Stored Procedures, Temporary tables, Views, Indexes, Triggers when required and complex Queries including Correlated queries and queries with Complex Joins and Aggregate Functions.
• Work experience in Data Warehouse projects, worked on Informatica Power Center tools-Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Experience in dealing with different data sources ranging from Flat files, SQL server, Oracle, MS Access and Excel
• Experience in creating SSIS packages and developing SSRS reports.
• Experience in resolving on-going maintenance issues and bug fixes monitoring Informatica sessions as well as performance tuning of mappings and sessions
• Experience in report writing using SQL Server Reporting Services and creating various types of reports like Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Excellent in High Level Design of DTS and SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like Excel, CSV, Oracle, flat file, Text Format Data by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and union all.
• Experience in writing expressions in SSRS and Expert in fine-tuning the reports. Created Drill through and Drill Down reports using SSRS.
• Proven proficiency at Requirements elicitation, Management Specification utilizing BA best practices.
• Adept at conducting JAD sessions supplemented by proto-typing and at delivering detailed user walkthroughs.
• Skilled in preparing Business Requirements Document BRD , Functional and Technical Specifications and Systems design.
• Well versed with Software Development Life Cycle SDLC methodologies and models like Waterfall, RUP and Agile.
• Expert in developing Data models, Data Flow Diagrams, Current and future state diagrams using MS Visio.
• Good communication and facilitation skills coupled with strong teaming, leadership and decision-making abilities.
• Application testing experience with working knowledge of testing tools like Rational Quality Manager RQM
• Work experience with Insurance and Healthcare industry
• Organized, goal-oriented, self-starter and ability to master new technologies, manage multiple tasks while following through from start to completion with limited supervision

PROFESSIONAL EXPERIENCE

Confidential

Business/ Data Analyst

• Efficiently liaised with business stakeholders and Technical Support Groups for the elicitation, analysis and specification of business, functional non-functional requirements for ETL projects.
• Worked closely with Actuaries to understand the operational and reporting requirements for enhancement of Hedging Application and discuss existing application issues.
• Developed Process flow diagrams, Current State and future State Process diagrams
• Organized JAD sessions and Requirements workshops with the Business and technology SMRs from multiple groups to facilitate efficient elicitation of requirements and timely, mutually agreeable resolution of conflicting requirements.
• Involved in planning the tasks and prioritizing the requirements.
• Created Tablix, Tabular, Multi Parameterized and data driven reports using SSRS
• Facilitate Calls with the Cross Functional Teams to drive performance improvements.
• Ensure alignment of project deliverables as per the defined scope.
• Used MS SQL Server Management Studio for data analysis and validation, Expert in creating SQL and T-SQL scripts.
• Prepared Test plans and test conditions in RQM and conducted system testing and Integration testing.
• Experience in using Automation Scheduling tools like Control-M.
• Assisted Lead Business Analyst and Project Manager in creating Work Breakdown Structure, planning milestones/Key performance indicators and deliverable.

Confidential

SQL / ETL Developer

• Develop and maintain complex ETL processes using SQL Server Integration Services
• Perform data imports, data transformation, and report queries in SQL Server 2008 database
• Perform Quality and Business logic checks on all data into and out of systems
• Create stored procedures, views, and functions
• Analyze data for integrity and validity
• Using SQL to query Databases performing various validations and mapping activities
• Worked in different phases of SDLC Analyze business and functional requirements and prepare technical design, support code development and complete unit test planning
• Create SSIS packages to pull data from SQL Server and export to Excel Spreadsheets and vice versa.
• Extensively used SSIS Import/Export Wizard for performing the ETL operations.
• Created SQL Server Reports using SSRS and exported them to Excel format for managers and QA team for easy validation
• Involved in Performance tuning and Query Optimization.
• Participated in business meetings, Reported and co-coordinated with all stakeholders.
• Involved in extensive Data validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Troubleshooted performance issues and bugs within packages
• Identified and evaluated technology risks, helped team with work estimates.
• Assisted on Release and regression testing activities.

Confidential

Informatica/ ETL Developer

• Experienced in working on data-intensive projects involving analysis, consolidation, massaging of data obtained from multiple and disparate data sources and outlining processing/business rules for the presentation of derived information.
• Expert in writing complex SQL queries for Data Analysis, Data Validation and Data reconciliation.
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Worked with Excel Pivot tables and V lookup functions.
• Experienced using Informatica-Power Center to developed ETL mappings, transformations.
• Created mappings and maplets to transform the data according to the business rules.
• Used various transformations like Source Qualifier, Joiner, Lookup, Sql, Router, Filter, Expression and Update Strategy.
• Developed Mapping Extracts to support technical specification documents
• Worked on PL/SQL procedures/functions to build business rules to load data.
• Experience in resolving on-going maintenance issues and bug fixes monitoring Informatica sessions as well as performance tuning of mappings and sessions.
• Served as internal consultant with technology and business groups
• Supported multiple implementations in parallel.
• Supported System Test Planning, Developed the test plan, test scenarios and test cases
• Communicated and coordinated effort with offshore and onshore Technical and QA team, Maintained activity and Query Log for team
• Clearly outlined activity diagrams to provide an end-to-end visibility of system functionality and computational processes.

SKILLSET

Methodologies/Standards: Waterfall, Iterative/RUP, Agile

Tools: MS Office Suite, MS Visio, MS Outlook, MS Excel, MS SQL Server Management Studio, SQL Developer, MS SQL Server Integration Services SSIS , MS SQL Server Reporting Services SSRS , ReqPro, RQM, Control M, DI Analyst, Informatica- Power Center

Databases: MS Access, MS SQL Server 2008/2012, Oracle 9i/11g