Name: Sreelatha Reddy

Email:ad02nu@r.postjobfree.com

Phone:601-***-****

PROFESSIONAL SUMMARY:

•Over 11 years of rich and diversified IT industry experience in Database Development, Application Development, Data Modeling, Requirement Gathering and Analysis, Unit Testing and Monitoring, Technical Documentation and Technical Support in Banking, Insurance, Healh care, Mortgage, Construction, Oil and gas, Telecom,Education and Government projects.

•Implemented cutting-edge engineering solutions, automating processes, optimizing workflows, and establishing robust Continuous Integration and Delivery (CI/CD) pipelines; resulted in a 50% reduction in time-to-market for new product releases.

•Proficient in implementing Azure services like Azure Cloud, Azure Active Directory, Azure Blob Storage, Azure VMs, Azure SQL Database, Azure Data Bricks, Azure Functions, Azure Logic Apps,PowerApps, Azure SQL Data Warehouse, Azure Monitor, and Azure Data Lake Services Gen2.

•Implemented automated data pipelines using Power BI and SQL Server Integration Services (SSIS), enabling real-time data updates and reducing data processing time by 75%. Improved data accuracy and eliminated manual data extraction, saving 10+ hours per week.

•Accomplished in Logical and Physical Database design, DataConversion,Datamanagement, Normalization, and Data modeling using Erwin and SQL Server Enterprise Manager.

•Optimized data visualization techniques using SSRS, Tableau, Cognos, and Power BI; created interactive dashboards and reports that empowered data analysts to identify trends and make data-driven recommendations, leading to a 30% improvement in customer retention and a 15% increase in cross-selling opportunities.

•Expert in Creating, Configuring and Fine-tuning ETL workflows in DTS and MS SQL Server Integration Services (SSIS) and Sql server Analysis Services (SSAS) which extract data from a variety of sources using Orcale/ share point and later transform and integrate the data into a data warehouse/data mart model.

•Strong knowledge in data warehousing, including cube development with the Star/Snowflake Schema model, Partitions, KPIs, Perspectives, and Slow Changing Dimensions (SCD).

•Spearheaded the integration of Snowflake cloud technology, optimizing data warehousing infrastructure and amplifying data

and remarkable 50%, empowering data-driven business insights and expediting decision-making processes.

TECHNICAL SKILL SET:

Cloud Computing: Microsoft Azure - Azure SQL Data Warehouse, Azure Storages (Blobs, Tables, Queues), Azure Data Factory V2, Azure portal, Web Apps, Active Directory, Application Insights, Azure Monitoring,Logic Apps, Azure Key Vault and SQL Azure, DevOps,Git, Azure Data Bricks,ADF pipelines, Self-hosted runtime Integration, SSIS runtime Integartion,Azure Components, Azure Analysis Services, Power Apps,AWS, SnowFlake.

Operating System: Windows,Unix

Databases: SQL Server 2019/2018/2014/2012/2008R2, MySQL, MS Access, Oracle 9i, Microsoft365

Hive, Impala,No-Sql, Sql- Squirrel,Netezza.

Programming Languages: SQL, T-SQL, PL/SQL, MDX, C, C#, ASP.NET, Python and Scala

Business Tools: Word, Excel, PowerPoint, Access, Visio, Outlook

Database Tools: SQL Server Enterprise Manager, SQL Query Analyzer, SQL Profiler, SQL Alerts, Index Tuning Wizard, BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, Index Analyzer, Report Analyzer, SQL Client Utility, Big data, Hadoop, Azure

Reporting Tools: SSRS 2016/2014/2012/2008, Power BI, Congo’s Reports and Tableau

ETL Tools: DTS 2000, SSIS 2016/2014/2012/2008 and 2005, SSDT

EDUCATION and CERTIFICATIONS:

Master’s Degree in Computer Science - San Jose, CA.

Bachelor’s Degree in Computer Science - J.N.T.U Hyderabad, India.

Microsoft Certified Professional in DP-200: Implementing an Azure Data Solution.

Microsoft Certified Professional in DP-201: Designing an Azure Data Solution

Microsoft Certified Professional in 70-461: Querying Microsoft SQL Server 2012/2014

PROFESSIONAL EXPERIENCE:

RESPONSIBILITIES:

Collaborated with users, team leads, and technical managers, resulting in a 20% improvement in capturing accurate system requirements.

Successfully managed the entire SDLC, leading to a 15% reduction in development cycle time.

Utilized extensive industry knowledge to develop precise requirements specifications, contributing to a 10% increase in project accuracy.

Documented and translated requirements into system specifications, improving documentation accuracy by 25%.

