PROFESSIONAL SUMMARY:

• 8+ years of experience as a Sr. Data Analyst in the Insurance Industry with product knowledge (Group, Annuities, Universal life and Term life insurance).
• Vast Insurance business knowledge with project experience in various LOB such as Personal (Auto, Dwelling, Home owner) and Commercial (Commercial Auto, Workers Compensation, Commercial Property, General Liability, Business Owners Policy (BOP), Commercial Package Policy (CPP).
• Insurance experience includes Personal Property Casualty and Commercial Automobile Product knowledge, Reinsurance for Commercial Property Casualty, Group and Life Insurance Systems.
• Good understanding of Whole Life, Traditional Life, Term Life, Survivorship, Universal Life, Survivorship, Variable Universal Life, Variable Universal Life, Fixed Premium Universal Life, Fixed Income Annuities, Variable, Annuities, Equity Indexed Annuities, Flexible Premium Annuity, Interest Sensitive Life, Ordinary Life, Long Term Care, Retirement Services (401k, 403b, 457 and other products), property and Casualty.
• Experience in Data Analysis, Data mining with large data sets of Structured and Unstructured data, Data Acquisition, Data Validation, Predictive modeling, Data Visualization, Web Scraping, Data Cleansing, Data Verification and identifying data mismatch.
• Good experience in Data Modeling with expertise in creating Star & Snow - Flake Schemas, FACT and Dimensions Tables, Physical and Logical Data Modeling using Erwin.
• Adept in statistical programming languages like SAS, R and Python.
• Experience as Data Analyst by gathering data from different sources, data profiling, data definition, and loaded those data on business warehouse. Worked on different kind of source systems and deeply understanding of business and accounting terms and formula.
• Experienced to work as a Data Analyst to perform complex Data Profiling, Data definition, Data Mining, validating and analyzing data and presenting reports.
• Strong knowledge in designing Various Reports/dashboards to provide insights and data visualization using BI/ETL tools like Mainframes SAS, SSAS, SSIS, OLTP, OLAP, Business Objects, Tableau, Informatica power center, Data stage.
• Good with data visualization tools like Tableau, SAP, Qlik, Amazon Qlikview, OBIEE, Google Analytics
• Experience in using Business Intelligence Reporting Tool (QlikView, Power BI) to create KPIs and Scorecards to improve Production support goals and measures.
• Expert on maintaining and managing Tableau and POWER BI driven reports and dashboards.
• Experience in providing reporting analytical thinking, process improvements, problem solving, time management, decision making and issue resolution.
• Technical expertise in ETL methodologies, Power Mart, Client tools - Mapping Designer, Workflow Manager/Monitor and Server tools - Informatica Server Manager, Repository Server Manager, and Power Exchange.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Excellent Software Development Life Cycle (SDLC) with good working knowledge of testing methodologies, disciplines, tasks, resources and scheduling.
• Experience in testing and writing SQL and PL/SQL statements.
• Solid experience of creating PL/SQL packages, Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
• Excellent knowledge in Data Analysis, Data Validation, Data Cleansing, Data Verification and identifying data mismatch.
• Experience and understanding of database design, relational integrity constraints, OLAP, OLTP, and normalizations.
• Experience in Business Intelligence in generating various reports using Cognos and Business Objects.
• Knowledge of creating UNIX shell scripts to automate data loading and to perform regular updates to database tables to keep in sync with the incoming data from other sources.
• Experience in designing ETL Specification documents to load data from source to target using various transformations according to the business logic.
• Inclusive knowledge of Waterfall, Agile, Risk Engineering, Data modeling and Mapping.
• Excellent experience in writing SQL queries to validate data movement between different layers in data warehouse environment.
• Expertise in source to target mapping in Enterprise and Corporate Data Warehouse environments.
• Strong knowledge of developing and implementing ETL processes using DQE, UNIX shell, DB2, and Oracle.
• Good Knowledge on Amazon Web Services (AWS) Cloud services like EC2, S3, EBS, RDS, VPC, and IAM.
• Advanced knowledge in ETL, DSS and Data warehousing with OLAP technology.
• Good Experience in preparing financial reports using oracle SQL.
• Ability to work independently as well as collectively willing to relocate.

PROFESSIONAL EXPERIENCE:

Confidential, Sacramento, CA

Sr. Data Analyst

Responsibilities:

• Developed and implemented ETL framework using SSIS, stored procedures, functions for extractions into SQL Server.
• Created SSIS Packages for data transfer between servers, load data into database, and archived data file from various heterogeneous sources like SQL Server, Excel and CSV.
• Experience in using SAS to read, import and export to another data file formats, including delimited files, DBF, MDB, Spreadsheet files.
• Performed Regression Analysis on the dataset using SAS.
• Formulated Mapping Specification Documents (ETL mapping, Qlikview report mapping)
• Analyzed accuracy of data warehouse fields for reporting tools including Business Warehouse and QlikView
• Influence Qlikview Dashboard integrity, stability, revisions, and evolution based on customer feedback.
• Collaborating with end users to identify needs and opportunities for improved data management and delivery that can be seen in Qlikview.
• Overseeing the ongoing development and operations of an operational data store and enterprise data warehouse.
• Improving and streamlining processes regarding data flow and data quality to improve data accuracy, viability and value.
• Assisted in developing Power BI Reports and Dashboards from multiple data sources using Data Blending.
• Proficient in importing/exporting large amounts of data from files to Teradata and vice versa.
• Involved in developing strategic partnerships with the business unit to develop a solid knowledge base of the Term life, Whole life, Universal life, Variable life insurance business line, including the business plan, products, and processes and revenue streams.
• Used Power BI power query to extract data from external sources and modify data to certain format as required for consumption in the dashboards.
• Worked with IDQ on data quality for data cleansing, robust data, remove the unwanted data, correctness of data.
• Created parameter driven reports using parameters tab in the SSRS GUI procedures by setting up the report level parameters, along with building parameter driven queries and stored and placing them, in the data field.
• Working on generating various dashboards in Tableau Server using different data sources such as Teradata, Oracle, Microsoft SQL Server and Microsoft Analysis Services.
• Detailed Data Mapping with the purpose of being able to locate any field on UI and simultaneously correlating it to the database field.
• Provided quantitative analysis of website visits and optimized media spending by using statistical tests, data mining techniques and data visualization tools with R
• Assess and coordinate the prioritization of requirements of cross enterprise business segments for in corporation into the enterprise master data management (MDM) solution.
• Created various geographical and time dimension reports of fiscal year, quarter month, week and daily reports for all domains and published through Reports Server.
• Solid understanding of Business Process definition, Risk Analysis and SDLC methodologies.
• Design and generation of different database objects like Tables, Views, Synonyms and Sequences, Pl/SQL packages and Database Triggers.
• Used Business Intelligence tool sets and building solutions using these tools (Business Objects, Tableau, SAS, prefer business objects).
• Extensively used both Star Schema and Snowflake schema methodologies in building and designing the logical data model in Dimensional Models.
• Create Mapping documents, ETL technical specifications and various documents related to data migration.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in a complex EDW using Informatica.
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Involved in designing database using MS Visio.
• Responsible to design, develop and test the software (Informatica, PL SQL, UNIX shell scripts) to maintain the data marts (Load data, analyze using OLAP tools).
• Involved in developing reports using the Teradata advanced techniques like rank, row number and etc.
• Created report schedules, data connections, projects, groups in Tableau server.
• Implemented Agile Methodology for building an internal application.
• Deployed SSRS reports to the reporting server in Native and SP integrated mode and assisted in troubleshooting deployment problems.
• Developed consolidation process for number of MS SQL servers within the firm.
• Responsible for Performing Requirement Analysis and Data Analysis for various work streams with the help of SQL and Excel.
• Good at SQL for querying and analysis purposes on various source tables and conditions applied and Wrote SQL joins, sub queries.
• Created Standard and Ad-hoc reports using Cognos tool to estimate ETL process load statics.
• Worked in tuning the ETL processes to reduce the processing time
• Monitor the ETL process daily and report and data correction before the daily report is sent to the stakeholder and business partner
• Provided key data analysis using ad-hoc MS SQL queries and Excel pivot tables.
• Processed Data-Entry and Entered data into and maintain several Excel spreadsheets
• Analyze data and generate reports using Excel and VBA

Confidential, Saint Paul, MN

Data Analyst

Responsibilities:

• Document all data mapping and transformation processes in the Functional Design documents based on the business requirements.
• Developed prediction algorithm using advanced data mining algorithms to classify similar properties together to develop sub-markets; each zip code was divided into submarkets using advanced data mining techniques.
• Worked on Parameterize of all variables, connections at all levels in UNIX.
• Prepared High Level Logical Data Models using Erwin, and later translated the model into physical model using the Forward Engineering technique.
• Involved in developing Dashboards featuring detailed analytical reports to promote greater business insights and a more informed decision-making process using QlikView Developer tool.
• Developed simple & complex mappings using Informatica to load dimension & fact tables as per STAR Schema techniques.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub Reports.
• Involved in providing service to inforce whole life, universal and variable universal life insurance policies.
• Developed and deployed reports in MS SQL Server environment using SSRS.
• Performed Data Profiling and Data Quality.
• Experience working with large database to perform complete data retrieval, manipulation using multiple input files using SAS data steps.
• Hands on experience in providing Tableau report access to the business users and reducing the space on the server for effective functioning by creating extracts and parameters in large reports.
• Develop, test, implement and maintain reporting solutions using the Crystal Reports 9.0 environment.
• Working on Agile and Scrum methodologies.
• Responsible for defining the key identifiers for each mapping/interface.
• Creation of multiple, very complex reports in SSRS and Power BI, that run on high volume of data, with response time less than a few secs and which pulls data from SQL Server as well as Mongo DB.
• Creation of multiple highly interactive Power BI and SSRS reports for supervisors and managers, which enables them to see the current status of the work, shift allocation for the next day at location, district and borough level.
• Created Technical specifications documents based on the functional design document for the ETL coding to build the data mart.
• Intelligence tools like Informatica Power Center, Data stage, Mainframes SAS, SSAS, OLTP, OLAP and Business Objects.
• Extensively involved in Data Extraction, Transformation and Loading (ETL process) from Source to target systems using Informatica Power Center.
• Participate in defining and establishing the Client Master Data management (MDM) organization within the Enterprise Data Office.
• Documented, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
• In depth analysis on VSAM files to understand the data anomaly and for drafting data cleansing requirements.
• Implementing various checkpoints of Software Development Life Cycle (SDLC) process, throughout different phases of a project: Analysis, Design, Develop, Test and Deploy.
• Reverse engineered all the Source Database's using Erwin.
• Expert in creating various SQL stored procedures, functions and temporary tables for data input to the Crystal Reports.
• Worked with Informatica Data Quality (IDQ) for data cleansing, data matching and data conversion.
• Understand the reporting requirements and provide Tableau reporting solutions.
• Created complex reports using Crystal Reports.
• Preparing the SQL script to verify data and validating data from source and target Through PL/SQL Developer.
• Designed parallel jobs using various stages like Join, Merge, look up, Filter, Remove Duplicates, Data Set, Look up File Set, Complex Flat File, Modify, Aggregator, XML.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/dynamic and static datasets.
• Used data analysis techniques to validate business rules and identify low quality missing data in the existing data.
• Created Teradata objects like Databases, Users, Tables, Views and Macros.
• Designed and developed weekly, monthly reports related to the marketing and financial departments using Teradata SQL.
• Converted OBIEE reports and dashboards to Tableau reports and dashboards.
• Prepared High Level Logical Data Models using Erwin 9.1, and later translated the model into physical model using the Forward Engineering technique.
• Responsibilities included analysis, data mapping, design, QA testing and documentation of applications in support of end-user access to the Data Warehouse.

Confidential, Bloomington, IL

Data Analyst

Responsibilities:

• Provide support across different domain areas such as Auto Assignment, Payments, Claims Data and Appointment Logs, Auto Estimations, Fire Claims etc.
• Part of team conducting logical data analysis and data modelling, communicated data-related standards.
• Worked with Data Warehouse in the development and execution of data conversion, data cleaning and standardization strategies and plans as several small tables are combined into one single data repository system MDM (Master Data Management).
• Carefully examine data and reports to make sure conversion is proceeding correctly, run test scripts with various data to see how new or customized transactions process through the software and verify and validate accuracy of data through the generation of a variety of reports.
• Responsible for defining the key identifiers for each mapping.
• Supported User-Acceptance phases by performing data validations and metrics calculation across every layer including source systems, Staging, Mart and MicroStrategy layer.
• Scheduled data refresh for Power BI dashboards on periodic basis enable the display of the most current data on the dashboards.
• Deployed SSRS reports and published Power BI dashboards to share them with the appropriate users. Created multiple roles, with appropriate privileges for different users.
• 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 data models that capture current state/future state data elements and data flows using Erwin.
• Wrote Test cases for Enterprise Data Warehousing (EDW) Tables and Data Mart Staging Tables.
• Responsible for executing User Interface Testing, System Testing, Data 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 data model and business requirements.
• Loading staging tables on Teradata and further loading target tables on SQL server via DTS transformation Package.
• Involved in requirement gathering and database design and implementation of star-schema, dimensional data warehouse using Erwin.
• Used BEA (BPM Tool) to map Process flows and migrated Visio Process flows into BEA Tool.
• Created Data Dictionary and ER diagrams for data mapping purposes.
• Performed source data profiling to verify that data 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.

Confidential, Madison, WI

Data Analyst

Responsibilities:

• Document all data mapping and transformation processes in the Functional Design documents based on the business requirements.
• Provide support to end users of BI Applications from system analysis to BI/ETL development and support
• Involved in Data mining, transformation and loading from the source systems to the target system
• Involved in defining the source to target data mappings, business rules, business and data definitions
• Provided quality data review for completeness, inconsistencies, erroneous and missing data according to data review plan
• Prepared High Level Logical Data Models using Erwin, and later translated the model into physical model using the Forward Engineering technique.
• Was responsible in using MDM to decide how to manage their life cycle, cardinality, complexity and Collect and analyze metadata about the master data.
• Loaded operational data from Oracle, flat files, XML files, Excel spreadsheets into Oracle target data mart and used
• Informatica Power Exchange for mainframe sources, such as COBOL files.
• Extensively used Informatica Power Center Designer to create a variety of mappings including expression, sequence generator, source qualifier, router, joiner, update strategy, aggregator, stored procedure, and lookup transformations with embedded business logic.
• Contributed to the initial data mining work and development of tools and technology
• Produced system documents, functional requirements, ETL mapping and modeling deliverables Worked with root cause of data inaccuracies and improved the quality of data by using Data Flux
• Worked on data profiling, data mining, data cleansing and other validations like integrity checks, DB consistency checks for data quality.
• Wrote complex SQL, T/SQL Testing scripts for Backend Testing of the data warehouse application.
• Assisted developers and testing teams to ensure that the requirements are communicated accurately and that the system being developed is verifiable against the requirements
• Tested whether the reports developed in Business Objects and Crystal Report is as per company standards.
• Involved in pre and post session migration planning for optimizing data load performance.
• Facilitated periodic data loading by using reusable transformations, mapplets and worklets.
• Worked on performance tuning of the SQL queries, Informatica mappings, sessions, and workflows to achieve faster data loads to the data mart.
• Extensively used SQL DDL/DML commands with TOAD environment to create target tables and perform different testing for accuracy & quality.

Confidential, Hartford, CT

Data Analyst

Responsibilities:

• The major job involved the cleansing and normalization of the data in the staging area then loading data to the data marts.
• Utilized Informatica toolset (Informatica Data Explorer, and Informatica Data Quality) to analyze legacy data for data profiling
• Performed Detailed Data Analysis (DDA), Data Quality Analysis (DQA) and Data profiling on source Data.
• Database table review and data mapping for large scale data conversion project Oracle database to Mainframe.
• Provided technical support during delivery of MDM (Master Data Management) components.
• Generated reports (SSRS/Crystal) from SQL Server Database and Cubes and included parameterized and cascading parameterized reports to populate drilldowns, drill through, and sub-report.
• Created intricate set of SQL tables to hold user login and user access information with constraints and access errors were logged in to error tables.
• Responsible for creating weekly and monthly reports for management based on Cognos data.
• Reviewed the logical model with application developers, ETL Team, DBAs and testing team to provide information about the data model and business requirements.
• Conducted UAT for data integrity. Analyzed user requirements, attended Change Request meetings to document changes and implemented procedures to test changes.