SUMMARY

• 8+ years of experience in IT, as MS SQL Server Developer in Windows environment.
• Extensive experience with SQL Azure, SQL Server 2014,2012, 2008R2, 2008, 2005 and worked extensively on BI Tools like Integration services (SSIS), Reporting services (SSRS) and Analysis Services (SSAS).
• Expertise in Database design, Entity Normalization & Database Creation, Maintenance, Monitoring.
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshooting SQL Server 2014/2 /2000.
• Expert in using tools like SQL Profiler, Index tuning, Windows Performance for monitoring and tuning MS SQL Server performance.
• Extensive experience in T - SQL (DDL, DML, DCL), Views, Stored Procedures, Cursors and Triggers.
• Experienced in Extraction, Transformation and Loading (ETL) process using Data Transformation Services (DTS), MS-SSIS application tools.
• Experience in creating Configuration files to deploy the SSIS packages across all environments.
• Wide experience in Creating OLAP cubes, identifying dimensions, attributes, hierarchies and calculating measures and dimension members in SQL Server Analysis Services (SSAS).
• Expertise in creating OLAP cubes using SSAS for data mining and created reports from the OLAP cubes using SSRS.
• Experienced in Extraction, Transformation and Loading (ETL) process using Data Transformation Services (DTS), MS-SSIS, Informatica Power Center application tools.
• Experience in developing management reports using SSRS (SQL Server Reporting Services).
• Strong experience in creating Ad Hoc Reports, Parameterized Reports, Linked Reports, Snapshot Reports, Drilldown and Drill through reports using SQL SSRS.
• Experience in Microsoft SQL 2008/2005 Server migration from SQL Server 2000, Integration Service (SSIS), Reporting Service (SSRS).
• Accomplished System Optimization, Performance Monitoring and Tuning inMicroStrategyBusiness Intelligence environment.Developed packages using lookup, aggregator, Derived Column, Sort and Conditional Split transformations.
• SQLDBA activities include but not limited to patch installs, backup and recovery of mission critical databases.
• Good experience in design, development and maintaining Dashboards and BI applications using Qlikview.
• Excellent understanding and implementation knowledge of Software Development Life Cycle.
• Ability to handle multiple tasks and responsibilities independently as well as a proactive team member.
• Worked on GIT, Team Foundation Server, Visual Studio online and the application lifecycle tools associated with it (source control, test manager, release management).
• Excellent communication and inter-personal skills with ability to develop creative solutions for challenging client needs using agile methodologies and participated in sprint planning, retrospective, estimates etc.

TECHNICAL SKILLS

