SUMMARY

• Well - qualified Data Analytics professional with 8+ years of industry experienced working with vast data sets to break down information, gather relevant points and solve advanced business problems.
• Skilled in predictive modeling, optimization, data mining and Statistics.
• Experienced working in Finance, Banking, Insurance and Retail Applications.
• Strong experience in Data Analysis, Data Migration, Data Cleansing, Transformation, Integration, Data Import, and Data Export.
• Profound knowledge of various banking and finance fundamentals like capital markets, equities, financial databases, general ledger, accounts payable/receivable, risk management, derivatives contracts etc.
• Self-Motivated and quick learner and enthusiastic to learn new technologies/tools.
• Extensive experience & coordination skills in an Onsite-Offsite model environment.
• Excellent Communication, Leadership, and Interpersonal skills with clear understanding of business logic.
• Well versed in Normalization / De-normalization techniques for optimum performance in relational and dimensional database environments.
• Experience in setting up connections to different RDBMS Databases like Oracle, SQL Server, DB2, Teradata according to users’ requirement.
• Extensive experience with OLTP/OLAP System and E - R Modelling, developing Database Schemas like STAR schema and Snowflake schema used in relational, dimensional, and multidimensional Modelling.
• Experience in implementing Master Data Management (MDM) solutions, project management and Business Analysis Principles.
• Demonstrated ability to execute end-to-end data analysis projects.
• Thorough understanding of Anti Money Laundering (AML) procedures
• Experienced in Pricing Analytics.
• Experience in writing complex SQL queries and optimizing the queries in Sybase, Oracle, and SQL Server 2000.
• Hands on experience on Hadoop /Big Data related technology experience in Storage, Querying, Processing, and analysis of data.
• Experience in creating Logical Data model and Physical data models Using ERWIN.
• Experience in all phases ofSoftware Development Life Cycle(SDLC), Waterfall and AGILE methodologies. Performed various system - related analytical activities within all the phases.
• Thorough Knowledge in creating DDL, DML and Transaction queries in SQL for Oracle and Teradata databases.
• Thorough working knowledge of SharePoint and MOSS, (TFS) Team Foundation Systems and Visual Studio Team System (VSTS).
• Extensive experience working with Business Intelligence data visualization tools with specialization in Tableau Desktop, and Tableau Server.
• Proficient in Analyzing System & Functional Specifications, Use Cases, Business Requirements, Business Rules to Identify Test Requirements, track the requirements (Bi-Directional traceability matrix).
• Extensive experience in conducting Data Analyses, Data Mapping, Data Profiling, Gap Analysis.
• Experience with SAS/BASE, SAS/GRAPH, SAS/SQL.
• Strong understanding Data warehouse and BI Analytics concepts.
• Knowledge inDataAnalysis,DataValidation,DataCleansing,DataVerification and identifyingdatamismatch.
• Experience in preparing test strategy, developing test plan, detailed test cases, writing test scripts by decomposing business requirements, and developing test scenarios to support quality deliverables.
• Working knowledge on salesforce table structures.
• Experienced in requirements gathering and analysis using various elicitation techniques
• Expertise in performingGAP analysis, Requirements Traceability Matrix (RTM), Data mapping.
• Extensive experience in Functionality of Web applications.
• Expertise in backend testing. Experience in writing SQL queries (Inner join and Outer joins and Functions).

TECHNICAL SKILLS

Operating Systems: Windows, UNIX.

ETL / Reporting: Informatica, Business Objects, Tableau

Testing Tools: Quality Center, QTP, JIRA

RDBMS: SQL, SQL Server, Oracle, MDM, Hadoop, MySQL, DB2, Teradata and PL/SQL, MS Access

Microsoft Package: Microsoft Excel, Power Point, Word & Visio

Scripting Language: Jscript, VBScript

Application Server: IIS, Apache, Tomcat, JBoss

Languages / Web technologies: SAS, C, C#, Java, .NET, JSP, ASP, XML, HTML, DHTML, Delphi, SQL, PL/SQL

Methodologies: Agile, Waterfall

Versioning tools: GIT, SVN

Reporting Tools: Tableau, Spotfire

