SUMMARY:

• Over 6 years of professional IT experience in Architecture, Data Analysis, Systems Design, Integration and Implementation of complex Client/Server, web based applications and data warehouses with strong domain knowledge of Health Care, Supply chain, Financial (Bank and Insurance), Retail.
• Five(5+) years of excellent Data warehousing experience using Informatica 9.x/8.x/7.1/6.x (Power Center /Power Mart),SSIS 2008, SSAS 2008, SSRS 2008, Oracle 10g/9i/8i/7.3, SQL Server 2008/2005/2000 , Oracle utilities & tools (SQL Plus, PL/SQL, TOAD), Data mart/s, etc in Unix and Windows environment/s handling multi - terabyte data warehouses.
• Architect and Build Near Real Time Data Warehouses for Mid Size to Large Organizations. Successful implementation of both Corporate Information Factory (CIF) and BUS Architecture methodologies of Data Warehouse designs.
• Hands on experience in implementing all 3 forms of SCD (Slowly Changing Dimensions) as per the client requirement
• Experience with three complete life cycles on, Active data warehousing projects using Informatica Power Center 8.x/7.x/6.x (Informatica Scheduler, Informatica Data Explorer)and Oracle 10g/9i/8i/7.3, SQL Server 2008/2005/2000 ,NCR Teradata RDBMS V2R6.x/V2R5.x.
• Expertise in working with Informatica 6.x/7.x/8.x and tools like Informatica Server, Repository Manager, Designer, Workflow Manger and Workflow monitor and experience working with Informatica Data Quality, Explorer and Scheduler
• Expertise in working with Teradata V2R5 and V2R6 (with TTU 8.1) systems and used utilities like Multi-Load, Fast-Load, Fast-Export, BTEQ, TPUMP, SQL Assistant, TDQM, PMON and Priority Scheduler.
• Experience in all phases of Data Modeling - Conceptual, Logical and Physical modeling.
• Expertise in Data Modeling using tools likes Erwin, ER/Studio and MS Visio along with the hands on experience in using Forward Engineering and Reverse Engineering functionality.
• Strong experience in implementing Data warehousing solutions involving Dimension modeling and Snow flake schema implementation (3 NF)
• Experience in working with various RDBMS like Teradata, DB2UDB, Oracle, SQL server and MS-Access
• Extensive experience in writing oracle SQL and PL-SQL procedures, functions, triggers and packages
• Experience in Business Objects 3.x/5.x, BO Designer, BO Developer Suite (Broadcast Agent, Supervisor, Designer, Info View), Universe Developer, Supervisor, BO Data Integrator (Data Integrator Job Server and the Data Integrator Designer)
• Experience in Business objects 6.1 and Hyperion Essbase 6.1 (Building Multi dimensional data base, loading scripts with rule implementation, calculations scripts)

TECHNICAL SKILLS:

ETL Tools: Informatica PowerCenter 5.x/6.x/ 7.1/8.1/9.1/9.5.1/9.6 , Informatica Data QualityMS SSIS 2008/2005

BI Tools: SQL Server 2005/2008, Business Objects 5.1/6.x/XI (Web IntelligenceBroadcast Agent, Supervisor, Designer)

Programming Languages: Visual Basic 5.0/6.0, Visual C++ 5.0, ASP 3.0, Oracle PL/SQL, SQL Plus, T-SQLSQL Server DTS, DB2 SQL, Teradata-SQL, Korn Shell Scripts

Development Tools: Microsoft Visual Studio IDE

RDBMS: Oracle 7.x/8i/9i/10g, MS SQL Server 6.5/2000 e/e, Teradata V2R5/V2R6, DB2 8.1, MYSQL

Database Tools: TOAD 8.6, Quest Central for DB2, QMF for DB2, SQL Server Query Analyzer.

Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimension Tables, Physical and Logical Data ModelingErwin 7.0/4.1/5.1

Software Configuration Management (SCM) & Migration Tools: Microsoft Visual SourceSafe 5.0/6.0, Rational Clear case 6.1, Informatica Version Control

Testing Tools: Mercury Test Director 6.0, Mercury Quality Center

Other Tools: Informatica B2B, Informatica DVO, Microsoft Office 2000/2003, Teradata MultiLoad and FastLoad, FileNET, Panagon IDM Desktop 3.1, Control-M 6.1CVS

Operating Systems: Microsoft Windows NT/2000/2003, IBM AIX 4.3/5.2, IBM z/OS.

