SUMMARY:

• IT Professional (Sr. Business Systems Analyst) with an education in Management Information Systems, and prior work experience in roles such as Software Developer, Business Analyst, Software Quality Assurance, and Technical Support.
• My expertise is in understanding, documenting, and tracking the business needs, as well as training the end user throughout the system development life cycle (SDLC).

TECHNICAL SKILLS:

Software Tools: SQL, C/C++, VB.Net, UML, XML, HTML, Java, Microsoft Office/Project/Visio, Eclipse, Essabse

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

Operating Systems: Microsoft Windows, Mac OS

PROFESSIONAL EXPERIENCE:

Confidential - Cupertino, CA

Sr. Business/Data Analyst

Responsibilities:

• Worked with business teams to perform various data analysis for the proprietary system
• Worked closely with WW Sales ops team and document data architecture of their forecast model
• Executed several data queries in Teradata for different business projects
• Performed end to end testing for several data migration projects
• Managed and groomed product backlogs for sprint planning as part of Agile/SCRUM methodology
• Gathered and documented requirements in confluence, JIRA
• Perform data analysis for Confidential forecasting and several sales channel projects
• Conduct UAT session with business groups around the globe
• Created data mapping documents for teradata data extracts

Confidential - Islandia, NY

Sr. Business Systems Analyst

Responsibilities:

• Designed functional specs for several application reports for the newly acquired company by CA Technology
• 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

Confidential - Columbus, OH

Sr. BI Analyst / Consultant

Responsibilities:

• 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.
• 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.

Confidential - Cincinnati, OH

Sr. Business Systems Analyst

Responsibilities:

• Assisted client in development of business and data requirements, including identification of opportunities for improvement and optimization of business processes
• Created business use cases, logical data models, cost/benefit analysis, and User Interface designs followed by screen mockups.
• Identifying risks involved with the functioning of enterprises and providing advice regarding risk mitigation, best practices, operations cost reduction, and business development
• Conducted JAD sessions to allow different stakeholders to communicate their perspectives with each other, resolve any issues and come to an agreement quickly
• Involved in building “AS-IS” document, collected inputs for alternate solutions for “TO-BE” document
• Assisted in Validating business rules, process improvements, and UI designs with clients.

Confidential - Cincinnati, OH

Sr. Business Systems Analyst

Responsibilities:

• Owned the data cleansing for the multinational CRM project based on 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
• 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 maintain 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 environment 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, StrikeIron, 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 a 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

Confidential - Albert Lea, MN

Systems Analyst

Responsibilities:

• 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 Fee Disclosure Project that not only helped improved 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 helped end users present the information in 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 pro-actively 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 interaction 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

Confidential - Ames, IA

Software Development

Responsibilities:

• Program code to operate AFM instruments using VB.net
• Analyze samples with AFM instruments
• Debug and eliminate software bugs in the current code
• Execute general network maintenance duties assigned

Confidential - Williamsburg, IA

Information Systems Specialist

Responsibilities:

• Coordinated and developed plan for PC move to the new building
• Performed miscellaneous technical troubleshooting for all departments iPhone Application Development:
• Researched non-MAC user SDK called Tersus Visual Programming
• Developed native iPhone applications using visual diagrams

Confidential - West Des Moines, IA

Software Quality Assurance Tester

Responsibilities:

• Updated and tracked software defects using Test Track Pro
• Worked on standalone as well as web applications such as CART and PRS
• Demonstrated success in multi-tasking, and administrative responsibilities
• Acquired understanding of Software Development Life Cycle and Test case scenarios

Confidential - West Des Moines, IA

IT Business Analyst

Responsibilities:

• Managed & developed business requirements for healthcare IT projects of federal government
• Developed Requirements Change Control (RCC’s) document
• Pilot requirement visualizations for healthcare IT projects of federal government
• Designed virtualization of Inter Functional Design Document (IFD’s)