SUMMARY

• Over 5+ years of experience as Business Intelligence /SQL Developer and Data Analyst.
• Experience with Data Warehousing, Business Intelligence solution design and implementation.
• Extensive experience on implementation of T - SQL, SSIS, SSRS, Tableau and power BI utilizing software and hardware components within a creative and technology-driven organization for Web, Client-Server Systems and Applications over Insurance, Banking, health care and Manufacturing domain
• Experience in Software Design, Development, Integration, Implementation of Data Warehousing & Business Intelligence Applications in Microsoft BI (SSAS, SSIS, SSRS), Power BI, ETL Design & Development, BI/DW, Tableau Desktop, Tableau Server, OBIEE and Power BI.
• Worked extensively inSQL Server 2008, 2012& 2014.
• SQL Server 2014/2012/2008.
• Experienced in Installing, Upgrading and Configuring Microsoft SQL Server 2008/2005/2000.
• Experience in writing complex SQL queries involving multiple tables inner and outer joins.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views.
• Scheduled and maintain packages by daily, weekly and monthly using SQL Server Agent in SSMS.
• Expert in TSQL DDL/DML, perform most of the SQL Server Enterprise Manager and Management Studio functionality using T-SQL Scripts and Batches.
• Optimized query performance by creating various clustered, non-clustered indexes and indexed views and populated test data.
• Experience with SQL server and in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, data dictionaries and integrity.
• Strong in Data warehousing concepts Dimensional Modeling, Star Schema / Snowflake Schema, Fact and Dimensional Tables.
• Used the SSIS for extracting, transforming, and loading data into data warehouse.
• Create SSIS Packages used Control flow, Data flow and tasks according to business requirement.
• Created different transformations for loading the data into Oracle and SQL database which includes (*Lookup*, *conditional split*, *SCD*, *Pivot*, *multi cast*, *merge join*, Data conversion, Script task and many more).
• Experience in SQL Server Reporting Services (SSRS) Development, Deployment and Support.
• Proficiency in creating different types of reports such as Cross-Tab, Drill-down, Form, OLAP, Dashboard reports, Sub reports and Linked Reports, and formatting them using both SSRS 2005/2008.
• Sending the reports from different output file format into different end users using Standard and Data Driven Subscriptions.
• Experience in configuring automation reports using various delivery mechanisms like Email Links, PDF attachments and Excel attachments.
• Experience in deploying reports in various sources like Web browser, XML and PDF.
• Experience in OLAP Cube Creation (Created many multidimensional *cubes* Using SSAS of SQL Server 2012/2008/2005 ).
• Experience in Relational and Dimensional Modeling, Designing of Star, Snow Flake Schemas, Development.
• Experience in creating SSAS 2012/2008 cubes, MDX queries, working with facts, dimensions, hierarchies, Perspectives.
• SQL AZURE / Microsoft Cloud Database Service
• Create Database(s) on SQL AZURE.
• Setting up SQL Azure Firewall.
• Create, manage SQL Server AZURE Databases Setting up Connection Strings and connecting SQL Server AZURE Databases from locally Installed SQL Server Management Studio(SSMS) for Developers
• Design and development of data warehouse ETL and building and publishing complex Power BI Reports.
• Involved in large data pulls from various source systems and creating complex Excel reports, Adhoc reporting.
• Created complex DAX calculations in Power BI, created data models and implemented one to many relationships.
• Complex reporting in Power BI to provide users advanced slice and dice functionality.
• Created database backup jobs and automated the end to end data flow and scheduled it.

TECHNICAL SKILLS

Languages: SQL, T-SQL, PL/SQL. C, VB 6.0, XML, Python.

Databases: SQL Server 2014, 2012/2008/2005 /, Oracle 9i/8.x, 10g, 11g, DB2 MS Access

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Reports XI/10/9, Power BI, tableau, Excel

ETL Tools: SSIS (SQL Server Integration Services), DTS (Data Transformation Services), Import Export Data, Bulk Copy Program (BCP)

Other Software: MS Office- 2007/2003/2000 , Adobe Professional, SharePoint

Operating Systems: Windows / 98/2000/2003/ XP/Vista/8

Database Tools: ERWIN, SQL Query Analyzer, SWIFT Tool, SQL Enterprise Manager, SQL Server Management Studio(SSMS), SSDT 2012, SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server, Business Intelligence Development Studio(BIDS), Visual Studio 2013, TFS

