Technical Business Analyst / Solution Architect Resume
2.00/5 (Submit Your Rating)
New, YorK
SUMMARY
- Sophisticated Business Analyst/Information technology leader with expertise working on Risk, Finance & Capital market systems.
- Highly adept at analyzing complex Business requirements, providing innovative solutions for various Business Functions, Audits, Data Lineage, and liaising with multiple stakeholders in driving solution implementation.
- Product Control Functions: G/L Posting, Balance Sheet, PnL, FairValue, Off - Balance Sheet
- Risk & Finance: IHC/CCAR, SOX, Basel II/III, Dodd Frank/Volcker Rule
- Trading Systems: (Booking/Settlement/Confirms), Bullion Trading (Spot/Forward/Straddle)
- American Depository Receipts (ADRs): Inter Bank SWIFT messaging for capturing/releasing foreign shares
- Corporate RealEstate Tax, Private Banking Limited Partnership Ops.
- Business/Systems Analysis Requirements Gathering / Business Process Flow
- Functional/Technical Specs creation SDLC/Agile-Waterfall Methodologies
- Communication & Team Building skills Application Development / Architecture Design
- Data Modeling / Data Warehouse / OLTP Hands-on coding (SQL/Unix/ETL)
TECHNICAL SKILLS
- Sybase 15
- Oracle 11g
- PL/SQL Informatica
- Scripting (Unix
- Perl
- Python)
- Excel Pivots
- Client-Server/n-Tier systems
- Business Objects
- PowerBuilder
- Java
- XML
- Erwin
- MS Visio/PowerPoint
PROFESSIONAL EXPERIENCE
Confidential, New York
Technical Business Analyst / Solution Architect
Responsibilities:
- Devised complex G/L posting rules for various financial instruments, analyzing Data/Process requirements, building Functional/Interface specs, and coordinating the technical implementation.
- Extensively supported IHC/CCAR compliance efforts, eliciting data sourcing requirements for various reporting (FR Y-14A/Q/M) and creating functional specs for critical process flows.
- Leveraged extensive noledge of PC Systems (SubLedger, G/L posting, PnL, Adjustments, FOBO recon/Reg reporting etc), identifying impacted systems and defining scope of technical deliverables.
- Elicited requirements for in-bound feeds into the PC Datawarehouse from various PC systems, extensively liaising with Business users and creating functional specs for various Business analytics.
- Drove the OBS reporting effort for Broker-Dealer Lite derivatives, extensively analyzing business requirements and building process flow charts mapping technical system capabilities.
- Led multiple IT Audit processes including Data Tracing across systems & Data Lineage, Application platform audit, Systems Risk assessment and Business continuity Assurance.
- Extensively performed data analysis and analytics, writing complex SQL queries and utilizing excel tool pivots along with powerpoint/visio charts and UML tools for process/data visualizations.
- Designed elaborate test cases, supported all testing phases, formulated reconciliation specifications across multiple systems, liaised with QA/Ops, built go-live plans, and signed-off on deployment.
Confidential
Systems Analyst / Developer
Responsibilities:
- Extensive hands-on coding in Sybase 12/15, UnixScripts, Powerbuilder for building G/L Posting application and Oracle/Informatica for building P/L Calculation framework.
- Implemented Fair Value Leveling process for various Asset classes, partaking in extensive systems analysis, creating functional Specs along with Data modeling/technical specifications.
- Designed key architectural components of G/L Posting Engine and P/L calculation including extensive Database schema/process development.
- Collaborated TEMPeffectively across divisions, designing architectural solutions in a technology landscape consisting of Sybase 15/Oracle 11G, Informatica, Unix/Linux and Java/Weblogic middle tiers.
- Highly skilled at prioritizing tasks, balancing competing demands and meeting aggressive timelines for development and production delivery.
Confidential, New York
Contractor - Systems Analyst / Application Design
Responsibilities:
- Determined operational objectives, gathering information, evaluating output requirements/formats
- Translated business requirements into technically relevant specifications.
- Built Python modules relating to customer email interaction using POP/SMTP protocols.
Confidential, New York
Contractor - Senior Analyst/Developer
Responsibilities:
- Gatheird requirements and created GUI screens used for ADRs and processing SWIFT messaging.
- Undertook extensive Systems analysis for translating Business requirements into Technical Specs.
- Used sound Object Oriented Design principles in building the Application front-end architecture.