Anupama Bisetty

adcpvr@r.postjobfree.com

470-***-****

Sr. MSBI Developer

Summary

7+ years of experience in Microsoft SQL Server 2016/ 2014/2012/2008 R2/2005 with an emphasis on design, development, enhancement, and automation, tuning and optimizing databases for high Availability, Performance and Security.

Proficiency in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS).

Experience in integration of various data sources like SQL Server, Oracle, Access DB, DB2 and Flat File, Excel File.

Familiarity in Huge Data Migrations, using SSIS, Bulk Copy Program ( BCP ) and Bulk Insert (BI).

Highly proficient in packages to extract, transform and load data (ETL) using SSIS, Designed packages which are utilized for tasks and transformations Data Conversion and Pivot tables.

Experience in Power BI, creating interactive visualizations, dashboards, reports based on business requirements.

Extensively worked on Control Flow Tasks such as For each Loop Container, Data Flow Task, File System Task, Script Task, Execute SQL Task, FTP Task, Execute Process Task and Send Mail Task.

Strong experience with T-SQL (DDL & DML) in implementing and developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, Indexes, User Profiles and Relational Database Models.

Experienced in BI Development and Deployment of SSIS packages from MS - Access and Excel.

Documented the technical architecture of the data warehouse, including the physical components, their functionality, source data and ability to integrate with existing system architecture.

Strong experiences to design, deploy, and maintain various SSRS reports in SQL Server.

Excellent experience in designing and developing stylish and complex reports like reports using Drill Down, Sub Reports, Cascading parameters, Drill-Through Reports, Parameterized Reports, Chart Reports and ad-hoc reports using Global variables, Expressions and Functions for Business Users using SQL Server Reporting Services (SSRS).

Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.

Strong concepts of Data Warehousing, strategies for ETL, identifying metrics, dimensions, hierarchies, and design dimensional schema (Star, Snowflake) and implementing slowly changing dimension etc.

Familiar with database normalization in database designing. Adept in creating ER diagrams and mapping the data into database objects.

Experience in configuration of report server and report manager scheduling, give permissions to different level of users in SQL Server Reporting Services (SSRS).

Experience in building and writing MDX Queries, Calculated Members, and KPI’s using Microsoft SQL Server Analysis Services Business Intelligence (SSAS, SSRS).

Experience with software development life cycle (SDLC), Agile, Scrum and Project Management Methodologies.

Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP and SMTP.

Involved in coding new and maintaining current business applications and systems using SQL.

Experience in developing testing and debugging.

Excellent interpersonal skills with problem solving and analytical skills.

Strong communication skills (oral and written) along with good organizational skills.

TECHNICAL SKILLS

Languages

T-SQL, PL/SQL, C, C++

Operating Systems

MS-DOS, Windows Server 2012/2008/2003/ XP/NT 4.0/98/95, UNIX

Database Tools

MS SQL Server 2016/2014/2012/2008 R2/2005, Oracle 11g/10g/9i/8i, TOAD 7.5, 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

SSIS, SSRS, SSAS 2016/2014/2012/2008 R2/2005

Data Modeling Tools

Power Designer, MS Visio, ERWIN

Reporting Tools

MS Reporting Server(SSRS), Excel Power View

Packages

MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS), Microsoft Performance Point Server

Work Experience

Memphis Light Gas and Water, Memphis, TN Apr 2019 to Till date

Role: MSBI/SSRS/SSIS Developer

Responsibilities:

Involved in analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.

Designed automated scripts in T-SQL and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity.

Created Efficient Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL scripts.

Responsible for Query optimization and Performance tuning.

Involved in Debugging Issues as a part of Production Support.

Designed Database Maintenance Planner for the Performance of SQL Server, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.

Build efficient SSIS packages for processing fact and dimension tables with complex transforms.

Extract, Transform and Load source data into respective target tables to build the required Data Marts.

Created ETL process using SSIS to transfer data from heterogeneous data sources.

Worked on Deployment of packages into Production servers and managed scheduled SQL jobs.

Created a variety of reports using SSRS including matrix report, Parameter Report, Dashboard, Charts, Drill-down, Drill- through, Cascade parameterized Report, and Configured Report Server

Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.

Experience in developing interactive data visualization reports, and dashboards using Power BI Desktop.

Used Microsoft Power BI Power Query to extract data from external sources and modify data to certain format as required in Excel, and created SSIS packages.

Designed aggregations and pre-calculations in SSAS.

Monitoring SQL server performance using SQL Profiler, Query analyzer, Index Tuning Wizard and Windows Performance Monitor.

Created sophisticated calculated members using MDX queries and designed and created aggregations to speed up queries and improve performance in SSAS.

