SUMMARY

• 9 yrs. of experience in Data Architecture, Server Migration, Data Integration, Data Warehousing using ETL tool SSIS, INFORMATICA PowerCenter 9.1/8.6/8.1/7.1 (Source Analyzer, Warehouse Designer, Mapping/Mapplet Designer, Sessions/tasks, Worklets/Workflow Manager). Working experience of Power Exchange/CDC.
• Worked on Successful SQL server all instances (SSIS, SSAS, SSRS, SQL DB) migration from including Team Foundation Server on Windows Sever 2008.
• Worked on Various reporting tools like SSRS and Tableau.
• 5 Years of SSIS experience in developing packages.
• Worked on complete software development life cycle (SDLC) starting from information strategy planning, requirement analysis, design, development, coding, testing, debugging and rollout to the field user and support for production environment.
• Experience working as Sr. Technical lead, Sr. Developer, Onshore - Offshore coordinator, Developer, Business/Data Analyst, Data Designer during the 8 year career span.
• Capability to work as a ETL Architect
• Worked in Agile and Traditional Waterfall SDLC Methods
• Experience in Data Modeling retaining concepts of RDBMS, Logical and Physical Data Modeling and Multidimensional Data Modeling Schema (Star schema, Snow-Flake Modeling, Facts and dimensions).
• Designed and developed complex mappings to extract data from diverse sources including flat files, RDBMS tables, legacy system files
• Proficient in implementing Complex business rules by creating re-usable transformations, workflows/worklets and Mappings/Mapplets.
• Hands on experience in identifying and resolving performance bottlenecks in various levels like sources, targets, mappings, transformations and sessions.
• Expertise in performance tuning concepts and practices involving large-scale complex databases; experience in SQL optimization techniques.
• Used Explain Plan to analyze the SQL Scripts
• Worked with Informatica Mapping Variables, Mapping Parameters and Parameter Files.
• Developed slowly changing dimension mappings of Type1, Type2 and Type3 (version, flag and time stamp).
• Extensively worked on Code Migration from Development, Systest, UAT, and Production.
• Worked on SSIS, SSAS, SSRS for ETL help on ARGO report and ETL development.
• Worked on reporting tool likes Micro strategy, Business Object and Cognos
• Worked with UNIX Shell Scripts.
• Experience in Relational, Multi-Dimensional and OLAP Technologies leveraging DB systems such as Oracle, SQL Server, MS Access, Netteza, Teradata design and database development/Optimization using SQL, PL/SQL, SQL PLUS, TOAD, SQL Navigator, Nexus.
• Domain experience including Banking, Credit Card, and Pharmaceutical.
• Created/Documented and executed test cases as a part of Regression and Load testing.
• Involved in Production Support of Application.
• Involved in writing DIT Test Cases, Worked with EST team on SIT, Worked with UAT team,
• Worked in retiring Legacy Application and converting them to core application.
• Involved in validating the ETL Mapping during the migration of the environment
• Strong verbal and written communication skills, excellent analytical, problem solving with an ability to express complex technical concepts.
• Excellent team work spirit and capable of learning new technologies and concepts.
• Team Player with ability to work independently and manage/lead ETL Teams.

TECHNICAL SKILLS

ETL Tools: SSIS-Data Tools 2010 and 2012, SSIS-BIDS, Informatica Power Center 9.1/8.6/8.1/7.1.2/7.1 , Power Exchange

OLAP/BI: SSAS, SSRS, Tableau, Hyperion 8, 9, MicroStrategy 8, Business Objects XI, Cognos 8.

Data Modeling: Erwin 4.0, MS Visio

RDBMS: SQL 2012, SQL 2008, Netezza, Teradata, Oracle, Microsoft Access, SQL Server 2005, DB2, MS Excel, Flat Files

Operating Systems: Windows Server 2008 R2, Windows 2008/2003/NT/XP, Unix

SharePoint: Share point, Excel Power view and Power Pivot

Others: Team Foundation Server (TFS-2012, 2010), MS Project, MS Office Suite, TOAD, SQL Navigator, Nexus, Clarity, SharePoint, Remedy, Lotus Notes, Outlook, InfoWeb, Manage Now.

PROFESSIONAL EXPERIENCE

Confidential, Atlanta, GA

Data Warehouse Architect

Responsibilities:

