We provide IT Staff Augmentation Services!

Business Analyst/informatica Data Warehousing Analyst Resume

Alpharetta, GA


  • I have 10+ years of Professional IT experience in handling Data warehousing & Business Intelligence and Data Analytics projects. Currently working as a Business Analyst for Fraud strategy system. Worked as a Technical lead for the Development and the Enhancements projects that spread across the Domains Insurance, Healthcare & Life sciences, Fraud strategy and involved in the complete SDLC for custom tools/applications, data migration, data Integration configurations based on Informatica 7.1/8.6/9.6.1, Abinitio 3.0, Unix, Relational databases Oracle 9i/11g, SQL Server 2005/2008, DB2 and on On - Cloud Applications like Oracle On Demand (OOD), Sales Force data center (SFDC) using Informatica web services and Sales Force SFDC Data.
  • Proficient in Analyzing the Business Processes requirements and translating the minto t echnical requirements, design data architecture for data Integration/Migration.
  • HaveworkedonInformaticawebservicesandhttptransformationstointeractthedatawiththeCRM Oracle On demand applications.
  • Expertise on PL/SQL in developing Procedures /Functions with complex datatypes including ref cursor and table types.
  • Proficientinproductionsupportactivitieswitheffectivechangemanagement configurations using visual source safe VSS, Handling Incident tickets, change requests and Problem tickets using Remedy Incident Management and Quality Center tool.
  • Experienced in writing the Production support documents like System Maintenance Technical document (SMTD), Knowledge error DB documents(KEDB)
  • Experience in working collaboratively with internal integration groups such as Business Analysis, Architecture, Tool Administration and DBA to deliver high-value solutions that conform to all requirements. Work collaboratively with external IT groups such as Operations, Help Desk and Applications to implement solutions into the environment
  • Design, Development and Testing of Informatica Objects, database procedures, functions and Unix scripts.
  • Involved in carrying out Quality Reviews, Audits, design and development reviews, review of user-cases and test-cases, business scenarios and root-cause analysis, coordinating user acceptance testing, training, and implementing new processes.
  • Good exposure towards the principles of Data warehousing.
  • Strong Knowledge of RDBMS like DB2, Oracle, SQL Server 2005/2008.
  • Reviewing the mappings, tracking and solving the defects occurring during the different phases of the Software Development lifecycle.
  • Has experience on data migration to SFDC application.


Domain Knowledge: Insurance, Health care and Life sciences, Investments, Fraud strategy.

Data warehousing Tools: Informatica 7.1/8.6/9.6.1, SAS, Abinitio3.0,Hyperion, SAP BO 4.0 web intelligence

Database and Tools: Oracle 9i/11g, DB2, SQL server 2005/2008,Toad, QMF, SQL developer

Program Languages: PL/SQL, C, VB 6.0, UNIX

Scripting Languages: HTML, JavaScript

Scheduling Tools: IPM (In Process manager), TWS (Tivoli workflow scheduler).


Confidential, Alpharetta, GA

Business Analyst/Informatica Data Warehousing Analyst

  • Analyze the requirements and design solution for the one acquisition platform that serve customer better through new functionality, flexibility and speed to implement new strategies with the migration of two separate platforms retail card applications and payment solution /care credit. coordinating with Business Analyst for clarification and development. ensure all the Strategies are mapped correctly, coordinate with multiple teams to ensure project is on track and on time. understand the current strategy design and platform, clearly communicate fraud requirements and ensure those are incorporated into the new platform
  • Reviews First data screens for SAS raptor scoring & Defense Edge parameters for Fraud strategy /Risk Analytics and validates the across the databases and data warehouses.
  • Analyze data reports CD-051(Noncoms) & CD-031 (Authorizations) using document direct tool and provide detailed analysis/recommendations to senior management.
  • Prepares the UAT testing scripts and test the End to End solutions to test scenarios 100% real time authorizations scored, critical Noncoms presented to engine in Real time.
  • Validates the Production data for the corresponding Production release.
  • Develop recommendations to address problems/issues and make presentations to the manager

