PROFESSIONAL SUMMARY:

• Over 9 years of professional experience in Information Technology with a strong background in Analyzing, Designing, Development and Implementation of Client and Server Applications.
• 7 years of experience in Data Analysis, Business Intelligence, Data Migration and Data Warehouse.
• 7 years of experience in Data Warehouse/Data Migration using Informatica Power Center 8.x/9. x.
• Good Database development, programming and maintenance skills.
• 1 year of experience in .Net, C# technologies.
• 2 years’ experience in SAP BO R3 reporting.
• 1 year of experience in Actuate Reporting.
• 7 Years of experience in Data Migration using ETL tools.
• 7 years of strong database development and design skills.
• Extensive experience in Documentation of Data Assessment, Data Mapping, Code Review, Test plan and operations.
• Hands on experience in writing, testing and implementation of the PL/SQL triggers, stored procedures, functions and packages.
• Experience in production support and product maintenance.
• Oracle development experience designing, modeling, PL/SQL, loading data, testing and tuning queries.
• Offshore and Onshore team management.
• Experienced in setup and working with the offshore team.
• Expertise with T - SQL usage and syntax to build Stored Procedures, Triggers, Views, Cursors and Indexes.
• Understanding of SQL best-practices to ensure data integrity and fastest data acquisition.
• Excellent Project Management skills.
• Knowledge of Software Testing and Quality Assurance.
• Good understanding and working knowledge on Power Exchange (Change data capture)
• Domain Knowledge in Energy trading.

TECHNICAL SKILLS:

BI Tools: Informatica Power Center 8.6.1/9.1.0

DBMS: SQL Server 2005/2008, Oracle 9i/10g/11g

Reporting Tools: Actuate Reporting, SAP BO 3.1 Reporting

Languages: C#, VB.NET, SQL, PL/SQL, JavaScript, XML

Web Technologies: ASP.NET, Web Services, JavaScript, VB.Net, .NET Framework 2.0/3.0

Application Tools: Visual Studio 2003/2005, Visual Source Safe 6.0

Configuration Management Tools: Remedy, IBM Rational Clear Case

Scheduling Tools: Tidal

PROFESSIONAL EXPERIENCE:

Confidential, Houston, TX

ETL Developer/Technical Lead

Responsibilities:

• Managed ETL and Data Reporting development and support for the client.
• Worked on building Business Intelligence Repository at 3 layers i.e., Physical Layer, Business Model and mapping Layer and Presentation Layer.
• Analysis of source systems for validation of business rules, data Integrity and data cleansing requirements particularly with respect to vendor and Material master data.
• Draft and maintain business requirements and make sure functional and technical requirements are aligned.
• Worked as Scrum Master & Project Manager to meet goals for quality, schedule & cost.
• High Level ETL process design - Design of Interface between Oracle Apps and the legacy applications.
• Designed an overall Oracle EBS implementation solution including analyzing data, preparation of high level, detailed design documents, test plans and deployment strategy.
• Understand the existing subject areas, source systems, target system, operational data, jobs, deployment processes and Production Support activities.
• Discover the source data that causes the problems downstream.
• Supported daily nightly productions jobs on rotation basis.
• Design and developed ETL process to load and extract data for legacy applications.
• Design and built Oracle databases and stored procedures to in corporate into ETL process.
• Manage and mentor team of 3.
• Provided Informatica Training to other teams throughout the company

Environment: Oracle 11g, LINUX, Informatica 9.1/9.5, Oracle 11g, SQL Developer, SQL Server, JIRA

Confidential, Houston, TX

Data Integration Developer

Responsibilities:

• Developed ETL code for OPI Application for OBIEE Reporting.
• Worked closely Clinical Analytics management team in improving performance clinical analytics & research
• Performed Data Analysis in the process of delivering accurate data loads which will be used by internal clients
• Worked closely with Analytics team in gathering requirements
• Created Mappings, Sessions, Workflows as required in Informatica
• Tuned the application by converting some of the Views/materialized Views to Mappings in Informatica.
• Created lot of Informatica repository queries which are useful during analysis and is being used by the entire ETL team and being used for creating dashboards.
• Involved in system testing, migration and Production support.
• Keeping Up-to-date with the latest technologies.
• Involved in requirement gathering prior to development work.
• Troubleshooting and resolve End User Issues/Data Issues
• Participated in Disaster Recovery testing
• Always completed maintenance tickets either on-time or earlier than agreed SLAs
• Actively monitor Data load jobs
• Maintaining and updating the Issue Log
• Fixed root causes for reoccurring problems in several instances and decreased maintenance tickets
• Provided primary on-call support during after hours

Environment: Informatica Power Center 9.1.0, Oracle 11g, TOAD, JIRA, Altiris, Hyperion

Confidential, Houston, TX

Technology Lead

Responsibilities:

