SUMMARY

• Highly adaptable and experienced Database Engineer, Data enthusiast with a proven track record of high client satisfaction.
• Expertise on Big Data, Data warehouse, RDBMS with 11 Years 4 Months of strong experience.
• Able to work with the team and manage the team with Offshore - Onshore model.
• Worked on all critical development tasks like Big Data Analytics, Data Analysis, Data Quality (DQ), Performance Tuning, Data warehousing, Data Modeling and ETL (Informatica Power Center). Database SME and Certified in Netezza and Oracle.
• Expertise on Hadoop, Netezza and Oracle database.
• Certified database professional (IBM Netezza Certification and Oracle Database certification).
• Strong hands on experience on Hadoop Eco System: HDFS, Hive, Impala, Sqoop, Spark-Scala.
• Strong hands on experience on NZSQL, NZPLSQL, SQL, PLSQL.
• Specialized in performance tuning task, Data Modeling, ETL process and Data Quality.
• Experienced to build authorized data source on Netezza & Hadoop.
• Experienced to build Data Quality (DQ) rules framework on various database systems.
• Experienced in Informatica Power Center (ETL )
• Strong working experience on multiple domains like Real Media, Insurance and Banking.
• Working experience with globally known clients as Confidential, Confidential, Xaxis, ABN AMRO, Standard Charted etc.
• Database architecture level understanding and development and performance tuning experience.
• A keen Analyst and Team Player with thorough understanding of all aspects of the SDLC from understanding client requirements through direct client interaction, translating them into technical specifications and driving their execution
• Have expertise and experience in all phases of project life cycle namely analysis, design, coding, testing, and implementation phases.
• Experience in working with an Agile process.
• Good team player as well as team lead; able to manage and work with Onsite-Offshore model.
• Able to manage and work with end users/business users with high satisfaction track record.
• Awarded by Confidential International for the Outstanding Performance (Extra Miler Award).
• Awarded two times by Confidential as ‘Employee of the Month’.
• Awarded by Synecrhon as “Surpass” for the outstanding performance (Surpass Award).
• Nominated by Confidential by its prestigious “Syne-Oscar” award for annual performance.

TECHNICAL SKILLS

Big Data Hadoop: HDFS, Hive, Impala, Sqoop, Spark with Scala, Kafka

OLAP / MPP Database Netezza: NZSQL, NZPL-SQL, NZLOAD, NZMIGRATION, NZDUMPSCHEMA, NPS, Netezza-ADMIN

Teradata: Teradata SQL and ETL

OLTP / RDBMS: Oracle 8,9i,10g,11g SQL,PL-SQL

ETL Tools: Informatica Power Center 9.x

Operating System: Unix-Linux, Windows

Scheduling Tools: AutoSys, Cron Jobs, Oozie.

Tools: NPS, Netezza Query Tool, Hue, PL/SQL Developer, TOAD, Oracle Enterprise Manager, SQL*Plus, Aginity

Scripting: Unix Shell Scripting, Python 2.6, C

PROFESSIONAL EXPERIENCE

Confidential, Charlotte, NC

Lead Database Consultant

Environment: Netezza TwinFin, Hadoop (Map-Reduce and SPARK ), SQL Server

Responsibilities:

• Lead and key developer of Wholesale ADS (Authorized Data Source) on Netezza and Hadoop
• Involved and leading entire Database migration project from Teradata legacy system.
• Able to develop seamless data warehousing application on Netezza.
• Able to migrate Netezza data warehousing application on Hadoop.
• Development of analytical report on Hadoop and Netezza.
• Development of DQ framework on Hadoop, Netezza on each hops of the system (Source to all downstream).
• Development of Federal related DQ and Financial reports i.e. CCAR, FRY-14 etc.
• Development of functional Data Gap DQ monitoring framework for all BA groups.
• Deliver multiple batch processing data to various downstream with defined SLA.
• Able to create more than 20 databases in Netezza and Hadoop using ADS.
• Able to develop transformation logic on Hadoop (Hive, Spark) and Netezza database.
• Database design for Netezza and Hadoop (Data Modelling).
• Decommissioning of existing ETL (Informatica and Talend) process and developed own ELT framework.
• Use of Hadoop streaming (Kafka) for sourcing to handle huge file inputs into the system.
• Studied existing Teradata Database design and designed new database on Netezza and Hadoop which will have optimized outcome.
• Establish daily, monthly, hourly data loading and unloading activity for Netezza and Hadoop (NZLOAD, NZMIGRATE, Sqoop, Hive, Spark-Scala, Shell Scripting)
• Successfully Implemented Database related ELT and ETL process on AutoSys.
• Discuss and escalate Netezza related issue with IBM and fix them ASAP.
• Work on new development as well as on TQMS bugs for fixes.
• Subject matter expert for Netezza Performance tuning issues.
• Provide support for Month End batch execution to streamline the production process.
• Successfully developed generic CDC (Change Data Capture) module on Hadoop and Netezza.
• Communication with all downstream and handling business issues as a lead point of contact person.
• Provide training to other team members on existing database process, database programming, Technologies like Netezza and Hadoop.

