Analyst

Anshul Popat

**** ***** ******, *** # *, South Richmond Hill, NY 11419 • ******@*****.*** • 315-***-****

Qualifications / Skills

• Process Excellence Green Belt certified experienced Analyst proficient in Six Sigma and Lean

• Experienced in gathering requirements, programming, testing, implementing software tools

• Proficient in all phases of Software Development Life Cycle (SDLC)

• Applying creativity, problem-solving, data collection, logical and analytical skills to achieve business results

• Ability to lead a project as part of a larger team or work independently

• Adept at presentations using statistical analysis which help formulate business decisions

• Experienced in creating Test Cases, Test Plan, and Test Data

• Excellent interpersonal skills and an aptitude for competence planning, coaching/mentoring, resource allocation and monitoring outcomes of cross-functional projects

• Proven ability to draft, edit and finalize effectively crafted project reports and technical documentation

• Exceptional time-management, organizational as well as written and verbal communication skills

• Thorough understanding of Project Management principles, Business Processes and Process Flows

• Passion for knowledge and new tools as well as applying industry best-practices

Languages: C/C++, Java (Eclipse)

Databases: Oracle, MS SQL Server, Access, RDBMS concepts, Seibel, CRM

Query Tools: SQL, PL/SQL, TOAD

Reporting/BI: Business Objects, Cognos 8, Crystal Reports, SSIS, SSRS

Data Warehouse: SAP/BW, Documentum, ETL

Methodologies: Data Modeling Logical/Physical, Star/Snowflake Schema, FACT & Dimension Tables, ETL, OLAP, SDLC, Agile (Scrum), Waterfall, UML, RUP

Operating Systems: Windows 98/00/NT/XP/Vista, Unix/Linux (RedHat, Ubuntu), Mac (Snow Leopard)

Web Tools: HTML (FrontPage), Java Script, XML, VBScript, ASP, CSS Style sheets, ActiveX

Others: Word, Excel (Pivot Tables), PowerPoint, Visio, Project, SharePoint, Matlab, IBM Rational

Network technologies: LAN, WAN, VPN, TCP/IP, UDP, VoIP, RIP, SIP, EIGRP, ATM, BGP, OSPF, IGMP, EDI

Areas of Strength

Business Analysis, Statistical Analysis, Software Development, Project Management, Consulting, Marketing, Sales Engineering, Business Development, Business Intelligence

Projects / Achievements

• Technology leadership and revenue generation through e-Services

Gathering requirements and technical specifications along with supporting the Business Case for the e-Services project that will lead to revenue generation around $2.5 MM/year

• Process Excellence Green Belt Certification for project on e-Connectivity

Data collection and implementation of processes for the Remote Monitoring Centers for e-Connecting machines through documentation and training leading to annual savings of $26,000/year

• Dashboard, e-Health Check and BackOffice Applications

Gathering requirements, analyzing, prioritizing, implementing and testing applications with Agile and Waterfall models to improve reliability and provide call centers, field engineers and technical personnel with relevant data

• Assembling the cuvette incubator in-house

Cross-functional project aimed at reducing parts cost by assembling the cuvette incubator in-house. Involved data gathering, analysis, documentation, timely co-ordination & seamless implementation for savings of $120,000/year

• Parts Cube

Driven by strategic imperatives and also to control rising parts cost, worked on a unique way of analyzing parts data and assembled new reports to organize and present data in a graphical, intuitive OLAP cube format

• Feedback control system for the piano keyboard

Completed Master’s thesis using LabView software on replicating the tactile sensation experienced by a pianist on an acoustic piano, to a digital piano employing feedback mechanism using a sensor and actuator

Professional Experience

Ortho Clinical Diagnostics – a Johnson & Johnson Company Rochester, NY

Business Analyst / Worldwide Systems Engineer Mar 2008 – Feb 2010

• Developing, testing web-based software applications for e-ConnectivityTM and e-Services by gathering requirements and designing workflows

• Preparing business and functional requirement documents

• Employing business process mapping/reengineering, data modeling, data warehousing activities

• Proactively identifying key trends through statistical analysis & providing insight for actionable changes

• Managing project plans and documenting change control

• Subject matter expert (SME) between business users and IT programmers

• Realizing metrics, processes, scorecards for Remote Monitoring Centers in Europe and USA

• Validating data sources for proposals, business cases, reporting and dashboards

• Creating Business Intelligence (BI) reports from SQL Server, Oracle, Access databases using Cognos, Excel, SQL

• Presentation of e-Connectivity technology at Sales, Marketing and customer events

• Providing strategic and tactical analysis to marketing, sales with discussion through customers

• Building strong relationships with cross-functional teams (IT, QA, Training, Publications, Product Lifecycle, Parts and Supply Chain) to establish improvements in products

• Implementing training enhancements, service parts planning, service publications, information systems and delivering technical support for field engineers

Patni Computer Systems (PCS) Industries Ltd. Mumbai, India

Intern - Diagnostic & Research Cell

• Assisting with Project Management and writing technical reports from statistical analysis

• Programming in C/C++/Java for Windows Server editions and Linux/Unix backgrounds

• Organizing periodic meetings with process owners to communicate project status and ensure timely delivery

• Worked with routers, servers and Operating Systems to resolve hardware and software compatibility issues

Air India Ltd. Mumbai, India

Intern - Electronics Overhaul Division

• Involved with aircraft electronics including Rescue Beacon, RF transceivers, audio systems and Black Box

• Using Business Intelligence, data mining, OLAP to support business cases for reliability projects

• Assisting Supply Chain and Parts groups with inventory reduction

• Performing market research to gain competitive advantage

Education

University of Rochester Rochester, NY

M.S. in Electrical & Computer Engineering (GPA 3.62) Jan 2008

• Courses: Probability and Random Processes, Science Writing, Wireless Communications, Mobile Communications, Digital Signal Processing, Digital Communications, Consulting Practicum (MBA course)

Mumbai University Ramrao Adik Institute of Technology New Mumbai, India

Bachelor’s course in Electronics & Telecommunication (70.06% - Distinction) May 2006

• Courses: Computer Architecture and Organization, Computer Networks, Satellite Communication, Radar Engineering, Filter Theory, Microprocessors, Microcontrollers, Antenna and Wave Propagation

Shri Bhagubhai Mafatlal Polytechnic Mumbai, India

Diploma course in Digital Electronics (86.2% - Distinction) Jun 2003

• Courses: Microprocessors, Circuits and Networks, Elements of Communication Engineering

Published work

http://www.science.rochester.edu/depts/ece/archives/ece_050307.html

Interests / Certifications

• Completed Process Excellence Green Belt certification (Six Sigma)

• Web administrator for the student club Rochester Indian Association

• Studying the financial markets and working on a personal investment portfolio

Contact this candidate