SUMMARY

• Highly motivated IT Professional with Experience in Microsoft technologies, Database and Business Intelligence Technologies with expertise on ETLprocessand Reporting using SQL Server 2016/2014/2, SSIS, SSRS and MS Power BI.
• Experience in various domain such as Financial, Healthcare, Insurance and Retail with different kind of data type and huge data size.
• Experience in migration of data and reports using SQL server 2016/2014/2012/2008 R2/2008/2005 and Visual studio 2019/2014/2012/2008/2005.
• Experience in designing, developing and maintaining buisness intelligence solutions using Powe BI.
• Expert in Database Design, Data modeling, Development, Implementation, ETL and Reporting in SQL Server 2000/ 2005/2008/2008 R 2/2012/2014/2018 with expertise on data normalization and understanding of software/application/system development lifecycle.
• Experience in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services and managing Event Handlers, Package Configurations, Logging, System and User - defined Variables for SSIS Packages.
• Lead experience in writing high level server side coding using ASP by implementing design patterns, web methods, sever events, dependency injection, and log events using Visual Studio.
• Experience in developing large number of reports like drill down, paramaterized, Ad hoc, using data from ETL loads, SSAS cubes and various hetrogeneus data sources(Access DB, excel spreadheets etc.) using SQL Server Reporting Services.
• Expertise in using Business Intelligence Development Studio (BIDS) Graphical User Interface (GUI) to design SSIS packages for Data Management applications. Experience in Normalization/De-normalization, data design methodology and building Referential Integrity. Good knowledge of security,memory management, andexception handling.
• Experienced in SQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Data Transform Services (DTS) and SQL Server Analysis Services (SSAS).Extensive experience in Data Extraction, Transformation and Loading (ETL) using DTS package in MS SQL Server 2005/2008/2008 R 2/2012/2014/2018 SQL tools like SSIS, Data Transformation Services (DTS), Bulk Insert, BCP, and XML.
• Experience and Knowledge of methodologies like Agile, Waterfall.
• Expert level experience in writing sql and mdx queries; stored procedures, views and triggers etc in Microsoft sql server.
• Good knowledge of object oriented paridigms programming like C, C++, C# in dot net framework, also scriptting languages like javascript and R for integrating in tableau for dashboard generation.
• Experienced in designing and developing large number of reports in SSRS/Tableau using the data from ETL Loads, SSAS Cubes with DMX extensions and various heterogeneous data sources. Scheduled & distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio. Highly proficient in creating database objects like tables, indexes, views, user defined functions, stored procedures, triggers, cursors, data integrity and constraints.
• Good knowleadge of RDBMS principle such as table design, ACID properties, Normalization, relationships, referential integrity and how it is used in SQL.
• Experience in data Import/Export, Bulk insert and BCP. Experienced in creating Jobs, alerts, SQL Mail Agent, scheduling packages using SSRS.
• Extensive experience in database activities like Data Modeling, Database Design & Development, Coding, Implementation, Maintenance and Performance Monitoring & Tuning using tools such as Index Tuning Wizard, SQL Profiler and Replication.
• Highly proficient with Microsoft Office tools such as Word, PowerPoint, Excel and Outlook.
• Organized, self-motivated and punctual with excellent oral and written communication skills, quick learner, can adapt quickly to a new technology, with ability to take new roles in minimum time and little training.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL Programming, Dynamic SQL, XML, Visual Basic, C#, Python, Java.

Databases: MS SQL Server 206,2014,2012,2008R2,2008,2005,MS Access,Oracle 10g/11g

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Business Intelligence Development Studio (BIDS), Visual Studio

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Business Intelligence Development Studio (BIDS), Power Pivot, Microsoft Office, Excel Power Pivot, Excel Data Explorer, Tableau.

Operating Systems: Windows, NT & Windows 9x, MS-DOS and UNIX.

PROFESSIONAL EXPERIENCE

Confidential, Norwell - MA

Programmer/Analyst (SQL/ETL Developer)

Responsibilities:

• Work with Project Manager and IT Director to understand business rules and to discuss the requirements of the clients and creating SDLC to execute the plan.
• Use SSIS to create ETL packages to validate, extract, transform and load data to data warehouse/data marts
• Capture details of IT - support requests via company-based web portal tool.
• Responsible to support the issues with SSIS packages, SQL job failures and reports failure.
• Developing dashboards for the summary of analysis using various high-level charts, parameters and filters using SSRS.
• Establishing data connection with ODBC such as Flexible Automated Collection Systems with ETLtool for data integration and reporting.
• Testing and Debugging ETL packages.
• Upgrading and Creating reports for internal payment tracking systems and for various clients’ organizations like healthcare, education, and Services to keep track of in-out payments and bad payments.
• Upgrading and developing various BAT files to make connections for data flow from client to organization and from organization to client using WINSCP.
• Designing and mapping overview documents to identify relationship between source and destination and to document the business process logic in the SSIS packages.
• Working with various kind of data connections in packages like OLEDB, ODBC, excel and documenting the patch work to be done to make ODBC work on new environment.

Environment: MS SQL Server 2012/2016/2018 , T-SQL, SQL Server Integration Services, Management Studio 2014/2019, MS SQL server Profiler, WINSCP, VB/C#.net, TFS.

Confidential, MA

Programmer/Analyst Consultant (SQL/ETL Developer, Tableau)

Responsibilities:

• Written T-SQL queries, stored procedures, user defined functions to implement mapping fields and remaining fields.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse/data marts.
• Proactively designed, used, and managed mapping overview documents to identify relationship between source and destination and to document the business process logic in the SSIS packages.
• Designed staging tables, temp tables to perform multiple joins, merge statements, views and aggregate functions.
• Created T-SQL stored procedures and mdx queries to improve the performance of aggregate queries dynamically.
• Developed SSIS packages for data migration using OLEDB connection and transformation like Lookup, Merge, Data Conversion, Copy Column, and Derived Column.
• Test and Debug ETL packages and configured the packages for migration, worked with QA teams to qualify and migrate packages from Dev to test to PROD environments.
• Created reports like Drill-down reports for Customer’s available policies and registered policies, Parameterized reports for various kind of policies like commercial, personal and life using SSRS.
• Created data cubes using SSAS for efficient use of data tables and to avoid dead lock scenarios while interacting with database.
• Involved in creating complicated packages with custom coding using c#.net in SSIS.
• Developed dashboards for the summary of analysis using various high level charts, parameters and filters using Tableau and integrating with R for generating statistical analysis of business.
• Responsible to support the issues with reports on the enterprise environments (development, UAT, test and production).

Environment: MS SQL Server 2012, T-SQL, SQL Server Integration Services, Management Studio 2012, SQL server Profiler, AWS, Erwin, C#.Net, Tableau9, JIRA.

Confidential

Asst. Developer/Programmer

Responsibilities:

• Worked closely with clients as part of a development team to evaluate requirements and developed DW solutions and web development
• Worked with DBA to design/implement/maintain the Data Warehouse and Business Intelligence solutions.
• Analyzed data for data quality and improved data architecture.
• Developed SSIS Packages for integrating data using OLE DB connection from heterogeneous sources like (Excel, Oracle, flat file, Text Format Data).
• Performed error handling in scripts for user portal of the company’s website. parameterized and sub reports etc. with different types of formats using Excel.
• For faster analysis of customer’s claims, payment and policies data; created data marts and also used DMX query’s common function like predict (DMX), range (DMX) extra for returning information as per requirement.
• Worked with visualization team to develop various dashboards for web portal.

Environment: MS SQL Server 2008R2/2012, T-SQL, VB.net, Java.