SUMMARY:

• 8 years of MS SQL Server Development experience with expertise in MS SQL Server 2005/2008/2008 R2/2012,2014,2016 suite of products like SSIS, SSAS, and SSRS.
• Expertise in ETL and reporting tools. Deep understanding of the Data Warehousing SDLC and architecture of ETL, reporting and BI tools.
• Expertise in Power BI, Power BI Pro, Power BI Mobile.
• Expert in creating and developing Power BI Dashboards in to rich look.
• Experienced in Logical and Physical Database design & development, Data Conversion, Normalization and Data modeling using ERwinand SQL Server Enterprise manager.
• Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server and Databases.
• Expertise in Analysis Design Development Testing and implementation of Data warehouse Data marts with ETL OLAP Tools using Informatica Power Center, Oracle, Netezza and SQL Server.
• Hands on experience in developing and writing T - SQL queries, store procedures, triggers, creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration.
• Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
• Can write shell and SQL scripts for batch processing.
• Expertise in Installing and configuring new SQL Servers.
• Fluent understanding of basic database instance maintenance tasks (e.g. DB Integrity Checks, Index Maintenance, etc.).
• Ability to configure security within established guidelines and perform related task/audits.
• Experienced in analyzing and writing Oracle PL/SQL code.
• Experienced in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using SSIS of MS SQL Server 2008/2008R2/2012.
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
• Strong experience with ETL tool in Mapping, Transformations, Expressions, lookups and Aggregations.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB Connection from heterogeneous sources (Excel, CSV, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, Merge and Merge Join.
• An expert with key reporting/visualization tools such as Tableau or QlikView / QlikSense.
• Good experiences with data handling, investigation and transformation.
• Hands on experiences with a database and/or transformation tools (SQL).
• Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled SSIS Packages.
• Good knowledge of Data Warehousing (Star/Snowflake schema) concepts.
• Active participation in designing dashboards including the design of the data warehouse tables, Source to Target ETL logic and dashboard development.
• Created data sources, connection strings and defined the datasets for generating the report.
• Experience in generating On-demand and Scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2008/2008R2/2012 (SSRS).
• Expert in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS.
• Proficiency in creating different types of reports such as Cross-Tab, Drill-down, Drill-through, Parameterized reports, Linked reports, OLAP and Sub reports, and formatting them using both SSRS.
• Strong ability in defining query for generating Cascaded Reports, Custom Reports and creating stylish report layouts in SSRS.
• Developed Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder.
• Designed and developed Microsoft Power BI reports and Dashboards including data set ingestion and transformation, Modeling, Data Analysis Expressions (DAX) using the appropriate report templates.
• Demonstrated and promoted reporting best practices and use of data visualizations to empower data driven decision making.
• Provided governance around the Power BI platform architecture and operations.
• Maintained up to date on Power BI desktop, Power BI Service and related technology enhancements.
• Experience in deploying created reports in various sources like Web browser, XML and PDF.
• Expertise in Developing and Extending MS SQL Server Analysis Services (SSAS) 2008/2008R2/2012 Cubes and Deploying and Processing SSAS objects.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS and in adding calculations using MDX.
• Experience in Troubleshooting Report Processing, Subscription, Delivery and Configuration Problems.
• Worked on creating Azure Data Factory for moving and transforming the data.
• Worked with Azure Data Lake Store to capture data of any size, type, and ingestion speed in one single place for different operations.
• Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements.
• Knowledge of Software Development Life Cycle (SDLC).
• Worked in Agile Scrum Methodology with daily stand up meetings.
• Excellent interpersonal communication, problem solving, documentation and business analytical skills.

TECHNICAL SKILLS:

SQL Server Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio

Tools: SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Data Transformation Services (DTS), Crystal Reports, Cognos.

Databases: SQL SERVER, MYSQL, Oracle and DB2, SQL Server 2016/2014/2012/2008 R2/2005/2000

Languages: C, C++, T-SQL, .Net, C#, Java, Java Script, CSS. TSQL,SSIS/SSRS/SSAS, PLSQL

Operating Systems: Windows NT, Windows 2008,2003XP, UNIX, Windows 7, LINUX.

Technologies: .NET, ASP.NET, SQL, JAVA.

WORK EXPERIENCE:

Confidential, Minneapolis, MN

SrSQL SSIS Developer

Responsibilities:

• Worked with business gathering requirements.
• Involved in performance tuning of T-SQL queries and Stored Procedures.
• Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data sources using SSIS.
• Designed and developed SSIS Packages for loading data from text files, CSV files to SQL Server databases using SSIS.
• Scheduled the SSIS jobs using SQL server agent for daily, weekly and monthly loads.
• Migrated data between different heterogeneous sources such as Flat file, Excel 2005 using SSIS.
• Worked with different control flow elements like Data Flow Task, Execute SQL Task, Script Task and Send Mail Task.
• Used different data flow elements like Flat File, OLEDB, Excel Sources, Destinations and Data Flow Transformations like Data Conversion, Conditional Split, Derived Column etc.
• Deployed different SSIS packages on test and production servers.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user environments.
• Created Clustered and Non Clustered Indexes on tables for performance optimization of complex stored procedures.
• Did lot of Performance Tuning by using unblocking Transformations and row transformations for better performance of SSIS packages.
• Create Cache Memory on Windows Azure to improve the performance of data transfer between SQL Azure and WCF services.
• Upgraded existing packages developed using SSIS 2005 to SSIS 2008 packages.
• Developed various types of reports like Drill down, Drill through and parameterized reports using SQL Server Reporting Services 2008 R2
• Used SQL Analyzer and Profiler for monitoring the SQL statements and procedures.
• Created Joins and Sub-Queries for complex queries involving multiple tables.
• Used DDL and DML for writing triggers, functions, stored procedures, and data manipulation.
• Scheduled the SSIS packages to run at different intervals to load the data into SQL Server.
• Deployed the created SSIS packages in Development and Testing environments.
• Created Linked Servers to retrieve data from other databases.
• Optimized the T-SQL query performance with modifications in TSQL queries, removing unnecessary columns, establishing necessary joins.
• Generated score cards with executive summary dashboards to display performance monitoring measures with Tableau.
• Delivered on-demand reports in multiple rendering formats with standard and data driven subscriptions.
• Designed and developed Power BI graphical and visualization solutions with business requirement documents and plans for creating interactive dashboards.
• Utilized Power BI (Power View) to create various analytical dashboards that depicts critical KPIs such as legal case matter, billing hours and case proceedings along with slicers and dicers enabling end-user to make filters.
• Generated ad-hoc reports in Excel Power Pivot and sheared them using Power BI to the decision makers for strategic planning.
• Utilized Power Query in Power BI to Pivot and Un-pivot the data model for data cleansing and data massaging.
• Implemented several DAX functions for various fact calculations for efficient data visualization in Power BI.
• Utilized Power BI gateway to keep dashboards and reports up to-date with on premise data sources.
• Migrated enterprise database to Microsoft Azure with Red gate and azure data factory.
• Involved in preparing detailed technical documents.
• Involved in code review and preparing unit test cases.

Environment: MS SQL Server 2016, 2012, 2008R2, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Power BI, Tableau, Secure Workbench, Oracle, TFS, MS Azure, MS Excel, MS OneNote, MS Visio, MS SharePoint.

Confidential

SQL/ETL/BI Developer

Responsibilities:

• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables and Table valued Functions for data extraction, data load and transformations.
• Created Reports with different Output formats such as Excel file, fixed width text file, PDF, tab-delimited and pipe-delimited.
• Worked on several State Reports and used SSIS to create multiple destination files from single/multiple sources.
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports using SSRS 2012.
• Exposure to Power BI concepts for creating visualized reports and publishing it within the team.
• Prepare the detailed level ETL mapping specification documents describing the algorithms and flowchart and mentioning the source systems, change data capture logic, transformation logic involved in each field, the lookup tables, lookup logic used and also the target systems per each individual mapping involved with the datamarts. Also, document the important SSIS session properties that should be used for executing SSIS Packages from Teradata in to the SSIS Database.
• Generated reports from the cubes by connecting to Analysis server from SSRS.
• Responsible for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Created Data Models from the data retrieved from Data warehouse.
• Conducted Data model reviews with project team members.
• Collaborate with BI teams to create reporting data models.
• Hands on creating multidimensional data models.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages.
• Published the dashboard reports to Power BI service for navigating the developed dashboards in web.
• Develop physical data models using ERWIN and created DDL scripts for database schema and objects.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc. and scheduled SSIS packages.
• Implemented Extraction Transformation and Loading (ETL) process by pulling large volume of data from various data so0urces using SSIS.
• Developed complex Stored Procedures to generate various Drill-through reports, Parameterized reports, Tabular reports, Matrix reports and linked reports using SSRS.
• Tested Power bi reports and verified the data with the source database data and checked the accuracy of data.
• Data Modeling of all Process flows to integrate multiple banking systems via acquisition using Visio 2013 and CA Erwin 9.0 Tools, NDM Data Transmission with SSIS Packages.
• Develop complex SSIS packages with different data sources incorporating script task (VB scripting or C# scripting), etc. to deliver data reports to business users.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Created SSRS (SQL Server Reporting Services) reports having multiple Parameters and cascading parameters, Navigation to a sub reports and created book marks when report is exported to PDF or EXCEL File.
• Generated various reports with drilldowns, calculated members, dropdowns from the cubes by connecting to Analysis server from SSRS.
• Responsible to build Reports for different Markets and ADHOC reports as per request.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc.) and then loaded the data into destination tables by performing different kinds of transformations using SSIS (SQL Server Integration Services)
• Documented Back out Implementation Plan for all the work done and also created the CMD files.
• Worked with Team foundation server version Control to maintain the different versions of Code, RDL Files, Back out Scripts, CMD files & SSIS Packages.
• Created Subscriptions to provide reports on a daily/weekly/monthly/Quarterly and annual basis.
• Worked with Oracle Application database to pull Claims, Providers, and Members information for various reports and extracts.
• Provided 24/7 Production Support for the maintenance & scheduling of reports.

Environment: SQL Server 2012/2014, Report Builder 3.0, Power BI, ETL, Business Intelligence Studio (SSIS, SSRS), C#.NET, T SQL, MS Excel.

Confidential, Redlands, CA

SQL Server/BI Developer

Responsibilities:

• The project is designed in two phase's data gathering and reporting, the data gathering part is done using SQL Server Integration Services (SSIS) and the reporting portion is built on SQL Server Reporting Services (SSRS) platforms
• Responsible for Data Modeling based on the client requirements, daily maintenance and performance tuning.
• Developed Tabular Reports,Matrix Reports parameterized Reports Sub reports, Snapshot and Adhoc reports (SSRS).
• Developed physical data models using ERWIN/ ER Studio and created DDL scripts for database schema and objects.
• Worked on Installation and Maintenance of SQL Server 2014/2012 on Test, Development and for Production Environments worked closely with Admin teams.
• Stored Procedures, User Defined Functions, Views, TSQL for complex business logic.
• Design and implementation of SSIS/ETL process for the system.
• Data conversion from mainframe system and Oracle databases to SQL server.
• Created SSIS Templates for developing SSIS Packages that can be dynamically deployed into development, Testing and Production Environments.
• Validated change requests and made appropriate recommendations, standardized the implementation of data.
• Experience in configuring and deploying SSRS reports onto Microsoft Office SharePoint Server.
• Used c#.net asp web pages to show the deployed reports as required by the user
• Involved in creating various Database Objects - Tables, Indexes, Store Procedure, Trigger, Views, and Roles Improved Performance by creating Clustered and Non-Clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis.
• Designed and developed different type of reports including Tabular forms, Dashboards, Matrix (cross Tab report) form, Conditional, List items, Charts and Sub reports, custom report, Drill down reports using SSRS.
• Developed dashboards and key Performance Indicators (KPI) with SQL Server Reporting Services (SSRS) and Power BI
• Responsible for Deployment of the report to report server using SSRS and used Report Subscription (Data Driven and Standard) to publish reports.
• Uses of power pivot, red gate tools for different purposes. Use of source control product such as Team foundation server.
• Modified stored procedures to meet current design and used them in SQL Server.
• Maintain security, assign logins, permissions and desk support for problems related to Active Directory.

Environment: MS SQL Server 2012/2014, MS dynamics 2013/2015, Red Gate tools,PowerPivotTFS 2013, Agile/SCRUMSharePoint2013, MS SSRS/SSIS 2012, T-SQL, Visual studio 2013, MS Visio.

Confidential, Adelphi, MD

SQL/ETL/BI Developer

Responsibilities:

• Reformatted the data and inserted the reformatted data into staging table, data type conversions and then loaded into destination table.
• Developed SQL queries with multi-table joins, group functions, sub queries and T-SQL stored procedures, user defined functions (UDFs) for data analysis.
• Iteration planning for new features and user stories in Agile Development methodology.
• Developed Logical and Physical data models that capture current state/future state data elements and data flows using Erwin.
• Responsible for design and build data mart as per the requirements.
• Identify the field/column level data quality issues of the source systems to drive the data quality, data cleansing and error checking in the ETL mappings. Identify and document the source to target mapping data lineage.
• Prepare the detailed level ETL mapping specification documents describing the algorithms and flowchart and mentioning the source systems, change data capture logic, transformation logic involved in each field, the lookup tables, lookup logic used and also the target systems per each individual mapping involved with the datamarts. Also, document the important SSISsession properties that should be used for executing SSIS Packages from Teradata in to the SSIS Database.
• Design and document the error-handling strategy in the ETL load process using Event handlers. Consistently use this error handling techniques in all the mappings.
• Cleanse and Scrub the Data in uniform data type and format applying MDM Informatica and IDQ tools and Load to STAGE and HUB tables and then to the EDW and Finally to Dimension and rollup/aggregate the data by the business grains into the FACT tables.
• Developed MDM Hub Match and Merge rules Batch jobs and Batch groups.
• Created Queries Query Groups and packages in MDM Hub Console.
• Translate needs into strategy and high-level requirements for data warehouse / data related solutions into Datawarehouse / MDM / ETL / feeds / Dashboards.
• Extracted data from SQL Server database tables into flat data files and Excel sheets using table export.
• Loaded flat and Excel files into SQL database and developed SQL scripts to create desired queries (views) for data analysis.
• Created package with different data sources (SQL Server, Flat Files, Excel files, etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Utilized various data flow transformations like lookup, row count, data conversion, multicast between different data sources as per business requirements.
• Successfully deployed SSIS Package into Production environment.
• Developed Spreadsheets to Schedule Jobs to automate the SSIS packages.
• Generated variety of business reports from SQL servers using excel with pivot table and pivot chart.
• Used Event Handlers and implemented Error Handling in SSIS packages and notified process results to various user groups.
• Created excel reports with pivot functions from Access and SQL.
• Migrated macros from Access to MS SQL server which were being used to transfer data between Excel and Access manually and generated reports automatically with job scheduling.
• Created various views on SharePoint List to read and import data into SQL staging table for mapping.
• Worked on SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
• Designed SQL Server Analysis Services (SSAS) databases and OLAP cubes used in ad-hoc analytic research and automated reporting.
• Designed cubes in SSAS environment using Snowflake and Star Schemas.Worked with Excel Power Pivot Tables.
• Created PowerPivot models and PowerPivot reports, published reports onto SharePoint, and deploy models into SQL Server SSAS instance.
• Developed various dashboards, used context filters, sets while dealing with huge volume of data.
• Used excel sheet, flat files, CSV files to generated Tableau AdHoc reports.
• Designed dash boards for actionable, non-actionable complaints from Multidimensional database.
• Generated dashboards to compare the expected weekly registration and physician specific registrations used dual axis for comparison.
• Generated Dashboards by joining multiple complex tables.
• Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Worked with End users and Database analysts for the Design of Summary tables required for efficient Report Design.
• Expertise in configuring and deploying SSRS reports onto Report Server.
• Designed the functional and technical documents, report templates and reporting standards for the developers to work on the report development.
• Created SQL server Reports using SSRS 2008R2. Identified the data source and defined them to build the data source views.
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design(SSRS).

Environment: MS SQL Server 2012, 2008R2, SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Informatica MDM.