We provide IT Staff Augmentation Services!

Project Technical Lead Resume

SUMMARY

  • Having 13 years of professional IT experience in all the phases of software development life cycle including requirement study, system design, data modelling, development, implementation, testing and production support of various business applications.
  • Expertise in Data Warehousing and Business Intelligence applications using Informatica, UNIX, DB2, Oracle, Teradata, OBIEE, Cognos, MicroStrategy.
  • Expertise in designing and coding stored procedures, functions, triggers, cursors, packages using PL/SQL
  • Strong SQL coding knowledge and Performance tuning skills
  • Experience in using the d atabase tools like Teradata SQL assistance, TOAD, SQL*Plus, SQL*Loader, Oracle Export/Import, Oracle SQL Developer, PL/SQL developer
  • Good working knowledge and experience in writing UNIX Shell Scripts

TECHNICAL SKILLS

  • Informatica V9.1, OBIEE, Microstrategy, Cognos 8, Cognos Impromptu, Power Play
  • DB2, Oracle, Teradata
  • SQL, Oracle PL/SQL, UNIX Shell Scripting
  • Teradata SQL assistance, Toad, PL/SQL Developer, SQL *Plus, Oracle SQL Developer, Microsoft Visio
  • CVS, Tortoise SVN, VSS
  • UNIX, Windows XP

PROFESSIONAL EXPERIENCE

Confidential

Project Technical Lead

Responsibilities:

  • Design, development and maintenance of Enterprise Data Warehouse (EDW) using Informatica, DB2, UNIX for JC Penney’s .com business.
  • Development, maintenance and support of JC Penney’s BI applications like Infovision, HR Datamart, OBIEE and Microstrategy applications.
  • Provide L2 and L3 support for 3000+ batch jobs, business queries as per the agreed SLA
  • Handling batch failures, providing bug fixes, and enhancing the applications based on the business requests
  • Handling year end realignment to incorporates changes in merchandise hierarchy and location hierarchy during the end of the fiscal year.
  • In corporate the new business requirements (work requests) in existing Informatica workflows, mappings, sessions, etc
  • Creating workflows, Sessions, Mappings using Informatica PowerCenter ETL tool
  • Extensively used the transformations Source qualifier, Expression, Sorter, Joiner, Aggregator, Lookup, Stored Procedure, Transaction Control, Normalizer, Data Masking, XML transformations in the mappings and also modify existing mappings to resolve production issues
  • Used Informatica PowerExchange tool for accessing Mainframe datasets
  • Generate Microstrategy Reports by creating Schema and Public Object like attributes, facts, hierarchies, metrics, filters, Transformations, custom groups and Consolidations.
  • Troubleshooting MicroStrategy prompt, filter, template, consolidation, and custom group objects in an Enterprise Data Warehouse environment.
  • Design Prompts and Filters in Microstrategy to generate reports in grid and graph mode.
  • Act as a data analyst and answer business by analyzing the reports designed in OBIEE and Microstrategy
  • Analyzing the root cause and provide permanent fixes for repeated job failures based on the problem incidents
  • Develop or modify existing PL/SQL procedures, packages, functions per the given requirement and execute the same using TOAD and PL/SQL developer
  • Involved in Oracle PL/SQL debugging and support and also in performance tuning activities
  • Maintain and administer the corporate databases
  • Provide value addition to the business by suggesting changes which increase the usability of the system
  • Providing business easy access to all the products in the application
  • Being an onsite lead, ensured active communication between client and development team
  • Tracking the progress of the project deliverables, coordinating offshore team, status report to the customer

Environment: Informatica, Oracle PL/SQL, Microstrategy, OBIEE, UDB DB2 V9.5, IBM AIX, Mainframes, DB2, UNIX, Teradata SQL assistance, ESP scheduler, BMC remedy, Tortoise SVN, JIRA

Confidential

Project Technical Lead

