SUMMARY:

Passionate Business and Data Analytics professional with experience in the field of Healthcare, Banking, Real - Estate, Telecommunication, NGO and Retail. Strong Business and Functional knowledge of the working industries. Outstanding Academic Background besides Significant Years(7) of working experience in distinguished companies.

PROFESSIONAL SUMMARY:

• Highly knowledgeable in the field of Data Analytics, Insight Reporting, Data Visualization and Data Modeling.
• Experienced with Synthetic Data Generation, Service Virtualization, capture Project Requirements, maintain Project Versioning.
• Established capability of formulating insight using BI tools - Tableau, Qlik View, SAS and Power BI. Proficiency of using Google Analytics, Data Studio and Google Sheets.
• Efficient in Functional and Business Requirement Document, Business Process Flow, Use Case Diagram and Document and Change Requirement Document formation.
• Solid understanding and proficiency in Data Mining, Variable Selection, Clustering, Model Formation - Regression - (Logistic, Polynomial, Multivariate, Multiple, Linear), Time Series, KNN and Model Validation.
• Extremely knowledgeable about R Programing principles and creating Matrix, Bind, Variables and Vectors. Also proficient in Data Analysis, Preparation, Manipulation, Visualization and Functions.
• Highly proficient in using Tableau to create Interactive Dashboard, Story Line with different Charts, creating Calculated Field in a Blend, Reference Line with Parameters, Filters and adding Actions.
• Working Experience on Salesforce - Classic and Lightning. Formulating Reports, Joining Tables, Creating Charts and Presenting Insights with Interactive Dashboard.
• Experienced in Data Wrangling and Modeling, Process Optimizing, using tools like Python, R, STATA, SPSS and MS Excel.
• Collaborating with Manual and Automation Testing Team to support the functional process
• Knowledgeable about the RDBMS concepts and Data Extraction, Transformation and Loading (ETL) process using tools like Informatica.
• Knowledgeable about Developing complex mappings involving SCD Type - I and II mappings in Informatica Power Center to load data from various sources
• Extensive knowledge of using complex SQL Queries for Aggregation, Triggers, Sequences, Local and Global Variables, Indexes, Slowly Changing Dimensions and more.
• Designing and developing complex mappings from varied transformation logic like Unconnected and Connected lookups, Source Qualifier, Router, Filter, Expression, Aggregator, Joiner, Update Strategy etc using Informatica Power Center.

TECHNICAL SKILLS:

RDBMS and ETL: Oracle SQL, MS-SQL Server, SQLite, MySQL, Informatica Power Center

Statistical Tools: R, STATA, SAS, SPSS, MS Excel and Analytics Solver

Business Intelligence: Tableau, Qlik View, Power BI, Salesforce & Data Studio

Language: UNIX Shell Scripting, R, Python, JavaScript, HTML, XML, JSON, BeanShell

Other Software: CA - TDM/TEM, Postman, GitLab, Visio, Outlook, JIRA, SharePoint

PROFESSIONAL EXPERIENCE:

Sr QA Analyst - Data Management (IT)

Confidential, Atlanta, GA

Responsibilities:

• Support Test Data Management (TDM) and Test Environment Management (TEM) in order to formulate Synthetic Data and Service Virtualization to facilitate the manual and automation test team.
• Understand and research the application behavior and mapping end points in order to create Requirements for POCs and singular Project Module.
• Create Project and Network Connection using TDM tools, register relational Database Objects, control Project Level Versioning, formulate required Variables and data generator using TDM functions
• Check the Application and Environment level log files in order to debug any error in the process of data generation or connectivity and resolve the issues.
• Capturing Network Payload and process the JSON transactions in order to create Collections in Postman to support the data generation for automation team using the service through API
• Use Datamaker and Agile Requirement Designer in order to create Data Pool and Properties for the data generator, create required Pre and Post Publish Actions using SQL and Batch Script, design the Data Flow Model and User Interface
• Formulate cURL command to connect with Test Environment Management (TEM), use Groovy, BeanShell, IBM MQ, REST API in order to create Virtual Service and capture response from TDM
• Maintain Administrative and User level Documentation for the project deployment, use GitLab and SharePoint to share and access project level resources
• Maintain work level Effort and priority Backlog in JIRA. Create, Update and Assign Tasks to designated team members. Follow up the progress in Weekly Team Standup and Monthly Department Meeting.
• Go through the required Training and Resources in order to support and be in Compliant for Healthcare Industry.
• Develop Windows Batch Scripts to extract and share data files from/to external servers.
• Involved in System Integration Testing, User Acceptance Testing and implementation of code to production.
• Involved in Production Support and Root Cause Analysis.

Data Analyst

Confidential, Atlanta, GA

Responsibilities:

• Perform SQL query, Group, Join and Filter data to formulate insight and interactive dashboard to present to the Executives and Board Members using Tableau, Salesforce and Data Studio.
• Perform queries with Informatica Power Center to Extract, Design Mapping and Develop database support for Board Member, Clients and Supporting Organization for Business Analysis.
• Analyze Hard or Soft form of giving in Salesforce environment and evaluate donor performance.
• Use Tableau, Google Analytics, Google Data Studio and Salesforce to analyze the campaign performance following the required KPIs.
• Assist the Operation and Development Manager in all aspect of data management in the organization’s database.
• Understand Non-Profit organizational KPIs and develop report to forecast further funding.
• Involved in performance tuning of mapping, creating reusable objects, creating mapping using Update Strategy, Lookup, Filter, Router, Joiner and Aggregate using Informatica Power Center.
• Provided Technical Assistance and support to IT Analysts and business community.

Business Intelligence Analyst

Confidential, Atlanta, GA

Responsibilities:

• Transform raw business data into action items using Informatica Power Center, create interactive Tableau platform, formulate findings and suggest process improvement ideas.
• Perform the team day-to-day planning and problem solving to Meet Deliverables and act as single Point of Contact in running business data management.
• Involved in Analysis, Change/Requirements Gathering and Documenting Functional and Technical specifications.
• Work with various teams in Agile Environment.
• Maintain work level Effort and priority Backlog in JIRA. Create, Update and Assign Tasks to designated team members. Follow up the progress in Daily Team Standup and Weekly Department Meeting.
• Processing data stored in various file formats like Json, Xml, Csv, txt, tsv etc.
• Perform SQL Queries, Groping, Joining, Filtering and Updating for Root-Cause Analysis on internal and external data to answer specific business question. Identify Insights and suggest ways of improvement.
• Apply quantitative techniques using R Programing to uncover concealed patterns in the data and provide research and administrative assistance for special projects as assigned.
• Use R and Tableau Prep for data mining (Clipping, Sorting, and Calculating) to remove outlier and extract an unified data set for further processing.
• Collaborate data sources and formulate Dashboard for presenting insight using Tableau.
• Develop SQL query to be used with Automated Processes to identify revenue opportunities and potential customer.
• Independently Query and Analyze Unstructured Data from multiple databases in order to diagnose data quality issues, Assess system impacts, Define data processing rules and Conduct functional testing as required by the business.
• Use Unix Command and Unix Shell Scripting to interact with the server and to move flat files and to load the files in the server

Account Manager

Confidential, Atlanta, GA

Responsibilities:

• Serve current classified customers by Managing Red Bull Product Portfolio and ensuring utilization of current promotions, planograms, and marketing tools.
• Establish and maintain regular and on-going communications with retail partners in order to successfully Implement National and Local Programming .
• Monitor competitor activities including New Product Launches and Price Developments.
• Achieve monthly key performance indicators (KPI‘s) in the following areas: Sales, Distribution, Pricing, Placement, and New Accounts.
• Bring a sense of urgency and commitment along with desire to get things done.
• Maintain a high level of communication across the designated team.
• Ensure all Red Bull gear is in standard operational order and appropriately engaged.
• Build and Protect the Brand Image of Red Bull.

Marketing Analyst

Confidential, Atlanta, GA

Responsibilities:

• Maximize Business Market through exceptional customer targeting, product portfolio, promotion and remarkable site image both inside-outs.
• Provide Business Insight to Operation Management by recapping promotional activity; report business opportunities, results, trends and competitive statistics.
• Analyze Controllable Charges and educate the management team on procedures for controlling product variation. Analyze and report market operation expenses.
• Collaborate with marketing and operation team to Ensure Promotions and New Product Introductions are fully implemented. Report to Category Managers concerning inventory management.
• Partner with Vendors to ensure products are available. Timely execution and Performance Review of Monthly Promotion Planner . Ensure vendor's performance and behavior is professional.
• Supervise and Train Operation Managers in use of service module, tools and materials. Ensure compliance with requirements.

Business Analyst

Confidential

Responsibilities:

• Execute, Monitor and Supervise Project Development Activities and ensure that the ongoing project works are in progress accurately and timely as per approved specification and schedule.
• Maintain Close Liaison with Engineers/Product Owners and other team members in the department for effective and efficient operational activities of the department.
• Prepare Periodical Reports on the progress and development of ongoing projects.
• Involved in Analysis, Business Requirements Gathering and Documenting Functional and Technical specifications.
• Consult with the Project Owner & Stakeholders on the Feasibility of Operation and Development Issues of the project and contribute to make proper management decision.
• Supervise Developers and make sure they are Well Engaged and not Distracted during development cycle.
• Facilitate effective exercise of internal and external resources to identify efficiency and Improvements in Project Quality, Reliability, Costs, Schedule or other parameters that enhance company's strategic edges.
• Monitor Expenditure to avoid spending more than client budget and also ensure the capital allotted for project is enough to complete it as earlier discussed with the client and management.
• Use of performance management techniques to Monitor and Demonstrate Achievement of Agreed Service levels and to lead on improvement.
• Maintain Production Support backlog and ensure their Level of Priority for Development.