SUMMARY

• 7+ years of industry experience in D Confidential Analysis, D Confidential Warehousing, Business Intelligence, d Confidential modelling, d Confidential mapping and quality assurance skills.
• Insurance experience includes Personal Property & Casualty and Commercial Automobile Product knowledge, Reinsurance for Commercial Property & Casualty, Group and Confidential Systems.
• Well versed in Guidewire PolicyCenter, BillingCenter, ClaimCenter and Contact Center D Confidential Analysis, Mapping, Conversion, Validation and Reconciliation Processes.
• Strong experience in SQL Server Integration Services (SSIS), D Confidential Transformation Services (DTS) and SQL Server Analysis Services (SSAS), and SQL Server Reporting Services (SSRS), and Power BI.
• Experience with D Confidential cleansing, D Confidential Validation and creating Source to Target D Confidential Mapping documents, creating Metad Confidential documents and Source to Target d Confidential comparison.
• Strong experience in D Confidential Analysis, D Confidential Profiling, D Confidential Migration, D Confidential Integration and Metad Confidential Management Services.
• Working experience with the Project Management experience, especially in Project Planning, Project Design and coordinating / managing multiple BI and DW projects.
• Have good working knowledge and experience on Microsoft Word, Excel, Visio, PowerPoint and HP Quality Center.
• Experience in d Confidential analysis, d Confidential visualization using Tableau/Microsoft Power BI, model building with machine learning algorithms for prediction and forecasting using d Confidential (historical or time series with regression techniques), using statistical/econometric tools like SAS and R, d Confidential mining using python, SQL, Hadoop, Spark, Hive, etc.
• Experience in working with different reporting tools like Cognos, OBIEE, Tableau, Business Objects, MicroStrategy.
• Have developed standards for d Confidential definitions, d Confidential element naming conventions, and logical/physical d Confidential base design for applications and d Confidential warehouse development.
• Extensive experience in testing and implanting Extraction, Transformation and Loading of d Confidential from multiple sources into D Confidential warehouse using Informatica.
• Used tools like Tableau and Microsoft Excel for d Confidential analysis and generating d Confidential reports
• Good command over Logical and Physical entity relationship d Confidential modeling using Erwin, Oracle Designer and Power Designer.
• Strong expertise in Excel spreadsheet, Pivot tables, graphs and charts for forecast modeling, business and executive reporting
• Extensive experience in Strategic development of a D Confidential Warehouse and in Performing D Confidential Analysis and D Confidential Mapping from a Operational D Confidential Store to an Enterprise D Confidential Warehouse
• Experience in Business Intelligence (BI) and Reporting technology, d Confidential analytics and KPI to provide pattern, trend, and insights for decision making.
• Strong knowledge in d Confidential Governance and D Confidential Modelling Roadmap presentation for consistent d Confidential governance guidelines and scalable d Confidential plan with respect to proposed D Confidential Mart.
• Familiar with D Confidential base maintenance, installation and support, Date mining, D Confidential Warehousing, d Confidential repository, ETL.
• Experience in SQL and PL/SQL, and working skills in developing complex queries, stored procedures, cube and views.
• Extensive experience working in back end tester by writing SQL Queries and PL/SQL scripts on large d Confidential warehouse systems involving Terabytes worth of d Confidential .
• Extensive experience in D Confidential Analysis and ETL Techniques for loading high volumes of d Confidential and smooth structural flow of the d Confidential .
• Very good understanding of Business Intelligence and D Confidential Warehousing concepts with emphasis on ETL and Life Cycle Development including requirements analysis, design, development, testing and implementation.
• Extensively worked on Dimensional modeling, D Confidential cleansing and D Confidential Staging of operational sources using ETL processes.
• Experience in D Confidential Transformation, D Confidential Loading, Modeling and Performance Tuning.
• Strong in d Confidential base design, domain modelling and ER diagrams design
• Well conversant with scripting languages like Java Script, VB Script, HTML, DHTML, and XML.
• Highly motivated and a self - starter with excellent communication and interpersonal skills
• Strong analytical and problem-solving skills, capable of addressing relevant facts and recommending solutions.
• Used Team Site Content Management Tool to deploy and manage the content managed files.

