SUMMARY:

• Proactive, Analytical and Self - directed Business Analyst with strong technical academic background complemented with 9 years of experience in business technology solutions with top Consulting major in IT industry with expertise in business analysis and IT Project Analysis Support.
• In-depth knowledge of business processes in IT industries with thorough understanding of the Software Development Life cycle (SDLC) including various concepts such as Requirement Gathering, Estimates Gathering. Possess a detailed-oriented nature with excellent communication, interpersonal, problem solving skills, and recognized for being a valued team player.
• Strong Domain knowledge across multiple industries, such as Healthcare, Banking & Insurance and Telecom with very challenging and demanding work environment.
• Strong knowledge in the design of Data-warehouse using Star-Schema methodology and converting data from various sources to oracle tables.
• Project management experience with commercial and retail banking, investments, FX Trading, brokerage, wealth management and mortgage industry.
• Functional Expertise in Sales Force Automation (SFA), Marketing Automation, Partner RelationshipManagement (PRM), and Case Management
• Implemented sales and service cloud to improve business process.
• Acute understanding of concepts related to Student Lending, Consumer/Business Credit Cards and Consumer loans.
• Advanced Microsoft Office skills, Excel, macros including the use of pivot tables, MS Project, MS Office, MS PowerPoint, creating Business Process Models (BPM) for various Applications, creating reports, and analyzing data.
• Skilled in gathering business and application requirements, Business Processes, identifying risks, impact analysis, UML modeling, and Sequence and Activity Diagrams using Rational Rose and Microsoft Visio.
• Experience in implementing and managing projects in Clarity tools.
• Responsible for meeting with internal departmental clients in order to gather information and requirements for SharePoint 2013 and present them with recommended and proposed solutions
• Extensive experience working on creating Business Requirement Documents (BRDs), Functional Requirement Documents, Systems Design Specification, Business Process Models and diagramming skills for K12 implementation.
• Experienced with data modeling, System Architecture, Feasibility studies, Scope Documents & requests for proposal (RFP).
• Strong working knowledge of Microsoft Test Manager (MTM)on Visual Studio Team Foundation (VSTF) in managing product lifecycle.
• Experience in Data Analytics and creating Report from the generated data for K12 reporting.
• Worked as a liaison between the stakeholders, SME's and the IT team including Product owners and Scrum Master of the different teams in Scrum & Agile Software Development during SDLC phase.
• Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.
• Experience across core health insurance functions like Product Configuration, Quoting & Enrollment, Policy Administration, Claims Management, Workflow Management, and Provider Management.
• Worked on BMC Remedy ARS 7.x, 6.x, 5.x, 4.x, Oracle 8i/9i/11g, on various operating systems and hardware environments including windows and unix.
• Monitored progress of Healthcare tools involving building a platform to support both single and multiple product Quoting and Enrollment across the Humana One product lines.
• Was involved in the Integrated Digital Experience (IDE) initiative to integrate dozens of Humana Websites into a single Humana.com Website with a best in class user experience personalized to different segments including prospects, members, employers, providers and agents/brokers
• In depth knowledge of Medicare/Medicaid Claims processes including health insurance benefits under health maintenance organization (HMO), private fee-for-service (PFFS) and preferred provider organization (PPO) Plans.
• Good knowledge of Hadoop (HDFS, MapReduce), HBase, Pig, Hive, Hue, Impala, Flume, Oozie, Zoo Keeper, Sqoop and Cloudera's Distribution including Apache Hadoop (CDH).
• Analyzed the status of Application received, submitted on the federal Exchange site and generated statistics report for success/failure rate for root cause analysis across ON Exchange and Off Exchange HCR product category .
• Proficient in data visualization using power query, pivot charts, power Maps etc in Microsoft excel, Tableau, Power Bi and Qlik View
• Analyzed the enrollment under HCR Gold, Platinum, Silver products category across different region based on zip and provided the data for the performance tuning and case management
• Utilized Informatica Velocity methodology and extensively followed Velocity best practices and performance tuning measures.

TECHNICAL SKILLS:

Operating System: Windows /2000/XP/Windows 7, Linux.

Business Modeling Tool: MS Visio.

Languages: C++, JAVA, Oracle, SQL,, Visual studio.

Project Management Tool: MS Project.

Reporting Tools: MS Office Suite - MS Word, Excel, PowerPoint, Outlook MS Visio, Open Office.

Database: MS SQL Server, MYSQL, DB2

QA Tools: HP Quality Center, Load Runner, QTP, Squids, QC, Dollar Universe, TFS, Service Now

SDLC Methodologies: Agile (SCRUM), Waterfall Model, SDLC, Spiral, RUP.

Defect Tracking Tool: Squids,TFS.

