PROFESSIONAL SUMMARY:

• I have 20 years of experience IT industry in analysis, design, development and implementation, and maintenance of Big Data/Hadoop, Business Intelligence, Data warehouse, BI Reporting, Web based reporting applications and Client/Server applications using Microsoft BI, Micro Strategy, Informatica, SSIS, SSAS, SSRS, Micro Strategy, Cold Fusion, SQL Server, and Oracle on Windows and Unix operating systems.
• Implemented Data Lake and several Big Data use cases using 16 node on - prim cloudera cluster
• Implemented Kimball’s Multi-Dimensional Methodologies using Microsoft BI Stack.
• Designed, developed, tested Data warehouses/Operational Data Marts Using MS SQL Server and Oracle databases.
• Designed, Developed and tested ETL Packages using DTS, SSIS, and Informatica.
• Designed, Developed, Tuned Multidimensional Cubes using SSAS 2008.
• Developed Data warehouse using Agile, Scrum Development Methodologies
• Created various financial, drill down and cross-tabbed Reports, objects using SSRS, Micro Strategy, and Excel.
• Documented processes and trained users and team members.

TECHNICAL SKILLS:

Big Data Tools: Cloudera, Hbase, Hive, Oozie, Sqoop, Hue, Flume, R, SAS, Azure, AWS

BI/Reporting Tools: Micro Strategy, Microsoft BI, SSAS, SSRS, SharePoint, Excel Pivots, Tableau

ETL Tools: DTS, SSIS, Informatica RDBMS:SQL Server, Oracle, Access, DB2

Data Modeling Tools: Erwin, MS Visio, Embarcadero Data Architect

Languages: C, UML, COBOL, SQL

Operating System: Windows, UNIX and OS2

Web Technologies: Cold fusion, HTML, CSS, XML and XSLT

IDE/Tools: Microsoft Office Tools, Cold Fusion Studio, Crystal Reports, ERWIN, TOAD, Home-site, Rational Rose, Dream weaver, Visual Studio

Version Control: Team Foundation Server, Visual Source Safe, Rational Clear Case, Source Offsite Past/Current

WORK EXPERIENCE:

Confidential, Tempe, AZ

Meter Data Analytics

Responsibilities:

• Developed SSIS packages using “Neudesic Large Structured Data Load Framework” using SQL 2008/2014 server partition switching for parallel processing of huge volumes of data.
• Developed SSAS Cubes using “SSAS framework for OLAP cube partition management and partition processing” for parallel processing of huge volumes of data.
• Developed and Trained users on Meter Reports and SSAS Cubes
• Responsible to plan and coordinate production release during the migration process.
• Documented technical specifications and Data warehouse development process

Environment: Visual Studio 2008/2013, SQL Server 2008/2014, SSIS, SSAS,SSRS, TFS, SharePoint, Windows 2003, MS-Office(Excel, Visio, PowerPoint), Excel Services

Confidential, Phoenix, AZ

Responsibilities:

• Analyzed Confidential Source data and created Data Mappings/Transformation rules for capturing data in Data warehouse database.
• Created and Maintained overnight batch jobs using SQL Server Integration Services (SSIS) to load and process data from Confidential Source Systems.
• Estimated the complexity, duration, and efforts for business requirements
• Coordinated and participated in design and code review sessions.
• Created & maintained data warehouse database tables (Facts and Dimensions), stored procedures, triggers, views.
• Optimized SQL queries, stored procedures and trigger by evaluating the use of indexes on database tables & use of CTE in stored procedures.
• Performance tuned queries and de-normalized database table objects to improve query efficiency & reduce response time.
• Used SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) under SQL Server 2008 environment to make Confidential Analytics Operations and Analysts self-sufficient and thus reducing number of requests for ah-hoc reporting.
• Designed, Developed and deployed Multidimensional OLAP Cubes and implemented Cube dimensional Security for FERPA
• Responsible to plan and coordinate production release during the migration process.
• Documented technical specifications and Data warehouse development process
• Managed and Trained team members and other IT Staff.
• Presented AEDW to technical and non-technical teams ( Confidential Schools, External Researchers, MIS Conference, NCES Staff)

Environment: Visual Studio 2008, SQL Server 2005/2008, SSIS, SSAS,SSRS, TFS, SharePoint, Windows 2003, MS-Office 2007(Excel, Visio, PowerPoint), Excel Services

Confidential, Santa Ana, CA

Responsibilities:

• Participated Data mart design discussions and collected U.S Geography, Application specific inputs and populated data into data mart. It helped as a model for various on boarding product companies.
• Performed gap Analysis between Source Systems and Data mart.
• Documented Source controlled admin data functions and its data elements.
• Identified and fixed data anomalies by creating data quality and exception reports and as a result improved data quality and they’re by accuracy of reports.
• Participated Legacy reporting environment stabilization tasks with DBA, Project Managers, Vendors, and Customers.
• Analyzed, designed, developed and tested Micro Strategy Objects such as Attributes, metrics, filters, reports, prompts for Reporting applications.
• Developed various project specific documents in Micro Strategy.
• Developed performance stress test reports in Micro Strategy
• Developed Demo data warehouse to trains customers in Micro Strategy.
• Created Data process for on boarding companies to improve data quality.
• Trained team members and customers on self-serviced BI reporting.

Environment: Micro Strategy, Oracle 9i/10g, Informatica, SQL Server 7.0/2000, Cold Fusion, SQL, Windows NT/2000, UNIX