SUMMARY

• Qualified professional has 6+yearsof extensive IT Experience inData WarehousingandBusiness Intelligenceapplications inRetail, Financial, Health Care and Manufacturing industries.
• Proficient inTableau 6.x/7.x/8.x Desktop, Server,Intelligence Server, Narrowcast Server, SSRS and Power BI, Adobe Analytics.
• Proficient in design and development of various dashboards, reports utilizingTableau Visualizationslikebar graphs,scatter plots,pie charts,geographic visualizationand other making use ofactions,otherlocal and global filtersaccording to the end user requirement.
• Expertise in designing and creating various analytical reports andDashboards tohelp users to identify critical KPIs and facilitate strategic planning in the organization.
• Experience in creating and implementinginteractive charts,graphs, and other user interface elements.
• Proficient in developingEntity - Relationship diagrams,Star/Snow Flake SchemaDesigns, and Expert in modeling Transactional Databases and Data Warehouse.
• Outstanding Data analysis skills includingData mappingfromsource to targetdatabase schemas,Data Cleansingand processing, writing data extract scripts/programming of data conversion and researching complex data problems.
• Expertise inOracle,SQL Server,Informatica, SSIS, SSRS, SSAS, UNIX,Toad,Microsoft Office Suite.
• ProficientStar Schema dimensional modeling, which includes understanding business, processes, modeling dimensions, hierarchies and facts.
• Posses' strong knowledge ofdatabase managementin writing complexSQLqueries,Stored procedures,database tuning, query optimizationandresolving key performance issues.
• Coordinated Technical Reviews, developed System requirements. Developedtest requirements,test plans,scripts,test conditionsandtest data. Supported status reporting and test execution forUnit testing,Integration testing,System testing,Regression testing, andUser Acceptance Testing UAT.
• Adept in analyzing bugs, interacting with team members in fixing errors and UAT and assisted in Post Production support.
• Experience in control versioning of the development using SVN and Git.
• Experience in writing custom events and queries using Adobe Analytics.
• Worked on delivering more accurate data insights to the business users with Adobe Analytics.
• Experience in Microsoft Azure Analysis Services, Azure Data Lake (ADL), Azure Data Factory (ADF). Proficient in Machine Learning in Microsoft Azure Data bricks.
• Well versed with Linear/non-linear regression and classification modeling predictive algorithms built predictive analytics models to generate actionable insights.
• Expertise in Object Oriented Programming using C++ and Java related technologies.
• Strong influence management skills, reporting and analytical/problem solving skills with attention to detail.
• Strong understanding of project life cycle andSDLCmethodologies includingRUP, RAD, WaterfallandAgile.
• Highly motivated team player with excellent Interpersonal and Customer Relational Skills, Proven Communication, Organizational, Analytical, Presentation Skills, and Leadership Qualities

TECHNICAL SKILLS

BI Tools: Tableau 7.x/8.x, SSRS, Power BI, Micro Strategy

ETL Tools: Informatica, Microsoft SQL Server Integrated Services SSIS

Requirements management: Requisite Pro, Microsoft Office Word, PowerPoint Excel

Front End Tools: Microsoft Project, Microsoft Office, Visible Analyst

Databases: Google big-query, Oracle, SQL Server, Mongo DB, Access etc

Document management: Visual Source Safe 6.0, Share point, Ultra Edit

Defect management tool: HP Quality center 10.0

Programming Languages: C, C++, Java, HTML, SQL, PL/SQL, XML, Python

Data modeling: Power Designer, ER Studio, MS Visio

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

Sr. Data Analyst/ Business Intelligence Analyst

Responsibilities:

• Performed data profiling in the source systems that are required for Dual Medicare Medicaid Data mart.
• Document the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Responsible for ETL development with successful design, development, and integration of components within the Informatica ETL Platform and Java Technology.
• Responsible for management of data, duplicating the data and storing the data in to specific data warehouse using ETL Platform for Data Management and MDM.
• Involved in defining the trumping rules applied by Master Data Repository.
• Define the list codes and code conversions between the source systems and MDR.
• Worked with internal architects and, assisting in the development of current and target state enterprise data architectures.
• Worked with project team representatives to ensure that logical and physical ER/Studio data models is developed in line with corporate standards and guidelines.
• Involved in defining the source to target data mappings, business rules, and business and data definitions.
• Responsible for defining the key identifiers for each mapping/interface.
• Responsible for defining the functional requirement documents for each source to target interface.
• Document, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
• Responsible to extract data using SSIS and prepare data sets for Power BI reports. Providing weekly reports of key performance metrics to the management.
• Designed and implemented end-to-end systems for Data Analytics and Automation, integrating custom visualization tools using Power BI, Adobe Analytics.
• Experience in writing custom events and queries using Adobe Analytics. Organized raw data into a meaningful pattern after cleaning and prepared the data using Adobe Analytics.
• Worked on delivering more accurate data insights to the business users with Adobe Analytics.
• Proficient in design and development of various dashboards, reports utilizingTableau Visualizationslikebar graphs,scatter plots,pie charts,geographic visualizationand other making use ofactions,otherlocal and global filtersaccording to the end user requirement.
• Coordinate with the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality.
• Document data quality and traceability documents for each source interface.
• Designed and implemented data integration modules for Extract/Transform/Load ETL functions
• Involved in data warehouse and Data mart design.
• Experience with various ETL, data warehousing tools and concepts.
• Documented the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Worked with internal architects and, assisting in the development of current and target state data architectures.
• Used data analysis techniques to validate business rules and identify low quality for Missing data in the existing Humana Enterprise data warehouse EDW.
• Experience in Microsoft Azure Analysis Services, Azure Data Lake (ADL), Azure Data Factory (ADF). Proficient in Machine Learning in Microsoft Azure Data bricks.
• Also worked on some impact of low quality and/or missing data on the performance of data warehouse client.