Requirement Management Tool: Rational Requisite Pro, Rally.

PROFESSIONAL EXPERIENCE:

Confidential, Des Moines, IA

Sr. Business Analyst

Responsibilities:

• Translating business into Business Requirement Documents (BRDs), Functional Requirement Documents, Systems Design Specification, Business Process Models, use case documents, use case specification, sequence diagram and wireframe for large complex projects during SDLC phase.
• Process redesign for identity and access management solution and NIST SP 800-53 and PCI standard and Policy compliance
• Developing the Traceability Matrix in between Requirements and Test Cases and involved in creation and execution of comprehensive system Test plans, Test Cases, Test Data, Test Scripts and Test Results to support/perform System Integration testing and User Acceptance testing.
• Conducted and coordinated JAD/RAD sessions, brain storming sessions, focus groups, personal interviews, testing, training and support with different technical teams and stakeholders to get a better understanding of the client's business process and identifying business solution for E2E global cash management product development .
• Involved in RFP and RFI and developed RFP/RFI Documents for Idaas Project and API project and compliance project for Auditing subcontract compliance by SOX (Sarbanes-Oxley), PCI, GAAP (General Accepted Accounting Practices), FAR (Federal Acquisition Regulations) and DFAR (Defense Federal Acquisition Regulations)
• Provided procurement support to the Agencies and generated compliant file to meet requirements
• Created project initiaton documents, use case specification and mitigated risk factor through careful analysis of financial data with Tableau dashboards for Commercial Lending and purchasing systems Ariba using Agile and Scrum methodology for Enterprise content management(ECM) Adobe Experience Manager (AEM) Project.
• Worked with QA team to design test plan and test cases for User Acceptance Testing (UAT) using HP Quality center Tool.
• Gathered req for Configuring infrastructure for deployment of Middleware application through APIGEE and TIBCO for APIs
• Defined process and tool best suited to each project for identity and access management solution for OIM / OIG System for provisioning, deprovisioning Commercial Lending users.
• Did analysis of maintenance and upgrade of Service Now ITSM software and Oracle Identity Management (OIM), MAC-Access Recertification.
• Helped devise reliable asset tracking system for equipment that employees were allowed to take home using Ariba systems.
• Assists with integration of IAM systems with in-house and third party applications for provisioning, identity authentication and developing connectors between IAM tools and system resources for implementing Single Sign on SSO, Privileged Access Management (PAM) and federation services
• Used BMC Remedy Migrator to move the modified/newly developed forms and workflows in between the finanacial sytem environments using Agile and Scrum methodology
• Gathered requirements for Roles Based Access Control RBAC security model to manage access for users using Auth, aOpenID, and SCIM and enforcing access management policies for both internal and external stakeholders for API management solution Apigee API Gateway
• Responsible for auditing depreciation logs and updating them on a quarterly basis.
• Developed reports for executive team that explained the company's assets and potential for using those assets to generate profit for asset management implementation for OIM/OAM project
• Working in Office 365 (O365) and Azure AD implementation for Identity as a service (Idaas) project and also enable Azure for other Saas applications such as Box, salesforce, HCM and moneyguide pro for Enterprise content management(ECM) Adobe Experience Manager (AEM).
• Created tickets using BMC Remedy to document all incident management troubleshooting and changes performed on devices for financial management project
• Developed service catalog, incident management and configuration management database in Service Now for OIM/OAM project
• Led teams of business and technical analysts in the collection and documentation of business and technical requirements gathering for the development of Master Data Management MDM, Data Warehousing and Reporting implementation roadmaps using Agile and Scrum methodology.
• Led teams in the collection and documentation of data and program governance requirements gathering for the development of enterprise wide BIIM data governance implementation and for asset management project implementation utilizing IBM Unica and IBM interact.
• Led development and documentation of data governance policy and procedures as well as Stewardship inventory and control set up processes for Master Data Management MDM project.
• Led requirements gathering for Master Data Management MDM tool implementation and user workflow processes for Commercial Lending and Mortgage.
• Involved in development of web-to-lead functionality to vertrue.com site which directs leads to Salesforce CRM and utilized RBAC Methodology for IAM.
• Created various Reports and Report folders to assist managers to better utilize Salesforce as a sales tool and configured various Reports for different user profiles based on the needs of the organization for asset management project implementation OIM/OAM project.
• Involved in implementing Syntellect Phonelink CTI salesforce application which is used to provide agents with click-to-dial and screen pop capabilities for Enterprise content management(ECM) Adobe Experience Manager (AEM) asset management project implementation utilizing IBM Unica and IBM interact
• Worked in the areas of Drupal including Views, CCK, Drush, Cron, Custom Module, Tpl
• Helped Install and configur Drupal on a Linux server and other servers
• Implemented sales cloud, service cloud and wave analystic for field service users.
• Managed and Implemented RBAC based Segregation of duties controls in MIB to manage business risk across Front Office, Operation, International Banking and Finance for Commercial Lending and Mortgage for OIM/OAM project .
• Implemented RSA Aveksa Suite Access Fulfillment Express, Access Certification Manager, Business Role Manager, Access Request Manager and Data Access Governance