ETL (Extract Transform Load) Tools: SSIS, SQL Server Management studio, SQL Server Data Tools 2012, SQL Server Business Intelligence development studio (BIDS DTS

Reporting/Analysis Tools: SSRS, SSAS, Crystal Reports XI

Data Modeling: Erwin Tool, MS Excel

Databases: SQL Azure, SQL Server 2014/2012/2008 R 2/2008/2005/2000 , Oracle 11g\10g\9i, MS Access, DB2

IDE Tools: Visual Studio.Net 2005/2008/2010/2013/2015 , Visual Studio Online

Tools: & Scheduler’s: TOAD, SQL Developer, Unix Cron Job, Control M Scheduler, Serena Team Track, Quality Center, Rally, Jira (Agile Tools).

Programming: SQL, T-SQL, PL/SQL, Unix Shell Scripting, C, C#, VB

Operating System: Windows 10/8/7/ Vista /2003/XP, Unix

Source Control Tools: Team Foundation Server (TFS), GIT

PROFESSIONAL EXPERIENCE

Confidential, Boise, ID

Sr. MS BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Worked with ITD staff to validate data mart elements and approach to ensure the finished data mart will in fact provide the necessary data elements for the in-scope reports.
• Created SSIS packages to Extract, Transform & Load (ETL) data crucial for the data mart.
• Created database tables and schemas to support assigned SSIS ETL packages.
• Primary role to providedatamodellingduties for the development and maintenance of tables (Fact, Dimension, Reference), views, stored procedures in a dimensional EnterpriseDataWarehouse (EDW) and Enterprise Reporting.
• Designed database table structures for each assigned dimension or fact table based on the reporting requirements identified for that table.
• Verified successful migration of SSIS packages from Development to Test environments.
• Worked with ITD staff to understand and document the requirements for the dimensions and/or fact tables and to clarify the source of the data, ETL approach.
• Created assigned data mart dimensions and/or fact tables - Using SSIS creating the ETL packages that will result in the desired data mart dimension table or fact table.
• This includes testing and migration from Development environment to Test environments. Several dimensions are very simple and consequently should take less time to complete.
• Migration of dimensions into Production, Assisting in migration and testing of data mart packages into the production environment and validating proper scheduling, function and management of the packages.
• Worked on data model according to the user requirement and successfully created an optimized QlikView application.
• Used Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Designed and developed SSIS packages, Store Procedures, configuration files, tables, views and functions and helped implement best practices for optimal ETL performance.
• Created stored procedures to build the Fact tables in thedatamart for Multi-Dimensional analysis using (SSAS) and produced ad-hoc, standard and super user reports using SSRS.
• Designed Dimensional Modeling usingSSASpackages for End-User. Created Hierarchies and defined Dimension Relationships.
• Extensive Knowledge inSSASstorage and partitions, and Aggregations, calculation of queries with MDX, developing reports using MDX and SQL.

Environment: SQL Azure Database, SQL Server 2014/2012, SSIS, SSAS, SSRS, TFS, VSO, SSDT 2012, VBScript, XHTML, XML, MS Excel, Windows 2005/2008/2012 Server.

Confidential, Glendale, CA

MS BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Dynamically supported business users for given requirements and developed the reports accordingly.
• Designed and developed SSIS packages, Store Procedures, configuration files, tables, views, functions and to implement best practices to maintain optimal performance.
• Successfully migrated the data between the heterogeneous sources like Flat File, Excel Source and SQL server using SSIS.
• Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms.
• Developed SSIS Templates, which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Developed pipelines in Azure data factories to extract data from Microsoft Big data Platform (Cosmos) and SQL Server.
• Build ETL’s to extract data from Microsoft Big Data platform (Cosmos), Flat files and SQL Sources.
• Created ETL’s to take data from various source systems (includingCOSMOS) and import into Azure Storage Blob, SQL Databases, and Azure SQL Data Warehouse.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Created SSIS packages to copy tables, schemas and views and to extract data from Excel.
• Build dashboards and perform ad hoc analyses withtableau.
• Well versed in implementing Data blending, Replace references, customized queries and advanced visualizations inTableau.
• Worked onPowerBI Dashboard to make some changes on behalf of Business requirements.
• Created various reports like Tabular reports and Matrix reports inPowerBI.
• Created reports in Power BI preview portal utilizing theSSASTabular via Analysis connector.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Managed company-wide system of QlikView BI solutions to ensure optimization of both data models and front-end UIs.
• Strong knowledge of Star schema, Snow flake schema in dimensional modeling and their usage in differentdatamodeling design.
• Converted existing SSIS packages into informatica mapping/Sessions/Workflow.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Designed and Build the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
• Developed theSSASMultidimensional and Tabular model reports fromDatawarehouse using SSDT.
• Created Cell Level Security in cubes usingSSAS.
• Created Perspectives, Partitions and Design Aggregations in cubes usingSSAS.
• Created, maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Created different chart reports helped in analyzing perform counters using SSRS.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.

Environment: SQL Azure Database, SQL Server 2014/2012, SSIS, SSRS, GIT, SSDT 2012, VBScript, XHTML, XML, MS Excel, RedGateTools, Windows 2005/2008/2012 Server, Visual Studio 2015.

Confidential, Frederick, MD

MS BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

• Worked closely with business users to congregate and comprehend requirements.
• Preparation of documentation for all the requirements and enhancements to reports.
• Provided Design documents for offshore and has been an On-Shore Offshore Coordinator and has been a lead for about 8 resources at off shore.
• Designed and developed SSIS packages, Store Procedures, configuration files, tables, views, functions and to implement best practices to maintain optimal performance.
• Successfully migrated the data between the heterogeneous sources like Flat File, Excel Source and SQL server using SSIS.
• Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms.
• Developed SSIS Templates, which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Created SSIS packages to copy tables, schemas and views and to extract data from Excel.
• Created cross validation rules to ensure mapping accuracy.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Developed various analytical reports and dashboards to facilitate predictive modeling and to analyze data to draw conclusions usingPowerBI.
• Used Pivot and Un-Pivot to make changes ofPower BI data to ExcelPowerPivot.
• Performed unit testing during the migration process between SSIS and informatica.
• Used Informatica to Extract and load the Data as per the requirement.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Developed and build quality interactions with all facets of Process Property and Casualty related insurance policy requests including endorsements, claims, payments, and in depth expansive research for Property and Casualty Policy Holders, Policy Cancelation.
• Used property and casualty expertise and industry knowledge to recommend and implement change when needed.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Developed Dimensions, Data source views, SSAS Cubes, deployed and processed SSAS objects, created SSAS storage and partitions and aggregations.
• Interacted with customers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and Confidential .
• Created, maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Created different chart reports helped in analyzing perform counters using SSRS.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Physical Implementation of database into SQL Azure, SQL Server 2014 using T-SQL.
• Created check constraints to maintain data integrity.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Coordinating post-implementation events such as testing.

Environment: SQL Azure Database, SQL Server 2014/2012, SSIS, SSAS, SSRS, TFS, VSO, SSDT 2012, VBScript, XHTML, XML, MS Excel, Windows 2005/2008/2012 Server.

Confidential, Dallas, TX

MSBI Developer

Responsibilities:

• Worked closely with business users to congregate and comprehend requirements.
• Preparation of documentation for all the requirements and enhancements to reports.
• Designed and developed SSIS packages, Store Procedures, configuration files, tables, views, functions and to implement best practices to maintain optimal performance.
• Successfully migrated the data between the heterogeneous sources like Flat File, Excel Source, Oracle and SQL server using SSIS.
• Experienced with Property & Casualty insurance.
• Extraction, Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Migrating the needed data from Oracle, MySQL in to HDFS using Sqoop and importing various formats of flat files in to HDFS.
• Migrated ETL jobs to Pig scripts did Transformations, even joins and some pre-aggregations before storing the data onto HDFS.
• Implemented Partitioning, Dynamic Partitions, Buckets in HIVE.
• Build efficient SSIS packages for processing fact and dimension tables with complex transforms.
• Developed SSIS Templates, which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Dev, Test and Production Environments.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Created SSIS packages to copy tables, schemas and views and to extract data from Excel and Oracle.
• Created cross validation rules to ensure mapping accuracy.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Involved in extracting the data using SSIS from OLTP to OLAP.
• Involved in SSAS Tabular cube (DAX) development.
• Designing, Creating & maintenance of Reports in SSRS.
• Created, maintained & scheduled various reports in SSRS like Ad-hoc Reports, Canned Reports, Master Reports & Parameterized Reports using SQL Server Reporting Services SSRS.
• Created different chart reports helped in analyzing perform counters using SSRS.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Interacted with customers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and Confidential .
• Determined the SQL Server Installation. Installed SQL Server Management tools using SQL Server Setup Program.
• Tested the Installation of SQL Server.
• Implemented Triggers for checking complex business conditions, providing security for the tables.
• Physical Implementation of database into SQL Server 2012 using T-SQL.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to administer SQL Server.
• Created check constraints to maintain data integrity.
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Created Business-Crucial stored procedures and functions to support efficient data storage and manipulation.
• Worked on DTS Package, DTS Import/Export for transferring data from heterogeneous database.
• Worked on DQS tasks like Creating Knowledge Base, Domain rules, Setting Term base Relationships etc..
• Data migration (import & export/BCP) from different sources to SQL Server.
• Coordinating post-implementation events such as testing.

Environment: SQL Server 2008R2/2012, SSIS, SSRS, SSAS, DTS, VSS, VBScript, XHTML, XML,MS Access, Windows 2005/2008 Server, Oracle 11g, IIS5.0, 6.0, 7.0.

Confidential

SQL BI Developer

Responsibilities:

• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), MS Excel Spreadsheet to SQL Server 2008.
• Designed ETL packages for different data sources (XML, SQL Server, Flat Files).
• Scheduled the DTS package for data migration from legacy system to MS SQL 2008.
• Designed dynamic DTS Packages to transfer data between servers, load data into database, and archived data file from different DBMS.
• Experience in designing and developing Business Intelligence solutions on Operational Data Store (ODS), Global Data Warehouse (EDW), Data Marts / Decision Support Systems
• Developed mappings using connected/unconnected lookup, router, joiner, expression, filter, sequence generator transformations.
• Developed packages using lookup, aggregator, Derived Column, Sort and Conditional Split transformations.
• Utilized SSIS (SQL Server Integration Services) to produce a Data Mart for reporting.
• Created Linked-Servers among different operational systems.
• Developed tables, stored procedures, triggers, cursors, views and indexes for the design specifications
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Created Views and Index Views to reduce database complexities for the end users.
• Experience in designing ER diagrams and mapping the data into database objects.
• Using Erwin, Prepared logical data models in support of integrated financial management and reporting requirements.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Regular responsibilities for updating staging and dimensional databases as well as rebuild the Dimensions and Cubes in Analysis Services (SSAS).
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
• Developed Dimensions, Data source views, SSAS Cubes, deployed and processed SSAS objects, created SSAS storage and partitions and aggregations.
• Responsible for report generation using SQL Server Reporting Services (SSRS) and Crystal Reports based on business requirements.
• Developed Parameterized, Drill-down, Drill-through, Sub-Reports and Charts in SSRS.
• Developed Stored Procedures for parameterized, drill-down and drill-through reports in SSRS 2008.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Created dashboards using Performance Point Server, combining scorecards and reports generated in SSRS, PPS, and Excel Services.

