SUMMARY

• Around 5 years in IT wif 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 ODS and Data warehouse side.
• Experience wif 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 wif TOAD 9x/8x, SQL server management studio for Database interactions and manipulations.
• Experienced to work as Data Analyst to perform complex Data Profiling, Data Definition, Data Mining, data analytics, validating and analyzing data and presenting reports.
• Generated DDL's and created tables and views in the corresponding layers.
• Experience in the Oracle development tool set (Including PL/SQL, SQL*Plus, SQL Loader).
• Experience in creating Data definition and metadata repositories. Participated in physical implementation (partitioning, cluster, indexing, etc.)
• Experienced to work as Data Analyst to perform complex Data Profiling, Data Definition, Data Mining, data analytics, validating and analyzing data and presenting reports.
• Good experience working wif very large databases and Performance tuning.
• Experience in Dimensional Data Modeling, Star Schema modeling, Snowflake Schema modeling, fact and dimension table design, physical and logical Data modeling using Erwin.
• Experienced in Load Data Warehouses (Star Schemas) and developed supporting Jobs for Extraction Transformation Loading (ETL) mechanism.
• Report creation using OLAP data source and having knowledge in OLAP universe.
• Strong skills in fulfilling EDI requirements and experience wif XML, CSV, and fixed width file formats.
• Extensive experience in working on Oracle 8i/9i/10g/11g and writing Complex SQL queries and PL/SQL Procedures, Functions, Packages, Database Triggers, Exception Handlers, Ref Cursors, Database Objects using PL/SQL.
• Proficient in writing Unix Shell scripts.
• Developed metadata management program wif business and technical definitions, data lineage, life cycle, identify authoritative source.
• Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, functions and Indexes using T-SQL.
• Proficient wif creating Modules and Macros wif Excel VBA in different business environments.
• Experience wif Data Extraction, Transforming and Loading (ETL) using various tools such as Data Transformation Service(DTS), SSIS.
• 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.
• Prepared documentation for standard practices using Datastage for enhanced performance.
• Knowledge in Testing phase planning, preparation and execution.
• Expertise in creating schema objects, Performance Tuning of SQL coding.
• Able to work wifin an aggressive and demanding project schedule and environment.
• Strengths include excellent communication skills and interpersonal skills, good analytical skills and logical approach to problem solving.
• Experience in management for large projects from requirement gathering through implementation.
• Proficient in developing various levels of documentation: Context Diagram, Process Diagram, Decomposition diagram, Data Flow diagram, Data Exchange diagram and Data Mapping matrixes.
• Excellent communication and interpersonal skills wif a proven track record of ability, adaptability, creativity and innovation along wif 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, Tableau, SSRS, R

Databases: Oracle11g/10g/9i/8i, SQL Server 2014, MS Access

ETL Tools: SSIS, Informatica Power Center, Oracle Data Integrator (ODI)

Languages: SQL, PL/SQL, T-SQL, C, Java, R, Python, VBA

Web Technologies: HTML, CSS, Java Script, SharePoint

Platforms: UNIX/Linux, Windows

Office Tools: MS Excel, MS Visio, MS PowerPoint, Word, Outlook, Lync

Software Tools: / LibrariesMy Eclipse, NetBeans, ATOM, IntelliJ IDEA

Software Process Models: Agile-Scrum, Waterfall

Cloud Computing: AWS, Microsoft Azure

Other skills: Photoshop, MS Office 2016 suite, MS Paint

PROFESSIONAL EXPERIENCE

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 Microsoft SQL Server, Oracle and 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 or Python / R to analyze extracted data.
• Worked wif the Business Analyst, QA team in their testing and DBA for requirements gathering, business analysis, testing and project coordination.
• Testing the current reports using the BI tool Tableau for exploring more options in data analytics.
• Works wif users to define business requirements and analytical needs; identifies and recommends potential data sources; compiles/mines data from a variety sources.
• Interact wif the report server, reports, and report related items by using application pages on the SharePoint site. Used the SharePoint document library and other libraries that I create to store the content types related to reports.
• Responds to requests for specific, customized reports. Ensures adherence to data management regulations and policies.
• Automates the report process and monitor throughout.
• Experienced in generating and documenting Metadata while designing OLTP and OLAP system environment.
• Loaded metadata into Data Stage which is used by the ETL people to create jobs.
• Created reports for the users using Tableau by connecting to multiple data sources like Flat Files, MS Excel, CSV files, JSON files, SQL Server and Oracle.
• Used Python scripts to update content in the database and manipulate files.
• Experience in using Python for creating graphics, data exchange and business logic implementation.
• Coordinated wif DBAs and generated SQL codes from data models.
• Use VLOOKUP to create tables from one spreadsheet to another to reduce complex data to readable data.
• Use IF function COUNTIF, MATCH, SUMIF, INDEX, VBA and other formulas to organize data.
• Create tables, temp tables, triggers and views as required in Oracle, SQL Server databases. And also use joins (inner, outer, left, right.) to extract required data.

Environment: TOAD for Oracle, TOAD for data analysts, R application for data analysis, SharePoint, Python, SSRS,SQL Server, Oracle DB, MS Access, MS Excel.

Confidential, Irving, TX

