PROFESSIONAL SUMMARY:

• 15+ years of experience in IT, including 7+ years of experience in design and implementation of Data Warehouse & Business Intelligence systems using Informatica Power Center 9.x/8.x/7.x ETL tool.
• Expertise in Informatica Power Center tools: Mapping Designer, Workflow Manager, Workflow Monitor and Repository Manager.
• 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.
• Used transformations like Source Qualifier, Expression, Aggregator, Joiner, Filter, Router, Lookup, Update Strategy, Sorter, Sequence Generator, Stored procedure, XML etc. to develop mappings/Mapplets using Informatica PowerCenter Designer.
• In - depth understanding of STAR, SNOWFLAKE schema, OLAP, OLTP, Fact and Dimensions tables.
• Knowledge of implementing slowly 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" to execute workflows. Knowledge of job scheduler.
• 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 Power Center 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.
• Project Management experience including managing project development plan, scope, time, cost, quality, resources, communications, risk, and procurement.
• Experience working in Scrum.
• 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 9.x/8.x/7.x

Data 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, Essbase Spreadsheet Add-in, Dodeca

Programming: Basic Python, Unix Shell scripting, 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, Hyperion, SSRS

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, Control M, AutoSys, File Zilla, Vi editor

WORK EXPERIENCE:

Confidential

Sr. Informatica Developer

Responsibilities:

• Involved in requirement gathering, data modeling, and design specification document. Written documentation to describe development logic, coding, testing, changes and corrections.
• Used Informatica to integrate data from different sources and deliver trusted and complete information for reporting need.
• Modified existing source and target mappings, transformation logic and processes to reflect the changing business environment overtime.
• Developed several complex mappings using transformations like expression, filter, joiner, aggregator, lookup, router, sequence generator, update strategy, sorter etc.
• Designed and implemented slowly changing dimensions to maintain history.
• Involved in Unit, Integration and Performance testing.
• Migrated the code into QA and supported code QA team and UAT.

Confidential

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 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

Sr. BI Analyst

Responsibilities:

• Documented business requirement and data mapping to create BI reports for HR and Profitability Mart (Retail/Lease) systems. The BI reports have dashboards, charts, drill-downs, dynamic reports to show details of workforce, sales, budget & forecast and helps in performing strategic planning, financial planning & analytics (FP&A).
• Responsible for identifying and analyzing source data elements, creation of business rules, map data elements for transformation/migration into data warehouse, examine data for completeness and accuracy, document ETL requirements, prepare specifications for mapping/transformation rules all the way from source to target environment. Understanding of data migration/conversion requirements and translate them into ETL specifications, mapping documents and test cases.

Confidential

Sr. Analyst

Responsibilities:

• 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

Analyst

Responsibilities:

• Workflow - Developed the operational aspect of a work procedure: how tasks are structured, who performs them, what their relative order is, how they are synchronized, how information flows to support the tasks and how tasks are being tracked. Identified the areas for process automation.
• Worked on data security project to encrypt the sensitive information using third party tool (Ingrian) to comply with Sarbanes-Oxley (SOX) guidelines. Interviewed several divisions to identify the impact on various internal and external applications and develop the mitigation strategy.
• Document Imaging - Interviewed and documented the business requirements from different groups to develop the system for centrally storing and imaging the documents. That reduces the cost, redundancy of storing the multiple copies and increases the accuracy for document processing.

Confidential

Programmer Analyst

Responsibilities:

• 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.

Confidential

Consultant

Responsibilities:

• Modeled & implemented Financial Aid application for University of Pennsylvania, providing students with the ability to plan the Effective financial contribution, thus saving the institution 25% in customer servicing costs.
• Redesigned the IT strategy for an Online Store System and implemented store-wide session tracking, intelligent data analysis and secure channels for online shopping functionality, integrating the user channels and customizing their shopping experience with e-Support strategy.
• Managed the research, analysis, strategy development and designing of the web development projects for clients globally. Worked with and trained the teams on the project quality control, methodology and development. Advised clients for implementing B2B products through feature demos, generating up to $150k additional revenue from existing resources.
• Initiated design and developed the web applications, interfaces and client intranets to coordinate systems. Structured and Researched the Knowledge Management repository for quality assurance and project teams. Trained client teams on web technologies, tools and IT strategy applications.