• Worked as a Data Warehouse Architect in Warehouse migration from SQL 2008 to SQL 2012.
• Successful Migration completion from Clustered SQL environment to stand along SQL 2012 on Windows server 2008 R2 .
• Gathered requirements for the Migration project, created technical specs with timeline for each task.
• Migrated SQL, SSIS, SSAS, SSRS and TFS servers from SQL .
• SQL migration with backup and restore of 8 different databases and 5 different servers for each instance.
• For SQL Migration created partitions to separate the index and tables for quicker result set and performance.
• High data load and high traffic table separated in to different partitions for parallel querying and quick return.
• Upgraded and Migrated the SSIS Packages from BIDS to SQL 2012 Data tools.
• Migrated SSRS reports and configured the Reporting Services configuration manger.
• Migrated the SSAS MOLAP cube from the old environment on SQL and updated the Data sources and established new connections.
• Worked on Configuring Kerberos and Windows NTLM authentications for reports and other servers.
• Migrated the Team Foundation server from and created the projects and collection for the Packages and reports for TFS successful migration.
• Worked with Business End Users during new report requirement gathering.
• Environment: SSIS -MS
• Developed new reports in SSRS using parameters, SQL Queries and created various charts and graphs for the report builder reports.
• Worked on Excel power pivot and power view reports that run of the cube.

Environment: SSIS-Visual Studio 2008, SQL 2008, SSRS, SSAS, TFS-2010, Power View, Power Pivot, SAN, Clustered SQL Server, SharePoint, Windows XP, VB scripting., SQL 2012, SSIS-Data Tools, Visual Studio - Data tools 2012.

Confidential, Atlanta, GA

ETL Consultant

Responsibilities:

• Worked on Business related IT needs on ETL using SSIS packages, for Tableau reporting needs with SQL Server as Database and SAP/Salesforce/Clarfiy as sources.
• Worked on Developing new SSIS solutions and packages for new Tabelau Dashboard development Source table.
• Wrote Various Stored procedures in SQL for the managing of multiple Key performance Indicators for RSM and CCSC Dashboard projects.
• Worked on Production maintenance issues such as managing the data flow pipeline to flow the steps only if an excel source file exists.
• Worked on SAP source files for SSIS ETL.
• Worked on SSIS using Slowly Changing Dimensions and merge commands where SCD was considered slow due to the quantity of the data and table structure.
• Performed ETL Unit Testing for new development and existing packages during post development.
• Worked on Agile methodology project for the CCSC dashboard in Tableau.
• Performance Enhancements of the various SSIS packages by removing unnecessary join and column pass-through in the data flow.
• Documented all the production ETL processes and created various solution copies for Production and QA work.
• Created reports in SSRS using datasets from the data warehouse tables.
• Created various Visual Basic scripts for SSIS ETL effective performance as needed.
• Worked with Business Analysts in requirement gathering and providing needed technical support.

Environment: SSIS -MS Visual Studio 2008, SQL Server, Tableau, SSRS, Sharepoint, Windows XP, VB scripting.

Confidential, Palo Alto, CA

ETL Developer

Responsibilities:

• Worked on about 50-70 mappings for ETL using Informatica 9 with Oracle as Database and OBIEE reporting for the Stanford School of Medicine.
• Mappings were designed to Extract, Transform and load the data that helps the office of School of Medicine for storing and Maintaining Employee, space, benchmarking, research, Expenditure, Budget, Salary, Finance and HR information.
• Worked on Exception Handling and data cleaning for the source data along with providing the source data for the OBIEE reporting team.
• Created, Documented and executed various test cases for the Load testing.

Environment: Informatica 9.1, Oracle, SharePoint, Windows XP, UNIX Shell Scripting.

Confidential, Atlanta, GA

ETL Technical Lead

Responsibilities:

• Worked on BIP (Buyer Initiated Payment) System of the B2B (Business 2 Business) interface of Amex.
• Involved in various requirement gathering discussions as a part new ETLdevelopment in up coming projects.
• Involved in Design Specifications and technical Sessions.
• Worked with the team on Data Quality and Data Cleansing to match the requirements.
• Worked on Regression and Load Testing on the new Architecture changes to be deployed in to the existing production environment.
• Created, Documented and executed various test cases for the Load testing.
• Worked on analysis, debugging, fixing code changes and bugs in the existing Informatica mappings.
• Experienced using Informatica integrated with web services
• Worked on SQL DDL and DML queries for the ETL purposes.
• Experience with high volume datasets from various sources like Oracle 10g, Text Files, Relational Tables and xml targets.
• Worked as a part of the new architecture production deployment team in creating various Change Management and Incident Management ticket.
• Deployed mappings from and to various Development environments for testing purposes.
• Worked on ETL Design documents for various new projects in the pipeline.
• Worked with various UNIX scripts and Data Transformation mappings.
• Worked with Onsite/Offshore team structure.

