SUMMARY

• Around 6 years in IT with expertise in data modeling for data warehouse/ data mart development, SQL, data analysis for online transaction processing (OLTP)and data warehousing (OLAP) and business intelligence (BI) applications.
• Expert knowledge in SDLC (Software Development Life Cycle) and was involved in all phases in projects.
• Expert in Business Intelligence solutions in Data warehousing / Decision Support Systems using ETL tools Informatica, OLAP, OLTP and Data Warehouse Reports using Business Objects, Crystal Reports.
• Collaborated Cross work stream sessions to give idea on conversion changes from Data warehouse side.
• Experience with gathering business requirements and requirements analysis.
• Experience in the Data Analysis, Design, Development, Implementation and Testing using Data Conversions, Extraction, Transformation and Loading (ETL) and SQL Server, ORACLE and other relational and non - relational databases. Expertise with SQL server management studio for Database interactions and manipulations.
• Generated DDL's and created tables and views in the corresponding layers.
• Implemented business logic using store procedures, TSQL and Triggers (DML and DDL)
• Experience in the Oracle development tool set (Including PL/SQL).
• Experience in creating Data definition and metadata repositories. Participated in physical implementation (partitioning, cluster, indexing, etc.)
• Experience in creating Data definition and Metadata repositories.
• Experienced in Load Data Warehouse and developed supporting Jobs for Extraction Transformation Loading (ETL) mechanism.
• Report creation using OLAP data source and having knowledge in OLAP universe.
• Extensive experience in working on Oracle 9i/10g and writing Complex SQL queries and PL/SQL Procedures, Functions, Packages, Database Triggers, Exception Handlers, Ref Cursors, Database Objects using PL/SQL.
• Developed metadata management program with business and technical definitions, data lineage, life cycle, identify authoritative source.
• Experienced in forecasting the data space requirements using the features like Capacity planning, mapping source to target data using data lineage feature and calculating the impact analysis.
• Expertise in creating schema objects, Performance Tuning of SQL coding.
• Able to work within an aggressive and demanding project schedule and environment.
• Evaluate current process performance at a higher level for the purpose of identifying and prioritizing new project opportunities.
• Provide analytical support to the process design teams, including definition, planning, and implementation of various initiatives to achieve process design goals.
• Strengths include excellent communication skills and interpersonal skills, good analytical skills and logical approach to problem solving.
• Extensive experience in using ER modeling tools such as Erwin and ER/Studio, Teradata
• Excellent communication and interpersonal skills with a proven track record of ability, adaptability, creativity and innovation along with demonstration of very strong technical and managerial skills and while successfully leading teams to strict project deadlines.

TECHNICAL SKILLS

Data Analytics/reporting tools: TOAD, MS Excel, SSRS

Databases: Oracle11g/10g/9i, SQL Server 2008 and MS Access

ETL Tools: SQL Server, DTS/Integration Services

Languages: SQL, PL/SQL, T-SQL, C, Java

Web Technologies: HTML, CSS, Java Script

Platforms: UNIX/Linux, Windows

Office Tools: MS Excel, MS Visio, MS PowerPoint, WordOutlook

Software Tools/ Libraries: My Eclipse, NetBeans

Software Process Models: Agile-Scrum, Waterfall

PROFESSIONAL EXPERIENCE

Confidential

Data Analyst

Responsibilities:

• Responsible for the Extraction, Transformation and Loading (ETL) Architecture & Standards implementation.
• Analyze the raw data from alliance partners and perform coding to generate the reports according to the Data model.
• Involved in data profiling to help identify patterns in the source data using SQL and Informatica and thereby help improve quality of data and help business to understand the converted data better to come up with accurate business rules.
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Designed, created and implemented Web reports, and Design Studio Dashboards using best practices.
• Built, published and customized interactive reports and dashboards, report scheduling using Tableau server.
• Made use of SQL joins, sub queries, tracing and performance tuning for better running of packages.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using ETL.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/ dynamic and static datasets.
• Wrote several SQL Queries using Teradata SQL Assistant for Ad Hoc Data Pull request.
• Worked on creating filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Creating and updating workflows in Alteryx to validate the quality and consistency of the data.
• Creating queries in Access DB and Excel to validate data.
• Involved in resolving the data type inconsistencies between the source systems and the target system using the Mapping Documents.
• Turned SQL queries to make use of data base indexes, and analyzed the data base objects.
• Investigating and fixing the bugs occurred in the production environment and providing the on-call support.

Environment: Data Analytics, Alteryx, Microsoft Office Suite, Oracle, SQL, SQL Developer, Teradata SQL Assistant, UNIX, Crystal Reports.

