Computer Science Sql Server

Girija Darapu

+1-816-***-**** ************@*****.***

Summary:

Software professional with overall 3.5 years of experience in data warehousing architectural design which includes Requirement gathering, Analysis & Design, Implementation & Development, Unit Testing & QA Support.

Expertise in Oracle 11g,12c SQL, PL/SQL, Toad, Informatica

Hands on experience in writing SQL queries and Query Optimization.

Master in creating Oracle PL/SQL Functions, Stored Procedures and Triggers.

Efficient in Data warehousing concepts and experience in using Analytical functions like Rank, Dense Rank, Row number.

Proficient in Designing Informatica Mappings/sessions/workflows based on the requirements

Skilled in transformations like Filter/Sequence Generator, Router, Update Strategy, Lookup/Joiner.

Expert in developing mappings, mapplets, sessions, worklets, workflows.

Expertise in Designed Metadata Tables.

Hands on experience in implementing Slowly Changing dimension types (I, II &III) methodologies, Incremental Loads and Change Data Capture (CDC).

Education:

Master of Science - Computer Science Anticipated Graduation: May 2017

University of Central Missouri, Warrensburg- MO

Bachelors of Technology – Information Technology Graduated: 2013

Acharya Nagarjuna University, India

Technical Skills:

Programming Languages

SQL, PL/SQL, Shell Scripting, JIL Scripting, HTML, Python, CSS

ETL Tools

Informatica Power center/Power exchange 9.6.1/8.6.1/8.1/7.X

RDBMS

Oracle 10g/9i/8i/8.0, SQL Server 2000

Operating Systems

Unix, Windows XP, Windows 7,Windows 8,Windows 10

Other Tools

Toad, SQL Developer, Autosys, SQL Server 2014 Management Studio, Putty, Remedy, Service Now

Certifications: Oracle Database 11g: SQL Fundamentals I

Professional Experience:

University of Central Missouri Jun’16 - Current

#1 Role - Graduate Assistant

Responsible for maintaining and scheduling the shuttle services provided by the University.

Student Interaction.

#2 Role - Student Programmer

Description - Create tables; Rewrite existing functions, packages and Informatica jobs, handling data for newly added streams in Computer Science like Cyber Security & Information Assurance, Data Science.

Responsibilities Included:

Gather Requirements.

Perform Application Analysis.

Prepare Technical Design.

Prepare Test plan and Test cases.

Coding of components.

Perform Testing.

Take care of Deployment.

Environment: Informatica Power Center 9.5/9.6.1, IDR 9.5, Oracle, SQL, PL/SQL

Cognizant India PVT LTD Feb’14 – Dec’ 15

Client - The Hartford Life Insurance Company, Connecticut, USA

Role - Programmer Analyst

Teams - Maintenance (GB DW MAS)

#1 Group Benefits (GB DW MAS)

Responsibilities Included:

Responsible for analyzing source system based on Business Requirements Document (BRD) and created analysis and design documents.

Analyzed existing system and developed source table guidelines to enhance the data quality.

Developed Various ODS Tables and designed ETL logic from Source Systems.

Prepared code review check list document to make sure all the release components are uploaded.

Responsible for code walk-through with other co-developers and Production Support team for knowledge sharing, process improvement and to handle production failures.

Creating mapping document with the exact names and versions of changed components to send the migration team.

Worked extensively with the release team to plan and execute the releases.

Responsible for migrating projects between multiple environments (Dev, QA, UAT and Prod).

#2 Project: Personal Alliance (PL DW MAS)

Responsibilities Included:

Involved in creating new jobs by preparing JIL Scripts and running them using the job scheduler WCC Autosys.

Involved in code reviews, mentoring, helping the co-developers

Coordinated and worked Release Management and Production support teams to plan and execute the releases as per the timelines.

Coordinating with DBA Team, QA Team, Business Analysts, Migration Team, Release management team, Data Modeling Team and Production Support team.

Utilized advanced features in Informatica like Informatica Version Control to retain a copy of source code and track the code changes.

Strong experience in performing Unit testing, Test cases preparations and providing QA support for fixing the defects.

Experience in production support for issues raised by application users.

Involved in a team of onsite and offshore developers.

Involved in a weekly call scheduled for maintenance team and daily status call for supporting 24*7 production applications.

Experience in creating efficient and effective High and Low level documentation both for business as well as development community.

Extensively involved in migrating various Informatica sessions and mappings from one version to another.

Environment: Informatica Power Center 9.5/9.6.1, IDR 9.5, Oracle, Autosys, Shell Scripting, JIL Scripting, UNIX.

Excell Media PVT LTD, India Jun’13-Jan’14

Role : Intern Trainee

Responsibilities Included:

Hands on experience in writing SQL Queries.

Designed and developed several complex database procedures, packages.

Generated DDL scripts and Created and modified database objects such as tables, views, functions, synonyms, indexes, packages, stored procedures.

Environment: Microsoft SQL Server, SQL, PL/SQL

Contact this candidate