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.
• Has 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.
• Has experience in Insurance and mortgage industry including financial and trend analysis, training, and reporting and project management functions.
• Exceptional experience in dealing wif 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 wif 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 wif 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 wif 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, Merchandising operations

Responsibilities:

• Communicated TEMPeffectively 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 wif 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 wif Business Analysts & Business Managers to understand the requirement
• Worked wif 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 wif 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 wif 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 wif the QA team.

Confidential, Richardson, TX

Business System Analyst

Responsibilities:

• Analyzed the requirements for new reports and changes requests for existing reports
• Gatheird 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 wif 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 wif system administrator on data model and relationship between tables
• Validated customer support/ call center reports against database data
• Coordinated and worked wif IT development and quality assurance team members.
• Created procedural documents such as user guides and process flow diagram.
• Facilitated meetings and coordinated wif 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 wif 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 wif 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 wif project tracking and scheduling requirements, during the project lifecycle
• Supported the team in efforts to establish collaborative partnership wif key stakeholders. Leveraged problem solving skills to help ensure project plans deliver on intent.
• Reviewed and processed subcontractor invoices for approval wif 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 wif audit and other team members as required.

Confidential

Mechanical Engineer Intern

Responsibilities:

• Provided technical input, in line wif project requirements, into technical studies and Basis of Design. Ensured a smooth and TEMPeffective transfer of data and information between Contractors and between Contractors and the Company.
• Identified, created and adopted appropriate mechanical & HVAC machinery engineering standards, wif 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 wif the Piping and Layout definition and wif the related follow-on activities.
• Participated in process safety reviews activities.