Confidential, Chicago, IL

Data Analyst /System Analyst

Responsibilities:

• Responsible for the Extraction, Transformation and Loading (ETL) Architecture & Standards implementation.
• Analyze the raw data from alliance partners and perform coding to generate the reports according to the Data model.
• Involved in data profiling to help identify patterns in the source data using SQL and Informatica and thereby help improve quality of data and help business to understand the converted data better to come up with accurate business rules.
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Designed, created and implemented Web reports, and Design Studio Dashboards using best practices.
• Built, published and customized interactive reports and dashboards, report scheduling using Tableau server.
• Made use of SQL joins, sub queries, tracing and performance tuning for better running of packages.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using ETL.
• Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting live/ dynamic and static datasets.
• Wrote several SQL Queries using Teradata SQL Assistant for Ad Hoc Data Pull request.
• Worked on creating filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Creating and updating workflows in Alteryx to validate the quality and consistency of the data.
• Creating queries in Access DB and Excel to validate data
• Involved in resolving the data type inconsistencies between the source systems and the target system using the Mapping Documents.
• Turned SQL queries to make use of data base indexes, and analyzed the data base objects.
• Investigating and fixing the bugs occurred in the production environment and providing the on-call support.

Environment: Tera data SQL, SQL Server, Oracle DB, MS Access, MS Excel, Agile, Jira, Spark, Scala, Hadoop.

Confidential

Data Analyst /Data Modeler

Responsibilities:

• Collaborate with Product Management and Data Architect to develop logical and physical data models, detailed functional specification for Marketing DB processes and procedures. Responsible for developing mapping data fields, creating data field definitions and documenting marketing DB schema.
• Design, Model and develop database objects, Star Schema to support the collection, tracking and reporting of business data Work on data governance policies and procedures, ETL code development, automation of the existing manually intense ETL processes using Informatica for marketing DB.
• Develop mappings/reusable objects/ transformations by using mapping designer and transformation developer in Informatica Power Center.
• Develop Data Quality operating model and connectivity to Enterprise Data Governance.
• Perform data discovery, profiling, and rules development to establish data dictionaries, lineage and supporting processes.
• Document approach and methodology to data profiling and data cataloging.
• Designing, developing of ETL (Extract, Transformation and Load) strategy to populate the Data Warehouse from various source systems feeds using ETL tools like Informatica, Power exchange, MDM Web services, and PL/SQL and Unix Shell scripts.
• Responsible for functional and technical support during implementation.
• Works closely with programmers and end-users to identify product and service requirements.
• Interpret data, analyze results using statistical techniques and provide ongoing reports.
• Develop and implement databases, data collection systems, data analytics and other strategies that optimize statistical efficiency and quality.
• Identify, analyze, and interpret trends or patterns in complex data sets
• Analyzes and tests software packages prior to implementations.
• Collection and analysis of data for the purpose of understanding current performance.
• Extract data from various data sources residing on DB2, Oracle, XML, and Flat Files and load it to target enterprise Marketing Data Warehouse tables using Informatics ETL Mappings.
• Responsible for loading and maintaining all the referential data tables used by different development teams in their day to day jobs and updating it daily according to the changes happening on the business end.
• Involve in Performance tuning for sources, targets, mappings, sessions and server.
• Knowledge of Snowflake Database, Schema and Table structures. Experience in using Snowflake Clone and Time Travel. Understanding of Snowflake cloud technology.
• Perform troubleshooting, fixed and deployed python bug fixes and write script to load the data in database.
• Responsible for creating database objects like Table, Store Procedure, Triggers, Functions using T-SQL to provide structure to store data and to maintain database efficiently.
• Involve in gathering business requirements, logical modeling, physical database design, data sourcing and data transformation, data loading, SQL and performance tuning.

Environment: Erwin 9.6/9.8, TOAD for Oracle, TOAD for data analysts, SQL Server, Oracle DB, MS Access, MS Excel, Agile, Jira, Hadoop.

Confidential, Lake Forest, IL

Data Analyst /Data Modeler

Responsibilities:

• Performing assigned analysis and data validations.
• Projects to solve a variety of business issues for a department or functional area.
• Reverse Engineered the Data Models and identified the Data Elements in the source systems and adding new Data Elements to the existing data models.
• Performed Data Analysis and Data Profiling using complex SQL queries on various sources systems including Oracle, Teradata.
• Performs analysis of findings and trends using statistical and/or financial analysis, modeling, process documentation, profitability analysis, etc. summarizes and presents findings to increase revenue, reduce expense, maximize operational efficiency, quality, compliance, etc.
• Develop and maintain data solutions that utilize Oracle db, Microsoft SQL Server Reporting Services and Excel.
• Effectively utilized TOAD to run SQL / PLSQL / T-SQL statements on the database.
• Worked with the Business Analyst, QA team in their testing and DBA for requirements gathering, business analysis, testing and project coordination.
• Works with users to define business requirements and analytical needs; identifies and recommends potential data sources; compiles/mines data from a variety source.
• Involved with analyzing data with hive.
• Involved in map reducing program using Hadoop for working with big data.
• Responds to requests for specific, customized reports. Ensures adherence to data management regulations and policies.
• Experienced in generating and documenting Metadata while designing OLTP and OLAP system environment.
• Coordinated with DBAs and generated SQL codes from data models.
• Create tables, temp tables, triggers and views as required in Oracle, SQL Server databases. And use joins (inner, outer, left, right.) to extract required data.

Environment: TOAD for Oracle, TOAD for data analysts, SQL Server, Oracle DB, MS Access, MS Excel.

Confidential, Irving, TX

Data Modeler/Data Analyst

Responsibilities:

• Actively involved in the Design and development of the Star schema data model.
• Implemented slowly changing and rapidly changing dimension methodologies; created aggregate fact tables for the creation of ad-hoc reports.
• Involved in understanding Logical and Physical Data model using Erwin Tool.
• 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.
• Designed the database in Teradata and worked with Data Architect to implement it in the data model.
• Involved with metadata & Data Dictionary Management, Data Profiling and Data Mapping.
• Inherited enterprise data requirements and definitions from the Enterprise Information Models for use in projects and data-related initiatives.
• Worked as Enterprise Data Modeler to harvest new insights discovered in project and program work that can inform and strengthen the Enterprise Information Models.
• Lead data model walk-throughs to insure clear understanding across all stakeholders and addresses issues that surface.
• Extensively worked on data profiling and scanning to de-duplicate records in the staging area before data gets processed.
• Worked with Solution Architects to provide a consensus-based enterprise solution that is scalable, adaptable and in synchronization with ever changing business needs.
• Ensured that new solutions comply with company technology standards and support the strategic requirements of the business.
• Worked in AGILE software development methodology.
• Proficient in importing/exporting large amounts of data from files to Teradata and vice versa.
• Worked with project team representatives to ensure that logical and physical data models were developed in line with corporate standards and guidelines.

Environment: Teradata 13.10, Microsoft SQL Server 2012, Agile, SQL Manager, Erwin 8.0, Teradata SQL Assistant.

Confidential

Associate Data Consultant /Modeler

Responsibilities:

• Performed Data Analysis and Data Profiling and worked on data transformations and data quality rules.
• Conducted Oracle database analytics using TOAD and other BI tools, Tableau to resolve customer services issues.
• Monitored the client system using the Virtual connection, used Putty.
• Consulted with client management and staff to identify and document business needs and objectives, current operational procedures for creating the logical data model.
• Manipulating, cleansing & processing call and price data using Excel, Access and SQL
• Implemented Referential Integrity using primary key and foreign key relationships.
• Involved in Data Mapping.
• Participated in performance management and tuning for stored procedures, tables and database servers.
• Performed root cause analysis to trace the client side issues in the data.
• Develop and maintain data solutions that utilize SQL, Microsoft SQL Server Reporting Services and Excel.
• Develop new reports both proactively and in response to client request in order to improve operational efficiency.
• Review all data records received during the nightly electronic extracts.
• Worked on several interactive dashboards with Filtering, highlighting, ability to combine multiple data sources, fast creation by a business user, easy sharing with support for existing security using several visual analysis best practices.
• Worked on the development of dashboard reports for the Key Performance Indicators for the top management.
• Created advanced chart types, rich data visualizations and complex calculations to manipulate the data.
• Created dashboards in line with the analytical uniformity using the advanced analysis of Tableau Desktop and organizing Dashboard views and objects.
• Good exposure in creating reports from multiple data sources using Data blending technique.
• Design the use case diagrams and workflow charts for the processes and create algorithms from them.
• Performed reverse engineering to analyze and rewrite the programs and queries to create readable documents.
• Collaborated with other teams to identify and solve the software problems.
• Performed repeated checks on the system to identify the problems.
• Identified and tracked the slowly changing dimensions, heterogeneous sources and determined the hierarchies in dimensions.
• Prepared Summary reports, Suggestion Documents to improve the quality of the application.
• Prepare routine reports that provide insightful analysis of performance including specific recommendations for improvements.

Environment: MS SQL Server 2012, Oracle 12c/11g, MS office, Clear Quest, Clear Case.