SUMMARY:

• Exceptional background in analysis, design, development, customization and implementation of business intelligence solutions.
• Demonstrated expertise utilizing ETL tools, including SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and RDBM systems like SQL Server and Oracle.
• Excellent technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and dimension modeling for OLAP.
• Independent contributor as well as a team player with excellent communication and problem solving skills.  

• SQL Server 7.0, SQL Server 2000, SQL Server 2005, SQL Server 2008 R2,SQL Server 2012 10
• Analysis Services (MDX, Cubes) 3
• T - SQL, Stored Procedures 8
• ETL Tool ( DTS packages, SSIS, BCP) 6
• Business Intelligence (Cognos, Analysis Services, Excel Pivot tables, Proclarity, Power Pivot) 5
• Reporting Tools (Crystal Reports, Brio, Business Objects, Web Focus, SQL Reporting Services) 4
• Oracle SQL, PL/SQL 3
• MS Access 2
• Team Foundation Server, Visual Source Safe, Source Depot 5
• Design Tools (Erwin, Visio) 4
• MS Project 1
• Functional Testing, UAT 2

PROFESSIONAL EXPERIENCE:

Confidential, Redmond WA

Lead Business Intelligence Developer

Responsibilities:

• Designing, developing, and implementing the new features for YAP cube to meet the user requirements.
• Supporting the data warehouse and OLAP cube for the existing system.
• Optimizing the cube processing and performance with proper aggregation and partitions design.
• Compiling the deployment document for every release and work with testing and OPS team during every engineering and cube release.
• Part of the triage team, I would triage the new tasks needed and assigning them to the respective developers in each sprint.
• I was part of the release management, preparing the required deployment document, working with the OPS team during the release ensuring smooth release for each sprint.

Environment: SQL Server2008R2, T-SQL , SSIS, SSAS (OLAP), Excel Pivot, MDX, Power Pivot, VSS, SQL Server2012

Confidential

Redmond WA

Senior Business Intelligence Develope

Responsibilities:

• Performed data profiling and created data snapshots for different data sources to eliminate data discrepancies
• Designing, developing, and implementing data architecture, including overall ETL processes and architecture design for Centralized Data Analysis Platform (AIR Hunting Guide).
• Translating user requirements into data flows and data mapping.
• Designing the data mart (which sourced the data from 20 different data sources) that runs efficiently.
• Developing the stored procedures for Silverlight UI interface tables required for exploded tile and pivot viewer.
• Designing technical project documentation required for the project.
• Delivery of high quality project on time.
• Providing key insights to business critical areas using scorecard metrics in order to prove out the visions and make modifications to FY12 approach.
• Designing and developing BG Tear sheet using Power Pivot and EXCEL.

Environment : SQL Server 2008R2, T-SQL , SQL Reporting Services, SSIS, OLAP, Excel Pivot, Power Pivot, MSRA, Pivot Viewer, Silver light UI

Confidential, Enumclaw, WA

Senior Data Warehouse Developer

Responsibilities:

• Developed, maintained, supported, and enhanced enterprise data warehouse and BI systems.
• Designed conceptual and logical data models for data warehouse applications.
• Created and optimized physical data models, tables, and partitions. Implemented dimensional models, including aggregation and indexing strategies.
• Identified the source data systems and map source system data to data warehouse models.
• Designed, developed, and tested ETL (extraction, transformation, and load) processes.
• Defined and captured metadata and rules associated with the ETL processes.
• Tested and validated data loaded into the data warehouse for accuracy.
• Designed and developed BI semantic layers, views, and query objects for business users.
• Developed reports and report templates.

Environment : SQL Server 2005, SQL Server 2008, T-SQL , SQL Reporting Services, SSIS, OLAP, MS Access, Excel Pivot

Confidential, Redmond, WA

Software Database Engineer II

Responsibilities:

• Designed a working proof of concept (POC) of a Business Intelligence system that pulls cases from a data mart for classification and analysis.
• Gathered requirements from Supportability PM for design of data warehouse and data mart entities.
• Designed and developed SSIS packages, stored procedures, tables, views, and functions.
• Conducted code walkthroughs and review peer code and documentation
• Developed SSIS packages for processing fact and dimension tables.
• Created system for capturing, reporting, and correcting error data. Worked with developers, DBA s, and systems support personnel in elevating and automating successful code to production.
• Produced reports using EXCEL and SQL Reporting Services.

Environment : SQL Server 2005, T-SQL , SQL Reporting Services, SSIS, OLAP

System Analyst III/Developer

Confidential

Responsibilities:

• Part of Partner Business Data Analysis Team, involved in providing services to two groups MSPP and SBC.
• Analyzed the service request assigned by queue manager to find if the request can be pulled from the existing multidimensional cubes.
• Wrote and supported complex T-SQL queries and stored procedures and produced adhoc reports from the database. Created SSIS packages to extract data from external sources into SQL Server.
• Performed complex design analysis, researched alternative approaches to come up with an appropriate implementation methodology. Migrated existing reports to new enhanced reports using SQL Reporting Services.
• Participated in unit testing of the reports before release.

Environment: SQL Server 2005, Stored Procedures, T-SQL , SQL Reporting Services, SSIS, OLAP

Confidential, Redmond, WA

Application Developer

Responsibilities:

• Modified the SRS reports for enhancement requests from the clients and bug fixing.
• Participated in regression and systems integration testing of the HR Relocation Application.

