Etl Systems Analyst

Vamsi Krishna

Email: ************@*****.*** Phone: +1-650-***-****

SUMMARY

●Experience with Data modeling and Data warehouse skills (Star & Snowflake Schema, ETL Fact and Dimensional tables, Denormalization, Normalization, Aggregations).

●Experience in developing stored procedures, functions, Views and Triggers, Complex queries using Oracle PL/SQL, SQL Server, T- SQL and

●Strong ETL testing experience and verification utilizing SQL querying skills (PL/SQL, Toad or other tool) and formal testing methodologies.

●Expertise in data analysis, data mapping, data loading, and data validation

●Experience in various databases like Oracle, SQL Server, Teradata etc.

●Involved in the full Software Development Life Cycle.

●Worked with business users to gather business requirements and interaction with Business Systems Analyst and other team members to ensure the output meets client requirements

●Experience in Business Intelligence Tools like MicroStrategy, Tableau.

●Expertise in data analysis and developed key reports to executives.

●Ability to multitask and stay organized in a dynamic work environment.

EDUCATION

Master’s Degree in Information Technology Campbellsville University, KY

Master’s Degree in Computer Science Silicon valley University, CA Bachelor of Technology in Electronics and Electrical Engineering RVR & JC College, India

SKILLS

●

●BI Tools: Tableau, MicroStrategy, Qlik View, Cognos

●Programming Languages: SQL, PL/SQL, Java, HTML, CSS, JavaScript, jQuery, XML, T- SQL, R

●Databases: Oracle 11g/10g, Microsoft SQL Server, Teradata

●Operating Systems: Windows Server, Linux

●Other Tools: JIRA, Rally, MS Office, Microsoft Visio, Microsoft Excel

PROFESSIONAL EXPERIENCE

Enterprise Mobility Inc – SanRamon, CA Sep’19 – Present

Role: BI Consultant

Responsibilities:

●Involved in gathering elements from different data marts to consolidate in to single data mart.

●Involved in analysis of data marts to understand feasibility and complexity.

●Developed PL/SQL Procedures, Functions to populate data in to stage tables.

●Wrote complex SQL queries on oracle tables to pull data for analysis purpose.

●Worked on fact, dimension tables and dimensional modeling.

●Involved in ETL Development using Oracle PL/SQL.

●Created Tables, Materialized views, Indexes, Partition tables by range using date column to increase the performance.

●Wrote database triggers for automatic updating the tables.

●Perform ETL Testing by validating data.

Environment: PL/SQL, Oracle 10g/11g, SQL, PLSQL, Toad, Tableau.

Sutter Health - Sacramento, CA Aug’16- Sep’17

Role: ETL Developer

Responsibilities:

●Involved in the data modeling and design phase of the project.

●Designed the Dimensional Model of the Data Warehouse Confirmation of source data layouts and needs.

●Responsible for design and build data mart as per the requirements.

●Perform tests and validate the data flow, prepare all ETL processes according to business requirements

●Created and executed mapping using Slowly Changing Dimensions Type 2

●Analyze requirements and enhance ETL code accordingly.

●Responsible for developing, support and maintenance for the ETL (Extract, Transform and Load) processes

using Oracle.

●Involved in data validation and good at troubleshooting SQL and working with business users.

Environment: Informatica Power Center 8.1/7.1.2, Erwin 4.5, Oracle 10g/9i, Teradata V2R5, XML, PL/SQL, SQL Server 2005/2000

Silicon Valley University Jan’16- Mar’16

Developed a rental database management system where I was responsible for SQL development part of the project, report development and integrations.

NTT DATA – India Jan’13- Aug ’15

Role: SQL Developer

Responsibilities:

●Creation of database tables, views, indexes for different requirements. Created joins and sub-queries for complex queries involving multiple tables.

●Designed and implemented stored procedures, views and other application database code objects to aid complex mappings.

●Involved in various stages like development, system analysis, and design for new applications.

●Gathered requirements from users and converted them to technical specifications and provided best solutions to meet the client expectations.

●Designed and developed Informatica mappings and sessions based on business user requirements and business rules to load data from source flat files and oracle tables to target tables.

●Integrated data quality plans as a part of ETL processes.

●Developed and tested ETL processes and complex queries for analysis and extraction.

Environment: MS SQL Server 2008/2005, SSRS, SSIS, Windows 7.

Contact this candidate