Summary

Experienced analyst and worked extensively in business intelligence, data warehouse and analytics with strength hold in data mining, ETL tools, project management, agile-scrum, requirement gathering and analysis, data visualization tools, and predictive modelling. Proven track record of improving the efficiency and productivity of corporations through strong communication, technical and analytical skill.

Skills

Skills

TECHNICAL SKILLS & CERTIFICATIONS

ETL Tool:Informatica Power Center 8.6/9.1/9.5.1/9.6.1, SAP BODS 3.2/4.1, MS BI (SSIS, SSAS)
Reporting and Visualization Tool:SAP Business Objects XI 3.1/ BOBJ, Tableau, and Qlikview
Languages:C++, c, Java, Python, SQL and PL/SQL
Application Tool:Toad, SQL Developer, MS Office (Microsoft Advance Excel and Access) and MS Project
Scheduling and Analysis Tool: Autosys, R, SAS Enterprise Miner, Digital Marketing (Google Analytics & AdWords)
Certifications:
  • Awarded with Level 1 certification for DWH/BI Concepts by NTTDATA Learning & Certification Institute.
  • Google Analytics Certification

Projects and Business Experience

Work History

Software Engineer (Business Intelligence/DW SAP BODS/ Informatica Consultant)

Jun 2013 - Feb 2015
NTT DATA
  • Analyzed and managed the business requirement for incremental releases.
  • Involved in Design and Development of Data warehouse.
  • Provided operational support and used scheduler tools like Autosys.
  • Performed data analysis and worked extensively in Data warehousing, database systems and coded using ETL tools like SAP BODS (3.x & 4.x) and Powercenter Informatica (8.x & 9.x) that improved the productivity by 10%.
  • Worked as an analyst to solve complex issues and prepared design documents with the technical details for better understanding for team and clients to meet Business needs.
  • Deployed, Designed and developed/modified business intelligence applications like Informatica ETL for the data migration.
  • Worked in Oracle 11g using Toad to develop PL/SQL programs to help to monitor the data loads in JSP web page.
  • Designed and developed BO/BOBJ (SAP Business Objects) reports. Also, prepared dashboard, maintained and delivered reports to the clients.
  • Created and/or upgraded Structured Query Language (SQL) stored procedures, tables and queries to modify or create reports for clients and contributed to achieve organizational goals.
  • Utilized Crystal Reports, SQL Server Reporting Services (SSRS) and Microsoft Excel spreadsheets to display the resulting data from coding and analysis frequently in pivot and table format.

Sas Enterprise Miner

Jan 2016 - Mar 2016
Data Mining-UTD Project
  • Generated a set of decision rules as part of predictive analytics and data mining to predict the category of the crime for a given location using SAS Enterprise Miner.

Analyst

Jan 2016 - Mar 2016
Web Analytics/Digital Marketing-UTD Project
  • Analyzed web data using Google Analytics for different departments at JSOM (Jindal School of Management) across various dimensionsto classify and target prospective students’ clusters.
  • Analyzed and summarized the findings using custom reports and advanced segments and increased traffic by 8%.

BI/ETL Developer

Aug 2015 - Dec 2015
Microsoft SQL Server- UTD Project
  • Designed an Inventory Online Transaction Processing System in MS-SQL. Designed and developed a data warehouse for reporting on the above OLTP. Created an ETL program using SSIS. Created Reporting cubes in SSAS. Connected cubes with Tableau for front end reports and dashboards.

Data Visualizations using Tableau

Aug 2015 - Dec 2015
UTD Project
  • Identified dimensions and measures. Placed different types of charts according to the KPIs to be illustrated. Applied quick filter formatting, story points, Visual data window handling, excel and text file connector. Added complicated data to the reports using the calculated fields formed using various aggregation levels in Meta data. Blended data in Tableau.

Project Management

Aug 2015 - Dec 2015
Agile - (SCRUM)-UTDProject
  • Reduced costs, managed and resolved issues in Fissure SimProject, an online project management simulation focusing on completing the project Resource Management, business processes, business analysis, Schedule & Budget Management and using MS project 2013 for the same.

Education

Education

MS

Aug 2015 - May 2017
The University of Texas at Dallas

M.S., Information Technology and Management (MIS);                                                                       GPA 3.78
Minor in Business Intelligence & Analytics

B.Technology

Aug 2008 - Jul 2012
Uttar Pradesh Technical University

B.Tech, Major Computer Science and Engineering                                                                                  GPA 3.5

Organizations

Infinity Lions Club UTD- Vice President - Events & Operations                                    August 2015- Present

Literary Committee, IIMT IET-Founder & Organizer                                                      May 2011- May 2012

Recognitions

Award: Received a Team Award for my outstanding contribution in the team in NTT DATA.

Recognition: Led the Team as Team Captain and was among Top 5 teams in UTD HULT Prize Competition.

Languages:  Hindi and English