SUMMARY

• 7 years of experience with over analyzing, designing, tuning, and developing Client/Server, Business Intelligence (BI) database applications and various segments of Software Development Life Cycle (SDLC) using MS SQL Server 2005/20 /2016 , DTS/SQL Server Integration, Reporting and Analysis Services
• Extensive SQL Development experience in Banking, Insurance, and Healthcare industries with a strong understanding of data and analytics
• Profound knowledge of Software Development Life Cycle (SDLC) with thorough understanding of various phases like Requirements Gathering, Analysis, Design, Development and Testing using Agile Methods like Scrum, Open Agile and Lean
• Solid expertise in database development for both Online Processing & Batch Processing (OLTP) and OLAP Systems (SSRS, SSIS, SSAS) using SQL Server 2005/2008/2012
• Well versed with Spot Fire and how to use interactive and customized dashboards
• Widespread experience in creating, configuring, deploying and testing SSIS packages for ETL and Business Intelligence processes
• Good hold in Object Oriented Analysis and Design (OOAD) on Unified Modeling Language (UML)
• Highly skilled in all areas of RDBMS concepts like scripting T - SQL (DDL, DML) queries and complex stored procedures, designing and implementing views, indexes, functions and triggers
• Expertise in Normalization/De-Normalization, data design methodology and building Referential Integrity Constraints for the relational and dimensional database models
• Experienced in testing and deploying code through several Software Development Life Cycle environments like TEST, UA/UT, Production and Development
• Hands-on experience in transforming data from one server to several other servers for data migration by using tools like Data Transformation Services (DTS), Bulk Copy Program (BCP), Data Replication, Bulk Insert and SQL Server Integration Services (SSIS)
• Extensive understanding of managing and automating Control flow, Data flow, Events and Logging for SSIS packages using Microsoft .NET framework
• Strong experience in error handling, product support, debugging, testing and error logging for SSIS
• Expertise in designing, developing, and deploying several kinds of reports and dashboards using SSRS using relational and multidimensional data
• Proficient in solving problems related to troubleshooting report processing, subscription, delivery and configuration
• Expertise in querying the SSAS Cubes, identifying Key Performance Indicators (KPIs), and creating Dashboards and Score Cards using Multi-Dimensional Expressions (MDX)
• Well-versed at building the Star/Snowflake schema, Fact/Dimensional tables used in relational, dimensional and multidimensional data modelling
• Skilled at using SSAS extensively for configuring and managing data sources, data source views, dimensions, cubes and mining structures

TECHNICAL SKILLS

RDBMS/DBMS: MS SQL Server 2016/2014/2012/2008/2005 , Oracle 9i/10g, MS Access

Data Warehousing/BI Tools: SQL Server BI - MSBI (SSIS, SSAS, SSRS), DTS, Performance Point Server, TFS

Programming Languages: T-SQL, C, C#.net, VB.net, Java, JavaScript, VBScript

Web Technologies: HTML, DHTML, XML, Shell Scripting

Database Tools: SQL Server Management Studio, Enterprise Manager, Query Analyzer, BCP, OSQL, Business Intelligence Development Studio (BIDS), Performance Monitor, Client Configuration Utility, Server Configuration Utility, SQL Agent, Visio, SQL Server Agent

Data Modelling Tools: MS Visio, Erwin r7.3, ERStudio, DTS Enterprise Manager

PROFESSIONAL EXPERIENCE

Confidential, Bedford, NH

Sr. SQL Server (SSIS/SSRS/SSAS) BI Developer

Responsibilities:

