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.
• 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).
• 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 beyond.
• 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.
• 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.
• Interacted with customers to analyze business needs. Provide software product design and developed technical roadmap for the solution through the project lifecycle and beyond.
• 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.