MSBI Developer
Resume:
Anvitha
**********@*****.***
PROFESSIONAL SUMMARY:
7+ years of experience in designing, developing & extending Microsoft BI & Sql Server Databases
I have been working on Sql Server OLAP & OLTP Databases, Sql Server Integration Services (SSIS), Reporting Services(SSRS), Analysis Services (SSAS) &Power BI (Power View, Power Pivot, Power Query, Power Map),SharePoint, Data Mining, MDX, DQS, strong background in SQL Server2014/2012/2008R2/2008/2005, stored procedure development and triggers.
I started working with Sql server 2005 and currently working on Sql Server 2012 SP2.
I am very strong in T Sql and design the tables that have 1-many & many-many relations.
My day-to-day work involves designing & Implementing SSIS Packages, SSRS Reports & Power Pivot Reports on top of a 650 GB OLAP database.
I have worked on a 4GB Tabular Model and exposed the measures/aggregations through self-service Power View Reports& excels. Power Views are hosted in a SharePoint.
Prepared Power Pivot reports for smaller data-sets and refreshed the Power-Pivots in SharePoint.
I design & Implement facts & dimensions as needed for the Tabular Models.
Used SSIS ETL tool for implementing Full & Incremental loads.
Used Custom Logging, Error Handling in SSIS.
Good knowledge of data flow buffers, execution trees, Synchronous & Asynchronous Transformations.
Built SSIS scripts with .Net code to implement the business functionality & setting variables.
Good knowledge in developing and designing reports through SSRS and Excel.
Expert in drill down and drill through reports using SSRS. Developed adhoc SSRS Reports using Sql Server Report Builder.
Expertise in Documenting user requirements, low level technical design, implementations and user guides using Agile Scrum Methodology and Kimball Methodology.
Extensively worked with clients of Insurance, Healthcare, Financial environments with primary skills on the Analysis, Design, Development, Implementing and Testing Client/server application using Microsoft SQL Server and BI suite to understand business requirements, recommended technical solutions and documented functional requirements.
Prepared deployment scripts using Sql cmd, DTEXEC& Sql Server jobs.
Analyzing & gathering sql query plans for Query Optimization.
Experience in handling Production issues using SQL Profiler.
Expert in writing MDX queries with extensive experience in creating and customizing Cubes using SQL Server Analysis Services (SSAS).
Developed unit test automation scripts using Sql server test project.
Good understanding of Data Management and Data modeling concepts such as Design of the Dataflow, ER Diagrams, Use Cases, Normalization and De-normalization of Tables.
Worked with scripting languages like HTML, CSS, XML.
Experience in developing Custom Report and different types of Tabular Reports, Matrix Reports and Ad hoc reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS). Rendered excel & pdf reports by using data-driven subscriptions in SSRS.
Good in Erwin Data Modeler and ER studio.
Excellent communication, interpersonal, analytical skills and strong ability to perform as part of a team.
TECHNICAL EXPERTISE:
OPERATING SYSTEMS
Windows 8.1/8/7/vista/XP/2003
DATABASE
SQL Server 2005/2008 R2/2012 SP2/2014
SQL Server Tools
SQL Server Management Studio, Sql Server Data Tools, BIDS, SQL Profiler, Query Analyzer
ETL Tools
SQL Server Integration Services (SSIS), DTS
Reporting Tools
SQL Server Reporting Services (SSRS), Power Views, Power Pivot, MDX, DAX
SCRIPTING
Microsoft Command Shell Scripting
Languages
C#, VB.Net
Web services
Soap, Restful
Web Servers
IIS
Web Technologies
XML,HTML,CSS, Java script
PROFESSIONAL EXPERIENCE :
Client: WASHINGTON HEALTH BENIFIT EXCHANGE, WA Nov ’13 – Till Date
Role : BI Developer
Responsibilities:
Analyze business requirements/processes and system integration points to determine appropriate technology solutions.
Designed, developed and deployed the OLAP database project
The tables used to have 100+ million records. Query Tuning of slow running queries.
Designing data warehousing Fact & Dimension tables using star and snow flake schema.
Prepare Data Mart, Multi dimensional, Tabular Model using SQL Server Analysis Services.
Implemented Aggregations & Partitions on the Tabular Model. The Tabular Model is browsed from Power Views on the SharePoint. The month-level Partitions are processed on a daily basis.
Responsible for Extraction, Transformation and Loading (ETL) of data from multiple up-stream sources to Database. Up-stream sources are OLTP, excel, SharePoint lists& Azure Sql Database.
Developed Power Pivots when aggregations are needed on top of few million records. Mostly these were used as Proof of concept reports by the Client.
The Power Pivots are refreshed from the SharePoint.
Worked on SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
Designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
Developed complex procedures and functions, views, triggers and batch processes in TSQL (Sql Server 2012 SP2). This is a 650 GB Sql Server OLAP database.
Expertise in Dynamic SQL using sp_execute Sql and Exception handling.
Worked extensively on Common Table Expressions to retrieve hierarchical data from tables.
Partitioned large Tables into different File groups.
Involved in performance tuning and troubleshooting issues using Sql Profiler& Sql Trace.
Make changes to the table schema, impact analysis of the schema changes.
OLAP design (SSAS) for different cloud services such as azure database. Implemented OLAP cube and connecting using Excel Power Pivot.
Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
Involved in ER diagrams (Physical and Logical using Erwin) and mapping the data into database objects.
Defined cubes, dimensions, user hierarchies, aggregations in an OLAP environment (SSAS).
Involved in Migration of Databases from SQL Server 2005 to SQL Server 2008 using SSIS.
Used script task, lookup & control flow tasks like FTP, Bulk Insert Task, Transfer Job Task etc
Implemented the custom logging & Error Handling for both control flow &data flow tasks.
Preparing the builds that deploy and rollback all the above changes to SIT, UAT and Production databases.
Environment: SQL Server 2008 R2/2012 SP2,Visual Studio 2012/2010,Sql Server Management Studio, ER Studio, TFS,SSIS, SSAS, SSRS, Azure SQL Data base, OLTP, OLAP, ETL,C#, Power-BI Desktop,ERWIN.
Client:ICICI BANK, NY SEP ‘12 – Oct ‘13
Role: BI& Reports Developer
Responsibilities:
I developed totally 35 Complex SSRS Reports in this project from a Dynamics CRM OLTP system.
Developed 7 dashboards using the out-of-the-box charts available in the Dynamics CRM system.
Written complex TSQL procedures for SSRS Reports. Developed analytical reports using matrix control.
Coordinate with the onshore team and raise the queries or gaps that we find in the business documents.
Optimize the slow running Queries by analyzing the sql plans.
Experience in writing the Ad-hoc reports by SSRS Reports Builder.
Designed & modeled databases using Data Flow Diagrams, ER diagrams, Process Models, Dimensional Data Models and SDLC concepts.
Created Database Objects – Schemas, Tables, Indexes, Views, User defined functions, Cursors, Triggers, Stored Procedure, Constraints and Roles.
Developed Excel reports (Regular, Power Pivot). Gave a demo on using Power View to the client.
Implemented cascading parameters in SSRS Reports.
Proficient in writing parameterized queries for generating Tabular, Matrix, Drill-Down, Drill-Through, Linked, Sub reports, List and Chart reports using global variables, expressions, and functions, sorting the data and defining data sources for the reports usingSSRS2012/2008/2005.
Written sql scripts that inserted 7+ million records into all the transaction tables in 70 minutes for Performance testing. Batched records to insert into the database.
Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
Had involved in Start to end of enhancements projects like creating Business Required Document (BRD), Developing, Testing, creating Unit test scripts and UAT test scripts and involved in production moves for releases.
Experience in writing expressions in SSRS and Expert in fine tuning the reports.
Rebuilt the indexes at regular intervals for better performance.
Implemented SSAS Cubes, Facts and Dimension tables to perform analysis services as a Proof of concept for the client.
Developed Trend Lines, Groups, hierarchies, sets to create detail level summary report and Dashboard using KPI's.
Used data driven subscriptions to schedule the report generations as excel on a daily/weekly basis.
Environment: Sql Server 2008 R2, Visual Studio 2012, TFS, Sql Server Management Studio, C#.
Client: YMCA of Metropolitan, Chicago, IL FEB ‘12 – AUG ‘12
Role : BI Developer
Responsibilities:
Involved in design, development, testing and implementation of the application.
Adding the indexes to high volume tables to improve performance
Written SSIS Packages to import data from upstream systems to Inventory Modeling system.
Implemented the custom logging & Error Handling for both Control flow & Data flow tasks
Integration testing as this system involves many independently working systems.
Preparing the builds that deploy and rollback all the above changes to SIT, UAT and Production databases.
Deployed the SSIS packages to different environments using XML & SQL Server configurations.
Conducted training sessions to end-users.
Designed SSIS packages to Extract Data from different sources like Flat Files, Excel Files, SQL Server and Transform them and then load into Dimension and Fact tables in Data Warehouse using SSIS.
Responded to ad hoc requests and special projects that require immediate attention while at the same time maintaining deadlines on existing requests.
Designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
Created different types of reports such as Drill-down, Summary and Sub reports, and formatted them and Performed unit testing at various levels.
Environment: SQL Server 2008 R2, Microsoft Visual Studio 2008, TFS, ERWIN.
Client : Icrea Infotech Pvt Ltd, India DEC ’10 – JAN’12
Role : SSIS/SSRS Developer
Responsibilities:
Involved in various SDLC Life cycle phases like development, deployment, testing, documentation, implementation & maintenance of application software.
Understand the existing Stored Procedures. Modify and develop the complex Stored Procedures to incorporate the business rules.
Experience in creating SSIS package using dataflow tasks, script tasks, for loop container, for each loop, sequence container. I have used transformations like Lookup, Multicast, Derived Columns, Condition Split, Term Extraction, Aggregate and Slowly Changing Dimension.
Make changes to the table schema, impact analysis of the schema changes, retrieve the parent-child relations in the functions using Common Table Expressions.
As this is an OLAP database, I always used to remember the approximate number of rows that will be populated in each of the base tables when the OLAP process runs once in every week and just seeing the count in these tables, I was able to nail down the root causes of many issues.
I was responsible for database tables design and developed the complete functionality using procedures and functions.
Configuring the sql jobs and batch jobs.
Worked on implementation and maintenance of disaster recovery solutions such as replication and log shipping.
Managing historical data from various heterogeneous data sources (i.e. Excel, Flat and Access).
Prepare the Install and Rollback builds for deployment to SIT, UAT and Production environments. Used sql cmd command to deploy all the database files.
Environment: SQL server 2005, TSQL, Windows XP, SQL server Management Studio, TFS,BIDS, MS Visio
Client : Millicom International Cellular S.A., India NOV ’08 – Dec ’10
Role : TSQL Developer
Responsibilities:
Understanding the business requirements, writing functional specs, test specs and plans.
Responsible for production support and bug fixing.
Experience in migration from heterogeneous sources including Oracle to MS SQL Server.
Experience in T SQL, Table Partitions, Views, Stored Procedures, Functions, Triggers, Common Table Expressions and Indexes.
Handled errors using Exception Handling extensively for the ease of debugging and displaying the error messages in the database.
Worked on implementation and maintenance of disaster recovery solutions such as replication and log shipping.
Involved in ER diagrams (Physical and Logical using Erwin) and mapping the data into database objects.
Used linked servers to transfer data between different Sql Servers.
Excellent in scripting UNIX and LINUX commands.
Experience in OLAP System Study, Analysis and E-R modeling, understanding in developing Database Schemas.
Excellent Database administration(DBA) skills including user authorizations, Database creation, Tables, indexes and backup creation.
Good knowledge of soap & restful web services.
Environment: SQL server 2005, TSQL, Web logic, Windows XP, SQL server Management Studio, BIDS
EDUCATION
Bachelor of Technology from J.N.T. University, India
Contact this candidate