Predictive Modeling: Linear Regression, Logistic Regression, Clustering, KNN, Naïve Bayes

PROFESSIONAL EXPERIENCE

Confidential, Memphis, TN

Sr Data Analyst

Responsibilities:

• Performed revenue impact analysis on various pricing logic changes using SAS and SQL.
• Performed post launch measurement analysis on various pricing logic changes and presented the insights to business.
• Utilized Tableau to perform what if analysis of various scenarios on surcharge changes.
• Created data for customer and sales facing tool by combining data from various sources using SAS and SQL.
• Worked on the Data collection plan to load the data from different sources into the data lake. Created Sqoop jobs to load data from Teradata and Oracle into Hadoop.
• Developed key metrics on Customer interaction journey by analyzing logs from Emails, IVR, chat, SMS and Calls using SAS, SQL and Spotfire.
• Involved in data cleaning to rid the system of old, unused data, or duplicate data for better management and quicker access.
• Created Tableau reports and dashboards for data visualization and mining to identify the trends and patterns in the data.
• Worked with the DBAs on maintaining existing, and creating new, database Tools & Technologies and communicate to leadership within our company to convey the importance and business value of data descriptions for entities, attributes, domain values and relationships using data modeling tools to create Entity Relationship Diagrams.
• Created Data stage jobs (ETL Process) for populating the data into the Data warehouse constantly from different source systems.
• Served as a resource for analytical services utilizing SQL Server and TOAD/Oracle and Created SQL queries using TOAD and SQL Navigator and created various databases object stored procedure, tables, views.
• WroteHiveQLqueries by configuring number ofreducersandmappersin the query needed for the output.
• Designed and developed SSIS packages (ETL)to extract data from different data sources like SQL Server, Flat Files, Excel source files, XML files etc. and then load the data to various destinations like Excel, Flat File, OLÉ DB, Raw File, Data Reader etc.
• Created various reports for Business team using calculations, pie chart, bar graph, Geographic maps etc.
• Extensively involved in analyzing variousdataformats using industry standard tools and effectively communicating them with business users and SMEs.
• Assigned the work to offshore team and tracked the progress and communicated with a manager.
• Involved in Defect Review meetings with Business Core Team and Developed use-case Analysis.
• Validating theData filesfrom source to make sure correct data has been captured to be loaded to target tables.
• Validating the load process of ETLto make sure the target tables are populated according to thedata mappingprovided that satisfies thetransformation rules.

Environment: Oracle, SQL Server, SSIS, SAS, Teradata, Hadoop, Sqoop, Spotfire, Hive, Tableau.

Confidential, Norfolk, VA

Sr Data Analyst

Responsibilities:

• Analyzed and documented client's business requirements and processes; communicate these requirements to technical personnel by constructing basic conceptual data and process models, including data dictionaries and volume estimates.
• Performed extensive data profiling on source systems data to identify data anomalies.
• Performed extensive data analysis on finding data integration issues on different interrelated data domains.
• Used SAS Enterprise Guide (SAS EG) to automate coding which enables to build a VBScript (.vbs) to execute the entire project or just specific elements of the project
• Create various Data Mapping Repository documents as part of Metadata services (EMR)
• Analyzed thedata warehouse project database requirementsfrom the users in terms of thedimensionsthey want to measure and the facts for which the dimensions need to be analyzed.
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Designed different type of STAR schemas for detailed data marts and plan data marts in the OLAP environment.
• Created SSIS Packages using Various Transformation like Lookup, Derived Columns, Condition Split, Data Conversion, Aggregate, Merge Join, Sort, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Extensively used Informatica Data Explorer (IDE) & Informatica Data Quality (IDQ) profiling capabilities to profile various sources, generate score cards, create and validate rules and provided data for business analysts for creating the rules.
• Created/Reviewed data flow diagram to illustrate where data originates and how data flows within the Enterprise Data warehouse (EDW).
• Strategically aligned data, metrics, and technical solutions to build integrated products for business insights and action.
• Wrote SQL scripts extensively to identify data quality and integration issues in existing data warehouse and Data Mart tables.
• Created scorecards to monitor the data quality metrics and set up the email notifications to the Data stewards and Governance team if any changes in the threshold.
• Examined Key Performance Indicators KPI for Property and Casualty such as Loss Ratio, General Operating Expense Ratio.
• Performed research on data management, reporting and analytic methods and tools to improve service to internal customers.
• Supported Data cleansing, Match & Merge and Tokenization rules on Customer and Product Master data sets to eliminate duplicate records and data quality issues.
• Performed data profiling using Informatica IDQ and shared the profiling results with source system and Data Governance team.
• Evaluated and enhanced current data models to reflect business requirements.
• Consolidated and updated various data models through reverse and forward engineering.
• Assessed requirements for completeness and accuracy and determined if requirements are actionable for ETL team.
• Maintain a complete understanding of and adheres to all IT policies and processes.

