We provide IT Staff Augmentation Services!

Technical Consultant Resume

2.00/5 (Submit Your Rating)

PROFESSIONAL SUMMARY:

  • Visionary and creative technical consultant/business analyst with a stellar track record of driving data driven programs involving Big Data technologies, Enterprise Data Warehousing and Product Data Management solutions at several Confidential 500 companies including leading Investment banks, Financial Services and High tech firms.
  • Extensive data management experience including hands - on expertise in architecting and implementing enterprise-wide business intelligence solutions, pioneering data driven strategies and converting structured and unstructured data into knowledge especially for investment banks and financial institutions.
  • Strong finance domain knowledge including hands-on experience with a variety of Asset Classes, Financial Instruments and Trading Strategies, working knowledge of Quantitative Finance products, techniques and processes related to Options, Futures and OTC derivatives, and their underlying asset classes ranging from Equities, Fixed income, Commodities, and Structured products.
  • Strong technical background with hands on data modeling/data warehousing experience, and strong understanding of several Big Data platforms including Hadoop, NOSQL, MongoDB, Cassandra, Hive, Pig, Amazon Clustering, Microsoft Azure and Data Science techniques.
  • Excellent communication and relationship building skills with C level executives. Rare combination of technical and interpersonal skills that drive programs through consummation on budget, time and value. Skilled in uncovering opportunities, nurturing existing relationships and partnering with professionals at all organizational levels.

KEY STRATEGIC SKILLS:

Business Intelligence/Big Data Presales/Product Demos Account Management/Penetration Program/Project Management Data Analytics/Modeling Agile Methodologies Thinking on two feet Product Lifecycle Management Software Analysis/Solutioning

TECHNICAL SKILLS:

Big Data, Hadoop, MongoDB, SQL, Tableau, R, Microsoft Azure, Micro-Strategy Architect and Report Dev, ETL technologies, OLAP, Database Modeling, Data Analytics, Google Analytics, Business Intelligence & Data Warehousing Architecture, Dimensional Modeling (Kimball and Inmon), Logical Database design, Workflow & Process Design, Agile & Waterfall Software Development, ErWin, GatherSpace (requirements mgmt.), Advanced Excel modeling, Access data manipulation and analysis, Financial Modeling.

WORK EXPERIENCE:

Technical Consultant

Confidential

Responsibilities:

  • Defined Big Data Roadmap and Capabilities for the bank and the asset management firm.
  • Spearheaded enterprise Data Management and ETL Strategies for the data team and developed a reporting roadmap for the buy side analytics’ team, a project that would affect $2 trillion in combined assets under management.
  • Product owner for the Enterprise Data Warehouse and Operational Data Store Systems.
  • Led the capability building exercise for the bank foraying into Big Data with open source MongoDb and on cloud.
  • Implemented a Risk Management System that will imported trade positions and aggregated positions to provide portfolio level risk analytics such as Gross-Net Exposures, Sensitivities, Stress Testing/Scenario Analysis (Shocking the portfolio to hypothetical scenarios). Modeled a financial data warehouse creating a golden version of data incorporating sentimental analysis.
  • Worked with business leads in defining and prioritize the technology project backlog and aligned the PMO organization for project budgeting needs
  • Adopted Scrum methodology for the Development projects juggling multiple teams in Europe, US and Asia Pac.

Principal Consultant

Confidential

Responsibilities:

  • Implemented a Risk Management System that will imported trade positions and aggregated positions to provide portfolio level risk analytics such as Gross-Net Exposures, Sensitivities, Stress Testing/Scenario Analysis (Shocking the portfolio to hypothetical scenarios) and generating Risk Guideline Violation Reports.
  • Modeled a financial data warehouse creating a golden version of data incorporating sentimental analysis.
  • Spearheaded the bank’s analytics platform’s transition into Big Data with distributed computation of trades in Hadoop and NOSQL powered databases with a front end in Tableau software.
  • This move gave visibility into in a parallel way resulting in a more effective and streamlined buy-side decision making for over 50 traders.
  • Client Confidential Davidson: Assessed feasibility, value drivers and roadmap of a multiyear Product Management program at Confidential in product development costs.
  • Evaluated program value and ROI through Value Realization Method (VRMTM), and recommended key capabilities to develop new business.
  • Led the data team in performing sophisticated data analysis using Big Data techniques on social media and Confidential related data sources to boost fitment sales.

