We provide IT Staff Augmentation Services!

Bi Project Lead Resume

0/5 (Submit Your Rating)

San Jose, CA

SUMMARY

  • Over 12+ years of IT experience in the field of ETL Development & Designing, Data warehouse Development, Data Modeling, Business/Data analysis, Project Management, Business Intelligence and development of application software in Web - Based environment, distributed n-tier and Client/Server environments.
  • 11+ years of ETL and data integration experience in designing and developing ETL mappings and scripts using Informatica PowerCenter 9.1/8.x/7.x versions.
  • 10+ years of experience in design and development of ETL process from databases such as Oracle, SQL server, Salesforce, SAP, Teradata, Sybase and Flat files sources.
  • 11+ years of UNIX shell scripting(Korn and Bash) experience for developing wrapper scripts for ETL jobs and for creating environment files, to create the jobs and job streams(schedules) for daily runs.
  • 11+ years of Strong proficiency in writing SQL (including ORACLE, SQL Server, Teradata, Sybase IQ).
  • 7+ years of good exposure on optimizing the SQL and performance tuning.
  • 8+ years of Team Lead Experience with expertise in leading team for development/ maintenance projects, handling small to large team, effort estimation, impact analysis for change request, task allocation to Team Members, and resolving technical issues of the Team Members
  • 9+ years of extensive experience on DataWarehousing concepts like Star Schema, Snow Flake, Dimension and Fact tables and Slowly Changing Dimensions.
  • Experience in working with different business systems like Salesforce, SAP, Mainframes etc.
  • Thorough understanding of Software Development Life Cycle (SDLC) including requirements analysis, system analysis, design, development, documentation, training, implementation and post-implementation review.
  • Extensive experience with ETL tool Informatica in designing the Workflows, Worklets, Tasks and Mappings, scheduling and monitoring the Workflows and sessions using Informatica PowerCenter 9.1/8.x/7.x
  • Experience in optimizing and performance tuning of Mappings and implementing the complex business rules by creating re-usable transformations, Mapplets and Tasks.
  • Knowledge on Business Objects Reporting Tool.
  • Knowledge of Teradata BTEQ, Fast Load, Fast Export and MLOAD scripts
  • Developed test strategies and plans for Unit, Integration, System and User Acceptance Testing.
  • Developed ETL migration documents and operation manuals for migrating in various environments
  • Extensive experience in Production Support of Data Warehousing System
  • Extensive knowledge of Informatica PowerCenter 8.x/7.x/6.x administration
  • Extensive Knowledge of RDBMS concepts, PL/SQL, Stored Procedure and Normal Forms.
  • Good Knowledge of DollarU tool for scheduling the jobs.
  • Good Knowledge of PVCS - Polytron Version Control System, used for version control management.
  • Good knowledge of Kintana tool, used for Configuration management.
  • Knowledge of C, C++, Java, SQL programming and Perl Scripting.
  • Familiar with building end to end solution, onshore-offshore model and multi site development projects, System Integration, migration, maintenance and Support projects
  • Experience on working with Client, Customer and User interfacing projects
  • Team player and self-starter with good communication and inter-personal skills.
  • Organized professional with immensely strong leadership capabilities.

TECHNICAL SKILLS

Data Warehousing: Informatica PowerCenter 9.1/8.5/7.1/6.2 (Source Analyzer, Data Warehouse Designer, Mapping Designer, Mapplet, Transformations, Workflow Manager, Workflow Monitor, Worklets ), Data cleansing, OLAP, Star Schema, Snowflake Schema, OLTP, SQL*Plus, SQL*Loader, DTS Package.

Data Modeling: Dimensional Data Modeling, Star Join Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables, Physical and Logical Data Modeling, Slowly Changing Dimensions, Master Data Management.

Front-end tools: TOAD 7.x, SQL Server Management studio, Eclipse 7.x, Visual studio 6.0.

Databases: Oracle 10i/9i, SQL Server 2005, MS Access 7.0/97/2000, Teradata V2R5/V2R4.

BI & Reporting Tools: Business Objects XI/6.0 (Web-Intelligence 2.5, Designer 5.0, and Developer Suite & Set Analyzer 2.0) Data Reports.

GUI: MS Excel, MS Word, Visio.

Programming: SQL, PL/SQL, SQL*Plus 3.3/8.0, Java 1.4, HTML, DHTML, C, C++, Java, J2EE, Struts framework, Perl Scripting, Java Scripting, UNIX Shell Scripting.

Environment: Windows 7/XP, Windows server 2008/2003, Sun Solaris 9/8/7/2.6/2.5, AS/400, SCO-UNIX, LINUX, WinNT4.0, MSDOS.

