Data Developer
Resume:
SUPRIYA RAO
Email:*******.*****@*****.***
Over 8 years of experience in Designing and Implementing BI applications within various industries such as Healthcare, Insurance and Banking. Highly proficient with SQL Server BI Stack (SSIS, SSAS and SSRS) within large and small Development/Production teams. Experienced with all phases of SDLC involving Systems Analysis, Design, Development, and Implementation. Excellent problem-solving skills with strong ability to efficiently implement Database Solutions to accomplish all critical Business Objectives.
SUMMARY:
Proficient in Extracting, Transforming and Loading (ETL) Data from different type of Sources such as Excel, Oracle, and Flat Files using SQL Server Integration Services (SSIS) from OLTP to OLAP
Experience in SQL Server DTS and SSIS (Integration Service) package Design, Constructing, and Deployment.
Created complex SSIS Packages using appropriate control and Data Flow elements with SSIS Standards like Error Handling, Logging and working with Package config files.
Experience in Interacting with Business Users to analyze the business process and transforming requirements into screens, performing ETL.
Experience in generating on-demand and scheduled Reports for Business Analysis or Management Decisions using (SSRS).
Created Ad-Hoc Reports as per client requirement and used Stored Procedures.
Created weekly and Monthly Reports as per requirement using SSRS and Scheduled Reports to be delivered to User on-demand Basis or run on daily, weekly and monthly basis in SSRS report Manager.
Worked on Power BI Desktop by extracting data from different sources, by writing queries according to business needs in query editor.
Good experience on creating Power BI Dashboard from scratch and handling Workspaces, Apps and User Security in Power BI Service.
Used Temporary Tables, Table variables and Common Table Expressions (CTE) for the better performance of the queries according to the requirement.
Configured data partitioning/table partitioning on huge tables containing millions of rows for better performance.
Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
Creating, maintaining and updating various Web applications created primarily in Python
Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Triggers
TECHNICAL SKILLS:
Languages: T-SQL, PL/SQL, C, Java
Operating Systems: MS-DOS, Windows Server 2012/2008/2003/ XP, UNIX
RDBMS/ Databases / Database Tools: MS SQL Server 2014/2012/2008 R2/2005, MS Access, SQL Server Management Studio, SQL Server Data Tools, Business Intelligence Development Studio (BIDS), Visual Studio, SQL Profiler, Performance Monitor, DTS, Database
Data Warehouse Tools/Technologies: SSIS, SSRS, SSAS 2014/2012/2008 R2/2005
Data Modeling Tools: Power Designer, MS Visio, ERWIN
Reporting Tools: MS Reporting Server (SSRS), Excel Power View
Microsoft Technologies: SharePoint, VB.Net, ASP.NET, POWER BI
PROFESSIONAL EXPERIENCE:
FISCHER HOMES, CINCINNATI, OH
SR.ETL DEVELOPER FEB 2020-TILLDATE
Project Scope:
This project is to move all the data from the datawarehouse and pull the data from the warehouse and develop the reports.
Responsibilities:
Loading data from source (MYSQL) to destination using ssis.
Wrote Stored Procedures to insert the data to the staging table using ssis from staging to production we moved through Stored Procedures.
Created Triggers for the automatic event in the audit tables so that if any changes occur in the base table it automatically triggers in the audit table
Worked on Incremental load to load the data from various sources to destination for the past 6 hour data to load in the target.
Created packages by checking the destination tables if they are getting loaded or not into Datawarehouse.
Deployed SSIS packages to SQL server agent for the automatic schedule of jobs.
Created and Scheduled Jobs in SQL Server agent according to the business requirements.
Created tables to pull the data from the Datawarehouse and load it to the destinations by applying different types of transformations.
I worked on creating snowflake schema which involves Facts and Dimensions
Created PL/SQL stored procedures, functions and packages for moving the data from staging area to data mart.
Designed and developed Oracle forms & reports generating up to 60 reports.
Created PL/SQL scripts to extract the data from the operational database into simple flat text files using UTL_FILE package.
Design and implement database solutions in Azure SQL Data Warehouse, Azure SQL
Recreating existing application logic and functionality in the Azure Data Lake, Data Factory, SQL Database and SQL Datawarehouse environment. experience in DWH/BI project implementation using Azure DF
Documented the Data Lineage for the future reference for the business and to keep track of the packages and Jobs whether they are loading the data into the tables according to the scheduled job.
Created Log tables to log the information of the package.
Used Script task for the connection details of the database instead of writing it every time and it will notify if the records are updated correctly or not.
Environment: MySQL, SSMS (SQL Server Management studio), Microsoft Visual Studio 2017, Pervasive, SQL Server agent, Confluence, SVN, TFS, VB.net, Microsoft Azure.
US BANK, CHARLOTTE, NC June 2019- Dec 2019
ETL/BI Developer
Project Scope:
The replacement of Foreign Exchange (FX) trading platform and related accounting system interfaces from SQL Server to Oracle Database.
Responsibilities:
Loading data from source to target using SSIS which involves tasks, containers and transformations depends on requirement.
Designed complex ETL strategies to pull data from different sources, like SQL server, and flat files and load it to the destination database using API files after using multiple transformations.
Participated in agile and Retrospective ceremonies to discuss about the requirements.
Creating batch files to run the packages to load the data and copying the files from local to server locations using Linux.
Developed Advance PL/SQL packages, procedures, triggers, functions, Indexes and implement business logic
Experienced in Configuring Batch Logging, Error Logging, event handlers and Connection Managers in SSIS
Created jobs and scheduled them using SQL server agent and involved in monitoring those jobs to make sure if they ran fine.
Involved in working with Ops team and DBA’s in the time of deployment when working on Prod environments.
Created Tableau reports using Pie-charts, bar graphs and tabular, matrix reports based on business requirements.
Reports including Drill-down, drill-through using expressions to show the reports.
Maintained the SSIS packages and Tableau reports using Git version control
Generated Tableau Dashboard with quick/context/global filters, parameters and calculated fields on Tableau reports.
Worked with various versions in Tableau, Tableau Server, Tableau Public, Tableau Reader and Tableau Online
Developed SQL queries using stored procedures, common table expressions (CTEs), temporary table to support SSRS reports
Created database objects like Tables, DML, DDL, Views, Stored Procedures, Functions, Joins, and Indexes in T- SQL based upon the functional specifications
Extensively worked on developing database objects like Stored Procedures, Views, Indexes, Triggers and Functions using T- SQL and performance tuning of SQL Queries.
Environment: SQL Server 2014, SQL Server Data Tools, Microsoft Visual Studio 2017, GIT, Oracle SQL developer 18c, Linux, Version One, SQL Server Agent, Tortoise, Tableau, MS Excel
Great American Insurance, Cincinnati, OH August 2017-May 2019
ETL / SQL BI Developer
Project Scope: De-commissioning of Oracle Datawarehouse and creating a new solution in SQL server using
Informatica in SSIS.
Responsibilities:
Involved in Technical discussions about business gathering requirements with Product Owner, Client Team.
Analyzed Informatica Mapping and COBOL code which was the ETL framework for ODW to identify sources and transformations to re-build that in SQL server for the EDW.
Developed the code in SQL Server using SSIS with different type of Transformations like Audit, Look-up, aggregate, Data conversion, Multi-cast.
Participate in all phases of the SDLC to ensure and verify that the design meets defined business requirements
Performed complex Data Analysis/Validation to ensure the accuracy and integrity of Data
Responsible for understanding the complex SSIS packages and make understandable to the team
Monitor for timely and accurate completion of Data Processes and scheduled Jobs
Create batch files for automatic deployment of database objects and ETL packages while promoting to other environments.
Processed and reviewed transactions to identify fraud, reconciled accounts and reviewed financial documentation
Responsible for understanding the complex SSIS packages and make understandable to the team
Used SSIS tester automated tool to test packages, tasks and precedence constraints
Create change requests using ServiceNow to promote newly developed database objects and ETL packages to production.
Worked with Operations Team to create and schedule the jobs/workflows in UC4 to have the automated execution of the workflows
Maintaining the SSIS packages In TFS for the version control.
Collaborate with Database Administrator and Solutions Architect to determine strategy for Data warehouse design architecture and the backup/recovery of Databases and Data warehouse
Performed Performance Optimization and Tuning on new and/or existing Data warehouse and/or ETL operations
Ensures adherence to Data Management/Data Governance Policies
Create and maintain Documentation for existing architecture, and data lineage of the source and target.
Environment: SQL Server 2008, SQL Server 2012/2016, SQL Server Data Tools, Microsoft Visual Studio 2015, TFS, MS Office 2010, UC4, Service Now, JIRA, Informatica PowerCenter 8.6.1, Beyond compare, Excel SSMS,
Care Source, Dayton, OH Aug 2015 – June 2017
MSBI (SSIS & SSRS) Developer
Project Scope: The Main scope of the project Indiana Roster Reconciliation is to integrate the data from Facets, Cactus and Choreo and identify Providers who credentialed, Delegated, Non-Delegated and automate the manual process. Also worked on generating different formats of the report. The project Incorporates data from various databases including Teradata, Facets, Ohio State ODM files.
Responsibilities:
Involved in Technical discussions and decisions for Business requirements, Interaction with Business Analysts, Client team and Development team.
Experienced in database design process and data modeling process.
Analyzed the Data quality, Data validating, Data Mapping to migrate data to SQL Server database.
Designed SQL Server Database and Table Design with Schemas, Constraints and Views.
Extracted data from various sources like Teradata, Facets, .CSV, Microsoft Excel and Text file from Client servers.
Analyzed business requirements and implemented data mart solutions for data mining and reporting.
Created SSIS packages which involved a variety of transformations such as Slowly Changing Dimension, look up, Aggregate, Derived Column, Conditional Split, Multicast, Union All, Merge, Merge Join, and Data Conversion before loading the data into Data Warehouse.
Created a report model on SSAS cubes.
Designed the Data Model based on Star Schema and created the Tables and Indexes and developed the scripts to load the Datamart Tables.
Identified the issues and developed a procedure for correcting the problem which resulted in the improved quality of critical Tables by eliminating the possibility of entering duplicate data in a Data Warehouse.
Developed, Code Reviewed, fixed bugs, Tested and Deployed SSIS packages using SQL Server 2014 Business Intelligence Development Studio.
Gathered Report Requirements and designed Reports, Matrix, Table Reports with Drilldowns, Map Reports, Dashboards, Gauge and Subscription reports.
Experienced in ETL tool Ab Initio in using GDE Designer. Very good working experience with all the Ab Initio components.
Also wrote DAX queries in power BI for performing calculations like Aggregations.
Created detail reports using Drill through filters.
Created Custom visualizations for business users to see their data in a way that best fits for their business.
Strong knowledge of Data Warehousing methodologies, concepts and implementation of star schemas, snowflakes schemas, facts & dimensions.
Implemented Power View to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
Implemented PowerBI gateway different source to matching analysis criteria and further modeling for Power pivot and Power View.
Ensured constraints and writing triggers/linked server scripts to apply the business rules. Performance Tuning, Backing Up & Restoring User Databases.
Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions.
Deployed and Tested (UAT) Reports in Multiuser Environment.
Part of the Agile/Scrum team and participated in Standup, grooming, planning and retrospective meetings.
Environment: T-SQL, MS SQL Server 2014, MS SQL Server Reporting Services 2015, MS SQL Server Integration Services 2015, SVN, TFS, Octopus, Power BI, Power Query, Power Pivot,ab nitio
First National Bank,PA Jan 2014 - June 2015
Microsoft BI developer
Project Scope: The project consisted on the data migration to the M&T servers for the credit risk unit, and to provide user-ready credit risk analytics reports using historical data and up to date records, optimize visualization, dashboard interaction, usability and re-usability of scheduled reports, and support data solution requirements from business departments.
Responsibilities:
Actively participate in gathering of user requirement and system specification.
Interacted with customers to analyze business needs. Provide software product design and - developed technical roadmap for the solution through the project lifecycle and beyond.
Created different Parameterized Reports which consist of report Criteria in various reports to make minimize the report execution time and to limit the number of records required
Built SSRS project to generate reports with desired formats (Word, PDF, Excel, etc.) to present statistics information according to business requirements
Created subscriptions to provide a daily basis Report.
Involved in performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard
Created reports using stored procedure. Involved in scheduling, creating snapshots and subscriptions for the reports
Migration of stored procedures and database objects between development and test environments
Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
Modified queries and stored procedures to improve the performance.
Environment: SQL Server 2005/2008/2010, SQL Server Management Studio, Windows 2000/2003, SSIS & SSRS
Client: HDFC Standard Life Insurance, INDIA March 2012 - Oct 2013
SQL Server Developer
Project Scope: The project was to develop the credit card division of a leading bank, built a customer-centric data warehouse to analyze transactions across finance, marketing risk, collections, and customer relations. The project dealt with database management such as security, performance tuning, writing queries and triggers.
Responsibilities:
Developed, maintained and executed SQL queries and validated completeness, integrity, and accuracy of data.
Designed, developed, and tested stored procedures, views and complex queries for the creation of Reports.
Involved in Designing and developing ETL packages using Heterogonous Sources to Destination (SQL Server).
Successfully created SSIS packages using Sequence Container, Data Flow, Execute SQL, Bulk Insert, Send Mail Task Etc.
Used SQL Server Agent for job scheduling.
Used advanced features of T-SQL in-order to design and tune T-SQL to interface with the database and other applications in the most efficient management.
Environment: MS SQL Server 2005/2008, SSIS, SSRS, SQL Server Studio Management, Visual Studio, MS Excel, SQL Server Agent
EDUCATION: Bachelor of Computer Science
Contact this candidate