Confidential, Frankfort, KY

Sr. Business Analyst

Responsibilities:

• Led implementations, JAD/RAD sessions, testing, training and support for business intelligence solution tools . Support existing data warehouse reporting platform and applications to ensure operational availability and scalability
• Report requirement gathering for Project, Portfolio, Gant Chart using Webi and Crystal reports
• Work directly with functional analysts and business users in understanding the information needs of the business and developing new data warehouse/BI functionalities or tools to meet these requirements for UI design.
• Implemenetd performance analysis tool and, national vendor management and inventory control best practices, standards, procedures, and evaluations.
• Created RBAC blueprints with approved access routes. Worked with LOB's to create RBAC user classes and hostgroups.
• System validation experience in compliance with FDA standards referred 21 CFR Part 11, Electronic Records/ Electronic Signatures.
• Collaborated with development teams to create automated single sign-on SSO, Privileged Access Management (PAM) and federation services.
• Analyzed Test Scripts to verify complete functionality, which needed to be in compliance with 21CFR Part 11 enforced by the FDA using Agile and Scrum methodology.
• Interfaced with departmental Quality Assurance organization to ensure that all documents satisfied FDA requirements and implemted security tools SIEM and configured firewalls and anti-virus.
• Responsible for creating dynamic dashboard in Power BI to demonstrate our key insights.
• Supported multiple teams, developed and delivered numerous BI reports, operational scorecards, actionable KPIs, predictive trend analyses using complex Excel Macro, power pivots, Power View, Power BI, OLAP Cube, MDX to analyze efficiency performance and to predict future level of operational activities for HHS system.
• Gathered requirement for SSIS, SSRS, OLAP Cube and used advanced Excel Power Pivot, SAS, Tableau Visualization tool to deliver actionable KPIs, measurable metrics and indices in support their operations, sales development for Enterprise Information Management.
• Advised both FDA IT and Business representative during the requirements phase of the ALM Laboratory Information Management System LIMS project
• Coordinated with LOB's to test RBAC user classes and migrate user's from Legacy classes to RBAC user classes .
• Deep functional and technical knowledge of the Service Now platform as well as experience delivering medium to large-scale Service Now implementations
• Created support documents and trained AMAC support staff to support RBAC after migration.
• Implemented Segregation of Duties controls and policies in RBS organization by enhancing RBAC and user entitlement review applications using Agile and Scrum methodology.
• On-site L1 Support, User Access Administration and Incident Management for Multiple Applications used by internal and external clients of DB for ITIL for HHS system.
• Created custom reports to monitor Case Management process and Data Acquisition and ingestion.
• Assess existing and available data warehousing technologies and methods to ensure our Data warehouse/BI architecture meets the needs of the business unit and enterprise and allows for business growth. Provide recommendations on evolution of the IDMP EU sytem architecture.
• Maintain a technical relationship with BMC Remedy and its support partners with regards to requesting enhancements, license management, reporting and tracking bugs, and planning upgrades for wealth management 401k utilizing IBM Unica and IBM interact.
• Involved in Integrating tools with Service Now applications utilizing Mid server and email technologies for SACWIS, ACWIS HHS system
• Used BMC Remedy Migrator to move the modified/newly developed forms and workflows in between the IDMP EUsytem environments for Enterprise content management(ECM) Adobe Experience Manager (AEM).
• Involved in the design of Data-warehouse using Star-Schema methodology and converted data from various sources to oracle tables for OIM/OAM project.
• Involed in Design and development of several mappings to load data from Source systems to ODS and then to Data Mart for OIM/OIG identity access management System for SACWIS, ACWIS project.
• Monitored network incident queue and handled tickets that required resolution and building event notification and monitoring webshpere datapower and access management for SACWIS poject.
• Strong understanding of Data Modeling in data warehouse environment such as star schema and snow flake schema and google analytics and data extract delivery.
• Led requirements gathering for BI reporting solutions for Data Warehouse/Decision Support Systems (DSS) development integrating Cognos management and administrative reporting report design and dashboard in Power BI and provided incident resolution for OIM/OAM project
• Gathered business requirement to support the functionality including performance, scalability, quality of service (QoS), security and usability for telesoft utilizing IBM Unica and IBM interact.
• Planned various SharePoint sites including creating document libraries, lists, and web part content using Microsoft Visio for OIM/OAM project
• With the understanding of ITIL V3, was involved in technical implementation of Change Management, Incident Management, Problem Management, Service Catalog, Configuration Management, Reporting, Discovery and Integrations for HHS system.
• Involved in Applications Configuration using Service-Now tool used in ITIL Management.
• Involved in Creation, and testing of various SharePoint sites including creating document libraries, lists, links to other web sites and SharePoint sites and web parts and their content using SharePoint 2010 using TFS for SACWIS, ACWIS OIM/OAM project
• Involved in RFP and RFI and developed RFP/RFI Documents and vendor analysis documents
• Created project documentation such as work scopes, wireframes, and project details and requirements for identity and access management solution and created use case specification.
• Improved SharePoint security by proposing and implementing improved payer security access controls and Policies and claims eligibility for identity and access management solution for SACWIS, ACWIS and IDMP project for Enterprise content management(ECM) Adobe Experience Manager (AEM).
• Involved in production support and incident resolution and resolving them within SLAs
• Involved in Creation and replication of SharePoint sites to offshore vessels using Doc Ave V5
• Nurtured relationships of technical staff and functional owners of multiple payer source systems throughout the application development Life Cycle (SDLC)
• Managed documentation and process flows for internal teams and client project teams and Design Tabulation and and K12 BI metrics for SACWIS, ACWIS project
• Supported business owners in issue resolution, benefit plan discrepancies, plan utilization concerns and suspected abusive activity using online business intelligence applications, customized analytics, and BI report development for telesoft mobility service management
• Developed training material; performed knowledge transfer and ongoing client supporting case management for payer and provider CDC and tracking TFS
• Provided post production support/analysis and assisted in performing User Acceptance Testing (UAT), performance testing and validated test plans for K12 and SACWIS, ACWIS project implementaion.
• Involved in Creating SharePoint workflows using SharePoint Designer 2010 for ITIL project
• Evaluated process flows and procedures and user application interfaces and claims eligibility and analyse the data for Enterprise Information Management.
• Helped project manager to develop project plans, managed project resources, managed project status, managed time lines, deliverables and documentation, and managed client expectations
• Wrote proposal responses to RFPs and RFIs for wealth management project
• Supported users in developing reports for data analysis and trend analysis using Cognos Report Studio/Query Studio, MS Access, and Toad for SACWIS, ACWIS project
• Analysed the Existing System and created the As-is Systems for identity and access management solution and use case specification
• Created Business process model To-Be Systems for various Applications using MS Visio.
• Identified and captured use cases that test the IDMP reporting process.
• Did Current and future state gap analysis for the IDMP impacted business sytems for business units
• Monitored deployment and releases and incident management using Service Now
• Documented process flows for IDMP business process and data flow mapping
• Involved in Design and development of Workflows rules, triggers, validation rules and other customizations with Salesforce and wealth management.
• Administered Salesforce CRM applications for Sales, Marketing and Support Departments. Involved in creating multiple analytical reports, with varying degreee of complexity.

