SUMMARY

• Over 9+ Years of IT experience as Developer, Senior Data Analyst, Business Analyst and UAT Analyst in various domains like Health care, Insurance, Telecommunication, Consumer Banking and Retail. Proven ability in working with enterprise level large Data Warehouses, RDBMS systems, ETL and modeling tools/techniques.
• Strong Data Warehousing ETL experience of using Informatica PowerCenter Client tools - Mapping Designer, Repository manager, Workflow Manager/Monitor.
• Strong experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor
• Expert in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server
• Experienced in extraction & migration of data from heterogeneous data sources like Excel, MS Access, Sybase, SAS, DB2 to MS SQL Server by using import/export Wizard, DTS/SSIS and Bulk Insert utilities.
• Implemented SSIS transformations like Lookup transformation, Derive Column, Conditional Split, Merge Join and Row Count.
• Strong knowledge and understanding of Data warehousing concepts: Star Schema, Snowflake Schema, Fact and Dimension Tables. Good knowledge of Dimensional Modeling and Normalization approaches.
• Proficiency, including architecture, with different RDBMS platforms like Oracle, Teradata and SQL Server.
• Strong knowledge of Software Development Life Cycle (SDLC) including Waterfall and Agile models.
• Expertise handling all the domain and technical interaction with application users / stakeholders, analyzing client business processes, and documenting business requirements (BRD). Extensive experience of building stakeholder relationships, managing communications plans, tracking, assessing, and reporting on the analysis process.
• Facilitated collection of Functional Requirements from system users, and prepared Business and Functional Requirement Specification documents.
• Experienced in conducting JAD sessions - participating in varied roles ranging from facilitator, preparing visual aids, setting goals and objectives, providing read-ahead materials and time-boxed agenda to participants.
• Experience working with multiple/cross-functional groups, conducting brainstorming/root cause analysis sessions.

TECHNICAL SKILLS

Analysis/Modeling Tools: UML, JAD, RUP, Waterfall, Agile

Defect Tracking and Testing Tools: Quality Center, JIRA, HP ALM, Service Now

Operating Systems/Platforms: Windows 7/XP/2000/2003/NT, RHEL 5x/6x

Office Applications and other tools: MS Office Suite, Visio, SharePoint, MS Project

Databases: Teradata 13, MS SQL Server 2008 R2, Oracle 11g

DB Tools: SQL Plus, SQL Developer, Teradata SQL Assistant, Toad for Oracle and DB2, SSMS, CA Erwin DM, SSIS, SSMS, Informatica

Programming languages: C, C++, Java, SQL, T-SQL, PL/SQL, SAS

PROFESSIONAL EXPERIENCE

Confidential

ETL Developer

Technologies: Informatica, MS SQL Server 2008, MS Access 2000, T-SQL, SSMS, Oracle 10g

Responsibilities:

• Conduct full client lifecycle activities to include requirements analysis and design; develop analysis and reporting capabilities; and continuous performance monitoring.
• Worked on Informatica Power Center tools- Designer, Repository Manager, Workflow Manager, and Workflow Monitor.
• Parsed high-level design specification to simple ETL coding and mapping standards.
• Designed and customized data models for Data warehouse supporting data from multiple sources on real time
• Involved in building the ETL architecture and Source to Target mapping to load data into Data warehouse.
• Created mapping documents to outline data flow from sources to targets.
• Involved in Dimensional modeling (Star Schema) of the Data warehouse and used Erwin to design the business process, dimensions and measured facts.
• Developed mapping parameters and variables to support SQL override.
• Created mapplets to use them in different mappings.
• Developed mappings to load into staging tables and then to Dimensions and Facts.
• Created sessions, configured workflows to extract data from various sources, transformed data, and loading into data warehouse.
• Used Type 1 SCD and Type 2 SCD mappings to update slowly Changing Dimension Tables.
• Modified existing mappings for enhancements of new business requirements.
• Used Debugger to test the mappings and fixed the bugs.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Prepared migration document to move the mappings from development to testing and then to production repositories.
• Queried against Heterogeneous Data Sources like SQL Server, Oracle, to retrieve records for data loads using SSIS 2008R2.
• Used different Control Flow Tasks and Data flow Task for Creating SSIS Packages. Used different types of Transformations for Data Conversion, Sorting and cleaning the data from different Sources into Company Format.
• Expertise in Using different Transformations like Lookups, Derived Column, Merge Join, For Loop, For Each Loop, Conditional Split, Union all, Script component etc.
• Review process design and stored procedures. Ensure compliance to standards.
• Articulate and educate technical and architectural concepts to a variety of audiences, including developers, data modelers and business users.
• Writing, tuning and reviewing PL/SQL stored procedures, triggers and functions.

Confidential

Lead Data Analyst/SQL Developer

Responsibilities:

• Support and maintain the Federal Employee Program - Care Coordination Technology Infrastructure.
• Involvement in SDLC which includes gathering of business requirements, architecture, design document, planning, development, deployment and maintenance of Care Coordination Technology Infrastructure.
• Gathering and analyzing the business and technical requirements. Create Functional Specification Document
• Attend program design, coding and test walk-through meetings to provide input regarding adherence to technical standards and customer requirements.
• Conducting Functional Requirement Specification Artifacts meetings with the Project Teams and analyzing the risks involved.
• Responsible for data mapping, metadata maintenance and enhancing existing Logical and Physical data models.
• Conducted sessions with architects, business SME and development teams to understand the Change Requests (CR’s), and effects caused on the system by the change requests.
• Determined data rules and conducted Logical and Physical design reviews with business analysts, development team and DBAs.
• Maintained and updated Metadata repository based on the change requests
• Analyzed existing Logical and Physical data models and altered them using Erwin to support enhancements.
• Worked with the ETL team to document the transformation rules for data migration from OLTP to Warehouse environment for reporting purposes.
• SQL performance tuning.
• Designed physical and logical database structures/diagrams.
• Used SQL Profiler to estimate the Slow Running queries and performance tuning purpose.
• Wrote different complex SQL queries including inner, outer join and update queries.
• Developed source to target mapping documents to support ETL design.
• Created tables, views, sequences, indexes, constraints and generated SQL scripts for physical implementation.
• Reverse Engineered databases schema into ERwin Physical Data Model for reusability and then forward engineered them to Teradata using Erwin.