SUMMARY:

• Over 9 years of software experience in Data warehousing, RDBMS systems, and client server application design, development, implementation, upgrade and maintenance.
• Extensive Experience in Extraction, Transformation, Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center Tools.
• Involved in full life cycle development of building a Data Warehouse.
• Good knowledge on Informatica architecture such as Server Components ( Repository Server and Informatica Server) and Client Components (Workflow Designer, Workflow Manager, Workflow Monitor, Repository Manager).
• Written several UNIX Korn Shell Scripts for batch processing.
• Highly skilled in writing, testing and execution of the stored procedures, functions, triggers, views at the level of database by using SQL,PL/SQL for Oracle 9i/10G and SQL Server 2005,2008.
• Experience in UNIX shell Scripting & Batch Processing, job scheduling, communicating with server.
• Working knowledge on different data sources ranging from flat files, excel, oracle, SQL Server, DB2 databases, XML, XSL files.
• Experience in implementing update strategies, incremental loads and data capture.
• Experience in developing slowly changing dimensions.
• Performed data cleaning and data manipulation activities using NZSQL utility.
• Handled data loading operations from flat files to tables using NZLOAD utility.
• Extensively used NZSQL and NZLOAD utilities.
• Created SQL scripts for building the Data Warehouse Schema for various subject areas including tables, indexes, transaction tables, sequences, synonyms, grants etc.
• Strong leadership, excellent communication, analytical, design and development skills with customers, end users and colleagues.
• Excellent knowledge and experience in Technical Design and Documentation.
• Extensive design and development of transformations: Expression, Router, Filter, Normalizer, Lookup, Sequence Generator, Joiner, Update Strategy and Union.
• Strong leadership, excellent communication, analytical, design and development skills with customers, end users and colleagues.
• Good experience in interacting with business partners to identify information needs and business requirements.

TECHNICAL SKILLS:

Operating Systems: UNIX (Solaris, HP - UX, IBM-AIX), Windows XP/2000/NT/98/95.

Databases: Oracle 10g/9i, DB2, Netezza, Teradata, MS Access, and MS SQL Server 2008/2005.

ETL Tools: Informatica Power Center5.x/6.x/7.x/8.x/9,NetProphet 2.5.0/2.5.1

Languages: SQL, PL/SQL, HTML, Shell Scripting.

Technologies: XML, XSL, ODBC, UML and HTML.

Data Modeling Tools: Erwin 7.2/4.1.2/3.5

PROFESSIONAL EXPERIENCE:

Confidential, O’fallon, Missouri

Netezza DBA

Responsibilities:

• Create new groups,users and provide necessary Grant/Revoke privileges to groups based on the application requirement.
• Worked on optimizing and tuning the Netezza SQLs to improve the performance of batch cycles and various application reports.
• Experience in Netezza work load management - prepare the monthly resource usage metrics and review the workload sestina by resource groups and modify the resource allocation accordingly.
• Implement the changes that includes database,tables,views,synonyms creation and monitor the query performance after changes implementation.
• Experience in working with GSM,Remedy and ITSM ticket systems and create the new requests if required.
• Monitor the netezza system health by using nzhealthcheck,nzhw,crm mon,nzds utilities and create service request with IBM in case of hardware failure and replace the accordingly.
• Create full and incremental backups of user databases and the system catalog to ensure that the NPS systems can be restored.
• Schedule regular backups to allow for data recovery to protect against loss of data following events such as disaster recovery,hardware failure,accidental data loss, or incorrect changes to existing databases.
• Schedule the jobs to take backup, restore,generate stats,grooms,nzmigrate etc. using CRONTAB scheduler.
• Netezza servers patch management: Responsible for NPS patch upgrade, RHEL PDA OS patch upgrade,FDT and HPF upgrades.
• Check the pg logs, dbos logs,sysmgr logs,eventmgr logs etc. to troubleshoot the errors related to systems and application queries.
• Capacity planning in order to meet the data volume increase, extensive analysis to list down the unused columns and/or tables to reclaim the space.
• Proofs of concept on IBM Netezza Platform Development Software (INPDS) and migration from Twin fin to INPDS in dev environment.
• Performed Data warehouse consolidation activities which includes Migration from Twinfin to Mako appliance - appliance install, Security tools installation,sudo setup,users&groups migration,objects migration,data migration,LDAP configuration,INZA installation,SQL toolkit installation,QueryHist database configuration etc.
• Roadmap for Sailfish (IIAS: M S) POC, it majorly includes compatibility check, Network design, use cases preparation, data migration from Mako to Sailfish using db migrate.