Confidential, New York

Assistant Manager-Software

Environment: Netezza Mustang, Netezza TwinFin, Oracle 11g, Hadoop, Informatica

Responsibilities:

• Accept the report development request from various clients through JIRA system interface.
• Analyze the request and plan data modeling for raised report request.
• Use of Hadoop streaming to get the data by an hour to the system.
• Develop data quality framework before consuming the data into the actual Analytics database.
• Extensive use of Sqoop to load the data from various file system and vendors to the system.
• Development of NZSQL script and Netezza database for each report request (Data Modeling).
• Development on Hive (Map-Reduce) and Impala for each report request.
• R&D activity on analytical report for development.
• Execution of report code, Verification and Delivery of the report.
• Performance tuning and developed the analytical report (MIS and DSS Report).
• Develop Informatica ETL jobs and workflow to get multiple source data to the Netezza database.
• Design UI based report by analyzing user request and new analytical marketing terms.
• Integrating of NZSQL in UI application.
• Develop python script to generate data file and integrate the same in Netezza and Hadoop (HDFS).
• Demonstration of new UI reports and features to business users.
• Testing and release management of UI reports.
• Development of Oracle object for new UI report (PL/SQL package and procedures).
• Concept launching of various reports using Netezza and analytical skill.
• Monitoring, managing and troubleshooting of Netezza database.
• Escalation management of database and daily process. Ensure daily delivery timings.
• Provide performance statistics to business user and apply performance tuning changes wherever possible.
• Groom team members and help them to develop new report using analytical functions.
• Trained the team members on Netezza database and Oracle database also.
• Provide organization level corporate training on Netezza database.
• Participate in Netezza migration (Netezza-Mustang to Netezza-TwinFin migration).
• Generate critical Audience segments and Retargeting reports.
• Single point of contact for USA and UK business users.
• Daily conference call with business users for new report requirement and development.
• Trained the business user for UI report (Application)
• Monitoring of SPA and SPU performance of Netezza database.
• Raise the Netezza issue to IBM and fix the same with IBM.
• Perform NZLOAD operation to load the high volume data from various sources to production database
• Perform NZBACKUP to maintain database backup
• Check and monitor database health (Use of Generate statistics, GROOM etc.)

Confidential

Senior Software Engineer

Environment: Oracle 10g, Java, IBM WebSphere

Responsibilities:

• Team Member of Change Request (CR) team.
• Interacted with all clients those who were using STG Billing System.
• Gathered requirement of raised change request.
• Participated in impact analysis of raised change request.
• Developed the change request.
• Performed Functional testing of developed change request.
• Performance tuned existing code.
• Responsible for documentation, maintenance, release, and configuration.

Confidential

System Analyst

Environment: Oracle 9i/ 10g, Java, IBM WebSphere

Responsibilities:

• Developed Score Card (SB Card).
• Participated in DCB Data extraction (intelligence data extraction).
• Performed MARCIS EOD, Batch processing, and functionality tuning.
• Developed various reports using PL/SQL and Crystal Reports in Banco and SB Card.
• Developed PeopleSoft General Ledger and various interfaces.
• Participated in performance tuning EOD process.
• Worked on End of Day (EOD) process.
• Developed workflow for the application flow.
• Developed extra module to integrate the core applications in Kotak, SB Card, and Fiji.
• Analyzed requirement for the proposed enhancement.
• Developed documentation to meet the standards.
• Responsible for analysis, development, maintenance, and implementation of various IT applications.
• Developed SQL and PL/SQL stored procedures.
• Selected as point of contact to provide technical support to value-added clients.
• Restructured SQL to improve query response time.
• Provided troubleshooting for clients, and ensured end-user information discrepancies resolved.
• Created and monitored jobs for automated record manipulation.
• Created scripts for table and index partitioning.
• Prepared and followed QMS document and QMS processes.
• Participated in pre-sales activity, RA, and FS.

Confidential

Consultant (Software Engineer)

Environment: Oracle 9i/ 10g, Java, Apache

Responsibilities:

• Developed PL/SQL stored procedures on request from central team and client.
• Replicated the records from temp table to main table within database and after replication of the records, deleted those records from temp tables.
• Replicated the main table records to NRM server (central/ remote database server).
• Calculated the NRM and LRM server (remote and local user) records and activities.
• Created scripts for index partitioning.
• Interacted with clients for issues related to the application change requests and requirements.
• Developed scripts to automate database monitoring: Revalidated invalid objects, auto refresh of snapshots from remote database, and auto deletion of archive logs.
• Created the Statspack report to study performance related issue.
• Monitored the session and troubleshooting using TOAD and OEM.
• Gathered statistics regularly.
• Created objects such as indexes or portioned table or IOT to increase the performance.
• Participated in logical backup of database for data security and recovery.
• Responsible for minimizing downtimes on Risk Management System by ensuring the daily backups.