Candidates About

 

Harsha Data Analyst

           

SUMMARY

·         Around 7+ years of IT experience in the Analysis, design, development, testing and Implementation of ETL & Business Intelligence solutions using Data Warehouse/Data Mart Design, ETL, OLAP, Client/Server applications.

·         Experience in Data Analysis, Data Validation, Data modeling, Data Cleansing, Data Verification and identifying data mismatch.

·         Strong RDBMS concepts and well experience in creating database Tables, Views, Sequences, triggers, joins taking the Performance and Reusability into consideration.

·         Knowledge in the ETL (Extract, Transform and Load) of data into a data ware house/date mart and Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).

·         Maintain, update, and create queries in SQL and Business Objects to pull data from the Enterprise Data Warehouse for reporting.

·         Professional experience with BI tools such as SSIS, SSRS, Tableau and Crystal Report.

·         Proficient at creating Reports, Pivot Tables, VLOOKUP, HLOOKUP, Index, Graphs, and Match in MS Excel; Proficient at utilizing MS PowerPoint, MS Access, and MS Word.

·         Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Integration, Data Mapping and Metadata Management Services.

·         Extensive knowledge in data modeling in relational and non-relational databases using industry best practice data modeling techniques and tools such as Erwin.

·         Developed insights from analysis, prepared dashboards to make recommendations as per business requirements with Tableau and Excel.

·         Excellent understanding and working experience of industry standard methodologies like SDLC, STLC, AGILE, RUP, SCRUM and Waterfall.

·         Extensively used Erwin for forward and reverse engineering.

·         Experienced in dealing with international data requests, extracting data from different database using SQL, Cubes to fulfil data demands from international markets.

·         Involved in designing and building stored procedures, view generators and macros for the module.

·         Worked on moving data to dedicated environment for Analytics for better performance. Involved in Analysis, Administrative, Security, Development and Support.

·         Expertise in Procedures, Functions, Database Packages and Triggers. And experience in trouble shooting techniques, tuning the SQL statements, Query Optimization and Dynamic SQL.

·         Good knowledge of Performance tuning, Application Development and Application Support on UNIX, MVS and WINDOWS NT Environments.

·         Worked on moving data to dedicated environment for Analytics for better performance. Involved in Analysis, Administrative, Security, Development and Support.

·         Developed UNIX Shell scripts for Batch processing.

·         Responsible for writing Deployment/Release Notes before the project release and End User and Manual for production team.

·         Plans, Test Procedures, Test Case Design and Execution, Modification Requests.

·         Strong in conceptualizing and communicating enterprise data architecture frameworks for global enterprises for inter operation of data warehouses, middleware, and web applications.

·         Designed and developed stored procedures, queries and views necessary to support SSRS reports.

·         Extensively worked on SSRS and delivered complex reports from different data sources such as SQL Database and Cubes.

·         Generation of Dashboards with Quick filters, Parameters and sets to handle views more efficiently in Tableau.

·         Good working knowledge of tools like Azure ML, Google Analytics, Qlik View, Qlik Sense, Tableau.

·         Developing numerous ad-hoc queries and reports to collect and present information that satisfied clients and contributed to achieve organizational goals.

·         Excellent Communication, interpersonal, analytical skills and strong ability to perform in a team as well as individually.

TECHNICAL SKILLS

Languages	T-SQL, PL/SQL, SQL, C, C++, XML, HTML, DHTML, HTTP, Matlab, DAX, Python
Application Software	MS Office suite, Rational Suite, MS Project
Methodologies	RUP, OOAD, TOAD, UML & Business/Data Modeling, ER modeling
Documents & Processes	SRS, Use Cases, UML diagrams, FRS, UAT, Test plans & cases, Business Process Modelling, Project Planning & tracking
Data warehousing Tools	Informatica, Business Objects, Cognos, Erwin
Web Technologies	HTML, XML
DWH / BI Tools	Tableau, SSIS, SSRS, SSAS, Business Intelligence Development Studio (BIDS), Visual Studio, Crystal Reports, Informatica 6.1.
Database Design Tools and Data Modeling	MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, Fact & Dimensions tables, physical & logical data modeling, Normalization and De-normalization techniques, Kimball & Inmon Methodologies
Tools and Utilities	SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Microsoft Management Console, Visual Source Safe 6.0, DTS, Crystal Reports, Power Pivot, ProClarity, Microsoft Office, Excel Power Pivot, Excel Data Explorer, Tableau, JIRA, SparkMlib
Operating Systems	Windows XP, Windows NT/98/2000, UNIX

 

EDUCATION

·         Bachelor of Technology in Electrical & Electronics Engineering.

 

PROFESSIONAL EXPERIENCE

 

Senior Data Modeler/Analyst

Smart Energy Waters, Irvine, CA                                                                                              May 2017 – Present

Smart Energy Water (SEW) is the leading cloud based Software-as-a-Service (SaaS) platform for Energy & Utility sector delivering award winning Customer Engagement, Mobile Workforce, Demand Response, Energy Efficiency, Water Conservation, Smart Homes and Smart Cities applications. Energy and Water Utilities increase their digital customer engagement, field operations efficiency and profitability by using SEW platform to leverage the benefits of cloud, mobile, big data analytics, and Internet of Things (IoT) technology.

Responsibilities:

·         Modernizing operations by replacing Legacy Master Data Collection systems with new Oracle Master Data Management System.

·         Extensively involved in the modeling and development of Reporting Data Warehousing System.

·         As a Sr. Data Analyst worked closely with the Enterprise Data Warehouse team and Business Intelligence Architecture team to understand repository objects that support the business requirement and process.

·         Developed dashboards, reports, templates, and visualizations using Tableau.

·         Prototyped data visualizations using Charts, drill-down, parameterized controls using Tableau to highlight the value of analytics in Executive decision support control.

·         Developed and executed reports using combination of software applications, including Crystal Reports, IBM Rational ClearQuest, MSSQL Server Business Intelligence Development Studio.

·         Clean and manipulate complex healthcare datasets in order to create the data foundation for further analytics and the development of key insights (MSSQL server, R, Tableau, Excel)

·         Generated individual customer Reports using sales data of quantity, sales price, standard cost, allocation budget in dollars and standard margin using VBA and Macros in MS Excel.

·         Data Analysis Primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.

·         Manipulated data from website using Vlookups, match from MS Excel to obtain accurate data feed for visualization.

·         Collected and studied the Metadata about the master data for MDM and the transactional data.

·         Modelling the data relationship to provide assistance for business decision making (R, Tableau).

·         Generation of Dashboards with Quick filters, Parameters and sets to handle views more efficiently in Tableau.

·         Developing SSIS packages (DTSX) to get data from various sources like new data feed files, involving data analysis, data quality, data conversion, data migration, data validation, error handling, testing and security.

·         Assure correct information is maintained in EPIC and any applicable downstream systems by notifying all required departments of merges and corrections for correction in other department systems

·         Used Informatica / SSIS to extract, transform & load data from SQL Server to Oracle databases.

·         Reporting and dash boarding analytical results to client (R, Tableau, Excel).

·         Designed and developed the data dictionary and Meta data of the models and maintain them.

·         Provided analysis of enterprise data warehouse and business intelligence systems, including source data systems, to identify and document complex data mapping, business rule analysis, functional and non-functional requirements Created ad hoc queries, reports and analyses as requested.

·         Managed all data bases, data mining and reporting. Contributed to design of Six Sigma program infrastructure.

·         Used forward engineering to create a physical data model with DDL that best suits the requirements from the logical data model using Erwin.

·         Developed logical and physical data models that capture current state/future state data elements and data flow using Erwin.

·         Reverse Engineered the existing ODS into Erwin.

·         Worked with several marketing managers and project manager to gather financial data and requirements and build reports using SQL.

·         Created new macros and implemented them in SAS programs to produce the reports.