Confidential, Stamford, CT

Sr. Business Analyst

Responsibilities:

• Responsible for defining the scope and defining business rules of the project, gathering business requirements, doing gap analysis and document them textually or within models.
• Supported database conversions from Sybase to DB2/UDB
• Worked on replication reporting DB2/UDB database on the platform to ensure accurate and timely replication. Identified business requirements, and analyzed data and business rules using SalesForce..
• Worked closely with the MicroStrategy Admin team during the project migrations and fixing the metadata issues
• Created tickets using BMC Remedy to document all incident management troubleshooting and changes performed on devices for payer and provider for asset management project implemenation
• Experience on writing, testing and implementation of SQL triggers, stored procedures, and functions data integration using PL/SQL in Oracle 9i for wealth management 401k.
• Responsible for organizing and prioritizing identity access management and incident management related requests (i.e., provisioning / de-provisioning, role based access controls, segregation of duties, and user re-certification).
• Assisted SharePoint Administrator with upgrade and transition to SharePoint 2010 from SharePoint 2007 and quality of service (QoS) requirement for CDC for telesoft.
• Involved in designing Informatica mappings such as pass through, split, Type 1, Type 2 and used various transformation such as Lookups, Aggregator, Ranking, Mapplets, Connected and Unconnected lookup, SQL overrides etc for wealth management.
• Documented Salesforce fundamentals and reporting for easy understanding and navigation for business users for asset management and Commercial Lending project implemenation
• Work with business and technical SMEs to discover and mitigate data control weaknesses, develop internal control policies, and mitigate risk of data loss for telesoft reporting
• Good experience and understanding of dataware house database design, relational integrity constraints, OLAP, OLTP, Cubes and normalizations SalesForce CRM for 401K.
• Experience in Extraction, Transformation and Loading (ETL) processes on Teradata using SAS.
• Experience in areas of Information Management - Data Analysis, Data Modeling, Data Mapping, Data Warehousing, Data Integration and Metadata.
• Documented business requirements from Business Stakeholders interviews and workshops and then convert requirements into technical specifications in Rational Requisite. Conducted and coordinated JAD session with different technical teams and other SalesForce. Stakeholders for SAAS applications or Cloud .
• Involved in Configuring the Middleware like Tuxedo and EMBUS for process communication with Amdocs 401k systems.
• Perform performance tuning based on Informatica velocity best practices
• Involved in developing advanced mapping techniques to make the most of the Informatica tool for asset management project implemenation
• Led development and documentation of data governance policy and procedures as well as Stewardship inventory and control set up processes for Master Data Management MDM projects.
• Led requirements gathering for Master Data Management MDM tool implementation and user workflow processes.
• Implementing Process improvements for Order Processing in billing and Middleware systems and created and created use case specification and utilizing TFS.
• Analyzed Business Requirements performed gap analysis and segregated them into high level and low level Use Cases, Activity Diagrams using Rational Rose according to UML standard.
• Requirements Management using IBM Rational DOORS and Comply pro 2.
• Business Process Re-Engineering / System Analysis with Database Administration using IBM Rational DOORS for asset management project implemenation.
• Leading the user training & support team on Comply pro / IBM DOORS involving designer and verifier teams for requirement management with user base of 50+ members for cloud applications.
• Collaborated with testing team in defining test cases, test scenarios for load, stress and performance testing to assure the quality of the software in terms of its reliability, scalability and effectiveness simulating real time situations and utilizing TFS.
• Gathered non-functional requirements and documented them as Business Rules, Quality attributes, constraints documents.
• Extensively interacted with both user group and development team in coming up with structured charts, class and sequence diagrams for asset management project implemenation.
• Worked on live Hadoop cluster running on Cloudera CDH 5x and Data visualization.
• Participated in requirement analysis and creation of data solution using Hadoop.
• Worked on ingestion process of the web log data into Hadoop platform
• Involved in Creation process to web log data enrichment, page fixing, sessionization and session flagging.
• Responsible for creating Hive tables, partitions, loading data and writing hive queries and Data visualization.
• Migrated existing inbound processes from legacy system to Hadoop
• Worked with QA team to design test plan and test cases for User Acceptance Testing (UAT).
• Identified the positive and negative test cases for functionality, integration and system testing of the application. Implemented test phase entry and exit quality criteria documentation including requirement, specifications and testing strategies.
• Verified the Business Scenarios on new builds to allow extended testing by the QA team. Modified test cases and test scripts collaboratively with other testers to test the functional requirements. Used Test Director for bug tracking, reporting and analysis.
• Collaborated with development teams to manage defects, by logging them, reporting them, tracking them and so that defects were timely analyzed and fixed. Prepared User Guide as per the company standard and the type of audience using it.
• Created business requirements document and functional requirements document after gathering both functional and non-functional requirements as well as user stories.
• Extensive experience in using collaborative tools like Mercury Quality Center to facilitate development across disparate Service Now teams .
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, information needs and ensured that critical requirements are not missed.
• Applied cost-volume-profit analysis, workflow/process flow analysis process.
• Attended High level and low level waterfall design reviews, to arrive at design patterns/solutions And reviewing artifacts created by team members.
• Developed use case model using MS Visio. Created a development plan for the overall project and prototypes.

