SUMMARY

• Having 8+ years of professional experience in building Data Analytics and Business Intelligence infrastructure and solutions which led to increased efficiency in business operations.
• Closely worked with different management levels from Product, Technology, Finance and Marketing Teams to understand the business requirements and analysis needs.
• Attended daily standup meetings to discuss the tasks at hand and weekly meetings to present the status of tasks and reports.
• Proficient in design and development of various dashboards, reports on Power BI and Tableau Visualizations such as bar graphs, scatter plots, pie - charts, maps, funnel charts, lollypop charts, donuts, bubbles, etc. making use of actions and other local and global filters according to the end user requirement.
• Performed Data Analysis and Data Validation by writing complex SQL queries.
• Utilized all Tableau tools including Tableau Desktop, Tableau Server, Tableau Reader, and Tableau Public.
• Build better dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data.
• Experience with Tableau Server platforms.
• Extensive knowledge onData Profilingusing Informatica Developer tool.
• Experience in Performance Tuning and Debugging of mappings and sessions. Strong in optimizing the Mappings by creating/using Re-usable transformations, Mapplets and PL/SQL stored procedures
• Good Understanding of Visualization Techniques by creating summary and detailed reports Using Drill Down and Drill Through techniques.
• Extensive knowledge in various reporting objects such as Dimensions, Measures, Hierarchies, Filters, Actions, Calculated Fields, Sets, Groups, Bins, and Parameters etc. for summarizing and analyzing key analytics findings.
• Expertise in designing and developing filter driven interactive Dashboards, trend based KPIs, summary and detail reports featuring parameters, sorting, expressions, drill down and drill through, etc.
• Created summary and detail reports with drill down and drill through features using DAX Functions.
• Experienced in using Python for Exploratory Data Analysis (EDA) by analyzing data sets to summarize their main characteristics and then Visualization the findings using Jupiter Hub.
• Experienced in using Python for Data Preparation, Feature Engineering, Model Building, Evaluation and Deployment.
• Extensive experience in implementation ofData Cleanup Procedures, Transformation, Scripts, Stored Procedures and executionof Test plans for loading the data successfully into Targets.
• Extensive experience in using Python Libraries such as Pandas, NumPy, Matplotlib, Seaborne, SciPy and Scikit Learn.
• Hands-on experience on how to pull data by using SQL Server and also SSIS from database automatically.
• Great leadership qualities and excellent communication skills. Can work independently or within a team, self-motivated, determined, optimistic, willing to learn new technology. Ability to stay calm in stressful situations and adapt to new surroundings quickly.

PROFESSIONAL EXPERIENCE

Confidential, O’Fallon, MO

Senior Data Analyst

Responsibilities:

• Supported management team with reports generation and analysis using reporting and visualization on Power BI.
• Worked with Management teams from various departments to create departmental KPI reports for marketing, finance, product etc. to translate numbers and facts to inform strategic business decisions.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports using Power BI by analyzing sales figures & financial figures.
• Used Python for data cleansing and exploratory data analysis to help Oranum understand trends and its customers.
• Created Customer Dive Dashboards to analyze buying patterns of the customers which helped the marketing department to retain the existing customers and bring in new customers to the platform.
• Created a Psychic Deep Dive Dashboard for the Product department to help manage psychic performance and increase productivity.
• Created customer churn analysis report and used predictive analysis techniques to predict customers who may drop out and created flags for the marketing department to send them offers to retain them.
• Deeply analyzed customer satisfaction data to help improve customer satisfaction.
• Created Financial Reports highlighting areas of Sales growth, Sales Trends, Direct Expenses and Profitability to help the finance department take informed decisions.
• Used Power BI features to build and configure Hierarchical dimensions, Measure, Calculated Columns, KPI, Filter and Aggregations.
• Created and developed Power BI visualizations for the Key Performance Indicator (KPIs) and trend analysis.
• Generate joins and sub-queries for intricate queries involving multiple tables and fields.
• Expertise in data storage structures, data mining, and data cleansing.
• Established Logical and Physical database models to design source to target process.
• Created Logical/physical Data Model in Power designer and have worked on loading the tables in the Oracle based Data Warehouse.
• Used Common Table Expressions (CTE’s), Constraints, and Complex queries to fetch the data from different servers.
• Created frameworks and processes for data security to keep customers and payments data secure and confidential.
• Attended the project review meetings, daily/weekly status meetings and walkthroughs with project managers and leads.

Confidential, Dallas, TX

Data Analyst

Responsibilities:

• Analysisof functional andnon-functional categorized data elements for data profiling andmapping from source to target data environment. Developed working documents to support findings and assign specific tasks
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Worked with data investigation, discoveryand mapping tools to scan every single data record from many sources.
• Performed data miningon Claims data using very complex SQL queries and discovered claims pattern.
• Created DML code and statements for underlying & impacting databases.
• Extensively used ETL methodology for supporting data extraction, transformations and loading processing, in acomplex EDW using Informatica.
• Performdata reconciliation between integrated systems.
• Metrics reporting,data miningand trends in helpdesk environment using Access
• Written complex SQL queriesfor validating the data against different kinds of reports generated by Business Objects XIR2
• Extensively used MS Access to pull the data from various data bases and integrate the data.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Responsible for different Data mapping activities from Source systems to Teradata
• Assisted in the oversight for compliance to the Enterprise Data Standards
• Worked in importing and cleansing of data from various sources like Teradata, Oracle, flat files,SQL Server with high volume data
• Worked with Excel Pivot tables.
• Create and Monitor workflows using workflow designer and workflow monitor.
• Performingdata management projects and fulfilling ad-hocrequests according to user specifications by utilizing data management software programs and tools like Perl, Toad, MS Access, Excel and SQL
• Written SQL scripts to test the mappings and Developed Traceability Matrix of Business Requirements mapped to Test Scripts to ensure any Change Control in requirements leads to test case update.
• Involved in extensive DATA validation by writing several complex SQL queries and Involved in back-end testing and worked with data quality issues.
• Developed regression test scripts for the application and Involved in metrics gathering, analysis and reporting to concerned team and Tested the testing programs
• Identify & record defects with required information for issue to be reproduced by development team.

Confidential, Draper, UT

Data Analyst

Responsibilities:

• Involved in Data mapping specifications to create and execute detailed system test plans. The data mapping specifies what data will be extracted from an internal data warehouse, transformed and sent to an external entity.
• Analyzed business requirements, system requirements, data mapping requirement specifications, and responsible for documenting functional requirements and supplementary requirements in Quality Center.
• Setting up of environments to be used for testing and the range of functionalities to be tested as per technical specifications.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Performed data miningon Claims data using very complex SQL queries and discovered Health care claims pattern.
• Responsible for different Data mapping activities from Source systems to Teradata
• Created the test environment for Staging area, loading the Staging area with data from multiple sources.
• Responsible for analyzing various data sources such as flat files, ASCII Data, EBCDIC Data,Relational Data(Oracle, DB2 UDB, MS SQL Server) from various heterogeneous data sources.
• Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)
• Executed campaign based on customer requirements
• Followed company code standardization rule
• Performedad hoc analyses, as needed, with the ability to comprehend analysis as needed
• Involved in testing the XML files and checked whether data is parsed and loaded to staging tables.
• Responsible for creatingtest cases tomake sure the data originating from source is making into target properly in the right format.
• Tested several stored procedures and wrote complex SQL syntax using case, having, connect by etc
• Involved in Teradata SQL Development, Unit Testing and PerformanceTuning and to ensure testing issues are resolved on the basis of using defect reports.
• Tested the ETL process for both before data validation and after data validation process. Tested the messages published by ETL tool and data loaded into various databases
• Experience in creating UNIX scripts for file transferand file manipulation.
• Provide support to client with assessing how many virtual user licenses would be needed for performance testing.
• Ensuringonsite to offshore transition, QA Processes and closure of problems & issues.
• Tested the database to checkfield size validation, check constraints, stored procedures and cross verifying the field size defined within the application with metadata.

Confidential

Data Analyst

Responsibilities:

• Involved interacting with internal stakeholders gathering reporting requirement needs & implement solutions that meet their needs, while making sure the priorities for my team are properly aligned to business needs.
• Involved in extraction, transformation and loading of data directly from different source systems like flat files, Excel, SAP Hana, and SQL Server.
• Created Business KPIs using calculated key figures and parameters, interactive dashboards, reports, and stories, using bar graphs, scatter plots, geographic maps with the help of show me functionality and applied actions (filter, highlight and URL) to dashboards).
• Created Tableau Dashboards with interactive views, trends and drill downs.
• Designed and deployed rich Graphic visualizations with drill-down and drop-down option and Parameters using Tableau.
• Developed dashboards in Tableau Desktop on Metrics Mart and published them on to Tableau Server which allowed end users for decision support.
• Worked on loading data into Tableau from various data sources.
• Delivering reporting for decision support reports, Summary reports, dashboards, monthly reports such as Bar charts, 3D charts and created Power BI dashboards with multiple data sources.
• Leveraged the analytics pane in Tableau to perform statistical analysis helping business with Trends, forecasting future enrollments, and clustering.
• Transition existing reports from excel to Tableau reporting application as well as developing new reports as assigned.
• Implemented metrics, filters, reports, dashboards and also created advanced chart types, using calculations to manipulate the data and enable user driven parameters for visualizations and drilled down level of detail using sets.
• Utilized Tableau Server to publish and deliver custom reports/interactive dashboards, data visualizations with the business users across the entire organization.

Confidential

Data Analyst

Responsibilities:

• Involved in analysis, design and documenting business requirements and data specifications. Supported data warehousing extraction programs, end-user reports and queries
• Interacted with Business analysts to understand data requirements to ensure high quality data is provided to the customers
• Worked on numerous ad-hoc data pulls for business analysis and monitoring by writing SQL scripts.
• Created monthly and quarterly business monitoring reports by writing Teradata SQL queries includes System Calendars, Inner Joins and Outer Joins to retrieve data from multiple tables.
• Performed verification and validation for accuracy of data in the monthly/quarterly reports.
• Created reports, charts by querying data using Hive Query Language and reported the gaps in lake data loaded.
• Good knowledge on Json format data and performed the source, target validations using aggregations and null validity functions.
• Created multi-set tables and volatile tables using existing tables and collected statistics on table to improve the performance.
• Developed Teradata SQL scripts using RANK functions to improve the query performance while pulling the data from large tables.
• Experience in performing Dual Data Validation on various Businesses critical reports working with another Analyst.