Environment: Oracle, SQL server, SSIS, SAS EG, Informatica, Informatica IDQ, Tableau, MS Access, Agile methodologies

Confidential, Chevy Chase, MD

Sr Data Analyst

Responsibilities:

• Project followed Agile SDLC methodology for Guide wire Policy Center Integration in different sprints.
• Worked under Agile/Scrum methodology (user story, product backlog, risk prioritization, sprint planning, product backlog grooming, daily stand ups, sprint retrospective, sprint demo)
• Worked closely with the business users, Stakeholders and SMEs to identify, document and analyze the business process that was currently being followed to improve the time efficiency of the processes.
• Worked on insurance Billing System as a Subject Matter Expert on migrations, conversions, upgrades, and integrations of CSG and AS400 systems.
• CompletedDataMapping for Group and detail Product analysis and report writing.
• DevelopedDataMapping and Crosswalk documents.
• Identified the field/column level data quality issues of the source systems to drive the data quality, data cleansing and error checking in the mappings. Identify and document the source to target mapping data lineage.
• Performeddataanalysis, createddatamapping anddatainterface documents, and kept the documents updated with
• Worked on the Enterprise Meta data repositories for updating the metadata and involved in Master Data Management (MDM).
• Created Data Quality Scripts using SQL and Hive to validate successful data load and quality of the data. Created various types of data visualizations using Python and Tableau.
• Frequently used Requirements Traceability Matrix (RTM) for identifying and tracing the linkages among Policy Center,Billing Centerand Claim Center
• Created and maintained User Stories by interviewing the SMEs regarding Policy Administration Aspects and understood the quote variance elements.
• Defined the scope & financial projections, also performed Cost/Benefit Analysis, Risk Management and GAP Analysis.
• Managed General Liability, Commercial Property, Commercial Package, Commercial Auto andWorkersCompensationpolicy lines.
• Involved in integration between Policy Center, Claim Center and Billing Center.
• Involved in the Test Plan document preparation.
• Participated inScrum/Agile ceremonies, back log refinement, dailyscrums, sprint planning, sprint review and retrospective
• Extensively used agile methodology throughout the SDLC process.
• Worked inXML, SQL Server, JIRA, Working on Transformations inXML.
• Prepared requirements document for Commercial Auto, Inland Marine, Crime, Worker's Compensation, Umbrella,BusinessOwners Policy, Commercial Output Policy, and Commercial Property Package
• Designed and implemented basic SQL queries for testing and report/data validation
• Developed schemas for extraction, transaction, and loading (ETL) using Solonde Warehouse Workbench to expedite data integration between systems.
• Involved in testing the conversion of the application into web application using XML web services.
• Created translation document for requirements between Policy Center and Billing Center systems
• Performed Structured walk-through testing with QAs and developers, to analyze the root cause of flaws. Responsible for preparation test cases, test scripts, Decision tables and documented it for regression testing.
• Developed strategic partnerships with the business unit to develop a solid knowledge base of the business line, including the business plan, products, and processes.
• Conducted walkthrough sessions with stakeholders including end users, technical team and aided in developing user manuals.
• Worked with QA team to develop and execute Test Plan Document defining Test Cases and Test Scripts.
• Played a key role in conducting User Acceptance Testing (UAT) by managing identified issues and ensured all issues were resolved.
• Identify business, functional, and technical requirements through meetings and interviews and JAD sessions.
• Identified and analyze stakeholders and subject areas.