·         Involved in end-to-end ETL process design using various Informatica tools - Source Analyzer, Mapping, Designer, Transformation Designer, Workflow Manager, Workflow Monitor.

·         Designed 60+ mappings and workflows.

·         Worked on Tableau for Data Analysis, Digging the data for source systems for analysis and deeply dive in the data for Predictive findings and for various data Analysis by using R

·         Expert using Business Intelligence tools - Microsoft SSRS, SSIS and SSAS, Visual Studio, Informatica Power

·         Reviewed requirements together with QA Manager, ETL leads to enhancing the data warehouse for the originations systems and servicing systems.

·         Performed Data mapping between source systems to Target systems, logical data modeling, created class diagrams and ER diagrams and used SQL queries to filter data.

·         Implemented Unified Modelling Language (UML) methodologies to design Context Diagram, Use Case Diagrams, Data Flow Diagrams, Activity Diagrams, Sequence Diagram and using Erwin.

·         Design discussions and meetings with the data architects to come out with the appropriate design for the data warehouse.

Environment: Oracle 11g, 10g, HP ALM, Informatica Power Center 9/8.5.1 (Workflow Manager, Workflow Monitor), XML, Test Cases, R, SSIS, SSRS, SSAS, Visual Studio, Excel, SQL/ PLSQL, Tableau

 

Senior Data Modeler/Analyst

First Tennessee, Memphis, TN                                                                                              Jan 2016 – May 2017

First Tennessee, part of the First Horizon National Corporation, established in 1864 is a financial services company based in Memphis, Tennessee. First Tennessee provides financial services through more than 180 locations in and around Tennessee.

Responsibilities:

·         Created stored procedures, functions, Database triggers and packages as per the Business Needs for Developing Ad-hoc and robust reports. Incorporated Dynamic SQL, for generation of the where clauses dynamically based on the lexical parameters passed.

·         Suggested various changes in the physical model to support the business requirements.

·         Developed server jobs to load the data from flat files, text files, tag text files and MSSQL.

·         Generated comprehensive Analytical reports by running SQL Queries against current Databases to Conduct Data Analysis.

·         Utilized shared containers for code reusability and for implementing the predefined business logic.

·         Involved in All the phases of the development like Analysis, Design, Coding, Unit Testing, System Testing and UAT.

·         Wrote, executed, performance tuned SQL Queries for Data Analysis & Profiling.

·         Wrote complex SQL queries using joins, sub queries and correlated sub queries.

·         Used Model Mart of ERwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.

·         Developed a Conceptual model using Erwin based on business requirements.

·         Wrote PL/SQL stored procedures, functions and packages and triggers to implement business rules into the application.

·         Developed shell scripts to invoke back end SQL and PL/SQL programs.

·         Designed and developed stored procedures, queries and views necessary to support SSRS reports.

·         Extensively worked on SSRS and delivered complex reports from different data sources such as SQL Database and Cubes.

·         Performed unit testing to check the validity of the data at each stage.

·         Used Data Stage Director to debug the jobs and to view the error log to check for errors.

·         Generation of Dashboards with Quick filters, Parameters and sets to handle views more efficiently in Tableau.

·         Implemented best practices in the development environment (code standards, code migration).

·         Written complex SQLs using joins, sub queries and correlated sub queries and expertise in SQL Queries for cross verification of data.

·         Used Informatica features to implement Type I & II changes in slowly changing dimension tables.

·         Created and ran workflows and Worklets using Workflow Manager to load the data into the target database.

·         Performance tuning of SQL Queries, Sources, Targets and sessions.

Environment: Oracle 11g, 10g, HP ALM, MS SQL, SDLC, data analysis, Informatica Power Center 9/8.5.1 (Workflow Manager, Workflow Monitor), XML, Test Cases, SSIS, SSRS, Excel, SQL/ PLSQL, Tableau, Manual Testing.

 

Data Modeler/Analyst

