SUMMARY

• 8+ years of experience of IT experience in Analysis, Design, Modeling, Development, Testing and Maintenance of Business Intelligence Applications. I have worked in different domains such as Finance and Healthcare learning Solutions. Using different versions of Microsoft SQL Services (SSMS, SSRS and SSIS) related tools.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS), and Data Stage and ETL package design, and RDBM systems like SQL Servers 2012/2014.
• Have good financial and health care experience in my previous projects creating Chart reports, Drill down and Drill through Reports in SQL Server Reporting Services (SSRS).
• In - depth knowledge of T-SQL, Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Proficient in writing complex T-SQL queries using Inner, Left, Right, Outer and Cross Joins.
• Experienced in scheduling SSIS packages using SQL Server Agent.
• Strong knowledge of using variables and expressions in packages.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Expertise in the designing, developing and deploying SSIS packages using various control flow tasks and data flow transformations like conditional split, derived column, look up, merge, sort etc.
• Proficient in implementing all transformations available on the SSIS toolbox.
• Extensive knowledge in Tuning SQL queries and improving the query performance.
• Extensive experience in report writing using SQL Server Reporting Services like Tabular report, Matrix report, Chart report, Pie Charts and column report.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Exceptional versatility and adaptability, extremely diligent having excellent communication skills and ability to work both as individual and as a team member.
• Knowledgeable in planning and implementing MS SQL Server Security, DBA and database Permissions.
• Knowledgeable in planning and implementing MS SQL Server Security, DBA and database Permissions.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills.
• Excellent adaptability and diligent having magnificent communication skills and excellent team member to work both as individual and as a team member.
• Worked in scheduling SSIS packages using SQL Server Agent.
• Experienced in translating Business System Design document into technical design document

TECHNICAL SKILLS

Databases: MS SQL Server 2014,2012, 2008/2005/2000 , Oracle 8i /10g/11g MS-Access 97-2007

Operating Systems: Windows 2008/2000/2003 Advanced Server, Windows NT 4.0 / 3.51, Windows 3.x, Windows 9.x, Windows 95/98/XP.

ETL Tools: SQL Server Integration Services (SSIS) 2005/2008, Data Stage, DTS, SQL Server Reporting Services (SSRS), Crystal Reports 8/10, SQL Server Analysis Services (SSAS)

Web Technologies: HTML, DHTML, XML, Visual Studio, MS Front

Programming languages: C, c#, VB.NET, Visual Basic for Applications (VBA) and ASP.NET, SQL, PL/SQL

Internet Tools: Internet Information Server (IIS 5.0 / 6.0), FTP, TCP/IP

Database tools: MS SQL Server Enterprise Manager, SQL Profiler, Query Analyzer, OLTP, DBCC, BCP, OLAP, ADO.NET, Database Engine Tuning Advisor (DTA)

Other Tools: Microsoft Office 2003/2007, MS Project 2000, Toad, SQL Loader, DB visualize, Erwin, Microsoft Visio 2000/2003.

PROFESSIONAL EXPERIENCE:

Confidential, MI

SQL /BI Developer

Responsibilities:

• Created database objects such as Tables, Views, Stored Procedures, Triggers, Indexes and functions.
• Experienced for database development objects (schema changes, stored procedures implementation) and SSIS packages.
• Proficient in analyzing the existing data elements (Client specific schema) and mapping to Broad ridge specific data elements.
• Worked in requirement analysis, Design and prototyping, developing unit tests, bug fixes, maintenance and production support.
• Wrote complex SQL queries, stored procedures, User Defined Functions, Views, Indexes XML Queues,
• Developed multiple reports Power BI in Drill mode using tables, financial tables, crosses tabs and chart.
• Created Power BI Desktop reports created in Report view to the Power BI service.
• Generated packages with different control flow options and data flow transformations such as Conditional Split, Multicast, Union all, For Loop, Foreach Loop, lookup, Derived Column and others.
• Implemented various transforms in SSIS to load data from flat files and Excel files to the SQL databases.
• Created functional and technical documentation to assist in the design, development and/or maintenance of deliverables.
• Prepared ETL design documents/technical specifications- Identify transformation rules using Talent.
• Used the data from different Data Sources and transformed the data as per the user criteria and used the data in the SSAS cubes for the analysis.
• Worked in Back up Strategies and implementing Disaster Recovery.
• Generated reports to retrieve data usingStored Proceduresthat accept parameters.
• PreparedSub-Reports,Drill down reports, Drill through reports, Parameterized reports using SSRS and created various types of reports like chart, tabled, matrix and linked reports and maintained accurate and complete documentation for all packages.
• Migrate and upgrade databases from older versions to 2012
• Involved in developing graphs using appropriate transformations for implementing the business logics in data loading
• Creating Back up Strategies and implementing Disaster Recovery
• Developed stored procedures to transform the data from enterprise data warehouse toSQLserver and load data to fact tables.
• Designed and Implemented the Stored Procedures and Triggers for automating tasks.
• Gathered requirements through meetings with the Users, business analysts and team members.
• Involved in all phases of the project starting from gathering business requirements to production support.
• Created and maintained security profiles for MS BI reporting needs.
• Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables.
• Created reports to retrieve data usingStored Proceduresthat accept parameters.
• Optimized schema, performance, and capacity planning of various data transformation processes related to the reports.
• Defined and designed the data sourcing and data flows, data quality analysis
• Install and maintain SQL Server 2008 R2 and 2012 database and SSRS on multiple Servers
• UsedSQLServer Agent to automate theSSIS2008 package execution.
• Configured and maintained Report Manager and Report Server forSSRS.
• Migrate and upgrade databases from older versions to 2012
• Identified and added the report parameters and created the reports based on the requirements usingSSRS2008.
• Scheduled and monitored all maintenance activities ofSQLServer 2005 including database consistency checks and index defragmentation.

