Senior Business Analyst

HIMANSHU SETH SR. ANALYST

SUMMARY OF EXPERIENCE:

10+ Years of experience as a Business/Finance/Investment Analyst in deployment of web-based, client-server applications, developing

business processes and system solutions

Domain experience such as Real Estate – Commercial, Retail / E-commerce, Education, Finance / Investment, Securities / Risk &

Compliance

Experience in BI Reporting (Oracle), Sybase, Data Warehouse, ETL

Experience in conducting JAD sessions, project meetings, and reviews and walk through

Experience and effective in conducting/anchoring sessions during requirement gathering/analysis phase. The processes include –

JAD (Joint Application Design), Workshops and Brainstorming

Ability to work closely with the business partners to define and understand their needs

Actively used Joint Application Development (JAD) and Rapid Application Development (RAD) sessions with Business users,

SME’s and Stake holders alike in gathering requirements, collating and analyzing them to identify the real business need and

facilitating the development of a customized solution which delivers maximum cost and usability benefit to the client and company

Knowledge and working experience in converting business requirements into UML diagrams using Rational Unified Process and

MS Visio and also managing and tracking those requirements

Experience in process modeling using Use Cases, Sequence and Context Diagrams

Extensive experience in producing documents like Business Requirements Documents (BRD), Functional Requirement

Specifications (FRS), Software Requirement Specifications (SRS), Requirement Traceability Matrix (RTM)

Extensive experience on Excel, Word, PowerPoint, MS Project, MS Visio, Rational Unified Process and SQL

Highly motivated self-starter with excellent communication, presentation and interpersonal skills, can perform well both

independently and with a team, always willing to work in challenging and cross-platform environments

EDUCATION & CERTIFICATION:

• Master of Business Administration – Finance - 2009 - C.T. Bauer College of Business (UH), Houston, TX - GPA:

3.81

• Post Graduate Diploma in Management - Marketing and International Business - 2005 - Indian Center for

International Business, India.

• Certified Business Analyst – Liberty Institution

TECHNICAL SKILLS:

Methodologies Agile, Rational Unified Process (RUP) and Waterfall.

Finance Tools Capital IQ, Bloomberg

Modeling Tools/Languages Rational Software Modeler/UML

Testing Tools HP Quality Center, Clear Quest, Quick Test Professional

Case Tools Clear Case

Requirement Management Tools Rational Requisite Pro, Tele logic DOORS

Workflow Tools MS Office, MS Project, MS Visio

QA Standard Six Sigma with Total Quality Management (TQM)

Databases MS Access, SQL Server

Platforms Windows (NT, 2000, XP), Unix

Reporting Tools Business Objects, Data Warehouse, BI (Oracle), ETL, MS Excel

PROFESSIONAL EXPERIENCE:

MORGAN REED, MIAMI, FL – 02/2010 – PRESENT Sr. BUSINESS/FINANCE ANALYST

HIMANSHU SETH SR. ANALYST

PROJECT: E-Commerce System: This project aimed at migrating the Client’s current e-Commerce portal/merchandizing

integration and supply chain platform to an advanced and efficient platform that increased the productivity of the entire

merchandising process across their business lines. This included several external systems, including Vendor Management,

Catalog, Procurements, Merchandise Management Systems, Supply Chain, etc. This project also helped understanding of

the systems as well as flexibility to deal with different IT departments within the organization.

PROJECT: SUPPLY CHAIN MANAGEMENT: Client is expanding the Business across United States as well as in

Canada and Puerto Rico. The company has identified IT as a key growth driver. The system included an e-commerce as

well as online procurement (supply chain management), Vendor Management. The other modules designed in the system

were Inventory Control, CRM, Financial Accounting, Risk Management and HR. It was a web-based system with Java,

J2EE being the front-end technology and Oracle as backend.

PROJECT: LOAN ORIGINATING SYSTEM: The project was a web-based application involving the automation of

Mortgage loan origination process beginning from origination/opening a mortgage application through funding/closing.

The system performed all the business functions of the loan process such as set-up Account information, New Loan set-

up, the Appraisal, credit, and income. The project involved modules for Pre Approval, Application, Underwriting, Pricing,

Processing, and Closing.

PROJECT: TRADE MANAGEMENT: - Internet-based futures, options and forex brokerage. It allowed users to trade

online. The main features of this site were: Users can open new accounts online to trade equities, bonds, derivatives and

forex. The users will get real-time streaming quotes for the currency pairs they selected, their current position in the forex

market, summary of work orders, payments and current money balances, P & L Accounts and available trading power, all