Technical Consultant

Confidential

Responsibilities:

  • Led presales, product demonstrations, and requirements gathering sessions on behalf of Trace One consulting team at various major financial firms and CPG companies closing several multi-million dollar deals per year on average.
  • Served as central point of authority on data warehousing & reporting involving trading, risk management and compliance.
  • Perform what-if analysis and stress testing using different inputs and model assumptions to determine losses and assess capital adequacy under changing economic conditions Architected the Logical and physical database designfor an OLTP internet business to business communications and information system designed to help major financial institutions find, negotiate and agree to custom-tailored complex investment instrument transactions such as futures, options, swaps and other derivatives.
  • Spearheaded the Data Architecturefor Internet Data Aggregation. Provided data models and data maps (extract, transform and load analysis) of the datamarts and feeder systems in the aggregation effort.Designed and implemented a Metadata Repositoryproviding a centralized information source for the data models, data maps, processes, & datamaps.
  • Designed and implemented a pricing & trade reconciliation system.
  • The system would facilitate aggregating and independently pricing trades initiated from multiple locations and allow a three party reconciliation process between broker quotes, independent pricing source and administrator pricing and strike portfolio level Net Asset Value (NAV).
  • Conducted feasibility analysis and gathered requirements by leading JAD sessions to map end to end business work flow.
  • Worked with the technical team to translate business requirements into Technical Design and modeling using UML diagrams.
  • Conducted meetings and walkthroughs with process owners, mapped process flows, prepared documentations and flow charts using MS Visio.

Lead Business Analyst

Confidential

Responsibilities:

  • Assisted the Corporate Finance team using Capital Budgeting techniques.
  • Led JAD sessions with cross functional teams and Subject Matter Experts (SMEs) to discuss information system inter-dependencies and design robust reporting platforms for the risk management platform.
  • Created Use Cases, Process Flow diagrams, and Class diagrams using MS Visio.
  • Spearheaded the implementation of a Portfolio Management System to allow existing institutional investors manage their Confidential portfolios.
  • The functionalities included portfolio composition, rebalancing as well as analytics reporting such as monthly, yearly and annualized returns, standard deviations, maximum drawdown, risk-return diagram, portfolio asymmetry chart, VAMI chart,
  • Attribution Analysis, portfolio commentaries, Exposures, Sensitivities and Scenario Analysis.
  • Extensively used data vendor platforms such as Bloomberg Terminal & Morning Star for ad-hoc research Documented current state of the preferred hierarchy of vendor analytics to facilitate effective analytics data stewardship for to the risk department.
  • Led requirements walkthrough sessions with development team serving as the SME for data warehousing and reporting solutions.
  • Guided the development team in technical solution design, data modeling and building physical databases.
  • Informally led the Quality Assurance (QA) team to develop test cases.
  • Performed User Acceptance Testing (UAT).
  • Extensively used SQL for performing vendor data coverage analysis and performing ad-hoc research.

Confidential

Lead Business Analyst

Responsibilities:

  • Pioneered several data driven spend analytics projects helping retail customers reduce total cost of ownership.
  • Studied auction markets & Confidential auctioneering strategies, and analyzed of spend data to mine for trends, opportunities and savings.
  • Performed extensive data analysis using advanced Excel, SQL, Tableau and Micro Strategy to identify patterns and create stories from data.
  • Authored software requirements and architected the logical design of a business intelligence solution using snowflake/star schema dimensional modeling for the bank’s data warehouse storing key financial metrics.
  • Led JAD sessions with cross functional teams and Subject Matter Experts (SMEs) to discuss information system inter-dependencies.
  • Rallied development teams (on shore & offshore) in an Agile centric model to deliver product management releases on time and value.
  • Designed reports using IBM Cognos and MicroStrategy including GANTT charts, project timelines, profitability per product and savings in each category.
  • Developed various sourcing auction analytics generating insights into millions of savings’ dollars for top retailers in the world.
  • Provided quantitative and qualitative spend analysis to global consultants stationed in Europe, Asia and North America boosting savings by millions of dollars for various customer accounts.
  • Architected logical and physical design (star schema, snow flake, normalized) for an enterprise-wide data warehouse storing billions of dollars of data spend for spend and category analysis. Interfaced with development teams (in house and offshore), product managers and quality assurance in classic SDLC and Agile development setups to implement ETL and OLAP systems.

We'd love your feedback!