PROFESSIONAL SUMMARY:

• 15+ years of experience in IT, including 8+ years of experience in design and implementation of Data Warehouse & Business Intelligence systems using Informatica Power Center 10.1/9.x/8.xETL tool.
• Strong experience in integrating data from heterogeneous sources like Oracle, SQL Server, DB2, Flat Files (Fixed Width and Delimited), XML and Excel files into Data Warehouse.
• In - depth understanding of STAR, SNOWFLAKE schema, OLAP, OLTP, Fact and Dimensions tables.
• Knowledge ofimplementingslowly changing dimensions (Type 1, Type 2, Type 3) mappings and incremental data loading or change data capture (CDC).
• Created Workflows using various tasks like Email, Event-wait and Event-raise, Timer, Scheduler, Control, Decision in the Workflow Manager.
• Experience in developing Stored Procedure, Functions, Views, triggers, complex SQL queries using SQL Server and Oracle.
• Experience in using the Informatica command line utilities like "pmcmd", “pmrep” to execute workflows. Knowledge of job scheduler.
• Worked on IICS (Informatica Cloud) and integrated with many web based applications and DB.
• Identified performance issues in existing sources, targets and mappings by analyzing the data flow, evaluating transformations and tuned accordingly for better performance.
• Experience in Installation, Configuration, and Administration of Informatica Powercenter Client.
• Performed requirement gathering, data analysis, data mapping, unit testing, user acceptance testing and project documentation. Developed test plans, test cases, and test scripts.
• Exposure working with onsite-offshore team environment and coordinating with Offshore team.
• Project Management experience including managing project development plan, scope, time, cost, quality, resources, communications, risk, and procurement.
• Experience working in Agile and Waterfall and worked on many tools like Rally, Basecamp etc.
• Strong verbal and written communications skills, as well as strong organizational and presentation skills.
• Quick learner and excellent analytical and problem solving skills, ability to handle multiple tasks and responsibilities.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 10.1/9.x/8.x, Informatica Cloud (IICS), Informatica Power Exchange 10.1/9.xData Warehouse Star Schema, Snowflake Schema, FACT and Dimension tables, OLAP and OLTP, Physical and Logical data modeling, Erwin

Databases/BI Tools: SQL Server 2008, Oracle 11g/10g/9i, MS-Access, TOAD for Oracle, Hyperion SmartView, Hyperion FRS, TeraData 15/14, Hive, MySql

Programming: Basic Python, Unix Shell scripting, SQL, PL/SQL, Java, .Net, C++, Java Script, SharePoint, XML, HTML, VBA, UML, XML, FTP, TCP/IP, SMTP

Operating Systems: Windows, AS400, MS DOS

Reporting Tool: Business Objects, Cliqview

Utilities: VMware, Putty, Visual Studio 2012, Cygwin, MS Office, Microsoft Visio, Microsoft SharePoint, Win Runner, Test Director, Rational Requisite Pro, Viper, Remedy, Clarity, Quality Center, Outlook Soft, Lotus Notes, PuttyControl M, AutoSys, File Zilla, Vi editor

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

Sr. Informatica Developer

Responsibilities:

• Interacted with business analysts to gather the business requirements by attending regular meetings with the different system owners / analysts.
• Gather the requirement and create a specification document.
• Used IDQ tool for profiling, applying rules and develop mapping to move data from source to target system.
• Wrote oracle stored procedures to improve performances in the staging area.
• Tuned the oracle queries / processes to improve performance.
• Prepared ETL detail design and unit testing document to outline the flow of data, for testing source/targets counts and field-to-field mappings.
• Provided production support by running the jobs and fixing the bugs.
• Aided in migrating the code across various environments.
• Documented the process for further maintenance and production support.
• Coordinated the Change Management process which involved driving the QA and production deployments.
• Different enhancements involve architectural changes of the existing system.
• Involved in Information administration including creating new users and groups, backing up the repository and domain as well as handling various upgrades.
• Documented the scope of new development projects.
• Involved in writing and modifying UNIX shell scripts.
• Worked with data quality team to fix the production data issues and also provide solutions to the business users.
• Coordinated with offshore team to support the existing ODS system jobs.
• Coordinated with business users and across the development teams in implementing new business requests.
• Used Toad for data quality verification and unit testing the data.
• Updated design documents, defect trackers.

