SUMMARY

• 9+ years of wide - ranging experience in Database Design, Development, Implementation, Debugging and Testing of software applications to support reporting and Business Intelligence initiatives in Healthcare, Insurance Academic and Finance industries etc.
• Proficiency in Microsoft Business Intelligence technologies like MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS) and MS SQL Server Reporting Services (SSRS).
• Efficiently used Data Flow Tasks such as Excel Source, Flat File Source, OLE DB Source, Data Conversion, Lookup, Aggregate, Audit, Multi Cast, OLE DB Command, Sort, Union All, and Copy Column, Derived Column, cleaning bad data, Validating data using Derived Column, Row Count, Excel Destination, Flat File Destination, OLE DB Destination, Raw File Destination, SQL Server Destination, Record Set Destination of the integration services (SSIS).
• Experienced in writing T-SQL scripts, complex stored procedures, functions, triggers and complex joins and sub queries in SQL Server Management studio (SSMS).
• Highly proficient in packages to extract, transform and load data (ETL) using SSIS, designed packages which are utilized for tasks and transformations Data Conversion and Pivot tables.
• Extensively worked on Control Flow Tasks such as for each Loop Container, For Loop Container, Data Flow Task, File System Task, Script Task, Execute SQL Task, FTP Task, Execute Process Task, and Send Mail Task.
• Hands-on star schemas, snowflake schemas, dimensional modeling and reporting tools, operations Data Store concepts, Data Marts and OLAP technologies.
• Managed database integration issues including migration between disparate databases, integration, maintenance/conversion, capacity planning issues, and new applications
• Experience in debugging the SSIS packages using breakpoints and checkpoints.
• Experience in transforming unstructured data from various data sources using SSIS like Conditional Split, Lookup, Merge Join and Sort.
• Strong skills in writing MDX queries to access cubes in SSAS and creating feeds from OLTP systems.
• Designed and implemented user defined hierarchies in SSAS including parent-child hierarchy.
• Expertise with SSRS (tabular reports, parameterized reports, drilldown, drill through, sub reports, charts etc.)
• Highly proficient in creating data sources, data source views, dimensions, measures, measure groups, perspectives, partition aggregations. Analysis and Reporting Services, MDX queries, OLAP Cubes, and deployment and processing SSAS objects.
• Experience in Integration of various data sources like SQL Server, Oracle, Access DB, DB2 and Flat File, Excel File.
• Experience in Data warehouse as DataStage Designer for creating jobs flows to extract, transform, integrate and load data.
• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Highly proficient in the use of SQL for developing complex stored procedures, triggers, tables, user profiles, User functions, relational database models and data integrity, SQL joins and query writing.
• Strong understanding of Data Modeling in data warehouse environment such as star schema and snow flake schema
• Developed complex SQL queries using stored procedures, CTEs, Temp tables to support Power BI and SSRS reports
• Extensively worked on Table Design creating Clustered Indexes, Non-Clustered Indexes, Primary key Foreign Key Relationships, Highly complex joins and SQL Scripts for Views and Materialized Views.
• Created Pivot tables using Power Pivot and Power Query.
• Widely worked on to improve SQL Query performance, SQL Query analytics and highly complex joins to populate the desired result set.
• Worked on various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Modified existing Crystal Reports and provided installation supports for business functions.
• Comprehensively worked on SQL scripts using local and Global Temp Tables, Variables and Table Variables, Common Table Expressions (CTE) as per the requirement and convenience.
• Worked on SQL scripts PLSQL, Creating Tables, Clustered/Non-Clustered Indexes Joins, to get the desired result sets from the Oracle Database as per the requirement
• Hands-on Deploying reports, creating report schedules and subscriptions. Managing and securing reports and proficient in MS Office includes MS Excel, creating spread sheets, graphs and dashboard reports.
• Excellent skills in designing Logical and Physical Modeling using ERWIN Tool.
• Experience in Data warehouse as DataStage Designer for creating jobs flows to extract, transform, integrate and load data.
• Experience in using Star Team and Team foundation server for source control.

TECHNICAL SKILLS

Server Operating System: Windows 2003, 2008, 2012.

Languages: C, C#, Pl/SQL, T-SQL

Microsoft Technologies: C#.NET, ASP.NET, VB.NET, ADO.NET

Web Technologies: HTML, XML, JavaScript/Jquery, Web Services Soap and Restful.

Data bases: MS SQL Server 2005/2008/2012/2014 , Oracle 10g, Teradata

BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), ETL, Self BI with Excel

Development Tools: Visual Studio.NET 2008/2012/2013/2015 Community Edition

Database Query Tools: SQL Server Management Studio (SSMS), Business Intelligence Development Studio (BIDS), Visual Studio 2013, SQL Profiler, DQS, Toad for SQL server