PROFESSIONAL EXPERIENCE

Confidential, San Jose, CA

BI Project Lead

Responsibilities:

  • Performing the relevant project management processes - i.e. initiate, plan, execute, monitor and control and close, and the supporting processes e.g. scope, cost, time, issue, risk, resource, communication, stakeholder management.
  • Managing project work, recruitment and resources to enable successful and timely completion of the project including performing gate reviews and quality assurance reviews with all aspects of IT organization and business sponsors.
  • Worked with business users to identify, understand and build the data model.
  • Interacted with business analysts, data architects, application developers to develop a data model.
  • Interfacing and communicating with project teams, management, customers and stakeholders including implementing and working through defined governance processes.
  • Managing multiple development teams, ETL, BO, QA etc. and coordinating with other cross-functional teams like Performance, release management etc.
  • Responsible for providing the timely status reports, addressing technical issues and facilitating design.

Environment: Informatica Powercenter 9.5, Business Objects, Teradata, Oracle, Toad, Windows 7.

Confidential, Palo Alto

Informatica Admin / Architect

Responsibilities:

  • Project Lead for the upgrade of Informatica Powercenter from 8.6.1 to 9.1 HF4.
  • Informatica Administrator, performing the installation and configuration of the Informatica powercenter servers on the Linux servers.
  • Migrated and upgraded the code from old to new servers for all the DEV/QA/UAT/PROD environments.
  • Designed, installed and configured the UAT and PROD environments to run the Informatica servers ON GRID with 2-nodes.
  • Managing the development and test teams to test the upgraded code and deliver the environments to the respective teams.
  • Delivered the project by having good working relationship with the developers, testing team, architects, change managers and support teams.
  • Responsible for providing the timely status reports, addressing technical issues and facilitating design.
  • Worked with the Informatica Product support to troubleshoot issues and provide expert help to the Confidential DSS team.

Environment: Informatica Powercenter 9.1/8.6.1, PowerExchange for Oracle, Informatica Data replication (IDR), Oracle 11g, MS SQL server 2008, Salesforce, Toad, Putty, Shell scripting, Windows 7, Redhat Linux, Cent OS.

Confidential, San Francisco

Informatica Admin / Support Lead

Responsibilities:

  • Informatica in Dolby is mainly used as an Integration tool across different applications.
  • Extensively used Informatica PowerCenter 9.1 to integrate data between Salesforce to SAP and other internal/external applications.
  • Managed the project of upgrading the Informatica tool to 9.1 HF2 (latest version) from 8.5.1 version.
  • Interacting with the cross-functional teams and business analysts to define, analyze, and deliver customer requirements.
  • Responsible for understanding business/user requirements and converting those requirements to appropriately designed solutions.
  • Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and other database related issues.
  • Leading the Production support teams and the development teams for Integration related projects.
  • Provide timely status updates to the higher management.

Environment: Informatica Powercenter 9.1/8.5.1, PowerExchange for Salesforce, Informatica on-Demand, MS SQL server 2005, Salesforce, SAP, SAP PI, Windows 7, Windows Server 2008.

Confidential, San Jose, CA

Sr. Informatica Developer and Migration Team Lead

Responsibilities:

  • Worked with business users to identify, understand and design data Models and the business model.
  • Interacted with business analysts, data architects, application developers to develop a data model.
  • Worked closely with the project team to formulate and implement a flexible system design that meets functional requirements.
  • Prepared mapping documents and technical specifications.
  • Analyzed warehouse statistics to accommodate organic growth besides facilitating new Inventory details in the warehouse.
  • Extensively used ETL to load data from different source systems like Teradata Objects, Oracle, Flat files, etc., into the Staging table and load the data into the Target database.
  • Implemented slowly changing dimensions according to the requirements, Partitioned sessions, modified cache/buffers and tuned transformations for better performance.
  • Developed and supervised in the automation of master data loads and data conversion cutover plan, assisted client IT members in creating BDC sessions and data mappings.
  • Collaborated with data modelers, ETL developers in the creating the Data Functional Design documents.
  • Created the Staging mappings for delta detection using the different Transformations (Expression, Lookup, Joiner, Filter, Router, Stored Procedure etc.)
  • Worked with mapping variables, Mapping parameters and variable functions like SetVariable, SetCountVariable, SetMinVariable and SetMaxVariable.
  • Metadata Manager is used to link all the metadata from sources and to give a complete exploration for the business with customized views.
  • Installed, configured and administered the components of the Informatica Software like pmserver, repository server and Informatica repository client tools for efficient performance.
  • Wrote UNIX shell scripts to automate the data transfer (FTP) process to and from the Source systems.
  • Designed and Developed UNIX shell scripts as part of the ETL process to schedule tasks/sessions.
  • Coded and implemented PL/SQL packages to perform Application Security and batch job scheduling.
  • Created the DollarU jobs to automate the process and to scheduling the Informatica jobs and shell scripts.
  • PVCS - Polytron Version Control System, is used extensively for Configuration management purposes to store the versions of SQL scripts, Informatica code, DollarU jobs etc.
  • Quality Center - is used for tracking the defects, maintaining and running the test cases.
  • Extensively used Kintana tool for creating the packages and migrating the code.
  • TOAD - is used extensively for connecting to Oracle databases and running the SQL scripts and PL/SQL jobs.
  • Created several Mappings to validate the Data Quality Framework (DQF).
  • Was involved in the performance tuning of the queries using the stats and tune the queries for the optimal time frame.
  • Conducted Data profiling prior to extraction and during building mappings to assess data quality.
  • Developed and used re-usable transformations and mapplets extensively to simplify development and maintenance.
  • Wrote Pre and post session Shell scripts for extracting data from files, remove duplicates and sorting in the database to optimize performance.
  • Performed Unit testing during the mapping phase to ensure proper and efficient implementation of the transformations.
  • Played a key role in the entire project by handling the most key applications in the project.
  • Involved in fixing invalid mappings as well as remove logical errors using the Informatica Debugger.
  • Involved in Preparing Unit test cases and testing ETL process.
  • Involved in Co ordinating with onsite and offshore team members.

