SUMMARY:

• Experienced, detail - oriented Functional and Non-functional Business Analyst with a Developing background, having over 15+ years of professional experience in IT.
• Knowledge throughout the full SDLC, Project Planning, under different Methodologies such as Agile / Waterfall for large-scale systems. Strategized and planned for the what/how/when/why aspects of software development throughout implementation, thus aligning the business goals with Technology to improve Profit through Business Process re-engineering.
• Experience with Large data sets
• As BSA/BA other competencies include excellent working knowledge of enterprise Data Mart, Data Warehouse, Business Intelligence and Predictive Analytics stored on DBs such as Snowflake, MySql, Sql-Server, Teradata, Netezza, and Oracle.
• Accomplished developer in several languages and SQL for Data Analysis. Acquired (MCSE) with experience and knowledge of Operating system and tools for network administration. Result oriented, self-starter, Customer-Service focused, team player and bilingual in Spanish (speak, read and write) attention to detail and well-organized.
• Ability to learn new technology quickly (through self-), to multi-task and work in diverse fast paced environment with excellent verbal and written communication.
• Well verse in Manufacturing, Marketing, Finance, Retailing and Fast-Food Industries.
• Re-engeniring and identification SaaS

TECHNICAL SKILLS:

Application Development Software: NETSUITE, SalesForce, SQL, METADATA VS3.2, LAWSON, HAGEN, DEVELOPER, DEVELOPER 2000, PROGRESS, COBOL, CRYSTAL REPORT, EASYTRIEVE.

Databases: SNOWFLAKE, TERADATA vs 13.11, ORACLE, SQL SERVER 2008 vs 9.0 & 10.5, NETEZZA, MySQL vs 5.6, DB2, ACCESS 2013, BUSINESS INTELEGENCE.

Analyst tools: RALLY, JIRA, POWER BI, TOAD

Reporting Analytics Software: MICROSTRATEGY, SSIS, SSRS, EXCEL, VISIO, MICROSOFT OFFICE SUITE.

QA Tools: REQUISITE PRO, RATIONAL, SQL, SQL-Plus, ISHARE, SHARE POINT, DB

VISUALIZER, QLICKVIEW, QC, INTERTEST.: Defect Tracking HP QUALITY CENTER, CLEAR QUEST, BUGTRACK.

Platforms: UNIX HP6000, UNIX9000, WIN/SERVER 2000

Administration tools: CITRIX, WIN/2000/03, TERMINAL SERVICES

PROFESSIONAL EXPERIENCE:

Confidential, Hoffman Estates, IL

Sr. Business/Technical Analyst

Responsibilities:

• Researched Oracle-Netsuite CRM & ERP to create STT (Source To Target) for newly created Data Warehouse on the Cloud Snowflake DB.
• Generated SQL queries for manipulation and conversion of data located in several Relational and Cloud Database Platforms.
• Experienced in the Agile environment, created Epics and User Stories to accommodate Product Owner’s requirements for a new designed and consolidated Web and Reporting system for the Finance Dept, Sales and Supply Chain.
• Re-engineer and documented calculations and business rules needed for Reporting Business Intelligence DB.
• Worked independently and multitask on several items on the backlog
• Prioritization and follow through of Backlog on a fast-pace environment.
• As self-starter, created documentation, templates for Business and Technical personnel such as:
• Data Flow Document (DFD)
• Technical Requirement Document (TRD)
• Business Cases
• Functional Business Requirement Document (BRD)
• Analysis and consolidation of old Reports for Microstrategy
• Wrote Test scenarios and test cases for functional, regression and System testing UAT, Deployment
• Manuals.
• Flexible to navigate amongst the business and technical environments
• Supported Operations for fast resolution of Customer Service and data Issues.
• Redesigned and implemented new Change Request process using SharePoint.
• Prioritization and implementation of defects, and Change Management.
• Created and review Project Plan and worked closely with the Project Manager to manage Schedules, Resources, Risks and other issues to reduce Technical impact.
• Coordinated UAT testing and Deployments.
• Attended meeting, Video conferences on changes to the system and distributed status report on key issues.
• Recommendation and institution of best practices on functional and non-functional processes.

Confidential, Lisle, IL

Sr Business/Technical Analyst

Responsibilities:

• Build strong relationship through Service and excellent in-depth requirement through Interview, workshop facilitation, surveys, business process descriptions etc. with all Business Owner to Identified their process and software ownership.
• Used SQL for data analysis and quantification of all active software requiring Password through to Log Tables in SQL-Server 2012, Oracle, Azure.
• Data Analysis of legacy data. Decommission of old activities.
• Developed High Level Flowchart of all processes used by Deployed Software Packages to all servers and peripherals for additional sites.
• Analysis of all active packages and its components that required Password, deployed by SCCM and RUM (SaaS) in-house written Software.
• Analyzed and quantified other types of Software releases used for internal purposes that also required password such as Store Procedures, Script in Power Shell and C#.
• Created Technical andBusiness Functional Requirements, Process Flows, Use Cases, User Stories, Mockups, Mapping Documents, User & Operations Manuals.
• Constantly worked with the Developing and QA team to monitor and communicate with the Manager of high risks and potential issues on each of the modules or Sprints.
• Presentation in Power Point to Leading Management on suggested new Process, by implementing new innovative technology to increase productivity and save money.
• Proposal of strategic new needed technology such as Data Lineage & Governance from different Packages.
• ETL and created Ad-hoc visual reports using Power-Bi.
• Help create skinny tables for Ad-hoc
• Used SOQL in SalesForce to help research data.
• Prioritization and follow through implementation of defect, and change management.

Confidential, Riverwoods, IL

SR Business Analyst

Responsibilities:

• Met with the Business (Product Owners) to define and log all requirement of present and future functionalities on this new feature. Used judgement on different modalities of elicitation.
• Created STT (Source To Target) document to add or change data on the DL.
• Used Visio to depict the Present and Future state of the system, and used PP for presentation.
• Reengineer legacy systems in Main Frame (DB2), Oracle and SQL Server to depict Data Flow.
• Data Analysis to support initiative for leading Management.
• Used Data-Lineage and Data-Governance to acquire preliminary and basic information
• Researched through the Simple Object Access Protocol (SOAP) under the HTTPs architecture to uncover state of the data and acquire the data Real Time for the IVR (Interactive Voice Recognition) and Orion (Caller Verification Screens) systems, based out of Main Frame, Oracle, DW (Teradata) and Event Bus (ESB)
• Created Story Board with new features using Point system to evaluate and prioritize complexity of User Stories.
• Wrote and groomed User stories as well as Spike document in an Agile structure environment, using Rally.
• Wrote SQL on some of the loading queries for ETL, Data analysis and Cleansing.
• Wrote User and Technical requirement for new Reporting document under the BI DB (Teradata).
• Created ETL document using Excel for Enterprise Data Warehouse / Data Mart conversion indicating keys, relation, calculations and dependencies.
• Collaboration with the Product Owner and Peers for the best delivered solutions
• Created implementation document to include Dependencies, Test scenarios, Test Cases and result of UAT testing, Defects and its ramifications.
• Documented project’s best practices and suggested new Process changes based on the feedback or failures at the end of each Sprint.

Confidential, Lisle, IL

SR Business System Analyst / QA

Responsibilities:

• Analyzed data developing Sql for BI SQL Server 2008 R2 and using Network Access DB 2013
• Search and Analyzed RDLs and Packages to make new presentation and recommendation on new Processes.
• Maintain communication with Stake Holders to report progress and roadblocks.
• Analyzed and created Processes to be translated into Technical Requirement for new Development.
• Initiated reorganization of intake and approval process for new requirements and change management.
• Analyzed and created PFD (Process Flow Diagram) for new Processes in the Department on the new implementation of Share Point and Empower.
• Developed Excel-Pivot tables, Used V-lookup to analyzed Sales Data when requested by the stake holders.
• Support for SSRS (Sql Server Reporting System) Reports.
• Assisted other BAs and Developers to accomplish finish product by clarifying the understanding of Requirements.
• Managed Defect and new Request all through implementation
• Operations support through the extensive use of Access created process.

Confidential, Hoffman Est. IL

Business Systems Analyst

Responsibilities:

• Re-engineering of old system process, calculation and data flows, stored in SSIS, SSRS AND PRIMS to create the new BI DB MYSql
• Maintain Project Schedule
• Used Sql to research data and V-Lookup table to clean data for BI tables.
• Agile environment with special attention to each Sprint deliverables.
• Created ETL documents for developers to load a snowflake schema DB in MySql, including its calculations, business rules, dependencies and test plan.
• Created technical requirement document to develop in Microstrategy, one Ad-hoc and 2 User reports.
• Managed UAT and Performance testing.
• Extracted data to load DB for Unit, System, UAT and Performance testing.
• Used JIRA for Project, Defects and enhancement tracking.

Confidential, Oak Brook, IL

Business Systems Analyst / Data Analyst /QA

Responsibilities:

• Created Functional Test Plan document to make sure all functionalities of Tableau were working properly within the report and within the system.
• Wrote complexes SQL to ensure the data loaded to new BI Database during the ETL process, was correct and accurate for Web Application graphs (also in Spanish) for newly developed reports in Tableau.
• Created document detailing Case process and proof of accuracy for Stake Holders.
• Created defect and follow through implementation.

Confidential, Schaumburg, IL

Technical Business Analyst/ QA Manager

Responsibilities:

• Assessed, analyzed and tested in large DB such as Netezza.
• Gather all requirements needed to ensure thorough testing through COMPOSITE, TIBCO, NETEZZA and ORACLE DB.
• Analyzed and discussed with DBA SQL tuning for performance purposes.
• Instructed the team of new software, features, hardware, DB changes etc.
• Created Intranet Page for the Performance Department to keep all document, testing result and keep department informed.
• Demonstrated through Power Point the functions and advantages of a Performance department to BA’s core.
• Used Excel Pivot Table to analyzed & prepare data for Product Owner segmentation, set up of all test data and view the Final Analysis and improvement comparison documents between releases.
• Managed and Wrote all under a mix of Agile/Waterfall Methodology and BI techniques for:
• Non-functional, Systems requirements and Gap Analysis.
• Daily Scrum meetings.
• Data Analysis to substantiate and create Usage Model, and help Stakeholder with results.
• Architectural, physical and logical view of new release.
• Create Test Plan Strategy, Test Data and Use Cases for automated and manual testing such as;
• Smoke, Baseline, Loads,
• Successfully Implemented procedure and templates needed for the department to maintain stability and consistency in its documentation using Share Point.
• Directed Performance improvements that benefited the functional teams on each release.
• Power Point presentations to upper Management demonstrating improvements to resources benefiting the Customer and the Sales team.
• Manage all Defects using HP Quality Center for QA. Participated in Change Management review.

Confidential, Bowlingbrook, IL

SR Business System Analyst /Lead

Responsibilities:

• Responsible for depicting current and future state of the system by creating PFD, DFD
• Interview business area to identified issues and recommend improvement, new Processes and Consolidation.
• Developed User Stories for interface modules and new reports
• Created ETL document to upload data to BI tables for Data Mart for Accounting & Payroll area
• Attended daily Agile Scrum meeting to mitigate roadblocks and maintain Sprint date goals
• Directed rest of the BA’s to ensure clarity and timeliness of the project.
• Communicated progress and resolutions to Stake Holders and upper Management.
• Wrote SQLs to select and analyzed data for testing from SQL Server / Access DB.
• Developed test cases & scenarios.
• Used Excel V-lookup function to help analyzed and cleans data
• Demonstrated analysis of data through the use of Excel Pivot Table and Dash board for visualization purposes.
• Wrote new reports, using Crystal Reports.
• Validation of System, Regression and UAT testing.
• Creation of Traceability Matrix.
• Participated in application releases evaluation to ensure specification accuracy and quality control prior to deployment.
• Support and resolution of production issues.
• Managed all defects development and implementation across functional teams.

Confidential, Gurnee IL

Business Process Analyst/Head of QA

Responsibilities:

• Web design assessment for security, such as customer information saving and authentication, order accountability, queue timer and logs.
• Revised UML modeling techniques to ensure no gaps in the new system Business Events, Use Case, Scenarios and Data Flow entities for Object Oriented environment such as Java.
• Used Visio to document legacy system data flow, bridging to new environment as well as new functionalities.
• Evaluated together with IBM the Rational Suites new release capabilities to be incorporated, thus designing the new approach for the new system Defect Tracking and Change Request Management process. User Acceptance Testing and trained affected user groups.
• Generated Ad-hoc reports providing Performance Metrics to senior management to assist with their planning using SQL in very complex queries (using left and right Joins) and Crystal Report
• JAD section with stakeholder on site and on the Web.
• Performed data analysis using Excel.
• Creating SQL queries to help client with Marketing Solutions using Oracle Data Warehouse.
• Used MS project to keep track and determine time and resource in accomplishing milestones in Waterfall environment.
• User and junior member on site and on the Web of testing approach, new tools such as Clear Case, Requisite-Pro and Clear Quest.
• Created Traceability Matrix between Project requirement and Use Cases.
• Performed maintenance on Main Frame (COBOL) to update and maintain its functionality while bridging with new technologies.
• Used Cobol, TSO/ ISPF, SDSF, DB2, JES2 to maintain, access and test new developed functionalities on the legacy System