SUMMARY:

• Over 8+ years of IT experience in the use and development, design, support and migrate of Confidential SQL Server 2008 R2/2012/2016 database.
• Proficient in MS SQL Server suite of products like SSRS, SSIS and SSAS of MS SQL Server 2008 R2/2012/2016.
• Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC).
• Experienced in creating complex Stored Procedures, DTS packages, triggers, cursors, tables, views, table partitioning and other SQL joins and statements.
• Good Understanding of SDLC and Relation Database Architectures,
• Strong SQL Server 2008 R2/2012/2016 Developer Skills including writing user defined functions, views, query writing
• Proactive monitoring of databases
• Experience in creating and maintaining database and its objects
• Good experience in installation and upgrades of/to SQL server 2008 R2/2012/2016 and its service packs, database migrations, backup, recovery and maintenance of SQL Server 2008 R2/2012/2016 databases in Cluster environment.
• Extensive knowledge in SQL Server 2016 Developer Skills including writing user defined functions, views, query writing
• Expertise in writing complex Stored Procedures, Indexed Views and Triggers for data
• Consistency and manipulation.
• Experience in creating Indexes, Views, complex Triggers, effective Functions, and appropriate Stored Procedures to facilitate efficient data manipulation and data consistency.
• Good knowledge on SSRS 2016.
• Has a very good experience in creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.
• Great Expertise in creating and managing Event Handlers, Package Configurations, Logging, System and User - defined Variables for SSIS Packages.
• Worked with data extraction using SSIS and Data Warehouse staging and loading.
• Experienced in defining Query for generating drill down reports in SSRS 2008 R 2/2012/2016.
• Proficient in using global variables, expressions and functions for the reports.
• Experience in OLAP, created Cubes, Dimensions for schemas
• Proficient in building Star schema and Snowflake schema depending on business Requirements.

TECHNICAL SKILLS:

MS SQL Server 2008 R2/2012/2016, MS SQL Reporting Services 2008 R2/2012/2016, MS SQL Server Analysis Services 2012, MS SQL Server Integration Services 2012, MS-Access 2010, HTML, Java script, Windows NT, Windows 2008 R2 Server, TFS, Windows XP/7, Unix, and Shell script.

PROFESSIONAL EXPERIENCE:

Confidential, Milwaukee, WI

Sr. SQL BI/ETL

Responsibilities:

• Modified current database by adding tables and relationships to support online system.
• Defined Constraints, Rules and Defaults.
• Created complex SQL Queries, Stored Procedures and Functions to support efficient data storage and manipulation.
• Experience with software development life cycle (SDLC), Agile / Scrum and Project Management Methodologies. Extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member.
• Experience working as 24/7 prod support, coordinating with India offshore team and Canada onsite team. Monitoring jobs and fixing job failures.
• Experienced in creating and using Stored Procedures, Triggers, Views, User Defined Functions, Sub - Queries and Joins for complex queries involving multiple tables and exception handlers.
• Proficient in SQL Server and T- SQL (DDL and DML) in constructing Tables, Normalization/ De normalization Techniques on database Tables.
• Excellent Experience in Designing, Developing, Documenting, Testing of ETL jobs and mappings in Server and Parallel jobs using Data Stage to populate tables in Data Warehouse and Data marts Used various transformations like Filter, Expression, Sequence Generator, Update Strategy, Joiner, Stored Procedure, and Union to develop robust mappings in the Informatica Designer.
• Worked with Automation of Cube deployment and Cube processing with SSIS ETL packages.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert , Merge and union all.
• Developed SSIS ETL packages for performing multiple Data flow transformations on system as per the Customer Business data needs by maintaining data Integrity.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Created and managed SQL Server login, database users and Roles.
• Assisted in designing and creating website for the system using ASP, HTML, and CSS.
• Scheduled jobs for backup and created alerts for error reporting.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Extensively worked on various reports such as Drill-through, Drill-down, Sub Reports and Matrix Report, Bars, Chats and deployed them to Report Manager
• Designed Power BI data visualization utilizing cross tabs, maps, scatter plots, pie, bar and density charts.
• Created Power BI and sport fire reports for business user and executives to support the key decision-making process.
• Actively worked on creating Power BI dashboards, connecting live to various data sources, creating a data model with all the available sources in Power BI and created visuals.
• Working knowledge of OLAP Cube Design & Development and Deployment using SSAS.

