SUMMARY

• 8+ years of experience in IT as Sr. Business Intelligence working in various domains such as Telecom, Finance, Retail, Insurance and Healthcare using MS SQL Server 2014/2012/ 2008 R 2 /2008/2005/2000 DTS/SQL Server Integration, Reporting & Analysis Services.
• Experienced in software development life cycle in all phases.
• Experienced in client requirement analysis, Physical and Logical design & development (using normalization and SQL Server Enterprise Manager).
• Experienced in resource planning, coding, debugging, testing, deployment, support and maintenance of business applications using MS SQL Server 2005/2008/2012/2014, SQL Server Integrated System, SQL Server Analysis Services and SQL Server Reporting Services.
• Expertise in TSQL, creating and using Stored Procedures, Views, User Defined Functions, implementing Business Intelligence solutions using MS SQL Server 2005/2008/2012/2014 .
• Have good experience in creating Indexes in observing Business Rules and creating Effective Functions. Experienced in defining queries, generating drill - down report in Crystal Reports.
• Experience in using various sources to pull data into Power BI such as Oracle, SQL Server, Teradata, SQL Azure, and etc. Good experience in writing MDX queries while creating and customizing Cubes using SQL Server Analysis Services (SSAS) 2005/2008.
• Experience in working with SSAS in creating cubes, data source views, named queries, dimensions and deploying of analysis services projects. Used the SQL Server Import/Export wizard to migrate the Heterogeneous Databases such as Oracle and MS Access database, flat files to SQL server 2005/2008. Adept in creating Ad-hoc, Cross-Tab, Drill-down and Sub-Report using RDL. Experienced in creating many complex SSIS packages with complicated transformations. Experienced in creating Jobs, Alerts, SQL Mail Agent, Scheduling packages.
• Expertise in designing complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and ad-hoc reports using SQL Server Reporting Services based on client requirements. Expertise in writing complex DAX functions in Power BI
• Experience in Microsoft Azure Cloud Computing, Delivered BI reporting solutions in Power BI, Reporting Services (SSRS), and Tableau, Very proficient in working with large Databases - DB2, Oracle, Teradata
• Hand on experience in developing & deploying Cubes using SQL Server Analysis Services involving multidimensional data. Good knowledge of defining and deploying Cubes using MS SQL Server 2005/2008/2012 Analysis Services.

TECHNICAL SKILLS

• MS SQL SERVER 2012/2008/2005/2000
• MS SQL SERVER Management Studio
• Business Intelligence Development Studio
• SQL Server Enterprise Manager
• Oracle
• Teradata
• DB2
• C++
• SQL
• T-SQL
• Power BI
• Tableau
• MS Excel
• MS ACCESS
• DTS
• SQL Server Integration Service (SSIS)
• SQL Service Analysis Service (SSAS)
• U-SQL
• Azure Data Lake Storage (ADLS)
• Azure Data Lake Analytics (ADLA)
• Azure Data Factory (ADF)
• SQL Server Reporting Service (SSRS)
• SQL profiler
• MS VISIO
• ASP.net
• VB.net

PROFESSIONAL EXPERIENCE

Confidential, Richmond, VA

Microsoft SQL Server/SSIS Developer

Responsibilities:

• Involved in Analysis, Planning and Defining data based on business requirements and provided documentation.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Designed and normalized the databases, have written T-SQL Queries and created different objects like Tables, Views, Stored Procedures, User defined functions and Indexes.
• Enforced the Business Rules by creating multiple constraints like check constraints and triggers as well as automated the update of the database statistics.
• Improved the performance of queries by introducing clustered and non-clustered indexes on tables in the data base.
• Created very complex SSIS Packages with considering all the best practice like error handling, logging, configurations, deployments and maintenance.
• Developed ETL Packages using SQL Server 2014 Integration services to populate data from different sources like flat files/CSV Files to the staging databases.
• The packages created included a variety of transformations like Look up, Aggregate, Derived column, Conditional split, Multicast, Execute SQL Task, Term Extraction, Data Conversion etc.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Created USQL scripts from the existing SQL scripts as a part of the project to handle the data that lies inside the Microsoft cloud Azure.
• Experience in creating a Data Lake Storage Gen2 storage account and a file system
• Used Copy Activity in Azure Data Factory to copy data among data stores located on-premises and in the cloud, Created pipelines and activities in Azure Data Factory and used them to construct end-to-end data-driven workflows for the data movement and data processing
• Experience in executing an Azure Data Factory pipeline by manually and by using aTrigger
• Used Azure Data Lake Analytics to run big data analysis jobs that scale to massive data sets
• Experience in submitting U-SQL Jobs by using Azure Data Lake Analytics account in Azure Portal and in Visual Studio Used SQL Compare to fix errors in the production database by comparing it to a backup, scripts inSource Control
• Created Azure Data Storage accounts within the ADF (Azure Data Factory) for storing the big data inside the cloud.

Environment: MS SQL Server, Business intelligence development studio (BIDS), SQL Server Integration Services(SSIS), ETL, Power BI, Tableau, U-SQL,, Microsoft Azure, MS Access, MS Excel.

Confidential, Redmond, WA

SQL Server/SSIS/SSAS/Power BI Developer

Responsibilities:

• Developed Stored Procedures, Triggers, and SQL scripts for performing automation tasks
• Translated business requirements into data analysis, data sources and reporting solutions as per business requirement.
• Created Metadata-driven Packages in SSIS2017 as part of automating the process for the Referral Process.
• Performed and fine-tuned Stored Procedures and SQL Queries and User Defined Functions
• Developed test cases based on test matrix including test data preparation for Data completeness, Data Transformations, Data quality, performance and scalability
• Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality
• Created SQL Server jobs and scheduled them to load data periodically using SQL server Agent.
• Created complex SSAS cubes with multiple data partitions to selectively refresh smaller subsets of data to save on processing time in terms of heavy transactional data.
• Involved in designing and developing Tabular models.
• Developed Tabular models with row level security and integrated that to Power pivots and Power Views.
• Designed Tabular models to hold data which can be easily used for generating power views.
• Created business critical KPIs using SSAS representing aggregations in several ways - hierarchically and using custom groupings that the company will use to analyze performance.
• Created and deployed cubes in star and snowflake schema. Performed and worked with dimensions, measures, MDX queries
• Created Azure Data Storage accounts within the ADF (Azure Data Factory) for storing the big data inside the cloud.
• Created USQL scripts from the existing SQL scripts as a part of the project to handle the data that lies inside the Microsoft cloud Azure.
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts
• Scheduled Automatic refresh and scheduling refresh in Power BI service
• Created Workspace and content packs for business users to view the developed reports.
• Expertise in writing complex DAX functions in Power BI
• Developed power BI reports and dashboards from multiple data sources
• Explored data in a variety of ways and across multiple visualizations using Power BI
• Installed and configured Enterprise gateway and Personal gateway in Power BI service.
• Created Drill Down Reports, Drill Through Report by Region.
• Worked on all types of transformations that are available in Power BI query editor
• Wrote calculated columns, Measures query’s in Power BI desktop to show good data analysis techniques.

Environment: MS SQL Server 2017 Management Studio, Business intelligence development studio (BIDS), SQL Server Integration Services(SSIS), SQL Server Analysis Service(SSAS), Power BI, Tableau, T-SQL, Visual Studio 2017, Microsoft Azure, MS Access, MS Excel, windows 2000/2003 VB.net.

Confidential, Atlanta, GA

SQL Server/SSIS/SSRS/SSAS/Power BI Developer

Responsibilities:

• Translated business requirements into data analysis, data sources and reporting solutions for different types of consumers.
• Transformed data from different data sources like Oracle and DB2 to SQL Server 2008 R2 using OLE DB connection providers by creating various SSIS packages.
• Involved in Gathering requirements, performing source system analysis and development of ETL jobs to migrate data from the Source to the Target Data warehouse.
• Moved the data from the appropriate databases to end database and maintained batch log files.
• Well versed with the usage of variables to make the packages dynamic and scheduling the package in SSIS (sequential scheduling).
• Generated reports using the parameterized stored procedures for total number of outages in the Carolinas, total units consumed and electric rate per unit in specific location, Carolina rate schedule index, and regional rate comparisons.
• Used differenttransformationslike Conditional Split, Lookup, Merge Join, Aggregate, Fuzzy Grouping etc. for creating manySSISpackages.
• Developed complex Stored Procedures, Functions, Views, Cursors, Joins and Sub queries with T-SQL.
• Experienced with SSIS in creating, loading, and modifying new packages or existing packages and add or configure components, making changes in object by using Control Flow Tools and Data Flow Tools and then validating them.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load. Developed Metrics for front end applications using SQL Server.
• Extracted data from various sources like SQL Server 2012/2014, Oracle, Teradata, .CSV, Excel and Text file from client servers.
• Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs
• Scheduled reports to run weekly, monthly and quarterly based on the data to be reviewed by the manager. Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX
• Developed complex SQL queries using stored procedures, common table expressions (CTEs), temporary table to support Power BI and SSRS reports
• Involved in working with Redgate tool for SQL compare & SQL Data compare between the databases and tables.
• Developed Multi-dimensional Objects (Cubes, Dimensions) using SQL Server Analysis Services (SSAS). Designed cubes in SSAS environment using Snowflake and Star Schemas
• Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS)
• Created Azure Data Storage accounts within the ADF (Azure Data Factory) for storing the big data inside the cloud.
• Created USQL scripts from the existing SQL scripts as a part of the project to handle the data that lies inside the Microsoft cloud Azure.
• Designed and created data extracts, supporting SSRS, Power BI, Tableau or other visualization tools reporting applications
• Dealt with huge amount of data and used SSAS in order to retrieve the data
• Used SQL Compare to fix errors in the production database by comparing it to a backup, scripts inSource Control, Used SQL Compare to make sure that the deployment is successful, by checking the script dependencies in the database is in right order, and to compare the SQL Server database schemas with advanced filtering of database objects.
• Developed custom calculated measures using DAX in Power BI to satisfy business needs
• Provided continued maintenance and development of bug fixes for the existing and new Power BI Reports, Created indexes on the database tables and generated trace events to improve the query performance and optimize data access.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev, UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.

Environment: MS SQL Server 2008 R2/2012/2014 Management Studio, Business intelligence development studio (BIDS), SQL Server Integration Services(SSIS), SQL Server Analysis Service(SSAS), SQL Server Reporting Services(SSRS), Power BI, Tableau, T-SQL, Visual Studio 2012, Red Gate SQL Compare, Oracle, Teradata, MS Access, MS Excel, DB2, windows 2000/2003 VB.net.

Confidential, Seattle, WA

Sr. MS SQL BI Developer/SSIS/SSRS/SSAS Developer

Responsibilities:

• Creating reports from cubes- using either SQL Server Reporting Services (most recent experience with SQL Server 2008R2), creating complex stored procedures with TSQL creating reports from OLAP (online analytical processing) or SSAS (SQL Server Analytical Services) creating dashboards and deploying them to SharePoint.
• Created complex Stored Procedures for better performance to generate reports.
• Created and tuned stored procedures, triggers and tables. Created report data sets as per requirement and passed all input parameters by assigning default values to each input.
• Created reports by extracting data from the data set using SQL server reporting services 2010.
• Designed and deployed reports with Drill Down, Drill Through and drop down menu option and parameterized and Linked reports.
• Deployed and scheduled reports using SSRS to generate all daily, weekly, monthly and quarterly reports including current status.
• DesignedSSIS packages to Extract data from different sources like SQL server 2008, MS Excel, MS Access; transform them and then load intoDimension and Fact tables in Data warehouse using SSIS. Used various SSIS data flow transformations, such as Data Conversion, Conditional Split, Derived Column, and Lookup which were used for Data Scrubbing and Data Validation Checks during staging, before loading the data into Data Warehouse.
• Developed SSIS packages using for each loop inControl Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table.
• Involved in extracting data from heterogeneous sources, such as CSV and Excel files.
• Involved in dealing with off short team, Created and modified Stored Procedures, Functions, and Indexes
• Designed and developed SSIS packages, Stored Procedures, Configuration Files, Tables, Views, Functions, and implemented best practices to maintain optimal performance.
• Used VB script in script components for data transformations. Used Expressions to lookup data from multiple datasets as well as multiple databases.
• Created standard report subscription and data driven report subscriptions. Deployed reports on Microsoft office SharePoint on Development/Production server.
• Developed different kind of reports such as Sub Reports, Charts, Matrix reports, Linked reports. Involved with Query Optimization to increase the performance of the report.
• Worked with PerformancePoint dashboard designer to rollout dashboards.
• Worked on Data validations and data mapping. Involved with SSIS Source/destination mapping from M3 to Enterprise Data Warehouse.
• Developed reports for business end users using Report Builder with Updating Statistics

Environment: MS SQL Server 2008 R2, SQL Server Integration Service (SSIS), SQL Service Analysis Service (SSAS), SQL Server Reporting Service (SSRS), T-SQL, Visual Studio 2008, VB.net, MS Access, SQL Profiler, SharePoint server, windows XP, MS Excel.

Confidential

SQL Server Developer / ETL Analyst

Responsibilities:

• Involved in the requirements analysis, design and development phase of Water Fall SDLC model.
• Migrated data from Heterogeneous Data Sources (Access, Excel) to centralized SQL Server database using SQL Server Integration Services to overcome transformation constraints.
• Create packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing primarily Excel data sources.
• Performed data cleansing by creating tables to eliminate dirty data using SSIS.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and configured SQL mail agent for sending mails upon package deployment.
• Migrated packages from development server to production server using package configuration.
• Involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
• Created dynamic reports using SSRS for the Windows category managers and rest of the customer base to view the reports at various desired levels, generated report models using report builder for the end users.
• Scheduled reports on a weekly basis that was generated every Friday including the most recently updated data to the database from the subsidiaries.
• Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views in the databases
• Developed User Defined Functions, indexes to generate the distinct data based on the type of the region, release and version of the data released.
• Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Used various data mapping tools like epaCube. Worked on the Excel front end to formulate so as to collect the inputs from the Excel templates.

Environment: MS SQL Server 2008, SQL Server Integration Service (SSIS), SQL Service Analysis Service (SSAS), SQL Server Reporting Service (SSRS), T-SQL, Visual Studio 2008, VB.net, MS Access, SQL Profiler, windows XP, MS Excel, epaCube.

Confidential

SSIS Developer / ETL Analyst

Responsibilities:

• Migrated SQL Server databases to latest version 2008 from SQL server 2005.
• Developed SSIS packages to Extract, Transform and Load (ETL) data into the data warehouse database from heterogeneous databases/data sources (SQL, Oracle, Excel Sources).
• Used various SSIS tasks such as Conditional Split, Derived Column, lookup which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Optimized the performance of queries by removing unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established Joins and created clustered/non-clustered indexes wherever necessary.
• Successfully created dynamic configuration packages in SSIS.
• Used Event Handlers for Exception Handling in SSIS packages. Generated reports on wealth information, account information, research reports using ad-hoc reporting to be used by the clients and advisors.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients and advisors. Involved in Performance tuning and Query Optimization by using SQL profiler.
• Worked with business analysts to identify, design and implement solutions for extraction and integration of data, to and from databases and data marts for the purposes of data extraction and reporting using SSRS.
• Generated performance-based reports using SSRS for the managers to show active service engagements against various measures like pipeline, time, area, and price range.
• Used VSS to store, run, view, edit and revert back to different version of the design in case of a system crash.
• Created packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all and Derived Column etc.
• Designed and built star and snowflake dimensional models creating facts, dimensions, measures, cube and established data granularity.
• Experience in using Bulk Copy program (BCP) to import and export large amounts of data in and out of SQL Server databases.
• Implemented mechanisms to accelerate query performance, including aggregations, caching, and indexed data retrieval and optimizing the design of dimension attributes, cubes, and multidimensional expressions (MDX) queries.
• Data Validation using Excel and SSIS and Data Cleansing using SSIS.
• Implemented database standards and naming convention for the database objects and documentation of all the processes involved in maintaining the database for future reference.

Environment: MS SQL Server 2005/2008, SQL Server Management Studio, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Visual Studio 2008, SQL profiler, Excel and Oracle, Business intelligence development studio (BIDS), MS Access, MS Excel and Oracle.