PROFESSIONAL SUMMARY:

• Over Eight years of professional experience as a Data warehouse developer / Analyst in IT Industries with strong Data Warehousing, Data Marts, Data Analysis experience in RDBMS databases
• Attending project meetings and work with teams, Project managers, team members / associates, business analysts, statisticians, and internal customers/ end users, working with multiple tasks.
• Hands on experience in Finance, Telecom, Health Insurance Industry.
• Gathered, documented, and analyzed user requirements for the operational data marts.
• Extracting data from production data stores, Built Data structures, Developed departmental reports for performance and response purposes by using oracle SQL, MS Access, MS Excel, PL/SQL.
• Good Experience in preparing financial reports using oracle SQL, Teradata, BTEQ.
• Experience in Data warehouse, ETL - Extraction/Transformation/Loading, Data Analysis, Data migration, Data preparation, Reporting, Validation and Documentation.
• Performing Data validation, Data integrity, Data Quality checking before delivering data to operations, Business, Financial analyst by using Oracle, Teradata, Bteq.
• Designing, Developing, implementation of the Data marts, Data Structures, Stored Procedures, Functions, Data warehouse tables, views, Materialized Views, Indexes at Database level using PL/SQL, Oracle.
• Experience in automating shell scripts by UNIX CTL-M job.
• Experienced in databases - design, writing stored procedures, triggers and queries.
• Provided marketing tables to the Business Analyst’s in the marketing team for various flexibilities to make accurate analysis for their campaign research.
• Designed and developed weekly, monthly reports related to the marketing and financial departments by using SQL, PL/SQL, Ms Excel, Ms Access, and Teradata.
• Strong in analysis, requirements gathering, design, development, implementation, and management of full life cycle data warehousing projects.
• Experience in developing web pages using power builder
• Created staging tables, views on the top of the marketing and production databases for the Business Analyst’s for their analysis and reporting by using Teradata, Bteq, UNIX, SAS.
• Good experience working with very large databases and Performance tuning.
• Acted as liaison between IT department and core business group to prepare/maintain database reporting and perform data analysis and documentation using Oracle, teradata, MS Access, OLAP tools.
• Experience in creating views to the use of business objects repots.
• Experience in developing Data warehousing, Data marts by using various databases.
• Experienced in databases - design, writing stored procedures, triggers and queries.
• Team Player as well as able to work independently with minimum supervision, innovative & efficient, good in debugging and strong desire to keep pace with latest technologies

TECHNICAL SKILLS:

Operating Systems: WINDOWS NT, WINDOWS 95/98/2000 and UNIX

RDBMS: Oracle 9i/10g/11g, SQL Server 2000/2005,DB2, Teradata V2R5/V2R6//12.0

Data Modeling: Erwin, Power designer, Visio2000

Languages: C, C++, Java, COBOL, PL/SQL, SQL

ETL: Informatica Power Center 9.1/8.6/8.1/7.1, Data Stage, SSIS

ERP: People Soft Financials (GL, AP, AR, AM,)

GUI Tools: Developer 2000, Visual Basic, VBA, power builder

OLAP: Business Objects 5.1.2/6.5,Hyperion Essbase, SAS

PROFESSIONAL EXPERIENCE:

Confidential, Indianapolis, IN

Data Analyst/ETL Developer

Responsibilities:

• Participated in user meetings, gathered Business requirements & specifications for the Data-warehouse design. Translated the user inputs into ETL design docs.
• Involved in the designing of the Data Model in deriving Conceptual, Logical and Physical model’s using Erwin with Architect teams. Defined, and documented the technical architecture of the Data Warehouse, including the physical components and their functionality.
• Designed ETL architecture to Process large no of files and created High-level design, low-level design documents.
• Responsible for implementing the Informatica/Teradata CDC logic to Process the delta data.
• Extensively worked on flat files, mainframe files and involved in creation of UNIX shell scripts using different shell scripts for FTP, generating list files for loading multiple files and in archiving the files after the completion of loads.
• Involved in the creation of Informatica mappings to extracting data from oracle, Flat Files to load in to Stage area. Worked data mapping, data cleansing, program development for loads, and data verification of converted data to legacy data.
• Designed and Created data cleansing, data conversion, validation and External loading scripts like MLOAD and FLOAD for Teradata warehouse using Informatica ETL tool.
• Involved in error handling, performance tuning of mappings, testing of Stored Procedures and Functions, Testing of Informatica Sessions, and the Target Data.
• Experienced in loading data into Data Warehouse/Data Marts using Informatica, Teradata Multiload, Fast load and BTEQ utilities.
• Extensively worked on indexes in Teradata and Creation of proper Primary Index (PI) talking into consideration of both planned access of data and even distribution of data across all the available AMPS.
• Worked with DBA in making enhancements to physical DB schema. Also coordinated with DBA in creating and managing table, indexes, table spaces, triggers, db links and privileges.
• Possess expertise with relational database concepts, stored procedures, functions, triggers and scalability analysis. Optimized the SQL and PL/SQL queries by using different tuning techniques like using hints, parallel processing, and optimization rules.
• Responsible for SQL tuning and optimization using Analyze, Explain Plan and optimizer hints.
• Extensively worked on maintaining the up to date statistics of the tables by using explain plans. Extensively worked in Skew Factor, resource usage of the queries using query log data.
• Loading data by using the Teradata loader connection, writing Teradata utilities scripts (Fast load, Multiload) and working with loader logs. Scheduled workflows, BTEQ Scripts, UNIX shell scripts using WLM Scheduling tool.
• Testing and debugging of all ETL and Teradata objects in order to evaluate the performance and to check
• Responsible for migrations of the code from Development environment to QA and QA to Production.
• Documented the existing mappings as per the design standards followed in the project.
• Prepared the validation scripts to compare the new data with legacy systems.
• Carry out Defect Analysis and fixing of bugs raised by the Users
• Highly motivated with the ability to work effectively in teams as well as independently

Environment: Erwin, Informatica Power Center 9.1/8.6, Teradata, UNIX Shell Scripting, Business Objects, SAS and Windows XP.

Confidential, Hartford, CT

Sr. Data Analyst

Responsibilities:

• Involved in gathering new Business user requirements and understanding Reporting needs to be implemented into the Data Warehouse using Informatica Power Center 9.1.
• Created End to end detailed Logical Data mappings based on the Business requirements and the ETL workflows already running.
• Data Validation done by using SQL queries to access database and validate information for reports.
• Lead effort to create Test Conditions and Test Scripts for all subject areas.
• Maintained existing mappings by resolving performance issues.
• Creating a standard framework for System monitoring and alerts
• Creating a standard framework for data verification an validation process
• Creating a standard framework for cooperative locking mechanism where in data loads, index rebuilds, db stats, data purging processes work cooperatively without stepping on each other.
• Created Daily, Weekly, monthly reports related to the collection and financial departments by using Teradata, Bteq, SQL, and Ms Excel. Created History tables, views on the top of the Finance Data mart and production databases for the Business Analyst’s for there data analysis/ reporting needs by using Teradata, Bteq, UNIX.
• Performed Data validation, Data integrity before delivering data to operations, Business, Financial analyst by using Oracle, Teradata, Bteq, Ms Excel, Ms Access.
• Developed SQL queries, Ad Hoc for Extracting data from production databases to built data structures, reports.
• Extracted latest accounts data from Oracle, Teradata database by using SQL, BTEQ, and PL/SQL.
• Developed SQL, Bteq (Teradata), Ad Hoc queries to fulfill business analyst requirements.
• Developed Ad hoc queries and scripts to meet the Business Analyst’s and the Operational Analyst’s requirements by using Teradata, UNIX, Oracle, SQL.
• Created technical documentation for database, Function documentation/specification for report requirements
• Performed data extraction, data manipulation, data validations with help of Teradata, Oracle
• Provided ad-hoc reporting and Demonstrations for various financial reports

Environment: Teradata, SQL assistant 6.1, Oracle, SQL,PL/SQL,UNIX,SAS 9.1,Windows 2000/NT,UNIX

