SUMMARY:

• Technology professional seeking challenging career opportunity in the field of Information Technology, focusing on Microsoft Business Intelligence solutions and allowing for professional skill development and growth.

TECHNICAL SKILLS:

Databases: SQL Server 7, 2000, 2005, 2008 & 2012 - SSIS, SSAS, SSRS, Teradata,Sybase,Oracle

Operating Systems: MS Dos, Windows 95/98/2000/NT/XP/Vista/windows 7, Windows Server 2000/2003/2008/2012, UNIX

Programming: T-SQL, Html, MDX, VB.Net, C#

Software Applications: Visual Studio 2003/2005/2010/2013, SQL Server Reporting Services 2000/ 2005/2008/2012, SSIS, SSAS, MOSS 2007, Business Scorecard Manager 2005, Performance Point 2007, Zap Analytics, Microsoft Office 2000/2003/2007, Cizer.Net Reporting, Hyperion, Remedy, Business Objects - Voyager, Crystal Reporting,Tableau,Dundas

Relevant Skills: Database Management, Software Testing, Project Management

PROFESSIONAL EXPERIENCE:

Confidential, TX

Senior BI Developer

Responsibilities:

• Worked with Type 1 and 2 dimensions, Fact Tables, Star Schema design, Operational Data Store (ODS), leveling and other Data Warehouse concepts.
• Worked on all phases of data warehouse development lifecycle, from gathering requirements to testing, implementation, and support
• Created DataMart’s for multiple businesses to facilitate decision making processes
• Worked on reporting and Visualizations tools like SSRS,Tableau, and Dundas Dashboards
• Worked with developers, DBAs, and Production Support Teams in elevating and automating successful code to production.
• Developed ETL solutions with SSIS and Scheduled Jobs in Autosys by Jill Script
• Provide on - call support to production system to resolve any issues.

Confidential, DC

Microsoft BI Developer

Responsibilities:

• Developed interfaces using SSIS between PeopleSoft FMS and existing Application like Grant Processing, Human Resources and Time & Expenses
• Demonstrated experience across ETL Data warehouse design and development. Experience in a corporate environment with multiple source systems. Played lead role on ETL project implementing Type 1 Slowly changing dimensions utilizing SQL Server 2005/2008/2012 Integration Services in a 32 and 64 bit environments involving millions of records.
• SSAS Analysis Services 2005/2008/2012 cube development and optimization. Practical experience developing SSAS Cubes - Dimensions, Facts and data source view.
• Hands on experience with Microsoft BI tools and report development, including SSAS, SSIS and SSRS/Dundas Analytical Dashboards with SSAS as a backend

Confidential, AZ

Business Intelligence Specialist

Responsibilities:

• Played a lead role in the evaluation and selection of a new business intelligence tools, components and BI platform architectures. Solid experience with Microsoft BI tools and reporting, including SSRS, SSAS, SSIS
• Worked on an ETL project using SQL Server 2008 Integration Services in a 64 bit environment involving millions of records.
• SSAS Analysis Services 2005/2008 cube development and optimization. Practical experience developing SSAS Cubes - Dimensions, Facts and data source view.
• Dashboard development utilizing PPS Performance Point Server 2007
• Practical experience and knowledge about Kimball Data Warehousing concepts.

Confidential, WI

BI/SQL Developer

Responsibilities:

• Worked extensively with SQL Server Reporting Services 2005 to develop and deploy reports.
• Responsible for conversion of Crystal Reports to SQL Server 2005 Reporting Services.
• Worked with SQL Server 2005 Analysis Services to create OLAP Cubes as a backend Data Source for SSRS and Excel
• Worked with SQL Server 2005 Integration Services to create packages for various clients.
• Worked with Microsoft Office SharePoint Server 2007 as a front end for SQL Server Reporting Services.
• Created dashboards and scorecards for clients to track KPIs

Confidential

SQL Developer/ Reporting expert

Responsibilities:

• Wrote MDX, T-SQL queries for report datasets.
• Worked with Analysis Services, OLAP Cubes and Excel to generate Pivot Tables.
• Assisted client with Migration of the SQL Server 2000 data warehouse schema into Oracle schema.
• Helped with Migration of the SQL Server 2000 Analysis Services cubes into 2005.
• Migration of the SQL Server 2000 Reporting Services reports into 2005.

Confidential

SQL Developer

Responsibilities:

• Logical and Physical design of database for projects on the basis of user requirements using ERWIN.
• Created/reallocated database objects on appropriate File groups to ease maintenance and improve data access performance.
• Coded Stored Procedures, functions and triggers at High level.
• Wrote DTS packages on SQL Server 2000 Environment
• Fine Tuned the SQL queries using hints for maximum efficiency and performance.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Participated in User Acceptance Testing (UAT) for different modules.
• Implementing user Training and providing technical support.
• Prepared proper backup and recovery plans.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
• Merging data into a single server for achieving better control, consistency & security of data.

Confidential

Jr. Developer

Responsibilities:

• Analysis, Design, Development, Testing, Release and Maintenance.
• Applied Database Tuning and Optimization, Normalization in the new database design.
• Proposed SQL Tuning within applications for optimized database access.
• Audit programs in PL/SQL for Data consistency check and validation.
• Wrote Queries, Stored Procedures, functions and triggers.
• Creation of users, roles, schemas, tables, indexes etc.
• Data base Code Optimization using EXPLAIN PLAN
• Interaction with business users of the application to improve the performance of the reports and fixing the data for data integrity issues.
• Support query performance tuning and data analysis validation for the team using EXPLAIN PLAN and ORACLE STATSPACK.