We provide IT Staff Augmentation Services!

Technical Project Manager Resume

Irvine, CA

CAREER OBJECTIVE:

To obtain a challenging position that will enable me to utilize my experience and skills for organizational growth and help me reach higher echelons.

SUMMARY:

  • Highly proficient Teradata, Informatica certified professional with 10 years of experience in IT Services Industry. Transmit expertise in Data Analysis, Data Integration, Project lifecycle Development, Maintenance/Production Support & Service Operations.
  • Experience in managing full Software Development Life Cycle (SDLC)
  • Experience in working project using Waterfall, Agile and Kanban methodologies
  • Experienced in the roles of Technical Project Manager, Technology/Module Lead and Associate Consultant for Data warehousing projects for multinational companies in the Banking and Finance domain.
  • Experience in Offshore and Onshore Development Model/co - ordination
  • Detail-oriented, quick learner with excellent organizational skills and ability to multi task
  • Proven strength in quantitative, analytical and problem solving skills
  • Excellent written and interpersonal communication skills
  • Adept at working in high pressure environments with strict deadlines and multiple deliverables
  • Contributed to various Business Value Additions to improve productivity.
  • Reusable component for Error Logging Normalized Format: This tool is to have Error identified and logged in a standardized format which can be used for future reference.
  • Power Center Migration Script: Perform Multiple export and import workflows xml within and across power center repositories
  • Jil creation across environments: Process which creates Jil file for all environments
  • Top performer for consecutive three years with highest appraisal rating (1, 1 and 1+)
  • Managed and Lead BU initiative of ‘Mentor-Mentee Program’ for Trainees Batch.
  • Received 2 Insta Awards for contribution to project and account in successive years.
  • Member to DC level initiatives like Campus Connect, Thought Leadership, Sports Committee in present Organization.
  • Achieved Best Presenter and communication skills at account level

AREAS OF EXPERTISE:

Teradata

Informatica PowerCenter

Informatica Life Management(ILM) - Persistent Data Masking and Data Subset Tool

Unix

Development Methodologies

Autosys

Sybase

SQL/PL-SQL

Configuration Management

Release Management

MS-SQL Server 2008

COMPUTER PROFICIENCY:

Informatica PowerCenter 8.6, 9.0.1,9.1

Teradata 12

Sybase 15.5

Perforce

CA AutoSys

CA Cybermation ESP

Embarcadero RapidSQL

MS SQL Server

TD SQL Assistant

Informatica Life Management(ILM) - Persistent Data Masking and Data Subset Tool

PROFESSIONAL EXPERIENCE:

Confidential, Irvine, CA

Technical Project Manager

Responsibilities:

  • Profile PII (Personal Identifiable Information) attributes using Informatica Life Management(ILM) - Persistent Data Masking and Data Subset Tool
  • Data Masking- Create Masking rules, apply rules on recognized sensitive attributes using ILM.
  • Generate Informatica PowerCenter mappings/workflows and execute them.
  • Troubleshoot any PowerCenter Workflows failure and provide resolution.
  • Perform unit testing on Masked data w.r.t actual data.
  • Actively involved to carry out all phases of the project life cycle (Requirement gathering, Design, Architecture, Development, Unit Testing, Implementation and warranty).
  • Perform detail Technical Analysis on the requirements and share outcome with stakeholders.
  • Post Confirmation on Analysis results transform technical requirements into high level and detail level design document.
  • Provide build effort estimates and document sign off on detailed design document.
  • Create Database Objects (Tables/Stored Procs/Views) in Sybase/MS SQL Server using PL/SQL.
  • Developed complex PERL scripts for data-loading and batch processes etc.
  • Conduct application wide process performance review to identify the bottleneck process.
  • Develop mappings (SCD1/SCD2) and workflows using Informatica PowerCenter.
  • Extensively used Informatica PowerCenter to process data from different sources(Relational/File) to the Target System( Relational/File)
  • Developed Jobs in Autosys using Job Information Language (JIL)
  • Handle Application Informatica Admin tasks- Export and Import workflows across repositories, create Relational Connections etc.
  • Unit Test code (Database/Unix/ETL and Autosys JIL) and document Unit Test results
  • Migrate PL/SQL, Unix, ETL code and JIL files to Test Environment for QM team to perform Testing
  • Support Code Testing and Bug Fixing
  • 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.
  • Post approval, responsible to perform release management activities and deploy code to Production Environment.
  • 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).

Confidential

Technology Lead, Project Manager

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
  • Logical and physical modeling - Semantic Layer, PI, PK, Tables, Views
  • Scheduled Daily processes: Macros, Stored Procedures, Data Loads, System Load
  • Statistics analysis/updates
  • Database security
  • Provided support with TTU, 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
  • Worked with vendors to open tickets and resolve issues
  • Worked with Scheduling team to maintain job schedules and dependencies

Confidential

Global Delivery Center Consultant

Application: Teradata 12, BO XI 3

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 Power Center 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.

Hire Now