CAREER OBJECTIVE:

Intend to build a career with leading corporate of inspiring environment with committed & dedicated people, which will help me to explore myself fully and realize my potential. Willing to work as a key player in challenging & creative environment.

PROFESSIONAL SUMMARY:

• 11+ years of experience as MS SQL Developer in administration and development of Database Design and Development in SQL Server 2014/2008R2/2008/2005 system in OLTP and OLAP environment.
• Effective communication and interpersonal skills with the ability to focus on multiple tasks in a high - pressure environment.
• Excellent experience in design, development, configuration and deployment of ETL packages (SSIS), SSRS Reports and SSAS Cube.
• Excellent experience in performance tuning of store procedure, SSIS packages, Reports and Cube.
• Experience in design and development of SSAS cube based report using complex MDX queries.
• Excellent experience in design, development of Report and dashboard using Power Bi tool.
• Created complex power bi report like ranking, trend, forecasting, score card etc
• Excellent experience in translating Business System Design document into technical design document.
• Experience in installation, upgrade and configuration of Microsoft SQL Server and databases.
• In-depth knowledge of T-SQL, Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes.
• Experience in Project deployment, scheduling SSIS packages using SQL Server Agent.
• Experience in Data Extraction, Transforming and Loading (ETL) between Homogenous and Heterogeneous System using SQL tools.
• Have extensive experience in leading team and actively participated in all phase of project activity (SDLC) requirement analysis, designing, coding, deployment, documentation and resource building along with technical presentation.
• Extensive working experience on VB script, C# script, Excel Reporting, Oracle9i, PL/SQL.
• The creativity and flexibility to learn new technologies on the fly, and a track record of proactively detecting and finding solutions to potential problems.

TECHNICAL SKILLS:

DB Technologies: MS-SQL Server 2014/2008R2, SQL Server Integration, Reporting Services (SSIS/SSRS) 2012/2008R2 and Analysis Services (SSAS) 2008R2 Oracle 9i, MS Access.

Programing languages: T- SQL, MDX, C#, VB Script.

Software Tools: SQL Server BI Development Studio (BIDS), Power BI, MS Visual Studio 2014/2008/2005 , Erwin7.2/4.5/4.0, MSVisio2007/2003, Clear Quest, JIRA, SVN,DTS, Visual Source Safe, Team Foundation Server(TFS), Oracle 9i

EMPLOYMENT HISTORY:

Confidential

Operating System: Windows 10

Tools: Azure SQL Database, SQL server 2014 & 2016, Business Intelligence Development Studio 2013, Power BI, JIRA and SVN

Sr.BI developer/Analyst

Responsibilities:

• Extensive data analysis and data profiling.
• Automated the report generation and delivery process for different manufacture using SSIS.
• Implemented robust ETL logging feature with enhanced data validation, notification and exception handling.
• Created complex power BI reports (Ranking reports, Patient satisfaction, regional sales, Forecasting and trend analysis etc.) for different stake holder.
• Used On-Premises Gateway to create different refresh schedule for power BI reports/dashboards.
• Implemented rows level security and enabled secured access of sensitive power BI reports to specific user’s group.
• Created Cascading parameters, Drill down, Drill through, Sub-reports and Charts in SSRS.
• Performed T-SQL tuning and optimization of stored procedures for reports that take longer execution
• Client interfacing, gathering requirements all ETL and report development Process.
• Converted high level business requirements into detailed level by involving in multiple data mapping sessions.
• Involved in all phases of the project starting from analysis, design, development, testing, UAT and Prod release
• Worked on Service-Now Prod incidents for resolving issues with real time SSRS Reports

Confidential

Operating System: Windows 7

Tools: SQL server 2008/2012 and Business Intelligence Development Studio 2008.

Onshore Team Lead (Technical Specialist)

Responsibilities:

• analysis of day today production failure, performance issues and provides appropriate solution to meet their enhance/new business need (Risk department).
• Implementing enhanced data validation, notification features and exception handling to address frequently occurring issue.
• Identification, prioritization, and execution of all data warehousing module/projects including migration of SSAS report to new version of SSAS cube.
• Client interfacing, gathering requirements and Coordinating with offshore Team for executing all new ETL development Process.
• Design, deploy, and maintain of various ETL Jobs, SSRS Reports and SSAS Cubes.
• Build Knowledge Repository for Bayada internal and Confidential support team which involves documentation of key activity i.e. job Manual, Root cause analysis and solution detail for all major production failures, Process document, Technical design document and Test logs.
• Used to do various project management activity i.e. project tracking, setting up the task prioritization, managing the team members, preparing the status reports (Weekly and monthly) for the client.

Confidential

Operating System: Windows 7

Tools: SQL server 2008 and Business Intelligence Development Studio 2008/2005.

Offshore Team Lead and Sr. Developer

Responsibilities:

• Design and Architect the new Enterprise Data Warehouse (EDW), build semantic layer for self-reporting and Dashboards for various business processes.
• Analysis of current production performance issues with the help of DBA of existing system and provide the appropriate solution to meet their enhance/new business need (Risk department).
• Implementing enhanced data validation, logging features and exception handling to address issue effectively.
• Identification, prioritization, and execution of all data warehousing module/projects.
• Client interfacing, gathering requirements and Coordinating with offshore Team for executing all new ETL development Process. to Project team members in designing and coding components on BI Suite and its new features post implementation.
• In addition to that, performed various project management activity i.e. project tracking, setting up the task prioritization, managing the team members, prepare the status reports for the client and hiring activities etc.

Confidential

Senior Software Developer

Responsibilities:

• Core developer and module lead for IT hub i.e. Extremely Complex ETL Packages and jobs using Avanade's Enterprise BI Suite.
• Provided design solution to the BPO application of Confidential client for robust data loading environment from different RDBMS source using Avanade's Enterprise BI Suite.
• Functional testing and bug fixing (i.e. raised by SQE team) Preparation of functional, technical and deployment documents along with execution script.
• Quality Check of ETL package developed using Avanade's Enterprise BI Suite by other resources.
• Prepare status reports, Attend call with Onsite team on daily basis.

Confidential

Software Developer

Responsibilities:

• Involved in the design, development and implementation of ETL layer for robust data processing for Confidential and Confidential BPO system.
• Involves in the migration of docent database system to sum total (SQL 2005). Suggested flexible and robust design approach for efficient and error prone data processing for multiple downstream application i.e. LMS, HR portal.
• Gathered the requirements and scope from the customers for customization of Avanade BI transformation products.
• Involved in design, development and implementation of Data sync up for various front end application.
• Involved in designing of employee feed for expected format of data sync i.e. Sum total tool.

Confidential

Software Developer

Responsibilities:

• Requirement analysis, design, development, implementation and production of this application.
• End to end database design, creation of SSIS packages for data transformation and processing the SDF and TSF data feed for generating access codes for different business partners and members of Microsoft.
• Worked on automating the Reports generation (i.e. Volume and revenue reports) and distribution of various reports to respective recipients as per the schedule configuration.
• Preparation of business, requirement, unit test and deployment document.
• Status reports, Sync up call with Onsite team on daily basis.
• Quality Check of ETL package developed by other resources.

Confidential

SQL BI & Database Developer

Responsibilities:

• Monitoring and loading of parsed output in corresponding production table which was done by parsing script (AWK).
• Development of report (SSRS based), process document & Functional Doc.etc. I was also involved in Bug fixing and enhancement work on similar report.