Environment: NPS 7.2.1.5 (TF6, TF12,TF120,Mako 8 rack), WinSQL,Aginity Work bench, Oracle 11g, Toad, PUTTY,GSM Ticket management,Remedy ticket system, INPDS,Sailfish (IIAS M S),Cloudera Hadoop

Confidential, Charlotte

Netezza DBA

Responsibilities:

• Involved in full SDLC from gathering requirements, analysis, design, modeling, development, testing and implementation needed for loading and updating the warehouse.
• Creating new objects from data models, altering, dropping physical database table, external tables, views, materialized views.
• Reclaim the disk space from deleted rows using nz groom utility.
• Performed data cleaning and data manipulation activities using NZSQL utility.
• Handled data loading operations from flat files to tables using NZLOAD utility.
• Extensively used NZSQL and NZLOAD utilities.
• Worked on query history database configuration to capture the user queries, column level access detail,plans and also worked sql toolkit and INZA installation to enable the analytical functions.
• Enable the nzevents to monitor the system events like run away queries, disk issues, S-blade issues, SPU cores, filesystem size monitor,MM failures.
• Monitor the nzhealthcheck output on daily basis and work towards resolve the reported issues.
• Worked on PCI for Netezza Platform, Preparation of checklist for weekly Audit,user accounts auditing and splunk/guardium installation for database log monitoring.
• Experience in NPS,HPF,FDT upgrade and PDA OS patch on quarterly basis.
• Converted Oracle stored procedures to Netezza Equivalent procedures.
• Extensively used Aginity Netezza work bench to perform various DML, DDL...etc. operations on Netezza database.
• Strong knowledge in Kimball and Inmon methodology and models, Dimensional modeling using Star schema and Snowflake schema.
• Loading/Unloading tables using nzload and nzunload which internally uses external table concepts
• Migrating databases from one host to another host using nz migrate utility.
• Tuning the queries to improve performance of SQL using nz plan utility and if possible to use proper optimizer parameters.
• Use NZ Admin tool to check the hardware issues as well as data skew, stats, backup, database size, etc. as it is a GUI tool.
• Performed extensive Unit Testing and System Integration Testing on the developed Mappings and also involved in the documentation of Test Plans and testing with the users (UAT).
• Involved in the preparation of Best Practices documentation.
• Creating Release manuals (RM) to move the code from QA to production.
• Used Netezza groom to reclaim the space for tables, databases.
• Extensively managed the data skew all the Netezza database tables.
• Involved in UAT support to resolve the issues encountered during the catch up loads and regular data loads.
• Tracking tasks for their timely completion.
• Reporting status to the client on a daily basis.

Environment: NPS 7.2.0.6 (TF6, TF12,TF96,Mako 4 Rack etc), Aginity Work bench 4.1, Oracle 11g, Toad, PUTTY,, INPDS.

Confidential, Bellevue, WA

Netezza/Teradata DBA

Responsibilities

