Microsoft Business Intelligence Specialist with over nine years experience in analyzing, designing, tuning, and developing Business Intelligence (BI) database applications using Microsoft SQL Server 2008/2005/2000 Integration(SSIS), Analysis Services(SSAS) and Reporting(SSRS).

Experience in requirements gathering and scoping, developing, testing, debugging, data and report validation. Performed documentation of various segments of Software Development Life Cycle (SDLC) in a complex and changing environment. Worked in a SOX compliant data warehouse environment.

Provided end user training and system support.

Ability to learn and adapt new skills to changing business and technical environment. Worked both as a team player and on an individual level.

Detail-oriented and energetic personality with a strong ability to work in a very fast paced team-oriented environment. Unique combination of personal, analytical, technical and communication skills.

Flexible, enthusiastic and project oriented team player with good communication and leadership skills.

Worked for clients like Pfizer, Sony, Viacom, L’Oreal and AIG.

Technical Skills

Databases

Microsoft SQL Server 2008 R2, DB2, Oracle 11g R2 and MS-Access.

Data warehouse

Microsoft BI solutions: SSAS, SSRS and SSIS versions : 2000, 2005, 2008 (R2).

Presentation Tools

Office SharePoint Designer (OWC), Analysis Services Multi-Dimensional Expressions (MDX), SharePoint PerformancePoint Server (PPS), SharePoint 2010 Excel Services, Power Pivot, Report Builder 3.0, Front Page, SQL Server Reporting Services (SSRS) and SAP-BI reports.

Packages

Adobe (PDF), Excel and Pivot Table.

Tools:

SQL Server Business Intelligence Development Studio(BIDS), SQL Server Management Studio (SSMS), Visual Studio.Net, Microsoft Team Foundation Server (TFS), Oracle Toad, Query/400 and QMQRY.

Programming

PL/SQL, Store Procedure, Windows BAT, SQL/400, CL/400, RPG/400 and Cobol/400.

Documentation

MS-Office, Excel, Visio, SharePoint, PDOCS and Microsoft Project.

Platforms

Window NT/2000/2003/XP/Vista, Window7 and AS/400.

Work Experience:

Extensive exposure in analysis, design, development, testing, implementing and production support. Working extensively on Microsoft BI solution programming such as SSAS, SSRS and SSIS environment. Developed rich integrated reporting and analytics experience to users to gain access to accurate, up-to-date information for better and more quality decision making. Designed, developed and maintained SQL Server Analysis Services (SSAS) objects such as data source view, cubes, partitions, dimensions, hierarchies, calculated measures and perspectives. Performed cube optimization and best practices to ensure high availability of cube data for dashboard, reports and charts. Ability to deliver comprehensive OLAP data using MS Excel, Microsoft Office SharePoint Server (MOSS), and PerformancePoint Server (PPS). Extensive experience in creating several reports such as drill down reports, parameterized reports, linked reports, sub reports, matrix reports and chart using SQL Server Reporting Services(SSRS) using SQL scripts and MDX. Experienced in querying SQL, handling exceptionally large relational databases, query optimization and end user reporting.

Experience in scheduling, creating subscription, setting up parameters and managing security of reports and folders via the Reporting Services Report Manger.

Maintained a presentation layer integrated web site that enables clients to share all our BI contents for user to access Reporting Services report, SharePoint Designer (SSAS) reports, Excel reports on SharePoint Server and PerformancePoint Server Reports (PPS).

Extensive data validation using sql, excel and test scripts. Performed validation during data migration, system migration and system upgrades and scope enhancements.

Created tables, views, store procedures. Preformed ETL development using SSIS packages to enable data load, data transformation, manage and monitor jobs across cross platforms. Scheduled batch jobs using SQL Server Agent in SSMS.

Education : Master’s Degree in Commerce and Accounting.

Contact: abp99r@r.postjobfree.com

Phone: 732-***-**** 732-***-****

PROJECT DETAILS

Employee: CSC Apr 2007 to Date

Client: Pfizer, NJ (consultant)

Role: BI Lead Developer/Architect

Project: Indirect Sales, Rebates, EML & AML, Orders, WMS and Direct Sales reporting.

As part of a 25 member data warehouse team involved in the design, development, coding, testing and implementation of business intelligence system. There are 700 users using over 32 cubes and over 500 SSRS reports.

Responsibilities:Team Leader for the Pfizer Injectable business users to ensure data accuracy and availability. Successfully implemented other projects: European Market Logistic and American Market Logistics, US and Canadian Market Logistic, WMS, Cycle Time and Controlled Substance projects. Actively involved in project analysis, design, development, migration, testing, implementing and production support.Involved dimension modeling, creating and modifying OLAP cubes (SSAS), web-reports and deploying reports using .net environment. Performance tuning and dimensions design and scaling to large numbers of users in SQL Server Analysis Services (SSAS). Created web reports in SharePoint Designer, Excel, Performance Point and SharePoint against SSAS objects. Used SQL and MDX to create SSRS reports. Created a few SAP-BI reports. Used SSIS packages to process cube, load and validate data across environments. Actively participated in SOX audit activities. Reviewed and documented systems and program flow.

