SUMMARY:

• Accomplished, self - motivated, process-driven Business Analyst, Data Analyst & quality lead, and backend developer with 10+ years of experience in various domains like Insurance (P&C), Banking, Supply Chain Management.
• Worked in various projects related toData Modeling, System/Data Analysis, Design and Development for both OLTP and Data warehousing environments.
• Seasoned professional with perfect business judgement, experience in evaluating business trends, transforming customer data into actionable,data-driven insights to improve business.
• Good exposure to the following internal P&C insurance systems: The Agency Portal, Electronic Document Management(EDM), POS, Policy Builder and claims Life cycle using “RISKMASTER Accelerator” a CSC product.
• Hands on experience in Business Process Modelling(BPMN) using AgilPro software.
• Good understanding on Insurance & Reinsurance underwritings and Solvency II framework.
• Hands on experience in Guidewire Policy Center v7.0 Policy-Administration: 1year 6 months.
• Thorough understanding of Predictive and Descriptive Analytics, Data Mining concepts - clustering, classification, regression analysis, neural networks, probability, statistical modeling, time series analysis, forecasting, and hypothesis testing.
• Certified ‘Business Analytics Professional” from University of Pennsylvania.
• Experienced in Web, Digital Marketing using IBM digital Analytics and Google Analytics.
• Demonstrated good documentation, report writing and presentation skills.
• Subject Matter Expert (SME) in ‘Agency Compensation - (P&C Insurance)” and Supply Chain Management (Forecasting and Procurement).
• Hands on experience in SAS (Reporting & Analytics using JMP Pro), SQL, DB2, stored- Proc, ETL, Tableau Reporting, MS Excel, MS Project and Visio.
• Well versed with quality center tools like Peregrine, HP quality center 9.0 and HPSM.
• Experience in writing functional specifications (FSD), Business Requirements document (BRD) and user stories for reports, interfaces, extensions and customizations.
• Software Development Life Cycle (SDLC) experience including Requirements gathering, Planning, Designing, Development, and Testing along with after implementation support.
• Having strong team building, rational thinking and management skills with proficiency in applying Agile Methodologies (TDD & BDD approach) to maximize the level of productivity.
• Creative, Good interpersonal skills, Communication skills, Quick adaptability to new technologies, Effective leadership and an outstanding team player.

TECHNICAL SKILLS:

Programming /Scripting Language: SAS, JMP Pro, EZTRIEVE, COBOL, PL/I, JCL, Selenium

Database: SQL Server, DB2, Oracle and IMSDB

Operating System: MVS/XA, OS/VS1, VM/CMS, Windows 10

H/W platform: Windows, OS/390, Stratus continuum

Tools: ETL (Power Center), Tableau, Google Analytics, IBM SPSS, DataFlux studio, File Manager, Control-M, Control-D, MS Project, Excel and CA ERwin

Middle Ware: MQ Series, FTP and MDT

PROFESSIONAL EXPERIENCE:

Confidential, Normal, IL

Responsibilities:

• Leading a team of three SAs to collect and understand the complex, multi-dimensional data.
• Handling multiple requirement analysis/JAD sessions with ISU admin teams and Directors.
• Performing data scrubbing, data profiling and analyze results using statistical techniques and provide business reports.
• Identify, analyze, and interpret trends or patterns in the complex archived data sets.
• Filter and review reports, and performance indicators to locate and correct core problems.
• Maintaining project documentations, reviewing SLA and time card.
• Used IBM analytics tool for online data collection and creating reports like: Audience reporting, Benchmarking reports, performance reports and conversion reports.
• Helping PM and research director to understand KPI metrics and event tracking.
• Generate and manage Weekly, Monthly KPI Metrics Dashboards for the Office of the Provost using Excel and Tableau.

Environment: Windows 10, Android OS, SAS, SQL, DB2, Tableau, IBM web analytics tools, MS Excel 2010, MS Word, MS Outlook, PowerPoint, MS Project, Test Director and SharePoint.

Confidential, Bloomington, IL

Lead - Master Data Management and Analytics

Responsibilities:

• Worked collaboratively with our clients to develop the business process roadmap for the ARM (Asset Risk Management) project.
• Used ETL tools to collect the data from HPAM, ERP and Mainframes Systems, and advanced with standardization, aggregation, reporting and Analysis of data.
• Managed client engagements and led teams in all aspects of design and delivery of information solutions - including Data Quality, Data governance, Analytics, and Reporting.
• Created and implemented ER models and dimensional models (star schemas).
• Generated SQL scripts and assisted DBA’s in the development of physical database.
• Worked with DBAs to perform complete model compare using the DB and existing models
• Identify, analyze, and interpret trends or patterns in complex data sets and fix SAS reports
• Defined and developed the business rules to handle the sensitive data (SPI, PI and NPI data) through encryption in the test environments (SDIT).
• Hands on with the workflow-orienteddata governance software from SAS to create and enact enterprise-wide policies that establish guidelines on how to manage the organization's data across all its channels.
• Work with data governance stakeholders and the IT department to identify and document critical data elements, including metadata, lineage and business rules for in-scope systems.
• Reduced costs of project delivery by providing productivity tools and embedded resources during engineering.
• Quality Gate procedures and operational risk management assure safety and risk reduction during the entire project process.