Confidential, Louisville, KY

Sr. Business Analyst

Resp onsibilities:

• Created Business process models for the Humana One system for various Applications using MS Visio.
• Worked on BMC remedy and BMC Atrium CMDB 2.x/7.6 to provide industry best practices of the information technology services and its IT Infrastructure Library ITIL framework for NCANDS.
• Worked with the team in SalesForce Testing and Administration spanning all facets of package software and SaaS application implementation using .NET (DOT NET) technology.
• Created various Reports and Report folders to assist managers to better utilize Salesforce as a sales tool and configured various Reports for different user profiles based on the needs of the organization.
• Involved in implementing, using, modifying and supporting BMC's ITSM suite for NCANDS
• Interact with BMC and internal teams to help solve critical issues..
• Conduct JAD sessions to finalize the payer Billing system design, re-architect and streamline existing design changes impacting other BSS projects for Middleware services, Ensemble Billing, XIUS and claims eligibility systems for NCANDS and for the client-server based SACWIS application.
• Prepared the document templates for MicroStrategy reports and documented the existing and new reports
• Gathered req for new projects and project objects in MicroStrategy for analytical reporting
• Configured security and organizational hierarchy for sales for salesforce implementation.
• Customized page layouts for Salesforce standard and custom objects for NCANDS.
• Configured medicare Reports for custom objects and associated them to Dashboard.
• Involved in Design and development of Workflows rules, triggers, validation rules and other customizations with Salesforce quality of service (QoS) for development of a custom designed web-based SACWIS application
• Documented Sales force fundamentals and reporting for easy understanding and navigation for business users
• Identified and captured use cases that test the IDMP reporting process.
• Documented current and future state gap analysis for the IDMP impacted business sytems Monitored deployment and releases and incident management using Service Now
• Documented process flows for IDMP business process and data flow mapping
• Responsible for all the activities related to configuring Data Loader, uploading data in CSV files into salesforce.com, checking for integrity of the data
• Administered Salesforce CRM applications for Sales, Marketing and Support Departments. Involved in creating Payer and provider multiple analytical reports, with varying degreee of complexity
• Worked on Sales Cloud for Relay Product Group.
• Gathered and documented Master Data Management MDM payer application, conversion and integration requirements for NCANDS.
• Managed implementation across multiple environments (Master Data Management MDM (Product Creation) > Integration Hub (Fusion) > ERP) from requirements through stabilization.
• Assisting in development of the customer Master Data Management MDM data models (both conceptual and logical)
• Created Request for Proposal (RFP) requirement for Enroll benefit Project and adjudicated claims
• Customer Master Data Management MDM project experience from a business perspective and familiarity with the principals of Master Data Management MDM business solution design
• Developed the scope and vision documents that defined the primary goals, objectives and scope of the project.
• Worked with Flume to import the log data from the reaper logs and syslog's into the Hadoop cluster.
• Used complex data types like bags, tuples, and maps in Pig for handling Hadoop data.
• Created/modified UDF and UDAFs for Hive whenever necessary for big data.
• Involved in managing running and pending tasks Map Reduce through Cloudera hadoop manager console.
• Gathered requirement fro Pig UDFs for preprocessing the big data for membership analysis.
• Involved in writing shell scripts for scheduling and automation of tasks fro processing big data.
• Managed and reviewed Hadoop log files to identify issues when job fails. implemented Sales cloud to improve forecasting, campaign, and Partner Portal for channel partner with deal registration.
• Good functional knowledge of SAP CRM and SalesForce.com.
• Coordinated with middleware team to download Service Products, Product Hierarchy, and Product Categories from the backend system into the CRM system.
• Extensively used SQL queries to retrieve data for testing and analytics.
• Identified Gaps, performed feasibility analysis and Scope to customize SAP CRM and ECC 6.0 to meet Business requirements.
• Initial download of Customizing Objects and downloading all Master data’s from ECC to CRM.
• Setting up the Middleware for Business Partner data flow from CRM to ECC & vice-versa.
• Data qualities check of the downloaded data. Analyzes and fixes the error exceptions and completes the master data download successfully.
• Mapped the External List using method CRMD MKTLIST MAP of customers using the mapping rules, creation of Target Groups for Campaign execution using execution channels.
• Created, processed and facilitated troubleshooting for SQL and Oracle data loading scripts for QA and Production environments using such tools as TOAD, SQL Server Query Analyzer and SQL Enterprise Manager
• Defined frameworks for Operational data system (ODS), Brokerage data warehouse (BDW), Central file distribution (CFD) and Data Quality (DQ) and created functional data requirement (FDR) and Master Test Strategy documents.
• Experience on writing, testing and implementation of SQL triggers, stored procedures, and functions using PL/SQL in Oracle 9i.
• Managed Mobility Services and Service Change Recommendations for Telesoft
• Involved in the product release rolling out Healthcare Reform tools for Humana One Plans (Medical, Dental, Vision) under Affordable care Act.
• Experience with HIPPA X12 EDI ANSI transaction code 834(Benefit enrollment), 820 (Premium Payment)
• Work closely with ACA(Affordable Care Act) 270/271XML solution project (Eligibility for a HP)
• Supported Care radius application, on-call duties and interaction with business users.
• Experience in Care radius risk Analytics and data Report creation data.
• Worked in care radius platform for regulatory compliance.
• Coordinated the upgrade of Transaction Set 834 to HIPAA compliance.
• Analysis and Design of existing transaction sets, and modification of these transaction sets to ensure HIPAA compliance
• Entering budgets and allocation details for the projects in Clarity.
• Conduct qualitative analysis of existing SharePoint 2013 or other intranet implementations and provide thoughtful, strategic improvement recommendations
• Woked on the workflow capabilities using SharePoint 2013, including strategies and deliverables required for successful implementation and adoption.
• Worked on Orders and results building pathways and Troubleshooting.
• Profile set up for Interfaces, orders, patient management and results.
• Service master and charge master uploads and maintenance for various TCL and data evaluation for the customization
• Acted as analyst to offer workflow expertise for Epic’s ADT and Prelude modules as well as other system integration points created detailed guide describing data file content and structure for business partners; created quick reference guide for HIPAA EDI ASC X12 834 transaction set for HCR enrollment.
• Have experience managing teams working for EDI 835, 837 transaction.
• Worked for the performance tuning of Quoting and enrollment workflow for the across HCR product catogory for On as well as Off Exchnage.
• Obtained business requirements in form of users stories from users and stakeholders using JAD sessions, brain storming sessions, focus groups and personal interviews to get a better understanding of the client's business process.
• Created Effective test cases document to perform Unit testing and Integration testing with constructed Deliverable.
• Prepared business requirements Documents (BRD) and got sign off to be used by the developers.
• Worked with the development team during the Design, Build and Test phase of system projects to clarify business requirements as required.
• Requirements Elicitation, Analysis, Communication and Validation with the stakeholders according to Six Sigma Standards.
• Using Structured Analysis model built in Excel and Visio, prioritized systems analysis and built Use Cases for web application modification project to be completed in SOA environment
• Used MS Project to manage schedules, deadlines and resources and collaborate on the project.
• Translated high level business / data requirements into Process, Workflow, and Data Flow Diagrams using Rational Rose / MS Visio / BPMN towards facilitating clear understanding of the business process.
• Provided post production support/analysis and assisted in performing User Acceptance Testing (UAT), performance testing and validated test plans.
• Performed UAT, Regression testing, Sprint planning, stand up meetings and releases in SDLC and SOA.
• Closely working the Product owners and Scrum Master of the different teams in Scrum & Agile Software Development for Humana One during SDLC phase.

