SUMMARY

• 16 Years of IT experience in analysis, design, development and implementation of Business Intelligence solution using Data Mart/Data Warehousing Design, ETL, OLAP, Client/Server and web applications on Unix and windows platform in various domains such as Banking, Finance, Insurance, Sales and Manufacturing.
• 14 years’ experience in design, develop and maintaining Data Warehouses and Data Marts using Informatica, Teradata, Oracle, DB2, SQL Server, Siebel
• 2 Years of Business Intelligence experience using Business Objects 6.5/5.1(Designer, Business Objects and Migration) and Micro Strategy
• Strong hands on experience in creating SSIS Packages, Stored Procedures using SSIS, SQL Server 2008, and T - SQL.
• Strong hands on experience using Teradata utilities (SQL, B-TEQ, Fast Load, Multiload, Fast Export, and Tpump).
• Created bulk data loads from multiple data sources (Oracle, Flat files) in to Teradata using BTEQ, Multi load, and Fast load utilities.
• Proficient in Oracle in writing and using SQL queries, Stored Procedures, Materialized Views, and Optimization tuning techniques.
• Experienced in Data Extraction, Transformation, and Loading (ETL) from disparate Data sources like Multiple Relational Databases Oracle, DB2, SQLServer, Mainframe, SAP R/3, SAP BW and Worked on integrating data from flat files and CSV files into a common reporting and analytical Data Model using Informatica
• Expertise in Creation, Modification and Testing of Informatica Mappings, Mapplets, Workflows, Worklets and debugging and performance tuning of Informatica Mappings and Sessions.
• Experienced in Performance tuning of critical Informatica jobs & database loader jobs and Data Warehousing Applications
• Wide experience in applying Business Logic using SQL Scripts, PL/SQL, Database Packages, Procedures, Functions and Triggers.
• Write High Quality SQL, PL/SQL, and Shell Scripting code based on Business requirements.
• Exposed to various domains of Data warehouses like Insurance, Finance, Pharmaceutical and Sales
• Extensive experience in Offshore and Onsite model. Received good Customer feedback for timely delivery and fulfilled the expectations
• Extensive exposure in writing the UNIX Shell Scripts to automate the process.
• Handled critical job failures in the Production environment and Involved in fixing the data issues in the EDW database
• Hands on Experience using ITIL model, Supported Level1 & Level2 people on Production Issues and involved in tuning Informatica jobs as Performance group member under Level3 team.
• Involved in 24/7 on-call support for Info Factory, CDM, and CRM related jobs in Systems & QA & Production environments.
• Involved in Code Reviews & suggested best practices and presented Informatica new features in USER Group meetings.
• Hands-on experience using Informatica Power Exchange- in implementing CDC from VSAM systems, DB2 databases, Power Center Connect for SAP, expertise in installation, configuration and administration of Power Exchange.
• Well trained on Informatica Data Quality & Data Explorer tools.
• Good knowledge in Software Development Life Cycle (SDLC) and Quality Assurance Life Cycle
• Experience in analyzing, designing, developing Universes and Created different types of Business Objects reports
• Used Calculations, Variables, Sorted inputs, Drill down, Slice and Dice, Alerts for creating Business Objects reports
• Experienced in Creation and Modification of MSTR reports/queries, and Narrow Caster Runs - Monthly Production Runs
• Strong analytical, presentation, problem solving and excellent inter-personal communication skills and flexible to learn new technologies in the IT industry towards company’s success

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

ETL Tech lead

Responsibilities:

• Accountability for all applications under INFA Tower.
• Reassignment of tasks and tickets when required to keep overall tower healthy as possible.
• Provide Tower status on WSR calls.
• Maintaining relationship with Application team leads and Business stake holders.
• Technical and process assistance to team members as needed.
• Make sure all PROD Batch loads completed and not missed any SLA
• Gather repeated issues/Long running jobs and come up with solutions
• Responsible for updating Applications run book and KEDB on periodic basis.
• Responsible for all THR/TREX activities (end to end )
• Tracking all planned and unplanned releases and outages
• Mentoring all news resources and L1 resources
• Automate Adhoc tasks wherever it is possible
• On-Call support for all INFA/MS Applications
• Responsible for all UAT / PROD releases and handover calls
• Making sure all PTs / JIRAs are closed with in SLA timelines
• Responsible for Business Analysis and Requirements Collection and involved in Designing Technical Specification
• Transforming high-level design spec to simple ETL coding. Designing mappings according to the mapping standards, naming standards and warehouse standards for future application development
• Created Common objects for the ETL team to maintain the Common Code and Documented standards for Informatica code development
• Handled Offshore Teams and Co-ordinated with them on the ETL Development work efforts.
• Used Informatica to load data from Flat Files/ to DB2 database and extract data from different databases (Oracle, DB2, and SQL Server).
• Created Informatica mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy and Joiner transformations
• Involved in Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions
• Involved in Tuning critical Informatica jobs & database loader jobs.
• Guided the team to modify the logic to improve the performance of the maps.
• Created views which are refreshed On Demand for the Hyperion Reports.
• Wrote Shell scripts to get files from different servers.
• Modify existing mappings and write new programs as needed.
• Involved in Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions
• Involved in Tuning critical Informatica jobs & database loader jobs.
• Involved in data analysis and created reports using SQLs.
• Created Deployment groups and worked closely with DBAs to migrated Informatica code /database tables from Dev to QA and QA to Production.
• Crated and worked on Jade Items for Code fixes & data fixes.
• Performed Unit Testing and Integration Testing for Data Warehousing Applications and tuned for better performance
• Involved in Code Reviews & suggested best practices.
• Responsible for Business Analysis and Requirements Collection and involved in Designing Technical Specification
• Transforming high-level design spec to simple ETL coding. Designing mappings according to the mapping standards, naming standards and warehouse standards for future application development
• Created Common objects for the ETL team to maintain the Common Code and Documented standards for Informatica code development
• Used Informatica to load data from Flat Files to DB2 database and extract data from different databases (Teradata, oracle, SQL Server).
• Handled Commercial, Consumer, Mortgage, and Deposit loads in to MDM.
• Created Informatica mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy and Joiner transformations
• Created Complex SQL’s, PL/SQL Procedures to support MDM.
• Guided the team to modify the logic to improve the performance of the maps.
• Created Materialized views which are refreshed On Demand for the PB Dashboards.
• Wrote Shell scripts to get files from different servers.
• Created data loads from multiple data sources (DB2, Flat files) in to Teradata using BTEQ, and Fast load utilities.
• Modify existing mappings and write new programs as needed.
• Involved in Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions
• Involved in Tuning critical Informatica jobs & database loader jobs.
• Involved in data analysis and created reports using SQLs.
• Created Deployment groups and worked closely with DBAs to migrated Informatica code /database tables from Dev to QA and QA to Production.
• Crated and worked on Jade Items for Code fixes & data fixes.
• Performed Unit Testing and Integration Testing for Data Warehousing Applications and tuned for better performance
• Involved in 24/7 on-call support for MDM related jobs in Production environment.
• Involved in Code Reviews & suggested best practices.