Environment: Informatica Powercenter 10.2.1/9.6.1 , Informatica Power Exchange 10.1, Oracle 12c, IDQ, Teradata 14, MSSQL Server 2008 R2, T-SQL, SQL Server 2008, Aqua Studio 10.0.4 PL/SQL Developer, Shell Scripting, Putty, Jira/ALM

Confidential, CA

Sr. Informatica Developer

Responsibilities:

• Responsible for understanding business requirements from stakeholders/Architects/JAD sessions and provide inputs to the requirements/design/coding/testing/implementation and developing artifacts for all phases of the project life cycle.
• Mentored Informatica developers on the project for development, implementation, performance tuning of mappings and code reviews.
• Worked with different sources and targets systems like flat file, XML, and relational tables.
• Implemented complex mappings in Power Center Designer using Aggregator, Expression, Filter, Router, Sequence Generator, Update Strategy, Rank, Joiner, Connected - Unconnected Lookups, XML Parser, SQLT and Stored procedure transformations.
• Designed and developed mappings using slowly changing dimensions (Type 1, Type 2).
• Used Variables and Parameters in Mappings and Sessions.
• Written PL/SQL queries to validate the data in warehouse using TOAD.
• Developed Informatica mappings, reusable transformations, mapplets, sessions, workflows, worklet for data loads and automated data loads using Unix shell scripts.
• Involved in debugging mappings, recovering sessions and developing error-handling methods.
• Successfully migrated objects to the production environment while providing both technical and functional support.
• Developed email tasks to send emails to production support and operations.
• Worked on identifying and resolving various major production fixes and provide innovative solutions to meet the needs of the business.
• Test solutions to validate whether requirements have been met, develop test plans, test scripts, and test conditions based on the business and system requirements.

Confidential, Hauppauge, NY

Sr. Informatica Developer

Responsibilities:

• Involved in the documentation/Design of Technical Design Document of various interfaces like Sales organization, Field AOP, and Field Forecast.
• Used Teradata, SQL assistant for running the SQL Queries to check the data loaded to the Target Tables.
• Designed and developed mappings, mapplets and sessions from source to target database using Informatica Power Center.
• Used simple to moderately complex debugging techniques to test ETL applications.
• Developed Test Cases for testing the ETL mappings.
• Conducted code reviews and lead design reviews to assure compliance.
• Involved in migration of ETL/Bteq code from Development environment to QA environment and finally to Production environment.
• Followed Informatica development standards and enforce best practices.
• Performed QA work to verify the results provided from other teams.
• Worked with various file formats like fixed length and delimited.
• Involved in creation of BTEQ Script for validating the data quality like referential integrity, not null check.
• Experience in using TPT (Teradata Parallel Transporter) utility.
• Maintained the proper communication between other teams.
• Utilizing the existing UNIX shell scripts to run the Informatica workflow through process control.
• Scheduled sessions and batch process based on demand, run on time, run only once using Informatica Workflow Manager.
• Identified BI reporting problems, and suggests practical resolutions.
• Participates in *on-call* support for ODS and the data warehouse.
• Involved in documentation to describe program development, logic, coding, testing, and any changes and corrections.

Environment: Informatica Powercenter 8.6, Informatica Power Exchange 8.6, MSSQL Server 2008 R2, T-SQL, Erwin 7.1, Teradata, TPT,SQL Server, TOAD, PL/SQL Developer, Windows XP, Visual Basic 6, .Net, SQL Server 2005&2008, Sybase 12, Windows xp, Sun Solaris, Harvest, Putty.

Confidential, Agoura Hills, CA

Sr. Analyst