Confidential

Senior Data Analyst

Responsibilities:

• Participated in all phases including Analysis, Design, Coding, Testing, Production Support and Documentation.
• Performed numerous data pulling requests using TERADATA SQL Assistant, Oracle8i/9i, SQL Server 2000, SAS Base V9.1 and Mainframes.
• Extensively worked on to convert ORACLE scripts into Teradata scripts
• Used Joins like Inner Joins, Outer joins while creating tables from multiple tables.
• Designed & developed various Ad hoc reports for the CFDW Project (Teradata and Oracle SQL, MS ACCESS, MS EXCEL)
• Provided Data Analysis, gathered Business requirements and Designed and developed various Business Reports
• Also developed reports for the DELINQUENT Accounts with Wells Fargo.
• Enhanced the existing shell scripts to include new customers and executed the Kron jobs to schedule the CFDW data.
• Exported data from Teradata into various files by using Ms Excel, Ms Access and SAS.

Environment: Teradata, SQL assistant 6.1, Oracle, SQL, PL/SQL, UNIX, SAS 9.1,Windows 2000/NT

Confidential, Boston, MA

Data Analyst

Responsibilities:

• Involved in JAD sessions with SME’s, business users to analyze the High Level Requirements.
• Responsible for designing multi-thread extraction, load, transformation and aggregation, which significantly improved the overall performance throughput.
• Communicate creation or change of elements or other data items to affected owners or application development teams.
• In charge of designing and coding the scripts for end user reports based on in-depth analysis and interaction with the customers to get the desired results.
• Created BTEQ’s for the all the monthly and quarterly reports which were very efficient in using the CPU utilization on the UNIX box and in using the space on the database.
• Worked on the creation of the script which creates the driver table for many reports, the Master table contained detailed information for accounts which were randomly picked, this pool of random accounts had to have a sum total account balance as desired by treasury and had to satisfy many different criteria .
• Created Korn shell ( ksh) to run the scripts sequentially with checks for errors and account balances of the total accounts involved
• Analyze the request, convert the business requirements to DWH requirements i.e. attributes and metrics, create the SQL to pull the data
• Implement the request in DWH environment (CRON UNIX/ CA7 Mainframe) depending on the type of the request i.e. for the ongoing requests. Support the job and implement the ongoing enhancements
• Used Microstartegy web interface to generate reports using derived metrics, exporting reports to excel and worked with the business on various reports critical to business needs.
• Implement the new code in production and propose the SQL changes to implement the same change on the other tables
• Worked on many DMD’s (Demand Management Database) used to help the business meet there needs.
• In charge of gathering information and coding of the CSDM report for the transaction level data, it was very successful implementation and based on my recommendations we had replaced a very lengthy and semi automated process into a fully automated job
• Worked on the ADHOC report’s which was used in reporting various metrics involved in the small business and capital one master trust data
• The last stage of the project was the testing of the scripts for there overall performance
• Assist with navigation of database to support Reporting Team
• Involved in loading dimension tables, Fact tables based on surrogate key
• Worked on Job scheduling tool ‘Autosys’ to automate jobs on daily basis.

Environment: Oracle 9i/10g, SQL Analyzer, C, C++, Korn Shell, SQL, SOLARIS-Unix, Windows XP, Data Stage Version 7.1/7.5 (Designer, Manager), Teradata SQL 6.2, SAS

Confidential, Tampa, FL

ETL Developer/Data Analyst

Responsibilities:

• As an ETL Developer was involved in analysis, design, development and testing of the system. Some of my responsibilities are:
• Dimensional Modeling was done using ERWIN. Responsible for identifying, defining, loading and refreshing Customer, Organization, Campaign, Time, Contact, Suppression/Permission dimensions for Service order Data Mart.
• Was Involved in Development of the DSOF Application using Data Stage 7.1, which had the data from 11 regions and the source for this application is a flat file
• Was also involved in Designing the Report for the Business and Residential Customers for Verizon using numerous C, C++ functions in the form of OSH scripts and Business Objects 5.1
• Provided 24/7 Production support to the DSOF and RCAD Applications
• Wrote Numerous MLOAD,Fast Export Scripts on Unix for loading the data into the DATABASE Directly
• Was also involved in the Changing the code from the existing version to the new version using ERWIN6.1
• Was also involved in preparing the Detail Design Document for various applications using Visio
• Designed secured access rights structures for all Teradata systems to permit legitimate users access to only those resources they are authorized to use.
• Created Fast Export, MultiLoad, Fast Load UNIX script files for batch Processing
• Undertake database recovery actions as required and generally contributing towards the overall online availability goals of the organization Create and optimize the SQL scripts.
• Supported application development timelines by implementing designs as well as incremental changes to database definition in a timely manner into production and non-production Teradata systems.
• Maintain and Tune Teradata Production and Development systems.
• Perform tuning and optimization of database configuration and application SQL.
• Establish backup jobs, review procedures for backing up and review frequencies for backing up DBC using Netvault.
• Capacity planning, proactive monitoring and developing a Mixed Workload Strategy to meet performance and growth requirements.
• Monitor error log(s), database and log space, user activity and resource utilization of production environment. Work with application programmers to insure that application problems do not adversely affect production operations.
• Provide production Teradata System’s troubleshooting support.

Environment: C, C++, Korn Shell, SQL, HP-Unix, Windows XP, Orchestrate, Data Stage Version 7.1/7.5 (Designer, Manager), Teradata SQL 6.2

Confidential, Danbury, CT

Data Warehouse/TERADATA/ETL consultant

Responsibilities:

• The Project involved development of reports using Business Objects to cater their ad-hoc reporting needs. Was involved in the requirements analysis, Business Design and Field Mapping that involves extensive interaction with the Users and the management in the collection of information for their reporting needs
• Worked exclusively on the Real estate transactions ( Involved in calculating the delinquencies )
• Worked in Various Stages of Data warehousing life cycle development database logical and physical design, ETL process, performance tuning on Windows NT, UNIX operating systems on SMP and MPP machines
• The business design work involved in establishing the reporting layouts for various reports and also the frequency of report generation. Field mapping work involved establishing relationships between the database tables, filter criteria, formulas etc., needed for the reports
• As part of BO reporting, created Universes for different functionalities such as Sales, Finance system
• Created sales volume analysis report which involved area-wise sales analysis for the top management in decision-making.
• Created reports for Source order, Purchase orders, Invoicing, scheduling functions
• Supervisory functions include giving access to the users to certain configurations, setting up the repository with one-security domain three Universe domains and one document domain
• The reports were generated using Business Objects using various functionalities such as Master-details, creation of filter objects as part of resolving loops, creating functions for complex functionalities and drill down reporting.
• Performed duties as BO architect that includes installation, configuration of BO and Web Intelligence, created universes for reporting.
• Well versed with the Hyperion Essbase reporting concepts, had a one-one interaction with the reporting people to gather the requirements for building the Warehouse.

Environment: Informatica Power Center/Power Mart 5.1, Oracle 8.1.7, Windows NT/Unix, Sybase, Db2, Business Objects 5.1.1, 5.1.3

Confidential

Software Programmer/Analyst

Responsibilities:

• Involved in customization and implementation of Oracle Applications for Apollo Hospitals Limited.
• Involved in the Information strategy planning that entails in identifying the company’s Business needs and the user requirement analysis.
• Completed a case study for the Implementation of VB Applications comprising of General Ledger, Accounts Payable and AOL.
• Developed variety of Forms using Oracle Forms 4.5.
• Wrote Data Conversion programs using SQL*Loader and PL/SQL
• Developed numerous forms in VB according to Business logic and the User requirements
• The whole accounting and billing process was automated using numerous C and C++ functions.
• Wrote shell scripts to execute the scripts written in c and c++ in batches
• Was also involved in providing production support for numerous medical applications

Environment: C, C++, Oracle7.3, Microsoft Visual Basic 6.0, MFC, Windows NT/Unix