Planned, coordinated analysis, design and extraction of encounter data from multiple source systems into the data warehouse database while ensuring data integrity.

Experience working with XML documents, strong report/dashboard design experience and passionate practitioner of effective data visualization.

Monitoring and scheduling daily, weekly and monthly SQL Server jobs and debug any issues related with failed jobs or data discrepancy.

Generated on-demand and scheduled reports with SSRS for business analyses and managerial decisions.

Implemented a well-planned Backup and Restoration strategy that protects databases against data loss due to damage caused by a variety of failures.

Environment:MS SQL Server 2012/2014/2016,MS SQL Server ReportingServices(SSRS),MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services, Microsoft Visual Studio, Query Optimizer, MS Excel, MS Visio.

Sirius XM,Irving TX Jun 2017 to Mar 2019

Role: MSBI/SSRS/SSIS Developer

Responsibilities:

Worked on Full life cycle development (SDLC) involving in all stages of development.

Involved in system study, analyze the requirements by meeting the client and designing the complete system.

Developed complex SQL Server (T-SQL) queries with Sub Query, Derived Query, Joins, Union, CTE, Stored Procedures, Functions, Views, Triggers, Dynamic SQL etc.

Used SQL Profiler to estimate the slow running queries and Database Tuning Advisor for performance tuning purpose.

Generated SSRS Reports involving different features like Reports, Sub-Reports, Drilldown, Drill-Through, Charts, Filters, Multi-valued parameters and linked reports in SSRS.

Involved in developing ETL for loading data into Database.

Extracted data from various heterogeneous sources and created packages using SSIS, Import/ Export Data, Bulk Insert and BCP utilities.

Worked with various SSIS control flow tasks and data transformations like Data Conversion, Derived Column, Look-up, Fuzzy Look-up, Conditional Split, Aggregate transformations etc. as part of ETL.

Created SSIS Packages to load variety of large volume data into data warehouse from different sources like CSV files, Text files and Excel Spreadsheets.

Creating Packages on SSIS by using different Data Transformations like Derived Column, Conditional Split, Pivot, Multicast, Sort and Execute SQL Task to load data into data warehouse.

Widely worked on to improve SQL Query performance, SQL Query analytics and highly complex joins to populate the desired result set.

Extensively worked on Design and development of SSIS (ETL) packages to extract, transform and load data from different Sources like Excel files, flat files to the Data warehouse using different tasks and transformations like File System Task, Data Flow Task, Derived Columns, and Execute SQL Task.

Comprehensively worked on SQL scripts using local and Global Temp Tables, Variables and Table Variables, Common Table Expressions (CTE) as per the requirement and convenience.

Used Report manager and Power BI to deploy reports, schedule reports and created groups and users.

Created different types of Tabular reports like Cascaded Parameters, Drill through, Drilldown, sub-reports and Matrix reports and developed some graphical reports using Report Designer.

Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.

Wrote complex SQL Queries using multiple joins for creating reports using Report builder based on the requirements.

Designed SSIS packages to load data from source to Data Warehouse.

Created different Facts and Dimension tables to increase the performance of complex SQL queries that are used in SSRS reporting.

Created mappings and workflows as per the business requirement.

Designed and Implemented plan for the moving data to various destinations.

Designing Logical and Physical Data Model with Erwin r7.

Worked on analysis of the data and develop plan based on the ETL specifications.

Environment: Microsoft SQL Server 2014/2012/2008/ R2, Data stage ETL, SSDT, Microsoft Excel, SSIS/SSAS/SSRS 2012/2008, Microsoft Office, Power BI, Profiler, Visual Studio, Microsoft TFS, BIDS.

LA HEALTH CARE, Los Angeles, CA Feb 2015 to May 2017

Role: MSBI Developer

Responsibilities:

Involved in writing stored procedures, Triggers, User-defined Functions, Views and Cursors for both Online and Batch requests handling business logic and functionality of various modules

Involved in performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Taking Database Full Backup, Transaction log backup & differential backup in daily routine.

Traced long running queries and deadlocks using SQL Profiler.

Automated Stored Procedures to load data into staging and production environments in a timely manner using SQL Server Agent.

Developed complex stored procedures using T-SQL to generate Ad hoc reports within SQL Server Reporting Service (SSRS).

Worked on Power BI and prepared dashboards to make it more attractive and explored data in a variety of ways and across multiple visualizations using Power BI.

Involved in Installation, Configuration, and Deployment of Reports using SSRS.

Scheduled the reports to run on daily, weekly basis in the report manager.

Created SQL server jobs to execute SSIS packages according to the load type of the data.

Involved in writing stored procedures to create table structures in stage and pulling data from metadata.

Involved in creating marts and developing mart views used for the report building.

Created SSIS packages templates to clean and load data to parallel data warehouse, including error handling and metadata management.

