SUMMARY:

• Confidential is an IBM certified Netezza DBA and a data warehouse consultant with 15+ years of experience in multiple roles such as ETL developer, Netezza DBA, Data Modeler, Data Warehouse Consultant and Programmer/Application Analyst.
• Well versed with a range of technologies including Data Warehousing & Mining applications, data warehouse conversion and integrations projects, distributed computing, Client/Server Applications (OLTP), service - oriented frameworks, database systems, enterprise integration and object oriented application development.
• Very strong Analytical and problem solving skills, has depth in technical knowledge and effectively applies business solutions; improve productivity through re-usable centric design
• Extensive experience in Netezza 4.5.2/7.x, NZ utilities, NZLOAD, nzbackup, nzstats, Oracle, PL/SQL, Oracle utilities like SQL Loader, Shell Scripting, awk scripting & Unix Utilities
• Extensive experience in Dimensional Data Modeling & Application Modeling (OLTP Applications) using. Working experience for building Enterprise Data Warehouse Solution.
• Extensive experience in DW toolsets like ETL Tool: Informatica, Oracle Warehouse Builder, Business Intelligent: Business Objects Reports, BO Designer (OLAP), BO Dashboard Manager, BO Supervisor, Web-Intelligent, Business Objects Broad Cast Agent (BCA).
• Extensive experience in performance tuning (SQL, PL/SQL) using oracle Explain Plan, SQL Trace, TKProof, Toad, Oracle hints etc., features
• Strong proficiency in Microsoft Office including Excel, PowerPoint, Outlook, and Word
• Received Awards like Employee of the month and Pat on the Back and many peer recognition awards.
• Highly organized enthusiastic and motivated team player with leadership skills
• Well-developed communication and interpersonal skills
• Skillful at fast track learning and adopting new technologies

TECHNICAL SKILLS:

Operating Systems: Win 95, Windows NT 4, UNIX Solaris, Novell NetWare 4.11

Data warehouse Tools: ETL Tool (PL/SQL & UNIX Based), Business Objects (OLAP), Informatica 6.2/ 7.1, SAS9.1.3

Data Modelling Tools: ERWin, Power Designer 11, Designer 2000

ERP: MK (Manufacturing Knowledge) TOOLS (Module: Manufacturing)Oracle Applications (Modules: General Ledger, Receivables, Order Entry, Application Object Library)

Database Mgmt System: Netezza 2.4.2/7.0/7.0.4, SQL Server 7.0, Oracle 9i, 8i, 8.0, 7.3, Teradata

DB Tools: TOAD 7.1.7, Smart Term 9.0, MS Access, Vagum DB

GUI: VB 6.0, Crystal Reports

Languages: C, Pascal 7.0, COBOL, C++ (OOPs), HTML, PL/SQL

Editors: Vi, PL/SQL Editor, Toad Editor

QUALITY: Six Sigma (DMAIC Track), SEI CMM 5

PROFESSIONAL EXPERIENCE:

Confidential, Plano, TX

Sr. Netezza Database Administrator

Responsibilities:

• Have supported the NPS twinfin and striper servers for end to end solutions
• Have used nzbackup and nzrestore to backup and restored the big databases from one server to another server during the migration.
• Have extensively used nzsession, nzsystem, nz skew, nzstats and nz health utilities to monitoring the skew and distribution of all tables, NPS server issue for better performance
• Have established security LDAP authentication, users and groups
• Have used nz migrate, nzload to load and unload the data from text files and other databases
• Have renamed the old sever with new name used nzstop, nzstart to restart the NPS and have done manual vacuum using nz manual vacuum
• Have configured history database to collect all column and table level history info.
• Have created databases and designed the database objects with appropriate parameters
• Have upgraded NPS 7.1.0.4 to 7.2.0.1
• Have coordinated with NZ support to resolve many other issues, disk replacements and hardware components replacement.
• Have written shell scripts to automate ETL jobs, nz process related jobs, groom, genstats etc
• Have monitored the performance issues, database usage, hardware components SPUs, SPA, Disks and raise PMRs with IBM NZ support to resolve the issues and upgrades.
• Have installed setup SQL extensions and INZA on the Netezza performance server.

