SUMMARY:

• Have around 6 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, DataMining, MDX, DQS, strong background in SQL … 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 TSql 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 Sqlcmd, 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 SKILLS:

Operating Systems: Windows-XP, 7, 8 and 10.

Reporting Tools: SQL Server Reporting Services (SSRS), Power Views, Power Pivot, MDX, DAX

Database Experience: Microsoft SQL Server 2012/2008/2005

ETL Tools: SQL Server Integration Services (SSIS), DTS

Scripting: Microsoft Command Shell Scripting

Languages: C#, VB.Net

Web Services: Soap, Restful

Web Technologies: XML, HTML, CSS, JavaScript

PROFESSIONAL EXPERIENCE:

Confidential, Waukegan, IL

Power BI Developer/ Data Analyst

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 executeSql 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.
• Installed office 365 in my personal laptop and worked by connecting to power bi service.
• 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 Database, OLTP, OLAP, ETL, C#, Power-BI Desktop, ERWIN.

Confidential, San Francisco, CA

Power BI Developer / Data Analyst

Responsibilities:

• 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, PowerPivot). 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 using SSRS 2012/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#.

Confidential

T-SQL 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, Weblogic, Windows XP, SQL server Management Studio, BIDS