SUMMARY:

• Highly adaptable and experienced D Confidential base Engineer, D Confidential enthusiast with a proven track record of high client satisfaction. Expertise on Big D Confidential, D Confidential 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 D Confidential Analytics, D Confidential Analysis, D Confidential Quality (DQ), Performance Tuning, D Confidential warehousing, D Confidential Modeling and ETL (Informatica Power Center). D Confidential base SME and Certified in Netezza and Oracle.
• Expertise on Hadoop, Netezza and Oracle d Confidential base.
• Certified d Confidential base professional ( Confidential Netezza and Oracle D Confidential base ).
• 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, D Confidential Modeling, ETL process and D Confidential Quality.
• Experienced to build authorized d Confidential source on Netezza & Hadoop.
• Experienced to build D Confidential Quality (DQ) rules framework on various d Confidential base 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.
• D Confidential base 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. ed by R Systems International for the Outstanding Performance (Extra Miler ). ed two times by Confidential as ‘Employee of the Month’. ed by Synecrhon as “Surpass” for the outstanding performance (Surpass ).
• Nominated by Confidential by its prestigious “Syne-Oscar” for annual performance.

TECHNICAL SKILLS:

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

OLAP / MPP D Confidential base: Netezza: NZSQL, NZPL-SQL, NZLOAD, NZMIGRATION, NZDUMPSCHEMA, NPS, Netezza-ADMIN

Terad Confidential Terad Confidential 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, Consultant

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

Responsibilities:

• Lead and key developer of Wholesale ADS (Authorized D Confidential Source) on Netezza and Hadoop
• Involved and leading entire D Confidential base migration project from Terad Confidential legacy system.
• Able to develop seamless d Confidential warehousing application on Netezza.
• Able to migrate Netezza d Confidential 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 D Confidential Gap DQ monitoring framework for all BA groups.
• Deliver multiple batch processing d Confidential to various downstream with defined SLA.
• Able to create more than 20 d Confidential bases in Netezza and Hadoop using ADS.
• Able to develop transformation logic on Hadoop (Hive, Spark) and Netezza d Confidential base.
• D Confidential base design for Netezza and Hadoop (D Confidential 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 Terad Confidential D Confidential base design and designed new d Confidential base on Netezza and Hadoop which will have optimized outcome.
• Establish daily, monthly, hourly d Confidential loading and unloading activity for Netezza and Hadoop (NZLOAD, NZMIGRATE, Sqoop, Hive, Spark-Scala, Shell Scripting)
• Successfully Implemented D Confidential base related ELT and ETL process on AutoSys.
• Discuss and escalate Netezza related issue with Confidential 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 Confidential (Change D Confidential Capture) module on Hadoop and Netezza.
• Communication with all downstream and handling business issues as a lead point of contact person.
• Provide to other team members on existing d Confidential base process, d Confidential base programming, Technologies like Netezza and Hadoop.

Confidential, New York

Assistant Manager-Software

Responsibilities:

• Accept the report development request from various clients through JIRA system interface.
• Analyze the request and plan d Confidential modeling for raised report request.
• Use of Hadoop streaming to get the d Confidential by an hour to the system.
• Develop d Confidential quality framework before consuming the d Confidential into the actual Analytics d Confidential base.
• Extensive use of Sqoop to load the d Confidential from various file system and vendors to the system.
• Development of NZSQL script and Netezza d Confidential base for each report request (D Confidential 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 d Confidential to the Netezza d Confidential base.
• Design UI based report by analyzing user request and new analytical marketing terms.
• Integrating of NZSQL in UI application.
• Develop python script to generate d Confidential 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 d Confidential base.
• Escalation management of d Confidential base 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 d Confidential base and Oracle d Confidential base also.
• Provide organization level corporate on Netezza d Confidential base.
• 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 d Confidential base.
• Raise the Netezza issue to Confidential and fix the same with Confidential .
• Perform NZLOAD operation to load the high volume d Confidential from various sources to production d Confidential base
• Perform NZBACKUP to maintain d Confidential base backup
• Check and monitor d Confidential base health (Use of Generate statistics, GROOM etc.)

Confidential

Senior Software Engineer

Environment: Oracle 10g, Java, Confidential 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, Confidential WebSphere

Responsibilities:

• Developed Score Card (SB Card).
• Participated in DCB D Confidential extraction (intelligence d Confidential 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 d Confidential base and after replication of the records, deleted those records from temp tables.
• Replicated the main table records to NRM server (central/ remote d Confidential base 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 d Confidential base monitoring: Revalidated invalid objects, auto refresh of snapshots from remote d Confidential base, 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 d Confidential base for d Confidential security and recovery.
• Performed tasks associated with tuning of d Confidential base systems for performance and efficiency enhancements, reviewing the logs, available space, configuring the initialization parameters based on application requirements, and optimizing complex SQL queries.
• Responsible for minimizing downtimes on Risk Management System by ensuring the daily backups.