Played a pivotal role in data modeling and E-R design, reducing data processing time by 30%.

Implemented Automated synchronization of streams with 90 million rows data into synapse tables using polybase functionality

Maintained documentation, increasing end-user satisfaction by providing readily available reference materials.

Coordinated UAT, resulting in a 20% reduction in post-implementation defects.

Acted as a liaison between technical and business teams, facilitating the development of 30+ Dashboards and Data Visualizations.

Implemented Copy activity and custom Azure Data Factory Pipeline Activities, streamlining data integration and reducing development effort by 20%.

Executed BI solutions on Azure, optimizing data processing speed by 40% and reducing costs by 15%.

Loaded data into Azure Data sources, improving data acquisition efficiency by 25%.

Designed, developed, and tested complex software products, resulting in a 15% increase in system stability.

Controlled Azure jobs via Control-M, ensuring timely execution of daily tasks.

Maintained adherence to defined Methodology and Standards, resulting in a 95% compliance rate.

Utilized Power BI to create various visualizations, including KPIs, Maps, Pie Charts, Slicers, and Bubble Charts, enhancing data insights by 30%.

Implement Copy activity, Custom Azure Data Factory Pipeline Activities and Azure Data Platform as services (pass), Azure Data Lake, Data Factory, Data Lake Analytics, Azure SQL DW, Databricks.

Loaded the Data into Azure Data source using Azure pipleines from different sources like Oracle, My sql, Datalake,csv files and Sharepoint and Fetch Xml

Architected and executed ETL and data movement solutions using Azure Data Factory, along with creating and running SSIS packages in Azure-SSIS IR, contributing to efficient data integration.

Managed Azure Data Factory DEV, UAT, and PROD Deployments, ensuring a smooth and reliable delivery pipelines

Implemented Power BI Embedded, DAX, and M languages, resulting in a 25% improvement in data visualization efficiency.

ENVIRONMENT: SQL Server Management Studio 2019, Visual Studio 2015, VSTS, Oracle, PL/SQL, Azure SQL, Azure Storage Explorer, Azure Blob, Power BI Desktop, Microsoft Azure Devops, Power BI. DAX,Contorl -M, Python,Power Apps.

RESPONSIBILITIES:

Designed, developed, and optimized complex BI solutions, resulting in a 25% improvement in report generation efficiency, utilizing the Microsoft Business Intelligence stack (SSRS, SQL Server Database, SSIS).

Spearheaded performance tuning efforts, achieving a remarkable 30% reduction in query execution time by meticulously optimizing T-SQL stored procedures and SSIS packages.

Demonstrated expertise in data extraction and transformation from diverse sources, ensuring superior data quality and accuracy by implementing a wide range of database tools, including stored procedures, SQL queries, PL/SQL functions, procedures, and triggers.

Maintained a staggering 99.5% uptime for the Data Warehouse, ETL, and BI Reporting environment through vigilant continuous performance monitoring and tuning.

Acted as a bridge between technical and business teams, facilitating the development of over 20 Dashboards, Data Visualizations, Analytics, and BI solutions, leading to a remarkable 40% increase in data-driven decision-making.

Streamlined data extraction from heterogeneous sources by developing and optimizing SSIS (ETL) packages, resulting in a 20% reduction in data processing time.

Leveraged Azure services for data migration and management, realizing a substantial 25% reduction in infrastructure costs and a 15% enhancement in data availability.

Designed and implemented robust database solutions within Azure SQL Data Warehouse and executed seamless data migrations from traditional database systems to Azure SQL databases.

ENVIRONMENT: SQL Server Management Studio 2019, Visual Studio 2015, VSTS, Oracle, PL/SQL, Azure SQL, Azure Storage Explorer, Azure Blob, Power BI Desktop, Microsoft Azure Devops, Power BI. DAX,Contorl -M, Power Apps.

Sr. SQL/ETL Developer Aug 17– Jul 18

Summit Materials Inc: Denver, CO

RESPONSIBILITIES:

Use the SSIS packages to load date from spreadsheet into the database and used packages to move data between databases (oracle, flat-files) on different servers.

Created pipelines load data from Azure storage blob to Azure SQL and scheduled web jobs for daily loads.

Write and test high-quality, maintainable code using T-SQL and Microsoft BI Tools (SSIS/SSRS/SSAS)

Performed SQL and PL/SQL tuning to improve the performance with the help of SQl trace, explain plan, indexing and Hints.

Migrated data in various formats like text-based files, Excel spreadsheets, to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.

Design, Develop and test high-quality Extract, Transform and Load (ETL) Process, programs, and scripts to migrate data from source systems into the Data warehouse.