Environment: Informatica 8.x, PowerCenter Workflow Manager, Monitor, Mapping Designer, Repository Manager, Teradata, Oracle 10g, UNIX, Shell scripting, Windows XP, SQL, PL/SQL, DollarU, PVCS, Quality Center, Kintana, TOAD, MS Office.

Confidential, Emeryville

Sr. ETL Developer and Team Lead

Responsibilities:

  • Requirement gathering and Business Analysis.
  • Analyzed the functional specs provided by the data architect and created technical specs documents for all the mappings.
  • Converted the data mart from Logical design to Physical design, defined data types, Constraints, Indexes, generated Schema in the Database, created Automated scripts, defined storage parameters for the objects in the Database.
  • Defined various facts and Dimensions in the data mart including Fact less Facts, Aggregate and Summary facts.
  • Reviewed source systems and proposed data acquisition strategy.
  • Designed and Customized data models for Data Mart supporting data from multiple sources on real time.
  • Analyzed both the source systems - Legacy and new commerce platform to map the data into data warehouse accordingly.
  • Designed and developed Informatica Mappings to load data from Source systems to ODS and then to Data Mart.
  • Extensively used Power Center/Mart to design multiple mappings with embedded business logic.
  • Creation of Transformations like Lookup, Joiner, Rank and Source Qualifier Transformations in the Informatica Designer.
  • Created complex mappings using Unconnected Lookup, Sorter, Aggregator, newly changed dynamic Lookup and Router transformations for populating target table in efficient manner.
  • Created Mapplet and used them in different Mappings.
  • Provided Knowledge Transfer to the end users and created extensive documentation on the design, development, implementation, daily loads and process flow of the mappings.
  • Performance tuning of the Informatica mappings using various components like Parameter files, Variables and Dynamic Cache.
  • Performance tuning using round robin, hash auto key, Key range partitioning.
  • Used shell scripts for automating the execution of maps.
  • Designed and developed Oracle PL/SQL scripts for Data Import/Export.
  • Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process. Maintained the batch processes using Unix Shell Scripts.
  • Designed and Deployed UNIX Shell Scripts.
  • Managed Change control implementation and coordinating daily, monthly releases and reruns.

Environment: Informatica Power Center 8.x, Workflow Manager, Workflow Monitor, Informatica Power Connect / Power Exchange, Power Analyzer, BO XI, PL/SQL, Oracle 10g/9i, Sybase, Sybase IQ, SQL Server 2005/2000, SQL server BI services, HP-UX 10.20, Windows Server 2003, Toad.

Confidential, San Jose

Sr. Data warehouse Analyst /Program Manager

