We provide IT Staff Augmentation Services!

Technical Project Manager Resume

Irvine, CA

PROFILE:

A versatile and skilled IT professional specializing in Data Warehousing and Business Intelligence with 10 years of rich experience in handling data related activities. Equally comfortable in a Technical or Lead role, performed the role of a Technical Project Manager, Technology Lead for various projects.

SUMMARY:

  • 10 years of total IT experience.
  • Good understanding of the data warehousing concepts and standard ETL (Extraction Transformation Loading).
  • Having Strong knowledge on ETL (Extraction, Transformation and Loading) experience using Informatica Power Center 9.5/9.1/9.0/8. x/7.0
  • Good knowledge in Sybase/ Oracle/MS SQL Server databases.
  • Having strong knowledge in Teradata.
  • Various technical and domain related professional certifications including Informatica (Administration/Developer) and Teradata.
  • Having good knowledge in SQL and UNIX.
  • Experienced in doing analysis based on the User data.
  • Experience in Offshore and Onshore Development Model/co - ordination
  • Having good domain knowledge on Investment Portfolio Systems.
  • Having functional domain knowledge of Banking
  • Thorough understanding of Software Development Life Cycle (SDLC) including requirements analysis, system analysis, design, development, documentation, training, implementation and post-implementation review.
  • Extensively worked with large Databases in Production environments.
  • Proficient in understanding business processes/requirements and translating them into technical documents.
  • Prepared Unit Test Document/Unit Test Cases for the ETL development.
  • Proven/Extensive experience in activities related to the development, implementation, manage and support of ETL processes for large-scale data warehouses using Power Center.
  • Proficient in the implementation of Data cleanup procedures, transformations, scripts, stored procedures and execution of test plan for loading the data successfully into the targets.
  • Good experience in creating reporting tables materialized views and Stored procedures.
  • Analyzed, designed, developed, implemented and maintained moderate to complex initial load and incremental loads using Teradata Bteq scripts to provide data for Data Warehouse.
  • Strong experience on Creating End-to-End Autosys Job Stream and Implementation.
  • Experienced in Teradata Query optimization.
  • Experienced in environments requiring direct customer interaction during specifications, design, and development and product implementation phases.
  • Experienced in doing analysis on data and prepare Business requirement documents.
  • Involved in Troubleshooting database problems, Performance tuning - session and mapping tuning, partitioning and SQL Tuning.
  • Having greater ability to upgrade to new technologies.
  • A Team Player with excellent interpersonal skills.

TECHNICAL SKILLS:

Platforms: Windows 7, Windows XP, Windows 2000, DOS and UNIX

ETL/ Reporting Tools: Informatica Power Center 9.5/9.1/9.0/8. 6/8.1/7.1(Source Analyzer, Data warehousing designer, Mapping Designer, Mapplet and Transformations)

Database: Sybase 15.5, Teradata V13/V12, MS SQL Server 2012 and Oracle 11.2 g/ 11

File Handling Tools: Putty, Secure CRT and Secure, WS FTP Professional, Edit Plus, Notepad++

Programming Languages: UNIX and Shell Scripting

Productivity Software: Microsoft Visio, Microsoft Project 2010 and Office Suite 2010

Business Requirement: Requisite Pro, Embarcadero Studio for Data Modelling

Others: CA AutoSys, CA Cybermation ESP, TD SQL Assistant for Teradata, Informatica Life Management(ILM) - Persistent Data Masking and Data Subset Tool, BMC Remedy, Perforce, Clear Case, TOAD for Oracle, Rapid SQL, XMatters, Atlassian Fisheye

EXPERIENCE:

Confidential, IRVINE, CA

Technical Project Manager

Responsibilities:

  • Responsible to handle Steady State activities for 12 applications (this would increase to120 in future) reporting periodically to all the stakeholders and development effort tracking.
  • Coordinate with application SMES to understand their release changes.
  • Identify Profile PII (Personal Identifiable Information) attributes and build Informatica code using Informatica Life Management(ILM) - Persistent Data Masking and Data Subset Tool
  • Create Masking rules; apply rules on recognized sensitive attributes using ILM.
  • Troubleshoot any PowerCenter Workflows failure and provide resolution.
  • Perform unit testing on masked data w.r.t production data.
  • Provide Masked Copy to applications for their Non Prod environments.
  • Lead a team of 6 developers, allocated tasks to team members, review of code against design documents, maintained development tracker and responsible for module specific deliverables.

Environment: Windows 7, Unix, Informatica 9.5, ILM- Persistent Data Masking and Data Subset Tool, Oracle 11.2 g, Sybase, MS SQL Server,, BMC Remedy User, Secure CRT 7.1, Microsoft Suite 2010, Perforce P4V.

Confidential, IRVINE, CA

