SUMMARY

• 4 years of experience in Data Analysis, financial Analyst and Technical Business Analyst Data Profiling, Data Migration, Data Conversion, Data Quality, Data Governance, Data Integration, Metadata Management Services, and Configuration Management.
• Familiar in SCRUM Agile Framework and Methodology with experience in Sprint Planning meeting and Sprint Retrospective meeting.
• Schedule meeting with Business and offshore with business problem and getting solutions.
• Daily standup and weekly WebEx and google handout meetings.
• Experience in development of Process Flow Diagram, Use Case Diagram, Activity Diagram, and Sequence Diagram using UML tool: MS Visio.
• Expertise in the Design, Development, Implementation and Testing using Data Conversions, Extraction, Transformation and Loading (ETL)
• Good understanding of Tableau Desktop 2019.2, 2020.3 for data visualization, Reporting and Analysis, Cross Map, Scatter Plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.
• Good understanding of Data Flow Diagrams, ER Diagrams, Data warehousing concepts, RDBMS and Normalization Techniques.
• Experienced in Cloud Services such as AWS EC2, S3 to assist with big data tools.
• Experience on Amazon Athena for data query and data validation, report generation and dashboard for Tableau.
• Experience in working with ETL environments like SSIS, and reporting tools like SQL Server Reporting Services (SSRS)
• Worked on Ad sales and bringing data from 3rd party vendor like Facebook, google, trade desk and daily load count and validate the data.
• Experience in importing, cleaning, transforming, and validating data and making conclusions from the data for decision - making purposes.

TECHNICAL SKILLS

Languages: SQL, R

Databases: SQL Server, Teradata, Zeppelin, Oracle, Teradata, Hadoop, Redshift, AWS

DWH/BI Tools: SSIS, SSRS, Tableau, Power BI

Data Modeling: ERWIN, MS Visio, Star & Snowflake Schema, Fact & Dimensions tables

Tools: and Utilities: SSMS, SQL Server Profiler, Import/Export Wizard, Visual Studio, Nexidia, MS Access, Excel, JIRA, RALLY, WISER, File Zilla

PROFESSIONAL EXPERIENCE

Confidential, Colorado Springs, CO

Data Analyst

Responsibilities:

• Currently involved in Nexidia P270 for call center Voice Data
• Exporting Data from Tableau to MsAccess and to Excel for Pivot
• Building TMS behavior on the Nexidia for agent performance
• Bringing Data from SFTP using File Zilla in csv and load into Data lake
• Currently transitioning to Alteryx and AWS for ETL and data storage.
• Bringing the raw data, Using Deduplication process storing it and use it for reporting
• Making Dashboard using call disposition, AHT(average handle time and Mutual silence)
• Using Power BI to make dashboard for call center data
• Reports for Supervisors(Level I, II) and Managers for coaching the agents
• Tracking agent performance with Negative and positive sentiments
• Advance SQL query using Ambari, Zeppelin and SQL server, SQL Server
• Making report using SSRS and MicroStrategy
• Tableau Dashboard using custom SQL query from Hadoop, HIVE and SQL server
• Worked on tableau 2019.2 and 2020.1 for building dashboard and publishing it to server
• Helped senior executives making decision using the dashboard and visualization
• Data validation on tableau server and changes on the regular basis
• Helped team with the data flow strategy and optimizing the query
• Heavily involved in ad-hoc and daily scheduled reporting
• Worked as a bridge between the speech analyst and big data team for the behavior scores of agents.
• Lead the Vendor(NICE) call every week with the JIRA ticket and resolution
• Creating and escalating the ticket in Wiser( Confidential ) system
• Worked with busines for SLA on reporting for the team
• Extracting reports from Tableau raw data and call dispositioning in excel with Pivot.
• Worked with data scientist and admin team with ETL process and bringing data to get the reports automated
• Data governance, data validation, Data visualizations.

Confidential, Englewood, CO

Data Analyst

Responsibilities:

• Worked on Tableau dashboard extracting data from Aws Athena and Redshift.
• Involved on Bringing third party add to in house(Facebook, Google, Kochava, Trade desk, Flashtalking) via API
• Checked and verify the ad clicks and impressions and tally with UI to see the discrepancies.
• Worked with Developers and ETL team in enhancing the models and co-ordinate the same with DBA in implementing those changes into the Database.
• Worked with business team to validate the granularity of the data, checked in the source and destination count.
• Performed data mining on data using SQL queries and discovered pattern.
• API calls using SOAP UI
• Connect with Business team on the daily basis and work with them for data validation.
• Executed SQL queries to verify that data has been moved from transactional system to DSS, Data warehouse, data mart reporting system in accordance with requirements.
• Used Existing Package deployment model and implemented Package Configurations and Deployed into Production.
• Identified, analyzed, defined, and documented business processes and Use Case Scenarios.
• Generating dashboards, reports in Tableau.
• Analyzing raw data, drawing conclusions & developing recommendations to Clients
• Created databases and schema objects including tables, indexes and applied constraints, connected applications to the database and wrote functions, stored procedures and triggers.
• Designed SSIS Packages to develop jobs for extracting, cleaning, transforming and loading data into database.
• Use Tableau for SQL queried data, and data analysis, generating reports, graphics and statistical analysis.
• Used Power BI in some few Ads projects.
• Compile and Generate Reports in a Presentable Format to the Project Team.

Confidential, Ventura, CA

Business/Data Analyst

Responsibilities:

• Worked on Data warehouse project. Created dashboard for Doctors, Nurse and Clinic Managers.
• Worked on dashboard for 3NA (third Next available for doctors), Vaccinations, and Smoking records for Managements.
• Worked on a Cerner data migration and training the employees for cerner use.
• Implemented Agile Methodology for building Integrated Data Warehouse and participated in multiple Sprints for various tracks throughout the project lifecycle.
• Worked closely with data mapping SME and QA team to understand the business rules for acceptable data quality standards.
• Developed Data Mapping, Data Governance, and Transformation and cleansing rules for the Master Data Management Architecture involving OLTP.
• Developed prototype solutions to verify capabilities for new systems development, enhancement, and maintenance.
• Used Informatica Power Center for Extraction, Transformation and Loading process.
• Worked in AWS EC2, configuring the servers for scaling and Elastic Load Balancing.
• Developed strategies and loading techniques for better loading and faster query performance.
• Created test cases based on test strategy, and test plans based on ETL Mapping document.

Confidential, Ventura, CA

Business/Financial Analyst

Responsibilities:

• Worked on targeting ad and campaign for the customers.
• Created customer database for the errors made from the restaurants
• Targeted marketing campaign based on their purchasing habits.
• Used QuickBooks for the past trends and financials
• Responsible for requirement gathering, analyzing, distilling and clearly conveying complex information to business and project team members.
• Assisted offshore teams building POS software as per the client requirements.
• Performed GAP analysis to identify mismatch between system functionality and business requirements.
• Used Tableau and designed various charts and tables for data analysis and creating various analytical Dashboards to showcase the data to managers.
• Proposed solutions and provide SAS programming code to import data into SAS, primarily from Excel, CSV, and text files to create a data set.
• Provide daily communications, scrum notes, sprint reviews reports, project retrospectives, and regular snapshots of project velocity.