• Monitoring health of TF120, TF96 appliances and working with IBM if any issues related to Hardware.
• Alter tables to change distribution column to improve the performance of user queries.
• Loading data in to Netezza tables using external table process with NetProphet ETL.
• Populating Dimensional and Fact tables from staging tables by using Unification concept
• Migrating databases from one host to another by using nz migrate.
• Enhanced existing processes to run more efficiently and faster by working on factors like PPI, Skew, Joins, workload management etc.
• Created scripts using FastLoad,Multi-Load to load data into Teradata .
• Performed Teradata DBA tasks using Teradata Manager such as workload activity, space utilization, statistics collection, and system performance monitoring.
• Experience in using Teradata Manager & Teradata Administrator to Monitor and Manage Teradata Database.
• Monitoring of production systems comprises monitoring of production database and server and lower environments. Database monitoring includes monitoring of database resources, high cost queries, resource allocation.
• Structure tables in Netezza to get collocations during query executions, make use of stats, zone maps, materialized views, optimizer performance parameters, CBT and groom for optimal performance.
• Create new users, groups and Granting privileges based on the application requirement.
• Worked on DBA tasks like User creation, security, database creation, Primary/Secondary indexes and Scheduling/maintenance of jobs.
• Change the priority of the jobs/transactions if needed.
• Monitoring catalog size and performing manual vacuum while appliance is down.
• Monitor long running queries, sessions and abort the process/threads if needed using NZSESSION and Admin tool.
• STOP and START the Netezza appliances in case of issues.
• Clean up Tables and groom to reclaim space.
• Use Admin tool to check the hardware issues as well as data skew, stats, backup, database size, etc. as it is a GUI tool.
• Experienced in Creating tables, complex views, stored procedures, backup and recovering data.
• Configured New NetProphet windows servers and pointed those to FTP
• Upgrade NetProphet client version from 2.5.0 to 2.5.1
• Involved in JIRA service desk ticketing system.
• Tuning of development team queries by analyzing the plan files.
• Involved in ETL migration from NetProphet to Pentaho PDI/BI
• Actively involved in TF120 FDT (2.6 to 4.1.1.1) and RHEL (5.5 to 5.8) firmware Upgrade.

Environment: NPS 7.0.2.1 -P1 (TF120, TF96),Teradata,NetProphet 2.5.0/2.5.1 , SQL Server 2008, Windows 8, ControlM,Aginity Netezza Workbench V 4.4.

Confidential

ETL Developer

Responsibilities:

• Extensive design and development of transformations; Normalizer, Lookup, Aggregator, Expression, Sequence Generator, Router, Filter, Joiner, Update strategy and Union.
• Design and development of re-usable mappings, and mapping specifications.
• Designed a database for implementing data loading in the Staging areas.
• Performed transfer of data from various data sources like SQL Server, Oracle, and Flat Files etc. into Staging areas.
• Prepared specification documents for different mappings between Source Systems and Data Warehouse.
• Loading of data from various resources like Oracle, SQL server, Flat Files into a single Data Warehouse.
• Using NZLOAD, data loading operations from flat files to tables are handled.
• Involved in creating sessions, worklets and workflows for carrying out test loads.
• Implemented SCD-1 and SCD-II to update dimensional schema.
• Developed unit test plans to ensure that all results are correct.
• Involved in the preparation of technical specifications documentation.
• Debugged the mappings if it had any failed sessions.
• Involved in Performance tuning at source, target, mappings, sessions, and system levels.
• Creating new objects from data models / altering/ dropping physical database/ table/ external table/ views/ materialized views objects.
• Loading/Unloading tables using external table concepts also using the files.
• Check the pg logs, dbos logs, etc. with respective to error the application faced.
• Migrating databases from one host to another.
• Tuning the queries to improve performance of SQL using EXPLAIN. Also analyze the cost of the SQL.
• Use NZ Admin tool to check the hardware issues as well as data skew, stats, backup, database size, etc. as it is a GUI tool.
• Used NZSQL for data cleansing and data manipulation activities.
• Several Netezza SQL scripts are written to load data into Netezza tables.
• Played a vital role in handling the analysis, designing and coding of the database.

Confidential

Database Developer

Responsibilities:

• Created database objects including tables, indexes, clusters, sequence roles and object views.
• Designed and implemented the entire database system using E-R Diagrams.
• Developed complex stored procedures, packages, triggers.
• Loading data into database tables from flat files.
• Preparing several reports based on the Client requirement by writing SQL queries.
• Created users and established the application security by creating roles.
• Involved in SQL Tuning of PL/SQL modules.
• Designed and developed validation procedures for query and update of data.
• Implemented shell scripts for scheduling batch jobs, diagnostics.

Environment: Windows NT 4.0/2000, Oracle, PL/SQL, SQL Plus, Shell Scripting