SUMMARY

• 5+ years of experience in the field of Business analysis, Reports analysis (Decision Support Reports), Business Intelligence Analysis and Business management skills following Agile development method.
• Have working knowledge of reporting software development life cycle's (SDLC) phases like requirement specification, software designing and development, testing and maintenance.
• Extensive experience in analyzing Business Requirements and writing report Specifications.
• Have experience in Insurance and mortgage industry including financial and trend analysis, training, and reporting and project management functions.
• Exceptional experience in dealing with various databases and data sources like ERP systems, CRM data, Oracle, SQL Server, MS Access, and Flat files.
• Maintain a strict validation procedure to ensure that the system maintains its data integrity, retrievable, reproducibility and control of personnel access.
• Data warehousing, RDBMS, Schemas (like star & snow flake), Fact and Dimension tables.
• Identify SQL Server tools, query data from single and multiple tables, manage databases & tables.
• Proficient working with Stored Procedures, Joins, Triggers, Cursors, Functions and Views in SQL.
• Extract data from various data sources/applications/systems & linking/synchronize data in reports.
• Attended various internal training programs on quality management system in compliance with department rules and regulations.
• Knowledge of Test Cases and Usability cases to validate the business process.
• Proficient in business process documentation and end - user training/knowledge transfer.
• Prepared process maps and documents with the help of Visio & Excel.
• Prioritize the tasks, provide solutions and performance tuning.
• Automate report refresh/execution and publish/distribution.

TECHNICAL SKILLS

Office Tools & Operating System: MS Word, MS Excel, Advanced Excel, PowerPoint, Visio, Outlook & MS Project, Windows 2000/NT/XP/7/8/10, UNIX, Linux.

RDBMS: Oracle, MS Access, MS SQL Server

SAP Business Objects Reporting & Analytics: Business Objects 3.x, Webi Reports, Designer, BI launch pad & BI workspace, Universe Design Tool (UDT), Central Management Console (CMC) & Tableau

Customer Support Reporting: Genesys Infomart & Genesys Interactive Insights

Prog Languages: SQL, PL/SQL & SAS Base (including advanced SAS concepts Proc SQL, Macros) & Programming in R

Analysis Techniques: Linear & Logistic Regression, Factor Analysis, Cluster Analysis, Decision Trees, Time Series Forecasting

Other Skills: Analytical Thinking & Planning, Problem Analysis, Quantitative skills, Time Management, Reporting, Documentation and Specification, Interpersonal Communication, Requirements Analysis, Design Skills, Manufacturing Methods and Procedures, Process Improvement.

PROFESSIONAL EXPERIENCE

Confidential, Boca Raton, FL

Data Analyst

Responsibilities:

• Communicated effectively in both a verbal and written manner to client and merchandising team
• Completed documentation on all assigned systems and databases, including business rules, logics & processes
• Created Test data and Test Cases documentation for regression and performance
• Developed intermediate business knowledge of the functional area and processed to understand the application of data information to support business functions
• Identified Opportunities for Improvement (OFI), recommended and implemented, as applicable, processed improvement plans in collaboration with identified departments
• Leveraged a basic understanding of multiple data structures and sources
• Maintained and assisted in the development of moderately complex business solutions, which included data, reporting, business intelligence/analytics
• Performed hands-on data extraction and collection; analyzed data using MS Access (SQL) & Excel supporting several functional areas; provided forecasting reports and recommendations
• Facilitated requirements gathering and analysis as a part of client implementation lifecycle; completed corresponding process analysis, test cases, and documentation
• Performed as a functional lead to audit, assess, and expose business loss areas and recommend improvement opportunities to streamline operations and reduce overall shrink.

Confidential, Houston, TX

Business System Analyst

Responsibilities:

• Worked closely with Business Analysts & Business Managers to understand the requirement
• Worked with database team and done the fit gap analysis
• Prepared functional, technical specification documents, template, mockups, forecast reports and charts
• Involved in creating complex Agent performance and Employee Matrix reports
• Scheduled Reports to email the report copies to Business users in various formats as Excel and PDF
• Created complex pre-defined conditions and measure objects in Universe
• Modified GI2 universe and developed custom BO universe for IVR
• Developed several Call Center reports using Infomart and IVR database data
• Developed custom reports using Genesys Infomart and other sources like WFM & CRM
• Monitored ETL jobs and data loads, compared data between ICON databases and Infomart
• Initiated JAD (Joint Application Development) sessions with the business team and IT team
• Involved in creating activity diagrams using Microsoft Visio.
• Involved in designing the database schema and conceptual data model for Global customer Enterprise Data warehouse
• Used SQL to query the database, to retrieve data and to verify the values displayed in the report
• Created Metrics and Key Performance Indicators (KPI) as per the company business rules
• Set the goals and alerts in reports as advised by the management
• Tested and Validated report formulas data and calculations
• Involved in developing dashboards for business users and daily monitoring Score cards using Tableau
• Involved in setting up formal user group sessions with the corporate sponsor of the project to regularly apprise them of the development effort and success against timelines
• Assisted in writing test plans and test cases in coordination with the QA team.

Confidential, Richardson, TX

Business System Analyst

Responsibilities:

• Analyzed the requirements for new reports and changes requests for existing reports
• Gathered business requirement specifications from the users
• Created Functional & Technical specification documents
• Provided technical support and helped business users to access custom customer support system
• Worked with Genesys Infomart database (Call Center Data base)
• Developed several Call Center reports using Infomart and IVR database data
• Developed custom reports using Genesys Infomart and other sources like WFM & CRM
• Created several ad-hoc call center reports using SAP Business Objects Web Intelligence tool
• Created charts in Webi reports and monitored reports scheduling
• Created metrics, KPIs and complex reports
• Worked with system administrator on data model and relationship between tables
• Validated customer support/ call center reports against database data
• Coordinated and worked with IT development and quality assurance team members.
• Created procedural documents such as user guides and process flow diagram.
• Facilitated meetings and coordinated with business team and IT team
• Tested and validated the changes to the Infomart application data

Confidential, Dallas, TX

Project Analyst

Responsibilities:

• Developed project objectives by reviewing project proposals and plans; conferring with management.
• Determined project responsibilities by identifying project phases and elements; assigning personnel to phases and elements; reviewing bids from contractors.
• Maintained project data base by writing computer programs; entering and backing up data.
• Prepared internal and external reports pertaining to job status; Plan to prevent problems and resolve any emerging ones
• Negotiated terms of agreements, draft contracts and obtain permits and licenses; Analyze, manage and mitigate risks; Ensure quality construction standards and the use of proper construction techniques
• Undertook site checks to monitor progress, monitoring budget report and tracked inventory.
• Interfaced with business units to ensure they timely provide information necessary to deliver projects relating to business units & to ensure they receive timely information regarding projects impact on business
• Supported the scoping team and other project resources with project tracking and scheduling requirements, during the project lifecycle
• Supported the team in efforts to establish collaborative partnership with key stakeholders. Leveraged problem solving skills to help ensure project plans deliver on intent.
• Reviewed and processed subcontractor invoices for approval with Sr. Project Manager Involvement. Supervised and managed the project plans using project management tools. Prepare reports on projects specifically assigned by management
• Uploaded all required client documentation in client portals and files corporate files. Worked with audit and other team members as required.

Confidential

Mechanical Engineer Intern

Responsibilities:

• Provided technical input, in line with project requirements, into technical studies and Basis of Design. Ensured a smooth and effective transfer of data and information between Contractors and between Contractors and the Company.
• Identified, created and adopted appropriate mechanical & HVAC machinery engineering standards, with due consideration of the environmental and logistic conditions of the facilities HVAC Plant Design, including Utilities and Mechanical equipment’s.
• Provided technical support on the engineering, constructability, operation and maintenance of mechanical & HVAC equipment and systems.
• Assisted on mechanical & HVAC equipment standardization, availability, and sparing philosophies.
• Assisted with the Piping and Layout definition and with the related follow-on activities.
• Participated in process safety reviews activities.