SUMMARY

• Highly experienced with more than 8 years in Property and Casualty Insurance domain and Banking Industry concentrated more on Confidential Insurance.
• Worked mostly in Confidential Insurance domain predominantly with Confidential Insurance & Confidential Insurance and Allianz general Insurance.
• Insuranceexperience includes Personal Property Casualty and Commercial Automobile Product knowledge, Group and LifeInsurance Systems, HealthInsurance and AutoInsurance.
• Worked with Confidential for 2 years as Application Support and Development engineer.
• Experienced on multiple technologies - ETL, Teradata, Unix, RDBMS, PL/SQL,MS SQL Server, Data Warehousing, System Analysis, Data Analysis, Business requirement gathering.
• Extensive knowledge in Production Support process on .NET/Web Applications health monitoring, IRT (Immediate Response Team) Management, Debugging, Ticket monitoring and ticket resolutions and status reporting.
• Proficient in Software development life cycle (SDLC) process from requirement gathering, system analysis and design to development and testing of enterprise solutions.
• Personally worked MS Access to MS SQL migration and MS SQL to Oracle migration.
• Worked as Onsite Lead Application Designer, Direct Client interaction and Onsite Development co coordinator for Customer 360 and Contact Centre Data Product Projects.
• Possess strong analytical, interpersonal skills and client communication skills.
• Team Lead, mentoring, motivating and ability to handle multiple tasks
• Well versed in recruiting and training new hires.
• Worked on Application Data Modeling designing the warehouse data model for Confidential Client.
• Experiences as the finance steward for travellers insurance.
• Requirement Elicitation and Gathering & interact with Business to gather requirements through JAD (Joint Application Development) sessions and documentation of Requirement Specifications.
• Capable of effectively communicate in a complex, cross functional and geographically dispersed stakeholder.
• Providing clarifications of the Business requirements to the development and testing teams.
• Reviewing the deliverables prepared by both Development team & Testing Team e.g. Application and Component Design, Unit test plans, Testing Strategy, System and Regression test plan, System test scripts.
• Organized Application Release Management activities and been a single point of contact for Post-production support and support during development phase and co-ordination.
• Worked on Talend and Abi - initio ETL tools projects to build complex data warehouse, reverse data engineering to design complex data warehouse design.
• Onshore QA lead and leading a team of 3 offshore QA’s, expertise in solutioning complex and big data driven projects.
• Data warehousing Concepts and design, RDBMS, SCD 1,2,3.
• Large-scale data warehouse design and development using latest big data technologies like Hadoop (map reduce), Sqoop, MDM, Mongo DB and Hive query writer.
• Talend ETL tool including building technical design document, reviewing with client, building physical tables and ETL jobs in TAC and deploying them. Scaling, performance and scheduling and ETL techniques.
• Qlikview BI and Reporting Tool.
• Application System Analysis and Application Design Documents.
• ETL technical mapping design documents.
• Data Analysis and Data reporting.
• EDI Standards and processing.

TECHNICAL SKILLS

Database Worked: Teradata 14.10, 14.0, 13.0, 12.0, Mongo DB, Big Data Hive 2.0, Microsoft SQL Server 2012, 2008 and 2005, Oracle 10g, 11i and MS-Access.

System Analyst Documents: Business functional requirement documents (BFRD’s), ETL System Analyst Documents including Mapping Design Documents, System/ Application flow documents, Data flow diagram.

Bug Tracking Tools: Mercury TestDirector, Rational ClearQuest, HP Quality Centre

Automation Tools: MS Visio, Rational Rose, Rational ClearCase, Rational RequisitePro, Oracle Documentum.

Production Support Tools: Server Performance Monitoring tool., UltraEdit, Beyond Compare, Hp Quality Centre, Putty, Ultra FTP,SQL Developer, IBM FileNet, Windows Server 2000, 2005 R2,Right Fax Application Server, Microsoft Office(2016, 2013 & 2010), Autosys

Utility Tools: MS Office Suite, MS Project, TOAD, Adobe Photoshop

Reporting Tools: Crystal Reports, SQL Server Reports (SSRS)

