Information Technology Analyst Resume

SUMMARY

5 years of experience in Data Extraction, Transformation and Loading with expertise in SQL, Data Warehouse & OLAP.
Development mind & experience in designing and developing BI solutions using Teradata, Informaitca & OBIEE.

TECHNICAL SKILLS

Programming Languages or Skills: SQL, C, C++, Java, R and Python (pandas, numpy, matplotlib).

Software/Tools: Informatica Powercenter, Teradata BTEQs, FLoad, MLoad Oracle SQL Developer, HP Quality Center, Cronacle, OBIEE reporting, MS Excel (Foster School Certified), Linear Regression, Tableau, Rally.

PROFESSIONAL EXPERIENCE

Confidential

Information Technology Analyst

Responsibilities:

Led a team of 10 diverse BI developers across 6 global locations managing end to end project implementation in AGILE.
Conceptualized and led quality team ensuring defect free production deployments for entire account saving remigration costs and reducing post production defects for approximately 150 releases quarterly.
Worked with functional users, technical architects and project managers to capture and analyze complex project requirements through meetings, interviews and workshops.

Systems Engineer

Confidential

Responsibilities:

Owned the data integration in a multi - source BI integration project. Developed a Teradata SQL stored procedure comparing product hierarchies/structures in different source systems halping client to save 480 hours quarterly.
Developed a BI solution using Teradata and OBIEE to show product visibility of all supply chain phases from manufacturing to sales used by approximately 150 users saving $530k annually.
Created BTEQs dat read data from XML file to refresh real time transactional source data into warehouse.
Saved 256 work hours quarterly in testing efforts by automating the data testing between different DW stage tables.
Tuned the performance of a SQL procedure to reduce output time to less TEMPthan a minute from 10-15 minutes.

Assistant Systems Engineer

Confidential

Responsibilities:

Took the initiative of leading a team of 19 individuals delivering a project on Online Test Taking System at Initial Learning Program (TCS Training Program), managing the entire end to end delivery of the project.
Created an ETL solution showing approximately 250 product attributes used by 50 users globally.
Integrated data to create data pipelines from multiple sources into BI data warehouse using Informatica Powercenter.
Carried out ETL processes using Teradata Bteqs and Informatica mappings to load data into DW (ODS/EDW) tables.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship