SUMMARY

• 7+ Years of IT experience in Business Intelligence, Database Development, Quantitative Analytics experience with deep expertise in System Analysis, Design, Development, implementation and support of MS SQL Server 2005/2008//2008 R2/2012/2014/2016/2017.
• Proficient with Tableau Desktop, Server, Administration, Public reader as Developer.
• Extensive experience with all phases of Software Development Life Cycle with in - depth domain knowledge in Telecom, Healthcare, Marketing/Sales, Customer Experience, Loyalty, Finance and Insurance with a rigor to improve client support by providing sustainable solutions.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and De-normalization as required of the large-scale OLTP/OLAP databases using Erwin, Visio.
• In-depth knowledge in ER Modeling and Dimensional Modeling (Star and Snowflake Schema) building Dimension and Fact tables.
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Excellent in High Level Design of ETL DTS Packages & SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (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.
• Experience in working with Data Cleansing technique in ETL procedures.
• Experience in Performance Tuning in SSIS Packages by using Sorting, Design Alternatives and by Measuring Performance.
• Experience in Error Handling by using event handlers and also provide custom logging for SSIS packages.
• Experience in handling Heterogeneous Data Sources and databases Oracle, TERADATA, IBM DB2 and CSV and XML files using SSIS.
• Skillful in Creating, Managing, Delivering SQL Server Reports using SSRS 2005/2008/2012/2014 .
• Experience with Ad-Hoc Reporting using Report Builder in SSRS for daily reports.
• Experience in creating Multidimensional Cubes using SQL Server Analysis Services (SSAS) and Tabular Model.
• Experience in implementing KPI’s, Aggregation, Partitions, Perspectives, Hierarchies and Calculated Members using SSAS.
• Experience in creating Jobs, Alerts, SQL Server Agent, and Scheduled SSIS Packages.
• Versatile in BIDS (Business Intelligence Development Studio), Query Analyzer, Profiler, SQL Server Management Studio (SSMS).
• Well versed with HIPAA, Facets claim adjustments, claim processing from point of entry to finalizing, claim review, identifying claims processing problems, their source and providing corresponding solutions.
• Excellent knowledge of HIPAA (Health Insurance Portability and Accountability Act) transaction codes such as 270/271 (inquire/response health care benefits), 276/277 (claim status), 470 (benefit codes), 835 (payment or remittance advice), 837 (health care claim) and 834 (benefit enrollment).
• Expertise in using Team Foundation Server (TFS), Tortoise SVN, GIT and Visual Source Safe (VSS) as a tool for repository of codes and version control, branching and merging into production.
• Experience in developing the applications using T-SQL Programming (DDL, DML, and DCL).
• Experience with .NET framework using ASP.NET, C#, XML and ADO.NET database connectivity.
• Proficient in Database performance optimization, debugging and tuning using the Query Analyzer, SQL Profiler and SQL Server Debugger.
• Good knowledge and exposure to Database Mirroring, Replication, Log shipping, backup and restore procedures and disaster recovery.
• Experience with different scheduling tools like SQL Agent, Tidal Scheduler and TWS.
• Proficient with automated Testing Tools - Win Runner, Load Runner and QTP for testing Client /Server and Web based applications.
• Experience in agile and scrum methodologies.
• Excellent Communication, Analytical and Inter Personal Skills and ability to learn new concepts and supported 24/7 on call in production and development environment.

TECHNICAL SKILLS

RDBMS/DBMS: MS-SQL Server 2012/2008R 2/2008/2005/2000 , Oracle 11g/10g/9i/8iBusiness Intelligence Tools: SQL Server integration Services(SSIS), Microsoft SQL Server Reporting Services (SSRS), SQL Server Management Studio(SSMS), SQL Server Business Intelligence Development Studio(BIDS), SQL Server Enterprise Manager, Microsoft management Console, Data Transformation Services (DTS), DTSX, Team Foundation Server(TFS), SQL Server Analysis Services (SSAS), OLTP, OLAP, SAS Enterprise Guide

Reporting Tools: Microsoft SQL Server Reporting Services(SSRS), Tableau, Power BI

ETL Tools: DTS, SQL Server Integration Services (SSIS)

Operating Systems: Windows XP, 2000, NT, 98, 95, Windows 2003

Programming Languages: HTML, C#.Net, T-SQL, SQL, PL/SQL, Dynamic SQL, R, Base SAS

Design Technologies/Tools: Erwin r7/r4/r3.5, MS Visio 2007, SQL Profiler, SQL * Loader

PROFESSIONAL EXPERIENCE

Confidential, Denver, CO

Sr. SQL BI Developer

Responsibilities:

• Involved in complete software development life cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
• Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2012/2014 and Flat files.
• Expertise in Client-Server application development using Oracle 11g/10g/9i/8i, PL/SQL, SQL *PLUS.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
• Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers and Fuzzy Lookups etc.
• Involved in ETL architecture enhancements to increase the performance using query optimizer.
• Used star schema in designing data marts for creating SSIS ETL packages.
• Developed Complex database objects like Stored Procedures, Functions, Packages and Triggers using SQL and PL/SQL.
• Developed PL/SQL triggers and master tables for automatic creation of primary keys
• Implemented Event Handlers and Error Handling in SSIS packages.
• Created SSIS packages for Data Conversion using data conversion transformation.
• Configured the loading of data into slowly changing dimensions using slowly Changing Dimension wizard.
• Advanced extensible reporting skills using SQL Server Reporting Services (SSRS), Micro-Strategy and Tableau.
• Designed and created Report templates, bar graphs and pie charts based on the Telecom/sales data.
• Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
• Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2012.
• Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the client requirements.
• Support existing data warehouse reporting platform and applications to ensure operational availability and scalability
• Developed Tabular Reports, Ad-Hoc Reports using SSRS Report Designer.
• Modified several exiting reports based on the Business requirements and published in SharePoint development and production environment.
• Designed and built SSAS complex cubes which include millions of records which were complex and deployed them.
• OLAP model based on Dimension and FACTS for efficient loads of data based on Star Schema structure on levels of reports using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX.
• Created relationship in both cube structure as well as in DataSource view. Created relationship like many to many, fact, reference, and regular. Used refresh strategy after the modification made to the cube in DataSource view.
• Assigned roles to particular user to access the SSAS cube. Deployed and processed the cube.
• Created several complex measures which involves many to many relationships using DAX in tabular model.
• Developed many AD-hoc reports power pivot excel considering SSAS tabular model as data source.
• Conducted data import and export operations using the DTS wizard.
• Coordinated with front-end for implementing logic in stored procedures and functions.
• Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non-clustered indexes.
• Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
• Database and Transaction log backups & restoration, backing up user databases and restoring them whenever necessary.
• Created Databases, Tables, Cluster/ Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures, Triggers and functions.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Experience in Oracle supplied packages, Dynamic SQL, Records and PL/SQL Tables.
• Collaborated with business units to help create System Test Scenarios and Test Data for User Acceptance Testing (UAT).
• Created UAT plans with several test cases for each project to ensure that the system runs smoothly after the proposed enhancements or changes have been made.
• Used SAS Enterprise Guide extensively for advanced analytics to analyze Streaming/Content, Churn Reduction, Loyalty and retention.
• Built advanced predictive models in SAS using regression analytics to analyze campaign Efficiency, Integrated/Bundle Sales, Cross Sell/Up Sell and agent participation rate for sales performance analytics purposes.

Environment: Microsoft SQL Server 2014/2012/2008 R2/2008, SSIS, SSRS, SSAS (Multidimensional and Tabular Models), C#.NET, Microsoft Azure, MS Access, ODBC, Oracle 11g,PL/SQL, Teradata 14.0, SAS Enterprise Guide, R-Studio, MS Office 2013, Micro-Strategy, Tableau, Power BI, T-SQL, R, Base SAS Programming.

Confidential, Cleveland, OH

SQL/Tableau Developer

Responsibilities:

• Writing advanced/complex T-SQL queries, analyzing existing stored procedures and recommending modifications for efficiency gains.
• Used SQL Server 2012 tools like SQL Server Management Studio, SQL Server Profiler, and SQL Server Visual Studio.
• Used T-SQL in constructing User Functions, CTE’s, Views, Indexes, User Profiles, Relational Database Models, Data Dictionaries and Data Integrity.
• Created Table Reports, Matrix Reports, Parameterized Reports, Sub-reports, Charts, and Grids using SQL Server Reporting Services 2012.
• Created Dashboards, Line Charts, Trend Graphs using Tableau Desktop 2018.1/2019.1
• Testing Packages and fixing bugs using SQL 2012 Business Intelligence Development Studio.
• Scheduling and executing SSIS Packages, using SQL Server Agent.
• Creating SSIS package to import data from SQL tables to different sheets in Excel.
• Optimizing the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, established joins and created indexes.
• Creating SSIS Packages to extract data from CSV and TXT files into schema tables and sends Email attachment of the extracted data.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring and archived data files for different DBMS.
• Bug fixes in SSIS, SSRS, stored procedures as necessary.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Performance tuning of SQL queries & stored procedures using SQL Profiler and Index Tuning Wizard.
• Used C# and VB Scripts in ETL Packages where ever necessary.
• Worked in an agile scrum methodology.
• Used various SSIS tasks such as Conditional Split, Derived Column, which were used for Data Scrubbing, data validation checks during Staging, before loading the data into the Data warehouse.
• Scheduling the jobs to run for ETL using SQL Server Agent.
• Worked on writing the T-SQL code for the historical data to pull according to the requirement.
• Debugging PL/SQL packages to troubleshoot issues.
• Writing (Back-end) PL/SQL code to implement business rules through triggers, cursors, procedures, functions, and packages using SQL*Plus Editor and
• Played roles like production support of SSIS and SSRS jobs.
• Designing of deployment scheme for migrating SSIS package from Development to Test to UAT and Production by using the configuration files
• Implemented Complex business logic with User-Defined-Functions, Index Views and also created User Defined Data type, Clustered & Non-clustered Indexes.
• Perform T-SQL tuning and optimizing queries for and SSIS packages.
• Worked on Incremental Loads using concepts like Checksum and Column to Column compare.
• Assisted Testing teams in Regression testing and Black box testing; Participated in Navigation testing, Smoke testing and UAT of each build during the various phases of the application.
• Interfaces with Business users and Technical SMEs to clarify requirements, review design, test case and UAT and deployment. Design fact and dimension tables.
• Use of SharePoint 2010 and TFS to store all the related work and report the same by creating Tasks in TFS.

Environment: MS SQL Server 2016/2012, PL/SQL, Microsoft Visual Studio 2016, BIDS, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Tableau Desktop 2018.1/2019.1 , SQL Server Analysis Services (SSAS), Microsoft SharePoint Server, Team Foundation Server.

Confidential, Dallas, TX

SQL/BI Developer

Responsibilities:

• Gathered and clarified the functional requirements from Team and Business by referring to low level design documents and designed High Level Requirement Document.
• Involved in designing the physical databases model on SQL Server 2012 RDBMS using different Data Definition and Manipulation languages (DML/DDL) implementing Constraints and Triggers for data integrity in development database.
• Created several stored procedures, functions, triggers and views for building KPIs in dashboard.
• Used Sub Queries, RANK Functions, CTEs, Temp Tables, while Loops, Union, SET operators, String Functions, Error handling and Aggregate functions in different queries in SQL Server 2012/2008.
• Wrote advanced SQL queries and stored procedures to calculate measures and perform complex database tasks using T-SQL and redesigned database to add new level in the hierarchy to make it more efficient.
• Expertise in writing and debugging stored procedures, Optimizing Code and Improving Efficiency in databases including Re-indexing, Updating Statistics, Recompiling Stored Procedures and performing other maintenance tasks.
• Created Entity Relationship Diagrams (ERD) and implemented concepts like Star -Schema Modeling, Snowflake Schema Modeling for Fact and Dimension tables.
• Created non-clustered indexes to improve the performance of queries with by understanding the Actual Execution Plan, IO Statistics, and IO Time. Eliminated key-lookups, Table Scan by modifying the query and converted Index Scan to Index Seek.
• Created, scheduled several SQL Server Agent jobs and based on requirement made them call through the Store Procedures.
• Design, develop, maintain, support and test advanced SQL Server Integration Services (SSIS) packages related to the extraction, transformation and loading (ETL) process.
• Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
• Used SSIS 2012 to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.
• Planed, defined and designed data flow processes for data migration to the Data Warehouse using DTS.
• Worked with several Control Flow tasks, Data Flow tasks, Transformations (derived column, lookup, merge join, conditional split, slowly changing dimensions, data conversion etc.) in SQL Server Integration Services (SSIS) packages.
• Used C# for reading and writing variable in Script Task of SSIS. Worked in Extracting, Transforming and Loading (ETL) data from Sybase database to MS SQL Server by using SSIS 2012 .
• Used SSIS to create ETL packages to validate, extract, transform and load data to Data Warehouse databases.
• Worked with EDI transactions like 270, 271, 276, 277, 835 and 837I/P/D .
• Worked on HIPAA Transactions and Code Sets Standards according to the test scenarios such as 270/271, 276/277,837/835 transactions.
• Prepared the ITS host matrix that provides the inventory of components that are needed for ITS host implementation on Facets platform
• Worked with different kind of data sources i.e. flat file, OLEDB, ODBC, ADO.NET, etc. and loaded the data into different tables and vice versa i.e. created the flat file and loaded the data from tables.
• Developed complex Stored Procedures and views to generate various Drills through reports, parameterized reports and linked reports using SQL Server Reporting Services (SSRS).
• Developed critical SSRS reports using T-SQL stored procedures and complex SQL queries with custom coding for dynamic parameter change and formatting.
• As a part of project designed graph, chart, etc. reports for better visualization in SSRS.
• Built MDX queries used in reports of various clients' legal related documents using tuples and sets.
• Redesigned and tuned Stored Procedures, Views, Indexes and was successfully able to increase the performance of the queries. SQL Profiler and Database tuning advisor have been used to analyze complex queries.
• Integrated huge databases such as SAS, Teradata into SQL Server 2012.
• Responsible for Scheduling the Stored Procedures , SSIS Migration Packages through SQL Server Agent Job on weekly and monthly basis.
• Involved in analysis and issue report of mapping elements between old and new databases created by System and Business Analyst team.
• Understand CUBEing and doing the impact analysis on the migration of new Business scenarios introduced along with the Release of Normalizing the databases.
• Offshore coordination and issue resolution with Database and QA team working at offshore development centers.
• Data Quality Unit Testing of Migration Packages and processes which involved complex Stored Procedures, SQL blocks and efficient quality comparison scripts.
• As a Facets Systems Analyst, participated in BRD review and Solution workbook sessions for Interfaces and Facets Extension components.
• Created High level solution architecture for new Interfaces and Facets Extension components

Environment: MS SQL Server 2012/2008R2, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), PL/SQL, C#.NET, T SQL, SQL *Profiler , XML, Erwin r7, DTS, Team Foundation Server (TFS), MS Excel, Excess, Windows.