Environment: Netezza 7.2.0.1 (Twinfin-12 and Striper), Aginity, NZSQL, NZPLSQL, Redhat Linux

Confidential, Plano, TX

Sr. Netezza Database Administrator

Responsibilities:

• Have to install, maintain and tune Netezza Database
• Have been performing Daily database backup activities using nzbackup and nzrestore utilities
• Monitoring the disk utilization and checking for hardware issues
• Identifying performance issues and monitor the data loads
• Have extensively used nzsession, nzsystem, nz skew, nzstats and nz health utilities to monitoring the skew and distribution of all tables, NPS server issue for better performance
• Provide database administration, performance tuning support, gathering statistics on regular basis.
• Maintain stability, improve uptime and coordinate with IBM for any patches and hardware issues
• Establish and develop new database maintenance scripts for SPA, SPU and hardware issues.
• Automate Netezza database management and monitoring application using crontab in linux
• Start and stop NPS server, database vacuum and catalog cleaning on and off
• Developing the procedures and shell scripts using NZLOAD, NZSQL, NZPLSQL to load and perform DML operations with the database analyzing and developing proper Distribution Keys and Zone maps to gain better performance
• Setup the history database to capture the all database activities and generate the report for system resource usage and prioritize the tasks.

Environment: Netezza 7.01 (TF-12), Aginity, Oracle 11g, NZSQL, NZPLSQL, Redhat Linux, MS-Visio

Confidential, Irving, TX

Sr. Netezza Database developer/Admin

Responsibilities:

• Participate in the requirement gathering meeting with clients and define the scope & visibility options for new project
• Have prepared project review documents, test plans and change review documents.
• Have done the data profiling and cleansing and resolved the data quality issues as logic
• Extracted data from legacy sources DUNS, ABACUS, CORE and RENTAL and prepared the flat files.
• Have developed the ETL programs (using nzload, nzsql) in Netezza to load the data periodically into data warehouse.
• Have monitored the long running queries and tuned for better performance.
• Have completed the projects warranty, postal walk, reporting cube, model score current, site opt changes and DHS suppression modification
• Supported Netezza NPS with complete responsibility of administration including backup, tuning, maintaining, creating objects with proper distribution, managing SPUs, SPAs and statistics.
• Managing the physical and logical data structures and maintain the metadata
• Writing the shell scripts to automate the load processes that run periodically to load the data.
• Have written SQL scripts, functions and shells scripts to load the data from flat files.
• Developing the data flow diagrams and presenting them to business management.
• Track the requirement changes and estimate the development, testing and implementation efforts.
• Wrote and executed the SQL statement to validate the data with source.
• Prepare the report mockups and consolidated list of data elements, metrics in MS-excel and generate the charts to present to business.

Environment: Netezza 4.5.2, Oracle 10g, SQL, WinSQL, Unica, SAS, Redhat Linux, Erwin

Confidential, Plano, TX

DWH Data analyst/Informatica Analyst

Responsibilities:

• Setup the meetings and discuss the scope & visibility options for new critical audits.
• Understand Business requirement from business managers
• Business Requirements gathering with various business functional managers/analysts to understand the meaning of data and usage across enterprise
• Understand and identify master data across enterprise application to devise strategies for master data management with data cleansing methodologies and recommend importance of data steward ship.
• Data Naming and Meta data for entities and data elements in the data model
• Create data quality strategies for the enterprise data including data profiling and data cleansing.
• Initiated and documented data naming standards as a part of data governance at the enterprise.
• Determine standard data naming rules, logical and physical metadata for the data elements.
• Developed the mappings, maplets and workflows and used the transformations expression, joiner, lookup, union, update strategy, transaction control, router, normalizer transformations extensively.
• Approve ETL design for data movement from the source to target
• Monitor & reconcile the critical audits at the end of each month and present to business for sign off.
• Developed mappings, mapplets, sessions and workflows in informatica power center to support and load the data from System-X to System-XR.
• Scheduled the workflows, batches to load the data periodically i.e., daily, weekly and monthly.
• Developed complex transformations using aggregator, router, lookup, sorter and joiner transformations.
• Have done the data profiling and cleansing and resolved the data quality issues as logic
• Extracted data from legacy sources CARE, Telegence, Hyperion and ASPEN systems into BID DW
• Managing the physical and logical data structures and maintain the metadata
• Writing the shell scripts to automate the load processes that run periodically to load the data.
• Have written PL/SQL procedures, functions and shells scripts to load the data from flat files.
• Developing the data flow diagrams and presenting them to business management.
• Generate plans, tuning the procedures and functions and develop SQL Loader scripts for data load.
• Prepare the new plans, Audits and reports for the data quality program with solid documentation
• Track the requirement changes and estimate the development, testing and implementation efforts.
• Open the remedy tickets for any data issues and manage them appropriately.
• Wrote and executed the ETL scripts in teradata using MLoad, FLoad, bteq and Fast Export.
• Prepare the report mockups and consolidated list of data elements, metrics in MS-excel and generate the charts to present to business.

Environment: Oracle 10g, SQL, PL/SQL, Teradata, Informatica8.6, Business Objects, Sun Solaris, MS-Office, MS-Visio, ERwin

Confidential, Irving, TX

Informatica Analyst

Responsibilities:

• Fine tuned 100+ existing mappings and workflows to load the data efficiently and without any issues.
• Have created ETL jobs, Informatica mappings, workflows, sessions for Venture Delinquency process to retrieve data from production.
• Have used the transformations expression, source qualifier, update strategy, router, rank, stored procedure, union, lookup, transaction control transformation.
• Have used expression, aggregator, router and update strategy, transaction control transformations to for ETL jobs and capture the changed data with Update strategy transformation from mapping logic.
• Have extracted and loaded the data from SQL Server, Oracle and flat files into Data Warehouse.
• Involved in data modeling for any changes to existing tables and for creating new database objects.
• Have created mortgage reports from SAS environment in Word, PDF format for key business users.
• Have tested and executed the ETL jobs in test and moved them into production.
• Have Maintained, modified and created SAS production and adhoc programs

Environment: MS-SQL Server 2005, Oracle, SAS 9.2, Informatica8.6, MS-Office, Erwin

Confidential, Salt Lake City, UT

DWH Architect/Business analyst

Responsibilities:

• Organize the meetings and discuss the scope & visibility options to be integrated in Agent Desktop.
• Gathering the requirement from business users and Provide Strategic direction on critical issues
• Collecting the existing reports and future requirement for all phases of Agent Desktop and plan to
• Re-produce the reports from presentation/Integration layer of the IMD DW.
• Understand the reports functionality of trust and safety, Work force management, Satisfaction, Availability and prepare the report mockups. Retrieve the reports from Business objects and micro strategy tool and compare and develop the Mapping to help the developers to create them
• Writing design specifications for the ETL process
• Developing the mappings, transformation logic to load data from source to target
• Track the requirement changes and estimate the development, testing and implementation efforts.
• Validate the data in Excel and generate pivot tables and using analytical functions in MS-Excel.
• Identified the data quality issues and have done data cleansing and collected the data statistics.
• Write and execute the SQL statements to validate the data with source teradata and Oracle.
• Prepare the report mockups and consolidated list of data elements, metrics in MS-excel and generate the charts to present to business.

Environment: Oracle 9i, SQL, Teradata, Business objects, Micro strategy, MS-Visio, ERwin

Confidential - Minneapolis, MN

DWH Architect/ Data Modeler

Responsibilities:

• Preparing review documents for functional and technical reviews for the integration project.
• Database modeling using Erwin tool and create dataflow diagrams for presentation to user community.
• Preparing Business Requirements Document BRD and project requirement Document (PRD)
• Have planned and coordinated all data conversion, migration activities including defining the dimension attributes and facts.
• Developing transformation rules and business logic to load data from source to target
• Developing workflows and worklets, Extracting the data from Legacy system for reports
• Design the Data Warehouse Architecture and Plan for Data Marts
• Design Business Dimensional Model, logical Model and Physical Design
• Writing design specifications for the ETL process, data profiling, cleansing and data quality issues.
• Documenting the transformation logic changes for ETL/Informatica processes.
• Define the Data Sourcing Strategy and develop the mappings for data load
• Define Data Transformation Rules and build Business Intelligence Environment

Environment: SunSolaris5.8, Erwin, Toad, Oracle 10g, SQL, PL/SQL, Appworx, Business Objects 6.5/XI, Informatica 7.1.3, Power Center

Confidential, Minneapolis, MN

Data warehouse consultant

Responsibilities:

• Preparing Business Requirements Document
• Preparing Key metrics, definitions, calculations and metadata
• Design the Data Warehouse Architecture and Plan for Data Mart
• Understanding the existing normalized OLTP database, design DW using the OLTP database
• Design Business Dimensional Model, Star Schema Model and Physical Design
• Prepare Data Acquisition, Preparation and Loading Plan
• Created database packages, procedures and functions to load the data into data warehouse.
• Used DTS and other SSIS services to import and export the data among source systems.
• Compile OWB generated code in Oracle 10g database.
• Moving changes into prod and schedule them using shell scripts.
• Define Data Transformation Business Rules and build Business Intelligence Environment
• Involved data profiling and data cleansing process for good quality of data
• Building the gateways to access the different database objects from Oracle10g.

Environment: Oracle10g, MS-SQL server 2005, Oracle Warehouse Builder, Oracle Discoverer, Cygwin, Toad, Erwin, HP UNIX

Confidential, Plainville, CT

DHW Tech Lead/Architect

Responsibilities:

• Involved in universe design and ETL Process design using the Informatica
• Developed Informatica mappings, workflows. Tested and implemented them in production.
• Coordinated among the team members to get the AHDs and ITRs done within the given timeframe
• Assigned and tracked the status of tasks from individual members.
• Reviewed data model changes and involved in all database design activities.
• Apart from project maintenance, have taken certain tasks and completed the impact analysis for financial upgrade and Sales data model changes.
• Involved in Knowledge transition from Mind Tree consultants along with Polaris and successfully grabbed all process details
• Developed BO reports according to the user requirement.
• BO administration, creating users, providing access and developing new universes
• Raised ITRs for change control process and coordinated to implemented
• Interacted with key users to get the requirement and involved in analysis and design phase.
• Environment: Informatica 7.1.2, Power Center, Appworx5, Business Objects 6.5, SunSolaris5.8, Erwin, Toad, Oracle 9i

Confidential,

DHW Architect /Data Modeler

Responsibilities:

• Involved in Requirement gathering, Analysis & design of each IT work request
• Design and developed physical and Logical data models using Erwin
• Developed Sales: CHS Parts universe for internal customer
• Changes to BO universes as per the user requirement. Tested and implemented in production.
• Have developed the ETL load processes using Informatica. Workflows, mappings developed, tested and implemented in production. Some jobs got scheduled on maestro and some of them on Informatica using informatica scheduler.
• Coordinate with Mainframe COBOL team and get the required data in flat file format and developed the mapping using normalizer transformation to normalize and load the data into Data warehouse.
• Execute the JCL jobs in COBOL mainframe environment if the data extract job failed
• BO administration, creating users, providing access and developing new universes
• Maintained users, passwords and folders in informatica
• Worked on 12 MITRs and developed, tested and implemented in production without any issues those involves informatica changes, BO universe and report changes and schedule changes.
• Environment: Oracle9i, SQL PLUS, Sunsolaris5.8, Maestro, Business Objects 6.5, Informatica 6.1, Toad, ERwin