continuously updating in real time via live quotes. The site also facilitated users to Place, Change and Cancel an Entry

Order, Placing a Market Order, Place/Modify/Delete/Close a Stop Loss Limit on an Open Position.

Responsibilities:

Interacted with the Business Users to get a better understanding of client business processes and gathered Business Requirements

Assisted in Documentation control, ensured financial process risk and compliance

Interacted with the ETL team, and account holders to get the requirements, documented them, designed templates, and wrote

specifications

Facility planner using Clarity and Open Workbench (OWB) for the scheduling and tracking of all projects and online capture of

actual and subsequent posting of hours to Clarity Designed report templates based on the requests by account managers

Provided client mentoring, analysis and documentation of website and ERP process for the integration of both internal entities and

its valued Vendors

Created wireframes/screen mockups for portal enhancements based on business needs

Created UI specs documents with navigation maps and storyboards

Documenting management system that was utilized in the access control and management of the requirement specifications

produced in this role

HIMANSHU SETH SR. ANALYST

Expertise in iterative approach of Agile development with all the teams members (Requirement, development and QA teams)

reporting to me for issue resolution, each iteration was 3 weeks long

Prepared and maintained Business Requirements Documents (BRD) and Functional Requirements Documents (FRD) defining

new systems operations for the project using Rational Requisite Pro

Created Use cases, Use Case Diagram, Business flow diagram using Unified modeling language (UML)

Created Use cases, and developed detailed Use Case Diagrams and Sequence diagrams describing how actions are to be

carried out using MS Visio

Created User Stories to communicate requirements to the development team

Continually reviewed and revised project processes to ensure accurate and timely results

Updated project status to the Project Sponsor, Senior Management on a regular basis, creating PowerPoint presentations.

Functioned as the primary liaison between the business team and the technical team

Managed assets above $20M through selection in undervalued securities, bonds, treasuries and real estate holdings using evaluation

process based on historical trend and data research, industry and competitor analysis along with scenario planning and risk

assessment

Prepared specialized reporting and analysis for monthly as well as yearly costs, identified issues needing further review and or

attention and provided recommendations on research spending

Communicated with financial markets on a regular basis and researched statistical data, analyzed the information, prepared financial

models and reports for real estate investment decisions

Assisted in revenue recognition in compliance with GAAP, monitored monthly inventory levels and implemented efficient cost

accounting methods to improve overall company costs

Assisted in Documentation control, ensured financial process compliance and monitored actual financial performance against

budget/forecast to determine sales/profit impact

Environment: Windows, Rational Unified Process, Agile, Data Warehouse, ETL, MS Office, SQL Database for Basic Testing, MS

Project, UML

COUGAR INVESTMENT FUND, AIM CENTER OF INVESTMENT MANAGEMENT, HOUSTON, TX 07/2007 – 12/2009

BUSINESS/EQUITY ANALYST

PROJECT: RISK MANAGEMENT: - Built an Enterprise wide MIS/Reporting application in the Risk Management Group that

enabled the Financial Advisors and Money Managers to get a comprehensive look at their positions. Provided ease of use and portability

to the users who would be able to determine how they are invested in the various monetary instruments like Fixed Income, Equities,

Bonds and Derivatives. The interface will be a web based OLAP system that will provide business intelligence capability to the user.

PROJECT: COMPLIANCE AND BI REPORTING (Oracle):

Compliance:

Developed a java based engine through which trades are routed from trader's desk to compliance team so as to make sure trades are

in compliance with company’s rules and regulations or not. Then trader gets notification that they can go ahead if it complies

BI Reporting:

To generate reports needed by compliance team to make sure things are in compliance with the company's regulations

Developed a separate Data Warehouse from where reports can be generated. Helped ETL team to transform data from OLTP

database to Oracle based Data Warehouse from where reports can be generated for the compliance team

PROJECT: Oracle REPORT GENERATION:

Previous reporting system was based on Sybase and the management thought the reports generated were outdated and old and so

they wanted to migrate to Oracle based reporting system;

Sybase was pulling data from another source that would be transformed to Oracle and hence we would be missing some attributes as

designing of Oracle is such that they trimmed the attributes to save space.

Previously the reports were generated on PERL Scripts (PDF files mostly) and now Oracle BI would generate it.

HIMANSHU SETH SR. ANALYST

Responsibilities:

Selected to manage an equity portfolio of $9 million and one of only 8 to return to a compensated position to manage and train the

incoming students in stock analysis, industry and competitor analysis

Managed fund through stock selection in undervalued securities using fund's quantitative discounted cash flow (DCF) valuation

models