Methodologies: Logical and Physical Database Design, UML, Database Design and Normalization, Data Modeling

PROFESSIONAL EXPERIENCE

Confidential | Sunnyvale

SQL BI Reporting Analyst/DBA

Responsibilities:

• Involved in complete Software Development Life Cycle.
• Worked on T-SQL concepts like indexes, function, join, Constraints, Keys, and Import/export data and wrote dynamic stored procedure scripts.
• Created database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, Oracle, DB2etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
• Worked on many SSIS transformations like Data Conversion, Derived Columns, conditional split, Merge and used Loop Containers
• Loaded EDW tables using Type-2 and TYPE-3 slowly dimensional modelling.
• Worked on different data warehouse concepts mainly SCD types, facts and Dimensional Tables.
• Created packages in SSIS with error handling, worked with different methods of logging in SSIS.
• Worked on building and deploying the packages from Development to Test to production environments using XML configurations and environment variables, developed staging tables and configured SSIS packages on loading these tables.
• Ability to validate data, test and confirm code to meet specification.
• Worked on Dynamic Management Views to find duplicate indexes, unused Indexes and most beneficial indexes for the given Table name.
• Figuring out which index need to be removed based on the index seek, scan and read.
• Used SQL server profiler to Tuning jobs to minimize the runnable time.
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Involved to planning and designing SSAS 2012 Cubes and building attribute relationships for optimal MDX query performance of Hierarchies and Fact Dimensions.
• Involved in performing Audits and recovery operations of SSAS objects.
• Enforcing data Quality rules to upstream source using different tools. Conducted UAT, regression and shakeout testing in the production environment.
• Experience in Creating Data Models and Relationships in Excel reporting and Experience in Creating different Excel graphs and reports.
• Expertise in writing Excel functions like VLOOKUP, SUM… and DAX Formulas.
• Created Business Logics in SQL to solve Complex Calculation like Year to Date and Quarter to Date Calculations.
• Experience Writing DAX in PowerBI Desktop to Create measures and custom columns.
• Developed and Published Quality Reports in the Organization.
• Created Database for the All Reports as per the Requirement and Created Reports On top of the Database.
• Worked on Taking DB Backups Such as Full, deferential and Transactional Backups by Creating Maintenance Plan and SQL Jobs.

Environment: SQL Server 2014,2012, SSDT 2012, Query Analyzer, SSIS, SSRS, T-SQL, Power BI, Windows 10, Excel

Confidential | Marshalltown, IA

SQL BI Developer/Business Analyst

Responsibilities:

• Responsible as SQL BI developer for the customer support data of MS products like Xbox/ Windows/ Office. The BI dev activities include SQL DB dev/SSIS/SSRS and testing.
• Developed data warehouse to handle large data pulls daily by doing parallel load in SSIS and by SQL Server partition switching.
• Creating tables, running ETL jobs, writing dynamic scripts to generate stored procedure, creating tables etc.,
• Creating packages in the solution explorer (In EXTRACT, TRANSFORM AND LOAD) and writing SQL query in data flow task, creating variable, error handling process and writing functions.
• Creating project parameters for different regions. And maintaining package logs by SQL server in SSISDB database. Query in internal packages table in SSISDB to view execution performance, analyze performance and tracking logging message of the execution.
• Describing environments names from which data is coming and deploying the packages in the solution explorer to catalog which is in management studio.
• Testing the table in DW to load data to catch many errors like data type violation, NULL constraint violation, foreign key violation and duplicate data.
• Generating reports to maintain zero percent error’s in all the data warehouse tables.
• Writing quires to dynamically generated stored procedure, creating table and catching errors.
• Applied various data transformations like Data Conversion, Multicasting, Conditional Split, Derived column in SSIS.
• Wrote SSIS Packages to migrate user's logins, stored procedures, and functions.
• Involved in designing the SSIS packages to export data from SQL Server database to flat file source.
• Wrote SQL queries to retrieve specific information from the database to make sure that the data entered has been up-loaded correctly in to the database.
• Developed AdvancePL/SQL packages, procedures, triggers, functions, IndexesandCollectionsto implement business logic usingSQL Navigator.
• Checking the production environment jobs and troubleshooting the failed jobs.
• Worked on Creating Tabular Model by creating model and relationships between Facts and Dimensions.
• Creating row level Security for the specific Roles and for regional Security in the Tabular Model Using DAX.
• Created Multiple Measures and Calculated Columns as per the Requirements Using DAX.
• Writing some of the basic power queries to create a measure.
• Worked on Proof of Concept(POC) for Creating PowerBI Waterfall Chart. Created Custom reports in PowerBI, like Custom Waterfall Chart with Multiple Measures.
• Created and Developed Dashboards for the End Users and End to end Support for the Power BI reports.
• Maintained version control and code quality for our code base in TFS.
• Generated Weekly Status Reports and Dashboards using Visual Studio Online (VSO) by using Power BI Dashboard.