Environment: /Tools: SAS, Oracle, PL/SQL developer, document direct, FDRNET Extreme Attachmate, Docu Analyzer, Unix.

Confidential, Durham, NC

PL/SQL and ETL developer.

  • Involved in designing the design for ADE project data flow.
  • Preparing the Technical design document for ADE project including the pseudo code.
  • Developed and tested the Pl/SQL Procedures for Source to Stage and PL/SQL Procedures for the Web services to consume the data. developed the Automation test script from scratch for testing the Procedures including Input/output types of Ref cursor and table types.
  • Built Informatica mappings/Workflows to Source to stage OSCAR & SYBASE elements
  • Helped the Team in writing the SQL server Queries for AAROW Elements.
  • Helped the system Analyst and the Web services team in their documentation work whenever required.

Environment: /Tools: Informatica Power Center 9.1, Oracle 11g, PL/SQL, PL/SQL developer, Unix

Confidential, Boca Raton, FL

Technical Lead

  • Responsibility Involves in transition application support, KTLO activities and delivery of on-going support and maintenance for TYCOIS.
  • Worked on Performance tuning in the existing PLSQL and Informatica ETL code.
  • Developed materialized views for the BO reporting query.
  • Documenting of SMTD documents.
  • Involved in Preparing SDP and STP document for each work order.
  • Involved in Preparing Road map document for Analysis of each problem/Incident Tickets.
  • Involved in implementing Change Requests.
  • Providing modifications to the current applications and to deploy them to production as part of the enhancements delivery for Live.
  • Responsible for smooth migration of Code to Production, involved in preparing Migration checklist includes pre-and Post-validations of Informatica, UNIX and DB scripts.

Environment: /Tools: Informatica Power Center 9.6.1, Oracle 11g, TOAD, Pl/Sql developer, Unix, SAP BO 4.0

Confidential, Durham, NC

Technical Lead

  • Developed the mappings to integrate the data in the CRM application Oracle on demand and unit testing.
  • Involved in understanding the architecture and the functional flow of the application.
  • Documenting of Technical design documents, Development and
  • Testing and review of Informatica Objects.
  • Built the Reusable components like Automation of Remedy Ticket Creation using Informatica Web Services.
  • Generic email Unix script.
  • Developed Oracle Stored Procedures, functions, views
  • Generic PL/SQL Procedure to capture/validate the data counts.
  • Providing modifications to the current applications and to deploy them to production as part of the enhancements delivery for Live.
  • Co-coordinating with test team and provide them with all the technical details for smoother execution of test cycle.
  • Configuration Management such as maintaining Deployment checklist and details and code movement to VSS.
  • Supporting the application in Production in Warranty Period.

Environment: /Tools: Informatica Power Center8.6.1, Oracle 10g,TOAD,PL/SQL Developer, VSS, Unix.


Technical Lead

  • To understand the SFDC application Objects like Accounts, territory and customized Objects like Quotas, Line Fill.
  • To Prepare the Source Target sheet specifying the Business logic for each field.
  • Setting up the Infrastructure and connections for the databases and FTP connections.
  • Develop mappings/sessions to migrate these objects From SAP BW/R3 to SFDC application using Informatica and Data Loader.


ETL Developer

  • Study of client system, processes - Based on the Requirement of the Client, preparing the Analysis Document that is reviewed by Onsite Coordinator; involved in Design and Coding of the Informatica Mappings to create dimensions and facts to create a data warehouse; interaction with Business Analyst in Preparation of Technical Design Documentation; writing the SQL Scripts for extracting data in the application and applying those Scripts in the Database of the Application according to the Requirement; Supported the Team to develop the test cases; Prepared the CI lists to move the folders from one Environment like UAT to Production; Unit tested each process as per the functional specification document.

Tools: and Languages: Informatica 8.6, Oracle, DB2, Unix. Tivoli Maestro scheduler, vi editor, QMF, Toad.

Hire Now