Responsibilities:

  • Involved in the design of Informatica, Business Objects and the other Database systems.
  • Interacted effectively with the operations team to get the network settings properly setup so that there is a smooth run when the goods were delivered.
  • Extensively used Informatica PowerCenter 8.1.1 to extract data from various sources and load in to staging database.
  • Extensively used transformations such as Source Qualifier Aggregator Expression Lookup, Router, Filter, Update Strategy Joiner Transaction Control and Stored Procedure.
  • Developed Informatica mappings and mapplets and also tuned them for Optimum performance Dependencies and Batch Design.
  • Extensively worked with Informatica - Source Analyzer Warehouse Designer Transformation developer Mapplet Designer Mapping Designer Repository
  • Manage Workflow Manager Workflow Monitor Repository server and Informatica server to load data from flat files legacy data.
  • Designed the mappings between sources (external files and databases) to operational staging targets.
  • Worked with pre and post sessions and extracted data from Transaction System into Staging Area. Knowledge of Identifying Facts and Dimensions tables.
  • Tuned sources targets mappings and sessions to improve the performance of data load.
  • Implemented Slowly Changing Dimension methodology.
  • Created Several Informatica Mappings to populate the data into dimensions and fact tables.
  • Maintaining the bugs in the bug tracker tools based on their severity.
  • Analyzing and tracking the Test Results document and Bug reports using Quality Center 9.0.
  • Developed Perl Script for loading of Data from Source to Target.
  • Maintained Versions of Mappings Mapplets Sessions Workflows etc using StarTeam/Accurev.
  • Worked cooperatively with the team members to identify and resolve various issues relating to Informatica and other database related issues.
  • Designed and Developed Oracle PL/SQL Procedures and UNIX Shell Scripts Data Import/Export and Data Conversions.
  • Designing mapping templates to specify high level approach.
  • Involved in Unit testing and documentation.
  • Provided production support for Business Users and documented problems and solutions for running the workflow.

Environment: Informatica 8.1.1, Business Objects 12.x, Oracle 10g, Sun Solaris, Windows XP.

Confidential

Quality Analyst

Responsibilities:

  • Analyzed the complete master data of the Data warehouse.
  • Analyzed warehouse metadata, naming standards and warehouse standards for future application development.
  • Used Dataflux tool to generate the Quality reports on all the master tables.
  • Data Quality Analysis to determine cleansing requirements.
  • Generated graphical reports and presented the same to higher management.
  • Analyzed the upstream transaction systems and suggested good ETL practices.

Environment: Dataflux, Oracle 9i, MS Office, MS Access, MS Powerpoint, Windows.

Confidential, San Jose

Technology Lead

Responsibilities:

  • Was involved in preparing ETL requirement documents and designing and documenting the ETL process.
  • Conducted Data profiling prior to extraction and during building mappings to assess data quality.
  • Worked extensively on transformations such as Lookup, Aggregator, Expression, Joiner, Filter, Rank, Update Strategy, and Sequence Generator, XML Source Qualifier and performed performance tuning of ETL process.
  • Developed and used re-usable transformations and mapplets extensively to simplify development and maintenance.
  • Used Workflow Manager for creating, validating, testing and running sequential and concurrent batches and sessions and scheduling them to run at specified time.
  • Wrote Pre and post session Shell scripts for extracting data from files, remove duplicates and sorting in the database to optimize performance.
  • Improvised query performance by using explain plan.
  • Improved performance by creating materialized views.
  • Created mappings for Type2/Slowly Changing Dimensions for updating and inserting of records and in turn maintaining history.
  • Mappings for aggregate table and fact table population, currency conversion etc.
  • Performed Unit testing during the mapping phase to ensure proper and efficient implementation of the transformations.
  • Involved in Fixing invalid mappings as well as remove logical errors using the informatica debugger.

Environment: Informatica PowerCenter 8.1, Oracle 9i, SQL *PLUS, PL/SQL.

Confidential

Sr. Programmer

Responsibilities:

  • The Project is a Hotel Intranet system which provides functionalities like, providing info, booking seats in Restaurants, Party/Function halls, interacting with different departments in the hotel like travel desk to book tickets, Laundry, Kitchen and providing internet facilities like E-Mail, chatting, browsing etc.
  • Part of the team to develop and test the server side application.
  • Interact with the GUI team and design/develop the pages accordingly.
  • Design/develop the database related tables.
  • Implement the server side functionality for all the transactions.
  • To test the overall application and resolve the bugs.

Environment: PHP, HTML, JavaScript, Red Hat Linux, MySQL.

Confidential

Responsibilities:

  • The Project is a Hotel Intranet system which provides functionalities like, providing info, booking seats in Restaurants, Party/Function halls, interacting with different departments in the hotel like travel desk to book tickets, Laundry, Kitchen and providing internet facilities like E-Mail, chatting, browsing etc.
  • Part of the team to develop and test the server side application.
  • Interact with the GUI team and design/develop the pages accordingly.
  • Design/develop the database related tables.
  • Implement the server side functionality for all the transactions.
  • To test the overall application and resolve the bugs.

Environment: PHP, HTML, JavaScript, Red Hat Linux, MySQL, Java, MS-Access.

We'd love your feedback!