Environment: Informatica Power Center 9.1, SQL Server, Oracle 10g, Oracle 11g, Shell Scripting, UNIX, Windows XP, MicroStrategy 9.

Confidential, Austin, TX

BI Specialist II/BI Consultant

Responsibilities:

• Currently working on the ETL for Data Obfuscation to obfuscate sensitive data in development and test environments.
• Worked on SSIS packages for Argo mappings to load tables in SQL and run aadhoc basis when needed.
• Used sources as Excel files, flat files and tables in SSIS packages.
• Used SSIS Script tasks for Archival, rename and delete functions with file sources and targets.
• Used SSIS packages to trigger sql stored procedures
• ETL Developer on the Loss share project to map the BBVA loan systems data (post converted Guaranty system data) to the ALIAS loan database to provide ETL and reporting for FDIC.
• Informatica development on various projects like Portfolio, CD maturity and Historical Database.
• Primary BI Specialist in regards to ETL processes used to load the Guaranty Bank Data Warehouse and key resource in data analysis of Customer Profitability and General Ledger Data.
• Perform analysis, documentation, design, development and testing of numerous enhancements.
• Involved as a Lead Developer and Analyst in the entire lifecycle development and architecture changes to the Data warehouse for the Consumer Checking Onboarding project.
• Worked closely with the business user groups and IT staff during the Consumer Onboarding projects to make sure all the requirements and deadlines are met.
• Converted the data warehouse data models from ERwin to MS Visio, which involved a complete, rebuild of the models.
• Experienced in Data quality and data cleaning for ETL purposes.
• Worked on cleansing and profiling of General Ledger data for the Data warehouse.
• Served as mentor and reviewer to junior Specialists in all areas of data warehousing and ETL.
• Regular interfaces and meetings with business users, DBAs, server administrators and other IT staff to effectively support the data warehouse and business intelligence environments.
• Author necessary documentation for enhancements and projects assigned, monitor daily loads, follows up on issues to resolution, provide management accurate estimates, and always keep management informed of status and any existing issues.
• Developed various reports using Hyperion 8 and 9, including scheduling, monitoring Hyperion Jobs.

Environment:, Informatica Power Center 9.1/8.6, Teradata Database, Power exchange 9, Oracle 11g, SQL Server 2008, Hyperion 8/9, Shell Scripting, UNIX, Windows XP, TOAD9.0, ErWIN, MS Access, MS Visio.

Confidential, Durham, NC

Data Analyst/ETL Developer

Responsibilities:

• Study the existing system, which holds the compound, formulation and other protocol data.
• To identify the Business requirements to develop the Logical model of BCL2.
• Worked on the Use cases drafting and review.
• To interact with the Business users to find the requirements needed to improve the existing system.
• Worked on System requirement drafting, work order creation and Cost estimation for the project.
• Develop the entities and attributes as per the requirements provided by the business.
• To identify the relations between the entities and other external system interfaces.
• To draft the business and other data validation rules for the data model.
• To create the CRUD matrix which holds the create/read/update/delete privileges at entity level for the entire model including the other systems, which hold the primary data of the BCL.
• Develop a external system interface document to identify the mappings to the other systems with BCL.
• To create a complete high-level design this includes the external systems along with all the BCL2 entities.
• All documents delivered are as per the GSK IQMS standards.

Environment: Informatica 6, ERWIN, Oracle 8i, DB2, MS Access, Win XP, MS Excel, Business Objects 6

Confidential

ETL Developer/Analyst

Responsibilities:

• Created Repository, Folders, and User accounts using Power Centre Repository Manager.
• Involved in Designing and creating mappings using Power Center Designer.
• Created user objects including Dimensions, Details and Measures.
• Worked extensively on Source Analyzer, Mapping Designer, and Warehouse Designer.
• Developed several Mappings and Mapplets using corresponding Source, Targets and Transformations.
• Analyzing the source data and deciding on appropriate extraction, transformation and loading strategy
• Used all Transformations such as Expression, Filter, Joiner, aggregator, Lookup and Router, to load data.
• Used Work flow Manager connections
• Developed the documentation on the Data Warehouse ETL process.
• Worked with Workflow Designer in executing tasks.
• Setting up batches and sessions to schedule the loads at the required frequency and testing the data in the targets.
• Monitored the status of the workflow time to time using Workflow Monitor.

Environment: Informatica Power Center 5, Oracle 7i, MS-SQL Server 2000, Windows NT/2000