OBJECTIVE:

• To pursue a career in Software development or any challenging IT projects where my hands - on experience can be utilised and, in the meantime, providing me the opportunity for further growth.

SUMMARY:

• Having experience in responsible of Project Management/Systems Analyst including analysis, design, architect, development, testing, implementation and production support of full life cycle commercial applications.
• Functional expertise including Banking domain, Capital Market, Credit Card, Data warehouse / Business Intelligence and Exchange Traded Derivative or Commodity technologies and also worked the projects like data migration and Quality processes across different databases.
• Worked as a Project Lead Confidential India PVT. LTD. From Feb 2016 to June 2018.
• Worked as Onsite coordinator/Support Lead with Confidential Canada LTD. From Feb 2012 to Jan 2016.
• Worked as an Application Support Lead with Confidential India Pvt. Ltd. From Dec 2010 to Feb 2012.
• Worked as a senior software Engineer with Confidential Technologies Ltd. from Jan 2010 to Dec 2010.
• Worked as Associate Consultant Oracle financial software services formerly (formerly I-flexSolutions Ltd.) Aug-2009 to Jan-2010.
• Worked as senior software Engineer with Confidential Software Ltd. from Apr 2007 to Aug 2007.

TECHNICAL SKILLS:

Databases: Oracle 11G/10g/9i/8i, MS-SQL Server-2000/2005, Sybase, DB2, MySQL, Netezza

Cloud: AWS

Operating System: Linux RHEL/Ubuntu/CentOS, Windows (XP/7/8, 10), OEL

Microsoft office: MS Excel, PowerPoint, MS-Access, MS-Word

Scripting Languages: Shell Script

Domain Skill: Banking domain, Credit Card, Data warehouse / BI and Exchange Traded Derivative or Commodity technologies.

CASE TOOLS: Toad, PL/SQL Developer, ERWIN, SQL Navigator, Query Analyser, Control M, AQT, Aginity, ServiceNow, Autosys, Putty, SFTP, FTP

Database: Oracle 11G/10g/9i/8i, MS-SQL Server-2000/2005, Sybase, DB2, MySQL, Netezza

Big Data Eco-system: MRv1, MRv2+YARN, HDFS, Map Reduce, Pig, Hive, Hbase, Sqoop, zookeeper, Ranger, Storm, Kafka, Oozie, flume, Hue, Knox

Network Security: Kerberos

Tools/ Utilities: JIRA, Splunk

Monitoring Tools: Cloudera Manager, Ambari, Nagios, Ganglia

OFSAA: BASEL,OFSAA 8.0, DataFoundationFSDFStaging, LLFP, UnifiedMetadataManager, DT,T2T, F2T,DQs, DEFI, RulesFramework, MetadataArchive/Restore,OFSAAConfiguration, AML, ALM and LRM.

Version Control Tools: MS Visual Source Safe, Share point, VSTS

Environments: Development, UA

PROFESSIONAL EXPERIENCE:

Confidential

Project Lead/Application Support Lead

Responsibilities:

• Involve in Data Analysis, Data Modeling, Data Cleansing, Transformation, Integration, Data import, Data export
• Develop Views, Store Procedures using DB2 SQL to populate the Basel III reporting tables. The Stored Procedures support both daily and historical data loading to the fact tables.
• Experience in using modeling tools such as Erwin and system specifications using UML, AML, ALM and LRM
• Lead the support team, Interaction with Clients to solve the gaps between technical and functional requirements.
• SQL migration
• Experienced as an application Developer/BI Analyst/Application support lead/ Project Management/ Production Support Manager and also involved in design, architect and implementation during the project cycles.
• Good exposure on time-management and proactive way of working during analysis
• Nice exposure on getting project requirement gatherings
• Worked on analyzing the technical/business requirements gathering for designing and developing the solutions and coordinated with UAT (User acceptance testing).
• Lead a team and pioneered engagement activities in Audit Innovation and took responsible for the planning, co-ordination, code review, detailed documentation and timeline negotiations at various stages of the projects.
• Developed and implemented the policies and procedures throughout the SDLC to maximize the efficiency, effectiveness and overall quality of product.
• Hands on experience in installing, configuring, and using Hadoop ecosystem components like Hadoop HDFS, Yarn, MapReduce, HBase, Oozie, Hive, Sqoop, Pig, Kerberos, Ranger, and Knox.
• Experience in deploying Hadoop cluster on Public and Private Cloud Environment like Cloudera, Hortonworks, Amazon AWS, and EC2.
• Setting up automated 24x7 monitoring and escalation infrastructure for Hadoop cluster using Ambari and Cloudera Manager.
• Experience in managing and reviewing Hadoop log files.
• Experience in setting up the High-Availability Hadoop Clusters.
• Ability to prepare documents including Technical Design, Testing strategy, and supporting documents.
• Hands on experience in installation, configuration, supporting and managing Hadoop Clusters using Cloudera (CDH3, CDH4), Yarn distributions (CDH 5.X), Hortonworks (HDP 2.3, HDP2.4)
• Hadoop Cluster capacity planning, performance tuning, cluster Monitoring, Troubleshooting.
• Experience on Commissioning, Decommissioning, Balancing, and Managing Nodes and tuning server for optimal performance of the cluster.
• As an admin involved in Cluster maintenance, trouble shooting, Monitoring and followed proper backup& Recovery strategies.
• Experience in HDFS data storage and support for running map-reduce jobs.
• Knowledge on Hbase and zookeeper.
• Experience in importing and exporting the data using Sqoop from HDFS to Relational Database systems/mainframe and vice-versa.
• Scheduling all Hadoop/hive/Sqoop/Hbase jobs using Oozie.
• Good experience in Rack awareness configuration.
• Setting Quota to Users on HDFS and assigning quota to database.
• Flexible with Unix/Linux and Windows Environments working with Operating Systems like Centos 5/6, Ubuntu 10/11 and Sun.
• Good exposure in UNIX utility like Putty, SFTP, FTP, Filezilla, and WinSCP & Oracle utility tool like Toad, PL SQL developer.
• Excellent communication and interpersonal skills with experience of functioning as morale owner of the team and a good team player.
• Collaborates well across technology groups & Teams.
• Interaction with on-shore audit team to gather audit requirements and be a part of the brain storming sessions to produce the scope documentation.
• Worked on identifying risk of fraud, involved in management override of Internal Controls to improve the effectiveness and efficiency in audit.
• Exposures in Incident/change/backlog management tool like ZenDesk, JIRA

