SUMMARY

• Senior Technical Consultant / Project Manager with 18 years of experience in variety of industries including Bank & Finance, Defined Benefit System, Healthcare, Automobile and Corporate Services. Known and recognized working collaboratively across all levels to understand and solve problem through effective use of systems and technology. Proven success in delivering projects within budget and specified time frames
• 3 Years hands on experience handling Defined Benefit Systems Vanguard Pension Administration System for various clients determining the ERF, NRF, Death benefits, fund disbursements
• 7+ Years extensively worked on AML Programs such as Financial Crimes and Transactional monitoring, KYC, Case Management, SAR with Confidential Bank and JPMC
• Sound knowledge of Financial Crimes and Compliance Management practices, Customer, Account, Cash, Wire, Monitory Instrument transactions, Risk score derivations, Alerts spike analysis
• Experience designing and building expert systems for Product Recommendation & Selection, Problem Diagnostics & Troubleshooting, Customer Service
• Expertise in Oracle PL/SQL, Performance tuning, application DBA and database designs and tools such as TOAD, SQL Developer and Toad Data point
• Has more than 7 + years extensive experiences in Oracle Mantas 5x, OFSAA FCCM 8x Data model
• Expertise in setting up Oracle mantas environment in 5.7.2, 5.9.0 & OFSAA FCCM 8.0.4
• Has 1+ years of experience in bigdata tools such as Hadoop, hive, spark2, Sqoop, Python
• Has 6+ years of experience of Informatica power center, workflow manager, repository manager, workflow monitor
• Demonstrated leadership skill in the program and Scrum management to derive the best value from the team, promoting teamwork and accelerating synergy in solution delivery. Act as a mentor to the team to build very high - performance team and enabler for team to deliver best, optimized, engineered technical solutions to business
• Has extensive experiences of project task Planning, implementation, Progress tracking, resource allocations, monitoring, daily and weekly reporting, and stakeholder and customer communications, Release planning, Risk assessment and planning with contingencies
• Experience designing and building expert systems for Product Recommendation & Selection, Problem Diagnostics & Troubleshooting, Customer Service,
• Expertise in writing Business Requirements Document (BRD), Functional Specification Document (FSD), Non-Functional Specification Document, System Design Specification, System Use Cases, screen mockups, and training manuals
• Oracle Certified Associates - Advanced PL/SQL Track
• Oracle Certified Associates - DBA track
• Hadoop and spark certified developer

TECHNICAL SKILLS

• Oracle 12c
• SQL
• SQL Loader
• TOAD informatica power center
• Shell script
• HDFS
• Oracle 11g
• PL/SQL
• Export
• SQL Developer
• Talend
• Cucumber
• Hive
• Oracle 10g
• VB6.0
• Import
• PLSQL Developer
• Spark
• ORAAS
• Forms 6i
• Explain Plan
• SQL Plus
• Sqoop
• Sybase
• Reports 6i
• ADDM
• SVN
• HQL
• SQL Server
• HQL
• AWR
• RTC, RLM
• Python

PROFESSIONAL EXPERIENCE

Senior Technical Business Analyst / Technical PM

Confidential

Responsibilities:

• Involved in creating Business, Functional, Technical Requirements by working with all the stake holders - Business team, Architects and Development team members at onsite & offshore.
• Involved in conducting meetings for Agile projects requirements sessions with stake holders and able to articulate and create the requirements in User Story format. Worked with stakeholders, Product Owner for effectively scoping/user stories.
• Capture & clarification of business requirements through a range of analysis techniques (data flow diagrams, sequence diagram, case tool analysis, gap analysis and work & process flow diagrams).
• Worked on creating business, functional, use cases, technical requirements artifacts. Involved in understanding business problems and transformed these into EPICs/Feature and User Stories.
• Involved in creating User Stories, prioritization, iteration / Sprint planning, Release planning, Scrum Retrospective by working with Scrum Master and Project Manager. Worked with Technical teams to identify options to meet business requirements.
• Involved in features functional testing and conduct POC.
• Database analytics (Creating SQL Queries).

Environment: Oracle 12c, PL\SQL, UNIX, TOAD Data point, Control M, SQL server 2008, SYBASE

Technical Project Manager

Confidential, TAMPA, FL

Responsibilities:

• Ownership of the project management of small portfolio of change projects, these may often be complex projects spanning multiple functions and departments
• Setup a detailed project planning and milestone tracking relating to the implementations
• Engagement with senior business representatives and technology on systems implementation initiatives to facilitate scoping, prioritization, benefit identification and tracking and business readiness
• Contribute to continual process and people management innovation, supporting effective delivery of solutions
• Provision of clear and accurate reporting for key stakeholders and interested parties
• Providing support and guidance to the junior resources
• Responsible for monitoring team and task distributions
• Create tracking and progress reports relating towards the execution of the strategy
• Gathered Business requirements pertaining to Trading, fixed income and derivatives, converted the same into functional requirements by implementing the RUP methodology and authored the same in Business Requirement Document.
• Prepared slides using Microsoft PowerPoint and presented them at quarterly quality meetings.
• Construct run book for GPA to run BAU activities
• BAU supports and coordination

Environment: Oracle 11g, PL\SQL, UNIX, TOAD, RTC, Informatica, cloudera, Hive, Spark2, Sqoop, Shell scripting

Technical Project Manager/Senior Business Analyst

Confidential

Responsibilities:

• Ownership of the project management of small portfolio of change projects, these may often be complex projects spanning multiple functions and departments
• Setup a detailed project planning and milestone tracking relating to the implementations
• Engagement with senior business representatives and technology on systems implementation initiatives to facilitate scoping, prioritization, benefit identification and tracking and business readiness
• Contribute to continual process and people management innovation, supporting effective delivery of solutions
• Gathered Business requirements pertaining to Trading, fixed income and derivatives, converted the same into functional requirements by implementing the RUP methodology and authored the same in Business Requirement Document.
• Analysing informatica mappings, workflows to extract the current business logic
• Documentation of logic gathering into Key business requirement
• Has involved creating HLD and LLD
• Has involved writing oracle PL/SQL components and deployment
• Test document review and execution
• Coordinated with business, UAT during user testing
• Providing technical solution to team

Environment: Oracle 11g, PL/SQL, Toad, UNIX, Shell scripting, Informatica PowerCenter 9.6.1, RTC, BMC RLM

Senior Technical Consultant

Confidential, TAMPA, FL

Responsibilities:

• Worked on creating business, functional, use cases, technical requirements artifacts. Involved in understanding business problems.
• Involved in project requirement gathering, gap analysis, scope definition, scheduling and prioritizing, work assignment, execution, monitoring and controlling and delivery management.
• Involved in implementation of Mantas upgrade project form version 5.7.1 to 5.9.1 for North America instances like Private Banking, Smith Barney, and Institutional Anti-Money Laundering.
• Involved in migration of Informatica 9.6.1 repositories to new infrastructure.
• Coordinated infrastructure, procurement team for various components installation
• Performed one month of data loading into mantas 591 UAT environment by running various of scenario frequencies as per production execution, so that 591 UAT alerts will be validated against production 572 alerts

Environment: Oracle Mantas 5.9.1 RHEL 6.6, Oracle 12C Database, JIL Tool, Informatica 9.6.1, PL/SQL, SQL Developer, Shell scripting, RLM, Automated Control Framework Tool & Autosys Job Scheduler, MS Project, Visio