Confidential,

Systems Analyst

Responsibilities:

• Gathering requirement from application owners and prepare the retention policy. data profiling and data cleansing and identified the data that is no longer in use
• Discussed with functional team and identified application owners and time to retain the data.
• Design and develop the mappings and workflows to purge the data and schedule on Informatica scheduler to run every month so that the consistent years of data exist at any point of time.
• Testing the Business Objects reports performance and preparing other methods to improve.
• Prepared the change control process and get the approvals from the tech lead and functional leads
• Administering the MYIT requests logged through the MYITR tool.
• Making work delegation among the team members
• Environment: Oracle9i, Informatica 6.2, UNIX, Business Objects6.1, Toad, VegumDB

Confidential,

Systems Analyst

Responsibilities:

• Have involved in the data modeling, database design to convert all existing MARSII data into Oracle using Erwin and ETL utilities PL/SQL, SQL* Loader and other utilities & tools.
• Have developed ETL programs to load the data from legacy systems into Oracle database using Oracle PL/SQL, SQL Loader, merge, external tables and other utilities.
• Develop reports in Business Objects and automat them in BCA server.
• Have created detailed design document and accommodated changes to improve the existing database.
• Maintaining separate user accounts for MARII user community in BO.
• Go thought the entire existing system and identified and eliminated unnecessary feeds from DW and saved disk space in production server.
• Reduce redundancy while coding, by implementing the generic package to load small dimension tables.
• Reviewed six ETL tools including External tables, SQL Loader, ACTA, ETL procedure, Non-ETL procedure and Generic Load processes
• Change Management Process (CMP) and receive approvals from the tech lead and functional leads
• Making changes to star schema data model to accommodate the new changes
• Have done reverse engineering to extract existing database model to find out proper indexing methods.
• Environment: Oracle9i, Unix, Crontab, Business Objects 5.1, Erwin, SQL, PL/SQL.

Confidential,

Sr. Software engineer

Responsibilities:

• Have installed the Business Objects on my machine to get the reports done
• Have designed the database and prepared the appropriate data model (Star Schema) and developed the model using Erwin Tools.
• Have developed the Business Objects reports and automated them on BCA server.
• Have prepared logical and physical data models for new changes
• Have prepared for storage plan for the FCCDD application data.
• Prepared and Implemented the star schema model
• Have done data analysis and involved in data profiling and data cleansing process for better quality data
• Have developed the mappings and workflows in informatica and automated the load process in Maestro.
• Have loaded the 3 years data and reconciled. Made manual adjustments and provided the users with detailed level information.
• Have tested the lad process and gone through the Change Management control.
• Completed Six Sigma Corporate (DMAIC) exam and working on GB project.

Environment: Oracle9i, Informatica 6.2, Mastraeo, Unix, Business Objects 5.1, Erwin, SAS, MS Office

Confidential, Fort Wayne

Sr. Software engineer

Responsibilities:

• Have under gone through the Knowledge transition from TCS contractor and taken over the critical jobs in the data warehouse.
• Have monitored all daily, weekly, monthly and quarterly jobs in the Data warehouse and resolved the production issues efficiently.
• Database maintenance and production support for all 1Stop applications.
• Develop complex PL/SQL procedures and implement complex business transformation rules.
• Have Converted RRC (CASC) non-ETL procedures to ETL standard and made process more effective.
• Have supported 1STOP & OSB production system for a year. And given smooth knowledge transition to others and trained them in all 1STOP & OSB jobs.
• Wrote archive (shell) scripts to archive most critical tables in 1STOP warehouse.
• Have converted Backlog Non ETL job to ETL process and improved the performance. The process failure chances were reduced. Earlier it had many performance and data issues. Now it is more reliable.
• Enhance decision support system performance and uptime.
• Have resolved Data warehouse performance related issues and improved the performance.

Environment: Oracle 8.1.7, SQL*Plus, PL/SQL, SQL, Toad, Sun Solaris 5.7.