SUMMARY:

• Technical Lead with 9 Years of experience in Data warehousing, Database Design, Development, deployment and Maintenance/Support using Microsoft technologies in Retail, HealthCare and Travel Domains.
• Expertise in ETL tool (SSIS), Analytics (SSAS), and Reporting (SSRS).
• Expertise in database design and development: SQL Server.
• Experience in using Web Technologies like HTML, Java Script.
• Knowledge of XML technologies including XSLT, XSD.
• Expertise in writing complex SQL queries and PL/SQL stored procedures using SQL databases.
• Expertise in performance tuning of SQL queries and stored procedures.
• Good experience in different phases of SDLC mainly requirement definitions, analysis, designing, development, testing, implementation and maintenance of Cubes (MS - OLAP) SQL Server 2005/2008, SQL Server 2005/2008/2012 Integration Services and SQL Server 2005/2008 Reporting services
• Adept at building strong working relationships with coworkers and management.
• Experience in using DTS, VB and C#.
• Hands on experience in using Performance point server (PPS) Sharepoint for reporting purposes.
• Have excellent communication skills, work ethics and the ability to work well in a team or individual environment.
• Knowledge of Big Data Hadoop ( HDFS, Map/Reduce, Hive).

TECHNICAL SKILLS:

Operating System: Windows 7, Windows XP

Version Control: SVN, TFS

Defect Management Tool: JIRA

Technologies: SSAS (SQL Server Analysis Services), SSIS(SQL Server Integration Services), SSRS (SQL Server Reporting Services), C#, ASP.NET, DTS, Performance Point Server 2010

Web Technologies: XML,HTML,CSS,JavaScript

Database Technologies: SQL Server 2005, SQL Server 2008 R2, SQL Server 2012, PL/SQL procedures, T-SQL

BI Tools Versions: SSIS ( 2005, 2008 R2, 2012), SSRS ( 2005, 2008 R2, 2012) SSAS ( 2005, 2008 R2 ), Tableau, ReportPortal, Power BI

PROFESSIONAL EXPERIENCE:

Confidential

BI Developer

Responsibilities:

• Requirements Analysis, Application design.
• Requirements Gathering From Client And Analysis and Estimate the Requirement.
• Provide high level technical solution for various requirements /change requests received from client.
• Involved in creating various reports using SSRS as per business needs.
• Involved in creating dashboards, interactive reports for analytics using Tableau.

Environment: SSIS 2008/2012, SSRS 2008, SSAS 2008, SQL Server 2008/2012, T-SQL, Tableau

Confidential

Technical Lead

Responsibilities:

• Worked as a Technical lead, mentoring and providing technical guidance to other team members.
• Requirements Analysis, Application and Database Design.
• Requirements Gathering From Client And Analysis and Estimate the Requirement.
• Provide high level technical solution for various requirements /change requests received from client.
• Leading a team of 5 members and mentoring them for technical solutions.
• Involved in the creation of ETL solution using SSIS .
• Involved in creating various reports using SSRS as per business needs.
• Used web services in ETL as per business needs.
• Involved in creating dashboards, interactive reports using Tableau.
• Preparing and reviewing all the documents(Impact & Technical Feasibility, SRS, LLD,UTC) .

Environment: SQL SERVER 2008 R2 (SSIS, SSRS),C#, Power BI

Confidential

Lead Engineer

Responsibilities:

• Analyzed and reviewed the business requirement of the client by studying in detail the Functional Specification.
• Also developed SSIS packages transferring significant amount of data from a relational transactional databases to flat file.
• Worked on different modules and reviewed code of other members.
• Involved in the creation of reports in SSRS.
• Preparing all the documents(Impact & Technical Feasibility, SRS, LLD,UTC)

Environment: SQL SERVER 2008 (SSAS, SSRS, SSIS), SharePoint 2010, PPS (Performance Point Server), C#, .NET,Tableau

Confidential

Lead Engineer

Responsibilities:

• Analyzed and reviewed the business requirement of the client by studying in detail the Functional Specification.
• Worked on different modules and reviewed code of other members.
• Involved in designing and creating cubes using SSAS 2008 to be used by customer and also to be used as a backend for reporting purposes.
• Involved in the creation of Project level reports in SSRS and hierarchal reports i.e. L1 to L4 levels in PPS and Tableau.
• Preparing all the documents(Impact & Technical Feasibility, SRS, LLD,UTC)
• Created Stored Procedures for gathering data.
• Involved in creation of SharePoint sites for displaying reports.

Environment: MS - OLAP, SQL SERVER 2005 (SSAS, SSRS), Report Portal

Confidential

Software Engineer

Responsibilities:

• Daily Interaction with QA, UAT teams to resolve the bugs.
• Interacted with client/business people for requirement gathering.
• Worked on different modules and reviewed code of other member.
• Prepared all the documents.
• Involved in creating reports using SSRS and DW as datasource for dashboards.
• Responsible for Coding, System design, testing and implementation.

Environment: C#, SQL SERVER 2005 Analysis Manager

Confidential

Software Engineer

Responsibilities:

• Interacted with client/business people for requirement gathering.
• Worked on different modules and reviewed code of other member.
• Prepared all the documents.
• Responsible for Coding, System design, testing and implementation