SUMMARY

• Over 10 years of experience in Information Technology field with strong emphasis in Data Analysis (DA), ETL, Business Intelligence (BI) and Data Warehousing (DW) associated projects.
• Exposed to complex assignments in various domains like Banking, Mortgage, Investment, Healthcare and Insurance.
• Expertise in the different stages of Software Development Life Cycle (SDLC) i.e. Requirement(s) gathering & analyzing, Design/redesign, Implementation and Testing.
• Strong understanding of Data Warehouse concepts like Star Schema, Snowflake Schemas and Multi - Dim Models.
• Proficient in performance analysis, monitoring and SQL query tuning using EXPLAIN PLAN, Collect Statistics, Hints and SQL Trace both in Teradata as well as Oracle.
• Experience in ETL utilities like BTEQ, FastLoad, MultiLoad, TPT, SAS Procedures, Informatica Power Center, Microsoft SSIS, Oracle utility like SQL Loader and SQL Server utility like DTS, BCP etc., to export and load data to/from different source systems including flat files.
• Experience in Business Intelligence Tools like Tableau, SAP BusinessObjects Universe Designer (Data Modeling), Data Integrator (ETL), Web Intelligence, Crystal Reports, Crystal Xcelsius, for Report development.
• Hands on experience using query tools like TOAD, SQL Developer, PLSQL developer, SQL Assistant & Query man.
• Expert working knowledge of different RDBMS technologies like RDBMS like Teradata 12.x/13/x, MS SQL Server 2000/2005, ORACLE 10g/9i/8.x/7.x, Sybase 11.x, MS Access 98/2000.
• Expert in preparing all kinds of documentation for design and functional specifications.
• Undergoing online Big Data Hadoop training which covers various methodologies like HIVE, Spark, Sqoop etc.
• Actively involved in Quality Processes and release management activities by monitoring and streamlining project tasks.
• Expertise in SQL, T-SQL, PL/SQL, My SQL, Stored Procedures, Functions, Cursors, Packages, Views, Indexes.
• An excellent team member with good interpersonal relations, strong communication skills and ability to quickly adapt to different project environments, work in teams and accomplish difficult tasks independently within time frame.

TECHNICAL SKILLS

Operating Systems: Windows 95/98/2000/NT/XP/2000 Server, UNIX, Sun Solaris.

Reporting Tools: Tableau 10.x/9.x/8.x, MS SSRS, Business Objects, Crystal Decisions, Crystal Reports, Business View Manager, Excel 2000/XP

RDBMS: Teradata 15/14/13/12, IBM DB2, MS SQL Server 2000/2005, Oracle 10g/9i/8.x/7.x, Sybase 11.x/12.0, MS Access 98/2000Data-modeling Tools:

ETL Tools: FastLoad, MultiLoad, Informatica Power Center/ Power Mart 9.x/8.x/7.x, MS SSIS

Web Technologies: HTML, DHTML, Java Script, MS front Page, Adobe Dreamweaver CS3.

Communication Tools: MS Outlook, Remedy 7.0, Lotus Notes 5.x/6.x, Reflection X (Unix Client)

Other Tools: MS Office (Excel, Access, Word), Quick Test Pro (QTP 10.x)

PROFESSIONAL EXPERIENCE

Confidential, Plano TX

Sr Teradata/BI Consultant

Responsibilities:

• Worked in all the stages of the SDLC like Business, Functional, Technical Requirements Gathering, Designing, Documenting, Developing and Testing.
• As part of the Opus Data Extraction Project, performed data migration tasks which involve MS SQL Server and Teradata using Informatica ETL.
• Using ERWIN, designed the needed data models for the Teradata UD Containers which acted as the presentation layer on top of the available Teradata MDW Datamarts.
• Involved heavily in writing complex SQL queries based on the given requirements such as complex Teradata Joins, Stored Procedures, Macros, etc.
• Created various reporting applications using Tableau software and migrated reports from Business Objects to Tableau.
• Worked on the PCQA Automation project which involves the automation of various PCQA questions from the Risk Rating guide.
• Developed mappings using Informatica PowerCenter Designer to load data from various source systems to target database.
• Worked on a number ad-hoc data requests emanating as part of the Well Managed projects.
• Designed/created various business processing tasks using Python which involves different RDBMS sources and business applications.
• Involved in Cassandra data migration project which included the loading of aggregated HE OPUS data.
• Worked on automating different business tasks using UNIX Pcron Scheduling.
• Perform business process mapping/data mapping for change requests and new requirements.
• Used Teradata ETL Utilities like FastLoad, Multiload to load adhoc data files into the RDBMS.
• Worked with the Business Users in Production implementation and Post production validation.
• Create mockup reports and prototypes to get a sign off from the customer.
• Write complex SQL’s and used volatile tables for the code modularity and to improve performance of the report.
• Involved in tuning the SQL’s in order to improve the SQL execution performance.
• Creating the STM Documents as part of the Data migration projects.
• Acted as a SMEs for the most of the Home Loans related subject areas.

