Download PDF


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.


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)
  • Awarded with Level 1 certification for DWH/BI Concepts by NTTDATA Learning & Certification Institute.
  • Google Analytics Certification

Projects and Business Experience

Jun 2013Feb 2015

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

  • 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.
Jan 2016Mar 2016

Sas Enterprise Miner

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.
Jan 2016Mar 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%.
Aug 2015Dec 2015

BI/ETL Developer

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.
Aug 2015Dec 2015

Data Visualizations using Tableau

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.
Aug 2015Dec 2015

Project Management

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.


Aug 2015May 2017


The University of Texas at Dallas

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

Aug 2008Jul 2012


Uttar Pradesh Technical University

B.Tech, Major Computer Science and Engineering                                                                                  GPA 3.5


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

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


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