SUMMARY

• He has 10+ years of experience in extensive Data Warehousing and Data migration implementation in Financial & Healthcare domain including over 5+ years of experience working as a Senior ETL Developer being an SME for retail projects (Salesforce.com) at Confidential and with 2+ years of experience working as a Senior ETL Developer/Software Engineer and OBIEE Reports Developer on ESRD Program (CMS) at Confidential.
• Has worked in complete Software Development Life Cycle (SDLC) Implementation from Requirement Gathering, Analysis, Data Modelling, Design, Implementation, Testing, Implementation, Post Implementation Support and Maintenance Support. He is an excellent “team player” working with various teams of different sizes across the organization and taking a lead on initiatives to provide a better solution satisfying business needs.

TECHNICAL SKILLS

ETL Tools: Informatica PowerCenter v 10.1.0/9.6.1 /8. x/7.x/6.x, Informatica DataQuality (IDQ) v8.x, PowerExchange v8.x

Databases: Netezza TwinFin 6.0,Oracle 11g/10g/9i/8i, MS SQL Server, DB2, MS Access

Database Tools: SQL Plus, SQL Loader, Toad, SQL Navigator, PLSQL Developer,WinSQL, SQL Advantage, Query Analyzer

Reports/DSS Tools: OBIEE 11.1.1.9, Cognos 11/10.2, Business Objects XI/6.5.

Data Modeling: ERWin 6.0, MS - Visio

Operating Systems: Windows 9x/NT/2000/XP, UNIX (AIX)

Schedulars: Tidal Enterprise Scheduler, Autosys

Methodologies/Other: Agile, SAFe,Waterfall, Software Testing

Languages: SQL, PL/SQL, Shell Scripting

PROFESSIONAL EXPERIENCE

Confidential, MD

Sr. Software Engineer, Informatica/OBIEE Developer

Responsibilities:

• Interacted with Business stakeholders, Data architects and application developers to analyze and develop the new system.
• Working in Agile, actively contributed to planning sessions and story creations related to ETL/Reports and prepared ETL Design Document and mapping document.
• Designed the strategy to implement Bulk Load & Incremental load methods for transactional replication.
• Prepared ETL Design Document and mapping document.
• Implemented the best practices for the creation of mappings, sessions and workflows and performance optimization.
• Created mappings from SQL Server tables & Oracle views as sources to Oracle tables as target for replication and csv files for the reports.
• Optimized the performance of the Designed workflows processes in Informatica and identified the bottlenecks in different areas.
• Developed Slowly Changing Dimension Mappings for Type 1 SCD and Type 2 SCD.
• Extensively worked with various lookup caches like Static Cache, Dynamic Cache, and Persistent Cache.
• Used debugger to test the mapping and fix the bugs.
• Created/modified Metadata repository using the OBIEE Physical, Business Model and Mapping and Presentation Layers satisfying Business requirements.
• Collaborated with Business Analysts, discussed and identified the analytics requirements to be obtained from various user groups.
• Created star schemas in the repository. Used the foreign key link in the physical layer and the new complex joint key in the Business Model and Mapping layer to form relationships between fact and dimensional tables.
• Set up security to authenticate users and grant permissions and privileges to appropriate users thus facilitating efficient web use in a large environment.
• Used Catalog Manager to migrate new Projects and enhancements from Development to Production environment.
• Performed end to end testing from ETL Data Loads to Reports Generation.
• Developed and documented Cognos reports and dashboards and also supported deployments/validations of reports to different environments.
• Extensive SQL querying for Data Analysisand wrote, executed, performance tuned SQL Queries for Data Analysis & Profiling.
• Wrote Deployment Plan documents which involved migration of mappings and workflows/sessions from development repository to higher environments.
• Monitor & troubleshoot batches and sessions for weekly and monthly extracts.
• Created reconciliation process to match the records count and validations after incremental loads.
• Wrote UNIX Scripts for implementing certain functionalities like timestamps based file generation,

Environment: s: Informatica 10.1.0/9.6.1 , OBIEE 11.1.1.9, Cognos 11/10.2, Oracle 11g/10g, PL/SQL,WinSQL, Apex DataLoader, WinSCP, Unix/Shell scripting, TOAD 9.0

Confidential

Senior Informatica Developer

Responsibilities:

• Analyzed the existing systems and made Feasibility Study.
• Analyzed and understood business and customer requirements by interacting with Business Analysts, Data Modelers and Subject Matter Experts (SME).
• Collaborated with Business Analysts and the DBA for requirement gathering, business analysis and designing.
• Wrote and reviewed documents like User Data Sheet (UDS), Functional Specifications (FS), and ETL Specifications.
• Involved in ETL Process Flow Chart.
• Prepared Unit Test Cases.
• Data modeling and design for data warehouse and data marts in star schema methodology with confirmed and granular dimensions and FACT tables.
• Automated the processes from existing Manual processes.
• Prepared Technical Design Documents (TDD) and Detailed design documents (DDD) to load data into various tables in DataMarts.
• Established standard code migration process.
• Identified various Data Sources and Development Environment.
• Worked with heterogeneous sources from various channels like Flat files, XML files, Relational Databases (Oracle, SQL Server), Netezza.
• Working on a Highly Visible Time Constraint project.
• Worked extensively on various Large Projects and SPRs for Salesforce.com
• Worked on Salesforce Maintenance tickets and helped Investment Consultants in resolving Householding issues.
• Worked with Incremental Loads and Daily Refresh.
• Developed mappings in Informatica to load the data from various sources into the Data Warehouse, using different transformations like Source Qualifier, Expression, Lookup, aggregate, Update Strategy, Joiner, Normalizer, Router, Stored Procedure etc.
• Worked on Informatica tool Source Analyzer, Warehouse Designer, Mapping Designer, Workflow Manager, Workflow Monitor, and Repository Manager.
• Experienced in handling slowly changing dimensions.
• Implemented SCD Type 1 and SCD Type 2 methodologies to keep historical data in data warehouse.
• Loaded the flat files data using Informatica to the staging area.
• Designed and Developed pre-session, post-session routines and batch execution routines using Informatica Server to run Informatica sessions.
• Documented the complete Mappings.
• Experienced in handling XML files using XML transformations.
• Involved in different phases of testing like Unit, Functional, Integration and System testing.
• Performance tuning of targets, sources, mappings and sessions.
• Architectural Analysis of application and proposing solution to improve the performance, robustness, scalability and security of the applications.
• Code migration from development to QA and production environments.
• Scheduling the sessions to extract, transform and load data in to warehouse database on Business requirements.
• Provided technical assistance by responding to inquiries regarding errors, problems.
• Knowledge in writing Shell Scripts to run the workflows.
• Maintained Coding standards and participated in Code Review.
• Resolving production issues.
• Provide support during the business hours and On-call support otherwise.
• Onsite/Offshore co-ordination.

Environment: s: Informatica 9.0.1/8.1.1/7.1.4 , Salesforce.com, Netezza TwinFin 6.0,Oracle 11g/10g, PL/SQL,WinSQL, Apex DataLoader, WinSCP, Unix/Shell scripting, TOAD 9.0

Confidential, IL

SQL Developer

Responsibilities:

• Wrote complex SQL queries and demonstrated ability to collaborate with other developers during Design, Development, and Testing.
• Responsible for the management of the database performance, backup, replication, capacity and security.
• Collaborated with Business analysts and the DBA for requirements gathering, business analysis and designing of the data marts.
• Plan, design, and implement application database code objects, such as stored procedures and views.
• Generated SQL and PL/SQL scripts to install, create and drop Trading Exchange Connection database objects including: tables, views, primary keys, indexes, constraints.
• Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction.
• Identified data issues and provided recommendations for resolution to ensure optimal performance.
• Documented and maintained database system specifications, diagrams, and connectivity charts.
• Monitored and provided front-line support of daily processes.
• Helped create process logging and new monitoring tools, integrity reports, and mapping tools.
• Helped Troubleshooting, fixed, and implemented bug fixes and enhancements within tight deadlines.
• Designed and generated database objects and Oracle Forms, Reports, and Libraries through Oracle Designer.
• Also created, modified, maintained and optimized SQL server database.
• Maintained the documents and create reports for the business analysts and end-users.

Environment: s:. PL/SQL; SQL; SQL*Plus; Oracle 9i, 10,11g; Apex 3.2; Linux ; Windows XP; TOAD; Oracle Reports 6i, 10g; Oracle Developer; Oracle Developer; HTML; Dreamweaver;Windows NT.