Application Servers: IBM WebSphere, Windows Server 200, 2005 R2, Web Logic, SQL Server

Programming Languages: C and C++, Java, SQL

Internet: HTML, XML, XHTML, WebServices, VBScript, JavaScript, JSP

Data warehousing ETL Tools: Abi-initio, Talend

Web Servers: IIS 5.0, IIS 7.0.

Operating Systems: Windows 7, Vista, XP, UNIX, Z/OS

Utility Tools: UltraEdit, Beyond Compare, Unix Putty, SQL Developer, SharePoint site, Talend TAC Environment, DDL Scripts, Autosys.

Methodologies: Agile, Scrum, Waterfall Model (SDLC).

PROFESSIONAL EXPERIENCE

Senior Business System Analyst/Data Analyst/UX Designer

Confidential, Hartford

Responsibilities:

• Gathered user and business requirements through surveys, prototyping and observing from portfolio managers, business end user and UI (User Interface).
• Responsible for Data Manipulation and Data Validation using SQL queries in a MS SQL Server 2008 environment. Worked on call centre calls database for Commercial lines Property and CasualtyInsuranceincluding both policy and claim processing and operations support.
• Strong business domain knowledge of Personal, Commercial Auto including risk, Policy Sales, Policy Administration, Claim processing and call centre operations reporting.
• Designed and worked on successfully developing web applications that allow independent sales agents and call centre agents to view all related information of customer on one single portal related to the existing and future customers calling for policy maintenance, claims processing and underwriters for quoting, rating, processing and tracking applications.
• Work closely between Ex-stream Developers, Data Managers, Client Business Managers and Project Managers to ensure timely changes are met.
• Gathered requirements for the XML bridge and Web Service Data extraction for analysis.
• Stored and modified requirements in MS - Word and using Test Director.
• Validating defects in QC and updating them, daily defect calls and email communication with onshore team members and daily stand-up call for status updates
• Involved in Inception Phase and prepared Logical Data Models that contains set of diagrams and BRD (Business Requirement Documents) supporting documents containing the essential business elements, detail definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Planned and defined system requirements to Use Case, Use Case Scenario and Use Case Narrative using the UML (Unified Modeling Language) methodologies.
• Created Use Case Diagrams, Activity Diagrams, Sequence Diagrams and ER Diagrams in MS Visio.
• Scheduled meetings with developers, System Analysts (SA) and testers to collaborate resource allocation and project completion using MS Project.
• Created Mock-up forms in MS Access for better visualization and understanding of the software solution. Facilitated the User Acceptance Testing (UAT) with Pega System Administrators and Business Users, documented any issues or defects and eventually got sign off from the right parties.
• Played a major role in Interface testing both functionally and manually.
• Created and managed project templates, use case project templates, requirement types and traceability relationships in RequisitePro.
• Used SQL for Data manipulation and data analysis.
• Developed strategies with Quality Assurance group to implement Test Cases in Mercury Test Director for stress testing and UAT (User Acceptance Testing).
• Collaborated with Quality Assurance Analyst in Automated and Manual Black box testing using Mercury's WinRunner.
• Suggested measures and recommendations to improve the current application performance.
• Performed Business Process Mapping and performed AS-IS and TO BE analysis.
• Modified System flow diagrams using SDLC.
• Helped with Data Mapping between the data mart and the Source Systems.
• Implementing database objects in mongo db.
• Mongo DB queries for JSON data extraction and query performance tuning.
• Analyzing and enhancing the SOAP web service to bring in data to meet the business requirements.
• Writing complex business functional logics to meet business requirement by interacting with client directly and meetings with ISR’s.
• System Analysis and writing complex business rules for data transformation and extraction.
• Creating SOAP web services to fetch data from the different legacy systems.
• Client interactions to understand the GUI design requirements and business requirements.
• UX design of the wireframes for the web interface for the developers.
• Getting business sign off on the wireframes and making changes if required.
• Performing business validation and testing for the web interface.

Environment: Mongo DB, Master Data Management, SQL Server 2000, Windows, XML Web Services, Crystal Reports, JSON, Oracle, QC, MS Office, MS Visio, Mainframes, Java.