Environment: SQL/Server, Oracle 11g, MS-Office, Enterprise Architect, Informatica, ER Studio, XML.

Confidential, Tampa FL

Sr. BI Analyst/Data Analyst

Responsibilities:

• The project involves upgrading the current SMART system for the city from legacy system to a web based application, creating reports and dashboards.
• Involved in different aspects and development stages of the overall solution and database architecture and setting up of the development and testing guidelines.
• Participated in daily stand-ups, sprint planning sprint reviews and sprint retrospective on a regular basis and reviewed tasks and user stories and provided estimates in JIRA.
• Interaction with the users and conducted meetings to understand the report requirements, to know their Business views and the level of detail needed by them and also worked on data mappings.
• Performed a few proof of concepts for the reports to determine the right platform. Created several report mock-ups for the users to demo and finalize the requirements.
• Creation of multiple SSIS packages to import data from the legacy (mainframe) system, Oracle and Mongo DB to target SQL Server DB for report consumption and other use.
• Analysis of data in the existing databases and a thorough data quality analysis and profiling to identify anomalies, scrub, and clean the data.
• Created SQL scripts, stored procedures, common table expressions (CTEs), functions and ETL flows to extract, clean, scrub and load the historical data in the existing system to the target tables. Creation of data lakes and data marts.
• Creation of multiple, very complex reports in SSRS and Power BI, that run on high volume of data, with response time less than a few secs and which pulls data from SQL Server as well as Mongo DB.
• Creation of multiple highly interactive Power BI and SSRS reports for supervisors and managers, which enables them to see the current status of the work, shifts allocation for the next day at location, district and borough level.
• Development of key reports in SSRS which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.
• Generation of periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Development of various operational Drill-through and Drill-down reports using SSRS. Developed different kind of reports such a Sub Reports, Charts, Matrix reports, Linked reports.
• Creation of SSRS reports for consumption by the various user groups, which they use, to assess the trends and overall status of the tasks, shift capacities and manpower allocations.
• Scheduling of data refresh on SSRS reports on weekly and monthly increments based on business change to ensure that the views were displaying the changed data accurately.
• Extraction and importing of data from MongoDB and configuration of the MongoDB connectors and the ODBC driver to enable smooth communication between MongoDB and SSRS and Power BI
• Created multiple Power BI dashboards and data visualization reports for DSNY supervisors and users to to give them zone wise availability of the resources.
• Generated dashboards with key indicators for the daily planning team to enable them to plan the resources, in term of tasks, routes, personnel and their allocations.
• Used Power BI power query to extract data from external sources and modify data to certain format as required for consumption in the dashboards.
• Scheduled data refresh for Power BI dashboards on periodic basis ti enable the display of the most current data on the dashboards.
• Deployed SSRS reports and published Power BI dashboards to share them with the appropriate users. Created multiple roles, with appropriate privileges for different users.
• Involved in performance tuning and optimization of the complex SQL queries and stored procedures. Created appropriate indexes, scheduled jobs for updating stats on the tables to keep the queries efficient.
• Involved in troubleshooting of the issues and coordinated with the QA team and other teams for bug fixes and deployment of the report. Created tasks to track the bugs, fixes and their resolution, which helped in improving the overall development time.
• Involved in design, development, testing and support of the BI reports. Involved in debugging and monitoring, and troubleshooting performance issues during the release and the weekly runs.

Environment: - SAS, SQL, Toad, Tableau 9.x, SAS Data flux, T-SQL, MS SQL Server 2012, ER Studio, Excel, VBA, SSIS, SSRS, Google Analytics, Sharepoint, Autosys, Unix, Shell Script, J2EE.

Confidential

Data Analyst

Responsibilities:

• 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.
• Performed requirements gathering and design analysis for customer contact history for customer relationship management.
• Worked as business requirements analysts with subject matter experts to identify and understand requirements.
• Supported data warehouse projects with logical and physical data modeling in Oracle environment and assured accurate delivery of DDL to the development teams.
• Documented the data requirements and system changes into detailed functional specifications.
• Took ownership of Source to Target Mapping, tracked, and maintained changes.
• Performed Extraction, Transformation and Loading (ETL) using Informatica power center.
• Designed and implemented data profiling and data quality improvement solution to analyze, match, cleanse, and consolidate data before loading into data warehouse.
• Extensively used Erwin to design Logical, Physical Data Models, and Relational database and to perform forward/reverse engineering.
• Responsible in designing new FACT or Dimension Tables to existing Models.
• Implemented stored procedures, functions, views, triggers, packages in PL/SQL.

Environment: ERWIN 4.0, Oracle 8i/9i, PL/SQL, SQL, SQL*PLUS, SQL*LOADER, Informatica Power center.