Sign in

Business Analyst

Secaucus, New Jersey, United States
February 13, 2018

Contact this candidate


Somya Yadav

** ****** ******, ******, *******

Phone: + 201-***-****


Highly regarded self-starter with a master’s degree in Business Information Systems, offering more than 3 years as an Analyst in dynamic environments ranging from Release & Configuration management to Application and Business process design. Seeking a Business Analyst position at a company that appreciates a strong education background and work experience and where I can effectively contribute to the organization’s mission and vision.


M.S. Business & Information Systems: New Jersey Institute of Technology, NJ, USA-Dec2017

GPA: 3.95 / 4.0

Courses: Data Analytics for Info Systems, Business Process Innovation, System Analysis and Design, User Experience Design, Corporate Finance, IT Service Management, Enterprise Database Management, Data Mining, Project Management.

B. Tech Electronics and Communication: UMIT, SNDT University, Mumbai, India-May 2013

GPA: 4.51 / 6.0


ITIL® Foundation Certificate in IT Service Management (Axelos)

Master Course in Tableau v.10 for Business Intelligence (Udemy)

Business Analysis Foundation (PMI)

Lean Six Sigma Foundations (PMI)


Languages: C, C++, SQL, PL/SQL, Python, UNIX.

Tools: ETL - (AppWorx, Markit EDM CADIS, BMC Control-M, Charles River IMS, IBM InfoSphere

Datastage, Ellucian Banner), Tableau, JIRA, IBM COGNOS, IBM WebSphere, SAP ERP, BridgerInsightXG, UltraEdit, WinSCP, MATLAB, Confluence, SharePoint, Axure, inVision, MS Office, MS Project, MS Visio, Google Docs, Google Sheets, Google Slides, Google Drive, SALESFORCE Admin.

Database & OS: Oracle, MS SQL, MySQL, Embarcadero Rapid SQL, Linux, Mac, Windows.

Soft Skills: Analytical, Detail-oriented, Creative, Organized, Troubleshooter, Team Worker.

Work Experience

Business Analyst Intern, McKinsey & Company, NYC, USA (May 2017 to Dec 2017)

Led application upgrade, automated installation through Alteryx from version 2.5.7 to 4.6.

Coordinated with technical team for implementation and testing, vendor and followed-up with business users worldwide leading to monitor and document opportunities for system enhancements.

Translate and prioritize requirements from Business stakeholders into technical documentation for application development teams for design and code modification/enhancements.

Proposed solutions meeting defined specifications by inVision User Experience prototyping for McKinsey partners’ 2018 elections.

Collaborated with stakeholder groups across the organization to ensure business and technology alignment and increased efficiency.

Worked on dashboard creation using Tableau reporting and Python scripting.

Served as point-of-contact for project management staff.

Graduate Student Assistant, NJIT, Newark, USA (Oct 2016 to March 2017)

Performed quality assurance, system integration & user acceptance testing facilitating on-time enterprise implementations.

Extracted Student admissions data quicker by 40% by Oracle DB, Ellucian and COGNOS Reporting tools.

Designed test cases, created and executed PL/SQL scripts, automated load chains for data validation.

Provided continued maintenance and development of bug fixes and patch for web applications.

Formulated, defined and documented system requirements and specifications.

Business Support Analyst, Asset Management, HSBC GLT, Pune, India (Aug 2013 to June 2016)

●Provided L1 24/7 support for Run the Bank (RTB), Asset Management department, improved change management initiatives of FO/MO applications to increase productivity and workflow, got recognized as a critical resource.

●Performed Operations Management through Ticketing tool, ad-hoc analysis to resolve customer requests on financial data management issues, EDM implementation, maintaining the build, training on the platform, user access and version upgrade on ETL tools.

●Partnered with developers and stakeholders to automate manual processes, saving time and money while decreasing errors.

●Diagnosed and troubleshoot problems reported by customers, provided solutions through root-cause analysis, UNIX shell-scripting, checking data duplicates by SQL and provided Fixes or Work-arounds.

●Ensured secured DB Releases & Environment (PROD & UAT) management, facilitated end-user application support using Agile and Dev-Ops methodologies.

●Designed SharePoint pages, Daily Status Reports, Dashboards, Technical documents, serving as department’s Knowledge Management for all technical complications and addressed all personnel issues promptly and professionally.


●Bridger Insight XG – Successfully implemented application upgrade from version 2.5.7 to 4.6 including Datastage, Unix servers and User Interface, while in coordination with technical team, application vendor and users.

●SHC MD Elections Prototype – Using inVision application, user prototype was created for Managing Director Partner selection that scheduled for first quarter of year 2018.

●Business Process Improvement - Proposed TO-BE process using GAP Analysis and BPMN modeling involves using an automated Kiosk system eliminating various problems like long queues, unavailable rooms and incorrect invoices, to improve the timeliness and efficiency leading to positive customer satisfaction.

●Project Management – Created a Conceptual Plan for a Movie project ‘Love’s Here’ including SOW, WBS, CBS, ROI and Risk Analysis and Gantt Chart Scheduling.

●Megastore Data Visualization - Performed Data Analysis on a given store data and created a live dashboard using Tableau and Excel Pivot Tables to determine sales trend affecting the country.

●UI Design headStart - Built a review and rating system prototype of Professors for NJIT using Axure.

●Avalon – Responsible for the application, Sybase DB and server migration of Datastage v8.7 to v11 with no post operational issues.

●IMS Demise - A high priority Asset Management project, performed complex data validation and transformation, RCA by sort and de-duplicate data on MARKIT EDM CADIS solution designs, UAT DB releases, performed Control-M jobs and Autosys scheduling and monitoring, testing and troubleshooting to demise the older existing order management system CRD IMS using trade – analysis.


●Awarded with the official RISE Award for excellence in AVALON Project of System Upgrade.

●Creative Head for the council E-Cell (Entrepreneurship Cell) during Undergrad and won competitions in Photography, Designing and Dancing.

●Volunteered as Grad student and have been an active participant of graduate Student Association (GSA) and Society of Women Engineers (SWE).

Contact this candidate