SUMMARY:

• Over 9 years of comprehensive experience in Data Warehouse/ Business Intelligence technologies helping clients align IT strategies with corporate strategic objectives across departments.
• Business Intelligence experience includes, working with major clients like Confidential, Confidential, Confidential which helped gain business knowledge in Banking, Manufacturing and Transport respectively.
• Expertise in design, development, and implementation of Extraction, Transformation and Load (ETL) techniques using Informatica Power Center.
• Extensive experience in Creating Universe and Generating Reports/Dashboards using Business Objects Web Intelligence, Crystal Reports.
• Ability to effectively communicate with all levels of management and lead complete project life cycles, from Requirements gathering, initial planning to User acceptance testing and deployment of ETL and Reporting systems.
• Seasoned Experience in Relational and Dimensional Data Modeling and data warehousing Architectures.
• Expertise in database design and methodology from multiple perspectives (user, designer, and developer)
• Excellent client - facing skills and worked on complete SDLC of the projects.
• Over 15 months of experience in working with end-users for Business Objects Universe Creation and Reporting requirements definition, development and support at Confidential, Tempe, AZ.
• Over 18 months of experience working directly with banking clients using Informatica Power Center, Performance Tuning and Code Optimization at Wellsfargo, San Leandro, CA.
• Good experience developing SQL, PL/SQL Stored Procedures, Packages, Functions, Cursors and Triggers.
• Extensive experience in Working with Informatica Power Center involving Workflow Manager, Work flow Monitor, Repository Manager, Source Analyzer and developed Source and Target layout, Mappings, Mapplets, Worklets and Transformations.
• Extracted data from Homogenous sources, Heterogeneous sources which includes RDBMS, Flat files - Fixed Width and delimited files.
• Experience in working with Various Informatica Tasks as in Session, Command, Email, Assignment, etc.
• Worked in Unix environment to create and execute scripts and to monitor the behavior of applications running at the back end (snapshots), perform and monitor load utilities.
• Additional experience and knowledge in SSAS, SSIS projects.
• Excellent technical, interpersonal/communication skills with great team ethics.

TECHNICAL SKILLS:

Application Development: Informatica Power Center Version 9.5, Business Objects XI R3 SSAS, SSIS, SSRS(2005)

Operating System: WINDOWS (NT, XP,VISTA, 7), UNIX

Databases / DB Tools: Oracle(8,9i,10g,11g), SQL Server

Methodologies / Techniques: Relational and Dimensional Data Modeling, Data Warehouse and Data Mart Design, UniverseReports/Dashboards using Business Objects

Network Software / Communications: Citrix, VPN

Testing Tools: Knowledge in Manual DW Testing using SQL

Languages: SQL, PLSQL, Unix Shell Scripting

Scheduling Tools: AUTOSYS

Other: Configuration - Pac2000, Microsoft Visual Source Safe (VSS), Share point

PROFESSIONAL EXPERIENCE:

Confidential, San Leandro, CA

Sr. ETL Developer

Environment: Informatica 9.5, Oracle, SQL, PL/SQL, Unix

Responsibilities:

• Designed and Implemented the Extraction, Transformation, and Load (ETL) techniques built using Informatica, SQL, PL/SQL and Unix Shell Scripting.
• Prepared the Logical Flow Diagrams as per Business requirement Document.
• Prepared the Technical design documents as per Business requirement Document.
• Developed Active and Passive Transformations in Informatica like Source Qualifier, Lookup, Router, Stored Procedure, Aggregator, Filter, Joiner, Expression and Sorter as per functional requirements.
• Developed mappings, workflows and Shell Scripts to extract, validate, transform data according to the business rules.
• Designed and developed the sessions for the relevant mappings or Informatica jobs and organized them as sequential / concurrent sessions.
• Scheduled the main workflows as per the business rules using the Informatica scheduler and done UNIX shell scripting for some of the existing data jobs.
• Developed Functions and Stored procedures for automating the backup of the target tables loaded after every run.
• Prepared the Table Scripts and loaded the data into the tables using data files.
• Performance tuning of the Informatica code .
• Automated the informatica jobs using UNIX shell scripting.
• NDM the Whasel and Whafam files from UNIX to Main Frame Sever.

Confidential

Sr. BO Developer

Environment: Business Objects XI R3, Informatica, Oracle

Responsibilities:

• Involved in requirements gathering and analysis for the entire application.
• Involved in complete SDLC of the application
• Analysis of requirements for designing the Universe for report creation.
• Analysis of requirements to convert the metrics to Web Intelligence reports.
• Designed the Universe for creating the Web Intelligence reports.
• Designed security and Involved in the creation of the Web Intelligence reports and Dashboard from Universe.
• Complete system testing of the reports and dashboard developed against the database.
• Developed and Reviewed design documents, test plans, user documentations and promotion documents.
• Responsible for carrying out the process/management related work of the entire module.

Confidential

Sr. Developer

Environment: SSAS,SSIS,SQL Server

Responsibilities:

• Analysis of requirement to create the final Common Allocation Report for India.
• Developed a process to load the Confidential and Caritor data from flat files to data warehouse tables using SSIS components like Sequence Containers, Data Flows, File System, FTP tasks, jobs using SQL Server Agent.
• Involved in the System testing of the ETL process and the report developed using SSRS.

Confidential

Team Lead

Environment: Business Objects XI R2 Designer, Web Intelligence, SQL Server, Oracle

Responsibilities:

• Involved in requirements gathering and analysis for the entire application.
• Involved in complete SDLC of the application.
• Analysis of requirements for designing the Universe for report creation.
• Analysis of requirements to convert the metrics to Web Intelligence reports.
• Involved in the design and creation of the Business Objects Universe using Designer and creation of Web Intelligence reports from this Universe.
• Complete system testing of the Universe and the reports developed.
• Co-ordination with the Onsite Export Control resources for the creation and testing of Export Controlled reports.
• Responsible for managing the team and carrying out the process/management related work of the entire project.

Confidential, Tempe, AZ

Sr. Developer

Environment: Business Objects XI R2, Informatica, Oracle, SQL, PL/SQL.

Responsibilities:

• Analysis of requirement to create the final Common Allocation Report for India.
• Involved in the design, development and support of Business Objects reports.
• Involved in the development of changes required in the Universe for the data marts of different Subject Areas.
• Interacted with the customer/ Confidential Subject Matter Expert (SME) to gather new requirements for the development and enhancement tasks.
• Estimated new requirements given by the customers.
• Conducted weekly status meeting to discuss with the customers about the project proceedings, issues handled and current enhancements executed in the project.
• Conducted weekly meeting with all the US Business Objects users to update the status of report issues.
• Involved in preparation of Functional Specifications (FS) which captures the detailed requirements discussed with the Confidential SME.
• Involved in the preparation and review of Technical Specification (TS).
• Worked on creating a process (workflows) using Informatica to load the data from Certido (Internal ticket tracking) database to the Reporting Data Mart.
• Provided maintenance and support for the Production Environment of the Aerospace databases for the Codes Developed using Informatica, DI and Procedures.
• Involved in creation of Business Objects reports for the SLA Metrics of Certido tickets.
• Analysis of requirements to convert the metrics available in spreadsheet to Web Intelligence reports
• Created Universe using Business Objects Designer and reports for daily, monthly metrics.
• Coordinate with the offshore team to assign tasks and help them with their clarifications on issues.
• Review of the offshore deliverables.
• Involved in regression testing and coordinating with customers for QA and production testing of reports.

Confidential

Informatica & BO Developer

Environment: Informatica, Business Objects Designer and Web Intelligence, Crystal Reports, Oracle

Responsibilities:

• Involved in requirements gathering and analysis for the entire application.
• Designing the Snowflake schema for loading the data for adequate reporting.
• Developed the Mappings, Sessions and Workflows in Informatica to populate the Star schema.
• Developed Universes using Business Objects Designer XI to suit the need for reporting.
• Created the Web Intelligence reports in Info view.
• Tested the mappings and the Web Intelligence reports.
• Worked in customizing browser based third party application (iMany Contract Manager Application).
• Involved in system enhancement and maintenance support of Contract Manager and Export Predominance systems.
• Identification of systems requiring enhancements & updating in light of changing business needs.
• Imparting Changes/Enhancements to such identified applications.
• Worked on creating a process (workflows) using Informatica to load Sales Order data from Phoenix, Tempe, Torrance, and Tucson to an Oracle database.
• Monitoring daily, weekly and monthly jobs running in remote systems.
• Fixed the defects faced while monitoring, using Oracle queries, stored procedures and Informatica scripts.

Confidential

Application tester

Environment: Oracle, Power builder

Responsibilities:

• Involved in Application testing of banking solutions product.
• Involved in Preparation of Test plans and Documentation of Test results.