Management Sql Server

PROFESSINAL SUMMARY

* ***** ** ********** ** Business Analysis, Application Development, Testing and Maintenance, which includes design, development, deployment and implementation of Projects in the areas of Business Process Management (BPM),Geographic Information System(GIS), Reporting&Business Intelligence Enterprise Applications.

Proficient in creating Business Requirement Documents (BRD), Software Requirement Specifications Document (SRS),User Acceptance Test (UAT), and UML Diagrams using various tools including MS Visio, and Rational Rose

5 years 8 months of experience as a Business Systems Analyst involving in design and development of Business Process Management (BPM) and Business Rules Engines (BRE) applications using PRPC.

Experienced in advanced GIS techniques to determine the intelligence and geospatial datasets information contained in imagery, including evaluation of tools, and creation of customized methodologies and products to address a variety of geospatial intelligence challenges.

Exceptional Documentation Skills in writing use cases as well as in creating Use Case diagrams, Activity diagrams, State diagrams based on UML Methodology and business process flow diagrams using MS Visio and Enterprise Architect.

Experience in production support and support for end user by resolving the issues

Strong understanding of project management related to GIS technologies. Strong understanding of SOA and business analysis practices related with Enterprise GIS.

Developed and Improved GIS Data standards, workflows and best practices in the areas for spatial data management, GIS application development and support.

Experience in working with solution frameworks like CPM and Product Configuration Framework

Thoroughly worked on reporting wizard, list view, summary view, activities, Obj-Validation.

Experience in Software development life cycle (SDLC).Working experience on DSM

Experience in Project Implementation methodologies – AGILE and SCRUM.

Exp with CPM & Claims framework. Experience in creating List View & Summary View reports in GIS.

Extensive Knowledge of Software Development Life Cycle (SDLC) including requirements gathering, analysis, design, implementation, testing and deployment.

Expertise with Business Process Modeling Notation (BPMN) specifications and Swim Lane diagrams to better understand business processes.

Expert in Effort Estimation, Project Planning, Reporting, Business Intelligence and Defect Management in capacity of Business Analyst lead.

Proficient in preparing Test Plans, designing Test Scenarios and formulating Testing Strategies.

Excellent team player with ability to think analytically and troubleshoot issues.

Excellent working knowledge of key business process, with 3 to 4 years practical ecommerce and data management experience

TECHNICAL SKILLS

Frameworks

Product Configuration Framework, CPM for Healthcare, CPM for Insurance, Authorization Framework, Claims Framework

GIS Tools

ESRI ArcGIS Desktop 10x and Extensions, ArcGIS Server, Map3D, Web App Builder for ESRI, PODS (Pipeline Open Data Standard), Portal for ArcGIS Server, Geoevent Extension for ArcGIS Server, ArcSDE, ArcIMS, ArcFM, SQL Server, QGIS, ArcGIS Mobile, ArcGIS Online, MapInfo

Operating Systems

Windows 2000, XP, Windows NT, Server 2008R2, Unix/Linux (Red Hat), Ubuntu

Internet Technologies

SQL, JSP, JSF, XML, Java, .Net,HTML.

BPM Product

PegaRules Process Commander (PRPC v6.1/6.3/7.1)

Data Base

MS SQL Server 2000,Oracle 9i/10g, SQL Server, MS Access,IBM,UDBDB2,MYSQL, Teradata

Web Technologies

HTML, DHTML, Java, XML,XSL, XSLT

Web/App Servers

Apache Tomcat 6.0, web logic8.1/9.2, web sphere 6.0

Tools

SAP BOBI, SAPBex, Kronos (Time & Attendance),Microsoft Visio, Rational Rose, Quality Center, Eclipse,Edit Plus, Rational Rose, Google Analytics

Methodologies

Waterfall, Agile/Scrum, Six Sigma

EDUCATION& Certifications

Master’s in Business Administration (IT), University of Bangalore, India

CSM (Certified Scrum Master)

Trained in and pursuing PMI ACP (Agile Certified Practitioner)

PROFESSIONAL EXPERIENCE:

Express Scripts Inc. /MEDCO Health Solutions Dec’15 - Current

Franklin Lakes New Jersey

Role: Sr.GIS Analyst, Technology Division