Confidential

Business Analyst Lead

Responsibilities:

• Analyzed application requirements with UML modeling and documented Dialogue application output management and FileNet Enterprise Web Content Management solutions.
• Integrated call center software and FileNET document management software to provide Farmers Insurance adjusters 'in-the-field' access to claims processing call center notes and customer documents.
• Involved in Security/Identity Management, web application, User Identity management through Web Single Sign On utilizing technologies such as Claims, SSL, Tokens, Digital Signatures, PCI compliance. Property and casuality
• Created SharePoint workflows using SharePoint Designer for .NET
• Defines and tracks quality assurance metrics such as defects, defect counts, test results and test status using TFS and Visual Studio 2010.
• Maintained technical relationship with BMC Remedy and its support partners with regards to requesting enhancements, license management, reporting and tracking bugs, and planning upgrades
• Created, tested, and demoed various SharePoint sites including creating document libraries, lists, links to other web sites and SharePoint sites and web parts and their content using SharePoint Served as a liaison between mortgage specialists and the project team.
• Responsible for gathering user requirements and specifications for designing a mortgage based loan system using and documenting the same.
• Facilitated vendor (STG Mastek) gap analysis sessions for P&C, Life, Annuity, Group Direct and List Billing system with quality of service (QoS) parameters and web content management.
• Documented changes needed to vendor system to convert legacy internal Billing data into the vendor system and checking quality of service (QoS) and TFS tool,
• Increased database performance by utilizing MySQL config changes, multiple instances and by upgrading hardware.
• Developed stored procedures, triggers in MySQL for lowering traffic between servers & clients.
• Created internal system requirements required to implement the vendor system and vendor risk requirements for changes needed to the vendor system
• Executed SQL Queries in Db2 Environment for web application.
• Evaluated P&C Policy Administration & Billing system vendor analysis (Insurity, Guidewire, STGMastek, property and casaulity) and vendor risk management
• Created internal and vendor system P&C, Life, Annuity, Group product process maps for Policy Administration & Billing systems
• Created P&C policy lifecycle document to illustrate the policy administration and billing cost savings of moving to the vendor system
• Created Request for Proposal (RFP) requirements and evaluation documentation to send to content management system vendors as part of the public website redesign project
• Created website screen field design documentation to for field validation, formatting, and businessrules around all public website screens in SOA
• Used IBM Business Process Manager (BPM) to create and extend a business process model definition using parallel processes
• Responsible for Analyzing report requirements and developing the reports by writing Teradata SQL Queries and using MS Excel, Power Point and UNIX.
• Wrote several Teradata SQL Queries using Teradata SQL Assistant for Ad Hoc Data Pull request.
• Used SDLC and Microsoft Project planned scope, cost, requirements and risk analysis of four person web application development team in Visual Studio and SQL Server 2000
• Responsible for managing the data analysis, data sources, data mapping along with defining the meta data data warehouse repository
• Managed the evaluation of ETL and OLAP tools and recommended the most suitable solutions depending on business data warehouse needs.
• Conducted requirement sessions, identifying business needs, getting sign-off on requirements and capturing requirements in Rally
• Developed Test cases Rational Quality Manager (RQM) to perform Functional and Regression testing of the application based on Business Requirements.
• Used Rally for updating the status of all the Test Cases & Test Scripts that are executed during testing process.
• Skilled in implementing Data Warehousing and Business Intelligence solutions
• Performed Vendor Product evaluation and Selection for: Data Extraction and Transformation Tools, Meta Data Tools, Database (DBMS), DSS OLAP tools (Product analysis included the World Wide Web/Internet Interfaces).
• Entering budgets and allocation details for the projects in Clarity web application.
• Responsible for implementing an enterprise Data Warehouse to meet the decision support needs of users in the area of Plan activities.
• Worked in creation of Data Structures for Corporate Data Warehousing for Decision Support Systems (DSS) for SOA based products.
• Created the Data Warehouse Data Model to store atomic level data and the summarized data.
• Utilized MS Visio for designing Activity Diagrams and Sequence Diagrams, after accessing the status and scope of the project and understanding the business processes.
• Assisted in deletion of defects and bugs, in order to meet specific requirements and deadlines for successful execution of the project during UAT of the product with SME, release managers and Business Users.
• Lead the team meetings on status updates, issue resolution, client meetings, Track bug report, and postfix analysis.
• Communicated the project plan tasks, accomplishments and status to Project/Program Management on a weekly basis.
• Interacting with other teams through walkthroughs, teleconferences, meetings, etc. to resolve various issues.
• Used MS Project for status reporting and assisting in planning for Product owner.
• Assisted State Farm service desk and business sponsor team to come up with an agreed SLA for incidents and report back the SLA governance metrics to service desk team.
• Provided Level 2 support for State Farm. com's Online First Contact applications (StateFarm.com first page, Agent Locator and Agent Micro site and others)
• Analyzing the guidelines published by state farm infrastructure team and sharing the application and server availability report.