Amplifon, Plymouth, MN                                                                                                           Sep 2014 – Dec 2015

Amplifon USA was established in 1999 as a subsidiary of Amplifon S.p.A., the worldwide leader in the hearing health care industry for over 65 years. Amplifon USA supports the global mission to help people with hearing problems rediscover what it means to live life to its fullest through solutions based on individual needs and that guarantee complete satisfaction. Amplifon USA serves the diverse needs of North America through three unique and independent brand channels.

Responsibilities:

·         Worked with business users to gather requirements and create data flow, process flows and functional specification documents.

·         Developed Data Mapping, Data Governance and transformation and cleansing rules for the Master Data Management Architecture involving OLTP, ODS.

·         Developed, enhanced and maintained Snow Flakes Schemas within data warehouse and data mart with conceptual data models.

·         Designed3rd normal form target data model and mapped to logical model.

·         Involved in extensive Data validation using SQL queries and back-end testing and used SQL for Querying the database in UNIX environment.

·         Involved with Data Analysis primarily Identifying Data Sets, Source Data, Source Meta Data, Data Definitions and Data Formats.

·         Involved in data analysis and creating data mapping documents to capture source to target transformation rules.

·         Used ER Studio and Visio to create3NF and dimensional data models and published to the business users And ETL /BI teams.

·         Utilized Erwin’s reverse engineering and target database schema conversion process.

·         Used Erwin for effective model management of sharing, dividing and reusing model information and design for productivity improvement.

·         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.

·         Generation of Dashboards with Quick filters, Parameters and sets to handle views more efficiently in Tableau.

·         Developed Informatica SCD type-I, Type-II and Type III mappings and tuned them for better performance.

·         Creating or modifying the T-SQL queries as per the business requirements and worked on creating role playing dimensions, fact less Fact, snow flake and star schemas.

·         Using ER Studio modeling tool, publishing of a data dictionary, review of the model and dictionary with subject matter experts and generation of data definition language.

·         Extracted data from databases Oracle, Teradata, Netezza, SQL server and DB2 using Informatica to load it into a single repository for Data analysis.

·         Involved in development and implementation of SSIS, SSRS and SSAS application solutions for various business units across the organization.

·         Designed and developed stored procedures, queries and views necessary to support SSRS reports.

·         Managed full SDLC processes involving requirements management, workflow analysis, source data analysis, data mapping, metadata management, data quality, testing strategy and maintenance of the model.

·         Created and modified several UNIX shell Scripts according to the changing needs of the project and client requirements.

·         Identified and tracked the slowly changing dimensions, heterogeneous sources and determined the hierarchies in dimensions.

·         Wrote complex SQL queries for validating the data against different kinds of reports generated by Business Objects.

·         Used Teradata utilities such as Fast Export, MLOAD for handling various tasks.

·         Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks.

·         Involved in fixing invalid mappings, testing of Stored Procedures and Functions, Unit and Integrating testing Of Informatica Sessions, Batches and the Target Data.

·         Involved in the validation of the OLAP Unit testing and System Testing of the OLAP Report Functionality and data displayed in the reports.

Environment: ER Studio, Informatica Power Center 8.1/9.1, Power Connect/ Power exchange, Oracle 11g, Main frames, DB2 MS SQL Server 2008, SQL, PL/SQL, XML, Windows NT 4.0, Unix Shell Scripting, Teradata, Netezza, Aginity.

 

Data Analyst

Provident Financial Group Inc., Cleveland, OH                                                                  Nov 2013 – Aug 2014

Provident Financial is a financial service company offering a variety of banking products and financial solutions like personal banking, small business, retail banking, home financing and equity loan, asset management, corporate and investment banking and credit card services to its customers. My project was to build an Enterprise reporting system to support assets management and credit risk management. The application has three major components that is Extraction of data from data source, transformation and loading data into the database and generating reports.

Responsibilities:

·         Perform Stakeholder assessments to understand the business requirement and transform it to technical document it for IT development.

<span style="font-size:10.5pt;fon