PROFESSIONAL EXPERIENCE:

Confidential, Plantation, FL

Sr. Data Analyst

Responsibilities:

• Working as Sr. D Confidential Analyst for Guidewire PolicyCenter Implementation and integration of PolicyCenter with legacy systems, document output management systems and Rules & Rating Engine.
• Validate new additions to the Guidewire® Claims Center front end (OLTP) d Confidential structures for consistency and completeness.
• Provide production support for batch jobs, d Confidential fixes, and ad-hoc and regularly requested d Confidential extracts for Hays d Confidential base based on Guidewire platform.
• Collected business requirements to set rules for proper d Confidential transfer from D Confidential Source to D Confidential Target (STTM), D Confidential Mapping, analyzing the d Confidential and communicating with the clients and technical team from both a business and technical perspective.
• Supported the extraction, transformation and load process (ETL) for a D Confidential Warehouse from their legacy systems using Informatica and provide technical support and hands-on mentoring in the use of Informatica for testing.
• Prepared mock-up with sample d Confidential and created a model with extract, transform and load (ETL) principles in Qlikview.
• Integrated d Confidential sources between all systems from/to outbound customers with Workday / Where cape / MSSQL / PostgreSQL / Qlikview and web-based tools.
• Supported for analysis and evaluation of d Confidential mining in a d Confidential warehouse environment, which included d Confidential design and metad Confidential and d Confidential governance in oracle environment.
• Used Microsoft Power BI Query to extract d Confidential from external sources and modify d Confidential to certain format as required in Excel and created SSIS packages to load excel sheets from PC to d Confidential base.
• Involved in migration projects to migrate d Confidential from d Confidential warehouses on Oracle and migrated those to DB2.
• Ensured that Business, D Confidential Governance and Integration team leads are deeply involved in critical design issues and decisions
• Assisted in the creation of deliverables that are developed jointly with the user and technical Guidewire development team, including output definition, logical design (business process and rules, d Confidential elements and flows, screens and reports), implementation plan, documentation, and needs.
• Worked on both live and import d Confidential to Power BI for creating reports.
• Involved in publishing Power BI reports of dashboards in Power BI server and scheduling the d Confidential set to refresh for live d Confidential in Power BI server.
• Responsible for creating SQL d Confidential sets for Power BI and Ad-hoc Reports.
• Involved in creating multiple kinds of Power BI Reports, Dashboards and Visualizations.
• Involved in Creating and managing relationships between tables in Power BI to calculate accurate results.
• Advising and counselling users on d Confidential uses, definitions, assets' capabilities and information management processes.
• Developed detail D Confidential Mapping document for generating Workers Compensation compliance reporting through PolicyCenter.
• Use analysis and experience to ensure d Confidential is properly mapped from the OLTP system to the staging area to the Claims D Confidential Warehouse.
• Involved in developing various D Confidential Management strategy components such as incremental delivery of an Enterprise D Confidential Warehouse, utilization of a d Confidential lake for ETL offload, legacy systems archive, and a d Confidential integration hub.
• Review business requirements to identify product gaps in the Guidewire.
• Performed Integration testing, System testing, Regression testing and Performance testing of BillingCenter, PolicyCenter and Payment manager in Guidewire application based on the business requirements
• Developed d Confidential conversion programs for, claims, and benefit accumulator d Confidential -converted thirteen corporate acquisitions. Developed d Confidential field mappings. Provided programming and support for claims processing functions and auto-adjudication.
• Involved in D Confidential Modeling of both Logical Design and Physical design of d Confidential warehouse and d Confidential marts in Star Schema and Snow Flake Schema methodology.
• Created D Confidential disclosure user stories (Which talk about extraction of various d Confidential sources into Hadoop/Big D Confidential Lake) based on the requirements. Team uses command line interface tools such as SQOOP and Flume to extract d Confidential in to D Confidential lake and Used Kafka and Morning Star APIGEE API suite to import streaming and 3rd party d Confidential into d Confidential lake.
• Maintain business intelligence tools, applications, d Confidential bases, dashboards and systems methods
• Worked with Cognos reporting systems to extract the d Confidential for analysis using filters based on the analysis
• Reviewed the d Confidential model and reporting requirements for Cognos Reports with the D Confidential warehouse/ETL and Reporting team. Wrote several SQL scripts for massive d Confidential extracts and manage the d Confidential conversion and extraction process.
• Proposed solutions to reporting needs and develop prototypes using SQL and Business Objects that address these needs.
• Wrote PL/SQL statement and stored procedures in Oracle for extracting as well as writing d Confidential .
• Create packages using SSIS for d Confidential extraction from Flat Files, Excel Files, Oracle, XML, OLEDB to SQL Server 2008R2/2014
• Created Technical specifications for the Business Objects Reporting Applications.
• Generated reports through Business Objects and further analyzed d Confidential through Excel Used Pivot tables, Vlookups and Offset functions in order to quickly and effectively generate actionable and insightful analysis
• Worked on Informatica ETL D Confidential Integration tool to migrate the d Confidential, to create mapping from source to ODS (Operational D Confidential Source) and then to Target of Netezza Appliance.
• Planned and documented procedures for d Confidential processing and prepared d Confidential flow diagrams for the application.
• Modify and develop new ETL transformations, summary tables, d Confidential staging areas based upon redesign activities with Informatica ETL tool.
• Analyzed large d Confidential sets using MS SQL Server and Excel through SQL queries, VBA macros, and forms.
• Developed SQL Server Reports based on different business parameters and governance compliance.
• Prepared Logical D Confidential Models using ERWIN that contains set of diagrams and supporting documents containing the essential business elements, detailed definitions, and descriptions of the relationships between the d Confidential elements to analyze and document business d Confidential requirements.
• Experience with complex SQL queries for d Confidential profiling for D Confidential ETL Integration tool.
• Gathered requirements and modelled the d Confidential warehouse and the underlying transactional d Confidential base
• Interacted with the SME's to analyze the D Confidential Extracts from Legacy Systems (Mainframes and COBOL Files) and determine the element source, format and its integrity within the system
• Gathered requirements and modelled the d Confidential warehouse and the underlying transactional d Confidential base
• Involved in D Confidential Modeling of both Logical Design and Physical design of d Confidential warehouse and d Confidential marts in Star Schema and Snow Flake Schema methodology.
• Followed the UML based methods using Microsoft Visio to create: Use Cases Diagrams, Activity Diagrams, State Chart Diagrams, Sequence Diagrams and Collaboration Diagrams.
• Part of team conducting logical d Confidential analysis and d Confidential modelling, communicated d Confidential -related standards.
• Utilize Agile Jira to manage the Agile Scrum process for multiple teams concurrently
• Used D Confidential warehousing for D Confidential Profiling to examine the d Confidential available in an existing d Confidential base
• Responsibilities included source system analysis, d Confidential transformation, loading, validation for d Confidential marts, operational d Confidential store and d Confidential warehouse.
• Involved in preparation of technical design document and led the offshore team in the development process
• Collected business requirements to govern proper d Confidential transfer from d Confidential source to d Confidential target during the d Confidential mapping process
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.

