SUMMARY

• Accomplished Data Analyst with a strong background in Business and Data Analysis projects within Retail, Insurance, Healthcare, and Indirect Tax domains.
• Experience working very right from ‘as is’ and ‘to be’ stage of the project.
• Experienced inbusinessprocess engineering and Software Development Life Cycle (SDLC) methodologies including Waterfall, Agile and SAFe Agile in multiple projects following various iteration schedules based on project needs and support.
• Created and implemented source to target mapping documentation for the ETL process.
• Experience in working with project managers, product owner’s, subject matter expert’s and cross functional teams during various project implementations.
• Experience in Data Validating, Data Mapping, Data Profiling, Data Migration, Data Conversion, Data Cleansing, Data Quality, Data Ingestion and Data Integration.
• Performeddataanalysis anddataprofiling using complex SQL on various sources.
• Experience in using MS Excel to analyze thedatabased on business needs.
• Experience in development of reports and dashboards using Tableau.
• Extensive experience in working with Tableau 9.0 and 10.x Desktop and Tableau Server.
• Worked in SAFe Agile, Agile, Waterfall environments on multiple projects following various iteration schedules based on project needs and support.
• Experience in handling large databases to perform complexdatamanipulations.Maintaining customer/client’s confidential data with high security while sharing with internal and external team.
• Knowledge in identifying Facts and Dimensions, Star Schema and Snow Flake Schema for modeling aDatawarehouse in Relational, Dimensional and multidimensional modeling.
• Good at oral and verbal communications with strong leadership abilities.

TECHNICAL SKILLS

Databases: SQL Server, MS - Access, MongoDB, Oracle SQL Developer

DWH/BI Tools: SSIS, Clover-ETL, Talend, Tableau 10.x, Visio, Netezza, Teradata

SDLC Methodologies: SAFe, Agile development and Waterfall

Technical Skills: SQL, Excel, SharePoint, Python (beginner), SFTP, Visio, Erwin, IBM Campaign

PROFESSIONAL EXPERIENCE

Data Analyst/Data Ingestion Developer - Communication Manger

Confidential - Blue Ash, OH

Responsibilities:

• Which is useful to build the Enterprise Communication Manager tool. The tool is a decision maker to target right customer with right channel with right content at right time.
• In-depth understanding of how customer segmentation and customer targeting is happening through data science by 84.51.
• Worked on IBM Campaign Manager to create campaigns like Single subject emails (SSE), Multi subject emails (MSE), Friday Deals, etc., also worked under the campaign manager for campaign creation.
• Discovered and understanding of how Direct Mail, Email, SMS, Mobile Push, Web, Social Media, etc., communication channels are working and processes in entire Kroger eco-system.
• Creating the ‘as is’ process and data workflow into the Visio for each discovery of system and team.
• Extensively using the Netezza data ware house and understanding how data moves from one data mart to the another. Writing complex SQL queries in Netezza to create the customer profile and contact history.
• Conducting interviews and brainstorming with cross functional teams and internal teams to understanding all data points which are useful to ingest into Enterprise Communication Manager.
• Identifying transactional data, clickstream data, customer PII data, and contact history data in Netezza marts and creating 3000 customer obfuscated data to build customer profile for the conference room pilot.
• Created the use cases and test cases to the vendors for Conference room pilot.
• Created Data dictionary and data model for conference room pilot.
• Extensively involved in Salesforce pilot and Conference room pilot to finalize the vendor selection.
• Interacting with cross functional teams to identify their systems and processes.
• Understanding how each system can be interacted to Communication Manager and created ‘as is’ data flow and business flow for the identified systems.
• Involved in Business and Architect meetings in creating ‘to be’ analysis for the communication manager.
• Involved in selecting the vendor to build Enterprise Communication Manager. Helped in creating ‘use cases’ and ‘test cases’ for vendor selection.
• Creating business and data flow diagrams in Visio.
• Voluntary participation in end to end testing for Marketing Operations tool.
• Planning the sprint stories from features during the Iteration Planning (PI) for Completes the stories on time in a SAFe Agile environment.
• Maintains the documents in Confluence and OneNote.

Environment: Netezza DWH, Erwin, IBM Campaign, Salesforce, MS Office Suit, MS Teams, Visio, Jira, SAFe Agile.

Data Analyst

Confidential - Columbus, OH

Responsibilities:

• Responsible to create and update source to target data mapping document.
• Extensively used SQL for creating transformation logic for data mapping.
• Data validation on source to target mapping document to check the policy status.
• Understanding the Data Model to identify the facts and dimension tables.
• Daily standups in Agile environment.
• Providing technical clarifications forDataMapping/Transformation rules with Dev/Test teams.
• Peer review meetings with internal team, requirement analysts, and developers to understand the requirement to create mapping document.
• Generated SQL scripts to retrieve data from multiple tables. Handling large databases in Dev, Stage and Production environments.
• Evaluating data validation, profiling, mapping in day to day process.
• Responsible to provide deliverables on timely manner in heavy work load.

Environment: Oracle SQL Developer, Oracle-Toad 12.8, Oracle-Data Modeler 5.5, Visio, MS Excel, XML, RTC, Agile.

Business/Data Analyst

Confidential - Eden Prairie, MN

Responsibilities:

• Responsible for processing daily physicians query (PQ) files through SSIS and Talend.
• Creating SSIS packages and Talend jobs for business processes. Creating source to Target Mapping with data transformation logic.
• Using basic Java scripting to modify business logic in Talend job.
• Creating and updating SSIS packages and deploy in to production for the daily files.
• SSIS and Talend plays key role for all the ETL data operations to extract, manipulate and load the daily files received in respective formats.
• Used TAC and RUNDECK (online jobs to run Talend job) to move PQ letters from one folder to another, till the mail merge is done successfully.
• Generated SQL scripts to retrieve data from multiple tables. Handling large databases in Dev, Stage and Production environments.
• Involved in Unit testing and ran SQL queries for extracting specific data and validating applications.
• Handling client’s confidential data and maintaining with high security while sharing the data from clients and internal team.
• Mail Merging the PQ’s that includes all patient’s information in detail and generates the notices to send to the respective individuals.
• Evaluating data validation, profiling, cleansing, integration and extraction tools.
• Responsible in enhancing the existing dashboards, creating reports using Tableau desktop and publish that reports on Tableau Server.
• Responsible for generating ad-hoc reports in an accurate and timely manner as assigned.
• Used Quick filters, Data source filters, Global filters, and Context filters to restrict the data for securing patient information.
• Used Parameters, Calculated fields, Level of detailed expressions (LOD’s) to show more efficient information in Tableau reports.
• Experience in developing reports by Data Blending (SQL Server, MongoDB).

Environment: SSIS, Talend, SQL Server, MongoDB, Tableau 10.x, MS Office Suit, Visio, Java, SharePoint.

Business/Data Analyst

Confidential - Dallas, TX

Responsibilities:

• Gathering Business required documents and Functional required documents from the clients and SMP’s.
• Explaining developing team to fix the graphs in ETL tool, staging and production.
• Responsible for explaining Data specifications and Production logics to the client.
• Extensively involved in documenting the Source to Target Mapping documents with data transformation logic.
• Working on DataAnalysis, Data Validation, high level QA Testing, Loading, Quarterly reports, Pre-season and Season previews for the clients to generate 1094C and 1095C forms accurately.
• Conducted JAD sessions, Meetings, Teleconferences to gather business requirements from various Stake Holders and SME’S.
• Generated SQL scripts on clients 2016 and 2017 data specification to load into staging and production environment.
• Handling client’s confidential data and maintaining with high security while sharing the data from clients and internal team.
• Solving client data specification and data formatting issues on call and showing them in the WebEx.
• Evaluated data profiling, cleansing, integration and extraction tools.
• Experience with creating test data to replicate production data for Quality Assurance testing in all phases of developmental life cycle.
• Involved in performance tuning and Optimization of store procedures and complex SQL profiler.
• Responsible for training newAnalystonDataSpecifications, tools and Client Relations.
• Created the Pivot tables in MS Excel and explaining it to the leadership.
• Supporting Client and/or Engagement Managers relationships.
• Communicate with business/technology leadership for overall project/program office milestones.
• Coordinated and attended meetings to review the requirement specification with the quality Assurance Manager and other team members.
• Prepared User Acceptance Testing (UAT) document from Use Cases encompassing basic and alternate flows
• Actively participated daily and weekly basis on Client calls and explaining them to fix their data issues.
• Well versed with configuring the scripts from COMPASS 2.3 to 2.4 and 2.4 to 3.1. Responsible for creating complex business logic scripts by using TSQL.
• Performed entry level coding in SSMS databases, which extract raw payroll files, transform payrolldatato current system specifications, and export load-ready files.
• Utilizing different systems to identify client employees deemed eligible to generate tax credits.
• Creating projections and planning based upon several factors to project quantity and values of additional tax credits expected within established time frames.
• Consolidating calculations into respectable templates for review and use by internal and external clients.
• Assisted in developing new and improving existing tools to enhance processing efficiency and accuracy.
• Involved in multiple projects as needed. UAT 3.0 testing, Voyager, Compass view, 3.1 Deployment, etc.,
• Experience in manual testing the scripts.
• Additionally, involved in special projects in the ACA team.
• Keeping track of around 120 clients. Updating multiple trackers with incoming files and their status.
• Handling Client Inbound and Outbound Calls.
• Conducted GAP Analysis of the As -Is system to identify key areas of concern and addressed them with the Business team.

Environment: Clover-ETL Designer 4.0.4, SSIS, TSQL, SSMS, Tableau 10.0, MS Office Suit, Visio, Python PowerShell, Java, SharePoint, Internal tools (Voyager 3.1, Compass View, File Tracker).

Graduate Assistant

Confidential - Charleston, IL

Responsibilities:

• Assisted in initiation and use of newly developed, customized Access based on fiscal management system, troubleshooting system, made recommendations for improvement.
• Daily use of Self-Service Banner; intermittent use of other Banner products.
• Maintenance of financial data of the Biological Sciences Department faculty, staff and student’s transactions to support up-to-date budget status.
• Co-assist with account management and reporting of 40+ accounts.
• Departmental website updates using Access and Omni updates.
• Prepared travel vouchers, requests for payment, conference registrations, and PO’s.
• Maintained payroll documents and time reporting of graduate assistants.

Analyst

Confidential

Responsibilities:

• Work with users to identify the most appropriate source of record and profile/validate the data required for sales and service.
• Establish standards of procedures for public sector applications.
• Generate weekly and monthly asset inventory reports.
• Analyzed, designed and written functional and technical specifications and developed test plans and program enhancements for new releases.
• Involved in implementation of user logins, roles and profiles as a part of security policies for various categories of users.
• Scheduled the Reports to run on daily and weekly basis in Report Manager and email them to director and analysts to review in Excel Sheet.
• Our development team involves the website development based on HTML, SQL Server and other technologies
• Writing queries to retrieve, insertion of data into the SQL Server database in various environments.
• Developed charts, tables, and presentations to display website data for public use.
• Conducted market and user experience research forwebdesign
• Understanding look and feel User functionality of the website design that has been created by the team will reflect the client’s requirements and characteristics

Environment: HTML, XML, SQL Server, MS Office suit, Visio.