SUMMARY:

• 7+ years of IT experience in analysis, design, coding, development and testing of data warehouse systems. Hands on experience include developing Data Warehouses/Data Marts/ODS/BI Solutions using in Confidential Retail and Confidential Call Center.
• Currently working in Confidential
• Strong experience in Teradata Database in Data warehousing Environment, Oracle PL/SQL.
• Expertise in using Teradata SQL Assistant and data load/export utilities like BTEQ, Fastload, MultiLoad, Fast export and TPump on UNIX/Mainframes environments.
• Proficient in Teradata Query optimization, Performance Tuning.
• Experience in both technical and analytical skills with clear understanding of design goals of ER modeling for OLTP and STAR schema and/or SNOW FLAKE schema for OLAP, Multi dimensional cubes.
• SQL/Database developer experience in writing efficient SQL queries, PL/SQL Scripts, fine tuning queries and wrote several SQL queries for ad - hoc reporting.
• Extensively used different features of Teradata such as BTEQ, Fastload, Multiload, SQL Assistant, DDL and DML commands.
• Familiarity with Teradata’s MPP architecture such as Shared Nothing, Nodes, AMPs, BYNET, Partitioning, Primary Indexes, secondary indexes, Teradata Explain etc.
• Strong experience with data analysis, data modeling, extraction, loading, creation of tables, Creation of Universes, views, query optimization and performance tuning.
• Worked on various projects using TERADATA, ORACLE, SQL, Tableau, Business Object, Crystal Report .
• Extensive Knowledge in Informatica ETL tool, Teradata and UNIX Shell scripting.
• Good Experience with UNIX shell (Korn Shell) wrapper scripts .
• Sound Knowledge of Data Warehouse/Data Mart, Data Modeling Techniques. Very good understanding of Dimensional Modeling.
• Demonstrated ability in grasping new concepts (both Technical & Business) and utilized as needed.
• Strong experience leading facilitation sessions, participating in use cases, business rules and analyzing the system requirements, testing the application, Sign-off the issues and Installations to production.
• Created CORDA Dashboard, Tableau Report, and Business Objects Reports that had multiple data providers, drilldown, slice and dice features using Business Objects (Designer and Reporter).
• Worked with a project development and test team providing support during the project cycle, helping develop optimum solutions for data warehouse deliverables.
• Excellent communication, interpersonal skills and has a strong ability to work as part of a team and as well as handle independent responsibilities.
• Developed dashboards using Tableau desktop and publishing them to Tableau server
• Generated tableau dashboards with Tree Maps, Geo Maps, Stack Bars, Line Graphs, Histograms, Pie Charts, Donut charts, Heat Maps, Scatter Plots for showing Trends with Dual Axis
• Designed and deployed rich Graphic visualizations with Drill Down and Drop down Menu options, Parameterized and Linked reports, Local and Global filters, context filters using Tableau desktop.
• Used different functionalities in Tableau such as data blending, sets, groups, filters, parameters, actions and Hierarchies.
• Reviewed basic SQL queries and edited inner, left and right joins in Tableau Desktop by connecting to live and extract datasets

TECHNICAL SKILLS:

Databases:: Teradata, Oracle, PL/SQLOS: Mac OS X, Windows

Teradata Utilities:: Bteq, FastLoad, MultiLoad, FastExport,TPump

Reporting Tools:: CORDA, Business Object, Crystal Report and Tableau.

ETL Tool:: Informatica.

Scheduler: Autosys Jobs Scheduler.

Scripting:: Unix Shell Scripting.

PROFESSIONAL EXPERIENCE:

Confidential, Cupertino, CA

Business Intelligence

Responsibilities:

• Working with the business and BPR to understand the requirements.
• Doing Feasibility analysis on the requirements.
• Documenting the functional requirements and submitting it for development.
• Review and creation of design and technical specifications.
• Present the Design to all the stakeholders and get the sign offs.
• Doing the Development as per the Design and Leading the offshore team. Managing All the development tracks.
• Creation and execution of UT, FT and IT test cases, to test the new changes.
• Supporting the business testers during the UAT changes, explaining to the business issues raised in during the UAT.
• Fixing the bugs based on the priorities assigned to them and felicitating the Closure of the bug once the fix is implemented.
• Creation of the Cutover Plan and getting the sign off from the stakeholders.
• Leading the Production Implementation and Validation to ensure that the deployment is done correctly and the changes are thoroughly validated.
• Leading the Warranty Support after the Production Cutover.
• Creating the Support transition Plan to transition the modules to APS.
• Development of scripts exporting and loading data from one environment to other on need basis.
• Creation of tables /materialized views as per the requirement, performance tuning in case performance glitches are encountered.
• Supporting Failovers between Primary and Secondary environments and supporting EDW expansions.
• Meeting with the clients and business to discuss on the upcoming tracks in line and get involved in the Requirement gathering phase for the upcoming tasks.
• Supporting Production Run and any Prod/Non Prod related issues encountered in the Application.
• Providing Status updates to the customer on a regular basis.
• Leading day-to-day activities and follow up with offshore and other teams.