Data Analyst/ Senior Business System Analyst/Onsite Lead System Designer

Confidential, Hartford

Responsibilities:

• Reverse Engineer the existing data sources for the call centre applications and conferenced, discussed directly the application business owner, application technical owner and business users and created application technical dependency documents, data flow diagram documents and application dependency documents.
• Created ETL Job flow and dependency documents along with job timings, frequency, types, sample data, input and output points of the jobs.
• Create Database Table inventory with table attributes, datatypes, business meanings, sample data and possible values.
• Validating defects in QC and updating them, daily defect calls and email communication with onshore team members and daily stand-up call for status updates
• Created Application understanding documents for the team and gave Knowledge Transition session to the onshore and offshore System Analysts, Developers, QA and Delivery Mangers.
• Designed business requirement & systematic approach based on project scope and SDLC.
• Analysis of business requirements and system requirements of the client and also for Property and casualty modules.
• Proficient working knowledge with CMM Level and ISO (InsuranceService Office) standard guidelines.
• Translated business requirements into functional requirements and prepared an extensive technical ETL flow diagrams and ETL mapping documents.
• Interviewed Business Users to gather Requirements and analyzed the feasibility of their needs by coordinating with the project manager and technical lead.
• Created, Verify & Validate the data-mapping by verifying various business logics, discussion with business user, using test scripts in Quality Centre & filling defect logs if any and getting sign off on the mapping documents.
• Conducted User Interviews and Work Shops to gather accurate Business Requirements.
• Prepared High Level Logical Data Models and BRD's (Business Requirement Documents) supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the actors to analyze and document business data requirements.
• Facilitated JAD sessions with end users, development and QA teams. Performed requirements modeling and develop analysis diagrams, activity diagrams, sequence diagrams, state diagrams, data models and use-case realizations using RUP tools in Agile.
• Assisted QA team in executing Test plans and wrote Test Cases.
• Following up with business for the Data validation and getting the Business Sign-off’s for the QA’s.
• Getting business Sign-off once the data warehouse table is loaded with data and validating everything and data is loaded and correct as expected.
• Setting up project in Talend 6.1 ETL tool for the data extract, transform and load.
• Writing SQL queries in HIVE 2.0, SQL server and Teradata to fetch, analyses and create data reports for business users.
• Writing DDL scripts for Teradata 14.10 for creating simple and complex views and tables and space estimations based on the data volume.
• Validating tables are created in the warehouse as expected and in case of any discrepancy correcting it or getting it corrected if required from third party.
• Designing Data Model for the warehouse using ERWIN 9.1 for the data warehouse and data marts.
• Continuous discussions with client on business data element needs and business logics to derive them in the data warehouse/data marts.
• Reviewing the overall architecture design documents and providing signoff’s.
• Writing technical design documents for the ETL and capturing all low level and high level technical details from job level design to deployment strategies on Autosys/TAC servers, data elements, extract and load techniques and frequencies.
• Creating ETL mapping specs.
• Creating and implementing Teradata DDL scripts and validating them.
• Writing complex SQL queries with multiple level of nested queries and joins with complex joins and aggregate functions to extract data from SQL servers.
• Creating talend jobs for data extraction, transform and load into Hadoop core, staging, and publishing layer and target Teradata warehouse.
• Scheduling code deployments and follow up on any issues during the code deployments from the admin team.
• Data Quality checks during the various stages of the data load and final validation once loaded into target warehouse using standard metrics and SQL.
• Leading the offshore Development/QA team and daily standup calls and follow up on issues and provide solutions to the team on critical technical and business issues.
• Front face for the client at onsite from the vendor team for any communications and issues.
• Reverse data engineering to understand and prepare the existing data source systems, their load frequencies and data flow.
• Designing Autosys box jobs and deploy them to execute the Talend ETL jobs.
• Analyze and create solution to any issue reported by business during UAT and business testing phase.
• Analyze and schedule enhancements and changes needed based on the issues reported by the business or end users.

