SUMMARY

• Accomplished professional with over Eight years of experience developing, and optimizing customer experience analytics and online customer engagement strategies for major leading financial, banking, insurance, pharma and IT companies.
• Multifaceted digital marketer with expertise in digital analytics, demand management, predictive modeling and segmentation, conversion optimization, revenue/ROI management, multi - channel, social and mobile analytics.
• Insightful analyst with a keen understanding of consumer behavior and engagement having worked on Confidential ’s live chat feature and web breakage as a top priority generating cost savings of over $20M.
• Highly effective Business Analyst with proven experience planning and executing over 120 campaigns having successfully managed many successful product launches.
• Highly motivated team player with excellent communication, presentation and interpersonal skills, always willing to work in challenging and cross-platform Environments.
• Experienced as a Business Analyst in using the iterative software development life cycle principles of Rational Unified Process to manage, develop and test distributed client/server, Internet and intranet applications on heterogeneous environments.
• Worked with technical staff to implement business requirements into the software application in retail and e-commerce environments.
• In-depth knowledge of creating user cases, functional design specifications, activity diagrams, logical, component and deployment views to extract business process flow.
• Interacting regularly with the development team, creative services, database designer, system administrator and the higher management to meet the deadlines of Project milestones.
• Worked in close co-ordination with the testing team in developing test plan and test cases from functional and business requirements.
• Well versed in writing T-SQL queries/Scripts for Data Analysis and QA reporting and testing.
• Ability to implement Change Management and Defect Management techniques.
• Proficient at coordinating testing team in developing test plan and test cases by giving view of functional requirements.
• Excellent knowledge of MS Office especially MS Excel, Visio, Power Point, Word. Expertise in creating the Data flow diagrams using MS VISIO. Strong experience in creating Macros in Excel and MS Access.
• Successful as team player working in conjunction with other testers, developers and other team members in validation and testing complex scenarios and projects and in maintenance of Quality Standards in Projects especially with Test Director.
• Strong Software/Systems Development Life Cycle (SDLC) knowledge (waterfall and agile).
• Participated in Requirement gathering, System analysis, handling business and technical issues & communicating with both business and technical users.
• Very proficient with Data Analysis, mapping source and target systems for data migration efforts and resolving issues relating to data migration.
• Superlative organizational skills and project management attributes.
• Experience in Change Management Process (Identify, Analyze, Evaluate, Plan, Implement, Review and Close).

TECHNICAL SKILLS

Business Methodologies: Waterfall, Agile/Scrum

Operating System: Windows Vista/XP/2000/2008, UNIX

Database: MySQL, Confidential SQL Server 2008/2012/2014 , Oracle 12g

Programming Languages: C, C++, Java, T-SQL, SQL & PL/SQL

Tools: MS Visio, Project Planner, Unified Functional Testing, QA Complete, Notepad++, Edit Plus, MS Office Suite, Power BI and ETL.

PROFESSIONAL EXPERIENCE

Confidential, Dallas TX

Business Systems Analyst

Responsibilities:

• As a Business systems analyst for the research and development team, I designed and Modeled customized financial analysis of operational financial health of the organization.
• Analyze and report on business learning and business consulting services.
• Support month end close process and prepare accruals, cross charges and re-class journal entries. Build and maintain month end reports including variance analysis and headcount management reports.
• Closely worked with development team to make sure whether the software application fits within the architecture and has the required behavior.
• Created and maintained various team Share point portals for ease of communication and knowledge sharing
• Use advanced data modeling of Excel to provide a variety of data analysis views for Various levels of management including financial controller and sr. vice president in
• Utilize SQL querying for data mining from various databases/data marts based on Oracle, SQL server and Legacy-based systems.
• Documented software defects using bug tracking system and reported defects involving program functionality, output, online screen and content to software developers.
• Conducted formal and informal product design reviews throughout the software development lifecycle to provide input on functional requirements, product designs, schedules and potential issues.
• Review and modify the currentBusinessRequirements Document (BRD) and System Requirements Document (SRD) to describe all detail component changes for specific programs.
• Create metrics and reporting tools around the production planning/scheduling processes to improve information visibility and enhance the ability to measure and track goals. Reduce production schedule interruptions.
• Report summary of purchase orders weekly in MSIT Buydesk, using vendor names and number from MS Market and MS Inquire.
• Provided complex financial/business data analysis including sales/revenue/attainment reports, operating expense (OPEX) and budget reports, sales opportunity and pipeline
• Input financial data into the systems, performed data analysis and generated performance indicators in percentage or amounts using SQL server reporting services and PLSQL
• Designed an automated database systems to calculate the performance ratio of listed companies at the end of each financial year
• Created a reporting database to meet the specific analysis needs for the Education sales and finance teams.
• Collected and documented policies, calculation methods,businessprocesses as well asbusiness rules.
• Interviewed the domain experts and carefully recorded the requirements in the format that can be reviewed and understood by bothbusinesspeople and technical people
• Conducted Feasibility study, Risk Analysis and Cost benefit analysis
• Assisted in documenting variousbusinessrelated texts