ATK/C360 Criteria Review – Prior Authorization, HAP Health Action PlanAn application for creating and managing cases for patient’s prior authorization and coverage review. The tool defines a Product, a Client and Interlink between the Product and Clients.The Portal is accessed to enter patients’ information and is reviewed before suggesting the products & services to their clients. The services are provided by both ESI, MEDCO & partner companies like BCBS, Well Point and Anthem projects.

Frameworks used are - Product Configuration Framework, CPM for Healthcare Framework, Authorization Framework, and CPM for Insurance for DEV, SI, and QA& PRD Environments.

Responsibilities:

Requirements elicitation with Business Partners, Business Architects and End Users, in order to document Functional/ Non-Functional Requirements.

Used Agilefor software development SDLC.15 Sprints (3 weeksprint).

CreatedBusiness Rules and capturedE2B/E2C Business Data Elements in alignment to Functional requirements.

Involved in analysis forCPMHealthcare Framework for case management and Services for customers like BCBS, Well Point, Anthem and Phoenix

Geospatial dataDatasets design and implementation with PostGIS.

Administering ArcSDE and ArcGIS Server for management of Enterprise GIS Applications to support business requirements

Assisted in setting up AutoCAD Map3D/Oracle Spatial instances for production and UAT support testing and Test Plans

Worked closely with business stakeholders to translate the functional requirements into GIS business processes.

Learn the system, deliver and mentor client’s team members and partners the systems Smart BPM &Waterfall Methodology.

Involved in the elaboration phase with the Sogetti and Capgemini team and captured the requirements using the User Interface to create mock up of the requirement.

Created Classes and Class groups and also migrated rules between different systems.

Applied Waterfall Methodologies for the project and used practices such as Daily Standup Meetings, mockup design, business confirmation development and Quality test.

Involved in prioritizing the Defects and writing business requirements to resolve them.Automated the scripts/tools to load spatial data, Test reports and support applications

Created plans, test case summary, configurations, pre-conditions, steps to execute and expected outcomes for Test Cases and ran User Acceptance Test (UAT).

Worked on Application Life Cycle Management Software for Defect management. Configured and administered the ArcGIS Portal and Map3D

Worked in the Release Management team to release the right version of the software to the market.

Provided low-resolution support to the client, provide technical and troubleshooting support to the team

Facilitate meetings with Performance Test engineer to enable them to utilize data captured as part of Business Volume Metrics for Various scenarios while executing system performance testing.

Managed an offshore team consisting of 6 resources with following activities:

oOffshore queries resolution.

oAssigning tasks.

oBringing the team to the same page, in order to minimize errors with the requirements.

Review Wireframes,Content Component Library (CCL) and User Interface Specifications (UI Specs) to sync all these Documents with Functional Requirement Documents and maintain consistency in the documents.

Environment : GIS, Arc GIS, Map3D, MS Visio, UAT, Oracle dB, JVM, .Net, IBM Cognos, SAP ERP, Remedy, Clarity, ALM, MS applications.

ShiroTechnologies, Dallas,TX Feb‘13 – Nov’ 15

Client: State of TX & AL (BenefitAdministration Process)

Role:Sr. Business Analyst – Process Automation - (Location Based Service).

The project being developed was Benefit Administration Process System for employment and unemployment benefits for State Departments. Purpose of the project was to automate – system controlled pricing proposal tool for research study project through various channels that would enhance their benefits management procedure. The system has been designed for various processes such as employee insurance, employee benefits, commissions and loans that had followed the Enterprise Class hierarchy principles and guardrails. The second phase involved Mass Testing Tool where the results are generated with Rating factors and Premium details.

Responsibilities

●Project being AGILE, participated in the discussions with the Business Users and Client in gathering the requirements monthly.

●Design and development of Data Model, Class structure, Organizations structure, Access Group, Process flow, Activities, Flow actions, Decision Rules, UI properties, Rule sets and versions.

●Conducted workshops that helped stakeholders understand the functionality and how it can be adopted to meet business objectives.

●Conducted requirements gathering sessions through formal and informal meetings and workshops. Conduct one-on-one or small group interview sessions to gather functional requirements in order to develop requirement documentation.

●Created Application profile and executed Application Accelerator usingDCOtoolsand assisted in creating use cases and HLD documentation.

●Responsible for creating impact document for migration of existing system to 7.1 with pros and cons.