Environment: Teradata 15.x/13.x, Tableau 10.x/9.x, Informatica Power Center 9.x/8.x, Microsoft SQL Server 2000/2005, SAP BI 4.0(Universe Design Tool/ Web Intelligence), Windows 2000/XP Server, MS Office Tools.

Confidential, Richardson, TX

Sr Teradata Consultant

Responsibilities:

• Worked in all the stages of the SDLC like Business, Functional, Technical Requirements Gathering, Designing, Documenting, Developing and Testing.
• Designed and executed extract processes for the ACE/CCE Project using the DB2 and Teradata RDBMS systems by creating complex SQL queries in DB2 and Teradata.
• Worked on different proprietary mapping methodologies named DMIH Process to process the 834 File and TMG DAF files received from TMG and different states as part of the Medicaid MOMS Project.
• Designed complex Tableau analysis/reporting applications using Tableau for the ACE/CCE Project.
• Created adhoc reports to users in Tableau by connecting various data sources apart from RDBMS sources.
• Generated Dashboards with Quick filters, Parameters and sets to handle views more efficiently.
• Published Workbooks by creating user filters so that only appropriate teams can view it.
• Used filters, quick filters, sets, parameters and calculated fields on Tableau reports.
• Generated context filters and used performance actions while handling huge volume of data.
• As part of the Encounters Data Migration and Specialty Drug File Load projects, deigned various complex MultiLoad and FastLoad scripts to perform data loads to the Teradata Data warehouse.
• Designed complex Stored Procedures in SQL Server and Teradata to accomplish complicated tasks related to the FRED SPAdmin Maintenance.
• Automated the ERRT process execution using the command line parameters and designed the required back end SQL Server Stored Procedures to support the automation.
• As part of the ARRT Process Optimization project, analyzed Teradata SQLs and applied needed SQL tuning techniques to better the query execution performance.
• Worked on PowerCenter Designer client tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplets Designer and Transformations Developer.
• Involved in the creation of Fact Tables and Dimensions and Measures.
• Implemented Joiner, Expression, Aggregate, Rank, Lookup, Update Strategy, Filter and Router Transformations.
• Created Schema objects like Indexes, Views and Sequences.
• Created Tasks, Workflows and Worklets using Workflow Manager. Monitoring of Workflows and Worklets using Workflow Monitor.
• Designed complex table structures and views in Teradata and SQL Server as part of MCM360 Project.
• Involved heavily in writing complex SQL queries based on the given requirements such as complex Teradata Joins, Stored Procedures, Macros, etc.
• Involved in developing and performing UAT of the Presentation Layer for Building reports from 3NF data models in Teradata.
• Automated Production reports by scheduling them on a daily/weekly as required by the Business.
• Worked extensively in Optimizing Report/SQL Query Optimization (Explain plans, Collect statistics, Primary and Secondary indexes).
• Worked with the Business Users in Production implementation and Post production validation.
• Write complex SQL’s and used volatile tables for the code modularity and to improve performance of the query.
• Designed T-SQL stored procedures and packages for data loading, reports and data analysis and validation.
• Involved in tuning the SQL’s in order to improve the SQL execution performance.
• Created Data Mapping Documents as part of the Data migration projects.
• Worked closely with the Business to understand their needs and provided my inputs to address their needs and requirements.

Environment: Teradata 14.x/13.x/12.x, Microsoft SQL Server 2008, Informatica Power Center 8.x, MS Access 2000, Windows 2000/XP Server, MS Office Tools.