PROFESSIONAL EXPERIENCE:

Confidential

Operational Technical Engineer

Responsibilities:

• Analyze and understand Confidential systems and applications in order to diagnose and resolve problems that occur with them.
• Interact with Business users, Technology staff and Vendor partners to support and troubleshoot Confidential operations.
• Assist in the development and maintenance of the procedures to manage and ensure successful operations of Confidential systems.
• Support development efforts related to vendor data flows and operational data quality. Work with the business process owners, vendors, and Technology staff to ensure that data requirements are well understood and documented.
• Write SQL scripts to pull data special data requests and to do the data load activities
• Develop, enhance, and maintain process and issue documentation.
• Maintain open communications with business process owners keeping them aware of operational situations that may impact their respective areas.
• Perform proactive problem management and incident trending to eliminate future incidents.
• Assist in the development of tools to support operational processes.

Environment: Informatica power center 9.6.1, TOAD 11.6, SQL Server 2008, Oracle 10g, Windows XP Client and UNIX Server, SVN.

Confidential

Senior Software Engineer

Responsibilities:

• Design and develop ETL mappings and workflows using Informatica PowerCenter 9.x
• Used Informatica B2B Data exchange to deliver files securely to client and scheduling and monitoring jobs from time to time
• Develop technical specifications for data loading rules
• Implemented Kimball methodologies in implementing Data Warehouse
• Designed the ETL Specifications Document (Source to Target mapping document) based on the requirements from Business Users.
• Worked on analyzing the data coming from different source systems like Mainframes, Informix, SQL Server, Oracle, XML files and Flat files (Fixed width and Delimited).
• Designed the Data Model and created several Fact & Dimensions based on the reporting needs for the projects.
• Created several stored procedures and packages using Oracle10g and Sql server 2008
• Used Pushdown Optimization to push the transformation logic on to the Database both on the Source and the Target sides where ever possible to improve performance of the mapping.
• Designed and developed mappings with optimal performance using Aggregator, Joiner, Normalizer, Aggregator, Rank, Sequence Generator, Un-Cached & various kinds of Cached Lookup, Connected-Unconnected-Source Target pre and post load Stored Procedure Transformations, Update Strategy, Union,etc.
• Designed mapplets for implementing reusable logic to load into CDES
• Used pre-session and post-session variable assignment to transport variable values across sessions and worklets.
• Used Constraint Based loading & target load ordering to efficiently load tables with PK-FK relation in the same mapping.
• Worked on Informatica mappings and tuned existing mappings for better performance.
• Extensively used Parameter file to override mapping parameter, mapping Variables, Workflow Variables, Session Parameters and Source-Target Application Connection parameters.
• Applied slowly changing dimensions effectively to handle Delta loads.
• Worked extensively on XML files
• Worked on Informatica B2B tool to provide the clients the required files and receive Acknowledgement files from the clients
• Worked extensively on PL/SQL as part of the process to develop several scripts to handle different scenarios.
• Created several test cases for the mappings developed and then created Integration Testing Document
• Used DVO data validation tool to validate data and XML files
• Provide application support for existing products

Environment: Informatica power center 9.5/9.1/9.0, TOAD 9.1, XML, Informatica B2B, Informatica DVO, SQL Server 2008, Oracle 10g, Windows XP Client and UNIX Server, SVN.

Confidential, Chicago, IL

ETL Developer

Responsibilities:

• Created Complex Stored Procedure using T-SQL to evaluate result for the reports to implement using Management studio
• Developed SSIS solution to create a full-fledged data warehouse solution, consolidated data from various sources like MS Access, Flat Files and SQL Server Database.
• Enhanced the old Excel Reports to new SQL Server Reports fit new business requirement, and implemented into SQL Server 2008
• Involved in performance tuning of SSIS packages to achieve the optimized results
• Created SSIS Packages using Complex Tasks like ActiveX script task, Fuzzy Lookup and Fuzzy Groupings
• Outstanding knowledge in creating Drill down, Drill through and Ad-Hoc Reports
• Indexes are created on tables for new database to faster retrieval for the Reports
• Created different graph reports (Pie-Charts, Bar Diagrams and etc.) for annual reports
• Deployed and scheduled Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including current status
• Developed Report Models as per the requirements and generated Ad hoc Reports using SSRS
• Worked with SQL Server Reporting Services (SSRS), implement report builder to allow customers build their report
• Good experience in Designing, Processing and partitioning cubes in SSAS
• Experience in designing Star Schema and Snowflake Schema with Facts, Dimensions, Measures and Cubes
• Experience in designing, creating, processing of cubes using SSAS.
• Experience in calculating measures and dimension members using multi-dimensional expression (MDX), mathematical formulas, and user-defined functions.
• Good experience in Designing Aggregations and pre-calculating the same in SSAS 2008.
• Excellent hands on experience in creating groups and measures
• Worked on Pivot Tables using Excel Services in order to get the data from the Cube (SSAS)
• Backing up the databases from one server and restoring it to the different server on a regular basis.
• Wrote SQL Queries, Stored Procedures and User Functions
• Created Temp Tables to reduce the number of rows for Joins, to Aggregate data from different sources.
• Good Knowledge on SQL Profiler Tool.
• Created and monitored SQL Server automated jobs to transfer data from various data sources
• Designed reports in both SSRS and deployed them to the Share Point environment
• Migrated contents of SharePoint 2007 to SharePoint 2010 for large deployments
• Involved in installation and configuration of MOSS 2010
• Resolved issues arising from site customizations and 3rd party Web parts
• Worked on Performance Point Server 2007 and Performance Point Server 2010
• Worked with Microsoft SharePoint Designer Tool to create and customize the Web sites and also building Workflows based on Share Point Technologies
• Created Dashboards and Scorecards using Dashboard Designer tool
• Created new users for Clients and also gave access internally and externally by using Active Directory and Exchange Management Console.
• Worked with Active Directory issues such as: Logon Failures, Account Lockouts and Network Connectivity
• Documented all the procedures and processes for future references

Environment: SS BI Development Studio, SSAS / SSIS / SSRS 2008, T-SQL, VB.NET, MS SQL, Microsoft Visual Studio 2005, MS Office, MS Visio, HTML, VBScript, Windows 2003/XP/Vista/7,Windows 2000/2003 Server, Performance Point Server, InfoPath Designer, Share Point Designer tool and SharePoint 2007/2010.

Confidential, Madison, WI

Informatica Developer

Responsibilities:

• Design, develop and unit test ETL objects like mappings, sessions and workflows.
• Data model changes/maintenance over the period of the requirement changes.
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level.
• Worked within a team to populate Type I and Type II slowly changing dimension customer tables from several mainframe flat files.
• Assisting in the implementation of the scheduling strategy.
• Created scripts in PL/SQL to automate the process of creating and dropping indices before and after the ETL process.
• Extensively worked in operational support and deployment to Test and Production.
• Created static and dynamic deployment groups to deploy the ETL objects from Dev to test and from test to production.
• Worked on Data Profiling, Cleansing, Matching, Reporting and Monitoring of data quality.
• Used Tracker tool for scheduling the workflows.
• Daily Data Validation and data quality checks at database level using SQL scripts.
• Used Informatica Server Manager to create, schedule, monitor sessions and send pre and post session emails to communicate success or failure of session execution.
• Responsible for monitoring all the sessions that are running, scheduled, completed and failed. Debugged the mapping of the failed session.
• Improved the overall performance by tuning the whole ETL process.
• Participation in unit and system test process
• Performing troubleshooting and providing resolutions to ETL issues

Environment: Informatica 8.5.0 and 8.6, SQL Server 2008, Oracle 10g, TOAD 8.0, XML, Windows XP Client and UNIX Server.

Programmer Analyst

Confidential

Responsibilities:

• Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental Informatica mappings and workflows to provide data for Data Warehouse.
• Extensively worked in developing complex sql logic(which is to be embedded into the informatica mappings)
• Worked on Data Profiling, Cleansing, Matching, and Reporting and Monitoring data quality.
• Extensively used transformations like lookups (connected, unconnected), expressions, routers, joiners, sequence generators, stored procedures etc.
• Extensive experience in writing stored procedures, functions, and external stored procedures and packages to support the ETL process using PL/SQL.
• Implementation of the SQL triggers,.
• Involved in the development test cases for the Informatica mappings and update processes.
• Developed a PL/SQL package to perform the whole system testing to test the ETL process based on the requirement documents.
• Improved the overall performance by tuning the targets, sources, mappings and sessions.
• Shell Scripting to support ETL processes
• Preparation of technical documentation.

Environment: Oracle 10g, Oracle Applications, Informatica 8.1.1, Informix, TOAD 8.0, DAC, OBIEE, IIS, Windows XP Client and UNIX Server.