SUMMARY:

• Have 8 years of experience in Datawarehousing and Microsoft Business Intelligence (MSBI) Technology along with SQL Server 2005/2008/2008 R2/2012. His expertise lies in SSRS & Report Builder (Reporting), DTS/SSIS (ETL), SSAS (OLAP), Cube Development, Datamart designing, MDX, TSql & Sql Server 2000/ / 2008 R2 / 2012. He has good experience in working with Team Foundation Server (TFS) for source code management, reporting, requirements management, project management, testing and release management capabilities.
• He has strong experience in domains like BFS, Confidential, Healthcare, Confidential . He has worked on projects for clients such as Confidential, Confidential, Confidential (A Confidential ), Confidential, Confidential, Confidential Inc., Confidential Inc., Confidential, Confidential, Confidential & Confidential .
• Currently working as a MSBI Tech Lead/Analyst. main area of expertise has been in Application & Development with skills of SSRS, DTS/SSIS, SSAS, SQL Server 2000/ 2005/2008/2008 R2/2012, Report Builder and Report Model.
• 8 years of experience in Microsoft Business Intelligence Domain and SQL Server 2000/ 2005/2008/2008 R2/2012
• Good experience in Team Foundation Server (TFS) for source code management, reporting, requirements management, project management, testing and release management capabilities
• Good experience with SQL Server 2000/ 2005/2008/2008 R2/2012, SSRS (SQL Server Reporting Services), DTS/SSIS (SQL Server Integration Services) and SSAS (SQL Server Analysis Services) and writing MDX queries.
• Expert level skills on T - SQL and query optimization, developing Reports using SSRS, developing Extraction, Transformation and Loading (ETL) strategies using SSIS, Database designing using SQL Server 2000/ 2005/2008/2008 R2/2012 and Datamart Development.
• Good experience and understanding of database design, relational integrity constraints, OLAP, OLTP, Datamart Development, Cubes
• Expertise in writing and debugging Stored Procedures and Functions.
• Strong experience in building and designing Reports in SQL Server database.
• Supported team in resolving SQL Reporting services and ETL related issues.
• Excellent communication skills bridging Client Interaction and Team Management.
• Strong analytical, problem troubleshooting/solving skills, self-starter.
• Expert in providing in Microsoft BI tools.
• Exposure to Proposal/Estimation Discussions and data model.
• As part of assignments, has been involved in most SDLC phases of project Requirement gathering, design, code development /enhancement and User acceptance testing.
• He has also been a Tech Lead/Team lead for around 3 yrs.

TECHNICAL SKILLS:

Business Intelligence: MSBI, SSIS, SSAS, SSRS, Report Builder, BIDS, Reports, OLAP Cubes, MDX, ETL, Datamart

Operating Systems: Windows XP

DBMS: SQL Server 2005/2008/2008 R2/2012

Version Control System: Team Foundation Server (TFS), MS Visual Source Safe (VSS)

Framework Experience: Microsoft .NET (Basic)

Web Technology: HTML, XML, JScript, VBScript, ASP.NET (Basic)

Web Application: SharePoint (Basic)

PROFESSIONAL EXPERIENCE:

Confidential, Long Beach, CA

BI Tech Lead/Analyst

Responsibilities:

• His role basically involves as a Tech lead along with Application development.
• He defines, plans, schedules, monitors, set milestones and coordinates the activities of the team, and reviews their deliverables.
• He works directly with functional analysts and business users in understanding the information needs of the business and developing new data warehouse/BI functionalities or tools to meet these requirements.
• Works closely with Business Analysts and performs all the needed Requirement Gathering / Design / Develop / Enhance / Unit Test / Implementation for the Project.
• He presents Confidential EIM team on the daily leadership stand up meeting.
• He prepares performance Dashboard using SSRS, SQL and Excel and gives PPT presentation near client for this on a daily basis.
• He develops Scorecard report, Drill down Report, Drill through Report, Sub Report, Linked Reports and Parameterized Reports using SSRS and Report Builder for Finance, Loans, Risk, Compliance and Marketing Department.
• He creates and manages Reports subscriptions and schedules SSRS reports.
• He schedules reports for Replication check notification to business users using SSRS and subscription
• He manages Report Manager, uploads and deploys SSRS Reports rdls, Data sets, Data Sources, Report Model into Report Manager. He also manages roles & Permissions to be assigned to the users and works on Security for the SSRS Reports.
• He works with SSRS Report Migration from Pay Day One to RISE Product for Confidential .
• He works with ETL and Jobs Migration from Legacy environment to ODS Environment
• He develops SSIS, SSRS / T-SQL Code and schedules jobs for Jobs Monitoring Automation.
• He develops and deploys SSIS packages, configuration files, and schedules job to run the packages to generate data in CSV files for compliance department.
• He works with SSAS cube based reports, SSIS packages and job to process OLAP cube and uses his analysis services capabilities to maintain and support SSAS cube.
• Troubleshooting reports issues, ETL job failures, optimizing query performances.
• He performs code reviews, analyses the Requirements and Suggest suitable improvements
• He involves in Testing & Performance Tuning of written code
• He prepares Technical Documentation
• He coordinates with team members from different departments.

