SUMMARY

• 8 years experience as an analyst.
• Experience with the SDLC, RUP and Agile methodologies (SCRUM).
• Expert in data mining Oracle and DB2 databases using TOAD, SQL Developer, Control Center.
• Experience with Fixed Income and Credit Markets.
• Experience working with business stakeholders.
• Expertise in Business Requirements Documentation using MS Word, Rational Requisite Pro.
• Received advanced training and worked hands on with Business Objects OLAP reporting tools like Web Intelligence Reports and Crystal Reports.
• Mapped data elements using ETL tools like Composer, Data Integrator Ab Initio.
• Efficient in co - coordinating meetings, JAD sessions, project planning using Mind Manager Pro.
• Carried out analysis at portfolio level using Black Rock’s Green Package Suite of tools.
• Strong working knowledge of UML, Use Cases.
• Expertise working with Issue tracking tools likes Jira.
• Performed systems analysis to understand the change in portfolio compliance during the MLIM ( Confidential Investment Management) and Blackrock merger in October 2006.
• Instrumental in carrying out pre-trade, post-trade and end of day (portfolio level) compliance monitoring.
• Expertise in SharePoint (Moss2007) for task management, workflow management, document sharing, maintaining appropriate user level.
• Conducted user training workshops as required including DTCC connectivity training provided to Confidential employees globally.

TECHNICAL SKILLS

• MS Office
• MS Project
• Visio
• Rational Rose
• TOAD
• IBM Control Center
• Squirrel
• Charles River
• Aladdin Suite
• Eclipse Workbench
• Green Package
• Jira
• Mind Manager Pro
• Confluence
• Embarcadero

PROFESSIONAL EXPERIENCE

Confidential, NJ

Business Analyst

Responsibilities:

• Analyzed the data flows across the product processors, the global warehouse and billing systems
• Implemented a consolidated global billing system for the Global Transaction Services at Citi
• Participated in decommissioning of Canadian, Asian, Western European billing systems
• Eliminated revenue leakage by building automated cost based transactional feeds into the warehouse from different product processors
• Enhanced reporting flexibility by allowing granularity to be set by the customers on ad hoc basis
• Designed and deployed different billing functionalities such as price tiering for fee based transactions
• Develop strategic means to consolidate the transactions across various regions to offer tiered pricing and compensating balance advantages to global customers
• Created Interface Control Documents between banking product processors and the warehouse
• Drove the design and review meetings for the decommissioning of regional billing systems
• Implemented ETL for the billing data using Ab Initio graphs
• Data mining to analyze various banking products

Applications used: Ab Initio, Visio, Share point, Toad

Confidential, New York, NY

Business Analyst

Responsibilities:

• Analyzed trade processing workflows and created process flow diagrams.
• Conducted gap analyses between market processes and system functionality.
• Ensured consistency of specifications across sub-systems processing products belonging to various asset classes.
• Developed functional specifications.
• Instrumental in planning and executing the testing phase of the implemented solutions by writing and executing manual test scripts.
• Coordinated system and patch releases to ensure thorough testing and roll out to customers.
• Designed training for users and documented client educational materials including user and administrative guides.
• Participated in documenting effective date changes associated with the CDS Big Bang rolled out implemented in April 09 nationwide.
• Detailed specifications for on boarding new clients onto the futuristic electronic trade processing platform owned and operated by Confidential Serv.

Applications used: Confidential Wire, DTCC Deriv /SERV, Trade Manager, Credit Novation Consent, Trade Information Warehouse.

Confidential

Finance / Business Analyst

Responsibilities:

• Using the Agile methodology (Scrum) carried out the SDLC phases in efficient manner.
• Profile data to identify data quality issues using SQL and Data In Sight
• Instrumental in identifying authoritative data sources feeding into various systems by carrying out data mining using TOAD and Embarcadero tools.
• Extensively used Business Objects reporting functionalities such as WebI reports to slice and drill data along various measures.
• Intensive operational analysis of data being fed into SEC reports carried out using WebI reporting facilities such as filters, ranking, sectioning, graphs and breaks.
• Analyze exposure to securities with low FICO scores and/or high loan to value ratio.
• Implemented the Security and Customer Masters for client (Toronto Dominion)
• Defined the logic for business engine to capture and cleanse Reference data from data vendors (Bloomberg, Reuter, S&P, Moody’s, and Fitch) into a golden copy.
• Gathered and documented requirements from clients for installing Accounting Master to capture and monitor various Cash transactions.
• Applied business intelligence solutions to feed proprietary information into SEC filings (using high degree of data quality checks).
• Created the business requirement specifications having communicated with the business users (financial accounting department).
• Assisted in isolating downgraded securities amongst Subprime mortgage backed securities.
• Data mining and relational data modeling using Squirrel SQL query tool, TOAD, Embarcadero and IBM Control Center.
• Implemented Confidential solution at client locations to support key Derivative Lifecycle events that affect valuation, risk and exposure.
• Participated in designing the Test plan for automated and manual performance testing.

Applications used: GS Work-Bench, Mind Manager, Share point Task Management, Business Objects.

Confidential

Responsibilities:

• Monitored compliance rule exceptions/alerts generated for various portfolio accounts.
• Data Mining using complex SQL querying to analyze underlying securities information.
• Carried out task management using SharePoint (MOSS 2003).
• Gained hand on experience working with various MLIM products (consisting of various financial instruments like Fixed Income and Equities)
• Instrumental in carrying out end-user and compliance reporting using Green Package applications (Black Rock’s in-house portfolio, account compliance and risk reporting solution).
• Customizing rules imbedded in the Charles River Compliance (standard rules library) module for testing (positive and negative) purposes and isolating alerts generated.
• Coordinated and tracked various business and technical teams during UAT using SharePoint utilities (MOSS 2003).
• Analyzed defects discovered during UAT and Systems’ Performance Testing in the SharePoint web access application.

Applications used: Charles River FI and PI modules, SharePoint (MOSS 2003), Rapid SQL, Aladdin and Green Package applications.