Environment: INFORMATICA10.2/9.6.1, Informatica BDM, MDM, OBIEE, Hyperion, DB2, Oracle, Exadata, Teradata, Cloud, SSRS, SQL, PL/SQL, SQL Server, UNIX, AUTOSYS, OBIEE, Flat Files, Teradata SQL Assistance.

Confidential, Charlotte,NC

Sr Informatica/Database Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection and involved in Designing Technical Specification
• Created Common objects for the ETL team to maintain the Common Code and Documented standards for Informatica code development
• Used Informatica to load data from Flat Files to Oracle10g database and SQL server to Oracle.
• Created Informatica mappings using the transformations like Source Qualifier, Aggregator, Expression, Lookup, Router, Filter, Update Strategy and Joiner transformations
• Created several complex Informatica mappings as per business requirements and handled ETLs to load huge volume of data.
• Created reusable transformations and Mapplets and used them in complex mappings
• Created bulk data loads from multiple data sources in to Teradata using BTEQ, Multi load, and Fast load utilities.
• Crated Nested queries and fine-tuned long running queries.
• Identified and created the necessary indexes on the tables.
• Involved in Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions
• Involved in Tuning critical Informatica jobs & database loader jobs.
• Created Deployment groups and worked closely with DBAs to migrated Informatica code /database tables from Dev to QA and QA to Production.
• Crated and worked on Jade Items for Code fixes & data fixes.
• Performed Unit Testing and Integration Testing for Data Warehousing Applications and tuned for better performance
• Involved in support for MDM related jobs in Production environment.
• Involved in Code Reviews & suggested best practices and presented Informatica new features in USER Group meetings.

Environment: InformaticaV8.1/8.6, Oracle 10g, Teradata Utilities, MS Visual studio, SSIS, UNIX, Flat Files, Toad

Confidential

Sr ETL Developer

Responsibilities:

• Responsible for Business Analysis and Requirements Collection and involved in Designing Technical Specification
• Transforming high-level design spec to simple ETL coding. Designing mappings according to the mapping standards, naming standards and warehouse standards for future application development
• Created Common objects for the ETL team to maintain the Common Code and Documented standards for Informatica code development
• Involved in the creation and maintenance of the logical and physical data model using ERWIN tool.
• Extensively used UNIX based UDB loader scripts to load data from DB2 to XML files and DB2 tables to Flat Files.
• Used Informatica to load data from Flat Files/CSV files/XML files to DB2, DB2 to Flat Files.
• Created Informatica mappings using the transformations like Source Qualifier, XML SourceQualifier,Union,SQL Aggregator, Expression, Lookup, Router, Normalizer, Filter, Update Strategy and Joiner transformations
• Created several complex Informatica mappings as per business requirements.
• Created reusable transformations and Mapplets and used them in complex mappings
• Created Complex SQL’s, Stored Procedures to support Info factory, CDM & CRM related jobs.
• Involved in Creating, Validating, Testing and running the sequential and concurrent Batches and Sessions
• Involved in Tuning critical Informatica jobs & database loader jobs.
• Created Deployment groups and worked closely with DBAs to migrated Informatica code /UDB jobs from Dev to Systems Test
• Worked with Production support team on Sproj work for fixing data in Systems, QA, and Production.
• Crated SCCS & CMR tickets for Code migrations & data fixes.
• Performed Unit Testing and Integration Testing for Data Warehousing Applications and tuned for better performance
• Involved in 24/7 on-call support for Info Factory, CDM, and CRM related jobs in Systems & QA & Production environments.
• Involved in Code Reviews & suggested best practices and presented Informatica new features in USER Group meetings.

Environment: InformaticaV8.6.1, InformaticaRealTime, Oracle, OFSAA, DB2, UNIX, Flat Files, XMLFilesDBArtisan, Erwin, Maestro, Beyond Compare, RUMBA, SCCS, Reflex.