Environment: SAS, Proc-SQL, Selenium script, Cobol, DB2, ETL, MDS, ERwin r7.3, HPAM, Test Link, MS Excel, MS Word, PowerPoint, MS Project, PeopleSoft and lotus Notes.

Confidential

Responsibilities:

• Worked closely with client partners in e-Procurement data collection, standardization, aggregation, analysis and reporting.
• Illustrated complex relationships by combining different datasets to reveal information about customer ordering patterns.
• Used Google Analytics to track the events, response times and conversion rates in all electronics modes like: mobile, PCs and LANs.
• Review data driven products, datawork, and written documents for quality,accuracy, and readability.
• Used Model Mart of ERwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Conducted data model reviews using ‘reverse engineering’ with project team members.
• Preparing rich visualizations, attractive presentation layers, best practices around Dashboards, story boards to show business insights to the top Management.
• Analysis of production datafor process improvement and reduction of costs (Trouble Shooting and Root Cause Analysis).
• Provided necessary recommendations and helped in designing new practices to meet complex business needs.

Environment: SAS, SQL SP, Cobol, PLI, IMSDB/DC, DB2, ETL, Selenium, IBM Cognos, MDT, HPAM, HPSM, Test Link, MS Excel, PowerPoint, MS Project, ERwin, PeopleSoft and share point.

Confidential

Sr. Prof- Analyst (Techno-Functional)

Responsibilities:

• Led a team of 4 across India and United States to redesign the online Agency compensation system for Farmers Insurance using SOA architecture.
• Spearheaded the entire software Development Lifecycle (SDLC) of different features for the project.
• Trained team members on various CMMI level-3 (Capability Maturity Model Integration) quality guidelines.
• Implemented the project under “Six Sigma Green belt” guide lines, which was one of this kind completed within planned budget and duration.
• Trained teams on property and casualty Insurance principles and functional knowledge.
• Worked as a SME for “Agency compensation and OPRA”.

Environment: Mainframes, Cobol, SAS, DB2, SQL scripting in MVS, MQ Series, Mercury Quality center, MS Project, Java/J2EE, FileNet, Guidewire PC and lotus Notes.

Confidential

Software Engineer

Responsibilities:

• Business analysis and understanding of ECS - Auto Estimating
• Working on business requirements and creating Test plans.
• Contributed in designing new practices to meet complex business needs. Ensures programs meet standards and technical provisions; performs technical analysis and component delivery.
• Responsible for handling the new requests and problem tickets

Environment: Mainframes, SAS reporting, DB2, SQL, stored procedure, Mercury Quality center, MS Project, Java/J2EE, FileNet Content Manager and lotus Notes.

Confidential

Software Engineer

Responsibilities:

• Facilitated in requirement analysis, technical design specifications, time-tables and status reports; identified and assessed project risks, built and tracked the mitigation/contingency plans; represented and functioned as a single point of contact in the client location for the technical deliverables.
• Contributed in designing new practices to meet complex business needs. Ensures programs meet standards and technical provisions; performs technical analysis and component delivery.
• Monitored periodic project issues/concerns from teams across India and the United States and assigned appropriate ownership among the team.
• Develop, test and implement data quality monitoring process. Perform root cause analysis of data quality issues.
• Remains abreast of industry technical trends and new development to maintain current skills and remain current with industry standards.
• Analyzing the data and generating various SAS reports with system generated financial information and fatal rates.

Environment: Mainframes, Cobol, OS/390, Unix, DB2, MQ Series, Mercury Quality center, MS Excel and MS Project, Java/J2EE, Lotus Notes and GitLab.

Confidential

Software Consultant

Responsibilities:

• Involved in requirement Analysis, Coding, and Testing for both the online and batch modules.
• I was managing the document repository in Lotus notes database.
• I was responsible for peer review and migration of the new/changed elements from Development to Production environment.
• Worked closely with clients to establish problem specifications and system designs.
• Developed and made extensive modifications to various simulators for unit testing of billing and payment gateways.

Environment: Mainframes, CICS, ASP.Net, VBA, OS/390, Unix, DB2, SQL, FTP, Peregrine, Remedy, MS Excel and MS Project.