Environment: Toad, PL/SQL Developer, ERWIN, SQL Navigator, Query Analyser, Control M, AQT, Aginity, ServiceNow, Autosys,Oracle 10g/9i/8i, MS-SQL Server-2000/2005, Sybase, DB2, MySQL, Netezza,MS Excel, PowerPoint, MS-Access, MS-Word,Linux, Windows (XP/7/8, 10),Hadoop HDFS, Map Reduce, Hive 10.0, Pig, Puppet, Zookeeper, Hbase, Flume, Ganglia, Sqoop, Linux, CentOS, Ambari, Oracle SQL, Oracle, LINUX, SNOW - Service NOW, Autosys,Putty, Zendesk, JIRA, SQL Developer,MS Visual Source Safe, Share point, VSTS

Confidential

Onsite coordinator/Support Lead

Technology: DB2 SQL, Sybase SQL, Oracle PL/SQL, UNIX, Netezza, SAS, Reveleus/OFSAA and BCL, ESP Workstations, SAP BOBJ Reports

Responsibilities:

• Worked as an application Development &support lead and involved during design, architect and implementation of Basel III functionality the latest Level of the Basel Accords, which is recommendations on banking laws and regulations issued by the Basel Committee on Banking Supervisions of Canada i.e. OSFI (Office of the Superintendent of Financial Institutions).
• Maintained ad-hoc SQL Queries, tables, views, index, synonyms, sequence, Cursors, Stored Procedures, Functions and database Triggers to support the application to the users.
• Agile methodology.
• Involve in Data Analysis, Data Modeling, Data Cleansing, Transformation, Integration, Data import, Data export
• Lead the support team, Interaction with Clients to solve the gaps between technical and functional requirements.
• SQL migration from DB2 to Netezza.
• Involved in doing the maintenance and production support of 24X7 coverage.
• Work on service requests (SR’s) and change requests (CR’s) raised for the application.
• Response for loading data using SQL loader.
• Responsible for preparing weekly and monthly incident report for management using BMC remedy.
• Update ASID and ASCP document periodically.

Confidential

Application support Analyst/Lead

Technology: UNIX Command, Shell script, Sybase -SQL, ORACLE 10g (SQL, PL/SQL),Winscp, Putty, Test Directory, Toad, SQL developer, Remedy

Responsibilities:

• Involved in doing the maintenance and production support.
• Monitoring and scheduling the jobs.
• Attend defect meeting with vendor and business.
• Create/Modify UNIX shell scripts to make support work easier.
• Responsible for loading all the Manual loads, through the scripts.
• Analyzed the problem and solve the issue of the user.
• Create generic PL/SQL functions and packages for the various designed Load Programs.
• Database management by creation of Restatement scripts and reusable PLSQL parameterized Procedures.
• Mentor the team

Confidential

Environment: Oracle 10G, PL/SQL, Wall Street Money market and Emerging market, Clear vision, Control M (Job scheduling), UNIX, Taskman, Lotus note mail communications, RTI(Real Time Information), RANsys, BO, Forms 6i, Report 6i

Associate consultant

Responsibilities:

• Worked on Basel II/III Development & enhancement projects
• Preparation of technical specification documents and design
• Handled Onsite Product related queries & issues
• Wrote critical business Functions, Procedures, ETL (Extraction, loading and Transformations) from different source systems and Tuned database.
• To gather requirements, draft understanding, functional and technical specification documents and design.
• Worked on OFSA to facilitate the launch profit/loss analysis enables growth of profitability and customer profitability analysis.
• To provide optimization of decision-making processes and simplifies generation of external reports.