SUMMARY

• Over 9+ Years of IT experience in Database Design, Analysis and Development in MS SQL Server 2005, 2008 R2, 2012, 2014 providing Business Intelligence solutions for Data warehousing Applications using Microsoft BI Stack.
• Worked extensively on System Analysis, Design, Development, Testing and Implementation of projects in Software Development Life Cycle.
• Experience includes thorough Domain knowledge of Health Care, Business Financial system and Banking.
• Lead both the Development and Maintenance teams by coordinating wif the Business stakeholders and other vendors by ensuring the deadlines are met adhering to the standards.
• Experience in Release Management and Disaster Recovery.
• Worked extensively in Design, Development and Implementation of business requirements wif Microsoft SQL Server database system in client/server environment.
• Experience in drafting the Functional and Technical specifications for a business problem.
• Good Working Experience in SQL Server, SSIS, SSAS, SSRS, MDX, DAX, Confidential, C#.NET, VB.NET, MS EXCEL and POWER BI.
• In Depth Knowledge in both Dimensional (UDM/BISM Multidimensional) and Relational Modeling.
• Experience in using T - SQL Queries, Multidimensional Expressions (MDX) & DAX.
• Expert of Relational Database Management system (RDBMS) Concepts.
• In Depth Knowledge in creating Logical Data Model & Physical Data Model by understanding Business using Visio / ER Modelling tool.
• Experience in Architecting Data Warehouse and Extraction, Transformation, and Loading (ETL) for complex business dat gets data from various sources into Data Warehouse and designing Data Marts out of warehouse.
• Expert in creating Indexes, Views, complex Stored Procedures, Table Partitioning’s, Functions, CLR Stored procedures, CDC, Columnar Indexes to facilitate efficient data manipulation and data consistency.
• Experience in Implementing Query Optimization Techniques of T-SQL queries, In Memory concepts in SQL Server, Performance improvement of SSIS Packages, SSAS Multidimensional Cubes (Both processing & querying) and SSRS Reports.
• Excellent knowledge in Creating SSIS packages wif Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle, SAP systems to MS SQL Server by using SSIS Packages. Expert in implementing Bulk Insertions, Error Handling, Logging, Configurations, Creating Jobs, Scheduling using windows and SQL Server Agent, Notification mails (Interactive HTML - Email notifications).
• Designed standard SSIS ETL Templates which can be reused wif small to enterprise level loading which includes Logging, Error Handling, and Interactive Notifications wif robust framework which makes easy for debugging and ease of development.
• Designed standard SSRS Templates which includes implementation of CSS in reports (Common for all reports), formatted layout for enhanced development.
• Excellent knowledge on creating SSAS Multidimensional Cubes according to the business requirements wif creating Dimensions, Hierarchies, Attribute relations, KPIs, Perspectives, Aggregations, Calculations and Roles.
• Extensive experience in Development and Deployment of Reports using SSRS. Developed Custom/Dynamic reports, Different types of Tabular, Matrix Reports, and Drill down reports, Parameterized reports, Sub reports, Subscriptions.
• Expert in writing C#.NET, VB.NET which can be used to write custom code through Script Component in SSIS and SSRS Custom code areas.
• Expert in handling Source Control tools like Visual Source Safe (VSS); Team Foundation Server (TFS).
• Has good exposure in Power View, Power Pivot and the Latest Power BI (Power Query, Power Maps).
• Strong Initiative and excellent project management skills & in mentoring team members and conducting training sessions.

TECHNICAL SKILLS

Relational Databases: SQL Server 2012,2008/2005/2000, MS Access

Tools and Packages: SQL Server Management studio, SSAS, SSIS, SSRS, Microsoft Visual Source Safe, Visual Source Team Foundation

Languages: T-SQL, Confidential, VB.Net, C#.Net, HTML, TSQL, JAVASCRIPT

X: Windows vista/XP/2003/2000/NT 4.0/9x, MS-DOS, Windows Server 2008

Web Technologies: HTML, XML, XSL, JavaScript, IIS(4.0/5.0/6/0)

Application Packages: MS Office, MS Access, PowerPivot, Power View, MS Outlook (Microsoft Office Suite)

Version Control: TFS, Visual Source Safe, CC Harvest

PROFESSIONAL EXPERIENCE

Confidential, Plymouth Meeting, PA

Team Lead

Responsibilities:

• Lead the team in Requirements gathering architected the design, coding and testing.
• Providing the effort estimates for the projects and Preparing BRD, FRD and TDD documents.
• Responsible for initiating the meetings wif business stakeholders in understanding the source systems and analyzing the data feeds for integration.
• Designed the Logical Data Model & Physical Data Model using ER tool.
• Periodical review of the code and helping the development team in maintaining coding standards.
• Maintaining project metrics and monitoring the project performance.
• Design and Develop the Standard SSIS Template used across the project required for Data loading and Used these standard SSIS packages to extract, transform and load from various data sources to data mart and generated flat files to be sent to vendors.
• UsedSQLProfilerfor troubleshooting, monitoring, optimization ofSQL code.
• Scheduling of the packages using SQL Server agent.
• Design and Develop Data marts tailored to specific downstream.
• Design, Develop and Deployment Cube using SSAS.
• Participated in Build and deployment activities of all the components.
• Involved in writing MDX queries, Develop SSRS reports.
• Enhancing Dimension processing performance and Partition processing Performance.
• Improved Performance of Relational sources using SQL Server using indexes, Table partitioning etc.
• Mentoring and taking application/technical sessions to juniors in the team.

Confidential

Senior BI Developer

Responsibilities:

• Created and tuned complex SQL Queries, stored procedures, views, tables and database objects as per the Design on TDD
• Extensively worked on designing reports using SQL Server Reporting Services (SSRS).
• Involved in Designing, Development and Deploying of all objects related to Cube using SSAS.
• Coordinated wif business users and implemented OEM Cube enhancements and performance tuning related to cube processing.
• Created Partitions in SQL Server & OEM Cube to improve performance.
• Involved in creating Dimensional model.
• Writing MDX queries for Querying and Calculation purposes etc.
• Involved in Enhancing Dimension processing performance and Partition processing Performance.
• Improved Performance of Relational sources like SQL Server using indexes, Table partitioning etc.
• Composed of test strategies (which support/enhance the development methodology), test cases and test results

Confidential

Senior BI Developer

Responsibilities:

• Involved in Requirement gathering, Designing, and Development of Factory (Distribution) database.
• Involved in Acquisition of data from various data sources to Staging database and integration.
• Involved in designing, development and deploying of all objects related to Cube using SSAS.
• Designed and developed SSRS Reports using SSAS cube as source.
• Responsible for the developing of Stored Procedures, SQL Jobs.
• Improving performance of SQL queries using indexes, Table partitioning etc.
• Involved in Performance tuning of CUBE processing and MDX Queries.
• Created SSIS packages to transfer data between OLTP and OLAP databases
• Co-coordinating wif all the dependent application teams during the implementation window.

Confidential

BI Developer

Responsibilities:

• Involved in requirement gathering, designing, and development of database.
• Migration of historical data into the database using SSIS.
• Responsible for the designing of SQL queries, Stored Procedures and Scripts.
• Designing and developing of business reports using SSRS.

Confidential

Developer

Responsibilities:

• Involved in requirement gathering, designing, and development of data warehouse environment.
• Responsible for designing of Dimensions, Measure groups, KPIs, Partitions.
• Involved in writing MDX queries.
• Responsible for the designing of SQL queries, Stored Procedures and Scripts. Performed major aspects of database administration, including data modeling, backups restore, Log shipping
• Providing consultation on SQL Server to our development teams.
• Developed mappings dat incorporated logic needed to handle inserts and updates to the existing targets.
• Did Macro programming for excel in reports
• Composed of test strategies (which support/enhance the development methodology), test cases and test results
• Updating cubes like dimension hierarchies and loading the latest data in fact tables and optimizing the performance cubes.

Confidential

Developer

Responsibilities:

• Responsible for creating relational database model.
• Responsible for the developing of Complex SQL queries and Stored Procedures.
• Involved in performance tuning of SQL Queries.
• Worked on windows server 2003 R2 for configuring IIS and deployed various applications.

Confidential

Developer

Responsibilities:

• Understanding Requirements of Administrative module in the project.
• Designing & creating relational database objects.
• Responsible for the designing of SQL queries and Stored Procedures.
• Supporting application programmers in the testing of database applications.
• Designing of HTML forms.
• Deploying and maintaining the application.
• Customization of the application for the use of various departments like Finance, MIS, Communications, HR.

Confidential

Developer

Responsibilities:

• Involved in Enhancements and Maintenance of the project, Database.
• Involved in writing client side validations using JavaScript.
• Used ADO.Net to access the data from database application.
• Involved in Writing SQL queries and Stored Procedures.
• Integrated the third party tool for generating dynamic PDF reports.
• me was Involved in the development of Financial Mission module.