SUMMARY"

• An accomplished result oriented Microsoft Business Intelligence lead with extensive experience in design, analysis, development, support and providing end to end solutions in the business Intelligence and data warehousing space. Demonstrated success in a cutting edge technology and complex business environment not only as a skilled individual contributor but also as a creative team player, effectively prioritizing multiple tasks and achieving project deadlines exceeding customer expectations.
• Around 7 years of Information Technology experience in Microsoft Technologies with specialization in SQL Server 2005, 2008R2, SSRS(SQL Server Reporting Services), SSIS (SQL Server Integration Services) and SSAS (SQL Server Analysis Services)
• Microsoft Certified IT Professional in SQL Server 2012 Advanced Business Intelligence Platform.
• Microsoft Certified Technology Specialist in Microsoft Windows SharePoint Services 3.0 Web Application Development
• Involved in setting up a data warehouse, huge data migrations and transfers using utilities like SSIS packages, Building of cubes using SSAS and designing reports using SSRS
• Proficient in T - SQL and experience with databases like MS SQL Server 2000, 2005, 2008R2, DB2, Oracle, MySQL.
• Extensive experience in working on Software Integrated Development Environments and analysis tools like Visual Studio 2003, 2005, 2008, SQL Server Management Studio, SQL Query Analyzer, TOAD, Microsoft Team Foundation Server, VSS
• Working knowledge of Microsoft Dynamics Solutions - Microsoft CRM and Microsoft Dynamics AX
• Experience in UI development for Microsoft SharePoint Server 2007 Creating sites, Creating Workflows and using SharePoint designer, Creating External Content types and External lists.
• Hands on Experience in developing applications using Microsoft technologies like ASP.NET, C#, SQL Server
• Well versed and experienced in various Software Development Life Cycles like Waterfall model, Agile.
• Worked as a resourceful team member in cross functional teams involved in full project life cycle development of complex business solutions from requirement gathering, analysis, designing, development, unit testing, peer reviews, SIT support, UAT support, post production support.
• Proficient in customer facing role with proven capabilities of working with business users for requirement elicitation, documentation, mock ups, POCs and advising technical options for the complex business requirements.
• Proven abilities to learn new technologies and business processes quickly and skilled problem solver.
• Domain experience on Banking and Financial Services, Insurance, Gaming, Retail.

TECHNICAL SKILLS:

Technologies: MSBI - SSIS, SSAS, SSRS, ASP.NET, Microsoft SharePoint Server Microsoft Dynamics CRM, Microsoft Dynamics AX, Informatica Power Center

Programming Languages: C#.NET, VB.NET, C, C++

Database: SQL Server 2005/2008/2008 R2, Oracle, DB2, MySQL, MS ACCESS

Development Tools: BIDS, Visual Studio, SSMS, SharePoint Designer, SQL Developer, SQL Trace, SQL Agent, Query analyzer,

Scripting Languages: HTML, XML, JavaScript

Project Management: MS Project, VSS, SVN, PVCS, TFS

Design Tools: MS Visio

Other Technologies: Photoshop 7.0,MS-Office(Word, Excel, Power point, Access), Microsoft Visio, Notepad++

OS: Windows 98/2000/XP/2003, Windows NT/2000/2008 Server

PROFESSIONAL EXPERIENCE:

Client: Confidential - Netherlands

Title: Microsoft Business Intelligence Technical Lead

Responsibilities:

• Gathering business requirements by meeting the business owners/users and converting them into functional requirement specifications, technical design and supporting documents for business systems. Experience in database design process and data modeling process.
• Provided technical leadership in the development and deployment of SSIS Packages for new ETL Processes, building of SSAS Cubes, designing of SSRS Reports in SharePoint server
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and warehouse systems.
• Created ETL mappings using Informatica Power center to extract the data from multiple sources like Flat files, Oracle, Xml, csv, Delimited files transformed based on business requirements and loaded to Data Warehouse
• Well acquainted with Informatica Designer Components - Source Analyzer, Warehouse Designer, Transformation Developer, Mapplet an d Mapping Designer.
• Developed dashboard to cater the needs of CIO, MT and Operational Manager.
• Migrated Several existing applications (Based on Cognos, Informatica, Oracle BI platform) to Microsoft BI Platform
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions in SQL Server 2008
• Created cubes, dimensions, and business critical KPIs using SSAS representing aggregations in different ways - hierarchically and using custom groupings, that the company will use to analyze performance. Created MDX queries according to business requirements. Built cube dimensional security framework for data authorization.
• Creation of SharePoint Sites and implementation of Permission framework across several applications and enabled Real time data loading through use of SharePoint workflows.
• Perform testing and review of the product and report bugs
• Responsibility of allocation of work to the junior employees and mentoring them.
• Provided the product support after Go-Live of each application and bug fixes.
• Successfully implemented projects with aggressive timelines involving multiple vendors.
• Effectively managed client communication, business interaction, onsite co-ordination, requirement gathering, solution analysis, designing and architecture.