Confidential

Responsibilities:

• Involved in Requirement gathering, business Analysis, Design and Development, Testing and implementation of business rules.
• Translate customer requirements into formal requirements and design documents.
• Preparing design doc for the project
• Interaction with the offsite team for their queries and attending regular calls to clarify them
• Code review
• Preparing/reviewing test cases
• UDM interface implementation
• Support for fixing the bugs raised during the UAT
• Project execution
• Implementation and support

Environment: Teradata, Autosys, Unix Scripts, Business Object

Confidential, Cupertino, CA

Responsibilities:

• Involved in Requirement gathering, business Analysis, Design and Development, testing and implementation of business rules.
• Translate customer requirements into formal requirements and design documents.
• Development of scripts for loading the data into the base tables in EDW using FastLoad, MultiLoad and BTEQ utilities of Teradata.
• Performed application level activities creating tables, indexes , monitored and tuned Teradata BETQ scripts using Teradata Visual Explain utility.
• Query Analysis using Explain for unnecessary product joins, confidence factor, join type, order in which the tables are joined.
• Collected Multi-Column Statistics on all the non-indexed columns used during the join operations & all columns used in the residual conditions.
• Used extensively Derived Tables, Volatile Table and GTT tables in many of the ETL scripts.
• Tuning of Teradata SQL statements using Explain analyzing the data distribution among AMPs and index usage, collect statistics, definition of indexes, revision of correlated sub queries, usage of Hash functions, etc.
• Use SQL to query the databases and do as much crunching as possible in Teradata, using very complicated SQL Query optimization (explains plans, collect statistics, data distribution across AMPS, primary and secondary indexes, locking, etc) to achieve better performance.
• Automation of load processes using Autosys.
• Prepare logical/physical diagram of DW, and present it in front of business leaders.
• Worked closely with the end users in writing the functional specifications based on the business needs.
• Participated in project review meetings.
• Collected and analyzed the user requirements and the existing application and designed logical and physical data models.
• Created reports using Fixed format report using Crystal Reports tool and Interactive dashboard using CORDA.
• Scripts were run through Unix shell scripts in Batch scheduling.

Environment: Teradata 13, Informatica, Autosys, Corda, Unix Scripts, Crystal report

Confidential, Cupertino, CA

Responsibilities:

• Met with business/user groups to understand the business process and gather requirements. Extracted and analyzed the sample data from operational systems (OLTP system) to validate the user requirements. Created high level design documents.
• Participated in data model (Logical/Physical) discussions with Data Modelers and created both logical and physical data models. Implemented Star Schema models for the above data warehouses by creating facts and dimensions.
• Created source-to-target data mappings.
• Created functional and technical detailed design documents for the ETL. Did the ETL using Informatica. Automated the ETL process using UNIX Shell scripting.
• Extensively used the Teradata utilities like BTEQ, Fastload, Multiload, TPump, DDL Commands and DML Commands (SQL).
• Performed tuning and optimization of complex SQL queries using Teradata Explain.
• Created a BTEQ script for pre population of the work tables prior to the main load process.
• Used volatile table and derived queries for breaking up complex queries into simpler queries.
• Performance Tuning of sources, Targets, mappings and SQL queries in transformations
• Created proper Teradata Primary Indexes (PI) taking into consideration of both planned access of data and even distribution of data across all the available AMPS. Considering both the business requirements and factors, created appropriate Teradata NUSI for smooth (fast and easy) access of data.
• Worked on exporting data to flat files using Teradata Fast Export.
• Analyzed the Data Distribution and Reviewed the Index choices.
• In-depth expertise in the Teradata cost based query optimizer, identified potential bottlenecks.
• Worked with PPI Teradata tables and was involved in Teradata specific SQL fine-tuning to increase performance of the overall ETL process.
• Prepared Unit and Integration testing plans. Involved in Unit and Integration testing using the testing plans. Involved in UAT with user groups.
• Created several SQL queries and created several reports using the above data mart for UAT and user reports. Used several of SQL features such as group by, rollup, case, union, sub queries, exists, coalesce, null etc.
• Created new Fixed format report using Business Objects tool and Interactive dashboard using CORDA.
• Served as point-of-contact for technical problem resolution.
• IT, UT,UAT, Production Implementation .
• Involved in after implementation support, user training and data models walkthroughs with business/user groups.

