We provide IT Staff Augmentation Services!

Delivery Lead/informatica Technical Sme - Lead/senior Developer/business Analyst Resume

Newark, NJ

SUMMARY:

  • An experienced Information Technology management professional with over 10 years of comprehensive experience in Data Warehousing / Business Intelligence environments.
  • Experience of multiple end to end data warehouse implementations, migration, testing and support assignments.
  • Hands on exposure to ETL using Informatica, Oracle and Unix Scripting with knowledge in Healthcare, Telecommunication and Retail Domains.

TECHNICAL SKILLS:

ETL/Reporting Tools: Informatica 10.1.0, Informatica 9.1.0, Informatica 8.6.1, Informatica 8.1.1, Informatica 7.0, Informatica Power Analyzer 4.1, Business Objects Designer 6.5, Cognos8, Hyperion System9

RDBMS: Oracle 11g, Oracle 9.2.0.6, Oracle 10g, Netezza 4.08.0, DB 2 4.6.0.556

Other Utilities: Oracle SQL developer 4.0.3.16, Oracle SQL developer 3.0.04, UNIX FTP client, Toad for Oracle 9.0, WinSql 6.0.71.582 , Text pad, Agility for Netezza Workbench, Netezza Performance Server, Informatica Admin console, Aqua Data Studio V9 etc.

Data Modeling: MS Visio 2007/2010

Operating Systems: MS Windows 7/2000/XP, UNIX, LINUS

Methodologies: Party Modeling, ER/Multidimensional Modeling (Star/Snowflake), Data Warehouse Lifecycle

Programming Languages: Visual Basic 6.0, C, C++, HTML, PERL Scripting.

PROFESSIONAL EXPERIENCE:

Confidential, Newark, NJ

Delivery Lead/Informatica Technical SME - Lead/Senior Developer/Business Analyst

Responsibilities:

  • Play the role of technical SME lead the team with respect to new technical design/architecture or modifying current architecture/code.
  • Strong troubleshooting skills, strong experience of working with complex ETL in a data warehouse environment Extensive experience in database programming in writing Cursors, Stored procedures, Triggers and Indexes.
  • Involved in Development and Testing of UNIX Shell Scripts to handle files from different sources such as NMS, NASCO, UCSW, HNJH, WAM, CPL and LDAP.
  • Involved in Performance tuning of Informatica mappings, sessions and DB Queries.
  • Involved in Creation of tables structures using PARTY Model.
  • Held responsible for end to end project delivery and played the primary role for the projects that I handled Delivery responsibilities
  • Involved in profiling of Source data samples and Generate Mapping documents for the projects I played business analytic roles.
  • Walkthrough of Project Design, PA/Class B/Final Estimates with the business for Client Review and Approval.
  • Studied the requirements from the technical requirement document and prepared the low-level design document with business rules.
  • Review of ETL Code, DB Scripts, Deployment document, Unit test cases, Results and Walkthrough of the same with the Clients.
  • Deployment of ETL/Database and Unix Components to SIT/ UAT / PREPROD and support the respective testing and execution.
  • Conduct and Co-ordinate Defect Triage discussions with SQA and UAT COE teams.
  • Project Deployment/Warranty Support.
  • Assist the team to provide clarifications in design and resolve issues during development and testing
  • Development and Testing of NMS & NASCO Demographics mappings, sessions and workflows with Unit Test Cases and Results
  • Extensively used all Informatica Transformations like WSDL, XML Parser, XML Generator, Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier during development of ETL mappings.
  • Implemented Slowly Changing Dimensions - Type I & II in different mappings as per the requirements. load the target tables.
  • To perform Tickets monitoring, job monitoring and address any job failures or new incidents
  • Prepare Ageing Report, Weekly Metrics report, Monthly Metrics report and Provide Audit Support
  • To communicate Job notifications/ delays to Parallel and Downstream systems and Attend the Client conference calls with respect to Critical and High priority tickets to take corrective actions
  • Lead the Offshore Support team and Ensure proper support shift plans and activities are in place
  • Excellent technical and professional client interaction skills. Interacted with both Technical, functional and business audiences across different phases of the project life cycle

Environment: Informatica Power Center 10.1.0, Oracle 11g, Oracle SQL developer 4.0.3.16, UNIX Shell Scripting, WINSCP 5.7.7, AIX/Windows 7

Confidential, Newark, NJ

Informatica ETL Developer/Business Analyst/Team Lead

Responsibilities:

  • Used Informatica client tools - Source Analyzer, Warehouse designer, Mapping Designer, Mapplet Designer, and Transformation Developer for defining Source & Target definitions and coded the process of data flow from source system to data warehouse.
  • To collect and study the BRD requirements and prepare DLD that should include all the existing business rules
  • Track all requirement clarifications through regular update calls with onsite and in corporate the same in the DLD
  • Identifying and designing a new Physical / Logical Modeling as per business need with futuristic purposes.
  • Development/Testing of I care-Care core and MOM mappings, sessions with proper Unit Test Cases and Results
  • Extensively involved XML Transformation, Joiner, Aggregator, Update Strategy, Rank, Router, Lookup, Sequence Generator, Filter, Sorter, Source Qualifier transformations.
  • Created a Reusable asset to generate email reports on the erroneous records for every source system from the respective error table with different subject line.
  • Technically lead the team from offshore and help the team to provide clarifications in design and resolve issues during development and testing
  • Provide Deployment document and Warranty Support for Provider - Outbound

