SUMMARY

• Highly skilled Business Intelligence professional with 9+ years of demonstrated expertise delivering comprehensive analysis for industry - leading companies and organizations. Consummate Business Intelligence professional with a long track record of leveraging outstanding oversight and leadership attributes to continually enhance business operations and deliver projects that meet or exceed all benchmarks and requirements.
• Expert in providing BI functional & technical solutions for various cross functional business areas such as IT, Global Supply Chain, PLM, Sales, Finance, Engineering, Backend/Frontend Manufacturing, Business Units, Enteprise Reporting & Analytics, Global Supply Chain Metrics & Analytics etc.
• Experience with all phases of Software Development Life Cycle (SDLC) and project methodologies.
• Strong technical knowledge in Microsoft SQL Server/Oracle/Cognos/Microsoft BI/Tableau/Hadoop/SAP BI/BW/HANA development including DTS, Microsoft Analysis Services, Performance Tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Experience on the standard & genric data extraction from R/3 System (SD, MM and Inventory) application areas & SAP APO (DP, SNP, GATP planning areas).
• Experience with Pig, Hadoop and Hive and good understanding of the Hadoop Distributed File System (HDFS)
• Good understanding of MapReduce and the Hadoop Infrastructure for Global/Enterprise Dataware house.
• Experience in working as a SAP APO SNP, GATP, DP and involved in implementation of SAP BW/ Corporate Datawarehouse to support Global Supplychain APO/Sales business area.
• Designed, enhanced also become an SME/Architect for maintaining complex BI ETL, Cube models and Tableau dashboards supporting key BU, Sales, Global Supply Chain/S&OP departments like Demand Planning, GATP and SNP, PLM, BPPM.
• Extensively worked on Database Normalization and T-SQL in writing Stored Procedures, Indexes, Views and UDFs.
• Experience in using recursive CTEs, CTE, temp tables and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency as well as to support the existing applications.
• Experience in SQL Optimizing by using SQL techniquies, SQL Profiler, Index Tuning Wizard, Database Engine Tuning Advisor(DTA), DBCC Commands, Query Plan, Actual & Estimated Execution Plans.
• Transformed data from one server to other servers using tools like Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).
• Proficient in usage of SSIS Control Flow items (Execute Package/SQL tasks, Script task, Send mail task) and SSIS Data Flow items (Lookup, Conditional Split, Merge Join, Union All, Derived Column, Data Conversion, Multicast etc).
• Involved in Migration of DTS Packages to SQL Server 2005/2008/2012 Integration Services.
• Experience in performance tuning of SSIS Packages, building & deploying the SSIS packages from one environment to another environment.
• Experience in creating Jobs, Alerts, passing Variable values and schedule DTS/SSIS Packages using SQL Server Agent/ Active Batch Scheduler and also experience in scheduling batch jobs using Zookeeper.
• Experience in OLTP/OLAP system study, Analysis and modeling, developing data warehouse schemas like Star and Snowflake Schema used in dimensional and multi-dimensional modeling.
• Experience in Designing, Creating, Deploying and Processing of Cubes using SSAS included tabular model & Tableau 9.x.
• Invloved in Dimensional Data Modeling. Data Vault Modeling, SSAS Performance Tuning, Cube Partitioning, Desiging Aggregations and Persepectives.
• Expertise in designing complex reports like Drill-Down Reports, Drill-Through Reports, Parameterized Reports, Cascaded Reports using SQL Server Reporting Services (SSRS)/ Tableau 9.x based on client requirement.
• Expert in creating Ad-Hoc reports, Snapshot reports and Sub reports using SQL SSRS.
• Familiar with Agile and Waterfall methodology.

TECHNICAL SKILLS

Transactional & Data warehouse (BI) tools: SQL Server Integration Services(SSIS), SQL Server Analysis Services(SSAS), SSAS Tabular Model, Cognos (Framework Manager/Transformer), Tableau 9.x, SQL Server Reporting Services (SSRS), SAP APO, SAP BW on HANA, HANA Modeling (HA300), SAP ECC (R/3), Auto ETL, Active Batch V6,8,10 Admin, DTS xChange, DTS xChange Profiler. Hadoop 2.2 version, Map Reduce, Coludera & Hortonworks environment, Hive, Pig, Sqoop, Zookeeper. HDFS, MapReduce (MRv1, MRv2, YARN), Pig, Hive, Sqoop, Flume, Oozie, Zookeeper, PLM Teamcenter, PLM Agile, Microsoft Project Server.