Environment: SQL Server 2005, Stored Procedures, T-SQL , SQL Reporting Services

Application Developer

• Participated in the requirements gathering and preparing the functional spec for the responsible component.
• Designed technical spec and discussed the complete solution and implementation with the team.
• The design involved breaking up the functionality into two pieces, the import and tthe export process.
• The functionality was implemented using SQL Server, Stored Procedure, SSIS, .NET, XML, XSD, BCP and batch files. The import process involved working with XML data and performing ETL, cleansing data and importing the XML data using stored procedures into SQL 2005. The export process involved extracting data from SQL 2005 and generating XML data files for various vendors using BCP.
• Designed and created the underlying tables and stored procedures with error handling.
• Actively participated in the component design, physical and logical design of the DB. Used Erwin.

Environment: SQL Server 2005, Stored Procedures, Transact-SQL, SSIS, OLAP, XML, BCP, Visual Source Safe

Application Developer

• Worked with business users in understanding the requirements and translating into effective reporting solutions.
• Designed the STAR Schema and developed the data mart required for the reporting using SSIS packages and stored procedures. Develop multidimensional OLAP Cube in MS Analysis Manager .
• Developed and deployed Key Performance Indicator reports using Excel Pivot and SQL Reporting Services.
• The reports provided the data and trend to executive management to help them define the business process.
• The source system used was SIR and Change Point.

Environment: SQL Server 2005, Stored Procedures, Transact-SQL, SSIS, OLAP Cube, SQL Reporting Services, Excel Pivot Tables, Common Warehouse Platform (CWP)

SQL Server Developer

• Participated in design and implementation in development of staging database.
• Involved in data extraction from various external data sources (MS Sales, Seibel and MS Organization)
• Worked independently on one module and coordinated with others when it is time to combine the modules.
• Communicated and brainstorm within the group as the project continued with the progress.

Environment: SQL Server, Stored Procedures, Transact-SQL, DTS, ODS (Operational Data Stores)

Confidential, Irving, TX

Lead Marketing Systems Analyst

Responsibilities:

• Gathering user requirements from external customers like Mercedes , Direct Energy and New Century Mortgage (Home123).
• Understanding the requirements and translating into effective reporting solutions.
• Analyzing reporting needs, designing, deploying and automating the reporting packages. Providing insight to Business Intelligence team on accomplishing the reporting and analytic value to client by developing and deploying solutions using multidimensional OLAP Cube in MS Analysis Manager or Cognos .
• Delivering insights gained while analyzing the data, and proactively creating ad hoc solutions for client needs.
• Validating, manipulating, and importing large sets of data from outside sources into MS SQL Server database, and then analyzing and reporting on that data. Use DTS and BCP utilities for the importing/exporting of data.
• Design and maintenance of analytical databases with extensive use of T-SQL and stored procedures .
• Performed extensive Ad-hoc reporting. Working with the DBA team to ensure database performance and integrity . Used Visio for database models.

Environment: SQL Server 2000, T-SQL, Stored Procedures, ETL, DTS packages, BCP, MOLAP Cubes, MDX, Excel Pivot Tables, Windows XP, Visio, Cognos, Crystal Reports

Confidential, Plano, TX

Data Warehouse Developer

Responsibilities:

• Supported business users in understanding the requirements and translating into effective reporting solutions.
• Worked with Confidential consultants and contributed to the architecture, design and implementation of Remedy reporting system, the full life cycle of project.
• Performed in different activities of data assessment, data mapping and ETL definition.
• Designed a data mart solution using Confidential SQL Server 2000 for building the underlying data.
• Coded SQL Server stored procedures, DTS packages that extracted production data from OLTP systems and populated staging area tables and eventually Dimension and Fact tables for the STAR schema required for OLAP cubes. Loaded and extracted data to/from SQL databases.
• Built multidimensional MOLAP cubes from the data in the data mart, wrote MDX queries in Confidential Analysis Services. Produced ad hoc reports from the database.
• Did performance and tuning of slow queries. Database backup and restore. Scheduled and maintained jobs.
• Used Excel Pivot table feature and ProClarity to create demo reports for presentation out of MOLAP cubes.
• Created database model diagrams using Visio.
• Maintained and enhanced existing Business Objects reports.
• Was responsible for the maintenance and enhancements of the Universes for the existing reports.

Environment : SQL Server 2000, T-SQL, Stored Procedures, ETL, DTS packages, MOLAP Cubes, MDX, ProClarity, Excel Pivot Tables, Business Objects, Windows XP, Visio, Oracle

Confidential, Lewisville, TX

Database Analyst & Developer - Systems Integration

Responsibilities:

• Solely responsible in integrating Genuity’s internal order control systems (Magma, Circuit Tracking System, AOL Tracking System, TBS) and developing a framework for generating milestone reports required for Monthly Management Results off of the combined system.
• Brainstormed business requirements with various groups and prepared a detailed project plan and mapped the milestones to business requirements.
• Designed and created a SQL Server database and the underlying tables to capture the integrated data. Migrated the data from other systems including Oracle, Informix, flat files into SQL Server using various stored procedures and DTS packages.
• Used ERWIN in designing the logical and physical data models.
• Created complex views/queries and stored procedures and performed ad-hoc analytic development activities. Analyzed and modified various complex queries by optimization and improved the performance of the reports.
• Used Crystal Reports for report generation.

Environment: SQL Server 2000, T-SQL, Enterprise Manager, Crystal Reports, Visio, Oracle, Telecom Business Solution