●Responsible for code migration from development to UAT and production.

●Created and implemented Service and Connect rules.Configured and administered the ArcGIS Portal

●Developing applications using ArcGIS Online and Operation Dashboard Tools in ArcGIS Cloud.

●Assessed the feasibility of utilizing the services of arcgisonline and ArcGIS portal to meet the needs of the organization

●Designed and Created High Level Class Structure and Rule set Architecture.

●Participated extensively in designing application security which involves setting up Access groups, Access Roles, Operators, Application ID, Work groups, Work basket and SLA rules.

●Involved in Bug fixes and Unit testing.

●Worked with offshore teams in resolving Functional /Technical queries raised by the development team.

●Acted as a liaison between the business and the technical team.

●Involved in PROD support as well.

Environment: Agile, UAT, MS Visio, SAP BOBI 4.x, GIS, ArcGIS, ArcServer,HTML, Business Intelligence, XML, MS Visio, PRPC 7.1/6.3, HTML,Kronos (T&A), XML, SOAP UI 3.0, Oracle, JavaScript, .Net,WSDL,SQL Application Server, CSS

CAPITA Financial Services, Leeds, West Yorkshire, UK Apr’12–Jan’13

Shiro Technologies

Project: GRASP

Role:Sr. Analyst –Business Process Management - IT Business Analyst Group

ACC Bank, under their parent Rabobank has made a decision to exit the Irish marketplace and is currently in the process of divesting all of their savings and investment products. ACC have decided to outsource the management of the open loan book. The loan book consists of performing and non-performing loans of the following types:

-Unsecured personal loans

-Residential Mortgage – Principle Dwelling Houses

-Residential Mortgage – Buy to Let

Capita Asset Services (CAS) has been selected as the outsource partner for this operation subject to a successful pilot whereby they will undertake management of 10% of the loan book management. This is a call center based application developed in CPM framework. Designed a mechanism where if customer has a problem with paying his/her monthly payments of the loan account, they call to call center then call center representative (CSR) provide the information/solutions to the customer based on the loan account number, and start an action based on customer request. Above action also can be initiated in case when customer has acknowledged that in future he/she will not be able to pay the loan amount (pre arrears). In such a case CSR makes some temporary arrangements for the payment of the loan amount.

Key responsibilities include:

Served as an expert in the functional use of GIS its various cockpits and the B2B and B2C accelerators.

Involved in enhancement of STP systems for product and regulatory requirements. Using BRDs, prepared Functional Specification Documents (FSD) and prepared Standard Operating Procedures (SOP) docs for Ops Training.

Wrote BRD, FSD for use cases, and test scenarios, test cases for testing the functional requirement

Understand the current Business requirement. Configuring intents and interaction driver.

Build Stage based processes required for the Project.Update status to client on daily basis.

Acted as the Offshore Lead

Help Offshore Team in Technical Aspect

Code reviews. Help in reducing the logs

Provided the business solutions for the given requirements.

Lead the Offshore team, getting requirements from onsite & distributed the work

Implemented the correspondence

Technologies Used:GIS, (PRPC 6.3/6.2), CPM, CPMFS(Customer Process Manager Financial Services), MS SQL SERVER, Tomcat 7, Oracle, SQL Server, MangoDB, NOSQL, Web Logic application server, Jboss application server.

Global Technology Financials, Jersey City NJ Sept’11 – Apr’12

Project: Global Claims Initiative

Sr. Lead Analyst( IT Team)

Client has embarked on a Claim Transformation Initiative. This initiative intends to establish a Global Claims Platform which can be continuously enhanced to handle new Lines of Business and Geographies in turn resulting in consistent claim handling across all lines of businesses and geographies, improved customer experience and improved operational efficiency.

Responsibilities

Facilitated and managed meeting sessions with committee of SME’s from various business areas such as Accounts and credit cards and created a Business Requirement Document. Did post analysis of the business requirements of online banking service applications by analyzing the Risks associated and strategies used to assess and mitigate them.

Designed and developed Narrative Use Cases, Use Case Diagrams, Class Diagrams and Sequence Diagrams using MS Visio to define the Business Process. Involved in entire SDLC phases of the project.Used CPM framework in FNOL process model.

Interaction with Business Analysts to understand the business needs and requirements

