Sql Server Project
Resume:
Vanita Viswanathan
Powell OH *****
**************@*****.***
PROFESSIONAL SUMMARY
About 6 years experience in Application / Business Intelligence areas with emphasis on business / data
analysis & reporting
Domain exposure includes banking / financial, insurance and travel business processes
Knowledge of life insurance business process with particular focus around operations, claims
processing, accounting and finance functions
Experience with all modules of Business Objects XIR2/6.x/5.x
Strong understanding of Software Development Life cycle with exposure to project management
coordination
Knowledge of extraction, transformation and loading (ETL) processes inclusive of data analysis, data
mapping and testing procedures and test plan creation, and using quality center for defect tracking
Experience in interacting with Business users to analyze needs and transforming requirements into flow
models, report mock-ups, technical specification, UAT support and training
Good exposure to understanding data models, using Erwin and dimensional / star schema design
principles
Strong background in databases including Oracle, MS-SQL Server
Excellent communication and strong interpersonal skills with ability to interact with end-users,
managers and technical personnel.
Quick learner with excellent analytical, technical, problem solving and organizational skills
TECHNICAL SKILLS
Reporting Tools Hyperion Essbase, Hyperion Interactive Reporting 9.3, Desktop Intelligence
XIR2/6.x/5.x/4.x, Web Intelligence XIR2/6.x/2.x, Universe Designer, Crystal Reports XI,
CMC, Import Wizard, InfoView
Support Tools HP Quality Center, Visio, MS Project, Erwin
Database(s) DB2, ORACLE 10g/9i/8i, MS SQL Server 2000 / 2005
Operating System Windows, UNIX
SQL / Query Tools TOAD, SQLdbx, SQL plus, Sun Accounting System
PROFESSIONAL EXPERIENCE
JPMorgan Chase - Real Estate Operations Mar 2010 – Jun 2010
Columbus, OH
BO Report Developer
Central Technology and Ops group supports reporting and analytics for real estate operations of all JPMorgan
Chase facilities. This project consisted of BO report design and development activities on facilities direct data
covering US-based facilities. The reporting application consisting of daily, monthly and ad-hoc reports, provides
management with trending, exception, operations and performance reports across problem categories, problem
types, facilities, cost center and SLA related information
• Created around 30 WebI reports with tables and charts using complex calculation and report level
variable
• Extensively used reporting contexts including ForEach, ForAll and In functions for handling multiple
aggregation needs
• Created rolling 13 month and 7 month trending reports along with top 20 issue category ranking with
different dimension cuts to show SLA patterns and high-volume problem categories
• Designed reports based on requested, adjusted and actual SLA durations and provided moving segment
categorization by ranking first 7 problem types and bundling the remaining in the other category, based
on trends in most recent month
• Developed reports with drill through and linked functionality for various region specific needs
• Created report level variables involving complex calculations, If-Then-Else logic and BO built-in
functionality
• Identified data issues including missing information, data duplication, incorrect data mapping used in
ETL, incorrect universe level joins and universe variables
• Modified existing universe to add functionality to support new report development
• Assisted BO administrator with universe modification, migration and bug fixes
• Participated in JAD seesions for report needs & report design and documented requirements for
business signoff; prepared project WBS based on finalized requirements and schedules
• Created report design specifications with detailed mapping and calculations and reviewed with end-
users for accuracy
• Mentored junior BO development resources and trained end-users
Environment: Business Ojects XI R2, Oracle 11g, MS project
JPMorgan Chase - EDW – Banking Center P&L Dec 2009 – Mar 2010
Columbus, OH
Business / Data Analyst
This project was focused on data analysis, validation and reporting as part of the Banking Center P&L (BCPL)
group within EDW. JPMorgan Chase completed WAMU branch mergers in the last quarter of 2009 and numerous
baseline processing were required to validate the consolidation activities. The project was mainly around
validation of branch / cost-center level account, customer and household information across the merged entities.
As part of the yearend activities for the merged entities, extensive reporting around branch-level profitability,
account ownership, re-householding, aggregated account and balance information across various retail product
groups were performed.
• Performed cube build validation by comparing data from multiple essbase cubes against hyperion
queries
• Created hyperion reports for branch-level profitability reporting inclusive of account and balance
activity, tracking of cost center migrations, validation of high-balance aggregates etc..
• Generated ranking reports for branches based on existing accounts, new accounts opened and high-
balance accounts and applied Y-O-Y trending across 4 years and showed region-wise performance for
pre / post merger situation
• Analyzed data aross multiple environments to validate cost center allocations and roll-up for deposits,
loans and consumer data
• Performed complex data validation and analysis in exel through pivot tables, formulas, multiple and
vlookups to isolate accounts based on various bands of balance and transaction activity
• Created new reports and modified existing reports in Business Objects XI R2
Environment: Hyperion Essbase, Hyperion Interactive Reporting, Business Ojects XI R2, DB2, Excel
Global Software Solutions & Resources Oct 2008 – Nov 2009
Herndon, VA
Business Analyst
• Worked on the RFP for the report conversion project to convert Web Intelligence and Desktop
Intelligence reports in XI R2 version to Web Intelligence reports in XI R3.1
• Created the sql loader scripts to set-up database layer
• Performed source side data analysis to mimic report output for manual validation
• Developed consultant utilization metrics, payroll actual and projected disbursement reports
• Created client profitability analysis reports, with billing trends and provided drill down capabilities to an
individual consultant level
• Designed and built active contracting pipeline reports to help marketing managers manage job pipeline
and consultant placements
Environment: Business Objects R2, TOAD, Oracle 10g, SQL Server 2005, Windows XP, SQL Loader
Birla Sunlife Insurance, Mumbai, India Jun 2003 – Apr 2006
Accounting & Operations – Business / Data Analyst
Birla-Sunlife is a collaborative effort from Birla Group India and Sunlife Financial, Canada and is primarily
focused on providing life insurance products in India. The company has extensive operations in most states and
has a highly effective network of independent agents
• Part of the MIS group supporting accounting, billing and operations business groups
• Managed petty cash process, reporting and analysis across 55 branch offices
• Utilized the ‘Sun Accounting system’ for financial accounting activities and created custom operational
reports
• Managed the business analysis and requirements definition activity for the new expense management
application for petty cash and its interface with Sun systems
• Created high-level process flows, swim lane diagrams, and use-cases for the new web-based application
• Worked with the development group to produce functional design
• Created and executed test plans & test cases for SIT and assisted users with UAT process
• Performed ad-hoc SQL data analysis on sun systems database (Sql Server)
• Worked with branch executives and operations group to identify insurance active pipeline and
conversion / commission reports for sales group
• Captured business metadata and created reports for easier access by users
• Designed, developed and validated these reports built through BusinessObjects tool and / Sun system.
• Identified possibilities of report rationalization and cross-group usage
• Trained business users on report usage and helped convert legacy reporting to business objects reports
• Assisted with universe creation, performance improvement for queries, Sql testing, report debugging
and roll-out
Environment: Business Objects 6.1, TOAD, Oracle 9i, Windows 2003, Sql Server 2000, Sun Accounting
System, ASP.NET, Visio, Quality Center, MS Project
Blue Star Infotech, Mumbai, India
Data Analyst Sep 2001 – May 2003
• As part of the PG Diploma in Software Engineering, worked as an intern for 9 months at Blue Star
Infotech’s Business Intelligence (BI) division in Mumbai.
• Continued working as a data / business analyst with Blue Star’s travel and hospitality division
• Trained on Business Objects 5.1 report development
• Worked with client group to identify core reporting functionality and design requirements
• Performed Source to target data mappings, business rules for ETL and ad-hoc analysis
• Analyzed data from several source systems, assisted development teams to build solutions and provided
support for testing and delivery of applications
• Performed SIT through back-end data testing to validate business rules
• Assisted with UAT activities and with writing technical as well as training documentation
• Worked with business groups to improve reporting strategies and data usage for decision making
Environment: Business Objects 5.1, Sql Server 2000, Oracle, Windows NT,, Erwin 3.5
EDUCATION & TRAINING
Master of Commerce (M.Com) Mumbai University, India Apr 2004
(Accounting, Taxation & Information Systems)
PG Dip in Software Engineering Boston Institute, Mumbai May 2002
(2 Year integrated Course, done parallely with undergraduate studies)
Bachelor of Commerce (B.Com) S.I.E.S College, Mumbai India Apr 2001
(Taxation & Information Systems)
Contact this candidate