Surekha R Polavarapu

adhzj9@r.postjobfree.com

https://www.linkedin.com/in/surekharanipolavarapu/

Phone No: 1-774-***-****

PROFESSIONAL SUMMARY

IT Professional experience As a Technical Consultant and Involved in Design, Development & Testing of CRM, Data warehouse and database, Web and Client Server Applications.

Experience with Database Programming with T-SQL, SQL/PL-SQL, & NZ-SQL on SQL Server, Oracle, and Netezza Databases.

Excellent understanding of Software Development Life Cycle, and Test Strategies.

5 Years of Experience with ETL Processes with Informatica Power Center 9.6.1 and SSIS and ELT Process with Procedures.

Experience of creating SSRS Reports.

Experience with Scheduling Tools like Tidal, SQL Server Agent.

Experience with bug tracking or change request management tools like JIRA.

Experience of CRM, Marketing database development.

Knowledge of Performance Tuning with Indexes and Partitions.

Good documentation & communication skills.

Flexible to learn and adopt any new Technology.

TECHNICAL EXPERTISE:

Database : SQL Server 2014, Oracle 9i, MS Access (v2.0), Netezza

Programing Languages : SQL, PL/SQL, T-SQL, and NZ-SQL.

ETL Tools : SSIS, Infomatica Power Center

Reporting : SSRS

Design Documents : FLD, STT, QA Strategies.

Tools Awareness : Jira

Scheduling Tools : Tidal

Designing Methodologies&

Tools : SDLC, Microsoft Visio

Web Technologies : HTML, and JavaScript

Scripting Languages : Shell

Operating Systems : Windows, Linux

ACADEMIC QUALIFICATION:

Master of Science in Maths from Osmania University, Hyderabad, AP

PROJECT PROFILE:

Employer: Vision Government Solutions Inc

Role: Data Engineer

Technology: SQL Server 2014,T-SQL, Oracle 11G,Azure SQL

Duration: Dec 2018 to Present

Project Description:

Vision provides Real Estate and Personal Property Value Assessment Solutions for Towns and Cities of Various US States. It stores and manages the information about land, parcel, construction, building details for homes and commercial properties.

My Role: As Data Engineer,

I support converting application data from one version to other version.

Converting Oracle Views to SQL Server Views.

Data Migration

Support for customers adhoc requests and providing adhoc queries with SQL.

Fixing and Providing Data Research and Analysis on Value Match Variances.

Building Custom data views and Reports.

Taking Database backups and Uploading.

Attaching Property Card details to Database.

Creating appropriate Indexes for performance tuning.

Data Export & Import.

Status updates with JIRA.

Employer: Merkle Inc

Role: Dev Analyst

Title: Sanofi – Genzyme: Kevzara On boarding to Marketing Database.

Duration: Sep 2016 to Nov 2018

Technology: SQL Server 2014, Informatica Power Center 9.6.1, T-SQL

Project Description:

This Solution is designed to on board the Patient details of the new Prescription Drug into the Marketing Database, It collects patient’s details, Patient orders, caregivers, response, call centre activity information and make it available for campaign execution.

My Role: As a Dev Analyst

Involved in Design discussions and Project Estimations

Participated in Creating Source to Target (S2T) Mapping Documents and File Layout Documents (FLDs).

Created the Informatica mappings, sessions and workflows, for loading data into stage tables.

Created Partitioned Stage Tables for Sliding window of persistent stage tables.

Created the metadata driven file validation and data validation process.

Implemented Stored Procedures to load into Marketing DataMart.

Implemented SSIS Packages to migrate data between servers and to generate extracts into various formats including Excel and XML.

Created Operational and Business Reports using SSRS in Tablix, Matrix formats and Graphical formats.

Used new features in SQL Server 2014 like creating columnstore indexes.

Created Deployment Scripts and Custom Scripting for Email notifications and Validations.

Checked code into SVN version control system.

Created Tidal Jobs for Process Automation.

Performed Unit, Integration and Regression Testing.

Employer: Magma Solutions

Title: Nonstop Net (NSN), San Jose, CA

Technologies: JSP, Oracle, SQL/PL/SQL

Project Description: NSN is an Application Service Provider for network infrastructure and solutions, based at the multiple locations in USA. They mainly cater to their clients networking infrastructure requirements and technical support. This application uses Java Enabled browser as front-end, Oracle 8i as backend with JSP in the Presentation Layer and Java Beans in the middle tier.

My Role: Member Technical

Supported database queries for web site implementations.

Created Procedures for complex scenarios using SQL and PL/SQL.

Performance Tuning by looking at Explain Plan and creating appropriate Indexes.

Code Reviews.

Integration and End to End Testing.

Contact this candidate