PROFESSIONAL SUMMARY:

• Over 7 plus years of IT experience in the Analysis, Design, Development, Implementing and Testing Client/server application using Confidential SQL Server and BI suite.
• Strong background in a disciplined Software Development Life Cycle (SDLC) process involving Systems Analysis, Design, Development and Implementation and working knowledge in Agile/Scrum Environment
• Experienced in client requirement Analysis, Logical and Physical design & development of database (using MS Visio, Erwin, normalization, and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2017/ 2016/ 2014/2012/2008 R2, DTS, SSIS, SSAS and SSRS.
• Experiencein dimensional modeling with Star and Snowflake schemas.
• Experience in developing Azure data factory pipelines in V1 and V2, creating linked services, data sets, monitoring and scheduling ADF pipelines.
• Experience in Relational, Multi - Dimensional (Star) and Snowflake logical modeling, fact and Dimensions tables and Logical and Physical data modeling using data modeling tools such as Erwin and ER/Studio.
• Good hands-on working experience with using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique)
• Experience in Analyzing Execution Plan, managing indexes and troubleshooting deadlocks.
• Experience in designing, developing, and delivering business intelligence solutions using SQL Server Integration Services(SSIS), Analysis Services (SSAS) and Reporting Services (SSRS).
• Experience working with the BIDS and SSDT which includes SSIS, SSAS and SSRS.
• Experiencein using ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS and designed data conversions from wide variety of source system.
• Experiencein designing SSIS Packages to extract data from various heterogeneous data sources such as Access database, Excelspreadsheet and flat files into SQL Server for further Data Analysis and Reporting by using multiple transformationsprovided by SSIS.
• Expert in Performance Tuning by Index Defragmentation, optimizing execution plans, proper usage of indexes, horizontal and vertical partitioning.
• Proficiency in Performance Tuning, Query Optimization, Client/Server connectivity, and Database Consistency Checks using DBCC Utilities.
• Experiencein designing and implementing processes for deploying, upgrading, managing, archiving and extracting data for reporting using SQL Reporting Services (SSRS).
• Experiencein creating various SSRS reports like Charts, Filters, Sub reports, Drilldown and Drill-Through, Cascade, Parameterized reports involving conditional formatting.
• Extensive knowledge and experience in dealing with Relational Database Management Systems including Normalization, Stored Procedures, Constraints, Querying, Joins, Keys, Indexes, Data Import/Export, Triggers, cursors using SQL and PL SQL. knowledge in Web technologies such as HTML, DHTML, JavaScript and XML
• Good team player with good interpersonal and communication skills

TECHNICAL SKILLS:

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

Databases: MS SQL Server 2017/ 2016/ 2014/2012/2008 R2, Oracle 10g/9i/8i, DB2, Teradata, MS Access, Redshift, Vertica

Programming Languages: C, C++, JAVA, SQL, Visual Basic

Data Modeling Tools: Physical and Logical Data Modeling using ERWIN and MS Visio

ETL Tools: Data Transformation Services, SQL Server Integration Services (SSIS)

Scripting: HTML, DHTML, XML, JavaScript

Reporting Tools: SSRS, Crystal Reports, Tableau 9.1

Testing Frameworks: Testing Tools Selenium IDE, Selenium WebDriver, Selenium Grid, Junit

Application Packages: MS Outlook, MS Office

Operating Systems: Windows 2003/2008, Windows 7, Windows NT, Windows 2000, XP

EXPERIENCE SUMMARY:

Confidential, Redmond, WA

MSBI Developer

Responsibilities:

• Creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes.
• Installed, maintained, developed using SQL Server 2017/2016
• Involved in creating, modifying and troubleshooting SSIS packages.
• Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging and Configuration Files.
• Created various ad-hoc SQL queries for customer reports, executive management reports and types of report types like tables, matrix and sub reports.
• Involved in development of Azure Data Factory Pipelines, linked services, data sets, deploy and monitor them
• Scheduling/enabling triggers for the ADF Pipelines developed.
• Wrote complex stored procedures, functions, and triggers to implement business logics in the OLTP database.
• Design and developed Test Plan and Test Cases corresponding to workflow and requirements
• Created Complex SQL queries, Derived tables, common table expressions (CTEs), stored procedures, views, user defined functions (UDF).
• Developed and maintained existing Power BI reports and dashboards and made changes onto the same as per new and changing business requirements.
• Used DAX (Data Analysis Expressions) functions for the creation of calculations and measures.

Environment: MS SQL Server 2017/2016, Confidential SQL Server Integration Services (SSIS) 2017/ 2016/ 2014/2012/2008 R2, Confidential SQL Reporting Services (SSRS) 2017/ 2016/ 2014/2012/2008 R2, Confidential SQL Server Analysis Services (SSAS) 2017/ 2016/ 2014/2012/2008 R2, MS Azure, SQL Server Data tools, Confidential Access, MS Excel, Azure data factory V1 and V2, Power BI

Confidential, Reston, VA

MSBI Developer

Responsibilities:

• Extensive Experience in Agile Methodology, starting from SCRUM, business requirement gathering and analysis to testing and deployment. Involved in the creation of database objects like tables, views, stored procedures, functions, packages, DB triggers, Indexes.
• Extensively involved in gathering business requirements that will facilitate the planning and the implementation phase of OLTP database.
• Analysis of user requirements and reporting dataset needs and create Dimensional Model to create Logical and Physical Database Design using Star Schema Methodology. (Dimensions/Fact Table Design).
• Worked on SQL performance tuning and done unit testing to check the performance on the changes made in the backend reflecting in the front end of the application.
• Created database tables, Indexes, triggers by writing SQL queries as per the database change request by the business.
• Extensively used all components of Power BI by creating different types dashboards as per the business requirement and deployed into report servers.
• Worked with the front-end Java and UI developers to ensure that the data flow between the front end and backend worked seamlessly by SQL stored procedures for DML Operations.
• Analyzed source OLTP systems and created data mapping documents for the ETL process.
• Designed T-SQL scripts to identify long running queries and blocking sessions.
• Created SSIS templates for developing SSIS packages in such a way that they can be dynamically deployed in to development, testing and production environments.
• Involved in creating, modifying and troubleshooting SSIS packages.
• Implemented transactions at package and task level in SSIS to meet the business requirements.

