Career Summary

Versatile, goal-oriented business systems analyst with experience in data warehousing and business intelligence. In the past I have successfully managed and delivered several data migration projects involving Salesforce data, Teradata, Netezza, MySQL and BI tools such as Tableau, PowerBI and ThoughtSpot. My recent experience at Abbott involved working on quality critical, regulated Big Data projects that involved creating data privacy plans, quality controlled SLC documents and driving communication with the third-party vendors. I also created a RACI chart and negotiated contracts for the project team.

Technical Expertise

Software Tools: SQL, C/C++, VB.Net, UML, XML, HTML, Java, Microsoft Office/Project/Visio, Eclipse, Essbase, Confluence, JIRA, ThoughtSpot, Tableau, PowerBI, AWS Cloud, Big Data, Salesforce ServiceNow files

Business Tools: CMMI, Crystal Reports, Automate 9.0, PowerShell, Feith, Tortoise Subversion, (SVN), Serena Prototype Composer

Databases: Oracle 10g, 11i, SQL/PL, MS-Access, MS SQL Server, Teradata, Big Data

Operating Systems: Microsoft Windows, Mac OS

Professional Experience

Cognizant Technology Solutions- San Francisco Bay Area, CA March 2018- Present

Project work experience:

Abbott – Alameda, CA March 2019 – Present

Project Manager/Sr. Business Systems Analyst

●Managed, coached and mentor the existing cognizant delivery team for Big Data Advanced Analytics (BDAA) program

●Published accurate and timely reporting of program status throughout its life cycle

●Created detailed project plan and tracked delivery status via daily stand ups

●Managed business stakeholder engagements and periodize activities for the team

●Managed change requests and deviations and day to day assignments of the team

●Co-ordinated with customer point of contact for escalations and resolutions of technical issues

●Created functional requirements and other quality documents as per standard Abbott Quality process

●Navigated and Managed SLC documents deliverable tool (M files) for approvals as per standard Abbott Quality process

●Managed cognizant offshore & onsite team members’ key deliverables

●Build credibility, established rapport and maintained communications with stakeholders at multiple levels, including those external to organizations

●Coach, mentor, and lead personnel within an AWS Big data environment

●Negotiated contracts and developed statement of work (SOW), RACI charts for better work visibility for both Cognizant and Abbott

Apple – Cupertino, CA January 2017 – March 2019

Sr. Business Systems Analyst

●Worked with business teams to perform various data analysis for the proprietary system

●Maintain continuous alignment of project scope and make recommendations to enhance effectiveness

●Worked closely with WW Sales ops team and document data architecture of their forecast model

●Worked on data migration for Salesforce data (SFDC) into Teradata environment

●Extracted data from source and loaded into staging environment using Informatica (ETL) tool

●Conduct UAT session with business groups around the globe

●Created data mapping documents for Teradata data extracts

●Executed several data queries in Teradata for different business projects

●Performed end to end testing for several data migration projects

●Gathered and documented requirements in confluence, JIRA

●Worked closely with Marketing /Sales team on forecasting, headcount reporting and several other sales channel projects

●Managed new web input process for Headcount Reporting for WW Sales and WW Sales Finance Teams

●Managed and groomed product backlogs for sprint planning as part of Agile/SCRUM methodology

●Developed ThoughtSpot for report migration projects from Business Objects

●Managed enhancement requests for AppleCare repair data reports

●Developed and reviewed design playback with stakeholders and technical design document with development team

●Pilot new agile process and managed weekly sprint team meetings

●Performed data analysis using Excel / Tableau and helped drive business reports

Jersey Technology Partners- United States May 2013- January 2017

Project work experience:

CA technologies – Islandia, NY May 2016 – January 2017

Sr. Business Systems Analyst

●Designed functional specs for several application reports for the newly acquired company by CA Technology

●Presented periodic dashboard reports on the current program, future opportunities and client issues to project team members

●Created data mapping for new enterprise data to be merged with existing CA data warehouse

●Gathered data requirements & performed data analysis for BO reports

●Managed and guided offshore development team as well several third-party vendors throughout project

●Worked with cross functional teams to gather requirements for several data migration efforts

●Conducted UAT and helped offshore team with deployment efforts often outside regular work hours

●Executed several SQL queries and stored procedures to validate data in Teradata

Information Control Company (End-Client: M&T Bank) – Columbus, OH

November 2014 – May 2016

Sr. Business Intelligence Analyst

●Worked on projects servicing both Commercial and Retail divisions of the bank.

●Worked directly with end-users to collect data, specified technical requirements, and created Use Case documentation and process maps to address end user needs.

●Created several data mapping documents for the Liquid Coverage Ratio (LCR) project.

●Programmed data validation queries using SQL to check inbound and outbound data for the LCR project.

●Clearly communicated issues and progress to upper management via engaging and artful presentations

●Managed onsite & offshore team members for project deliverables

●Interacted with several business users and project stakeholders as part of the UAT team and made necessary changes as per their input.

●Interacted directly with client managers on the Enterprise Business Object (EBO) report project to gather business requirements.