PROFESSIONAL EXPERIENCE

Confidential, Jersey City, NJ

Sr. SQL Server Developer

Responsibilities:

• Create stored procedures and SSIS Packages to collect Accounts data from different sources
• Created database objects like Tables, Views, Stored Procedures, Functions, Joins, and Indexes in T-SQL based upon the functional specifications.
• Created different types of reports such as drill down, drill through, parameterize and dash board reports and schedule them according to business requirement using SSRS.
• Designed and developed data models (physical/logical data models) based on the given specs.
• Used various sources other than SQL Server for SSIS Package such as Flat File, Excel, Oracle and DB2
• Developed complex T-SQL Queries and SQL Scripts for efficient data load based on complex business rules.
• Created and published reports on Power BI which works on regular and mobile browser
• Designed complex ETL strategies to pull data from different sources, like SQL server, oracle, and flat files and load it to the destination database after using multiple transformations.
• Wrote complex T-SQL and PL/SQL queries, stored procedures, views, triggers, functions, table variables, and cursors as per business requirement.
• Experience in writing SQL Queries for pulling large volume of records from Facets and claims database using stored procedures, and Extraction Transformation and Loading (ETL) process using SSIS.
• Involved working with data validation logic for all source data and load them in data warehouse using SSIS Package
• Experience in migrating C# application on windows servers.
• Experience in migrating databases from one environment to another environment using linked servers.
• Designed and Developed Reports using Report Builder to easily generate reports by the user.
• Configuring SSIS packages using package configuration wizard to allow Packages run on different environments.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on Inputs, scheduling the SSIS packages using SQL Server Agent Services.
• Creating multiple parameterized stored procedures that are used by the reports to get the data.
• Created Jobs, Alerts, Activity logs, Error logs to capture any possible errors using SQL server Agent.
• Enhanced performance using optimization techniques such as Normalization, Indexing and Transaction Isolation levels.
• Deployed SSIS package on the server and scheduled the packages using SQL Server Agent Services.
• Worked in end to end testing of the packages and validated the data after each load.
• Designed, developed and deployed different reports like Matrix and Tabular reports with Top N, Cascaded, Parameterized, and pie chart reports using SSRS with Report Builder.
• Generated multiple reports from SQL Server Database (OLTP) and multidimensional data model OLAP.

Environment: MS SQL Server 2012/2008, Microsoft Visual Studio 2010, Oracle 10g, MS Access, MS Excel, MS Visio, SQL Server Profiler, Windows Server 2008.

Confidential, Parsippany, NJ

Sr. SSIS/SQL Developer

Responsibilities:

• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Responsible for writing SQL queries, stored procedures, views, triggers, T-SQL and DTS/SSIS.
• Responsible for gathering requirements for the new projects and creating the data flow model of the Business requirement with MS Visio.
• Involved in integrating different Database Applications using SSIS packages.
• Developed various T-SQL stored procedures, triggers, views, and adding/changing tables for data extraction, data load and transformations
• Creating SSIS packages that involves migration from legacy systems to centralized Database.
• Designed and tested packages to extract, transform and load data (ETL) using SSIS.
• Designed packages which are utilized for tasks and transformations such as Execute SQL Task, Mapping the right and required data from source to destination, Data Flow Task, Data Conversion, Foreach Loop Container.
• Validate data before performing ETL transformations and load into SQL server database.
• Intensively worked on transformations like Derived column, import column, Export column, Row count, Union all, Copy column, Lookup, Data Conversion with SSIS.
• Created new database objects like stored procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
• Implemented transformation mapping through BizTalk server with the help of Visual Studio to achieve data transformation from one type to another.
• Worked on Deployment of packages into Production servers and managed scheduled SQL jobs.
• Created stored procedures, Cursors, Joins in T-SQL.
• Created Drill-down and Drill- through reports, also scheduled and managed weekly/monthly inspection and violation reports based on the business requirements.
• Implemented Distributed Transaction Control for the SSIS packages and event handlers to keep track of error logs. Also, to trigger emails about the failure using Email task.
• Designed and created Report templates, bar graphs and pie charts based on the inspection data.
• Experience in designing, creating, processing of cubes using SSAS.
• Using Azure server for maintaining data to perform SSIS packages and SSRS reports
• Excellent hands on experience in creating groups and measures, KPIs.
• Strong understanding of Data Modeling in data warehouse environment such as star schema and snow flake schema.
• Planned, coordinated analysis, design and extraction of encounter data from multiple source systems into the data warehouse database while ensuring data integrity.
• Experience in Dimensional Modeling.

Environment: Microsoft SQL Server 2012, Microsoft Excel, SSIS/SSRS/SSAS, DataStage ETL, Microsoft Office, MS VISO, Profiler, C#.net, Visual Source Safe, BIDS, Visual Studio, MS BizTalk Server.

