We provide IT Staff Augmentation Services!

Technical Lead Resume

Pleasanton, CA

SUMMARY:

  • 10+ years of Strong IT experience in Planning, Designing, Data analytics, Development of Data Quality mappings and Building Data Warehouse or data mart using ETL - Informatica Data Quality 9.x Informatica Power Center for OLAP, OLTP and equivalent large systems.
  • Experience in Life Cycle Development of building a Data Warehouse for large technology projects including Analysis, Design, Development, Testing, Maintenance and Support.
  • Created various mappings with specific transformations in Data Quality like Address Doctor, Standardization, Matching, Association and continuing profiling on the huge volume of retail and Healthcare customer data.
  • Strong Database skills in writing advanced SQL and PL/SQL queries in Oracle & MS SQL Server.
  • Strong UNIX scripting and Python (Basic) skills for invoking and executing informatica sessions using static and dynamic parameter files.
  • Creating BOXI Reports and scheduled them to extract data for different source systems.
  • Ability to transition business expectations through IT's budgetary and technical limitations to design effective and efficient applications. As a Data Analyst I have successfully helped clients meet their business objectives by utilizing information technology
  • Experienced in tuning Informatica Mappings to identify and remove processing bottlenecks.
  • Experience in integration of various data sources from Databases like MS Access, Oracle, SQL Server and dealing source files like Sharepoint, XML files, TLV (Tag-Lenghth-Value) files and regular flat files (.dat, .csv)
  • Worked extensively with different Job Schedulers like Maestro, Tivoli Web Scheduler,Control-M and cron jobs in UNIX.
  • Postproduction support, enhancements and performance tuning.
  • Experience in Coordinating onsite - offshore interaction, contributed suggestions and valuable solutions during the on-going. Good communication skills, interpersonal skills, self-motivated, quick learner and valuable team player.

TECHNICAL SKILLS:

Data WareHousing Tool: Informatica Data Quality (IDQ) 9.x

Data Modeling: Dimensional Data Model, Star Schema and Relational data warehousing model

Databases: Oracle, SQL Server

Scipting Languages: UNIX Shell Scripts, Python (Limited Knowledge) script

Project Tools: Informatica Data Quality, Informatica Power Center, TWS - Maestro, Control- M, Actuate, Telelogic- Change synergy, Remedy websystem, CITRIX, HP-QC, CRT-Unix/Linux box, Dimensions.

WORK EXPERIENCE:

Confidential, Pleasanton, CA

Technical Lead

Roles and Responsibilities:

  • Designed the end to end solutioning to integrate various source systems and maintain historical view for users to slice and dice the reporting data in Tableau.
  • Created IDQ profiles to analyze the data better and perform the integration.
  • Responsible for delivering artifacts as a part of Agile methodology
  • Created handful Boxi reports for some of the source systems which we don’t have direct db access and scheduled them to extract daily / weekly and monthly based on reporting needs.
  • Created various PL/SQL analytical queries to perform the db integration load.
  • Created and Implemented the vbscript to convert the xls files into csv for Informatica processing.
  • Delegated the work to my subordinates / offshore team and ensure the deliverables are in time.

Confidential, Minneapolis, MN

Technical Lead

Roles and Responsibilities:

  • Defined the high level scope of Application Architecture, provided the solution for the design changes, build the informatica data quality mapplets and powercenter mappings for the Customer Identification (CID) Project.
  • Created Specific IDQ transformations for Standardization, Group key creation, AddressValidation, Matching (Different attributes) and Association based on the data profiling and cleansing rules provided by Business on high volume(400M) of Customer Data.
  • Responsible for delivering artifacts as a part of Agile methodology
  • Created concurrent and multi-thread solutions for better performance in creating the Data Quality mapplet and power center mappings.
  • Working in the Oracle PL/SQL procedures & packages to analyse and develop the new business requirements and enhancements in the existing functionalities.
  • Good hands on experience in performance tuning and maintanence on ETL tool (informatica) and Oracle Database.
  • Created High and Low level design technical documents and specs
  • Worked in the process of developing and scheduling Shell scripts to automate the sql packages and procedures

Confidential

Technical Lead

Roles and Responsibilities:

  • Cordinated with onsite managers and get the SRS documents for implementing the mainframe.
  • Created basic Python scripts to load different region text files in to staging.
  • Allocate the reports to the individual team members
  • Helping the team members to solve the issues and concerns on every report.
  • Reviewing and validating the reports on all the development phase
  • Presenting the reports to onsite managers and senior managements.
  • Working on daily, weekly and monthly feeds and its corresponding maintanence activities pre and post batch completion.

Hire Now