Environment: SQL Server 2005/2008/2008 R2, DTS, MS SQL Server Reporting Services, MS SQL Integration Services, MS SQL Analysis Services, T-SQL, PL/SQL, MS Excel, MS Access, Visual Studio 2008, ASP.Net, C#, ADO.Net, Oracle 10g.

Confidential

SQL BI Developer

Responsibilities:

• Dynamically supported business users for given requirements and developed the reports accordingly.
• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data load and transformations.
• Created various database objects such as tables, indexes and views based on the requirement.
• Designed and developed SSIS Packages to pull data from Access, Excel and Flat files to SQL server 2008.
• Responsible for ETL operation using SQL Server Integration Services (SSIS) and Worked with users in training and support and also have experience in incremental data loading.
• Developed ETL mappings to transfer data from some of the Access, Flat files.
• Developed, deployed and monitored SSIS Packages.
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks and re-indexing.
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions and data source views.
• Created Dimensions with the cube wizard and also individually and Generated Named calculations and named queries.
• Refreshing the cube to get the latest information updated and deployment of Cubes to the production server.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
• Extensively involved in the SSAS storage and partitions, and aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Created data sources, connection strings and defined the datasets for generating the report.
• Designed and written the queries in the query builder for retrieving the data.
• Created and worked with drill down reports and identified the report parameters.
• Used various report items like tables, sub report and charts to develop the reports in SSRS.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc.
• Created subscriptions to provide a daily basis reports.
• Managed and troubleshoot report server related issues.
• Migrated some Crystal reports to SSRS reports.

Environment: SQL Server 2005/2008, SSIS,SSAS, SSRS, VSS, VBScript, XHTML, XML, C#, ASP.Net, Windows 2000/2003 Server, IIS5.0, 6.0, 7.0, Crystal Reports.