Confidential, Memphis, TN

Sr. SQL/MSBI Developer

Responsibilities:

• Actively involved in the gathering requirements and analysis of the requirements related to the project and responsible for writing Business Approach Documents (B.A.D) and Technical Documents for new projects.
• Extensively worked on production support that includes Deployment of SSIS Packages into Development, Production Servers, Creating, Scheduling and Managing the SQL Jobs.
• Creating SSIS Package Configurations and maintaining their Tables by editing the values of the variables as per the requirement.
• Troubleshooting the failed SQL jobs due to errors in the sample processing and fixing them and re-scheduling the SQL Jobs.
• Created and deployed SQL Azure database using the Microsoft Azure platform. This included the creation of the database instance and all database objects.
• Implemented Azure DWH solution (MPP), Data Lake, Data Factory with Tableau reports presenting aggregated results.
• Manually running some of the SQL Jobs which generates the Weekly, Monthly and Quarterly reports after making sure that the input data acquired or not.
• Interacting with Managers, Project Directors to plan and execute the project provisions and efforts estimations.
• Worked on Data migration project by validating three source data row by row and field by filed
• Using SQL Server Integration Services (SSIS) Migrated data from Heterogeneous Sources and legacy system (Oracle, Access, Excel) to centralized SQL Server databases to overcome transformation constraints and limitations.
• Worked on the fixing the bad data in Legacy Tables in batches, created a logic to validate the data before loading to the clean table and bad data will store in the separate table and in Excel Report and notify by emails and using expressions in SSIS Packages.
• Extensively worked on Design and development of SSIS (ETL) packages to extract, transform and load data from different Sources like Excel files, flat files to the Data warehouse using different tasks and transformations like File System Task, Data Flow Task, Derived Columns, and Execute SQL Task.
• Setting up the Server Connections, File paths, Parameters mapping, and Expressions mapping in SSIS.
• Created and mapped the Various Results, Sets and Variables wherever they are needed in SSIS.
• Extensively worked on the packages created including a variety of transformations, for example Slowly Changing Dimensions, Lookup, Aggregate, Audit, Conditional Split, Merge join, Multi Cast, Pivot, OLE DB Command, Sort, Union All, and Copy Column, Derived Column using SSIS.
• Worked on development and implementation of SSAS cube dimensions and their deployment and production support.
• Worked on MDX Queries to pull the data from the SSAS Cubes for the reporting purposes
• Worked on Development and implementation of SSRS reports and ran them as per the requirement.
• Extensively worked on Table Design creating Clustered Indexes, Non-Clustered Indexes, Primary key Foreign Key Relationships, Highly complex joins and SQL Scripts for Views and Materialized Views.
• Widely worked on to improve SQL Query performance, SQL Query analytics and highly complex joins to populate the desired result set.
• Created Views, Materialized Views to get the values dynamically using joins and other queries from the multiple tables.
• Comprehensively worked on SQL scripts using local and Global Temp Tables, Variables and Table Variables, Common Table Expressions (CTE) as per the requirement and convenience.
• Created different Facts and Dimension tables to increase the performance of complex SQL queries that are used in SSRS reporting. Fine-tuned queries to make the reports run faster, worked on query run time analytics.
• Created complex stored procedures and user defined functions, created many cascaded parameters in the reports using MDX and SQL queries.
• Created user groups and accounts for users who could access the reports, generated Daily, Weekly and Monthly Trigger based reports concerning assigned projects to clients and designated Managers.

Environment: Microsoft SQL Server 2012/2008 R2, DataStage ETL, Microsoft Excel, SSIS/SSAS/SSRS 2012/2008, Microsoft Office, MS VISO, Crystal Reports XI Release, Profiler, C#.net/vb.net, Visual Source Safe, Microsoft TFS, BIDS, Visual Studio.

Confidential, NYC, NY

SQL BI Developer

Responsibilities:

• Developed Stored Procedures, Views, user defined functions, encrypting database tables with column encryption using DES algorithm, Temporary Tables, and table valued parameters and Common table expressions as per the requirement.
• Used XML datatype extensively and performed XML DML operations on the given XML data.
• Excellent command over XML, XSLT and XSD, XML is widely used in edifact, hippa.
• Migrated DTSX packages from SQL Server 2008 to SQL Server 2012.
• Experience in creating SSIS packages, deploying the packages to production server using BIDS package deployment wizard and SQL server data transformation services new deployment wizard available with SQL server 2012.
• Worked on different types of control tasks of SSIS like WMI data task, MSMQ task, Web service task, Script task, Ftp task to upload and download files, worked with different types of connection managers like file connection manager, flat file connection manager, cache connection manager, ftp connection manager and data quality connection services manager. Also used XML task to validate XML files and XSLT for generating html pages from XML.
• Implemented Logging and Event Handlers on SSIS packages for trouble shooting application.
• Excellent report creation skills using Microsoft SQL Server 2005/2008/2012 using Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Created different types of reports which involve more number of groupings and multi-value parameters.
• Deploying reports to reports server, proving features for reports to show in PDF format as per the requirement and printing all the reports in a batch process for monthly Statements.
• Developed reports like Claim Statements, Fee Bills Transactions and some end request user reports on periodic basis.
• Sound Experience and understanding of SSAS, OLAP and OLTP cube, Data mining and Architecture.
• Created multiple reports with drop down menu option having complex groupings within the report.
• Generated matrix reports, drill down, drill through, sub reports, chart reports, multi parameterized reports.
• Experience in working on Cube structure optimization for MDX query performance in Analysis Services 2005/2008/2012 (SSAS).
• Worked on OLAP Data warehouse, Model, Design, and Implementation.
• Troubleshooting performance issues and fine-tuning queries and stored procedures.
• Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers
• Querying and manipulating multidimensional cube data through MDX Scripting in SSAS.
• Checked the configuration and performance of the existing databases including data file allocation, index, fragmentation and impact on system performance. Analyzed potential problems (response delay, locking, server down time) to avoid and optimize by following the Normalization standards.
• Worked very closely with Business Customers, End Users and resolved any business process related issues.

Environment: MS SQL Server-2012/2008R2/2008, SSIS, SSAS, SSRS, SQL Profiler, MS Excel, C#.NET, ASP.Net

Confidential, Dublin, OH

Senior BI Developer

Responsibilities:

• Prepared detailed design documents and documented it clearly while detailing the purpose of the project, source and target database structures, list of batch jobs, sub jobs and their roles, Business rules and assumptions involved in the project.
• Imported the data from flat files and were transformed and placed in DB2, Teradata Databases as they were the target databases.
• Developed SQL scripts for data dump in the Database in SQL server, DB2, Teradata.
• Involved in maintaining Data consistency and Data Integrity using various constraints like Unique, Check, Primary Key and Default.
• Implemented Performance Tuning of T-SQL Statements effectively with SQL Profiler and Database Tuning Advisor.
• Designed SSIS packages using various control flow task like Data Flow Task, For Each Loop, Execute SQL Task. Actively involved in deploying and scheduling packages.
• Effectively implemented Data Extraction and Loading from OLTP onto staging with SSIS Packages.
• Worked with various Dataflow tasks like Character Map, Aggregate, ODE Command and Conditional Split while designing SSIS Packages.
• Involved in migration of large amount of data developed application using ASP.NET 4.0, C#, ADO.NET, AJAX, SQL Server 2012.
• Assisted the organization in performing data compilation, mining and analysis required to evaluate the given data.
• Research and investigate key business problems through quantitative analyses of utilization, healthcare and cost data.
• Provided and defend conclusions and recommendations to customer based on results of analysis.
• Maintained and enhanced healthcare reporting solutions to meet a wide range of business and system requirements.
• Exercise positive interpersonal communication skills and worked independently or with a small team on all phases of software development lifecycle.

Environment: SQL Server 2008, Windows 2003/2007 server, SQL Server Configuration Manager, T-SQL, DTS, SSIS, SQL Server Reporting Services (SSRS), SQL Profiler, ASP .Net, ERWIN, TFS.

Confidential

SQL Server/BI Developer

Responsibilities:

• Participated in developing Logical design of database incorporating business logic and user requirement and building entity relationship(ER) diagrams.
• Experienced in writing T-SQL scripts, complex stored procedures, functions, triggers and complex joins and sub queries in SQL Server Management studio (SSMS).
• Created Data migration utilities (Import & Export, Bulk Insert) from text to SQL Server.
• Used SSIS Packages for extracting, cleaning, transforming and loading data into data warehouse.
• Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column etc.
• Worked on SSIS script task, look up transformations and data flow tasks using T- SQL and Visual Basic (VB) scripts.
• Participated in designing and developing Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes in SQL Server Analysis Services (SSAS).
• Created Data marts for Staging and Production databases for Operational Data Stores (ODS).
• Analyzed multidimensional cubes in SQL Server Analysis Services (SSAS) by using slicing and dicing.
• Designed SSRS reports with sub reports, expressions and queries, and prepared Ad-Hoc reports through report builders.
• Design, Development, Implementation and support of ETL process involving various data sources and destinations using SSIS.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.

Environment: MS SQL Server 2008/2005, Excel (pivot tables), SSIS, SSAS, SSRS, T-SQL, VB Script, Visual studio 2005, Erwin, Windows Server 2003.