SUMMARY

• Creative Work Business Analyst/BI Analyst, Database Application Developer and Report Application Developer with passion for winning and working on complex projects with zeal, determination and an indomitable spirit of coming out victorious.
• Demonstrated ability to interact with a spectrum of industry professionals, graduates from leading business schools and industry experts to achieve immediate targets with an eye on long term results.
• Highly flexible team player/leader with a good understanding the latest technology.
• Excellent listening and communication skills necessary for a comfortable working relationship with the clients/users.
• Expert in coordinating changes to computer databases, testing and implementing the database and applying knowledge of database management systems.
• Responsible for planning, coordinating and implementing security measures to safeguard the computer databases.
• Industries: Banking, Financial, Security, Manufacturing, Gas Billing, Utilities, Healthcare, Education, Assessment

TECHNICAL SKILLS

Programming Languages and Tools: EPIC 2015,Clarity Database, SRSS (Report Builder 2.O) Oracle 10g, Power BI, Access 2010,Crystal Reports all versions, Business Objects 4.1,SSRS, SSIS, Oracle Apps ERP Manufacturing, OBIEE, PL/SQL,PHP 5,Visual Basic 5.0/6.0 ASP.NET, Discover 3.0, TFS, ASP.NET, Oracle 2000, Oracle Forms 4.5,Oracle PL/SQL, Oracle Reports 3.0/6i, Oracle Web DB Reports and Forms/Portal 9iAS, Oracle R12 Cloud HCM, OTBI Reporting, DB2, SQL plus 8.1.7

HR Apps: EPICOR version 9 and 10, Dayforce 6.45 and 7.46 version (Ceridian),Lawson 9,Infor LBI 9.0.1.12.1241 , INFOR Reporting Services Version 10 - 4-4-0-240, SMART NOTIFICATION Version 10.4.0.0.132

Healthcare: EMR—EPIC 2015

Manufacturing: Oracle

Testing: HP Quality Center

Scripting Languages: Java and JAVA Script, SQL, PL/SQL, HTML

Databases: SQL Server 2005, Access, Oracle 7.3 and 10g, R12 database

Operating Systems: Windows 95/NT, Windows 3.1, Windows 2000, XP,UNIX

Tools: Actuate 7.0,TOAD 9.0.1, Crystal Reports 7.0, 10 and 11.0, ActiveX, QMF for Windows(Query Builder DB2)6.1

Change Control: VSS 6.0, TFS,PVCS Version Manager 6.0.12

Management Tools: PowerPoint, Microsoft Project, Front Page 2003 and Visual Source Safe 6.0.

Software: Office 97, 2000 and 2003, FTP WSPRO

Hardware: Pentium Micros

BI: OBIEE, Tableau 9.3, Power BI

PROFESSIONAL EXPERIENCE

Confidential, Pittsburg, PA

Data/Business Analyst

Responsibilities:

• PeopleSoft Application 8.57/8.58 HCM and Finance module Develop and maintain
• Create SQR Queries and Reports
• OTBI/OBIEE
• EDI transactions 834
• Infor Demand planning and forecasting.
• Created Benefits and Leave of Absence Reports.
• Create BI Reports
• Data Mapping, Data modeling and data validation using inbuilt Reporting system.
• Developed Benefit, Salary, Job Reports Charts And Graphs
• Compensation, Comparison, Termination and Active Reports
• Worked on system maintenance, issue resolution, and end-user training.
• Performed analysis of research groups and business processes and functional requirements. Applied technical and business knowledge to analyze requirements.
• Gathered business requirements for different research areas.
• Design prototype based on functional specifications
• Review specifications with team/users
• In corporate feedback into functional specifications
• Testing (primary debugging)
• Worked on internal Incident ticketing system.

Confidential, Warrendale, PA

Analyst

Responsibilities:

• Oracle HCM Cloud Application R12/R13 Develop and maintain Tables and Procedures
• Create Reports using Subject Area Modules
• Created Location specific network wide dashboard with new components and Reports.
• Data Mapping, Data modeling and data validation using inbuilt Reporting system.
• Developed Benefit, Salary, Turnover, Audit Reports Charts And Graphs
• Compensation, Comparison, Termination and Active Reports
• Worked on system maintenance, issue resolution, and end-user training.
• Integration of different systems into Oracle R12. Mapping tables and configuration.
• Performed analysis of research groups and business processes and functional requirements. Applied technical and business knowledge to analyze requirements.
• Gathered business requirements for different research areas.
• Design prototype based on functional specifications
• Review specifications with team/users
• In corporate feedback into functional specifications
• Testing (primary debugging)
• Deployment using internal ticketing system.
• Created Reports using Access database. User web knowledge finding Reports and queries. Automated process for HCM-ERP system as daily feed

Confidential, Pittsburg, PA

Data Analyst

Responsibilities:

• Oracle HR Application R12 Develop and maintain Tables and Procedures
• Create Reports output in CSV
• Used Power View, PowerPivot, Power Query, Power Map and Power BI
• Created Location specific network wide dashboard with new components and Reports.
• Data Mapping, Data modeling and data validation using inbuilt Reporting system.
• Created Reports in Oracle 6i version using HCM database.
• Installing Oracle Reports6i
• Performed upgrades of the different database on SQL Server and Oracle.
• Managing users and security via Application
• Install Oracle Patches as well as Windows patches.
• Monitoring database performance
• Developed Turnover Reports, Charts And Graphs
• Census, Compensation, Comparison, Termination and Active Reports
• Worked on system maintenance, issue resolution, and end-user training.
• Performed analysis of research groups and business processes and functional requirements. Applied technical and business knowledge to analyze requirements.
• Gathered business requirements for different research areas.
• Design prototype based on functional specifications
• Review specifications with team/users
• In corporate feedback into functional specifications
• Creating and Publishing Reports on LBI Dashboard
• Testing (primary debugging)
• Deployment using internal ticketing system.
• Created Reports using Access database. User web knowledge finding Reports and queries. Automated process for HR-ERP system as daily feed by extracting file in a text delimited format using pipe | as a delimiter

Confidential, Pittsburg, PA

Business/Data Analyst

Responsibilities:

• Worked on Infor Applications.
• SQL Server 2012 Queries and Stored Proc, Queries. Develop and maintain Tables and Procedures
• Create Reports output in CSV
• Power View, PowerPivot, Power Query, Power Map and Power BI
• LBI Dashboard components and Reports.
• Created Location specific network wide dashboard with new components and Reports.
• Data Mapping, Data modeling and data validation using inbuilt Reporting system.
• Created Crystal Reports 2013 version using HCM database.
• Developed Turnover Reports, Charts And Graphs
• Compensation and Comparison Reports
• Created and wrote Termination and Active Reports
• Developed and created Turnover Reports and Employee Scorecard Metrics.
• Worked on Board of Directors
• Performed analysis of research groups and business processes and functional requirements. Applied technical and business knowledge to analyze requirements.
• Gathered business requirements for different research areas.
• Design prototype based on functional specifications
• Review specifications with team/users
• In corporate feedback into functional specifications
• Creating and Publishing Reports on LBI Dashboard
• Testing (primary debugging)
• Deployment using internal ticketing system.
• Cogito Reporting team using Clarity database. User web knowledge finding Reports and queries. Used Clarity Data Dictionary for load frequency and load type as well as derived tables.
• Reports:
• Compensation Adjustments
• Automatic $0.20 Increase Report for Sales Associates
• Employee Roster
• Below Min or Above Max of Pay Range
• All Terminated Employee Roster

Confidential, Pittsburgh, PA

Business/Data Analyst

Responsibilities:

• Worked on EPIC 2015 Applications and Clarity.
• Developed Dashboard components.
• Created Location specific network wide dashboard with new components and Reports.
• Development of Data Mapping, Data modeling and data validation using inbuilt Reporting system.
• Created Crystal Reports 2013 version using Clarity database.
• Attended Epic training for ADT.
• Worked on different modules/Hyperspace/patient care/chart scheduling /appointments /Registration and ADT
• Performed analysis of research groups and business processes and functional requirements. Applied technical and business knowledge to analyze requirements.
• Gathered business requirements for different research areas.
• Worked on support requests including data changes as well as creating reports on the server.
• Data collection, data analysis, documentation and presentation.
• Integration of multiple systems on development projects.
• Working with the users to design, analyze, and document the system's technical requirements.
• Used Cherwell Service Management for ticketing system as well as Rally for internal ticketing system.
• Cogito Reporting team using Clarity database. User web knowledge finding Reports and queries. Used Clarity Data Dictionary for load frequency and load type as well as derived tables.
• Reports:
• Discharge Volume Reports
• Birth Statistics Reports
• ED Charges Report
• Patient wait Time
• Open Slots Daily and many more

Confidential, Pittsburgh, PA

Data Analyst

Responsibilities:

• Worked on DBMS (Genetics Research Cleft) Applications.
• Development of Data Mapping, Data modeling and data validation using inbuilt Reporting system.
• Used BI component SSIS to transform and export data from different data sources such as excel and flat file.
• Performed analysis of research groups and business processes and functional requirements. Applied technical and business knowledge to analyze requirements.
• Gathered business requirements for different research areas.
• Worked on support requests including data changes as well as creating reports on the server.
• Worked on Onboarding, requirements gathering and data analysis from the Business side Certification.
• Data collection, data analysis, documentation and presentation.
• Integration of multiple systems on development projects.
• Working with the users to design, analyze, and document the system's technical requirements.
• Clinical Reports:
• Developed Clinical Reports
• Developed Reports using Crystal 11
• Worked on Data Export Definitions and Workflows
• Ran Background Tasks and monitor Backlog Jobs
• Worked on variables and module to track data from manual device and automated entry.
• Form submission process
• Worked on System

Confidential, PA

Analyst

Responsibilities:

• Worked on HCM (Human Capital Management) Workday, Dayforce 6.45 and 7.46 version (Ceridian) solutions.
• Development of HR Benefits and Payroll reports using inbuilt Reporting tool.
• Worked on CATs feed uploading punches using FileZilla.
• Support business operations and participated in system development projects
• Integration of multiple systems on development projects.
• Worked on On boarding, requirements gathering and data analysis from the Business side Certification.
• Data collection, data analysis, documentation and presentation.
• Analysis and testing of software upgrades and patches, assists with testing of new releases
• Technical support for supported systems, resolving routine issues and problems
• Enhance productivity researching software and hardware improvements
• Manage and develop a systems and integration test strategy that accurately meets business use cases
• Regression testing
• System flows and integration points across multiple applications
• Communicates with vendors to resolve technical issues and creates internal supported system documentation
• Helps determine technical needs of supported systems and providing information to leadership
• Meetings with stakeholders and IT personnel to identify solution design and application capabilities
• Used HP Quality Center for testing scripts as well as in-house apps
• Quality assurance software and interaction with customers
• Audit Reports:
• Developed Audit Reports for New Hires, Term and LOA’s
• Testing XML script for the HR Export and data validation.
• Developed Reports using Crystal 11 on Employee qualifications, Salary administration and Absence tracking
• Worked on Data Export Definitions and Workflows
• Ran Background Tasks and monitor Backlog Jobs
• Worked on Timesheet module to track time entered from handheld device using CAT’s feed and audit manual entry.
• Form submission process for new Hire and Status Change
• Worked on Clock Devices and Badge entry systems
• Worked on System Admin module to enter new Users and assign roles

Confidential, PA

Application Developer

Responsibilities:

• Worked on ERP HR System Epicor HCM (Human Capital Management) and iVantage (old version of HCM) solutions.
• Development of HR Benefits and Payroll reports using Crystal and SSRS and Access
• Designed and developed UMCD application using Access.
• Report development and editing scripts inbounding data from users and format out bounding it in the Report format.
• Worked on Onboarding, requirements gathering and data analysis from the Business side Certification.
• Training Users and debugging workflow.
• Data collection, data analysis, documentation and presentation.
• Designed and developed SSRS, SSIS, Crystal Reports using Crystal 10 and 11.
• Generated Reports in different formats.
• Maintained and created Tables, SQL Query working on SQL Server Database 2005 and 2008.
• Supported with administrative, systems, and business operations problems, Participated in
• Business Objects 4.1 Installation, Upgrade, Deployment
• Processing Receipts/Direct Shipments and Generating Advance Shipment Notifications
• Invoice Resolution & Payment and order management
• Microsoft Excel for analysis
• Database:
• Core employee information, job, pay and status information
• Employee qualifications, Salary administration
• Benefit administration, Absence tracking
• Standard reporting, Candidate tracking
• Self-Service — employee/manager, Employee data history tracking
• Flexible report-writing tools, Front-end customization tools
• Intuitive user interface, Integrated talent management
• Automated open enrollment, Knowledgeable and timely support
• Dependent Age Benefits Report

Confidential, PA

Consultant

Responsibilities:

• Worked on Identity Management (SailPoint) Onboarding, requirements gathering and data analysis from the Business side Certification.
• Data collection, data analysis, documentation and presentation.
• Used TOAD to write scripts as well as procedures and functions.
• Used Visio for data mapping, data design, and process flow.
• Worked on supporting multiple applications.
• Developed Metrics Reports using Excel.
• Created Reports running Adhoc query using SQL.
• Created Data Mapping and Data designing using Visio 2010.
• Developed test cases, test plans and test scripts for single and multi-tier applications.
• Worked with users to identify operational business requirements with sufficient detail and clarity to allow IT solution to development.
• Support technical group with administrative, systems, and business operations problems, Participated in system development projects
• Integration of multiple systems on development projects.
• Define system process improvement, quality assurance, as well as interaction with customers
• Performed analysis of client business processes and functional requirements. Applied technical and business knowledge to analyze client requirements.
• Gathered business requirements for different web/cloud applications from different business areas.
• Worked on support requests including data changes as well as creating reports on the server.
• Working with the users to design, analyze, and document the system's technical requirements.
• Worked on developing adhoc reports.

Confidential, PA

Consultant

Responsibilities:

• Responsible for data collection, data analyst, documentation and presentation.
• Analysis of client business processes and functional requirements.
• Developed BWR application using C# as a front end and Access database as a backend.
• Created test cases and test plans for different applications. Worked as QA testing plans for different applications.
• Used different Testing tools to test scripts as well as processes
• Maintained and created Tables, SQL Query.
• Maintenance of SQL Server jobs and Web Server jobs. Working with users to analyze and document the systems’ technical requirements.
• Order management and pricing. Designed and developed ASP.NET Application.
• Worked with clients to identify operational business requirements with sufficient detail and clarity to allow IT solution to development.
• Analysis of client business processes and functional requirements.
• Applied technical and business knowledge to analyze IT requirements.
• Worked on developing SharePoint HR pages.
• Worked as QA testing scripts and validating results.
• Worked on support requests like data changes as well as creating Reports on the server.
• Generated Reports/Metrics in Excel and well as Pivot for headcounts.
• Used Visio for Data Mapping and Data designing.
• Involved in data conversion from Excel and Text data to Access 2013.
• Worked on support requests like data changes as well as the password reset on the server.
• Support technical group with administrative, systems, and business operations problems, Participated in system development projects
• Integration of multiple systems on development projects.
• Define system process improvement, quality assurance, as well as interaction with customers