Technology Analyst Resume

SUMMARY:

8+ years of professional experience including 6.5 years of experience in Data Warehousing and about 1 year of experience in product development and testing.
Experience in working with Agile and Waterfall methodologies.
Experience in using Teradata SQL and Utilities like BTeq, Fastload, Fast Export, Tpump and TPT.
Managing and enhancing large scale data warehouse for decision support systems.
Experience in SQL performance tuning and performance optimization .
Experience in creating database objects like database users, tables, views, triggers, stored procedures.
4+ years of experience working at client location interacting with client for requirements gathering , analysis , design discussions and team co - ordination .
Worked on ETL for developing new interfaces and enhancements for data processing and to process the same within SLA to have the data available for downstream processing in time bound manner.
Knowledge of developing shell scripts.
Hands-on knowledge of ETL tools and platforms like Informatica and Hadoop/Hive/Cassandra for 4.5+ years.
Excellent knowledge of job scheduling tool, Autosys.
Comfortable with technical and functional roles with hands-on experience in both coding and documentation for requirements, design, functional specifications, test plan documents.
Excellent communication and inter-personal skills ; quick learner and ability to work independently as well as part of the team.

COMPUTER SKILLS:

Databases: Oracle 9i & 11g, Teradata 12, 13, 14, 15; Hadoop

Operating systems: Windows, Macintosh, Unix, Linux.

Web Services: HTML, CSS, XML

Languages: PL/SQL, C

Tools: Informatica, Autosys, Microsoft Visio, Visual Studio, Team Foundation Server

WORK HISTORY:

Confidential

Technology Analyst

Responsibilities:

My onsite role included working on the support and enhancement of the data warehousing having core tables and developing semantic layer for denormalized tables.
I worked on requirements gathering, discussions with client, and offshore-onsite coordination for the activities, leading offshore team.
The activities include maintaining ETL to fetch data from Oracle systems via Informatica and fetch the data to Teradata and Hadoop systems. The jobs for these are configured in Autosys.
I was also working as technical analyst to analyze the technical issues for root cause analysis and for prevention plans, and also for business presentations of these.
While at offshore, during 2010-‘11, developed stored procedures for loading the data in the tables as per reporting needs.
Worked on developing the Unix shell scripts to drive the execution of the processes in the desired sequence for enriching the data in semantic layer from source.

Confidential

Senior Systems Engineer

Responsibilities:

Worked on every step of the development including requirements gathering, high level design, detail design, prototyping, coding, integration and demo.
Worked with teams spread across multiple development locations for this project.
Worked primarily on the requirements and design phase.
Later, as the scope of the project widened, the coding was done in ASP.net using Visual Studio.
The prototyping was done using Visio and HTML.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship