SUMMARY:

• 10+ yearsof professional experience in various sectors like Asset management, Private Equity, Banking, Retail and Logistics.
• Extensive experience in developing and implementing projects using Microsoft Business intelligence 2012/2014/2016 (Microsoft SQL Server Integration Services (SSIS), SQL server Analysis Services(SSAS), SQL Server Reporting Services (SSRS),Power view, Power BI Desktop/Service, Power pivot, Power Query, Power Map and Performance point dashboard(PPS) designer 2008/2012), MDX, DAX, Tableau and Business Objects universe.
• 6+ years of experience in database administration tasks on Microsoft SQL Servers 2012/2014/2016 including Troubleshoots long running queries, monitor SQL server instances, Installation and configuration multiple instances (SSAS and SQL server),backup and recovery, Access management and defining security standards and code deployment activates etc..
• Have 4 + years of experience on creating Power BI dashboards using Power BI Desktop and Power Query.
• Have 4 + years of experience on creating dashboard Reports using Tableau Desktop and Tableau Server.
• Hands of experience on creating both multidimensional and tabular model analysis services cubes with complex DAX and MDX queries.
• 1 + Years of Experience in design, develop maps using Informatica Power Center and power designer 9.6
• Individual contribution on delivering around 25 E2E short term MS - BI stack projects(less than 6 months) .And also worked as a lead developer and onsite co-ordinator with a team of 10 people in offshore for around 4 E2E long term BI stack projects (greater than 1 year).
• Hands of experience on deploying and scheduling reports in SharePoint 2013 and access management.
• Helped and trained business users to explore analysis services cube data using self servicing BI tools like power view, power pivot, Power BI and excel.
• Had great experience on working on Agile and water fall methodology.
• Involved in requirements gathering, analysis,design, development, testing, implementation and maintenance ofprojects created by using SQL Server Business Intelligence tools 2005/2008/2012, BO Crystal Report XI, Jasper i reports, ASP.NET, Silver light and C#.Net.
• Experience in designing/developing/supporting a Business Objects universe and BO framework.
• Very good T-SQL programming skills and experience in writing complex stored procedures, triggers, views, cursors, stored procedures, functions, CTE and User Defined Functions (UDF’s).
• Have strong experience in other BI tool Power BI Desktop, Crystal reports 8/9/10/XI, Business Objects Enterprise XI,, info view/CMC management, Jasper I Reports, MS-Access Reports and Cognos 7.4 Impromptu Reporting Tool.
• Hands of experience on creating complex ETL logic using SSIS, Data modelling and design OLAP cubes using SSAS (Multidimensional, Tabular and power pivot) and created complex dashboards reports using SSRS for private equity, finance, derivative control, sales and risk teams. Extensive business knowledge on third-party investment applications like CRM, Apex, Equitrak, OTC Tools and Charles River IMS v8 and v9.
• Hands of experience on migrating reports from BO, Crystal and SAS to SSRS reports.
• Created and supported Invoice reports for finance using Jasper I Reports and integrated in Revport.

TECHNICAL SKILLS:

Operating Systems: Windows XP, Vista, Windows 7, Windows XP, Windows Server 2003/2008

Tools: Visual Studio 2005/2008, MS Visio, MS Office, VSS, MS-SharePoint 2010/2013, In-house Project control, CVS, Microsoft TFS 2013, BI Analytics

Languages: T-SQL, .Net (3.5), ASP.NET, C#.NET, VB.NET, Silverlight, DAX, MDX

Databases: MS SQL Server 2005/2008/2012 Oracle 10g/11i,MS-Access,DB2,TeraData

BI Tools: SQL Server Management Studio(SSMS),BIDS, SSIS, SSRS, SSAS, Crystal Reports XI, Business Objects, Jasper i reports, MS-Access Reports, Power view, Power BI, Power pivot, Power Query, Power Map, Performance Point designer, Tableau, SAS.

PROFESSIONAL EXPERIENCE:

Confidential - GA

Architect

Responsibilities:

Confidential is a leading Insurance company. Reporting team provides end to end reporting and analysis services to business users across Confidential . As a team, we work and handle end to end projects like gathering requirements, analysis, design, development, testing, implementation and production support for all the ETL packages, reports and cubes build projects. BI stack is strategic tools used to deliver COB, Weekly and Monthly reports. Apart from Confidential COB and on demand reports, we help and train end users on exploring analysis services cube data using self-service BI tools like power view, power pivot and excel. Design SAP