• Developed ETL code for SEARS’s application.
• Created mapplets, Mappings, Sessions, Workflows as required in Informatica
• Developed BO Universe and reports.
• Automated the process of scheduling BO reports by writing macros.
• Tuned the application by converting some of the stored procedures, Views to Mappings in Informatica. Achieved significant performance improvement with this change.
• Created lot of Informatica repository queries which are useful during analysis and is being used by the entire ETL team.
• System testing and production support.
• Keeping Up-to-date with the latest technologies.
• Have been part of the Business Continuity plan team.
• Involved in requirement gathering prior to development work.
• Providing Market Risk IT Support on daily basis.
• Actively monitor Data load jobs
• Maintaining and updating the Issue Log
• Troubleshooting and resolve End User Issues/Data Issues
• Working with Off Shore team in maintaining daily jobs.
• Used Problem and Incident management system in resolving issues and mitigating potential issues
• Played active role during team’s application releases (using Remedy - Release Management System) in Production and pre-Production environments
• Preparing the Test cases & Test Plans in Quality Center
• Fixed root causes for reoccurring problems in several instances and decreased maintenance tickets
• Provided primary on-call support during after hours
• Disaster Recovery testing

Environment: Informatica Power Center 9.1.0, Oracle 11g, SQL Developer, SAP BO XI 3.1, Change Management, Release Management, Tidal Enterprise Scheduler, JIRA, Mercury Quality Center, Clear Case

Confidential, Dallas, TX

ETL Developer

Responsibilities:

• Actively involved in the overall ETL architecture implementation and conversion process.
• Created Folders, Designed Target tables, Multi-Dimensional Meta Data.
• Handled Type-1, Type-2 slowly changing Dimensions.
• Created relevant Transformations, Mapplet, Mappings, Sessions, Worklets and Workflows.
• Developed number of Complex Informatica Mappings, Mapplets and Reusable Transformation.
• Had a fully-fledged involvement in the ETL process such has extracting sources form the external systems like Flat files, relational sources coming from staging database and then loading into the Data Warehouse.
• Used session and workflow variables and created parameter files
• Involved in optimizing the overall session and Workflow Runtime.
• Involved in the detail understanding of the business process, took the responsibility of identifying new process, finding out gaps in existing process, arranging training modules for new process development and implementation.
• Was involved in the User interaction to analyze and gather the ETL rules objects requirements. Prepared the ETL
• Involved in the Installation and Configuration of the Informatica Power Center 8.6 server repository and client setup, administered the Informatica server and the Process.
• Involved in setting up of Oracle database for the Development and QA environment.
• Was a key resource in extraction team that involved in ETL process, applying the necessary transformation logic to extract the source data from flat files, xml files into the Data Mart
• Knowledge in performance tuning of the ETL architecture and the Data warehouse.
• Implemented complex mapping such as slowly Changing Dimensions Type 2 using Flag.
• Designed and developed Oracle PL/SQL Procedures.

Environment: PL/SQL, TOAD, Informatica Power Center 8.6.1

Continental, Houston, TX

Software Developer

Responsibilities:

• Involved in designing and developing front-end screens using ASP.NET in several functional areas.
• Worked with architecture team, designers, and analytics team while working on developing web pages
• Created Web Services using DB Stored Procs which are called in the Web Applications
• Developed Green Screen Proxy Application & tested them in the Green Screen Environment.
• Designed Web-based ASP.Net applications linked to Oracle Databases
• Converting the Web Applications to Executables and Uploading to the Server.
• Extensively used JavaScript for the client validation.
• Work with Database Tables & Stored Procs to develop the web application.
• Extensively used .Net built-in components like Data Grid, Repeater and other out of the box components.
• Leveraged master pages, skins, themes for consistent look and feel of the web Application.
• Designed and developed custom user controls for a plug and play kind of implementation.
• Involved in peer to peer code reviews.
• Liaised with production team to analyze bugs and resolve issues.
• Troubleshoot and resolved bugs in .Net applications to ensure optimal development environment
• Analyzed business, functional, and technical requirements to make sure project met expectations

Environment: ASP.NET 1.0/2.0, C#, VB .NET, TOAD, PL/SQL, JavaScript, Oracle 10g, VS 2003/2005/2008, ICE, CateRunner, AirFrame, MainFrame

Confidential, Columbus, OH

Software Developer

Responsibilities:

• Design and development of new reports based on markup specifications using Actuate Reporting Tool.
• Designed and Developed data-entry/display screens using Visual Studio
• Involved in developing windows desktop applications
• Responsible for developing Export/Import Features on this Application from several data sources.
• Leveraged MS Enterprise Application blocks.
• Developed the data layer using ADO.NET and extensively leverage stored procedure, triggers, views and indexes in SQL Server 2000.
• Used Visual SourceSafe for version control

Environment: Actuate e.Reporting Suite 7.0/8.0, ASP.NET 1.0/2.0, C#, VB .NET, T-SQL, JavaScript, SQL 2000, VS 2003/2005, Oracle 9i, TOAD