Using the JIRA ticketing tool to track the issues of the reports for daily tasks.

Queried My Sql Database Queries from python using Python- Mysql connectorand My sql DB package to retrieve necessary information for the company, resulting 75% of retrieval data.

Extract complex data from multiple data sources into usable reports and analyses by implementing stored procedures and SQL queries.

ENVIRONMENT: SQL Server 2014, Microsoft Azure, T-SQL, SQL, SSRS, SSIS, Oracle 11g, PL/SQL, Power BI, MS-Access, Excel, VBA, VSTS, Azure SQL, Azure Storage Explorer, Azure Blob, Python,Devops.

Team Lead(SQL/Power BI) Jan 15- Sep 16

First DATA: Sugar Land,TX

RESPONSIBILITIES:

Creating various reports on Daily, Weekly, and Monthly basis.

Server monitoring and capacity planning to ensure adequate disk space and memory on all servers.

Responsible for data integrity throughout the application SQL and MySQL’

Responsible for scheduling the subscription reports with the subscription report wizard.

Installing different hot fixes for deadlocks, blocking and indexes.

Monitor testing servers for long running stored procedures queries using a profiler and recommended clustered and non-clustered indexes using DTA.

Involved in requirement analysis, ETL design and development for extracting data from the source systems like Oracle, flat files and loading into Netezza.

Experienced in Database optimization and developing stored procedures, Triggers, Cursors, Joins, Views, Cursors on databases SQL and MySQL.

Created Standard Reports,Cross,Tab, Drill down, Drill through,Tabular, List, Chart, Matrix reports, Parameterized, Sub reports.

Responsible for scheduling the subscription reports with the subscription report wizard.

ENVIRONMENT: SQL Server 2012, Oracle,TOAD, T-SQL, SSRS, SSIS, Windows Enterprise Server 2007, Power BI, SQL squirrel, MS-Access, Excel, VBA, JIRA, Oracle 10g, PL/SQL.

SQL Server BI Developer Jan 13 – Jun 14

Deloitte: Austin, TX (STATE OF TEXAS) & Sacramento,CA (STATE OF CALIFORNINA)

Project: THHSC (Texas Health and Human Services Commission) & EDD( Employment Development Department)

RESPONSIBILITIES:

Expertise in business Process Health Care Sector with Membership, claims, Payments, provider, eligibility and prior authorization for Medicaid and Medicare programs.

Perform unit and integration testing to verify code functionality.

Use the Execution Plan, SQL Profiler, and database engine tuning advisor to optimize queries and enhance the performance of databases.

Work on Event Handlers to do Event handling on error at the package and task level on error, on warning and configured it using send email task and script task.

Deploy reports to report Server as and when required and managed processes in data migration.

Developed Interface packages (SSIS) for transferring data from Legacy Systems to PeopleSoft Systems through scheduled SQL agent jobs.

Developed and Scheduled SSIS Packages which read source files and dynamically identify the SSIS package for that specific source file and execute the package with the required set of parameters thus generating the file and loading it into the destination system.

Created Monitoring System a Windows based web application which alerts the user community of failures and maintenance issues through Email and published dashboards to report failures.

ENVIRONMENT: MS SQL Server 2012/2008R2, SSIS, SSRS, SSAS, Visual Studio 2008, T- SQL, Windows Server 2008 R2, Visual Source Safe 2005 (VSS), XML, ADO.NET, ERWIN, PL/SQL, MS-Access,MS-Excel

Jackson State University: Jackson, MS (Mississippi) May 09 – Oct 12

SQL /ETL Developer

RESPONSIBILITIES:

Involved in designing the physical databases model on SQL Server 2005 RDBMS using different Data Definition and Manipulation Languages (DML/DDL) implementing constraints and triggers for data integrity in development database for the personal banking system.

Created databases and schema objects including tables, indexes, and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.

Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables from different databases.

Implemented Functions, views, Materialized views triggers, stored procedures and packages using oracle tools like Toad, Pl/SQL developer and QL Plus.

Performed Replication, Backup compression for individual tables and indexes and reducing the disk usage and I/O resources.

Used Execution Plan, SQL Profiler, and Database Engine Tuning Advisor to optimize queries and enhance the performance of databases.

Used Red Gate SQL compare schema differences between production, development and testing serv

ENVIRONMENT: MS SQL Server 2008R2, SSIS, SSRS, SSAS, Visual Studio 2008, T- SQL, Windows Server 2008 R2, Visual Source Safe 2005 (VSS), XML, ADO.NET, ERWIN, PL/SQL, MS-Access,MS-Excel

Contact this candidate