Made decisions on sector weightings and sector stock selections using various workstations such as Morningstar, Bloomberg,

Capital IQ, Value line

Performed risk analysis and scenario planning and outperformed benchmark (S&P 500) by 250 basis points

Conducted customer and stakeholder interviews to elicit system analysis and documentation of system processes

Did Gap analysis and structured walkthrough of workflow within different departments to identify and fill the gap

Created Use cases, and developed detailed Use Case Diagrams and Sequence diagrams describing how actions are to be carried

out using MS Visio

Developed and evaluated data design, and repository creation, analyzed, designed, and developed data modeling solutions

Involved in JAD sessions to gather requirements, and to analyze the requirements. Successfully conducted JAD sessions, which

helped synchronize the different stakeholders on their objectives and helped the developers to have a clear-cut picture of the project

Identified, analyzed and documented defects, questionable functions, errors, and inconsistencies in application functions, outputs,

online screens, and content

Scheduled meetings with developers, System Analyst and testers to collaborate resource allocation and project completion using MS

Project, MS Visio

Facilitated the gathering and documentation of business requirements for software enhancements related to new product releases,

bug fixes and general improvements to existing software

• Worked on profiling the data for understanding the data and mapping document

• Interacted with the SME's to analyze the data extracts from Legacy Systems (Mainframes and COBOL Files) and determine the

element source, format and its integrity within the system

• Defined and reviewed the Data Warehouse requirements with the business users for getting the right data from the source systems

for reporting purposes. Performed GAP analysis, which involved understanding the reports in the old financial management system

•

•

Interacted with the ETL team, and account holders to get the requirements, documented them, designed templates, and wrote

specifications

• Reviewed Logical Data Models that contains set of diagrams and supporting documents containing the essential business

elements, detailed definitions, and descriptions of the relationships between the data elements to analyze and document business data

requirements

• Created documents like the Business Glossary, Actors Catalog and Data Dictionary to facilitate the other teams in understanding

client business

Managed business requirements documentation to include operational overview, milestones/status and measurements of success -

additionally managed enhancements to project timelines as necessary

Organized, gathered, classified, analyzed and disseminated business intelligence data used in strategic and operational decision-

making

Prepared the test data scenarios and most of work using MS Excel using advanced features

HIMANSHU SETH SR. ANALYST

Conducted UAT Testing for clients, executed test cases and documented the actual results

Wrote/Executed SQL queries in HPQC for customizing the reports and dashboards as need of the project

Environment: Rational Requisite Pro, Rational Software Modeler, Access Windows, Data Warehouse, ETL, Oracle BI, MS Office

(MS Word, MS Excel, Adobe illustrator, MS PowerPoint, MS Visio), Sybase, Business Objects, Data Warehouse, UML, SQL, HP

QC

LIFESTYLE INTERNATIONAL LIMITED, INDIA 12/2005 – 09/2007 CONCEPT MANAGEMENT

ANALYST

Lifestyle, a division of Landmark Group (UAE), is one of the biggest retailers in Asia with more than 20,000

employees. It operates 41+ stores in major cities of India and has annual revenue of $500 million.

PROJECT: CRM (LOYALTY PROGRAM): Developed and Launched Customer Loyalty Program that enabled the

organization to attract new customers and retain old customers by providing rewards to customers for their repeat

purchases. It was an e-commerce platform. The loyalty program began when a customer enrolled. From that point forward,

the organization accurately tracked information about that “member,” captured the member’s purchases, credited points to

the member based on the rules stored in the loyalty “engine,” categorized the member in tiers or groups based on the

member’s value to the organization, and enabled the member to redeem points for products or services when various point

levels were attained.

Supervised a team of 70 employees for the apparel and cosmetic department with a budget of $50M

Implemented sales plan, merchandise presentation strategies and marketing campaigns with resulted in an increase of

6% in the annual revenue

Streamlined internal control procedures, analyzed inventories and prepared management information system (MIS)

reports which resulted in overall cost reductions for the department

Identified opportunities and appropriate suppliers for merchandise and cosmetics, which resulted in a clearly

identifiable advantage in functionality, price, quality and logistics

Provided overall revenue/gross margin reporting and maintained integrity of the data in the systems and assured that

adequate levels of control documentation are in place

Acted as liaison between the Technology group and Marketing department to deliver Loyalty Program, ecommerce

strategy and marketing initiatives that were supported by IT

Conducted discovery meetings with stakeholders to understand scope of Loyalty Rewards project, Loyalty platform

data and process flow

Created Use cases, and developed detailed Use Case Diagrams and Sequence diagrams describing how actions are to be

carried out using MS Visio