Environment: Oracle, SQL server, Jira, Informatica, Informatica IDQ, Tableau, Agile methodologies, UAT, objects, Informatica Validator

Confidential, Riverwoods, IL

Sr Data Analyst

Responsibilities:

• Updated or created new data models for each release and generated database scripts from Erwin.
• Used Erwin to create report templates. Maintained and changed the report templates as needed to generate varying data dictionary formats as contract deliverables.
• Worked with the DBAs on maintaining existing, and creating new, database Tools & Technologies and communicate to leadership within our company to convey the importance and business value of data descriptions for entities, attributes, domain values and relationships using data modeling tools to create Entity Relationship Diagrams.
• Created Data stage jobs (ETL Process) for populating the data into the Data warehouse constantly from different source systems.
• Analyzed and designed the business rules for data cleansing that are required by the staging and OLAP & OLTP database.
• Involved in working with source to target mapping documents for Pension & Retail products tables enhancements.
• Updating and maintaining existing test Matrix and test cases based on code changes and enhancements to assigned applications.
• Contribute to the development of knowledge transfer documentation.
• Involved in test preparation activities and test execution activities from authoring test scenarios, test cases, execution plan, identifying test data and executing test cases
• Experienced in test case design from requirements, use cases, wire frames and from user stories.
• Performed Data profiling, Validation, and Integration.
• Involved in Data analysis for data conversion - included data mapping from source to target database schemas, specification and writing data extract scripts/programming of data conversion, in test and production environments.
• Consulted with application development business analysts to translate business requirements into data design requirements used for driving innovative data designs that meet business objectives.
• Involved in information-gathering meetings and JAD sessions to gather business requirements, deliver business requirements document and preliminary logical data model.
• Perform data profiling on elements, entities, and entity relationship, data reconciliation, Data Extract, identify elements for metadata standardization.
• Worked with the Business team to get the metadata approved for the newdataelements that are added for this project.
• DevelopedDataMigration and Cleansing rules for the Integration Architecture (OLTP, ODS, DW)
• Analyzed all errors generated by Informatica and fixed those errors in data collection.
• Used forward engineering to create a Physical Data Model withDDLthat best suits the requirements from the Logical Data Model.
• Prepared low-level design documents and S-T Mapping sheets to convert business requirements into functional specifications.
• Documented the data requirements and system changes into detailed functional specifications.
• Updated and created new data models for each release and generated database scripts from Erwin.
• Created Data stage jobs (ETL Process) for populating the data into the Data warehouse constantly from different source systems.
• Analyzed and designed the business rules for data cleansing that are required by the staging and OLAP & OLTP database.

Environment: Oracle, ERWIN, ETL, OLAP, OLTP, SQL Server,Informatica, QC, Agile methodologies, MS Office, PowerPoint, Jira, Jama Erwin9.0, SQL Server2008, MS Visio, Oracle10g, UNIX, Linux, TOAD, SQL, PL/SQL, Oracle, Teradata, Netezza, XML, Informatica, Tableau, MS Visio, MDM, PowerBI.

Confidential

Data Analyst

Responsibilities:

• Worked under Waterfall and agile environment models.
• Developed SQL Queries/Scripts and similar Artifacts to validate the Completeness, Integrity and Accuracy of Data within an ETL process testing cycle.
• Performed Data Analysis and developed Data Mapping documents for ETL (SSIS) projects.
• Developed Test Cases and SQL Queries to perform various Validations.
• Performed Count Validation, Source Isolation, Dimensional Analysis, Statistical Analysis and Data Quality Validation in Data Migration.
• Executed Test Cases with respect to Source and Target database tables.
• Used Agile Test Methods to provide rapid feedback to the developers significantly helping them uncover important risks.
• Did extensive work with ETL testing including Data Completeness, Data Transformation & Data Quality for various data feeds coming from source.
• Worked with all Instrument types includes Equity, Government bonds, Swaps and Currency.
• Extensively tested several Business Objects Reports - Crystal’s reports and Dashboards to validate the reports the data and cosmetics of the report.
• Participate in the discovery, documentation and presentation of rules, issues, metadata, and business/technical decisions for the Data Warehouse.

Environment: Oracle, SQL server, QC, Crystal Reporting, MS Office, PowerPoint