Confidential, Ewing, NJ

Data Analyst

Responsibilities:

• Worked as a D Confidential Analyst in Enterprise D Confidential Warehouse to support software application (Guidewire) functionality release.
• Enhanced the out of box Guidewire PolicyCenter, BillingCenter and ClaimCenter d Confidential marts as per client’s requirement
• Deliver end to end mapping from source (Guidewire application) to target (EDW)
• Involved in d Confidential conversions and extracted d Confidential using SSIS packages (ETL) to transfer d Confidential from different server locations and heterogeneous sources like Oracle, Excel, CSV, flat file, XML and Text Format D Confidential .
• Tested Complex ETL mappings and Sessions based on business user requirements and business rules to load d Confidential from source flat files and RDBMS tables to target tables.
• Streamlining the ETL process for an Oracle d Confidential mart from different d Confidential sources (DB2, Access, Oracle, SQL Server, Excel and Text files)
• Review Business and Functional Requirements in the process of identifying the D Confidential Elements associated at a Product level in Guidewire and was responsible for performing the D Confidential Analysis.
• Worked on the commercial property and casualty domain and made specific changes to the same for the smooth flow of the process.
• Technical Analysis, Logical and Physical D Confidential Model, Source to Target Mapping (STTM) as part of compliance Kroll deliverables.
• Prepared requirements document for Commercial Auto, Inland Marine, Crime, Worker's Compensation, Umbrella, Business Owners Policy, Commercial Output Policy, and Commercial Property Package.
• Responded to production support issues and researched d Confidential anomalies in d Confidential ware-house against the Guidewire ClaimCenter system escalating to IT when necessary and keeping business stakeholders informed.
• Gained a solid understanding of the Guidewire Claims Center application.
• Conducted analysis of business and user needs for information, features, reports, and functions in order to develop requirements for d Confidential analytics and reporting for operating units and corporate functions.
• Performed D Confidential Analysis and validate the D Confidential for the Personal and Commercial Line products and also participated in the Integration testing, System testing, Regression testing and Performance testing of BillingCenter, PolicyCenter and Payment manager in Guidewire application based on the D Confidential Mapping Requirements.
• Worked on UAT testing and took signoff from the Commercial line of Property & Casualty business users.
• Completed the documentation of Claims Scenario’s for the source system
• Involved in developing a system alongside Sr. Analyst which will run in the d Confidential base and spits out the appropriate d Confidential that is needed.
• Created several D Confidential models and Reports, List of values and parameters, integrated it with OBIEE dashboards.
• Worked along with Project Manager in defining the Project scope, allocating resources, budgeting, creating the Project Charter.
• Wrote SQL queries for d Confidential validation, analysis and manipulation, and maintaining the integrity of the d Confidential base.
• Analyzed the flow of d Confidential into downstream d Confidential warehouse which fed to d Confidential marts and end systems that support analytical and operational reporting.
• Responsible to extract specific d Confidential set from Operation d Confidential base (ODS) by using PL/SQL query in order to d Confidential cleansing process and new feed processing purpose.
• Performed various ETL task Extracted the d Confidential from Oracle, Flat Files, Excel, Terad Confidential Transformed (Implemented required Business Logic) and Loaded into the target D Confidential warehouse using SSIS (SQL Server 2008 R2).
• Involved in ETL specification designing for incoming feed coming from various d Confidential source and D Confidential manipulation on it.
• Identified, researched, investigated, analyzed, defined and documented business processes, also worked closely with technical leads, information architects, and SQL developer team.
• Prepared Business Object Models and Business Process Models that included modeling of all the activities of business from conceptual to procedural level.
• Created and handled sales reports (Salesforce), activity reports, forecasting, referral summaries and other miscellaneous ad hoc reporting
• Created the DMD (D Confidential Mapping Document) to specify the D Confidential mapping from various d Confidential base sources to the target d Confidential base and used Rational Rose for developing Unified Modeling Language (UML) diagrams like Use Cases diagram, Class diagram, Sequence and Activity based diagrams.
• Involved in creating and designing reports framework with dimensional d Confidential models for the d Confidential warehouse and worked with the development team on SQL Server 2005 tools like Integrations Services and Analysis Services.
• Worked on requirements loading creating/updating test cases and tying them back to requirements, test execution and defect logging/tracking using Test Director.
• Played a key role in planning the UAT, implementation of system enhancements and d Confidential migration and conversions.