Prepared and maintained Business Requirements Documents (BRD) and Functional Requirements Documents (FRD)

defining new systems

Responsible for the creation and completion of all business requirements and change request documents

Responsible for comparing functional/technical design documentation to business requirements (Gap Analysis) to

ensure all business requirements are delivered as requested

Helped design and develop new and improved processes, tools and system enhancements to support business unit

requirements

Participated with IT developers in testing for system fixes, new releases and enhancements, changes and

implementations, in order to ensure functionality and user acceptance

Defined and reviewed the Data Warehouse requirements with the business users for getting the right data from the PoS

for storing and analyzing purposes

HIMANSHU SETH SR. ANALYST

Facilitated user acceptance testing of system changes and supported I.T. team through to successful delivery,

implementation and operation against pre-determined acceptance criteria

Environment: Rational Requisite Pro, MS Word, MS Power Point, MS Excel, MS Project

INDIA BULLS SECURITIES LIMITED – INDIA 06/2005 – 12/2005 FINANCE BUSINESS ANALYST

PROJECT: WEALTH MANAGEMENT: This project was developed specifically to support Wealth Management

Groups to provide most valuable advisory services to clients on Asset Projections, Equity, Options, futures, Fixed Income,

Credit Management, Risk Analytics, Portfolio Rebalancing, Investment Holdings, Trading, Liquidity needs and Future

goals. The systems solutions advise the clients on wealth management strategies, provide clear and complete picture of the

clients’ assets in position, full brokerage capabilities, research data, tax and insurance information.

PROJECT: PORTAL SYSTEM: Broker Portal Sales application was rewritten to provide a more accessible, secure,

and integrated user experience to the customers of the company's Business Units. The newly updated Sales application was

known as Broker Portal. ”Forms Wizard Project” was initiated at the same time as the newly updated Broker Portal. The

scope of the Forms Wizard Project included organizing the 100's of forms and marketing materials used by Broker Agents

on a day-to-day basis in the extranet (company's external website) and intranet sites (i.e. Broker site), and improving the

process of adding and modifying forms/ marketing materials.

Responsibilities:

Built Portfolio models for clients and back tested models to analyze return on portfolio versus S&P500

Analyzed securities with the aid of research reports and presented recommendations to supervisor

Determined the benefit of using covered call option to increase portfolio return

Reviewed the asset allocation of existing portfolios to determine the need for rebalancing based on portfolio models.

Performed cost basis analysis for securities sold for tax purposes

Gained in-depth understanding of market conditions and investment opportunities through conference calls and proprietary

research reports

Managed current and prospective client information using Sales force and researched on the securities especially stocks and mutual

funds

Experience in stock selection process involved looking at client research reports of various companies across all the industries. On

the other hand, Morning Star rating and analysis was used for evaluating mutual funds

Analyzed this information and presented my report to the financial advisor. The advisor would then make the final decision to

invest their client’s money in various securities

The portfolio as a whole was back tested using Thomson software to observe its return compared to the market. The performance of

the same portfolio against S&P 500 was compared for the past ten years

Analyzed the performance of the existing portfolios every quarter. An opinion such as Buy, Sell or Hold would be formed based on

the economic trend and the performance of the company or the fund in the past year and the outlook for the next quarter

Participated in the corporate wide BPR roadmap process to define the “To be” process based on Design for Six Sigma

Methodology

Developed functional requirements and a proposed data warehouse strategy for supporting employee compensation and compliance

reporting/analytics

Involved in defining the scope of the project, gathering business requirements and documenting and managing them using Rational

rose and Rational Requisite Pro respectively

Presented high level requirements and interaction diagrams using use cases, to user groups, as well as documenting requirements

and getting them reviewed and base lining the same

Analyzed business requirements and segregated them into high level and low level Use Cases, activity diagrams using UML

methodology

Prepared Business Workflow models that cover "How" business processes are accomplished

HIMANSHU SETH SR. ANALYST

Involved in process modeling, reviewing and writing URS and Functional Requirements

Participated in periodical Joint Application Development (JAD) sessions with the management and IT teams

Interviewed business experts, asking detailed questions and carefully recording the requirements in a format that can be reviewed

and understood by both business and technical communities

Utilized Rational Unified Process (RUP) to configure and develop processes, standards, and procedures

Performed UAT and Performance testing on the application

Used MS Office extensively (Word, Excel, Visio, Power Point, Outlook, Project) for analysis, presentation and documentation

throughout the project

Environment: Rational Requisite Pro, Rational Rose, MS Word, MS Power Point, MS Excel, MS Project

Contact this candidate