Confidential

SQL /ETL SSIS Developer

Responsibilities:

• Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
• Created new database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in SQL Server 2005/2008.
• Validated change requests and made appropriate recommendations. Standardized the implementation of data.
• Promoted database objects from test/develop to production. Coordinated and communicated production schedules within development team.
• Modified database structures as directed by developers for test/develop environments and assist with coding, design and performance tuning.
• Managed user access.
• Created and managed new security accounts. Backup and restore databases.
• Developed and implemented database and coding standards, improving performance and maintainability of corporate databases.
• Created SSIS Packages using SSIS Designer to export heterogeneous data from OLE DB Source (Oracle), Excel Spread sheet and loaded the data into target data destination (SQL Server 2008) by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Migrated DTS 2000 packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Service.
• Experience in working creating Multidimensional cubes using SSAS.
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services. - Add only in SSAS requirement.
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2008.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Assisted with various ad hoc query requests.
• Provided back-end support for functional testing and performance testing.

Environment: SQL Server 2005/2008, Oracle, PL/SQL, T-SQL, DTS Designer, MS-Office, MS-Excel, VSS

Confidential

Jr.SQL/ BI Developer

Responsibilities:

• Worked on SQL Server Integration Services (SSIS) to integrate and analyze data from multiple heterogeneous information sources (Oracle & Sybase)
• Created packages in SSIS with error handling.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Experience in SQL Server Analysis Services (SSAS) for data mining to identify rules and patterns in the data.
• Experience with SQL Server Reporting Services (SSRS) to author, manage, and deliver both paper-based and interactive Web-based reports.
• Web Form design and coding using Master Pages, Server controls, Cascading Style sheet, JavaScript, html in .net development.
• Wrote business logic code in C# code behind files to read data from database stored procedures.
• Developed stored procedures and triggers to facilitate consistent data entry into the database.
• Wrote store procedures to generate account statements.
• Worked with T-SQL to create Tables, Views, and triggers and stored Procedures.
• Created SQL scripts for tuning and scheduling.
• Performed data conversions from flat files into a normalized database structure.
• Created and managed users, roles and groups and handled database security.
• Created Triggers to enforce data and referential integrity.
• Defined Check constraints, Business Rules, Indexes, and Views.
• Involved in migration of SSRS from SQL 2000 to SQL 2005.
• Created custom and standard reports using Crystal Reports.
• Used SQL Server to create stored procedures, views and calling through the application.

Environment: SQL Server 2008/2005, SSIS, SSRS, Visual Studio, .NET, Crystal Report.