Databases: Oracle, MySQL, MS SQL Server, Teradata, HANA

Programming Languages: C++, Core Java, T-SQL, VB.Net & C#, SQL (PL SQL, T-SQL), MDX, DAX, ABAP

Web Technologies: HTML, PHP

Database Query Tools: SQL Profiler, Database Engine Tuning Advisor.

Development Environments: Eclipse, SSMS, SQL Developer, HANA Studio, visual Studio 2005/2008/2012

Operating System: Windows 10/7/Vista/XP/2003/2000, Windows Server 2003, Windows NT, Unix.

Version Management Tools: Subversion, Visual Source Safe, Team Foundation Server.

Other: MS Access, MATLAB, JIRA (Agile), MS Project Server.

PROFESSIONAL EXPERIENCE

Confidential, Boise, ID

IT Data Engineer

Responsibilities:

• Interacted with Customers, Business Analyst, Project Manager and gathered and peer reviewed the Business Requirements, Software Requirement, Developing, Testing, Maintenance and resolving Production issues.
• Extensively worked with Supply Chain (Demand Management Group, Order Fulfillment, Global Supply Chain Group), Business Unit’s, S&OP, Inventory, Sales & Logistic, Engineering & Manufacturing team.
• Involved in data modeling and physical database design concepts in the architecture of a relational data warehouse for OLAP reporting.
• Worked as an ETL (SSIS, SAP BI/BW)/Reporting (MSBI/Cogno’s/Tableau/HANA Modeling) Architect for Supply Chain & PLM interim program in IT, Supply Chain, NPI, Business Planning & Process Management team.
• Developed various analytical reports/dashboards for BU’s, NPI, Sales, Supply Chain department using Tableau, Microsoft BI, & Cogno’s.
• Involved in designing of data vault modeling in HANA Corporate Data warehouse to support PLM business process.
• Perform enhancements and database optimization activities to maximize database query performance and system stability.
• Involved in development of various Global Supply Chain related SAP APO (Advanced Planning Optimization) projects such as SNP (Supply & Network Planning (both in-house & subcon models)), Master Data, GATP (Global Available to Promise), DP (Demand Planning), Order to Cash (OTC), SSD Configure to Order, Allocation Management Cockpit & CSP Driven Order Scheduling.
• Hands on experience in building different Datamart’s like CTM Datamart, Delivery Failure, Calculated Inventory, Forecast Datamart etc. in Corporate Data warehouse or Business Data warehouse.
• Used multiple transformations in SSIS to meet the business requirements by extracting data from SAP BW source systems, excel, Oracle, transform and finally load into the Corporate Data Warehouse.
• Created the automated processes for the activities such as SSIS Packages, Process Chains & Meta Chains run sequentially using Active Batch job & SAP BI/BW.
• Worked as a SAP BI, focusing on SD - Sales and Distribution, MM - Material Management application areas & SAP APO (DP, SNP, GATP), BI ABAP.
• Good understanding on the delta initialization and extraction as per the business requirement.
• Involved in the Data extraction from R/3 System, to & from APO Planning Area, Modeling and loading it to BW as per the business requirement.
• Extensively worked on SAP R/3-SD full loads (Orders, Shipments, Invoices) to BW.
• Assist in design and generation of reports/dashboards in timely and accurate manner.
• Developed new SSAS cubes using MDX for calculated members & names sets such as Supply Chain SNP CTM Analysis Cube, Demand Forecast Accuracy Cube, Demand Management Analytics Cube, Micron Supply Chain Allocation Cube, Delivery Failure, Micron Supply Chain DMA by Product Group Cube etc. which are related to planning projects.
• Developed Dashboards/Metrics such as Performance Metrics, Time to Value, Business Case & MPN Contribution Analysis Metrics to support PLM business.
• Developed new SSAS tabular model cubes using DAX such as Micron Supply Chain of CSP Analytics & Micron Supply Chain Child Designs Report etc. which are related to supply chain planning projects.
• Used Tableau/SSRS to create reports/dashboards, parameterized Reports, drill down reports, cascaded reports and involved in analyzing multi-dimensional reports in SSAS.
• Used Dynamic SQL to create SSRS Reports.
• Experience in deploying/publishing SSIS Packages, SSAS Cubes (MDX & DAX), SSRS/Tableau Reports/Views/Dashboards on different servers.
• Involved in performing unit, integration testing & analyzing data from SAP APO or ECC system to ProClarity reports & validating data by pivoting the table using excel.
• Experience with Pig, Sqoop, Hbase, Hive and good understanding of the Hadoop file distributing system (HDFS)
• Experience understanding of MapReduce and the Hadoop Infrastructure for Global/Central/Enterprise Data warehouse.
• Maintain documentations for all business intelligence processes. Created micron standard technical documentation (such as ITWIKI on SharePoint site/AID) with regards to architecture, design, test plans etc.
• Actively took part in scrum meetings to discuss the progress of the deliverables.

