We provide IT Staff Augmentation Services!

Technical Project Manager Resume

Irvine, CA


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.


  • 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.


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


Confidential, IRVINE, CA

Technical Project Manager


  • 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


  • 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


Associate Technical Consultant


  • 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


Module Leader


  • 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.


Technical Consultant


  • 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