Confidential

Business Analyst

Responsibilities:

• Analyzed functional, non-functional requirement and technical requirements and prepared deliverables including Software Requirement Specifications, User Interface Specifications, data mapping screen mock-ups, report mockups.
• Developed detailed Use cases and User Interface specifications for the mortagage features implemented, Prepared Activity Diagrams (UMLs) as a part of Use Case Specifications in Photoshop.
• Exposure to real-time Financial/trading application on Investment Mgmt, Portfolio Management, Derivatives, Equity, Fixed Income, Corporate Actions, web content management etc.
• Actively participated in Kick-Off meetings to get a better understanding of the mortagage project scope and project requirements.
• Used Rational Requisite Pro as a Requirement Mgmt Tool, Rational Rose, Clear case for Version control.
• Involved in the User Acceptance Test, assisting the users in executing test scripts and validating conditions.
• Involved with the IT and QA team to fix the defects tracked in UAT and integrate the final build to the production environment and mapped Functional requirements to individual test case requirements through Traceability Matrix.
• Thoroughly used DATABASE Testing for data mapping, Data testing between 2 web applications, inserting data, retrieving data using SQL queries and Sybase Rapid SQL.
• Followed Agile Methodology as a Scrum model, RUP style.
• Organize, traced, developed and review mortagage Test Cases in Mercury Quality Center 9.5. Involved in Requirement gathering and matching requirement with the test cases.