Environment: Informatica Power Center 9.1.0, Oracle 11g, Oracle SQL developer 3.0.04, UNIX Shell Scripting, WINSCP 5.7.7, AIX/Windows 7

Confidential, Pittsburgh, PA

Informatica ETL Developer/Team Lead

Responsibilities:

  • To collect and study the requirements from BRD.
  • Technically lead the team from offshore and help the team to provide clarifications in design and resolve issues during development and testing
  • Actively involved in performance tuning and rebuilding some indexes.
  • Performed robust testing, unit testing, negative testing and then handed over the data to QA team.
  • Analyzed the existing mapping with the shrinkage mapping and Involve in the mapping merge process.
  • Involved in Identifying the performance/data discrepancy bottlenecks of 2 largely complex mappings as per the business requirement and help fixing a business-critical issue.
  • Perform Unit/Integration testing and capture the Unit Test Results.
  • Prepare the Traceability Matrix details of this project.

Environment: Informatica Power Center 8.6.1, Tool for DB 2 4.6.0.556

Confidential, Matawan, NJ

Informatica ETL Developer/Team Lead

Responsibilities:

  • Technically Lead the team from Analysis phase to Deployment/Warranty support
  • To study the DLD and identify design flaws and share with the design team for correction.
  • Prepare UTC, new Parameter files, develop 21 new mappings, modified 5 mappings, audit alert script sessions and Workflows with in a span of 6 months supporting multiple projects in Agile mode.
  • Using oracle hints for better performance on SQL override queries
  • Created Informatica PowerCenter mappings to create various Type 1 and Type 2 mappings using transformations like Joiner, Lookup, Router, Filter, Union, Sequence Generator, Aggregator and Expression
  • Optimization/performance tuning techniques implemented to identify bottlenecks- Query tuning (Explain Plan, SQL Trace), table partitioning, session partitioning, pushdown optimization, memory tuning and cache management.
  • Present the code for internal and external reviews and incorporated the review comments.
  • Perform UNIT/INTEGRATION testing and UAT data setup for the client validation.
  • Prepare/Present the Operation Manual, deployment document to the client and downstream team
  • Prepared pre and post session commands to send email notifications using Informatica Workflow Manager and renaming files in UNIX
  • Documenting various ETL standards to be followed which include both Informatica and Oracle Design standards
  • Perform Pre-Release tasks and provide the warranty support

Environment: Informatica Power Center 8.6.1, Business Objects XI 3.1, Netezza Twin fin V6.0.3 P5 SQL Server 2008

Confidential, Chicago, IL

Application SRM / Production support Executive

Responsibilities:

  • SRM for GSM and Confidential support application.
  • Monitoring GSM Jobs, Confidential Jobs, Power Analyzer server, BMC tickets and Handle Failures
  • Provide new user access for power analyzer and power center.
  • Implement GSM Enhancements - Penang Project, GSM Network separation project, Confidential SOX Compliance project and do presentation about the projects to the NSN /Client team.
  • Perform Active Directory testing and Disaster Recovery process for GSM and Confidential application

Environment: Informatica 7.0, Power Analyzer 4.1, Oracle 9.2.0.6

Confidential

Production Support Executive

Responsibilities:

  • Performing Pre Checks and Monitor Jobs and ensure if the daily loads are loaded properly and within the SLA.
  • Kill database/Informatica locks
  • Raise remedies to the source team when there is an issue with respect to the source system.
  • Ensure Reporting data available for business to run the reports.
  • Perform System Improvement Performance tasks to increase the performance of the daily ETL loads.
  • Fix the bugs encountered through deep analysis and ensure the data is correct.

Environment: Informatica 8.1, Oracle 10g, Netezza 4.0.8.0

Confidential

Informatica ETL Developer

Responsibilities:

  • To Study the BRD and understand the new workflow and mappings, Prepare Detailed Design document of all new workflows
  • Worked on dimensional modeling to Design and develop STAR Schemas, identifying Fact and Dimension Tables for providing a unified view to ensure consistent decision making
  • Create and Implement the new DB Scripts to create new fact, dimension tables in ORACLE, NETEZZA databases
  • Create new parameter files, XML source mappings , sessions, workflows and perform UNIT and Integration Testing
  • Restructure and Design new workflows from baselined guidelines and perform UNIT/INTEGRATION testing, QA data setup to run the old/new workflow in QA environment
  • Design 2 new business reports , for sales and products using business objects designer 6.5
  • Perform Pre-Release tasks and provide the warranty support to ensure smooth functioning of the workflows and stability of the Database in the live environment by interim prechecks and post monitoring.

Environment: Informatica 8.1.1, Business Objects Designer 6.5, Microsoft Office Visio 2003, Oracle 10 g, Netezza 4.0.8.0

Confidential

Informatica ETL Developer

Responsibilities:

  • Created mappings in Informatica that monitors the long running sessions using Informatica OPB Metadata repository tables
  • Created Unix Scripts to generate and sending an alert email to the support team about the long running session.
  • To Work on the Documentation part of the Tool that includes HLD, DLD and the Tool Template for submitting to the Organization Tools group

Environment: Informatica 8.1.1, Oracle 10g, Toad for Oracle

Hire Now