●Converted business requirements to technical data requirements (data flow diagrams, ETL mapping) for the development team.

●Gathered data requirements and performed data analysis for SAP Enterprise Business Objects reports.

●Executed SQL queries and stored procedures to validate data in Teradata.

●Performed ETL activities including loading test data and completing data profiling using Informatica tools.

●Managed and guided the offshore development team as well as several third-party vendors throughout the project.

●Conducted UAT for all customer match/merge rules for Master Data Management (MDM).

●Managed UAT for Change Data Capture (CDC) components of the MDM project.

●Performed data analysis using AnalytiX for various source systems within the MDM environment.

●Followed Agile SCRUM methodology

Luxottica Retail – Cincinnati, OH May 2013 – October 2014

Sr. Business Systems Analyst

●Owned the data cleansing for the multinational CRM project based on Salesforce, SAP and IBM Netezza platform

●Defined business requirements and functional specs for data cleansing

●Created comprehensive test plan for data cleansing using HP Quality Center

●Designed data mapping for new data feeds using Microsoft Visio

●Worked on legacy data conversion from JDA to SAP and design functional specs documents

●Migrated Salesforce Service Cloud data used for tracking customer orders, support history into Customer data mart as part of customer 360-degree view CRM project

●Worked closely with the marketing team on several campaigning efforts for various brands (Sunglass Hut, Lens crafters, Target Optical, Sears etc.)

●Programmed in ETL tool called Talend (java based) for various data extraction and data integration jobs

●Created user stores and worked with Agile team to break down stories to tasks

●Conducted T-shirt sizing and resource estimating to support roadmaps

●Worked on product backlog grooming and prioritized deliverables for each sprint

●Lead retrospective meeting after each sprint and

●Provided proactive and accurate cost analysis and sound business advice to strengthen the decision-making process

●Validated the data and test case scenarios based on query results using SQL inside IBM Netezza workbench

●Coordinated process for test phases including User Acceptance Test (UAT).

●Created and maintained User Acceptance Test (UAT) Plan and Test cases.

●Assisted client in developing content and training materials, recommended enhancements, and identified new business requirements.

●Created and maintained Control Plan and reviewed it with the Business owners.

●Conducted T-shirt sizing and resource estimating to support roadmaps.

●Created Project Definition Tollgate and conducted Tollgate Meetings.

●Provided proactive and accurate cost analysis and sound business advice to strengthen the decision-making process.

●Designed and implemented basic SQL queries for QA testing and report / data validation.

●Acquired good knowledge on mainframe technologies and systems.

●Experience working in a Retail / Distribution environment, supporting different business areas including: Sales, Customer Service, Fulfillment, and Payment Services.

●Expertise in E-Commerce in retail environments like Merchandising, Store operations, Order Management, Supply Chain, Warehouse Management, POS, and Content management.

●Logged defects using a tool called JIRA

●Coordinate closely with business owners, project managers and several third-party vendors such as Epsilon, Strike Iron, Rosetta & Olson to define the scope of the project

●Worked extensively with business to define flowcharts, campaign metadata in UNICA environment

●Developed & merged PII information for email/direct-mail coupons in UNICA

●Updated coupon contact history based on host suppression/control records in UNICA

●Strong visual modeling and business process modeling skills in Rational Unified Process (RUP) and Agile Modeling with tools like MS Visio

●Developed an FTP solution using Talend to send coupon/campaign data to various third-party vendors

●Followed Agile SCRUM methodology throughout the deliverables and switched roles between solutions architect, developer and product owner

Alliance Benefit Group – Albert Lea, MN May 2010 – May 2013

Sr. Systems Analyst (Full Time)

●Provide technical platforms for end users using SQL, PowerShell, Access, XML etc. to revamp efficiency of daily tasks

●Used AGILE (extreme programming) methodology on project deliverables with end to end ownership

●Worked on a Fee Disclosure Project that not only helped improve efficiency but client satisfaction since it aligns with the new Federal regulation.

●Automated the Dividends posting process that improved the productivity of end users by several hours (up to 18-36 hours in a quarter) and eliminated the possible of human errors

●Create specific reports for the end users using Crystal Reports that help end users present the information in the best possible manner to our clients.

●Conduct end user testing on reports and other applications

●Design automated systems in a multi-platform environment for various financial institutions

●Develop and present solutions and mitigation strategies to meet business needs to meet long-term value as well as immediate benefits

●Work independently and proactively in tracking and reporting issues, created use cases and validated the business processes for each process, website use cases and e-commerce scenarios

●Defining and managing the scope of Business Systems projects and assist in providing overload/traditional query results for processes, e-commerce methods and website integration with Share-point, SQL and other tools

●Worked closely with Client project managers, team program managers to differentiate and identify project scope needs

●Created slide presentations for quarterly business reviews for corporate-level management, documenting business status, performance, and pending business initiatives

Education

Iowa State University – Ames, IA

Bachelor of Science (BS) in Management of Information Systems (MIS)

Contact this candidate