Confidential

Programmer Analyst

Responsibilities:

• Worked in collaborative tools like Quality Center to facilitate development across disparate teams.
• Followed a structured approach to organize requirements into logical groupings of essential business processes, business rules, information needs and ensured that critical requirements are not missed.
• Involved in the creating the User Interface Specification Document and User Training Manual as per project specification with the help of development team
• Gap Analysis of client requirements, generated workflow process, flow charts and relevant artifacts.
• Attending High level and low level design reviews, to arrive at design patterns/solutions to the artifacts.
• Software development experience in implementing medium to complex technical projects using Java/J2EE Technologies (Core Java, Servlets, HTML/XHTML, JavaScript, JSP, JDBC, JMS, JNDI, EJB),Oracle & PL/SQL
• Created Request for Proposal (RFP) requirements and evaluation documentation to send to content management system vendors as part of the public website redesign project
• Developed use case model using MS Visio. Created a development plan for the overall project and prototypes.
• Designed Use Cases using UML and managed the entire functional requirements life cycle..
• Developed timely reports using Test Manager, Rational Clear Quest and Log Viewer.
• Analysis of the new requests specified by the end users for the future releases and discussion with the functional and technical teams.
• Developed tables, queries and reports gathered from system models .
• Defect Tracking and Bug Reporting was performed using Test Director.
• Worked with the clients on the final signing process in the User Acceptance stages of JAVA/J2EE JSP based application implementation