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.

EXPERIENCE 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, 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.

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, Agility, ServiceNow, Autosys.

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

Big Data Ecosystem: 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

Environment: s: Development, UAT-User acceptance testing, Pre-Production, Production

PROFESSIONAL EXPERIENCE:

Confidential

Senior analyst

Responsibilities:

• Performing data analysis, modeling, cleansing, transformation, integration, import, export, data lineage, maintained data protection and privacy.
• Developed database views, store procedures using sq. to populate the reporting tables.
• Working on creating, designing, quality testing and test forms/queries.
• Working as experienced senior leadership Business analyst role and handling on business rule changes, documentation about the changes and mapping with proper hierarchies.
• Working on design, develop, testing, implementation and production support.
• Performed and able to achieve post upgrade and implementation testing.
• Prepared project documents including version control, functional requirements, business cases, proposals, feasibilities, gap analysis, and detailed manuals which can be used.
• Preparation of functional & technical specification documents from the business requirements.
• Metadata definition preparation for different LOBs.
• Effective communication with different levels & layers of team, clients, stakeholders within the project and organization with the understanding of business priorities.
• Managing daily project status call with team and weekly status call with stake holders.
• Preparation of project plan and demonstration to end users to materialize future projects.
• Took responsible in design, architect and implementation during the project cycles to prioritize the ongoing and pipeline projects.
• Experienced in schedule or to assign project related works to respective team.
• Data preparation while building and designing the data movement.
• Worked with change management team to ensure proper developed codes are deployed.
• Worked on hive queries.

Environment: s: development, QA, UAT-User acceptance testing, Pre-production, production, Citrix XenApp

Confidential

Project Lead

Responsibilities:

• Worked on OFSAA installation and deployment of OFSAA and its applications.
• Good exposure of OFSAA data model, metadata logical and physical OFSAA data model
• Experienced in OFSAA Run rule framework and batch processing
• Worked as an application Developer/BI Analyst/Application support lead/ Project Management/ Production Support and 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 with team collaboratively.
• Worked on developing, programming and customizing and analytics to comply with the regulatory board requirements.
• Worked on identifying risk of fraud (AML), involved in management override of Internal Controls to improve the effectiveness and efficiency in audit.
• 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.
• Worked on Big data Eco system, understanding of Hadoop HDFS Map-Reduce and other Eco-System Projects
• Worked with Cloudera / Horton work Support team to Fine tune Cluster
• Manage several Hadoop clusters in production, development, Disaster Recovery environments.
• Took responsible for building a cluster on HDP 2.3 and HDP 2.4
• Worked with engineering software developers to investigate problems and make changes to the Hadoop environment and associated applications.
• Installed, upgraded and Managed Hadoop Cluster on Hortonworks
• Trouble shoot many cloud related issues such as Data Node down, Network failure and data block missing.

Environment: CASE TOOLS: Toad, PL/SQL Developer, ERWIN, SQL Navigator, Query Analyser, Control M, AQT, Agility, ServiceNow, Autosys.

Confidential

Support Lead

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 24X7 production support 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 Lead

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

OFSAA consultant/Admin

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.

Confidential

Responsibilities:

• An application developed to maintain the financial services. This project is part of managing enterprise and risk to meet compliance goals and gain insight into customer profitability. Responsibility in this project including migration and implementation of Finacle application). Database migration using SQL Server, PL/SQL and Oracle Database.

Environment: MYSQL, SQL, Pl/Sal, Wndows2000/XP, UNIX, Oracle 10g, Forms 6i, Report 6i