SUMMARY

• Accomplished information technology professional with 6 years of experience in all aspects of developing, implementing and managing business analytics and operational processes to support cross - functional business units.
• Direct customer facing and daily interactions with them to meet their expectations.
• Extensively involved in integrating and transforming institutions’ data into easy-to-use dashboards and KPI reports that help to illustrate performance improvement opportunities and ROI. Identified, analyzed, defined and documented current and future business process models, business requirements, data and technical requirements and created UAT scripts.
• Managed support exceptions/escalations and where appropriate, creates new or refines existing business processes.
• Recommended changes and enhancements to improve business and data optimization via modeling and analysis.
• Technical Subject Matter Expert (SME) in data collection and analysis, data interpretation and visualization, data mining, utilization and quality reports, standard financial and resource utilization KPI reports for performance improvement using SQL, MS Excel and SaaS (Salesforce); Graphical representation to multiple business units.
• Key person in gathering Business and Functional Requirements, UAT, modeling Businesses Processes, data modeling and mapping, preparing training manuals and knowledge transfer manuals and agile technology.
• Excellent communicator fast learner and proactive planner with the proven ability to prioritize assignments manage multiple tasks simultaneously and accustomed to work effectively under pressure remaining calm.

TECHNICAL SKILLS

Operating Systems: Windows/NT/2003, Mac OS

OLAP/Reporting: SalesForce, SQL Server Reporting Services, MS-Excel Power Pivot

ETL: SQL Server Integration Services, SQL Server DTS, Informatica

Languages: FORTRAN, C, HTML, UNIX, SQL, PL/SQL, MATLAB

Database Systems: DB2, Oracle RDBMS 9i, SQL Server, MySql

Utilities: Toad, SQL Developer, QueryAnalyser, WinSql, R Tool

PROFESSIONAL EXPERIENCE

Business Analyst

Confidential

Responsibilities:

• Directly interacted with business/customers on daily basis for Requirement Gathering and Analysis, organize meetings with Business, Development and Quality Engineering team for requirement gathering and work product review.
• Created and modified procedures to solve complex technical as well business related problems and documented the same.
• Constantly worked and negotiated with cross function teams to work as a team to achieve customer objectives.
• Provided and improved relationship and communication with various business teams to acquire knowledge necessary to manage the Service Level Manager IT process better so that the customer expectations are continually met.
• Have established a commitment to delivering exceptional customer support with a high level of professionalism and responsiveness by working accurately and precisely and received appreciation from the customers for the quality of the work.
• Wide knowledge and extensive usage of AGILE technology throughout the project management.
• Responsible for providing ongoing technical and production business support for 35 members.
• Monitors service performance to SLAs and ensures organizational and leadership visibility of SLA performance and problem areas.
• In control for ensuring Operational Support Teams are consistently delivering high quality service supports.
• Managed support exceptions/escalations and where appropriate, creates new or refines existing business processes.
• Recommended changes and enhancements to improve business and data optimization via modeling and analysis.
• Extensively involved in integrating and transforming institutions’ data into easy-to-use dashboards and KPI reports that help to illustrate performance improvement opportunities and ROI.
• Identified, analyzed, defined and documented current and future business process models, business requirements, data and technical requirements and created UAT scripts.
• Prosperous formal and informal interaction with clients to help breakdown of business details into technical implementation (JAD Sessions) and had been part of several successful regular and emergency bug fixes, large and small enhancements and application migrations.
• Responsible for Root cause analysis, Data validation and Data trend analysis and developed many complex reports that runs interfacing multiple databases and data warehouses in SQL and Teradata SQL.
• Communicated business expectations to cross-functional development teams which include marketing, development, and product management and delivered 100% client satisfaction across multiple dimensions.

Lead Data Analyst

Confidential

Responsibilities:

• Worked on two major products of the company, Crimson Market Advantage and Crimson Continuum of Care.
• Managed and mentored technical/functional guidance to a team of six Data Analysts to make sure that the team meets required quality for all the deliverables as specified in project requirements.
• Extracted and manipulated large customer/health care service providers' data sets using SQL and created multi-dimensional visualizations/dashboards/pivot tables/charts and used advance functions in MS Excel.
• Provided technical expertise and support in data analysis and data reporting.
• Applied business logics and provided the SQL scripts for ETL process to represent the clients’ data in the web application as per the requirements.
• Applied Reverse Engineering technology to create a database model of the databases and understand the relationship between the database elements it order to have better insight of the Web Application.
• Strong experience in constructing complex Stored Procedures, Functions, Triggers.
• Experience working in SQL Server Reporting Services (SSRS) and SQL Server Analysis Services (SSAS) for data research and data reporting.
• Worked extensively on Power Pivot in MS Excel and Salesforce for reporting, resource and utilization planning respectively.
• Handled Mass Migrations for over 150 clients with a team of 15 members.
• “Opportunity Analysis” was a major contribution during my role as a Data Analyst that enabled the Dedicated Advisors in the US to find new areas of improvement and provided actionable data to the clients.
• Basic knowledge in R tool for interpretation and presentation of data and done analysis using R.

Data Analyst/Business Analyst

Confidential

Responsibilities:

• Performed Business Process Modeling using Visio.
• Translated the business needs into system requirements, communicating with the Business Analyst on a non-technical level and with the System Analyst on a more technical level.
• Retrieved large data sets from MS SQL Server, Mainframe and developed MS Access databases, ad hoc reports and queries.
• Used MS Access, MS Excel, MS PowerPoint, Louts Notes, MS Word, MS Visio to extract, analyze, manipulate and present data findings.
• Coordinated with billing system Managers and support staff to clean up duplicate billing system user IDs in billing systems and User Base.
• Cleaned and imported data into User Base to correct duplicate data from the Judiciary web application.
• Created root cause analyses, histograms to determine cause of quality and performance issues.
• Presented data findings and data analysis presentations in graphs, charts, pivot tables, pivot charts and PowerPoint presentations.