• Worked on data management (ETL) including manage daily data flow from and to internal/external systems, extracting data from outside sources which involves parsing of extracted data, check if the data meets an expected pattern or structure, transforming it to fit operational needs, loading it into the end target, reconcile data, fix data issue, maintain database tables, write SQL queries, SSIS, Jobs etc.
• Documented the report requirements, data mapping from source to target environment, data flow diagrams to build reports in Hyperion and Business Objects for loan funding and servicing data. The reports provide dashboards, charts, dynamic reports, summary level data and drill down functionality at loan level.
• Managed multiple systems which handles financial and accounting processes including preparing journal entries, assists with closing process, variance analysis, analyzing General Ledger activity for any discrepancies, annual budgeting and financial reporting. Assisted in implementing changes affected by SOX and SEC regulations.

Confidential

Informatica Developer

Responsibilities:

• Worked on designing ETL design Documents and Informatica Load processes and handled document walkthroughs.
• Extensively participated in functional and technical meetings for designing the architecture of ETL load process (mappings, sessions, workflows from source systems to staging to DW).
• Developed mapping document indicating the source tables, columns, data types, transformation required, business rules, target tables, columns and data types.
• Identified and created Several Informatica reusable components like mapplets, user defined function, tasks and worklets to minimize the effort and enhance quality.
• Created mappings to Extract, Transform and Load (ETL) data from source (SQL Server) to the Data Warehouse by using Informatica ETL tool.
• Created Parameter files, Variables and Workflow parameters to enhance portability of code.
• Designed and Created ETL Design doc, UTC, Code review and tracker doc.
• Developed complex mappings in Informatica to load the data from various sources using different transformations like Source Qualifier, Look up (connected and unconnected), Expression, Aggregate, Update Strategy, Sequence Generator, Joiner, Filter, Update Strategy Rank and Router transformations.
• Worked on performance tuning of the complex transformations, mappings, sessions and SQL queries to achieve faster data loads to the data warehouse.
• Created session tasks, event waits & raise, command task, worklets etc. in the workflow manager and deployed them across the DEV, QA, UAT and PROD repositories.
• Exclusively worked with Views, Synonyms, Procedures/Functions and Packages in Oracle PL/SQL to build business rules.
• Run Micro Strategy reports and improved the performance of the reports by analyzing the underlined SQL that is generated by Micro Strategy reports using Oracle optimization methods like Partitioning Tables, Creating BITMAP Join index, Flushing buffer Cache etc.
• Have hands on experience to use MS SQL server management studio express (2005/2008).
• Wrote Unix scripts for scheduling the maestro jobs to automate the processes.
• Created unit test plan master document with appropriate test cases and test results for ETL Code.
• Experience in using TPT (Teradata Parallel Transporter) utility.
• Responsible for ETL Code walkthrough and Knowledge Transfer at all stages.
• Implemented type I & II slowly changing dimensions tables.
• Performed Unit testing to detect the defects in the codes and tracked by using HP Quality center tool.
• Involved in ETL Code migration from Informatica 8.1.1 to 8.6 using XML.
• Involved in pre & postproduction support to resolve the issues.

Environment: Informatica Powercenter 8 .6.1, Oracle 10g, SQL, PL/SQL, SUN OS 5.10, TOAD/SQL Developer, Micro Strategy, Tortoise SVN, HP Quality Center 9.2, Microsoft SQL Server Management Studio Express (2000/2008), Putty, WinSCP, Teradata V2R6, TPT, Microsoft Access.

Confidential, CA

.Net Programmer Analyst

• Responsible for gathering and documenting business requirements, preparing data flow charts, design specification, use cases, test plans, system documentation and user guides. Responsible for process improvement, process change planning and implementation of new processes.
• Worked on acquisition and servicing of loan portfolios, verified and completed the documentation in compliance with government policies and procedures. Coordinated with project management office, stakeholders and different departments to service portfolios. Implemented automatic centralized loan boarding project to improve process, data conversion, and accuracy and reduce cost. Managed the business process re-engineering (BPR) of Service Release and Interim Service of portfolios to accommodate the current business needs and streamline the document imaging process.
• Developed websites for Call Center operations to analyze the error tracking in customer liaison using ASP.Net, VB.Net, ASP, Java Script, AS400 and SQL Server languages and automated data processing and reporting to business units.