Environment: SQL Server 2008/2012, SSIS, SSAS (2008 & 2012), SSAS Tabular Model, Cogno’s, SSRS, Tableau 9.x, RC Tool, Share Point Server (Report Center), BI Center, Oracle, HANA Modeler & Development, MySQL, SAP APO, SAP BI/BW, Auto ETL, Active Batch AdminV10, Subversion, ProClarity, VB.Net/C#, Hadoop 2.2 Version, HDFS, Hive, Pig, TFS, SAP ECC, PLM Team center, MS Project Server, PLM Agile.

Confidential, Boise, ID

Business Intelligence Consultant

Responsibilities:

• Interacted with Customers, Business Analyst, Project Manager and gathered and peer reviewed the Business Requirements, Software Requirement, Developing, Testing, Maintenance and resolving Production issues.
• Extensively worked with Supply Chain (Demand Management Group, Order Fulfillment, Global Supply Chain Group), Business Unit’s, S&OP, Inventory, Sales & Logistic, Engineering & Manufacturing team.
• Involved in data modeling and physical database design concepts in the architecture of a relational data warehouse for OLAP reporting.
• Worked as an ETL (SSIS, SAP BI/BW)/Reporting (MSBI/Cogno’s/Tableau/HANA Modeling) Architect for Supply Chain & PLM interim program in IT, Supply Chain, NPI, Business Planning & Process Management team.
• Developed various analytical reports/dashboards for BU’s, NPI, Sales, Supply Chain department using Tableau, Microsoft BI, & Cogno’s.
• Perform enhancements and database optimization activities to maximize database query performance and system stability.
• Involved in development of various Global Supply Chain related SAP APO (Advanced Planning Optimization) projects such as SNP (Supply & Network Planning (both in-house & subcon models)), Master Data, GATP (Global Available to Promise), DP (Demand Planning), Order to Cash (OTC), SSD Configure to Order, Allocation Management Cockpit & CSP Driven Order Scheduling.
• Hands on experience in building different Datamart’s like CTM Datamart, Delivery Failure, Calculated Inventory, Forecast Datamart etc. in Corporate Data warehouse or Business Data warehouse.
• Used multiple transformations in SSIS to meet the business requirements by extracting data from SAP BW source systems, excel, Oracle, transform and finally load into the Corporate Data Warehouse.
• Created the automated processes for the activities such as SSIS Packages, Process Chains & Meta Chains run sequentially using Active Batch job & SAP BI/BW.
• Worked as a SAP BI, focusing on SD - Sales and Distribution, MM - Material Management application areas & SAP APO (DP, SNP, GATP), BI ABAP.
• Good understanding on the delta initialization and extraction as per the business requirement.
• Involved in the Data extraction from R/3 System, to & from APO Planning Area, Modeling and loading it to BW as per the business requirement.
• Extensively worked on SAP R/3-SD full loads (Orders, Shipments, Invoices) to BW.
• Designed raw data vault/business vault using Calculation Views in Hana Enterprise Data warehouse.
• Assist in design and generation of reports/dashboards in timely and accurate manner.
• Developed new SSAS cubes using MDX for calculated members & names sets such as Supply Chain SNP CTM Analysis Cube, Demand Forecast Accuracy Cube, Demand Management Analytics Cube, Micron Supply Chain Allocation Cube, Delivery Failure, Micron Supply Chain DMA by Product Group Cube etc. which are related to planning projects.
• Developed Dashboards/Metrics such as Performance Metrics, Time to Value, Business Case & MPN Contribution Analysis Metrics to support PLM business.
• Developed new SSAS tabular model cubes using DAX such as Micron Supply Chain of CSP Analytics & Micron Supply Chain Child Designs Report etc. which are related to supply chain planning projects.
• Used Tableau/SSRS to create reports/dashboards, parameterized Reports, drill down reports, cascaded reports and involved in analyzing multi-dimensional reports in SSAS.
• Used Dynamic SQL to create SSRS Reports.
• Experience in deploying/publishing SSIS Packages, SSAS Cubes (MDX & DAX), SSRS/Tableau Reports/Views/Dashboards on different servers.
• Involved in performing unit, integration testing & analyzing data from SAP APO or ECC system to ProClarity reports & validating data by pivoting the table using excel.
• Experience with Pig, Sqoop, Hbase, Hive and good understanding of the Hadoop file distributing system (HDFS)
• Experience understanding of MapReduce and the Hadoop Infrastructure for Global/Central/Enterprise Data warehouse.
• Maintain documentations for all business intelligence processes. Created micron standard technical documentation (such as ITWIKI on SharePoint site/AID) with regards to architecture, design, test plans etc.
• Actively took part in scrum meetings to discuss the progress of the deliverables.