Environment: SQL Server 2012, SSDT 2012, Query Analyzer, VS 2013 TFS, SSIS, SSRS, T-SQL, Windows 8, SharePoint, Scope, Power BI desktop, Visual studio.

Confidential | Richmond, VA

BI Analyst

Responsibilities:

• Worked on T-SQL concepts like indexes, function, join, Constraints, Keys, and Import/export data also wrote dynamic stored procedure scripts.
• Developing SQL queries and writing DMV’s.
• Wrote SQL queries to retrieve specific information from the database to make sure that the data entered has been up-loaded correctly in to the database.
• Performed SQL Server tools like SQL Performance optimization using SQL Server Profiler and Database Engine Tuning Advisor.
• Involved in SSIS Package maintenance
• Wrote SSIS Packages to migrate user's logins, stored procedures, and functions.
• Involved in designing the SSIS packages to export data from SQL Server database to flat file source.
• Effectively worked in production support and managed the quality assurance for SSIS packages.
• Effectively loaded data into relational database using ETL tool.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Developed formatted, complex reusable formula reports and reports with advanced features such as conditional formatting, built-in/custom functions usage, multiple grouping reports in Tableau.
• Used BCP command and TSQL command to bulk copy the data from Text files to SQL Server.
• Used different Mark types and Mark properties in views to provide better insights into large data sets.
• Created External filter, internal filter and Context filter to improve performance. Used Data Blending, groups, combine fields, calculated fields, and aggregated fields and spotlighting to compare and analyze data in different perspectives.
• Preparing Dashboard reports based on the performance of servers.
• Tested different types of reports before moving it to the production

Environment: SQL Server 2012/2008R2/2005, Query Analyzer, Enterprise Manager, TFS, SSIS, SSRS, T-SQL, Windows 2000/XP, SharePoint server 2007, Tableau.

Confidential

SQL Developer

Responsibilities:

• Efficiently used Microsoft SQL server management studio
• Created and developed stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Good working knowledge on Agile Projects.
• Developed SQL queries to validate data in tables based on business requirements.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Extensive use of T-SQL DDL and DML commands for various applications.
• Developed and Optimized Stored Procedures, Views, and User-Defined Functions for the Application.
• Involved in creating SSIS jobs to automate the reports generation and cube refresh Packages.
• Configured Server for sending automatic mails to respective people when a SSIS process failure or success.
• Deployed SSIS package into production environment and used package configuration to export various package properties to make package environment independent and scheduled Jobs using SQL Server Agent.

Environment: MS SQL Server 2005/2008, SQL Server Integration Services (SSIS), SSRS, Business Intelligence Development Studio (BIDS), MS Excel, Team Foundation Server (TFS), Windows XP, VBScript.

Confidential |Atlanta, GA

Intern BI Developer

Responsibilities:

• Filtered bad data from legacy system using complex T-SQL statements and implemented various types of Constraints and Triggers for Data Consistency.
• Used DDL and DML Triggers, Stored procedures to check the Data Integrity and verification at early stages before calling them.
• Used SSRS to create interactive reports with an ability to drill down into details.
• Used SQL Server Integration Services (SSIS) and its tools to Extract, Transform and Load data into Data Ware House.
• Designed and developed parameterized reports, linked reports, List, Chart, Sub reports, matrix and tabular reports with drill through and drop down menu option using SSRS.
• Developed, deployed and monitored SSIS Packages. Involved in creating log files for SSIS packages.
• Created SSIS Package configurations for executing in different environments.
• Enabled Check points in SSIS Packages and Created break points to view the status of data, variables and over all status of SSIS package.
• Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.

Environment: SQL Server 2008R2/2005, Query Analyzer, Enterprise Manager, DTS, SSIS, SSRS, T-SQL, Windows 2000/XP, SharePoint server 2007.