SUMMARY:

• Have 8 years of experience in Datawarehousing and Microsoft Business Intelligence ( Confidential ) 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 Confidential, Confidential, Confidential . He has worked on projects for clients such as Confidential, Confidential, Confidential (A Confidential ), Confidential Singapore, Confidential, Confidential Inc., Confidential Inc., Confidential, Confidential, Confidential & Confidential .
• Currently working as a Confidential 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.
• Expert in providing in Microsoft BI tools.
• Exposure to Proposal/Estimation Discussions and data model.

TECHNICAL SKILLS:

Business Intelligence: Confidential, 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 Confidential 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

Business Intelligence - Datamart, Cube and Report 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 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.