Environment: SQL Server 2008/2012, SSIS, SSAS (2008 & 2012), SSAS Tabular Model, Cogno’s, SSRS, Tableau 9.x, RC Tool, Share Point Server (Report Center), BI Center, Oracle, HANA Modeler & Development, MySQL, SAP APO, SAP BI/BW, Auto ETL, Active Batch AdminV10, Subversion, ProClarity, VB.Net/C#, Hadoop 2.2 Version, HDFS, Hive, Pig, TFS, SAP ECC, PLM Team center, MS Project Server, PLM Agile.

Confidential, Boise, ID

Business Intelligence Consultant

Responsibilities:

• Interacted with Customers, BI Lead to gather requirements, conduct analysis and prepare specifications.
• Translate project requirements into functional and non-functional specifications for BI reports and applications. Maintained the database schema in source code control (MS Team Suite Database Edition preferred).
• Analyzed business requirements and translated it into technical specifications for BI reports and applications.
• StrongSQL ServerDevelopment skills including writing Transact-SQL (T-SQL) Queries, Stored Procedures, User Defined Functions (UDF), Views, Calculation Views, Indexes, and User Defined Data Types strictly following the Data Integrity using Constrains, Rules and Default.
• Experience in performance tuning, query optimization, Database Maintenance plans
• Performed Unit & IT Testing & conducted UAT sessions with end users.
• Responsible for developing processes automation of maintenance jobs, tuningSQL Server, locks and indexes configurations.
• Extensive experiences in developing Normalization, Stored Procedures, Views, ETL processes, relational database theory and Complex Queries onSQL Server2005/2008.
• Used multiple transformations in SSIS to meet the business requirements by extracting data from transactional source systems, transform and finally load into the Staging Data base.
• Worked in designing Cubes in OLAP and identifying the Fact and Dimension tables.
• Used SQL Server Profiler to monitor the performance, Debug Transact-SQL statements and stored procedures in existing application, to identify slow running query etc.
• Enhanced the functionality in database and data ware housing concepts (OLAP, OLTP) Cube by creating Named Queries, Calculated Members and Perspective using SQL Server Analysis Services 2008(SSAS).
• Excellent in creating reports withSQL ServerReporting Services (SSRS).
• Used SSRS to create reports, Parametrized Reports, Drill Down & Drill Through Reports, Ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Experience in creating Parameterized Reports using Dynamic SQL i.e. Stored Procedures.
• Provided reporting and analytic solutions to the organization in the form of Reporting Services reports and Analysis Services cubes.
• Provided data by building datamart’s to the Information Worker Community, who are developing BI solutions within the business.
• Managed complex issues quickly using problem solving techniques such as problem (KT), process and data analysis.

