Objective:
To obtain a position that would allow me to enhance my managerial & technical skills and grow with & within the company
Technical Skills:
| Programming Languages |
SQL, PL/SQL |
| Operating System |
Windows |
| Software |
JIRA, Rally, Toad, Informatica PowerCenter 9.6/9.5/8.6, Dollar Universe (job scheduler), PVCS (Versioning and Recording tool), Kintana (Deployment tool), Action Request System -Remedy (Ticketing tool), MS Office, Pentaho (community) |
| Databases |
Oracle 11g/10g/9i |
| Conceptual Knowledge |
Scrum, SDLC, Data Warehousing, Data Modeling, Data Mart, ETL, Tableau Basic |
Work Experience:
Team Lead / Scrum Master
Zensar Technologies, Pune, India
Project: NetAcad (Cisco Systems Inc., San Jose, CA, USA)
Feb 2013 - Present
NetAcad (Networking Academy) is an online university by Cisco established in 1997. It is present in around 165 countries with more than 10000 academies associated with it and has trained more than 4 million students so far. It helps students prepare for industry recognized certifications like CCNA, CCNP.
Handled a team of 6 people (first 2 years, team size was 9) consisting of front end developers (Liferay), backend developers (ETL), and QA resources
Facilitated scrum ceremonies (grooming, sprint planning, retrospectives, daily stand-ups, demos, etc.)
Prepared / updated the daily impediment list and worked for its resolution
Facilitated and participated in story point estimation technique (planning poker)
Helped in preparing and maintaining product backlog, sprint backlog, release backlog.
Participated in the scrum of scrums with people from different time zones
Taught the team to create clear and concise epics/stories
Trained team members on the agile (scrum) methodology
Brought QA in the initial phase of development
Conducted Agile Gallery Walk for the agile awareness in the company; around 600 people attended it
Worked with Agile COE closely and helped people with their queries / doubts on scrum process
Worked with management and different teams to implement DevOps model
Maintained Velocity, burn-down chart, test case execution progress
Evangelized the importance of automation. Helped QA in automating test cases using Selenium (did presentation on same) and automated job execution using scheduler
Developed and test various ETLs using Informatica PowerCenter and Oracle (SQL, PL/SQL
Work Developed proactive monitoring to identify delay in ETL SLA and possible data issues
Closely with management, cross functional teams to identify the dependencies and get them prioritized
Arranged need based training programs (technical and behavioral) for the team
Developed various business reports in Tableau
Conducted quarterly business review (QBR) with the clients
Helped recruiters in finding the efficient resource to work on the client project
Senior Software Engineer
Zensar Technologies, Pune, India
Project: QDM (Cisco Systems Inc., San Jose, CA, USA)
Nov 2010 - Feb 2013
QDM (Quality DataMart) is a data warehouse that consists of Cisco’s Manufacturing Quality Standards. Various metrics like Customer Satisfaction, Customer Reliability Ratio, Customer portfolio, Products and Services portfolio etc. are derived in QDM. They are used by middle to higher management to improve, analyze, and make decisions about Cisco’s products and Services
Worked at all levels, from requirement gathering to deployment and maintenance, of software development life cycle
Created business requirement document, user guide, and ETL specification document
Collected and collated data; generated periodic reports and carried out value added analysis of the reports to monitor movement of key business indicators
Conceptualized and implemented measures for streamlining the operations to enhance operational efficiency and resource optimization. For example, automated the execution of batch of jobs using Dollar Universe Scheduler to minimize the human error and saved around 200 human hours every quarter
Developed and tested oracle code (SQL, PL/SQL) and Informatica mappings for Data ETL
Worked closely with cross functional teams and different infrastructure teams to provide uninterrupted access of information to the users
Worked as Subject Matter Expert for 6 different applications under QDM and led a team of 4 people on those applications
Arranged need based training programs (technical and behavioral) for the team
Worked in a team of 10 people (onsite and offshore) to provide day to day Operations Support
Involved in Root Cause Analysis and resolved many Priority 1 issues in which stakeholders were losing thousands of dollars by hour
Helped recruiters in finding the efficient resource to work on the client project
Proactively checked the code. For example, user opened one ticket for some data missing in a table. On troubleshooting, I found out that the data was as per logic in that table but other table was having faulty business logic from 4 years and fixed it
Programmer Analyst
EBase Technologies, Inc., Fremont, CA, USA
Project: QDM (Cisco Systems Inc., San Jose, CA, USA)
Jan 2007 - Jan 2010
QDM (Quality DataMart) is a data warehouse that consists of Cisco’s Manufacturing Quality Standards. Various metrics like Customer Satisfaction, Customer Reliability Ratio, Customer portfolio, Products and Services portfolio etc. are derived in QDM. They are used by middle to higher management to improve, analyze, and make decisions about Cisco’s products and Services.
Involved in vendor agreements, SLAs, and invoice raising
Worked at all levels, from requirement gathering to deployment and maintenance, of software development life cycle
Created business requirement document, user guide, and ETL specification document
Collected and collated data; generated periodic reports and carried out value added analysis of the reports to monitor movement of key business indicators
Developed and test oracle code (SQL, PL/SQL) and Informatica mappings for Data ETL
Helped other team members with their technical issues
Worked closely with cross functional teams and different infrastructure teams to provide uninterrupted access of information to the users
Helped recruiters in finding the efficient resource to work on the client project
Worked in a team of 7 people (onsite and offshore) to provide day to day Operations Support
Worked as Subject Matter Expert for 6 different applications under QDM and led a team of 3 people (offshore) on those applications
Trained team members on the existing project and new applications
Received certificates of appreciation for collaborating with different teams, working with key stakeholders and business users, demonstrating passion, empowering teams, achieving results, and for using best data warehousing practices
Completed Cisco certified training in Problem Management learning and Post Incident Review learning.
Involved in Root Cause Analysis and resolved many Priority 1 issues in which stakeholders were losing thousands of dollars by hour. For example, in one scenario, many Siebel reports and java applications were failing because of the ETL process. On doing RCA, I found out that it was happening because of the limitation of Oracle 10g
Project Consultant – Process Mapping
Public Works Department – City of Fresno, Fresno, CA, USA
Master’s Degree project
Sept 2006 - Dec 2006
The Right of Way Section manages various aspects related to public right of way. Process mapping was done in order to get operational improvement, better customer satisfaction, standardization of practices, improve interpersonal relationships, to get American Public Works Association (APWA) Accreditation etc.
Carried out client presentation expressing the value plan of the product, solution, and service offering
Conducted regular meetings with the operational managers to collect the existing process details about Right of Way Section operations and mapped them using Swim Lane Process Mapping Technique
Conducted regular presentations for client to keep the project on track
Analyzed and identified the gaps in the existing processes of Right of Way – Special District Division
Made suggestions to improve the existing Right of Way process for operational improvement
Information Systems Intern
Community Medical Centers, Fresno, CA, USA
Master’s Degree Internship
Sept 2005 - Mar 2006
Reviewed and documented the existing recording structure of the patient’s medical information
Gathered and analyzed users' requirements for the new medical forms and recording structure
Designed electronic forms using software Create!form which streamlined the information flow, reduced paper waste, and made information readily available and its storage easier
Analyzed the feedbacks given by the users and efficiently re-designed the forms based on feedback
Student Assistant at Camera Surveillance (part-time)
Police Department, California State University, Fresno, CA, USA
Aug 2005 - Nov 2006
Monitored cameras installed throughout the university and reported any suspicious activity to officers
Reviewed camera recordings and duplicated them for officers
Provided customer service at front desk
Sales Representative (part-time)
Manohar Lal Jai Prakash & Co., New Delhi, India
Apr 2002 - Dec 2004
Acted as a single point of contact for some clients
Analyzed the business & customer requirements and strategically suggested new location for the warehouse which saved the logistics and labor cost by Rs. 100,000 annually
Finalized many deals with various companies like Asian Paints and Pidilite
Successfully implemented database (MS Excel) having details of all the customers and dealers
Kept the track of the inventory and provided customer service
Certifications & Education:
Certified Scrum Master
Dec 2013
Scrum Alliance, USA
Six Sigma Green Belt (online course)
Nov 2011
Indian Institute of Technology (IIT), Delhi
Oracle Certified Associate OCA (SQL, PL/SQL) – Database developer
Aug 2006
Oracle India
Post Graduate Diploma in Financial Management
Dec 2011
(School of Distance Learning) Institute of Management Technology (IMT), Ghaziabad, India
Masters of Business Administration (MBA) – Management Information Systems (GPA 3.7/4.0)
Dec 2006
California State University, Fresno, CA, USA
Received scholarship, a letter and certificate of appreciation, and a bronze award (label pin) from US President’s Council and Senate for doing community service
Received Merchant’s Scholarship for outstanding performance in the class
Relevant Coursework
End User Computing, Management Information Systems, Business Intelligence, Leadership and Organizational Behavior, Financial Management, Financial and Managerial Accounting, Production and Operation Management, Business Policy and Strategy, Global Environment of Business, Strategic Marketing
Bachelors of Technology (BTECH) – Electronics & Communication Engineering (74% aggregate)
Jun 2004
Guru Gobind Singh Indraprastha University, New Delhi, India
Extra-Curricular:
Helping a friend in his startup company (www.medikreview.com)
Amateur painter and artist (www.ektasveer.com)
Did community service of 200 hours to help a government hospital in Fresno, California
Headed production team for International Cultural Night 2006 at California State University, Fresno
Ushered in International Cultural Night 2005 at California State University, Fresno
Represented MBA department at Grad Expo’05 at California State University, Fresno
Represented Electronics cricket team as captain for three years in college tournaments and won them
Represented Electronics volley ball team as captain in college tournament and secured third place
Participated in college badminton tournament and secured third place
Participated in various debates in college during engineering
Worked with two social non-profit organizations (Bhartiya Tejas and Prerana) in India for two years
