SUMMARY:

• Chandra 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
• 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

PROFESSIONAL EXPERIENCE:

Confidential, TX

Sr. Netezza Database Administrator

• 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, TX

Netezza Database Administrator

• 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, TX

Sr. Netezza Database developer/Admin

• 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, TX

DWH Data analyst/Informatica Analyst

• 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, TX

Informatica Analyst

• 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