Datawarehouse and Integration Intern Resume

SUMMARY

3+ years of experience in ETL, Analytics, Programming and relational database management systems.
Strong experience in US healthcare domain, Database Design, Modelling, Data Analysis and Data Mining.
Experience in implementing ETL projects in DataStage and SSIS.
Experience in developing SQL queries, Stored Procedures, Functions, Views, Indexes, Triggers
Proficient in ETL package design and strong experience in handling ETL operations with Flat Files, Excel, MS Access, Oracle, SQL.
Strong Programming skills in SQL, Python, R and Java.
Strong knowledge in Tableau and Power BI reporting tools.
Experience working in SDLC, Agile, JIRA, Azure Dev - Ops, TFS Version Control.

TECHNICAL SKILLS

PROFESSIONAL EXPERIENCE

Datawarehouse and Integration Intern

Confidential

Responsibilities:

Working on complex PL\SQL queries in Oracle based on the reporting and business needs.
Developed ETL jobs in DataStage to load facts and dimensions in Datawarehouse.
Working on loading SharePoint spreadsheets into the database using C-Data.
Automate testing process by building testcases in Data Gaps ETL Validator.

Graduate Teaching Assistant

Confidential, Houston, Texas

Responsibilities:

Assisting students in understanding various concepts and libraries of Python Programming language.
Assisting professor in designing the course structure and grading Assignments for 60 students and providing feedbacks.

Software Developer

Confidential, Houston, Texas

Responsibilities:

Business Intelligence Developer

Confidential, Buffalo, NY

Responsibilities:

Worked as an ETL database developer to generate/submit health insurance claims files and perform data analytics on it.
Worked on migrating existing DataStage ETL packages from version 9.1 to 11.7.
Worked on dimensional modelling building and loading facts and dimensions through SQL Stored Procedures.
Worked on SSIS packages for complex Data Migrations from legacy systems
Loading complex file structures such as XML, Excel, EDI file.
Optimizing stored procedures in SQL and Greenplum databases.
Designed UNIX shell scripting for error reporting, file corrections, auditing and logging.
Creating weekly and monthly insurance claim reports in Tableau and Power BI.

Software Engineer

Confidential

Responsibilities:

Gained Hands-on experience in Pega-Business Process Management Tool.
Designed, developed and tested a Pega application to create an automated business application for insurance management, considering a variety of insurance types.