Environment: MS SQL Server 2016/2012, PL/SQL, Snowflake Cloud Computing, SSIS, SSRS, Informatica Power Center 9.X, Informatica, MS Excel, TFS, Visual Studio 2014, Guidewire Policy Center, Claim Center, Jupiter Notebook Red Gate SQL Search, Red Gate Data Compare.

Confidential, Fort Worth, TX

Sr. SQL BI/ETL Dev

Responsibilities:

• Interacting with Business Analysts and Developers in identifying the requirements and designing and implementing the Database Schema.
• Writing queries to create stored procedures, User Defined Functions, Views, Triggers and CTEs (Common Table Expressions) for complex financial business requirements.
• Using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check and Unique etc.). Writing Complex T-SQL Queries, Sub queries, Co-related sub queries and Dynamic SQL queries.
• Created SSIS Packages, Informatica Mappings to load data from Source to destination database and generate a text file and email the same to the users.
• Used Look-up transformation and Slowly Changing Dimension transformation to insert the new records and update existing records with no primary key.
• Performance-tuned existing stored procedures with severe efficiency issues, making them more user friendly and run smother.
• Created SSIS Packages using Variables, Expressions and Environment Variables
• Automated ETL Data loads and established efficient ways of Error Handling in SSIS
• Implemented Event Handlers, Package Configurations, Logging, System and User-defined Variables, and Expressions for SSIS Packages.
• Creating packages to Extract, Transform and Load data using SQL Server Integration Services (SSIS/ETL) into local databases to facilitate reporting operations. Loaded the Fact and Dimension tables.
• Used Datastage Manager for importing metadata from repository, new job categories and creating new data elements.
• Used various transformations like Source Qualifier, Joiner, Lookup, sql, router, Filter, Expression and Update Strategy.Experience in designing, configuring, deploying SSIS packages and providing security for packages.
• Involved in maintaining the Error-Logging for the SSIS/ETL packages Involved in the design of transformation strategy from OLTP to OLAP Interfaces using SSIS and the new SCD Task.
• Created various reports such as Drill-through, Drill-down, Sub Reports and Matrix Report.
• Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Implemented various calculated columns using DAX expressions in Power BI
• Involved in developing Cubes in Business Intelligence Development Studio using SSAS

Environment: SQL server 2012, SSIS, SSAS, SSRS, VS, Informatica PowerCenter Designer, PL/SQL, SQL Diagnostic Manager, ETL, Team Foundation Server (TFS), Confidential Outlook

Confidential

Sr. Sr. SQL BI Dev

Responsibilities:

• Involved in optimization of queries, improving the performance by using various approaches from execution plans, Index optimization, and DMV’s.
• Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Developed SSIS Templates which can be used to develop SSIS Packages such a way that they can be dynamically deployed into Development, Test and Production Environments.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Merge and Send Mail task etc.
• Applied various SSIS data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column, For Loop, For Each Loop, Sequence containers.
• Maintained records in Excel Spread Sheet and imported data into SQL Server Database using SSIS.
• Used Data stage Manager for importing metadata from repository, new job categories and creating new data elements
• Designed Enterprise reports using SQL Server Reporting Services (SSRS 2008/2012) which make use of multiple value selection in parameters pick list, cascading prompts, drill thru reports, drill down reports, matrix dynamics reports and other features of reporting service.
• Developed Charts, Pie-Charts, Bar-graphs, series on SSRS
• Expertise in dealing with primary control for Tablix reports
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Identified and worked with Parameters for parameterized reports in SSRS 2008/2012.
• Based on the OLAP reporting needs, developed complex SSAS cubes with multiple fact measure groups, and multiple dimension hierarchies.
• Experience in Dimensional Data Modeling Star and Snowflake Schemas.