Environment: Teradata 12, Informatica, Autosys, Corda, Unix Scripts, Business Object

Confidential, Cupertino, CA

Responsibilities:

• Analyzed Business requirements, prepared the Physical design, High level designs and technical specifications.
• Created Unix scripts, DB scripts for partitions, compress and rebuild indexes, partition exchange and purging the partitions.
• Created ER diagrams, data models and other database related information by reverse engineering defined data dictionary, database entities, parent child relationship keys, identifying primary and referential integrity constraints, sequences, stored procedures, and triggers for source and target databases.
• Have experience in tuning some batch BTEQ queries.
• Enhanced some queries in the other application to run faster and more efficiently.
• Implemented star-schema models for the above data marts. Identified the grain for the fact table. Identified and tracked the slowly changing dimensions and determined the hierarchies within the dimensions.
• Worked with DBA team to ensure implementation of the databases for the physical data models intended for the above data marts.
• Created proper Teradata Primary Indexes (PI) taking into consideration of both planned access of data and even distribution of data across all the available AMPS. Considering both the business requirements and factors, created appropriate Teradata NUSI for smooth (fast and easy) access of data.
• Did the performance tuning for Teradata SQL statements using Teradata Explain command.
• Data was extracted from Teradata, Processed/Transformed using Ksh programs and loaded into Data Mart.
• Used various Teradata Index techniques to improve the query performance
• Used BTEQ and SQL Assistant (Query man) front-end tools to issue SQL commands matching the business requirements to Teradata RDBMS.
• Modified BTEQ scripts to load data from Teradata Staging area to Teradata data mart.
• Updated numerous BTEQ/SQL scripts, making appropriate DDL changes and completed unit and system test.
• Performed tuning and optimization of complex SQL queries using Teradata Explain.
• Created and automate the process of loading using Shell Script, Multi load, Teradata volatile tables and complex SQL statements. Used External tables for flat files in order for faster processing.
• Wrote stored Procedure for complex calculation and for faster processing of bulk volume of the data.
• Performed tuning and optimization of complex SQL queries using Teradata Explain.
• Created a BTEQ script for pre population of the work tables prior to the main load process.
• Identified the technical issues, risks and involved in the meetings with client and team mates to resolve.
• Created unit test plans to unit test the code prior to the handover process to QA.
• Created new Fixed format report using Business Objects tool and Interactive dashboard using CORDA.
• Performed migration documentation to move project from dev environment to all testing phases through UAT phase, and also supported the client to made sure that, code was delivered with in time and satisfied with their expectations.

Environment: Teradata, Informatica, Autosys, Corda, Unix Scripts, Business Object

Confidential, Cupertino, CA

Business Intelligence

Responsibilities:

• Created workflows using Informatica, prepared the test cases based on the business requirements and documented them in a specified manner.
• Performed the preparation of technical design docs, source to target mapping (filed to field matrix).
• Performed data validation, data reconciliation on the target, source data.
• Responsible in creating new tables, store procedures, triggers.
• Created mappings to generate the statistics for the dataflow and also mail notification when a particular load doesn’t meet the SLA.
• Performance Tuning of sources, Targets, mappings and SQL queries in transformations
• Created proper Teradata Primary Indexes (PI) taking into consideration of both planned access of data and even distribution of data across all the available AMPS. Considering both the business requirements and factors, created appropriate Teradata NUSI for smooth (fast and easy) access of data.
• Analyzed the Data Distribution and Reviewed the Index choices.
• In-depth expertise in the Teradata cost based query optimizer, identified potential bottlenecks.
• Worked with PPI Teradata tables and was involved in Teradata specific SQL fine-tuning to increase performance of the overall ETL process.
• Created new Fixed format report using Business Objects tool and Interactive dashboard using CORDA.
• Involved in the preparation of the QA checklist as per client provided standards.
• Performed coordination with onsite and offshore team.
• I was a key resource for the support during the system, integration and User acceptance test phases.

Environment: Teradata, Informatica, Autosys, Corda, Unix Scripts, Business Object, UNIX .