• Actively participated and interacted with project manager and other team members to process the complex business logic and requirements of the project.
• Responsible for extracting and loading client historical data from different sources to SQL environment and then performing various business operations using SSIS.
• Created complex dynamic T SQL, used in functions and Store procedures, which do the payroll calculations to determine the employees who are meeting the benefits of various clients, as per there requirements and Also report to client if there are any discrepancies and then filtering it in appropriate data format as needed.
• Used the SQL Profiler, query execution plans to trace the performance of TSQL Statements to resolve query performance by designing proper indexes and updating statistics
• Wrote complex stored procedures for the Application Development using T-SQL.
• Worked on Common Table Expression which uses rank function to calculate the ranking of clients based on the policies they insured.
• Moved the data from one server to another server (SQL Server 2008 to SQL Server 2012/2014/2016 ) by cleaning the data format using various transformations like Derived column, Fuzzy lookup, lookup, Merge Join, Data conversion etc. and then finally load them into client specific payroll tables using SSIS Packages and then created SSRS reports as per client requirements.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS in Business Intelligence Development Studio (BIDS).
• Defined report layouts and created Parameterized, Drill down, Drill through and Aggregation reports in MS SQL environment using SSRS.

Environment: MS SQL Server- 2016/2014/2008 Enterprise Edition, SSIS, SSRS, SSAS, T-SQL, SSDT, TFS-Team Foundation Server Version Manager, Ceridian HR Tool, SQL Agent, Office-2013, MS Excel, SharePoint, Power-Pivot, .Net (C#, VB), Service Now, Erwin r7.3, ER Studio

Confidential, Collegeville, PA

Sr. SQL Server (SSIS/SSRS/SSAS) BI Developer

Responsibilities:

• Created and developed Databases and database objects like Tables, Stored Procedures, Functions, DDL/DML Triggers, Indexes, User defined data types, Cursors and Views using T-SQL in different environments like Development, System Integration & production using SQL Server 2014.
• Created ETL Projects using SSIS 2014 in Package Deployment Model as well as Project Deployment Model, also efficiently used SSIS catalog for ETL Monitoring.
• Developed SSISpackages that fetches files from FTP, did transformation on those data base on business need before I loaded to destination.
• Expertise in creating Metadata tables to log the activity of the packages, errors and change of the variable. Various techniques such as CDC, SCD and Hash bytes were used to capture the change of the data and execute incremental loading of the dimension tables
• Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Migrating the present SSIS packages in 2008 to SQL Server 2014 and then from 2014 to the new 2016 box.
• Experienced in designing the Conceptual, Logical and Physical data modeling using Erwin r7.3, Power Designer 12.0 and ER Studio Data modeling tools.
• Designed the data marts in dimensional data modeling using star and snowflake schemas.
• Dimensional Data Modeling experience using Data modeling, Relational Data modeling, ER/Studio, Erwin, Star Join Schema/Snowflake modeling, FACT & Dimensions tables, Conceptual, Physical & logical data modeling.
• Designing packages which utilized tasks and transformations such as Execute SQL Task, Execute Process Task, Script Task, Send Mail Task, FTP task, Execute Package task, XML Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column. Designing incremental load packages using CDC Control Task, CDC Source and CDC Splitter.
• Involved in migrating the present SSIS packages in 2008 to SQL Server 2014 environment.
• Developed, tested, and deployed all the SSIS packages using project deployment model in the 2014 environment by configuring the DEV, TEST and PROD Environments.
• Uploading all the current migrated packages to the TFS for version control.
• Creating Scheduled Jobs using SQL Agent to call the packages and Stored Procedures and configured SQL mail agent for sending automatic emails when a SSIS packages is failed or succeed.
• Worked on creating Tabular Data Model Databases and created SSRS reports on top of it using both Direct Query and Cached Modes.
• Generated periodic reports based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Involved in Creating Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS.
• Used SSRSto create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Involved and responsible for deploying all the ETL packages using project deployment model in SSDT and also deploying the full functionality reports on to the SharePoint server.
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Created a cube using multiple dimensions and modified the Relationship between a Measure Group and a Dimension, created calculated members and KPI’s, using SSAS.
• Involved in developing ASP.NET Web API Application that required integrating the Applications with Service Now using SNOW API for creating Incidents ad deploying in Azure.
• Worked on hosting new application databases on Microsoft Azure ensuring the DR setup is in working condition.
• Involved in creating a virtual machine on Azure, installed SQL 2014, created and administered databases then loaded data for mobile application purposes using SSIS from another virtual machine.

Environment: MS SQL Server- 2016/2014/2008 Enterprise Edition, SSIS, SSRS, SSAS, T-SQL, SSDT, TFS-Team Foundation Server Version Manager, SQL Agent, Office-2013, MS Excel, SharePoint, Power-Pivot, .Net (C#, VB), Service Now, Erwin r7.3, ER Studio

Confidential, Dallas, Tx

Sr. SQL Server (SSIS/SSRS/SSAS) BI Developer

Responsibilities:

• Gathering business requirements from business team; providing technical specifications for customizations/implementations using Microsoft SQL Server Management Studio and Microsoft SQL Server Data tools.
• Writing complex SQL statements using joins, subqueries and correlated sub queries and Following Normalization and De-Normalization process while creating the tables to make quick Write and Read.
• Singlehandedly produced a Full-Functionality POC (proof-of-concept) solution on an Oracle Database to MSBI conversion project in 8 weeks which involved producing a complex financial/budgeting 2014 SSAS prototype cube to demonstrate effective replacement of a portion of existing SSRS reporting for a large Financial Organization.
• Created Data Modeling, Multi-Dimensional Modeling & created Star Schema and Snowflake dimensional schema using Erwin tool.
• Designed and developed an execution ETL framework using SQL Server that process all the loans into DWH and from DWH to Downstream applications using SQL Agent. Designed to run either in batch mode or sequentially and load the batch statistics into SQL Server tables.
• Designing and developed SSIS (ETL) packages to validate, extract, transform and load data from Cassiopeia to LOP Data warehouse and then from LOP Data warehouse to downstream applications like EIS, LAPRO, REPO using SSIS.
• Worked with Data Analysts in completing the ICD (Interface Control Document) by converting the Business rules into Extract and transformation rules and Load into downstream applications using SSIS.
• Creating SSIS packages to pull the data feeds from linked servers (Oracle/ Sybase) and load data into Sybase servers
• Configuring SSIS Error handling process for all the packages using Task Factory.
• Monitoring and maintenance of development/QA/Production databases of SQL,, Sybase ASE and RSA, Oracle, and MYSQL.
• Worked with the Budget Reporting Group users to enhance and advance the usability of the SSAS cube from POC stage phase to full Production phase which involved directly collecting requirements in real-time, coming up with solutions/ways of implementing these features within the context of cube drill-through, actions, mdx calculation items or reporting features residing on the SSRS reports; or figuring other ways of satisfying the client reporting need and presenting it to the client.
• Involving in analysis of Report design requirements and actively participated and interacted with Business Analyst to understand the Business requirements.
• Set up Advanced functions, dashboard, Drill-Trough/Drill-Down, KPI/Indicators, linked reports, sub reports, Matrix Reports & Chart reports using Microsoft SQL Server 2014 Reporting Services (SSRS) and publish them to users in online thru Report Server and SharePoint server. Creating different professional reports, utilizing Dynamic & Cascading Prompts, sub-reports, charts, dynamic parameterized and conditional reports.
• Creating complex Stored Procedures for better performance to generate reports.
• Develop OLAP Cubes using SQL Server Analysis Services (SSAS) and Created MDX queries, processed facts, dimensions and populating data through SSAS into SSRS Reports.
• Created data sources, data source views, Measures, Dimensions, Attributes, Hierarchies, and Calculations using SSAS multi-dimensional expression (MDX).
• Performance tuning of SQL queries and stored procedures using SQL Profiler, Estimated Query Plan and Index Tuning Wizard to improve the performance and implement the best practices. Troubleshooting performance issues, fine-tuning queries & stored procedures.
• Used TFS-Team Foundation Server for Version Controlling.
• Schedule Jobs daily/weekly/monthly using SQL Agent /Control-M to call the packages, Stored Procedures, Reports and Cubes and configured SQL mail agent for sending automatic emails when SSIS packages are failed or succeed.
• Implementing agile project methodology to provide estimations for each Sprint, and present status, highlight and discuss if any road blocks in Scrum meetings.
• Providing 24x7 production support to Batch, continuous flow process for daily, monthly and weekly job schedule.

Environment: MS SQL Server-2016/2014 Enterprise Edition, SSIS, SSRS, SSAS, T-SQL, SSDT, TFS-Team Foundation Server Version Manager, ER-Studio, Task Factory, SQL Agent, Razor SQL, Office-2013, MS Excel, SharePoint, Power-Pivot, .Net (C#, VB)

Confidential, Omaha, NE

Sr. SQL Server (SSIS/SSRS/SSAS) BI Developer

Responsibilities:

• Installs, configures, and deploys the SQL Server Management Studio, Spot Fire Client, Visual Studio for SSIS, SSRS, SSAS
• Manages the entire ETL process using SSIS involving the access, manipulation, analysis, interpretation and presentation of information from both internal and secondary data sources to customers
• Uses PostgreSQL as the source database to pull in data into SQL Server using SQL Server Integration Services
• Building/upgrading Sybase / Sybase Replication servers, adhering to bank deployment and security standards.
• Generates SSIS packages to receive data from different sources, consolidate and cleanse the data, and merge it into one single source
• Adds logins, roles, groups to the Window NT and MS SQL Server and maintains proper security procedures
• Provides business solutions for integrating applications and database platforms to provide reporting data for the users through Crystal Reports
• Designs and builds the Dimensions, Cubes on Star Schema using SQL Server Analysis Services (SSAS) for business analysis
• Monitors SQL error logs, schedule tasks, database activity, and eliminates blocking and deadlocks user counts and connections/locks
• Performs data transfer from various types of databases with conversion through SSIS
• Uses Data Cleansing to avoid duplicate, corrupt, or inaccurate data using SSIS tools
• Schedules jobs and alerts using SQL Server Agent
• For the reporting purpose of the client, we built cubes for the users to access the client site information effectively and the cube was built directly and it was a third-normal form design.
• Schedules the reports based on the subscriptions defined
• Designs reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes, which makes use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service
• Rolls out the Spot Fire client and web player to over 60 users while configuring the server so that Spot Fire will run efficiently
• Uses SSAS extensively for configuring and managing data sources, data source views, dimensions, cubes and mining structures
• Utilizes knowledge of both PostgreSQL and Oracle Databases as they act as the source for transforming data into SQL Server using SSIS
• Uses SSAS MDX to extract data from cubes and creates MDX script for representing Cube Calculations.

Environment: MS SQL Server-2014 Enterprise Edition, SSIS, SSRS, SSAS, T-SQL, SSDT, TFS-Team Foundation Server Version Manager, ER-Studio, Task Factory, SQL Agent, Razor SQL, Office-2013, MS Excel, SharePoint, Power-Pivot, .Net (C#, VB)

Confidential

SQL Server Developer

Responsibilities:

• Monitored Log Shipping/Replication and troubleshot errors
• Created Linked Servers between SQL Server 2000 and Oracle 9i
• Wrote complex Stored Procedures, User Defined Functions, Triggers using T-SQL
• Created DTS packages for data transfer between the two environments
• Performance tuned SQL queries and stored procedures using SQL profiler and index tuning advisor
• Developed a SOA based Stock Brokerage System using Web Services
• Resolved any deadlocks issues with Databases/Servers on a real-time basis
• Wrote scripts for generating Daily Backup Report, verified completion of all routine backups, log space utilization monitoring
• Participated in change and code reviews to understand the testing needs of the change components
• Worked on troubleshooting defects in timely manner
• Performed Unit testing with the test daily file and sent the everyday test Agent training file by running the jobs manually.

Environment: SQL Server 2000 Enterprise Edition, Windows 2000/NT, UNIX, Excel, SQL Profiler, Replication, DTS, MS Access, T-SQL, Crystal Reports