Responsibilities:

  • Majorly involved in migrating legacy scripts into Informatica ETLs
  • Involved in data modeling using Star and Snowflake schemas.
  • Extensively used all popular transformations in Informatica mappings
  • Identify performance bottlenecks at source, target, mapping, session, database levels
  • Implement Informatica best practices for perform optimization
  • Prepare high level and low level design using IBM rational rose tool
  • Design and development of various dimension and fact tables.
  • Involved in client discussions and requirements gathering
  • Preparing and maintaining Application Maintenance Manual (AMM)
  • Design of High level design and technical specification document
  • Report creation and enhancement using Cognos Report studio
  • Developed Multidimensional Models in Power - Play Transformer and generated Power Cubes for OLAP comprising of dimensions, hierarchies, levels, categories, and measures in Cognos
  • Modified Power Cubes by adding new Dimensions, Levels, Categories and Measures.
  • Validate and test reports in Query Studio and Analysis Studio.
  • Build Dashboards in report studio using combination of List, Crosstab, and Graph and Map reports.
  • Performance tuning of report with huge queries using concurrent query execution for better performance of report.
  • Root cause analysis for the defects logged in Quality Mercury Center tool and resolving the same at Cognos level
  • Build the objects like stored procedures, function, packages, Cursor, Ref Cursor and Triggers using PL/SQL in Oracle environment
  • Oracle PL/SQL debugging, support and performance tuning activities
  • Resolving the tickets raised by the customers in the HEAT tool
  • Unit Testing, System Testing and UAT data preparation
  • Preparation of Unit and System Test Plans
  • Performed IQA - Internal Quality Audit
  • Being an offshore coordinator, managed the team of ten members and update the onsite team and clients about the status of the project on regular basis
  • Review as well code the PL/SQL program and Informatica mapping and made sure they are defect free and efficiently coded by doing performance tuning
  • Would also act as a data analyst and verify if the data was flowing correctly per the business requirement
  • Involved in production release and project delivery activities

Environment: Informatica 8.1, Cognos, Oracle PL/SQL, TOAD, UNIX, PL/SQL developer, Microsoft Project, IBM Rational rose

Confidential

Senior Informatica Developer

Responsibilities:

  • Part of the requirement discussion group
  • Developed High level design and technical specification document using Rational rose tool
  • Build, Review the oracle PL/SQL objects
  • Developed Informatica workflow, sessions, mappings using most popular transformations.
  • Involved in performance tuning activity for the Informatica mappings/sessions developed
  • Built ETL Feeds and Teradata Unix Scripts
  • Monitoring the scheduled jobs and fix the same in case of any failure
  • Involved in FTP of inbound and outbound files
  • Preparation of Unit and System Test Plans
  • Involved in load testing
  • Mentoring the team members
  • Involved in onsite and offshore co-ordination activities
  • Follow up with testing team during integration testing and system testing

Environment: Informatica PowerCenter (7.1),Oracle 9i, PL/SQL, TOAD, UNIX, IBM Rational RoseTeradata

Confidential

Senior Informatica developer

Responsibilities:

  • Involved in design and implementation by gathering the requirements from business
  • Built Teradata Unix Scripts
  • Used Informatica extensively for building workflows, worklets, mappings, sessions
  • Also involved in performance tuning activity
  • Developed and performance tuning Oracle PL/SQL packages, procedures, functions and triggers
  • Performed Oracle database tuning and SQL statement tuning
  • Created UNIX shell scripts to solve simple and complex issues
  • Used Advanced Oracle PL/SQL techniques like cursors and bulk collect for data retrieval
  • Created indexes, materialized views and partitioning of tables for SQL Tuning
  • Involved in production support and maintenance activity too
  • Being an offshore coordinator, was managing the team of seven members
  • Would keep client updated on development progress and issues faced by the team
  • Preparation of Unit and System Test Plans
  • Unit Testing, System Testing and UAT data preparation

Environment: Informatica (7.1), Teradata, Oracle PL/SQL, TOAD, Oracle SQL developer, UNIX

Confidential

Senior Informatica Developer

Responsibilities:

  • Part of the requirement analysis team and gathered the requirements and converted them into technical specifications for developers to start coding
  • Responsible for Database design and creating database tables.
  • Used PL/SQL to process handle for automate extract data from Oracle SQL table
  • Developed database triggers and stored procedures using Oracle PL/SQL cursors and tables
  • Analyzing design documents and deriving the business logic
  • Used Informatica for ETL processing and to develop mappings, workflows and sessions
  • Monitor scheduled jobs in Informatica workflow monitor and fix the job failures if any
  • Creating the reports using Cognos Impromptu tool
  • Generating the Cubes using Cognos Powerplay tool
  • Performed unit testing at the desktop level to check the compliance with client requirements.
  • Performing detailed system testing of the Reports and Cubes.
  • Provided maintenance support to the application as per the agreed SLA
  • Resolved the direct customer issues with stringent SLA time
  • Preparing unit and system test case documents and the Report Documentations
  • Managed a team of four members

Environment: Informatica 7.1, Cognos Impromptu, Power Play Transformer, Oracle PL/SQL, UNIX

Hire Now