SUMMARY

Data Warehouse: , Mutual Fund, Credit/Debit Cards, POS, ATM, EDC, Payment Gateway. 14+ years of broad experience with clients including Confidential, BNPP, Confidential, Confidential, Merrill Lynch/Bank of America and Citibank. Excellent leadership and delivery track record in onshore/offshore model. Strong problem solving, team building and negotiation skills. Skills

Programming Languages: Java 7, C, C++, Pro*C, PL/SQL

Scala Big Data: Apache Spark, HDFS, Sqoop, Hive, Pig, MapReduce, HBASE, Cloudera, Kafka

Scripting Language: Python, Perl/Shell/AWK Scripts, JavaScriptFrameworks Spring 4.2.0

RDBMS: Oracle, Sybase, Teradata, Netezza, MS SQL ServerWeb

Technologies: JSP, JSTL, HTML, XMLDevelopment Tool Eclipse, Mave

Other Tools: TFS, Serena Dimension, PVCS, SVN, Informatica, Syncsort, AutoSys, Sybase PowerAMC, Ultra edit, Oracle SQL Developer, PL/SQL Developer, Visio, MS Project Plan, Delphi, ISO - 8583 Messaging Certification

PROFESSIONAL EXPERIENCE

Project Lead

Confidential

Responsibilities:

• Lead a team of engineers in design, develop and testing the financial data consistency on security and bond details across various platform.
• Designed, developed data mismatch report in REST API’s using Java Spring and deployed in the Tomcat server.
• Designed and created Hive tables and populated them with Oracle table’s data using sqoop.
• Coordinated with the downstream applications and reporting applications to retrieve the data from Hive tables.
• Generated adhoc reports using Python Spark from the Hadoop File System.
• Strategized in automating the dynamic generation of SQL*Loader control files to minimize the development time.
• Strategized in automating the post production reconciling process.
• Managed meeting with teams spread across globally to strategies business/technical solutions to minimize the reconciliation anomaly.
• Managed resource estimation, time line, code quality and metrics, collaborated with cross team managers/engineers and successfully negotiated deliverables and schedules.
• Managed weekly call with onshore team to discuss on the development progress.
• Researching and exploring the machine learning technology to leverage the business demand.
• Created effective communication plan and RACI chart to streamline the process.
• Suggested on technologies for cost effective delivery and application demand.
• Acted as BCP member to support the application during natural calamity.
• Supported the management in CMMI certification success.

Associate Consultant

Confidential, USA

Responsibilities:

• Designed/Architect Big Data solution to analyze employee chat transcript and synthesize technology requirements.
• Developed scripts to transfer chat log data to HDFS.
• Developed MapReduce jobs in Java to mine the data for business need.
• Created customized Hive tables and loaded Oracle data using Sqoop.
• Generated merchant type wise reports from Hive tables.
• Generated Spark python script to mine the chat transcript.
• Generated Pig script to transform and generated adhoc reports.
• Processed large sets of structured, unstructured data and supporting systems application architecture.
• Having good knowledge in HBase NoSQL database and Kafka stream processing platform.
• Researched, analyzed Sybase to Oracle migration tools and narrowed to Oracle SQL Developer.
• Created workaround handbook for handling Sybase features on variables case sensitivity, temporary tables, object type conversion.
• Led a team of engineers, identified, resolved issues in meeting the project objectives.

Hadoop, Cloudera

Confidential

Responsibilities:

• Created design and developed for the financial feeds, Credit risk calculating engines and generating credit risk reports.
• Credit risk report for specific customers are generated and email sent to an internal distribution list.
• Created process flow and application understanding documents.
• Reduced the dependency on development components by splitting into multiple components.
• Suggested/Optimized the performance of database queries and PL/SQL.
• Managed quality compliance by reviewing estimation, design, and development of the team members.
• Managed defects that were in warranty period to make the application business compliance.
• Managed the team in client walk through meeting for the new enhancements.
• Conducted application knowledge sharing session to the team.
• Ensured team compliance with the project key performance indicator.
• Loaded Teradata tables with Fastload utilities scripts and benchmarked on the query performace.
• Managed project plan for multiple projects in Microsoft Excel.
• Managed reiterating the project plan for the agreed changes in the Microsoft Excel.
• Prepared the detail and summarized project progress report in Microsoft Excel
• Organized and facilitated project steering committee weekly calls with clients to discuss development progress, prioritize and compliance with the business expectations.
• Managed scheduling, resource allocation, project execution and QA review.
• Managed the project milestone, risk, issue and dependency.

Agile Project Management

Confidential

Responsibilities:

• Expanded the team size to increase the project profit.
• Created, maintained application understanding documents in English.
• Suggested product owners on Agile in place of waterfall.
• Groomed the team for the transition from T&M to fixed cost model.
• Innovation team member spreading importance on being innovative across the Organisation.
• Conducting technology learning session across the Organisation.

Module Leader

Confidential

Responsibilities:

• Designed and developed for the Confidential clearing Data Warehouse application.
• Merchant wise sales performance reports are generated and circulated to the business analysts.
• Created and managed the application System Maintenance Technical document.
• Conducted application knowledge sharing session to the team members.
• Automated database objects modification verifications with shell scripts and PL/SQL procedures.
• Performed secondary application support for the production support team.
• Strategized, prepared and shared performance report to client on Netezza and Oracle databases.
• Estimated Oracle database space requirement for storing historical data.

Data Warehouse

Confidential

Responsibilities:

• Created System Maintenance Technical document to minimise the resources productive time.
• Mentoring junior engineers across the organisation.
• Conducting technology learning session across the Organisation.Estimated, designed and developed for loading and calculating CUSIP, SEDOL and Mutual Fund financial details batch process.
• Prepared strategic plan for optimizing the applications in Java.
• Optimized the application performance with multiple process and threading techniques in Java.
• Created, supported and maintained the production AutoSys batch jobs.
• Modified and tested Citibank card routing interface application for the business changes.
• Supported and maintained the production online financial transaction jobs.
• Coordinated with different merchants to integrate their application with Payment Gateway.
• Supported EDC machine testing certification.
• Managed junior engineers and the application support team