DHAVAL SHUKLA
Email: acepf1@r.postjobfree.com
Ph: 917-***-****
Over 7 years of progressive experience in Banking & Financial Services and
Telecommunications/Cable Industry). Extensive experience working on complex
IT projects and worked with on-site and off-shore model, in geographically
diverse locations of North America, EMEA, APAC and LATAM. Adept at
communicating with senior management, business users, vendors, and internal
teams to coordinate overall business requirements. Extremely meticulous and
process oriented.
Areas of Expertise
Business Analysis/ Data Project Management and UML Diagrams/ Wireframes
Analysis Function Points /XML & Dashboards
BRD/ FRD/ GAP/Root Cause Data Audit Reporting/ Data Testing/ Defect Management
and Impact Analysis, Mapping, Data Profiling Content & Release Management
Change Management SQL Queries/ KYC/MIS
Regulatory, Compliance Reporting
Financial & Risk Web Applications & Services/
analysis E-Commerce/ Data Analytics
TECHNICAL SKILLS
. MS Office, Microsoft Word, PowerPoint, Advanced Excel, Access, Visio
and Microsoft Project
. Microsoft Technologies (.NET, SQL Server, XML, SOAP, Web Services)
. SQL Server, Spreadsheet Modeling, Crystal Ball, Dashboard, IBM
Rational Suite, Oracle DBA, DOORS, POLARION, Blueprint,
Websphere,IBM Enterprise Contract Management & Supply Chain (v9, v10)
. SDLC Methodologies: Agile, Scrum, RUP and Waterfall
. Data Analysis Tool: Statistical Package for Social Sciences (SPSS)
. Reporting Tools: Crystal Reports 8.0/9.0/10, SSRS, Data Reports,
Siebel- (CRM), Cognos Reporting 8/10 BI
. Testing Tools: HP Quality Centre, Bugzilla, Win Runner, Load Runner,
Test Director, Quick Test Pro, Rational Pro.
PROFESSIONAL EXPERIENCE
Citi Bank,
Dec 2013- Continue
Role: Sr. Business Analyst/Project Management
Citi's Global Transaction Services (GTS) is a leading provider of cash
management, treasury, trade, custody, clearing, depositary receipts and
agency and trust services. GTS has a global platform that is unique in the
industry for its reach, interoperability and flexibility. Citi has been
mandated by OCC under the consent order to evaluate Regulatory & Compliance
effectiveness of its AML surveillance and transactions monitoring system
(MANTAS).Data quality enhancement regarding the consideration of new
scenarios to increase the effectiveness of Citi's current monitoring
program on EFT, Cash and Monetary Instruments.
Key Responsibilities:
. Achieved improvement on data quality, surveillance coverage for
monitoring effectiveness, efficiency, governance and quality through
data profiling, and SQL/ETL concepts. Worked on business processes and
product Processor like SEPA, RCX, Receivables and Payments for regions
NAM, EMEA, APAC, and LATAM.
. Defined logic to drive risk modeling efforts across a number of
dimensions and continually assessed the quality of risk models,
scenarios, and related output. Produced and maintained data map
between the AML/Sanctions monitoring tool (Prime), and associated
downstream and upstream systems built on Java and .Net
. Dodd-Frank experience with understanding of the actual rules,
regulations, and requirements across the entire act or experience with
implementing a portion (like clearing) of the Dodd-Frank Act.
. Participated and led on all action planning deliverable for relevant
rule making i.e Dodd Frank, Volker Rule (including front and back
office system developments and enhancements and monitoring and
surveillance needed).
. Executed data mining of historic transaction data, looking for trends
and unusual activity to enhance the core processes of Current and
Future State. Maintained information to support Suspicious Activity
Reports (SAR) or equivalent for regulatory filing and FATCA (Foreign
Account Tax Compliance Act) and Volcker risk sensitivities, stressed
VaR and trade surveillance, market abuse.
. Produced BRD, FRD, end to end mapping documents Root Cause and
Gap/Impact analysis for Regulatory & Compliance requirements, Prime
Brokerage, Stress testing, Leading JAD Session, unit test plans and co-
ordination with internal data analysts and data modeling teams,
external ETL, QC, Architecture and Production Support teams.
. Queried AML, Sanctions and KYC systems in response to regulatory or
risk events. Synthesized results into a coherent risk presentation for
management. Reviewed and analyzed AML current trends and news in order
to identify high risk areas, counterparties or keywords to incorporate
into monitoring filters, rules, or profiles for MIS and COGNOS
reporting.
. Advanced Excel spreadsheet knowledge including both mathematical and
functionality formulas, multi-page workbooks, building macros and
complex nested formulas.
. Managed OTC Derivatives Rates, Credit and FX products, pricing, risk
and clearing workflows and CCP (LCH, ICE, CME, Eurex) clearing data
feeds and interfaces.
. Detailed hands-on knowledge about industry-standard front office
standards for market data management (bootstrapping algorithm), trade
capture, pricing (Black-Scholes, Cox-Ross), and risk (Monte Carlo,
VAR).
. Implemented standards via data profiling, data quality assessment and
data models as part of the design and process development activities,
business model updates and mappings to the Logical and Physical Data
Model for current and future state.
. Engagement with ETL team, Completed mapping document, Populated
Spreadsheet containing new/modified business terms, Erwin models in
XML format.
Credit Suisse,
June 2012 - Nov 2013
Role: Sr. Business Analyst/ Project Management
Credit Suisse Initiated Implementation of Contract Lifecycle Management
(CLM) an IBM's Emptoris Strategic Supply Management solutions tool (v9,
v10).This application is for the purpose of evaluating the fit and
functionality of Credit Suisse negotiations & client on boarding
requirements of International Swaps and Derivatives Association (ISDA) &
Credit Support Annex (CSA) multi-party agreement Compliance. The CLM
program will mitigate current risks; greatly enhance "Credit Suisse
"ability" to respond to regulatory and compliance changes such as Dodd
Frank, Basel III, and Sarbanes-Oxley Act.
. Drived CLM Pilot project to analyze how IBM Emptoris application
works, and whether it can handle the business expectation of Credit
Suisse and conducted various tests/ different Scenarios and
environment to validate it. Documented change management and
application development management, Root Cause Analysis and adoption
methods.
. Wrote GAPS requirement once the pilot project was over, and
highlighted the actual gaps in IBM Emptoris tool and Credit Suisse CLM
Project. Lead the IBM Emptoris application configuration and
deployment worked with the IBM Emptoris Production & Engineering team
to close gaps and negotiated the timely completion of the same.
. Created BRD/FRD/NFRD/Test Plan, Test Cases, Stress testing, Root cause
and Impact analysis for the project. Facilitated business process
design workshops with business teams, identify improvement
opportunities, model and analyze business impact of future state
design and align with end-state strategy.
. Strategic Risk Management/CRO Leads (Risk Sensitivities & Scenarios)
and interacted with a large trading floor for both plain vanilla and
complex OTC and Listed Equity Derivative products understand the front
to back trade lifecycle for Equity Derivatives, trade surveillance,
market abuse.
. Extensively worked on Counterparty credit risk measurement techniques
including counterparty ratings, probability of default, loss given
default, exposure at default, current exposure, potential exposure,
potential future exposure, mark to future, collateral modeling,
portfolio margining and Trade Compliance.
. Worked on AML, Regulatory & Compliance, and operational risk issues
associated with the changes in regulation. Operational risk experience
working with capital markets business on Basel II reporting, risk
project management, design and implementation of new operational risk
models and controls.
. Involved in Compliance MIS and COGNOS reporting, Compliance
Transformation Service, Sanctions Scanning for both customers and
transactions, Anti-Money Laundering, Currency Transaction Reporting,
Know Your Customer and Customer Due Diligence, mainframe and
distributed applications.
. Defined site structure, navigation, and page layout by creating site
maps, wire frames, and UI specifications, assessing interface
usability, and managing content inventories. Designed process flows to
capture user interactions with front-end websites and integration with
back-end systems.
. Created DFD (Data Flow Diagrams) planned and documented procedures for
data processing, DSD (Data Structure Diagrams) Data mapping and
programs specifications with the ability to create and read Entity
Relationship Diagrams for Current and Future state.
. Completed Test Case Matrix for all test cases being executed in
testing effort and was responsible for overall success of System and
User Acceptance Testing (UAT) activities & UAT signoff activities.
. Worked as Share Point Solutions Analyst, collaborated with clients and
client development teams, as well as interacted with project managers,
business analysts, user experience designers, programmers, usability
engineers, documentation writers, and quality assurance analysts, to
specify, design, develop, and deploy complex SharePoint 2010 solutions
for Business approvers in CLM project.
DUN & BRADSTREET
Nov 2011-June 2012
Role: Business Analyst
Worked on MaxCV Project with Entity Matching & Identity Resolution team;
the primary objective was to drive consistent, high quality result for data
matching globally, Risk analysis of contract and vendors. Understand the
data and generate reports, prepare analysis, compare before and after data
and enhance client UI experience through ATG.
. Initiated data mapping and data collection system with improving the
accuracy, completeness and timelines of D&B data and providing
unparalleled insight to customers. Defined a common risk taxonomy and
hierarchical business structure to enable data analysis and
correlation across risk management disciplines and developing
interfaces for D&B Data Management (MDM) program.
. Proven experience developing BRD/FRD/TDD, wire frames, mockups, click-
able prototypes, Leading JAD Session and UI diagrams of complex multi-
state pages and functionality and Collaborated with team on ATG UI/UX
client online experience enhancement.
. Designed, developed, and configured UI/UX software systems to meet
client requirements on end-to-end analysis, design, implementation
through WebSphere, quality assurance testing, delivery and maintenance
of the software product, system and specific phase of the lifecycle.
. Established and maintained the vendor risk model and required tools
and procedures to assign consistent risk rankings to vendors at
various points in the Contract lifecycle and identified adjustment
points based on information obtained about the vendors, capabilities,
control environment, and performances. Used Omniture for digging into
data and making actionable recommendations.
. Executed project testing defect remediation process - completed Defect
Forms and send to Test coordinator. Stress testing, Regression UAT
Test cases based on requirements, business designs and business
scenarios where necessary.
. Critically analyzed and evaluated data for Current & Future state /
information gathered from multiple sources and reconciled / address
conflicts worked in partnership with internal control and risk groups
to advise, establish, syndicate and maintain vendor risk criteria
through MIS and COGNOS reporting.
. Worked with business units, sourcing professionals, vendor management
team and contract owners to assign risk criteria and rankings to new
and existing vendors and their associated contracts.
. Worked with Data Governance team on functional areas (Decision
Management, Risk, Operations, Finance, IT) to develop and implement an
overall MIS strategy and governance model for teams providing MIS
reporting, files, development, to ensure new projects adhere to the
strategy as well as ensure utilization of proper teams and data marts
based on the MIS roadmap and Data Warehousing & Business Intelligence
(BI). Advanced knowledge in Microsoft Excel (V Lookup, Pivot Table,
Formulas, etc.)
Synchronoss Technologies
Jan 2011 - Nov 2011
Role: Business Analyst
Project: Migrating existing Charter.com (Charter Communications) web
presence to Synchronoss/ATG tools. ConvergenceNow replaced functionality
performed by the Business Rule Engine (BRE), Mainframe and RECOM and Share
Point Analysis systems at charter. The ConvergenceNow platform will
interface directly with new Charter.com and other affiliate sites through
Go2Broadband (G2B) and other external applications through the EAI/BSS/OSS
API services.
Main Responsibilities:
. Worked with business users, web architects, and IT teams throughout the
project life cycle, from analysis through design, build, test and
deployment to design and implemented online products & bundles through
ATG.
. Designed and develop new features/functionality to provide world class
online shopping experience to drive online sales through ATG. And track
customer behavior through Omniture analytics.
. Provided leadership in design, development, implementation and ongoing
enhancement of Company's E-Commerce applications environment and Data
Warehousing. And served as internal subject matter expert for E-Commerce
and CRM software and environments.
. Drived Omniture testing and implementation standards, maintaining
consistency across company's businesses and develop and maintained
Omniture implementation processes and guidelines documentation.
. Documented issues and best practices relating to specific platforms or
configurations, including third party apps (i.e. Video, Mobile, Social,
or product/tool tracking). And marketing Analytics, for Charter
Communications for Mobile and Gaming Products. Understanding of Ad
Supported Products, In-App purchases through charter.com. Knowledge of
Network Service Assurance (SA) architecture and associated functions.
. Lead JAD sessions for requirement gathering (BRD, FRD, Scope, documents),
analysis and design which helped in determining the functional
specifications, writing use cases and creating screen prototypes.
. Performed GAP analysis to analyze the compatibility of the existing
system infrastructure with new business requirements and vendor
management and contract negotiation experience and MIS/COGNOS reporting.
. Providing technical support to the ATG/BCC Team, Database team,
developers (Onshore/ Offshore) and Quality Analysts. Created "User Guide"
manual for "Charter Communication" for the company reference and future
user understanding.
ROYAL BANK OF CANADA Jan
2010 - Dec 2010
Role: Business Analyst
The Project required developing an Assets Risk Management System under .NET
framework, an application for risk office to monitor and report front
office risk for Compliance of Alternative Assets Group (mainly Hedge
Funds). The application involved tracking and accepting front office
changes, independently run valuations, running Value at Risk models and
reporting standing order exceptions. The application included hedge fund
pricing components and various risk related reports.
Main Responsibilities:
. Worked on Financial, Strategic, Market, Credit and Operational risk, and
was involved in every aspect of IT risk management including SOX, SAS70,
IT Operational risk management, IT entitlement reviews, BCP, vendor risk
assessment and coordination of internal/external audit activities.
Coordination of internal/external audit planning Experience with
technology risk management (SOX, Basel II, and Risk control framework),
AML, and Compliance and Regulatory risk.
. Elicited and documented the Software Requirements Specification (SRS).
Analyzed legacy limit reports to understand the VAR/Delta/Gamma/Vega
limits and creating BRD/ FRD/TDD, Stress testing and MIS/COGNOS
reporting.
. Modelled the detailed design of the system using UML and Use Case
Diagrams, Class Diagrams, Sequence Diagrams, Activity Diagrams and State
Chart Diagrams, Current State V Future State and Impact analysis.
. Developed the detailed as-is and To-Be process for Business Process Re-
engineering and Enterprise Risk Management and Collateral Management.
. Normalized the data by reducing the redundancy, ensured data integrity
and eliminated inefficient storage. Ensured that data systems operate at
a high level of performance, including integrity, reliability and
availability in Data Warehousing & Custody Data and Prime Services
domain.
TELCO SERVICE AUSTRALIA
Feb 2007 - Nov 2009
Role: Business Analyst
Project: Migration from Mainframe to Siebel CRM
Main Responsibilities:
. Defined, documented and diagrammed the business needs, web design,
Internet, mobile, Pay TV media implementation. Knowledge in OSS/BSS
functional areas including ITIL Service Design, Implementation, &
Operations. Knowledge of Network Service Assurance (SA) architecture and
associated functions.
. Prepared and delivered an in-depth presentation on Agile Methodologies
and software craftsmanship including Scrum, Extreme Programming, RUP, and
RAD, Lean/Agile principles, practices and tools through team and
organizational coaching.
. Piloted detailed data analysis, end to end process mapping and translated
business requirements into BRD/FRD, Logical Data Models and Business
Objects (BO).
. Identifying the key business processes, requirements and use case
scenarios to facilitate the construction of Business Rules Engine (BRE)
for system integration and design.
. Participated in periodic Risk Analysis meetings with the Project Manager,
Developers, Management, Product Marketing Team, and the QA team. This
resulted in the assessment and identification of the main risks to the
project; put in place processes to minimize them.
. Implemented a linear approach to modeling certain project requirements,
in order to enable optimal risk detection and priority assignment to
requirements; this priority assignment is vital for use in mission-
critical decision-making.
. Working extensively with the QA team for designing Test Plan and Test
Cases for the User Acceptance testing (UAT).
. Involved in Architectural Diagrams, Data Flow Diagrams and providing
technical support to the Database Team.
EDUCATION
. Master of International Business - University of South Australia (UniSA),
Australia, 2008- Major in International Business, Finance, Marketing &
Business Strategy.
. Bachelor of Commerce - South Gujarat University, India- 2001- Major in
Advance Accounting, Auditing, Statistics & Economics.
[pic][pic]