Data Analyst/Data Modeler

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 Datamodel using Erwin Tool.
• Analysis of functional and non-functional categorized data elements for dataprofiling 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 wif Data Architect to implement it in the data model.
• Use of data transformation tools such as DTS, SSIS, Informatica.
• Experience in building Data Integration, Workflow Solutions and Extract, Transform, and Load (ETL) solutions for data warehousing using SQL Server Integration Service (SSIS).
• Involved wif metadata & Data Dictionary Management, DataProfiling and DataMapping.
• Worked wif project team representatives to ensure that logical and physical ER/Studio data models were developed in line wif corporate standards and guidelines.
• Tested several business reports developed using Business Objects including dashboard, drill-down, summarized, master-detail & Pivot reports.
• Implemented very advanced and complex queries in DDL and DML involving Joins, Sub queries. Alter Table etc.
• Active involvement in Optimization Process through database capacity planning, creation of materialized views, partitions, tables, views, indexes as tuned and optimized SQL statements.
• Prepared complex T-SQL queries, views and stored procedures to load data into staging area.
• Created T-SQL stored procedures to improve the performance of aggregate queries dynamically.
• Designed and Developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.
• Created RTF files for summarizing results and creating, modifying, importing and exporting Metadata using SAS ODS. Developed SAS code, VBA code to automate report generating process.
• Extensively worked on the ETL mapping, source data analysis, source to target mapping and documentation of OLAP reports requirements.
• Used TOAD Software for querying Oracle.
• Worked on generating reports using Crystal Reports, SQL Server Reporting Services and Excel spreadsheet.
• Experience in Data Visualization including producing tables, graphs, listings using various procedures and tools like Tableau.
• Worked wif Tableau Report Writers to test, validate data integrity of reports.
• Used Power BI to design interactive reports and data visualization.
• Support for the development, pre-production, and the production databases.
• Extensively worked on data profiling and scanning to de-duplicate records in the staging area before data gets processed.
• Established business glossary in Metadata hub and linked them to technical metadata
• Everyday communication between IT Managers, Project Stakeholders, Users, Developers, Source data owners
• Ensured that new solutions comply wif 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.

Environment: Teradata 13.10, Microsoft SQL Server 2012, Agile, SQL Manager, Erwin 8.0, Informatica, SSIS, Tableau, Teradata SQL Assistant, ER Studio 9.1.0, Linux.

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.
• Effectively utilized the knowledge of scripting languages in the Unix OS environment.
• Monitored the client system using the Virtual connection, used Putty.
• Consulted wif 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.
• Used forward engineering to create a Physical Data Model wif DDL, based on the requirements from the Logical Data Model.
• Implemented Referential Integrity using primary key and foreign key relationships.
• Generated ad-hoc SQL queries using joins, database connections and transformation rules to fetch data from legacy Oracle and SQL Server database systems.
• Involved in Data Mapping.
• Wrote standard and complex T-SQL Queries to perform data validation and graph validation to make sure test results matched back to expected results on business requirements.
• Participated in performance management and tuning for stored procedures, tables and database servers.
• Handling client side issues related to call data, call/location rates and top-up recharge data related to product. Provided level 1, 2 and 3 support to the client.
• 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.
• Designed several business dashboards using Tableau Desktop, Tableau Server, Tableau reader and Tableau Cloud.
• Worked on several interactive dashboards wif Filtering, highlighting, ability to combine multiple data sources, fast creation by a business user, easy sharing wif 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 wif the analytical uniformity using the advanced analysis of Tableau Desktop, and organizing Dashboard views and objects.
• Developed Power BI reports and dashboards from multiple data sources using data blending.
• Good knowledge in creating the user level, Data source level, row level security filters for the workbooks, views, dashboards and data sources.
• Design the use case diagrams and work flow 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 wif other teams to identify and solve the software problems.
• Performed repeated checks on the system to identify the problems.
• Responsible for creating the staging tables and source to target mapping documents for the ETL process.
• 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, Tableau, Power BI,T-SQL, Clear Case.

Confidential

Database Consultant

Responsibilities:

• Creation of schema objects like indexes, views, stored procedures and synonyms.
• Interacting wif the end-user (client) to gather business requirements.
• Converted and loaded data from flat files to temporary tables in Oracle database using SQL*Loader.
• Extensively used PL/SQL in writing database packages, stored procedures, functions and triggers in Oracle 9i.
• Developed SQL scripts involving complex joins for reporting purposes.
• Fine Tuned (performance tuning) SQL queries and PL/SQL blocks for the maximum efficiency and fast response using Oracle Hints.
• Used Teradata as a Source and a Target for few mappings.
• Migration of MS Access to SQL SERVER 2008.
• Developed Functional and Regression Testing scenarios based on XML and XSD schema validations
• Load data from MS Access database to SQL Server 2005 using SSIS (creating staging tables and then loading the data).
• Develop various SQL scripts and anonymous blocks to load data SQL Server 2008.
• Create procedures, functions and views in SQL Server.
• Develop ad hoc reports using Crystal reports XI for performance analysis by business users.
• Exported reports into various formats like XML, PDF, HTML, and EXCEL using Crystal Reports XI.
• Involved extensively in Unit testing, integration testing, system testing and UAT.
• Responsible for the reports deployment through SSRS on the Reports Server. Returned the stored procedure and the UDF for the reports.
• Participated in weekly end user meetings to discuss data quality, performance issues. Ways to improve data accuracy and new requirements, etc.

Environment: Oracle, SQL Server, Crystal Reports, SQL, PL-SQL, Linux, and UNIX