Implementation of PRPC components like Decision tables, Decision Maps, Declarative expressions, Constraints and Indexes etc.

Created Activities, steps and methods like property set, page new, calling other activities for implementing core business logic

Modified out of box reports and created new reports using List view and Summary view rules

Involved in Designing and developing high level class structure in PRPC like class groups, work classes based on the organizational hierarchy.

Created specialized rule sets which served as containers for specific rule types.

Implemented the pre-packaged workflows that come with the framework and customized them to support successful payments processing and handle payments exceptions.

Created various flow-actions for successful exceptions management.

Implemented field validations using declarative expressions and declare constraints for known issues in the framework.

Taking care of Business Ad Hoc Requests to update the Production Data.

Created product patch rules for the migration.

Involved in Bug fixing, Unit testing and Performance testing using PAL

Prepared Application Usage document and provided User Training.

Coordinated implementation, Integration, UAT and also for bug fix and enhancement activities.

Taken care of Change Management and sanity testing for the product deployed.

Supported change control activities for releases, upgrades and maintenance tasks.

Resolved customer service tickets. Automated various operational tasks based on the client SLA’s

Maintaining documentation in the form of the Production Support training manuals, tasks, and Process Instruction Forms.Working with vendors to solve problems and implement changes.

Primary point of contact in support of production issues during on-call

Managed a team of system analyst’s off-shore to re-design and implement Error management system

Technologies Used: AUTO CAD, BusinessIntelligence,, UAT, MS Visio, HTML, UDB DB2, JavaScript, Java

ComputerTechnologiesInc., DE Apr’11 to Aug’11

Project: Strategic Claims Initiative

Role: Analyst (Smart BPM)

Involved in re-engineering the insurance process model and its associated pricing model to improve its approach to risk selection/pricing and implement the ability to meet compliance/regulatory commitment throughout. The existing system had significant operational and productivity challenges including inconsistent and inaccurate pricing, risk of losing IP, insufficient governance and auditing.BAU is a project for maintenance of all the applications. Worked heavily on a customer facing role with clients such as Coles Motor/Home, KTAS Motor, OAMPS, and LSV

Roles and Responsibilities:

Primarily involved in architecture design and implementation to build a solution that automated the rating system, which captured rating criteria and calculated a technical premium that was based on sound underwriting.

Works on root cause analysis of critical issues in production

Responsible for application maintenance for partners that use broker channels

Provides high level estimates for the enhancements and defects in every release

Works on analysis, implementation of medium to critical change requests

Works on defect fixing for the issues that frequently log in Production

Works on log exceptions in production, uses PLA to enhance readability and provide a fix to them

Runs the performance tools to debug the performance issues that log in production and resolve them immediately

Performed code review for the code developed by all the team members and attaches a code review document to the JIRA

Creates reports for COLES and KTAS clients that contain the information of each insurance policy

Works with the preflight tool to get all the warnings from the application and eliminate them

Takes care of the release management for all the change requests or defects fixed by the team members by verifying the documents in the JIRA and changing the status to BUILD

Uses SMA to monitor agents in all the environments and resolve the issues if any or update the LastRunLog in the database to contain a recent date if the agents had stopped erroneously due to any false record in one of the tables

Works on correspondence and emailing the reports to an external email server

Works on work object assignment issues by creating a utility to resolve such issues

Works on system queues to find if any of the tasks have a broken-process status and runs the Broken Queue Items report to re-queue them if necessary

Updates the rating factor data tables in LTS and UAT from the Excel files of production to make a replica of the production environment. Performed Rule and Technical verification for the code in all the environments

Provided knowledge transfer sessions to the employees

Technologies Used:BusinesssIntelligence,AUTO CAD, SAP BI 7.0, Google Analytics, Google Appliance, SAP BEX QUERY, NoSQL, SQL Server, WebSphere, MS Visio, MS Excel, HTML, XML, Windows XP

Wesfarmers Group, Perth, Australia Jun’10 – Apr’ 11

Shiro Technologies, Bangalore, India

Project: Rating Control System

Role: System Analyst (IT)

EMAR (Exposure Measurements Automated Raters) is a rating application developed for Liability Insurance built on top of Product Configuration Framework. The objective of this application is to determine the total premium based on the given customer, insured object and policy profile. It includes calculation of base and coverage premiums, surcharges, discounts, fees and taxes depending on rating rules defined in the system