Environment: Business Intelligence: SSRS, Report Builder, SSIS, SSAS,DBMS: SQL Server 2008 R2 / 2012, Report Builder, Version Control System: Team Foundation Server (TFS)

Confidential

BI Tech Lead

Responsibilities:

• His role basically involves team lead and application development. works closely with Functional Analysts for requirement gathering, designing the database and creatingworkflow.
• He is involved in Proposal/Estimation Discussions and data model.
• He plays a major role in client interaction and team management.
• He writes scripts for pulling data from SQL Server db and XML.
• SQL Server 2005 to develop the datamart.
• He designs and implements the ETL processes
• He creates Cube-Based Reports through SSRS and Report Builder 3.0.
• He uses Analysis Services Capabilities to build Cubes.
• He troubleshoots reports issues, ETL job failures, optimizing query performances.
• He coordinates with team members from different departments.
• He ensures deliverables meet Quality standards.

Environment: Business Intelligence: SSRS, Report Builder, SSIS, SSAS,DBMS: SQL Server 2008 R2,Report Builder Version Control System: Team Foundation Server (TFS)

Confidential

BI Module Lead

Responsibilities:

• Design the technical documentation for the Rental Revision Reports
• Research, define and deploy BI improvement opportunities and streamline the business intelligence processes
• Create detail design, work on development and perform code reviews.
• Writing scripts for pulling data from SQL Server db.
• Using SQL Server 2008 to develop the Reports in SSRS.
• Using Analysis Services Capabilities to build Cubes.
• Troubleshooting reports issues, optimizing query performances.
• Coordinating with team members.
• Ensures deliverables meet Quality standards
• Troubleshoot and help resolve user issues.

Environment: Server: Reporting Services, Integration Services, Analysis Services.,Operating System - Windows Server 2003DBMS: SQL Server 2008 R2,Report Builder, Version Control System: Team Foundation Server (TFS)

Confidential

Module Lead

Responsibilities:

• Defines, plans, schedules, monitors, and coordinates the activities of the team, and reviews their deliverables.
• Develops various functional components of the data mart applications including extract programs on source systems, ETL applications, and data cleansing functions
• Work directly with functional analysts and business users in understanding the information needs of the business and developing new data warehouse/BI functionalities or tools to meet these requirements.
• Research, define and deploy BI improvement opportunities and streamline the business intelligence processes
• Create detail design, work on development and perform code reviews.
• Writing scripts for pulling data from SQL Server db.
• Using SQL Server 2008 to develop the datamart.
• Designing and Implementing the ETL processes
• Creation of AIMS Reports, Cube-Based Reports, Report Models, Reports using Report builder.
• Using Analysis Services Capabilities to build Cubes.
• Troubleshooting reports issues, ETL job failures, optimizing query performances.
• Coordinating with team members from different departments.
• Ensures deliverables meet Quality standards and create subscriptions.
• Troubleshoot and help resolve user issues.

Environment: Server: Reporting Services (SSRS), Integration Services (SSIS), Analysis Services (SSAS).,Operating System - Windows Server 2003,DBMS: SQL Server 2008 R2,Report Builder - Report Builder 3.0,Version Control System: Team Foundation Server (TFS)

Confidential

Module Lead

Responsibilities:

• Work directly with functional analysts and business users in understanding the information needs of the business and developing new data warehouse/BI functionalities or tools to meet these requirements.
• Research, define and deploy BI improvement opportunities and streamline the business intelligence processes
• Create detail design, work on development and perform code reviews.
• Writing scripts for pulling data from SQL Server db.
• Using SQL Server 2005 to develop the datamart.
• Designing and Implementing the ETL processes
• Creation of ASA Reports, Standard Reports, Cube-Based Reports, Report Models, Reports using Report builder.
• Using Analysis Services Capabilities to build Cubes.
• Troubleshooting reports issues, ETL job failures, optimizing query performances.
• Coordinating with team members from different departments.
• Ensures deliverables meet Quality standards and create subscriptions.
• Troubleshoot and help resolve user issues.

Environment: Server: Reporting Services, Integration Services, Analysis Services. Windows Server 2003,DBMS: SQL Server 2008, Excel.,Report Builder - Report Builder 3.0,Version Control System: Team Foundation Server (TFS)

Confidential

Senior Developer

Responsibilities:

• Work closely with onsite Business Analysts for requirement gathering, designing the database and creating workflow.
• Develop technical architecture based on detailed requirements
• Writing scripts for pulling data from SQL Server db.
• Using SQL Server 2005 to develop the datamart.
• Creation of Safety Scorecard Report, Confidential Standard reports, Report Models.
• Troubleshooting reports issues, optimizing query performances.
• Coordinating with team members from different departments.
• Ensures deliverables meet Quality standards.
• Validate the technical feasibility of business requirements
• Infrastructure, architecture and environment evaluation
• Interfaces with Business users and Technical managers to clarify requirements, review design, test cases, and deployment
• Devising the Report delivery mechanisms and creating subscriptions
• Ensures deliverables meet Quality standards

Environment: Server: Reporting Services, Integration Services, Analysis Services.Windows Server 2003 DBMS: SQL Server 2008, Excel.Report Builder, Version Control System: Team Foundation Server (TFS)

Confidential

Senior Developer

Responsibilities:

• Work closely with onsite Business Analysts for requirement gathering, designing the database and creating workflow.
• Work on enforcing proper integrity constraints and maintaining relationships among the different objects.
• Writing scripts for pulling data from SQL Server db.
• Using SQL Server 2005 to develop the datamart.
• Designing and Implementing the ETL processes
• Creation of Confidential Standard Reports, Cube-Based Reports, Report Models.
• Using Analysis Services Capabilities to build Cubes.
• Troubleshooting reports issues, ETL job failures, optimizing query performances.
• Coordinating with onsite team members.
• Ensures deliverables meet Quality standards.
• Troubleshoot and help resolve user issues.

Environment: Server: Reporting Services, Integration Services, Analysis Services.Windows Server 2003,DBMS: SQL Server 2008, Excel.Report Builder, Version Control System: Team Foundation Server (TFS)

Confidential

Senior Developer

Responsibilities:

• Work closely with Business Analysts for requirement gathering, designing the database and creating workflow.
• Writing scripts for pulling data from SQL Server db.
• Using SQL Server 2005 to develop the datamart.
• Designing and Implementing the ETL processes
• Creation of ITT Reports, Cube-Based Reports using SSRS and Report Models.
• Using Analysis Services Capabilities to build Cubes.
• Troubleshooting reports issues, ETL job failures, optimizing query performances.
• Coordinating with onsite team members.
• Ensures deliverables meet Quality standards.

Environment: Server: Reporting Services, Integration Services, Analysis Services, Windows Server 2003DBMS: SQL Server 2005, Excel.Report Builder, Version Control System: Team Foundation Server (TFS)

Confidential

Application Developer

Responsibilities:

• Work closely with Business Analysts for requirement gathering, designing the database and creating workflow.
• Writing scripts for pulling data from SQL Server db.
• Using SQL Server 2005 to develop the datamart.
• Designing and Implementing the ETL processes
• Creation of Scorecard Data Hierarchy report, Excel Back up Drill Down Report, Cube-Based Reports, Report Models.
• Using Analysis Services Capabilities to build Cubes.
• Troubleshooting reports issues, ETL job failures, optimizing query performances.
• Coordinating with onsite team members.
• Ensures deliverables meet Quality standards.
• Troubleshoot and help resolve user issues.

Environment: Server: Reporting Services, Integration Services, Analysis Services.,Operating System - Windows Server 2003,DBMS: SQL Server 2005, Excel.Report Builder, Version Control System: Team Foundation Server (TFS)

Confidential

Project Trainee

Responsibilities:

• Work closely with Functional Analysts for requirement gathering, designing the database and creating workflow.
• Writing scripts for pulling data from SQL Server db.
• Using ASP.Net to build the Forum
• Using SQL Server 2005 to develop the datamart.
• Designing and Implementing the ETL processes
• Creation of Standard Reports, Cube-Based Reports, Report Models.
• Using Analysis Services Capabilities to build Cubes.
• Troubleshooting reports issues, ETL job failures, optimizing query performances.
• Coordinating with team members.
• Ensures deliverables meet Quality standards.

Environment: Server: Reporting Services, Integration Services, Analysis Services.Operating System - Windows Server 2003,DBMS: SQL Server 2005, Excel.Report Builder,Version Control System: Visual Source Safe (VSS),ASP.Net, VB.Net, C#.Net

Confidential

Software Developer

Responsibilities:

• Work closely with Functional Analysts for requirement gathering, designing the database and creating workflow.
• Writing scripts for pulling data from SQL Server db.
• Using SQL Server DB to develop the OLTP system.
• Creation of Standard Reports, and Enterprise Reports.
• Troubleshooting reports issues, job failures, optimizing query performances.
• Writing Stored Procedures, Functions, Triggers and Views.
• Creating normalized and de-normalized system as per the need.
• Coordinating with team members.
• Ensures deliverables meet Quality standards.

Environment: Business Intelligence: Reporting Services,Operating System - Windows Server DBMS: SQL Server, T SQL, Excel.