Confidential, Louisville, KY

Senior Business Analyst

Responsibilities:

• Worked closely with test team for user testing of systems, developing and maintaining quality procedures, and ensuring that appropriate documentation is in place.
• Prepared Application Maintenance services operational reports.
• Developed the test scenarios and test plans based onbusinessrequirements, technical specifications and/or product knowledge in Quality Center.
• Assist the Development and QA team to provide clarification on requirements and test cases.
• Created UAT Test Plans and Test Cases based on user requirements and functional specifications.
• Interacted with DBA team to understand the table relation and the data information.
• Worked with SMEs to create workflows (to-be process) in MS Visio.
• Maintain knowledge and documentation of operational and system processes
• Perform cost/benefit analyses on potential changes to existing processes
• Participate in the administration of project and program contract activities, including preparation for internal and external meetings
• Collaborate with internal and external teams to define problems and implement solutions
• Create, review, and present program documents, including requirement traceability matrices, business and software specifications, process flows, and test cases
• Document complex program and system needs for both technical and non-technical audiences
• Assist in the analysis of data and the specification of report packages for internal and external audiences
• Worked closely with Quality Assurance and Training staff to optimize operational activities
• Support the project manager and product owner and stakeholders on project priorities
• Approve new vendor justification and keep track of active vendors. Create non-disclosure agreements and invite international vendors to participate in proposals.
• Used data applications to manage, approve vendor transaction and track commitments related to the deal.

Confidential, Riverwoods, IL

Senior Business Analyst

Responsibilities:

• Coordinated participation and sign-off of various business partners and customers.
• Involved in the analysis of the existing credit card processing system, mapping phase
• According to functionality and data conversion procedure.
• Performed Gap Analysis to check the compatibility of the existing system infrastructure With the new business requirements.
• Created Data Stage jobs to extract, transform and load data into data warehouses from
• Various sources like relational databases, application systems, temp tables, flat files etc.
• Designed use cases, activity diagrams, and sequence diagrams using UML.
• Used the DataStage Designer to develop processes for extracting, cleansing, transforms,
• Integrating and loading data into data warehouse database.
• Develop, maintain and publish project plan & scheduled project deliverables using
• Niku/Clarity resource database as well as MS Project.
• Extensively involved in the modeling and development of Reporting Data Warehousing System
• Was involved in the creation of new E-Commerce Products (Arrival Notices and Customized Reporting)
• Accumulated system requirements from various departments through surveys and Interviews.
• Involved in prioritizing the defects and writing business requirements to resolve them.
• Conducted JAD sessions with management, SME, vendors, users and other stakeholders for open and pending issues.
• Involved in mentoring specific projects in application of the new SDLC based on the Agile
• Unified Process, especially from the project management, requirements and architecture Perspectives.
• Create technical design documentation for the data models, data flow control process, Metadata management.
• Wrote detailed specifications for various reports generated using Cognos
• Analyzed the data collected and process maps to determine the root causes and identify opportunities.
• Planned and defined system requirements to Wire Frame with Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies
• Created business requirement documents and integrated the requirements and underlying platform functionality.

Confidential, Indianapolis, IN

Senior Business Analyst

Responsibilities:

• Manage and monitor financial performance within Operations Services functional team which includes Release & Data Management, Security & Solutions, Product Launch, Pricing, Online, and Operations Services Management.
• Drive insightful discussions with directors of each functional team to analyze current business performance and predict future trends.
• Perform FP&A processes that include budget/actual restatement, forecasting, target setting, hierarchy change and budget planning to facilitate business needs across teams within SMSG support.
• Use internal tools on daily basis to research for business rule violation as well as monitor and analyze spending.
• Manage Operations Services scorecard distribution by sending out schedules, reminders to metric owners and uploading monthly actual, headlines, issue description and resolution plan to the Confidential Dashboard/Data Collection Tool.
• Provide insightful analysis on COGS and OPEX control to the Operations management team.
• Integrate monthly close process for WW Operations team by sending out communication emails
• Prepare accruals for vendor spend, analyzing monthly financial performance/variances, generating flash report and monthly close deck to be presented to the GM of Operations Services and business partners.
• Improve the business unit’s SOP (sales/operations planning) process that drives manufacturing plans (production, capacity and inventory plans), sales plans (forecasting, bookings and shipments), sourcing plans (raw materials), financial plans (budgeting & financial outlooks) and impact/contingency analysis
• Translate raw sales forecasts into meaningful demand forecast for use in capacity planning, production planning and inventory planning.
• Assisted the project managers with the development of project schedules using MS Project
• Prepared Business Process Models that depicted modeling of all the activities of the business from the conceptual and procedural level.
• Acted as a liaison for projects with other corporate departments, including Executive, Legal and Information Services as well as vendor relationships
• Analyzed the existing reports of the reporting system in the database. Checked the consistency of the data after ETL process using SQL queries.
• Responsible for centralizing vendor list, controls spend and consolidate supplier diversity
• Create a standard process to manage accruals and drive for accuracy. Monthly account clearing (transfers and cross charges).
• Conduct system and data analysis for internal customer requests inquiring about data
• Discrepancies.
• Conducted root cause analysis and intensive investigation of data sources and rules applied to the data to reach best solution
• Successfully participated in completing annual SOX audit activities to ensure that my team successfully participated in completing annual SOX audit activities to ensure that Sales is in compliance.

Confidential, Redmond, WA

Business/Financial Analyst

Responsibilities:

• Acted as a liaison between underwriters who have a business problem and developers to create automated solutions.
• Involved in all phases of the Iterative approach of the SDLC from Inception to Transition.
• Performed the business requirements gathering by questioners, Interview business area Experts, surveys and JAD sessions.
• Working in Documents Management System to track and store images of paper documents.
• Propose process improvements to documentation and technical writing procedures.
• Gathered, documented, and communicated business requirements into systems design documentation using Business-Modeling concepts.
• Conducting Review Requirements meetings to identify missing or incomplete requirements and to identify potential test cases.
• Performed extensive data modelling to differentiate between the OLTP and Data Warehouse data models
• Involved in designing business use case scenarios, use case realizations diagrams, and workflow charts for documenting the requirements.
• Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models, and use-case realizations using RUP tools in Agile.
• Planned, coordinated and scheduled meetings, feasibility studies and surveys as required in order to collect detailed business requirements and specifications which can be used by the development teams.
• Interacted with representatives in supplying information, reporting defects, and obtaining information for specifications and implementation of the requirements.
• Prepared Logical Data Models that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the Entity relationships between the data elements to analyze and document business data Requirements.
• Maintained a requirements traceability matrix in order to keep the clients and all the Teams up-to- date with the current progress of the project.
• Involved in User Acceptance Testing (UAT) and Test Execution.
• Reviewing the business requirements and working with business and requirements team for gaps found during the review
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center 9.0
• Involved in Teradata SQL Development, Unit Testing and Performance Tuning
• Worked with various data sources with Multiple Relational Databases like DB2 UDB and Oracle to perform data validation.
• Extensively used Oracle Pl\Sql developer to query oracle database.
• Reviewed DataStage Mappings and test cases before delivering to Client
• Created ETL test data for all ETL graphs based on transformation rules to test the functionality of the application.
• Involved in extensive DATA validation using SQL queries and back-end testing
• Worked on logical data modeling to represent graphically about what information is about, how to relate it with business concepts and how to apply business rules to system.
• Analyzed system requirements, developed detailed Test plan, Test Cases, Test scripts for testing the functionality, GUI and security testing.
• Collaborated with QA Group to ensure adequate testing of application both before and after completion, maintained quality procedures, conducted UAT Testing, and ensured that documentation is in place.
• Collaborated with QA team to develop test plan, test conditions and test cases to be used in testing based on business requirements, technical specifications and/or product specifications.
• Designed the business requirement collection approach based on the project scope and SDLC Methodology.
• Designed the system, prepared UML and sequence diagrams using Rational Rose.
• Collaborated on creation of documents such as the Vision, business requirements (BR) and business systems design (BSD) documents
• Responsible for writing detailed descriptions of user needs, program functions, and steps
• Required for developing or modifying software programs using Rational Rose (UML).
• Actively interacted with different business groups to perform Gap analysis to identify the
• Deficiencies in the system by comparing the actual objectives with the system objectives desired.
• Used MS Visio for Process modeling and Business Process flow diagrams.