Environment: SQL server 2012, Windows 2008 R2 Standard Edition, SSIS, SSAS, SSRS, VS, SQL Diagnostic Manager, ETL, Team Foundation Server (TFS), Confidential Outlook

Confidential, Richmond, VA

SQL BI Dev

Responsibilities:

• Communicating with business users to deliver reports and other user interfaces that drive business value and efficiently and effectively leverage the use of data.
• Experience working with EDI transactions 270,271,276,277,278,834,835,837 etc.
• Extensively worked on loading/reporting Medicare, Medicaid and CHIP data.
• Creating packages to Extract, Transform and Load data using SQL Server Integration Services (SSIS) into local databases to facilitate reporting operations. Loaded the Fact and Dimension tables.
• Designed ETL SSIS packages to process data to target databases.
• Develop the Documents for Logging/Error Handling for SSIS Packages
• Designed ETL SSIS/ETL packages to process data to target databases.
• Created SSIS//ETL packages for migration of data which handles the synchronization y process between the databases
• Involved in maintaining the Error-Logging for the SSIS/ETL packages Involved in the design of transformation strategy from OLTP to OLAP Interfaces using SSIS and the new SCD Task.
• Scheduled Jobs to call ETL/SSIS packages and Stored Procedures.
• Generated Sub-Reports, Drill Down reports, Drill through reports and Parameterized reports using SSRS. Deployed all the reports to reporting server, SharePoint, Excel & PDF and provided Documentation support on SSRS 2012 as assigned.
• Wrote T-SQL for the retrieval of the data. Identified the Data Source and defining them to build the Data Source Views.
• Querying, creating stored procedures and writing complex queries and T-SQL Joins to address various reporting operations and random data requests.
• Developed Query for generating drill down reports in SSRS 2012. Created List reports, Crosstab reports and different types of charts like Column charts and Bar charts.
• Designed Enterprise reports using SQL Server Reporting Services (SSRS 2008/2012) and Excel Pivot tables based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, drill thru reports, drill down reports, matrix dynamics reports and other features of reporting service.
• Experience working with QNXT application for Integration and Reporting
• Worked on build star schema and snowflake schema in Analysis Created partition table for very large database for good performance.
• Involved in Performance Tuning and Optimization by tuning T-SQL and Stored Procedures for effective retrieval of data

Environment: SQL server 2012, Windows 2008 R2 Standard Edition, SSIS, SSAS, SSRS, VS, SQL Diagnostic Manager, ETL, Team Foundation Server (TFS), Confidential Outlook

Confidential, Issaquah, WA

SQL SSIS/SSRS Dev

Responsibilities:

• Interacting with Business Analysts and Developers in identifying the requirements and designing and implementing the Database Schema.
• Involved in database design process and data modeling process
• Developed stored procedures, complex queries, triggers and functions by using T-SQL.
• Responsible for defining Check constraints, business rules, tuning data, indexes for SQL Queries
• Designed ETL SSIS packages to process data to target databases.
• Created SSIS/ETL packages for migration of data which handles the synchronization process between the databases
• Implemented incremental Load for many SSIS packages.
• Experience in Error handling, Debugging, error logging for production support in SSIS.
• Experienced in Extracting, Transforming and Loading ETL data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Expertise in creating cascading parameters, expressions, filters, charts, tabular reports, matrix reports in SSRS 2008
• Developed standard reports, sub reports and charts using crystal reports.
• Extensively worked on converting of crystal reports to SSRS reports.
• Extensive worked on Tablix control reports in reporting services
• Based on the OLAP reporting needs, developed complex SSAS cubes with multiple fact measure groups, and multiple dimension hierarchies.
• Built efficient SSIS packages for processing Fact and Dimension tables with complex transforms and type 1 & type 2 changes.
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Experience working with TFS Check in, Check out, Assigning tasks and updating tasks

Environment: MS SQL Server 2008 R2/2012, MS SQL Server Reporting Services 2008 R2/2008/2012 R2, T-SQL, PL/SQL, SSIS 2008 R2/2008/2012 R2, TFS, Outlook.