Environment: SQL Server 2016/ 2014/2012/2008 R2, Confidential Access, Confidential SQL Server Integration Services (SSIS) 2016/ 2014/2012/2008 R2, Confidential SQL Server Reporting Services (SSRS) 2016/ 2014/2012/ 2008 R2, Confidential SQL Server Analysis Services (SSAS) 2016/ 2014/2012/ 2008 R2, MS Azure, MS Access, JIRA, C#, .Net, PowerBI, Teradata, Excel (VLOOKUP’s, Pivot Tables), MS Visual Studio 2010 and 2008(SSIS, SSAS, SSRS)

Confidential, Needham, MA

Data Analyst/ MSBI Developer

Responsibilities:

• Designed, developed and tested ETL (Extract, Transformation and Load) strategy to populate the data from various source systems feeds using SSIS.
• Developed complex SSIS packages like Decompress JSON files and convert it to xml file and load it to staging table from SFTP server, loading PayPal, real time floating exchange rate packages using Web Services task, Execute Package task etc.
• Monitoring and Troubleshooting SQL Server Performance using Query Tuning, SQL Server Profiler, System Monitor, Database Engine Tuning Advisor, Dynamic Management Views and Functions and Resolving Blocking and Deadlocking Issues.
• Coded SSIS processes to import data into the Data Warehouse from Excel spreadsheets, Flat Files and OLEDB Sources.
• Experience in working and troubleshooting 2TB Very Large databases (VLDB) in OLTP Environment.
• Responsible for monitoring and making recommendations for performance improvement in hosted Databases. This involved index creation, index removal, index modification, file group Modifications and updating statistics in databases
• Developed Cubes using SQL Analysis Services (SSAS) and Experience in Developing and Extending OLAP Cubes, Dimensions, and data source view
• Extensively used various SSIS objects such as Control Flow Components, Dataflow Components, Connection managers, Logging and Configuration Files.
• Wrote CTEs, ranked functions to remove duplicate records in OLTP tables.
• Wrote complex stored procedures, functions, and triggers to implement business logics in the OLTP database.
• Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments.
• Created various types of SSRS reports like drill down, drill through, sub reports, Nested Chart reports and create report parameters included single valued parameters, multi-value parameters which also consisted of different parameter types queried and non-queried parameters.

Environment: SQL Server 2014/2012/2008 R2, Confidential Access, Confidential SQL Server Integration Services (SSIS) 2014/2012/ 2008 R2, Confidential SQL Server Reporting Services (SSRS) 2014/2012/ 2008 R2, Confidential SQL Server Analysis Services (SSAS) 2014/2012/ 2008 R2, TFS, MS Azure, MS Access, PostgreSQL, Tableau 8.1, C#

Confidential, Arlington, VA

MSBI Developer

Responsibilities:

• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, Wed Services) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created complex stored procedures with parameters and generated multi parameterized SSRS reports from them, where the user has a choice to select the parameters.
• Regularly implement SSIS integration processes and custom SQL / C# code to fully automate specialized insurance claims data loads and ETL procedures. Developed SSRS reports for health care stakeholders
• Created SSIS Packages by using advanced tools (i.e. pivot Transformation, Derived Columns, Condition Split, Term extraction, Aggregations, Multicasting).
• Created functions and developed procedures to implement application functionality at the database side for performance improvement, involved in Performance tuning of Queries, Indexes and Stored Procedures using SQL Profiler.
• Design and document the error-handling strategy in the ETL load process using Event handlers.
• Worked on SSAS storage and partitions and Aggregations, Calculation of queries with MDX, Data Mining Models, developing reports using MDX and T-SQL.

Environment: SQL Server 2014/2012/2008 R2, T- SQL, Confidential Access, Confidential SQL Server Integration Services (SSIS) 2012/ 2008R2, Confidential SQL Server Reporting Services (SSRS) 2014/2012/2008 R2, Confidential SQL Server Analysis Services (SSAS) 2014/2012/2008 R2, SQL Server Business Intelligence Development Studio, Star Team Version Control tool), TFS, Tableau

Confidential

MSBI/SQL Developer

Responsibilities:

• Gathered requirements and created requirement specification documents for all reports.
• Developed documentation to reflect current design ETL processes.
• Worked closely with Business Users in identifying the gaps between existing code and the business requirements in the ETL projects.
• Developed various T-SQL scripts for transaction processing of Sales, Credit and Rebates.
• Interaction with business users to refine the requirements for the end to end process flow.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Designed and optimized dynamic SQL batches to perform bulk operations in the OLTP environment.
• Developed Sub Reports, Matrix Reports, Charts, and Drill down reports, Ad Hoc reports using SQL Server Reporting Services (SSRS).
• Created Packages, Jobs and Sending Alerts using SQL Mail, database Backup, Recovery and Disaster Recovery procedures. Planned the complete Back-up of various Databases for Disaster recovery scenarios.
• Developed backup and recovery plans based on OLTP load and server down time.
• Created T-SQL queries used in PIVOT/UPIVOT, CTE.
• Created Linked Servers, Functions and Stored Procedures and Views.and send data across multiple Servers.

Environment: MS SQL Server 2005/2008 R2, Confidential Access, T-SQL, C++, MS Excel.