Environment:

SQL Server Analysis Services, SQL Server Reporting Services, Microsoft Management Studio 2008 R2 (BIDS), Microsoft TFS, SharePoint Designer, Front Page, Excel, Performance Point and SAP-BI.

Back-end: SQL Server 2008 R2, Oracle (Linux) 11g R2, IBM Data-stage 8, SQL Integration Services, ODBC, AS/400 and MS-Access.

Employee: Itopia Inc. Green Brook, NJ

Client: Sony Music, NYC (consultant) Mar 2006 to Apr 2007

Role: Order Management, Warehouse and Sales reporting.

As part of a 25-member data warehouse team involved in the development, coding, testing and implementation of web-based reports for Orders and Sales Systems.

Environment:

SSIS, SSAS, SSRS, Oracle, ODBC, JD Edwards, RPG IV (LE), CL/400, Embedded SQL Programs, WrkQry, QMQRY and Client Access. SSAS.

Employee: Softek Information Services, Inc. Bedminster, NJ 07921 (Jul 1999 - Mar 2006)

Client: Pfizer, NJ Mar 2003 to Mar 2006

Role: BI Analyst and Developer

Project: EDI, Orders, Inventory and WMS reporting.

As part of a 12-member data warehouse team involved in the design, development, coding, testing and implementation of web-based reports for EDI, Orders, Inventory and Supply Chain Management Systems.

Responsibilities:Team Leader for the EDI projects to ensure load and presentation of data to WPO user group. Created extract programs (RPG400, SP and QM Queries) and ETL (DTS and DataStage). Created tables, views and store procedures to move data between systems. Performed Optimization on cube, sql, and database maintenance.Automated job flows between AS/400, Sequel Server and Oracle systems. Involved in creating and modifying OLAP cubes, web-reports and deploying reports.Created web reports using Reporting Services (XML) and FrontPage(OLAP). Used MDX to create reports from cube. Responsible for the web-reports security.

Environment:

SSIS and SQL Server Enterprise Manager (ETL Jobs), Oracle(Unix), PL/SQL, DataStage, ODBC, AS/400, OS/400, RPG IV (LE), CL/400, Embedded SQL Programs, WrkQry, QMQRY and Client Access. Analysis Manager, Data Analyzer, Front Page and Share point Portal.

Client: Viacom, New York Mar 2002 to Feb 2003

Role: Senior Programmer Analyst.

Project: Traffic Replacement Project.

Viacom has over 15 TV channels like MTV, VH1, CMT, etc.

Was responsible for development, testing and implementing programs for the Order Maintenance and Sales Planning Department, Invoicing, besides conversions programs written to migrate and maintain data for both systems.

Environment: AS/400, OS/400, RPG IV (LE), CL/400, Embedded SQL Programs, DDS, QMQRY, DDS, DDM, FTP, DBU, DFU, Client Access, Oracle(Unix) and SQL Server Enterprise Manager (ETL Jobs).

Client: L’Oreal, NJ Nov 2000 – Feb 2002

Role: Senior Programmer Analyst

Project: Sales Reporting, EDI and Order Entry System

L’Oreal is a leading Cosmetics/Designer Fragrance manufacturing company having its offices and manufacturing and distribution facilities around the world.

Was part of a 14-member team in the development, analysis, coding, testing and implementation of Sales Reporting, Invoicing, AP, EDI Reporting and Order Entry for both interactive and back-end processing systems.

Environment: AS/400, OS/400, ILE RPG IV, ILE, RPG-III, EDI, CL/400, Open Query, SQL/400, UDB, Embedded SQL, DDS, Robert Report Writer, DDM, PDM, DBU, DFU and SDM Implementer.

Client: AIG, NJ Jul 1999 – Nov 2000

Role: WINS Programmer Analyst

Project: New York State DMV Insurance Information and Enforcement System (IIES)

Working as part of a 10-member team to code the entire on-line system in Cobol/400.Integrated the module with the WINS system and also coded program for extracting data from the Wins system.

Environment: Cobol /400, EDI, CL/400, SQL/400, Embedded SQL, DB2/400, SDA using Subfiles, RLU, FTP, PDM, DFU, Client Access and DDM.

All Bank Finance Ltd, Bombay, India Sep 1991 to Jun 1999

Role: Project Executive.

AllBank is a wholly owned subsidiary of Allahabad Bank. Was a full time employee at All Bank and was responsible for development and maintenance of various financial applications and have handled many in-house projects for the following departments:

Lease and Hire Purchase, Inter Corporate Deposit Department, Merchant Banking Department, and Accounts Department.

Environment: FoxBASE, AS/400, Windows and Dos environments. SQL, RPG/400, Cobol/400, OS/400, CL/400, Open Query and DB2/400.

Contact this candidate