Environment: MS SQL Server 2008/2012, SSIS, SSAS (2008 & 2012), SSAS Tabular Model, Cognos, SSRS, RC Tool, Share Point Server (Report Center), BI Center, Oracle, HANA Modeler & Development, MySQL, SAP APO, SAP BI/BW, Auto ETL, Active Batch AdminV6 & 8, Subversion, ProClarity, VB.Net/C#, TFS, SAP ECC.

Confidential, IL

Database Developer

Responsibilities:

• Worked with Business Analysts, Project Managers and gathered and peer reviewed the Business Requirements, Software Requirement, Developing, Testing, Maintenance and resolving Production issues.
• Design, Implement and maintain Database Schema, Entity relationship diagrams, Data modeling, Tables, Stored procedures, Functions, Constraints, Views and complex SQL statements.
• Developed Confidential ’s student self-service enterprise system using SSAS & SSRS tool.
• Developed new datamart’s like SSES (Student Self-service Enterprise System) & FASOIS (Faculty & Staff Operational Information System) which includes ability to analyze and report of student records from historical data to present and also provides the basic definition of faculty and staff attributes like demographics, appointment, job history and basic salary information.
• Developed the T-SQL programs and Involved in performance tuning of SQL queries and stored procedures using SQL techniques and queries for faster retrieval.
• Involved in performance tuning of SSIS Packages.
• Created and Configured OLAP Cubes (Star Schema) using SQL Server 2008 Analysis Services (SSAS).
• Enhanced the functionality in database and data ware housing concepts (OLAP) Cube by creating KPI’s, Perspective using SQL Server Analysis Services 2008(SSAS).
• Generated Reports using Global Variables, Expressions and Functions for the reports using SSRS 2008.
• Developed Query for generating drill down reports in SSRS 2008.
• Involved in Unit testing, Validating the end to end data and Integration testing in SSIS, Aggregation behavior in SSAS Cube, SSRS.

Environment: MS SQL Server 2008, MS Access, Excel, Windows Server 2008, IIS, Share Point Server, Report Builder, Performance Point Server, TFS.

Confidential

BI Consultant

Responsibilities:

• Analyzed business requirements and translated it into technical specifications for BI reports and applications.
• StrongSQL ServerDevelopment skills including writing Transact-SQL (T-SQL) Queries, Stored Procedures, User Defined Functions (UDF), Views, Indexes, and User Defined Data Types strictly following the Data Integrity using Constrains, Rules and Default.
• Experience in performance tuning, query optimization, Database Maintenance plans.
• Involved in Unit Test cases preparation and performed Unit testing.
• Responsible for developing processes automation of maintenance jobs, tuningSQL Server, locks and indexes configurations.
• Extensive experiences in developing Normalization, Stored Procedures, Views, ETL processes, relational database theory and Complex Queries onSQL Server2005.
• Extensively worked in ETL and data integration in developing ETL mappings and scripts usingSSIS, worked on financial Data transfer from a Text, excel file & legacy systems toSQL Serverby using bulk insert task inSSIS.
• Used multiple transformations in SSIS to meet the business requirements by extracting data from transactional source systems, transform and finally load into the Staging Data base.
• Worked in designing Cubes in OLAP and identifying the Fact and Dimension tables.
• Used SQL Server Profiler to monitor the performance, Debug Transact-SQL statements and stored procedures in existing application, to identify slow running query etc.
• Excellent in creating reports withSQL ServerReporting Services (SSRS).
• Used SSRS to create reports, Parameterized Reports, Drill down, Drill through Reports, Ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• Experience in creating Parameterized Reports using Dynamic SQL i.e. Stored Procedures.

Environment: MS SQL Server 2005, SSIS, SSAS, SSRS, VSS, MS Excel 2003, VB .Net, SQL Server Agent.