Technology Lead

Responsibilities:

  • Working as SPOC in Onsite and took Overall responsibility for the day-to-day operations of the project, reporting periodically to all the stakeholders and development t effort tracking.
  • Working with different SMES on the data requirement.
  • Perform detail Technical Analysis on the requirements and share outcome with stakeholders.
  • Working as Informatica Lead, responsible for Functional and Technical Design document preparation, ETL development & Code review
  • Provide build effort estimates and document sign off on detailed design document.
  • Responsible for the migration of the code to ITE Testing environment for each release.
  • Responsible for delivery of application through the various testing phases like ITE, Sandbox Testing, UAT and PT.
  • Working as Release Manager for various BAU Releases.
  • Lead a team of 3 developers, allocated tasks to team members, review of code against design documents, maintained development tracker and responsible for module specific deliverables.
  • Managed Request, Incident, Change and Release using BMC Remedy Management Tool.
  • Create Deployment plan- Understand Batch Schedule and adjust code deployment with minimum impact to batch schedule.
  • DBA migration plan- Provide list of Database Objects and their sequence of execution and troubleshoot any error during execution.
  • Perform Post Mortem on release and document lesson learnt
  • Handle Production Issues which could be due to Data mismatch/PowerCenter Workflow failure/Autosys JIL failure/Stored Procedure execution failure
  • Handle Application Admin Activities- Manage Access across technology platforms, which include Database (Sybase/SQL Server), ETL (Informatica PowerCenter) and UNIX (Roles).

Environment: Windows 7, Unix, Informatica 9.0.1/9.1.0 , Oracle 11.2 g, Sybase, MS SQL Server, BMC Remedy User, Secure CRT 7.1, Microsoft Suite 2010, AutoSys, Perforce P4V, XMatters, Atlassian Fisheye, Embarcadero RapidSQL

Confidential

Associate Technical Consultant

Responsibilities:

  • Enhanced different modules in EDW through Request for Change (RFC’s)
  • Business Objects Universe
  • Load scripts (Multiload)
  • DDL changes
  • Data Models
  • Provided Teradata Application-level database support
  • Scheduled Daily processes: Macros, Stored Procedures, Data Loads, System Load
  • Statistics analysis/updates
  • Database security
  • Provided support with TPT, SQL, BTEQ, Stats/Index wizards, TASM
  • Supported database related technical/performance issues
  • Developed, maintained and helped enforce best practices and operational guidelines
  • Documented database operational procedures
  • Administration
  • Performance monitoring
  • Provided technical assistance on assigned EDW-related issues
  • Participated in rotations on EDW Primary Support for all planned activities and unplanned production issues to minimize disruption to the business

Environment: Windows 7, UNIX, Teradata 12, Business Objects, Secure, CRT 7.1, Microsoft Suite 2010

Confidential

Module Leader

Responsibilities:

  • Managed Production support team of 5 as Offshore Coordinator
  • Professionally maintained client’s IDW (Integrated Data Warehouse) infrastructure and following operational security policies
  • Conducted and analyzed data queries using Informatica and Teradata
  • Was working as offshore Teradata DBA team member and was involved in DBA activities
  • Involved in Offshore ETL administration tasks.
  • Supervised and coordinated meetings from offshore.
  • Oversaw security and user management, including users, groups, roles, privileges, and permissions
  • Performed advance monitoring and logging
  • Supported Informatica PowerCenter environments
  • Participated in Informatica installations and upgrades
  • Involved in ETL migration activities.
  • Participated in automation of monitoring Informatica environments
  • Participated in projects and proactively built relationships with Business Units to understand new requirements, facilitate design discussions, and ultimately implement a finalized solution.
  • Developed teamwork and leadership skills by working with offshore colleagues to ensure work activities are transitioned efficiently between shifts.
  • Communicated in a manner that was appropriate for the situation and possessed business insight necessary to communicate how technical design decisions affect users and budgets.
  • Developed detail documentation for supported/upgraded environments and helped train others on the particulars of those environments where applicable.
  • Comply with existing Ethics and Data Security policies, standards and processes.

Environment: Teradata, Informatica 8.6, CA Cybernation ESP, Remedy, Teradata PMON, Teradata Administrator.

Confidential

Technical Consultant

Responsibilities:

  • Responsible for the preparation of Technical Specification Document.
  • Involved in the design and coding of BTEQ scripts in Teradata.
  • Performed the role of a lead and handled a team of 3.
  • Prepared status reports, Maintained Issue tracker and Provided Effort Estimation.
  • Created Unit Test plans for testing.
  • Involved in testing the code against Requirements.
  • Involved in Data Migration Effort.

Environment: Windows XP, UNIX, Informatica PowerCenter 7.0, Teradata v2r5, Microsoft Suite 2003

Hire Now