Designed and deployed reports with Drill Down, Drill Through, Matrix Reports, Chart Reports and Drop down menu option and Parameterized and Linked reports.

Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports.

Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.

Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.

Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.

Used the SSIS Configuration files to make the packages connections, variables etc. Configurable and maintained the same on Test and Production environments.

Involved in designing reports and delivering them by any of the delivery methods like standard subscriptions, data-driven subscription, URL access etc

Experience in using SSRS gateway service calls to and from SSRS reports.

Created multiple Data Driven Subscriptions that delivers Power BI reports as excel and PDF output on network file system

Created multiple Email Data Driven Subscriptions that sends email to top-level executives consisting of different reports that helped in taking financial decision and future business strategies.

Discovered and corrected critical bugs in the data migration process that led to in-correct data being reported to clients and government reporting

Generated daily, weekly and monthly reports for the managers.

Developed Stored Procedures to populate various dimensional tables and the fact tables for the Data Warehouse

Used ETL to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.

Environment: MS SQL Server 2012/2010/2008, Business Intelligence Development studio (SSRS/ SSAS/SSIS), Oracle 11g/10g/9i, MS Office Access 2003 and Visual Studio 2008, .Net 3.5, Team Foundation Server 2010, Agile Methodology (Spring, SCRUM), T-SQL

GE Aviation, Cincinnati, OH Nov 2013 to Jan 2015

Role: MSBI Developer

Responsibilities:

Worked on T-SQL programming, stored procedures, user defined functions, cursors, views, and management of linked servers to non-SQL server database.

Developed the SQL Server Integration Services (SSIS) packages to transform data from SQL to MS SQL as well as Created interface stored procedures used in SSIS to load/transform data to the database.

Createdseveral Schemas, Tables, Cursers, Triggers and Indexes, Identity Column, Identity Seeding, Calculated Columns as per the requirement.

Worked in troubleshooting and debugging stored procedures, upgrading existing ones according to new requirements.

Developed packages using various transformations like Multicast, Conditional split, OLEDB Command, Script Component and Lookup while loading the data into Destination.

Migrated data from Heterogeneous Data Sources and legacy system (DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.

Written T-SQL statements for retrieval of data and Involved in performance tuning of TSQL queries and Stored Procedures.

Used agile methodology for the development.

Used SSIS jobs for importing data from the flat files that brings the data to the application tables.

Extensively used Joins to simplify complex queries/sub queries involving multiple tables and also optimized the procedures and Indexes, Cursers and triggers.

Created reports by dragging data from cube and wrote MDX scripts in SSRS.

Generated KPI for customer satisfaction survey results.

Created complex stored procedures and user defined functions, created many cascaded parameters in the reports using MDX and SQL queries.

Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SSIS.

Used Team Foundation Server (TFS) for source control, and data collection.

Created parameterized Reports using Charts, Cross-Tab and Sub-report types.

Worked on SQL *Loader to load data from flat files obtained from various facilities every day.

Created user groups and accounts for users who could access the reports, generated Daily, Weekly and Monthly Trigger based reports concerning assigned projects to clients and designated Managers.

Environment: Microsoft SQL Server 2012/2008 R2, Microsoft Excel, SSIS/SSAS/SSRS 2012/2008, Microsoft Office, MS VISO, Crystal Reports XI Release, Profiler, Visual Source Safe, Microsoft TFS, BIDS, Visual Studio.

HDFC Bank, India Sep 2012 to Oct 2013

Role: MSBI Developer

Responsibilities:

Worked closely with BA, DBA to analyze business model, gather project requirement, and translated user requirements into conceptual, logical and physical data models.

Developed, modified, and optimized complex queries to data retrieval and modification.

Wrote custom T-SQL stored procedures and triggers to improve performance, preserve referential integrity, and provide additional application functionality.

Create and test DTS packages for importing and exporting data from data warehouse.

Created Dashboards, Sub-Reports, Drilldown-Reports, Summary reports, and Matrix reports in SSRS.

Created triggers and audit tables in order to capture the incremental data from OLTP and created complex stored procedures to perform data profiling in the pre-staging database.

Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.

Scheduled replication on the databases.

Actively participated in meetings to decide backup policies for database & perform back up operations on databases.

Performed Join operations using on large scale database tables.

Extracted data from Oracle DB using Import Export Wizard in SQL Server Management Studio.

Used tools such as SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for monitoring and tuning MS SQL Server performance.

Documented the procedures and process.

Tuned and Optimized SQL Queries using Execution Plan and Profiler.

Rebuilding Indexes and Tables as part of Performance Tuning Exercise.

Environment: SQL Server 2008/2005/2000, Windows Server 2003 R2 Enterprise.

Contact this candidate