Environment: MS SQL Server 2000 and 2005, Teradata, QlikView Reporting Tool, Oracle 11i, Quality Centre, Abi-initio, Talend, XML, Autosys, FTP, MS Office Tools, Unix and Unix Scripting.

Lead Onsite Application System Developer and Support Engineer

Confidential, Rhode Island

Responsibilities:

• Lead for the small projects development work - Agile Methodology
• Involved in writing Technical Design Specification (TDS) documents.
• Developed modules using best industry practices to promote extensibility.
• Involved in Design reviews, code reviews and peer reviews.
• Involved in creation of Use Case documents.
• Developing and maintaining RTM - Requirement Traceability Matrix.
• Involved in creating Impact Assessment Documents (IADs).
• Involved in code merge activity for every Sprint
• Involved in resolving technical and design issues.
• Preparing MoM (Minutes of Meeting) documents for technical meetings.
• Managing a team of four developers and six support engineers.
• Developed PoCs (Proof of Concepts) to propose new solutions for complex requirements.
• Designed and developed a utility tool (effort saving) with in the product to create installers that could be used for code promotion.
• Implemented Rollback technique within product which is currently followed as
• Development Standard in the unit.
• Disaster Recovery of the applications hosted on windows servers which includes fail over the web applications to DR servers from prod servers and fail-back to prod servers.
• Supporting tickets opened by business users related to issues with banking applications.
• Working with the developers to implement and deploy the enhancement codes on the windows servers.
• Preparing the project plan and implementation steps for the code deployments.
• Scheduled application maintenance activities, Disaster Recovery, Application tests and weekly den status call and reporting.
• Responsible for application version upgrades.
• Application database migration from SQL server to oracle DB.
• SQL server upgrade.
• Validating defects in QC and updating them, daily defect calls and email communication with onshore team members and daily stand-up call for status updates.

Environment: MS SQL Server 2000 and 2005, Asp Net, Oracle Documaker, Oracle 11i, Right Fax Utility, IBM Filenet Content repository, Quality Centre, QTP, XML, Autosys, FTP, MS Office Tools, SQL Developer, Master Card Rewards, Application, Unix and Unix Shell Scripting.

Business System Analyst

Confidential, San Francisco

Responsibilities:

• Interacted with business owners to identify business system needs, proposed solutions for business problems and evaluated alternate methods to increase efficiency of the overall process.
• Use recognized business analysis methodologies to elicit requirements from business users as the foundation for developing solutions to the organization's business needs.
• Created Requirements Specification Document that translated business requirements into Technical specification including business and validation logic for ease of understanding to the development team.
• Develop systems requirements for future or to-be states of large business system projects using standard templates.
• Analyzed project called Duplicate Data Entry Eliminations with an applications systems like PS&E, LAS, SM, PES, PSS and EPPM, Engineer's Estimates documentations, meeting scribe and take the requirements.
• Defined the scope and implemented business rules to the project, as well as gathering business requirements and documentation.
• Supported the Project Manager in creating detailed Project Plan and assisted in developing, scheduling and tracking project timelines.
• Being an application owner for MCT, gathered and elicited business requirements based on application needs on a Waterfall methodology.
• Primavera project with multiple interfaces to manage multiple project letting, award of transportation department.
• Involved with top client executives view reporting dashboards requirements.
• Analyze current or as-is states of business processes, functions and process models.
• Communicate business process requirements to IT staff, program staff and stakeholders.
• Develop test scenarios, scripts and data and evaluate test results.
• Analyze the impact of changes to IT system requirements or business processes and evaluate project timelines and priorities.
• Lead stakeholders to resolve issues with design specifications before implementation.
• Monitor system testing and assess the impact of errors on system functions during and after implementation.
• Write system documentation and train users on new IT system or business process functions.
• Oracle Documaker 10.0 forms validation.
• Validating defects in QC and updating them, daily defect calls and email communication with onshore team members and daily stand-up call for status updates.

Environment: MS SQL Server 2000 and 2005, Asp Net, Oracle Documaker, Oracle 11i, Quality Centre, QTP, XML, Autosys, FTP, MS Office Tools, Unix and Unix Scripting.