Roles and Responsibilities

Involved in developing Full Policy life cycle transactions for the existing automated raters, which include Endorsements, renewals and cancellation.

Involved in the initial set-up of the system by creating the Organizational Hierarchy, Organizations, Divisions, Organization Units, Work Groups and Work Baskets.

Analyzing requirement gaps and coordinating with Line of Business.

Involved in Designing, Developing and testing the application.ProvidedRule set management in various environments.

Used ArcGIS and MAPINFO programs to create print quality thematic maps by compiling data from rough sketches, surveyor’s field notes, government and private survey reports and aerial photos.

Prepared system Test Plan and scenarios for Test Scripts.

Created and manage ArcGIS projects including: System maps, State maps, Public Awareness maps (Counties and Parishes maps), Maintenance Area maps and Emergency Response maps, Exhibit maps for legal submission to regulatory agencies.

Used GIS/GIMS to obtain various storm sewer, pipelines, streets and parcel taking data like the length & diameter of pipelines, length & width of streets etc..

Created drainage area and street study exhibits using ARCMaps

Involved in Designing High Level Class structure, Workflows and Rule sets in PRPC.

Worked on the Activities which implement the Core Business Logic using standard methods such as property set, Obj-List, Obj-Browse and hands on Java.

Performed peer code reviews and following SDLC Guardrails.

Involved in the migration and deployment of the application rules from Dev to Testing and Production environments.

Designed and implemented customized User Interfaces based on the requirements using Sections, Harness, Portals, and Gadgets rules and various Styles

Created the Business Process Flows and Flow actions in Applications.

Technologies used:), SQL Server, GIS, Arc GIS, ARC SDK, ARCGIS Server,WebSphere,MS Visio, SAP BO 3.x, Html, JavaScript, MVC model, Oracle 10g, Apache Tomcat, Eclipse 3.3.

Circle Consulting, Bangalore India Jan’10– June’10

Client: United Germany Corporation

Role: System Analyst (ERP)

Overall business solution involves integrating into UG loan origination system to handle specific functions through the life cycle of a loan process. Application interaction will begin when accepting a SOAP request from the backend loan origination system that contains the customer-entered data. The SOAP message contains all the possible fields that are needed for the three evaluation types, but only the values needed to process that particular evaluation type are passed to the business rules engine and back to the loan origination system

Roles and Responsibilities:

Involved in designing site specifications.

Involved in design and development of various screens

Performed various client side validations using Java scripting.

Performed Unit and System testing.

Project Implementation, Coding, Tracking, Coordination & Execution

Implementing Rules for Functional and Business scenario requirements

Defect Management & prevention

Configuration management activities

Daily Co-ordination with Onsite team for Project tracking.

Technologies Used: AutoDesk AutoCAD, Oracle RDBMS, Oracle/BEA

NelgoSolutions,Richardson TX and INDIA May’09 –Jan’10

Project: Security Applications and Reports

Role: Security Business Analyst (Mobile Apps)

Roles and Responsibilities:

Involved in gathering the requirements that were critical to the business process flow and using those requirements for the Business Requirements Document (BRD)

Conducted JAD sessions with Subject Matter Experts (SME’s) to obtain domain level information, interviewing and asking detailed questions and carefully recording the requirements in a format that can be reviewed an understood by both business and technical team.

Maintained a daily meeting with the Business team on task order approval, increased and decrease frequency of the meetings as per the progress of the task.

Worked on roles and authorizations in Business Intelligence and Reporting.

Authorization functions include configuration of hierarchy and authorization with variables, authorization Info Cube, allocation of roles and authorization objects.

Worked on data source enhancements and generic extractors to meet the business needs

Created transfer rules and update rules including routines for currency conversion.

Created revenue margin variance reports with complex restrictions on characteristics and calculations on key figures based on business requirements.Resolution& recommendation of table sizes, parameters, table spaces, partition break ups, and errors.Basis functions include monitoring and supervising check DBA, archive logs, parameters settings in R/3 and BW, and performance tune-ups.

Technologies Used: Data Security, SAP, AUTOCAD, E-Commerce, Kronos (Time & Attendance), HTML, UAT Testing,JSP, SQL Server 2000, JAVA Script, Java and Windows NT

Contact this candidate