Sap Functional Analyst /business Warehousing (bw) Resume
2.00/5 (Submit Your Rating)
SUMMARY
- Skilled data processing director possessing strong math, analytical and problem solving skills.
- Excellent verbal, written and interpersonal skills.
- Dedicated and focused.
- Hands - on with data warehousing.
- Able to work under pressure and meet deadlines.
- Experience designing, maintaining and development of databases for sales and reporting purposes.
SKILLS
Languages: C++, Visual Basic for Applications (VBA), ACCESS SQL, PL/SQL.
Software: EXCEL 2010, Access 2010, Word 2010.
Operating Systems: Windows, SAP R/3 4.6C, UNIX Solaris
Databases: SQL Server 2012, Oracle 10G, SAP BW.
Market Feeds: Bloomberg, Reuters.
EXPERIENCE
ConfidentialSAP Functional Analyst /Business Warehousing (BW)
- Performed all necessary configuration tasks with in SAP BW to execute a customer billing scenario.
- Configured ODS objects and infocubes (with and without hierarchies)
- Designed custom reports, queries, info-objects, aggregates and custom extractors.
- Customized data sources, configured authorization objects, data mapped and data flowed from R/3 to BW.
- Experience performing ETL job analysis.
- Experience in extracting data from SAP R/3, generic DataSources and Flat Files.
- Experience in Extraction, Transformation, Loading (Full and Delta Upload) and Monitoring.
- Experience in ERP tools, and using SAP User Exits, Customer modifications, and ABAP.
- Proprietary system provided screens (front end) for data input and report generation.
Director of Sales Analytics
- Leading the National Supplemental Life Sales initiative with hands-on data validation, devising and maintaining business rules, providing heat maps, merging data sources, training, and one-off projects.
- Serving as the first point of contact for technical-to-business translation, customized reports, and front-office-to-back-office data flow.
- Position entails advanced statistical and financial analysis for populations and for samples.
- Active dimensional modeling, QA/QC, ETL, performance optimization, and reporting in Oracle and Microstrategy.
- My department generates $25 million in annual revenue and is rated the best seller of Supplemental Life insurance in the Nation.
- Currently managing a team of five professionals.
Derivatives Reporting Analyst
- Internal report/dashboard design and roll-out (ad hoc reports, static reports, and real-time reports).
- Equities and fixed income product knowledge.
- P&L statements, front office through back office, internal reporting, automation, and derivative products (calls, puts, and interest-rate swaps).
Back Office SWAPS Operations
- Conducted international fixed income research & analysis to effectively support trading activities covering Emerging Markets.
- Developed spreadsheets & other modeling tools utilizing Visual Basic to price derivative structures, and to value fundamental & technical equity trades.
- Automated profit & loss processing for the trading-desk.