BW Info Cubes (Basic Cubes, Multi-cubes, Remote cubes, and Aggregates), BW ODS Objects, BW Data marts, Logical Models, BW Process Models, BW Enterprise Models.

Environment: SQL Server 2012/2014/2016, SSIS, SSAS, SSRS, T-SQL, MDX, DAX, Power BI Analytics, Tableau, Informatica 9.2,SAS, Crystal Reports 10/XI, Jasper i reports, Windows XP/7, Windows Server 2008, MS Excel, Visual Studio Team Foundation Server, MS-Visio, Power view, Power BI, Power pivot, Performance Point designer, Oracle 10g.

Confidential - Boston, USA

Tech Lead

Responsibilities:

Confidential Life Investments is a leading asset manager with an expanding global reach and has investment capabilities across the range of asset classes Including equities, bonds, real estate, private equity and absolute return strategies .Business Technology is part of SLI which will provide end to end reporting and analysis services to business users across SLI. As a team we work and handle end to end projects like gathering requirements, analysis, design, development, testing, implementation and production support for all the ETL packages, reports and cubes build projects. Crystal report XI, SAS and BI stack are strategic tools used to deliver CRM reports, financial reports, CRIMS investment and money market reports, OTC derivatives COB reports, contact and valuation reports for Real Estate and Jasper Invoice reports for finance. Apart from Confidential COB and on demand reports, we help and train end users on exploring analysis services cube data using self service BI tools like power view, power pivot and excel. Design SAP

BW Info Cubes (Basic Cubes, Multi-cubes, Remote cubes, and Aggregates), BW ODS Objects, BW Data marts, Logical Models, BW Process Models, BW Enterprise Models.

Environment: SQL Server 2012/2014/2016, SSIS, SSAS, SSRS, T-SQL, MDX,DAX, Tableau, Power BI Analytics Informatica 9.2, SAS, Crystal Reports 10/XI, Jasper i reports, Windows XP/7, Windows Server 2008, MS Excel, Visual Studio Team Foundation Server, MS-Visio, Power view, Power BI, Power pivot, Performance Point designer, Oracle 10g,SAP BW, Teradata.

Confidential

MS BI / Crystal Report Analyst Programmer

Responsibilities:

Confidential is the licenseduniversal serviceprovider ofmailservice for the Bailiwick ofJersey. Confidential offers freeship2me,webmail, POP3mail services called Jersey Mail, New premium service (FedEx Express) which Confidential calls J-express andtelephone servicecalled Me:Mo. SQL Server integration services used to integrate data and SSRS, Crystal XI, Cognos used as reporting tools to developed CRM reports, Financial reports and HR reports.

Environment: SQL Server 2008, SSIS, SSAS, SSRS, T-SQL, Crystal Reports 10/XI, Windows XP, Windows Server 2008, MS Excel, Visual Studio Team Foundation Server, MS-Visio, Oracle 10g, MS Access 2007, Oracle 9i

Confidential

MS BI / Crystal Report Analyst Programmer

Responsibilities:

Confidential makes optoelectronic components used to assemble fiber-optic data and voice communications networks. These laser diode modules, transmitter/receiver devices, and transceivers are incorporated by other equipment makers into larger multiplexing and digital cross-connect systems used in data communications and telecommunications .The scope of the project is to provide a designed Integrated System (Database) which would enable identification, valuation and targeting of customers. It closely works with each association customer to gain a deep understanding of their organization to develop a solution that best suited their specific needs. The project mainly dealt with creating SSIS packages, building cubes on the OLAP systems, generate reports by extracting data from the cube and checking the performance tuning of stored procedures, troubleshooting and maintenance.

Environment: SQL Server 2008, SSIS, SSRS, SSAS, T-SQL, Crystal Reports 10/XI, Windows XP, Windows Server 2008, MS Excel, Visual Studio Team Foundation Server, MS-Visio, Oracle 9i.

Confidential

MS BI / .Net Developer

Responsibilities:

Touch point allows communicators to message via email, text, Voice Broadcast, Social media sites, this application is an OLTP systemwhich stores the customer information regarding members and their payments and policies. The warehouse was running on SQL Server 2005 with a web based Dot Net front-end.

Environment: SQL Server 2005, SSIS, SSRS, Silverlight, C#.Net, VB.Net, T-SQL, HTML, VSS and Windows2003