Confidential, Plano TX

Sr Teradata/BI Consultant

Responsibilities:

• Worked in all the stages of the SDLC like Business, Functional, Technical Requirements Gathering, Designing, Documenting, Developing and Testing.
• Strong Experience in Technical and Business Requirements Documentation.
• As part of the Equator Data Migration Project, performed data modeling tasks from the source which is a SQL Server RDBMS to the target which is a Teradata RDBMS and also designed complex reporting applications using Business Objects.
• As part of the DCR Global 360 Project, performed data mapping tasks from the source which is a Oracle RDBMS to the target which is a Teradata RDBMS and also designed complex reporting applications using Business Objects.
• Worked on the ING Integration project which involved ING Historical mortgage data mapping into Confidential 3NF Data warehouse. Involved heavily in writing complex SQL queries based on the given requirements such as complex Teradata Joins, Stored Procedures, Macros, etc.
• Performed ETL tasks like designing source to target data mapping to create new database objects that need to be added to the Databases and monitor data refresh on a daily basis.
• Perform business process mapping/data mapping for change requests and new requirements.
• Extract the data from Flat files or external data sources like Equator, Passport, etc. and load them into data warehouse using FastLoad/MultiLoad to perform analysis and generate reports off of them.
• Involved in developing and performing UAT of the Presentation Layer for Building reports from 3NF data models in Teradata.
• DevelopedComplex SAS programs for data loading purposes from disparate sources as part of the CCM Data reporting and DCR UAT project.
• Automated Production reports by scheduling them on a daily/weekly as required by the Business.
• Worked extensively in Optimizing Report/ SQL Query Optimization (Explain plans, Collect statistics, Primary and Secondary indexes).
• Involved in Data Validation and User Acceptance Testing with Cross Functional Teams that follow Agile methodology, to find resolution for Defects
• Worked with the Business Users in Production implementation and Post production validation.
• Create mockup reports and prototypes to get a sign off from the customer.
• Write complex SQL’s and used volatile tables for the code modularity and to improve performance of the report.
• Designed PL/SQL and T-SQL stored procedures and packages for data loading, reports and data analysis and validation.
• Responsible for loading the Teradata UD tables for the Daily and Monthly reports related to Rose-Tracker, Debt Protection, CCM and FNMA.
• Involved in loading the REO tables and provided underlying SQL Scripts for the critical REO Dashboards and Scorecards built in Business Objects Environment.
• Provided production support to the Default &Servicing and Originations Reports in the Business Objects Environment.
• Created and supported Daily Fulfillment Reports in the Business Objects and Crystal Reports Environment.
• Involved in tuning the SQL’s in order to improve the SQL execution performance.
• Creating the STM Documents as part of the Data migration projects.
• Acted as a SMEs for the most of the Home Loans related subject areas.

Environment: Teradata 13.x/12.x, Microsoft SQL Server 2000/2005, Oracle 11g/10g, SAP BI 4.0(Universe Design Tool/ Web Intelligence), Windows 2000/XP Server, MS Office Tools.

Confidential, Chicago, IL

Business Intelligence/ETL Consultant

Responsibilities:

• Worked with Business Users in executing different number of projects like Risk Performance Projects, London Reports Customization using Business Objects - QTP Integration, Reports Migration.
• Interacted with Business Users, Business Owners and Database teams on Business Requirements.
• Interacted with Business Users to understand and document the requirements and translate these to Technical Specifications for Universes and Business Object Reports.
• Writing complex SQL Queries and Stored Procedures which act as Data Sources to the reporting applications.
• Worked with Business team on the new change requests, fixing defects in Business Objects reports and enhancements after migration.
• Involved in migration from existing BOXIR2 systems to BOXIR3.1 in all four Environments (Dev, Test, Pre-Prod, Prod).
• Created 5 Complex Universes which involved user defined objects which included complex Financial Calculations.
• Migrated Users/Groups, documents (Web I and Desk I), Universe, folders and objects using Import Wizard.
• Added/deleted, enabled/disabled various BO servers using Central Configuration Manager.
• Created users/ groups and defined their roles and set privileges using the CMC
• Created queries to extract data from database for multi-dimensional analysis using Slice & Dice, Master Detail and Drill up/down/by/through functionality.
• Worked as a team in developing business objects Crystal Xcelsius Dashboards.
• Installed & Configured Business Objects Enterprise XIR3.1 on Windows 2000 server and created Repository.
• Formatted the raw data retrieved from Universe Objects in Xcelsius spreadsheet using VLOOKUP, IF, AND, OR, CONCATENATE and many other excel formulae/functions that are supported in Xcelsius.
• Used multi value components like line charts, bar charts, stacked column charts and combination charts, and single value components like gauge, slider, dial and progress bars in the development of the Dashboards.
• Extensively worked on new Xcelsius components like Print Button, Connection Refresh Button, Refresh Button, and Trend Icon.
• Extensively used slice and dice, filtering and ranking to create cross tab and master/detail reports.
• Involved in formatting sections, tables, inserting and organizing multiple breaks.
• Extensively worked on drill mode to view data in different Perspectives.
• Used the formatting options like cross tab representation, section breaks, data sort options, calculations, font, colors etc.
• Prepared Test Cases and Test Scripts for Unit Testing.
• Involved in Unit testing, System testing and User Acceptance Test (Universes and Reports) throughout migration process.
• Implemented Single Sign-On(SSO)and XI Portal Integration Kit.
• Provided extensive support for the users on application usage and trained users in the functionality of the software.

Environment: Business Objects XIR2/XIR3.1 (CMC, SIA, CMS, Designer, DESKI),Qlikview Web Intelligence, Desktop Intelligence, Info View, Toad 9.0, Import Wizard, Conversion Tool, Server Intelligence Agent, Crystal Reports 2008, Xcelsius 4/5/2008, Oracle 8i/9i/10g, SQL Server, MS Access, DB2, Sybase, Teradata V2R6.0, SAP BW (OLAP/MOLAP), Microsoft SQL Server 2000/2005, Windows 2000/XP Server.

Confidential, Chicago, IL

Business Intelligence/ ETL Consultant

Responsibilities:

• Interacted with the users/clients to understand and gather the business requirements.
• Worked on a Business team and have a very good knowledge of the Confidential investment business.
• Worked with the Business analysts, end users and the DBA for requirements gathering, business analysis, and testing, project coordination.
• Worked with data-warehouse team in building a new DWH called DQS for the NTGI.
• Worked on Excel Automation projects, translated complex VBA procedures to Oracle Functions.
• Peformed Data Mapping tasks using complex SQL Queries for ETL Purposes.
• Writing SQL, PL/SQL procedures, packages, functions for the Oracle and Sybase databases. Testing and maintaining the DBMS systems
• Designed and Developed Business Objects universes and applied row level and object level security to different groups and users.
• Maintained Universes and exported them to the CMS repository
• Resolved loops, fan traps, chasm traps by creating aliases and contexts
• Used Designer Module to implement Universes, Joins between Tables, and created prompts and queries, parsing of Universes, and created Contexts and Alias Tables to remove cyclic dependencies.
• Customized LOVs (Combining Code and Description).
• Designed Exception Reports for the Users to help understand their data discrepancies.
• Design and Development of Web intelligence and Desktop intelligence reports based on the business/client requirements.
• Conducted training sessions for end users about using Business Objects Full client version and creating ad-hoc Reports.
• Created user Prompts, Conditions and Filters to improve the report generation. Also used Alerters to improve the readability of the report.
• Involved in creating thin client reports using Business Objects Web Intelligence 6.1 and exported them to the repository to be viewed by all WebI users.
• Extensive testing and migrating the reports or objects from Test to Production system.
• Handled Embedded Functions like @Prompt, @Select and @Where in the Designer to handle User requests for report generators.
• Used the Publishing wizard to export different document types as objects to different folders in CMC.
• Worked on the SQL tuning and optimization of the Business Objects reports.
• Linked reports using Open Document syntax to link master report to detail report.

Environment: BO XI 3.1/R2, Designer 6.5, Desktop Intelligence, Web Intelligence 6.1, Crystal Reports 9, Oracle 10g, SQL Server 2005, SQL, PL/SQL, Query Analyzer, Rapid SQL, TOAD, Visual Basic Editor, Windows 2003 Server, RHL 7.2, MS Word, MS Excel