Environment/Tools: MSBI (SSIS, SSAS, SSRS), SharePoint Server 2007, SQL Server 2008 R2, Oracle, Informatica Power Center, C#.NET, Visual Studio 2008, 2010, Business Intelligence Development Studio, TFS

Client: Confidential - Las Vegas

Title: Senior Software Engineer

Responsibilities:

• Analyzed the CRM system and designed the requirements for BI development in CRM -Dashboards
• Worked as a Data warehouse developer involved in building a Data Warehouse using SSIS, enhancing the analytical engine by building cubes for predictive modeling.
• Designed and developed numerous reports based on SQL Server Reporting Services
• Involved in Data migration processes
• Involved in the Enhancements of the product and bug fixes.
• Contributed my efforts during the upgrade of the product from CRM 4.0 to CRM 2011
• Performance tuning, code review and ensuring best practices.
• Interaction with the customer.
• Contributed and designed various Application and High Level Logical architecture diagrams as a part of proposal document of the product.
• Performance tuning, code review and ensuring best practices.
• Developed and performed technical product demos for pre-sales process

Environment/Tools: MSBI (SSIS, SSAS, SSRS), CRM 2011, SQL Server, MS Visio

Client: Confidential

Title: Senior Software Engineer

Responsibilities:

• Worked on gathering the requirements by interacting with the business team and documenting them as technical requirements.
• Used ETL capabilities of SSIS to define imports of data from xml extracts into data mart, scheduled packages, defined integration flows, log data error exceptions and also defined database Maintenance Plans and send automated e-mails.
• Developed detail and summary reports, line and pie charts, trend analysis reports and sub-reports according to business requirements using SSRS.
• Developed and optimized database structures, stored procedures, Dynamic Management views, DDL triggers and user-defined functions in SQL Server 2008
• Worked on System Testing and Integration Testing of the product
• Involved in creation/review of functional requirement specifications, technical design and supporting documents for business systems, experience in database design process and data modeling process.
• Worked on unit testing, system integration testing support and user acceptance testing support.
• Worked on developing SSRS reports from Team Foundation Server (TFS) data which was used to keep the track of each sprint under taken during the project execution. The reports highlighted the sprints with tendency of missing the scheduled completion date.
• Created executive dashboards for management level reporting, maintenance of the reports and provide customized reports to the senior management based upon the certain specific business requirements.
• Took the ownership of Estimating the efforts based on the complexity points by creating a CP Estimation template

Environment/Tools: MSBI (SSIS, SSAS, SSRS), SharePoint Server 2007, SQL Server 2008 R2, Visual Studio 2005, BIDS, Team Foundation Server

Client: Confidential, United Kingdom                                 

Title: Senior Software Engineer

Responsibilities:

• Worked on gathering the requirements by interacting with the business team and documenting them as technical requirements.
• Interaction with the customer
• Design and Developments of the Reports using Microsoft Dynamics AX 2009 reporting tools
• Performed unit testing of the BI platform, provided SIT and UAT support.
• Perform support and maintenance activities based upon the tickets received from the business users.

Environment/Tools: SSRS, Microsoft Dynamics AX Reporting

Client: Confidential

Title: Senior Software Engineer

Responsibilities:

• Took the entire responsibility of data migration process of the product
• Enhancing the Analytical Engine by building cubes for predictive modeling
• Involved in the enhancements of the product and bug fixes.
• Contributed in writing stored procedure scripts for Analytical Engine of the product.
• Involved in writing stored procedures, SQL Scripts in SQL SERVER 2008
• Developed and performed technical product demos for pre-sales process

Environment/Tools: MSBI (SSIS, SSAS, SSRS), CRM 4.0, SQL Server 2008R2

Client:  Confidential, New York

Title: Software Engineer

Responsibilities:

• Involved in developing Reports using SSRS technology.
• Developed custom code functions using .Net
• Involved in UDM Development and data transfer from different data sources into data warehouse
• Analyze requirements and prepare initial analysis document.
• Contribute to testing which involves data validation, UI validation, writing test cases.
• Involved in doing enhancements in report development and bug fixes.
• Written MDX & SQL queries for data validation.

Environment/Tools: MSBI (SSIS, SSAS, SSRS), SQL Server 2008, SharePoint Server 2007