Engineer Ssis

Deepika Angara

619-***-**** • ******.****@*****.*** • San Diego, CA 92128

Resourceful Soȅware Engineer driven to increase team effectiveness. Focused on usability and performance improvements and known for creating useful, efficient and cost-effective projects. Strong knowledge of Microsoȅ T-SQL and experience building complex queries, skilled at application development, testing and optimization. Summary

05/2010

Master Of Science, Computer Applications

Andhra University, Visakhapatnam

Education And

Training

Certifications • Certified AWS Cloud Practitioner

• Certified IBM Data Science Professional through Coursera 12/2019 - 03/2020

Soȅware Engineer, DynPro India Pvt Ltd, AT&T, IBM, Bangalore, India Experience

The AT&T Business Operations Assurance portfolio (consists of CBS - Critical Business Services Sales, Orders, Provisioning, Delivery) provides the latest technological solutions to help customers maintain business continuity during daily operations.

•

Production Support for daily automated and server processes loading data and transformation processes (ETL/ELT) producing the reports and analysis.

•

• Perform adhoc data loads and reporting functions for break-fixes. Create complex functions, scripts, stored procedures and triggers to support application development.

•

Debug, troubleshoot and revise SQL scripts to provide hot-fixes on prod data issues discovered.

•

Conducted investigation and diagnosis of incidents and service requests perform trend analysis of incidents and presented recommendations to improve service quality and availability.

•

Enforce due diligence of deployments to ensure a controlled and governed Production Release.

•

Participate in database design and architecture to support application development projects.

•

• Optimize and tune database systems for performance efficiency.

• Assist with reporting operational metrics to the leadership team.

• Developed strategies and support plans for Analytical services tooling.

• Strong interpersonal, analytical, critical-thinking, verbal and written communication skills.

• Performed risk assessments.

• Analyzed solutions and coding fixes for soȅware problems.

• Conducted full life-cycle soȅware development in multiple soȅware environments. 12/2013 - 03/2015

Associate Soȅware Engineer, Pyramid IT Consulting, Microsoȅ, Hyderabad, India

• Compiled current business intelligence data into reports and presentations.

• Prepared forecasts and identified trends through data analysis and tracking.

• Prepared data examples, runs and views for client meetings. Designed and implemented an object-oriented framework for Microsoȅ customer relationship application MS-VL which deals with volume licensing of Microsoȅ retail soȅware products.

•

UI and Performance automation of soȅware systems with suite of Microsoȅ Team foundation server, SQL server and Visual Basic Scripting.

•

Created complex ETL (SSIS) packages to pull data from various DBs, load from Excel & flat-files to SQL server.

•

Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters.

•

Worked on Code review, Unit test case preparations for reporting packages Developed a relational database, and implemented billing computation using SQL for a subscriber network of over 100,000 customers.

•

This database implementation is employed to date as it allows for faster data access, better fault tolerance and improved data management.

•

Designed, Developed and Implemented various reporting services using Microsoȅ SQL Server Reporting Services.

•

Designed and developed SQL project using SSIS package, and implemented Performance tuning improvements.

•

Hands on SQL Profiler for troubleshooting, monitoring, optimization of SQL Server, created stored procedures, fine-tuned database queries, plans and creating indexes on tables Experience in Extracting, Transforming and Loading (ETL) data from various sources to several destinations using BCP utility, DTS and SSIS.

•

Installing, validating, and maintaining soȅware & Databases to various environments ensuring successful deployments.

•

• Conceived, developed and implemented wide range of BI solutions. Updated tracking documents, generated different reports and gave presentations on findings.

•

• Optimized data gathering processes, analysis procedures and visualization strategies.

Contact this candidate