Environment: SQL Server 2017/2016/2014/2012 , SSIS, T-SQL, SSMS, C# scripting, BIDS, Excel 2013, SharePoint 2013, TFS, Power BI, Visual Studio 2013/2008, Code Collaborator Client, Rally, ServiceNow.

SSIS/ETL Developer

Confidential, West Chester, PA

Responsibilities:

• Developed logical and physical database (using ER-win, Normalization, Dimension Modeling and Enterprise Manager).
• Optimized schema, performance, and capacity planning of various data transformation processes related to the reports.
• Made sure that standards and best practices in database development were followed and maintained.
• Defined and designed the data sourcing and data flows, data quality analysis.
• Identified the data source and defined them to build the data source views.
• Wrote Complex Stored Procedures, Triggers, Views and Queries. Created indexes, Constraints and rules on database objects.
• Developed and deployedSSISpackages to load data from OLTP to Data Warehouse system.
• Designed ETL packages dealing with different data sources (SQLServer, CSV, Flat Files etc.) and loaded the data into target data destination by performing different kinds of transformations usingSQL Server Integration Services (SSIS).
• UsedSQLServer Agent to automate theSSIS2008 package execution.
• Developed stored procedures to transform the data from enterprise data warehouse toSQLserver and load data to fact tables.
• Transferred data from various sources like MS Excel, MS Access, andSQLServer usingSSIS 2005/2008 and then created reports using this data usingSSRS.
• Configured and maintained Report Manager and Report Server forSSRS.
• Identified and added the report parameters and created the reports based on the requirements usingSSRS2008.
• Tested and managed theSSIS2005 andSSIS2008 packages and was responsible for its security.
• Scheduled and monitored all maintenance activities ofSQLServer 2005 including database consistency checks and index defragmentation.
• Designed and Implemented the Stored Procedures and Triggers for automating tasks.
• Maintained all records of project status and followed changes as per control procedures.
• Provided technical support to internal developers and external clients.
• Generated test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

Environment: MSSQLServer 2014/2012, MS Access 2000, Erwin v7.0, T-SQL, MS-Excel, MS-Access,SQLServer Management Studio, MSSQLProfiler.

Confidential, Charlotte NC

BI Developer

Responsibilities:

• Designed solution for Consolidating Different data sources
• Generated SSIS package to vendors in which records were loaded daily, also to other data resources such as Excel, Access, flat file and XML in order to create and maintain a centralized database.
• Developed complex stored procedures to generate reports using SSRS
• Implemented strategies for data acquisition, ODS implementation, and archive Process
• Worked and built-in relational databases.
• Fine-tuned in pulling data and deal with heterogeneous sources and optimize the data extraction and conversion process using SSIS.
• Migrated Databases from SQL Server 2008 to SQL Server 2012
• Analyzed in creating Ad hoc reporting universes using Business Objects Universe Designer.
• Analyzed and evaluated in building and retrieving data using Universes, Personal data files, and creating complex ad-hoc Reports using the Business Objects suite applications.
• Migrated and installed from SQL Server 2008 to SQL Server 2012 on Various Servers.
• Implemented and developed ETL dash boards to monitor the ETL Process
• Troubleshoot SSIS to track down the data discrepancies.
• Worked with Share Point 2010 lists in using them as interface for users
• Magnificent T-SQL Programming skills in creating stored procedures, executing, debugging, problem analysis & troubleshooting, functions, triggers, and creating solutions.
• Worked in database Performance tuning to help user in efficient reporting
• Processed high level design of ETL Package in MS SQL Server 2008 for integrating data from heterogeneous sources such as Excel, CSV, Oracle, flat file and Text Format Data.
• Developed reports using SSRS and helped develop efficient reporting solutions and setting up subscriptions as needed for SSRS
• Enhanced and Debugged SSIS Packages to fine tune the data loads and reduce the data load time and come up with Best Strategies in the data load process
• Constructed in dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements.

Environment: s: SQL Server 2017/2014 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSIS, SSRS), MS SQL Profiler, SQL Query Analyzer.