Confidential, Cedar Rapids, IA

Data Analyst

Responsibilities:

• Provide support across different domain areas such as Auto Assignment, Payments, Claims D Confidential and Appointment Logs, Auto Estimations, Fire Claims etc.
• Part of team conducting logical d Confidential analysis and d Confidential modelling, communicated d Confidential -related standards.
• Worked with D Confidential Warehouse in the development and execution of d Confidential conversion, d Confidential cleaning and standardization strategies and plans as several small tables are combined into one single d Confidential repository system MDM (Master D Confidential Management).
• Carefully examine d Confidential and reports to make sure conversion is proceeding correctly, run test scripts with various d Confidential to see how new or customized transactions process through the software and verify and validate accuracy of d Confidential through the generation of a variety of reports.
• Worked with project team representatives to ensure that logical and physical ER/Studio d Confidential models were developed in line with corporate standards and guidelines.
• Responsible for defining the key identifiers for each mapping
• Supported User-Acceptance phases by performing d Confidential validations and metrics calculation across every layer including source systems, Staging, Mart and MicroStrategy layer.
• Involved in business meetings along with Architects and D Confidential Modelers to help gather both the business requirements and the D Confidential Mart requirements for the portal
• Created scorecards for management reporting with Tableau analytics software, to allow prompt decision making for corrective actions as needed
• Worked on Bi-Publisher created RTF reports and created various template builders.
• Develop Logical and Physical d Confidential models that capture current state/future state d Confidential elements and d Confidential flows using Erwin.
• Wrote Test cases for Enterprise D Confidential Warehousing (EDW) Tables and D Confidential Mart Staging Tables.
• Involved in designing workflows and within allocated permissions SharePoint
• Provided technical Expertise on the use of Rational Clear Case, Rational clear quest and Requisite pro, which were used for D Confidential archiving and Requirements Management.
• Responsible for executing User Interface Testing, System Testing, D Confidential Quality Testing on the configuration design and prototypes.
• Review the logical model with Business users, ETL Team, DBAs and testing team to provide information about the d Confidential model and business requirements.
• Loading staging tables on Terad Confidential and further loading target tables on SQL server via DTS transformation Package.
• Prepared the Test Plan and Testing Strategies for D Confidential Warehousing Application.
• Involved in requirement gathering and d Confidential base design and implementation of star-schema, dimensional d Confidential warehouse using Erwin.
• Used BEA (BPM Tool) to map Process flows and migrated Visio Process flows into BEA Tool.
• Created D Confidential Dictionary and ER diagrams for d Confidential mapping purposes.
• Performed source d Confidential profiling to verify that d Confidential meets the business requirements.
• Understood core processes of the departments to provide input on re-engineering or Streamline opportunities.
• Development of standard documentation package (Requirements, Specification, Design, Operations and Quality Testing Plans.
• Worked on different modules and analyzed the bugs in Defect manager in the Test Director reported by the users during the UAT.
• Proposed solutions to reporting needs and develop prototypes using SQL and Business Objects that address these needs.
• Set up definitions and process for test phases including product test, integration test, and system test. Work to fully implement test phase entry and exit quality criteria, standard test reporting metrics and standard test artifacts.

Confidential, Madison, WI

Data Analyst

Responsibilities:

• Developed D Confidential Flow Diagrams and D Confidential mapping documents for QAS integration with Guidewire application.
• Gathered all the required d Confidential from QAS integration and Involved in Logical & Physical D Confidential Modeling required in Guidewire applications.
• Integrated Guidewire with QAS.com using Web services for address verification functionality implementation.
• Provided support to the client team for the production implementation of Release 1 of Guidewire ClaimCenter.
• Provide ETL logic to pull the d Confidential from Guidewire application d Confidential base to ODS layer and into Guidewire d Confidential marts and EDW (Enterprise D Confidential Warehouse).
• Created/Reviewed d Confidential flow diagram to illustrate where d Confidential originates and how d Confidential flows within the Enterprise D Confidential warehouse (EDW).
• Worked closely with the Enterprise D Confidential Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.
• In charge of comprehensive D Confidential Quality by making sure invalid, inconsistent or missing Obligor Risk Ratings are reported to portfolio managers for remediation and ensure that checks are in place to prevent the issue from re-occurring.
• Facilitated transition of logical d Confidential models into the physical d Confidential base design and recommended technical approaches for good d Confidential management practices.
• D Confidential base table review and d Confidential mapping for large scale d Confidential conversion project Oracle d Confidential base to Mainframe.
• Wrote SQL queries for each Test case and executed in SQL Plus to validate the d Confidential between Enterprise D Confidential Warehousing and D Confidential Mart Staging Tables.
• Created D Confidential Flow Diagrams and Process Flow Diagrams for various load components like FTP Load, SQL Loader Load, ETL process and various other processes that required transformation.
• Generated Statements of Work for the Design and Implementation of CRM solutions based on Salesforce.com Methodology.
• Validated the test d Confidential in DB2 tables on Mainframes and on Terad Confidential using SQL queries.
• Transformed project d Confidential requirements into project d Confidential models.
• Wrote Test cases for Enterprise D Confidential Warehousing (EDW) Tables and D Confidential Mart Staging Tables.
• Worked on Performance, Tuning and loading d Confidential for fast access of reports in Client/D Confidential base. Server balancing, business Rules Implementation, Metad Confidential, D Confidential Profiling.
• Generated reports through Business Objects and further analyzed d Confidential through Excel Used Pivot tables, Vlookups and Offset functions in order to quickly and effectively generate actionable and insightful analysis
• Produced functional decomposition and logical models into an enterprise d Confidential model.
• Involved in D Confidential mapping specifications to create and execute detailed system test plans. The d Confidential mapping specifies what d Confidential will be extracted from an internal d Confidential warehouse, transformed and sent to an external entity.
• Extraction of test d Confidential from tables and loading of d Confidential into SQL tables.
• Used Reverse Engineering to create d Confidential models of existing d Confidential bases.
• Conduct d Confidential mapping sessions.
• Participated in UAT and worked with Mercury Quality Center for bug and defect tracking.
• Used Test Director and Mercury Quality Center for updating the status of all the Test Cases & Test Scripts that are executed during testing process.

Confidential, Columbus, OH

Data Analyst

Responsibilities:

• Implement redundant systems, policies, and procedures for disaster recovery and d Confidential archiving to ensure effective protection and integrity of d Confidential assets.
• Performed D Confidential Mapping between Rating engine and ClaimCenter screens
• Prepared D Confidential Comparison tool by using VBA (Excel Macro).
• Translated business requirements into working logical and physical d Confidential models for D Confidential warehouse, D Confidential marts and OLAP applications.
• Communicate with Customer Service on ACORD Forms design and other technical problems
• Involved in extensive D Confidential validation using SQL queries and back-end testing
• Developed and maintained programs in SAS for UNIX in a user support environment.
• Experience in implementing Microsoft Office SharePoint 2007.
• Worked on profiling the d Confidential for understanding the d Confidential and ETL specification document.
• Collaborated with business and technical teams to reengineer and translate the current trading process into new requirements that encompassed an improved solution. This included defining a new trading flow, d Confidential mapping, d Confidential messages, exception handling, gaps and impacts.
• Created and handled sales reports (Salesforce), activity reports, forecasting, referral summaries and other miscellaneous ad hoc reporting.
• Understanding the specifications for D Confidential Warehouse ETL Processes and interacting with the d Confidential analysts and the end users for informational requirements.
• Responsible for executing Volume Testing, Compliance Testing, D Confidential Quality Testing.
• Gathering business requirements development team. From customer, preparing the technical design and conveying the requirements and design to the offshore.
• Coordinated defects routing in the team and created Excel macros to generate daily defects report status from Quality centre across multiple teams.
• Involved in the performance tuning of the D Confidential Stage Jobs and SQL queries.
• Successfully used Remote D Confidential Access technology in the coding to integrate the SQL CE and SQL 2000 d Confidential bases
• Worked with various ETL tools for the generation of d Confidential marts for reporting purpose.
• Worked with XML feeds from multiple sources systems and loaded the same into Enterprise d Confidential warehouse.