Data Sql Server
Resume:
Nikhil Ashok
******.*****@*****.***
PROFESSIONAL SUMMARY
Around 8 Years of IT Experience in Business Intelligence, Data warehousing, ETL & Reporting.
Sound knowledge of the Insurance, HIPAA, Banking and Financial services industry.
Experience in all modules of Business Objects XI R2/3.1, Web Intelligence XI 3.1/R2/6.x &
Crystal Reports 9.x/XI/2008.
Migration experience from Business Objects 6.5 to XI R2 & from XI R2 to XI 3.1
Designed Interactive Dashboards using Crystal Xcelsius 4.5/2008 with data providers being Excel
sheets/QaaWS (Query as a Web Service)
Created Universes on large data warehouse(s) & on data marts for specific subject areas involving
data sources from SAP BW & HFM.
Assisted in designing physical & logical data models using MS-Visio, ERwin & Magic Draw.
Created ad-hoc, Cross-tab, Drill Down, standard & canned reports using Free hand SQL & Stored
Procedures as the Data Providers
Experience in creating Interactive graphs & Dashboards using Crystal Xcelsius.
In-depth knowledge of Informatica Power center 8.1 & BO Data Integrator 6.5 used in ETL &
Data Profiling
Experience in Schema design (Star schema, Snowflake Schema) involving complex architecture(s).
Experience in dealing with Oracle 10g/9i/8i, MS SQL Server & DB2 databases.
Added Classes & Objects, checked joins & cardinalities of existing Universes.
Participated in the SOX(Sarbanes-Oxley) audit for various Control Activities,
Proficient in business process documentation and end-user training/knowledge transfer.
Data modeling experience using CA’s ERwin.
Experience in using QTP (Quick Test Pro) & Mercury Quality Center 9.2, Loadrunner for testing
purposes.
Outstanding ability to communicate and work within a diverse team and independently.
Excellent communication skills, strong decision making skills, organizational skills,
excellent analytical and problem solving skills.
TECHNICAL SKILLS
Operating Systems Windows 9.x/NT/2000/XP/2003,AIX,UNIX,Linux
Language C++, Visual Basic, PL/SQL, XML, COBOL, UML
Reporting Tools Business Objects 6.x/XI R2, Crystal Reports 9.x/XI/2008
ETL Tools Informatica Powercenter 8.1,BO Data Integrator 6.5,SSIS
Dash boarding Tools Crystal Xcelsius 4.5/2008, BO Dashboard Builder(EPM)
Data Modeling Tools ERwin Data modeler 7.1, MS - Visio
Defect Tracking tools Remedy ARS
Testing Tools QTP(Quick Test Professional),Mercury Loadrunner, Rational CQ
Web Applications Apache, IIS
Application Suite Microsoft Office Suite, Lotus Notes
Databases Oracle 11i/9i/8i, MS SQL Server 2000/2005, DB2 UDB
Database Tools TOAD, Oracle SQL Developer, PowerBuilder
PROFESSIONAL WORK EXPERIENCE
The New Edge Group (Mar’ 09 – Till Date)
Domain: Financial Services/Securities/Commodity Trading
Business Objects Consultant
New Edge uses Business Objects XI R2 for reporting & analysis. Xcelsius 2008 is being used as a primary
dash boarding tool, to visually capture KPI’s & metrics of the Org.
Currently, in the process of migrating to Business Objects XI 3.1.
Involved in designing the process & framework around creating dashboards.
Prepared technical specs & created a universe for Activity Based Costing & Cost Per trade for
reporting on the daily trading activities within the Organization.
Created canned & ad-hoc reports relating to Service Family using Crystal Reports XI & Web
Intelligence XI R2, detailing the system “up time” & issues affecting other systems.
Used Live Office & QaaWs (Query as a Web Service) to integrate data in a Dashboard for the Higher
management.
Enhance existing dashboard on using Dashboard Builder (BO EPM).
Linked Web-I content using Opendocument.jsp to Xcelsius dashboards for detailed level data.
Designed the IT Finance Universe combining various modules of Human Resources( Head Count,
Resource Planning, Expenses, Tier 1 App, Activity Tracking)
Assisted in System Testing, UAT & migrated reports/dashboard from Dev. To Prod.
Environment: Business Objects XI R2/3.1, Crystal Reports 2008, Crystal Xcelsius 4.5/2008, MS Visio, MS
Office, SQL Server 2005 Remedy ARS v.7.1, Windows NT/2003.
Capital One (Feb’ 09 – Mar’ 09)
Domain: Financial Services
Business Objects Consultant (Vendor)
Note: The intended duration of this project was 3 weeks, to design a dashboard prototype & train Capital
One associates on Xcelsius Development
Capital One uses Business Objects XI R2 for reporting & analysis. Xcelsius 2008 is being used as a primary
dash boarding tool, to visually capture KPI’s & metrics of the Org.
Involved in designing the process & framework around creating dashboards.
Integrated a complex dashboard with 18 LO connections & created using Crystal Xcelsius 4.5 & 2008.
Creating Preliminary Design document(s) & Dashboard Specifications for dashboards using
Xcelsius 4.5/2008.
Advised & Improvised on the existing methodology on Dash boarding & Reporting
Assisted in Integrating Web Intelligence XI R2 reports in Live Office to act as a source for the
Xcelsius Dashboard.
Environment: Business Objects XI R2/3.1, Crystal Reports 2008, Crystal Xcelsius 4.5/2008, MS Visio, MS
Office, Teradata 12.0, Windows NT/2003.
Shire Pharmaceuticals (Nov’ 08 – Feb ‘09)
Domain: Pharmaceuticals
Consultant – Business Intelligence
Shire uses Business Objects, HFM & SAP to manage their IT Ops. Business Objects & Crystal Xcelsius are
used for reporting & dash boarding purposes respectively. Informatica is the ETL tool used to
retrieve/capture data from external data sources & load it onto the FDW.
Responsibilities:
Migrated from Business Objects XI R2 to BO XI 3.1
Redesigned the Variances universe (used for Financial reporting) which utilizes the SAP BW 3.x data
access driver, along with the SAP Integration Kit to connect to the SAP database.
Gathered the FDW design & ETL Specs to identify the current dataflow.
Also used Crystal Reports 2008 for Pixel Perfect detailed reporting (PDF format) for the higher
management
Created complex reports showing Actual vs. Budget, Actual vs. forecast & other variance reports using
Crystal Reports XI/2008 & Web Intelligence XI R2.
Designed Interlinked - drillable dashboards & dashboards linking to Web I reports using Xcelsius 2008, QaaWs & Live Office using the “Opendocument” function
Extensively used Xcelsius functions (Dynamic visibility) to provide visually stunning components
being displayed based on various conditions.
Used Business Objects Voyager for analyzing & reporting off OLAP data cubes from Hyperion
Essbase (HFM) primarily being used for Variance reporting
Designed & published reports in PDF involving complex formulae using Crystal Reports 2008
Held Interactive KT sessions with business analysts/end-user(s) to gain a firm grasp on the intricacies
of the business, to improvise the current reporting & dashboarding process.
Used QaaWs (Query as a Web Service) extensively, to dynamically alter & present data on the
dashboard using Crystal Xcelsius 2008
Enhanced the P&L(Profile & Loss) universe, to improve data retrieval & handle errors whilst
reporting
Proposed a Cost Center/Business Unit dashboard to show the variance (Actual vs. Budget & Actual
vs. Forecast) for all business entities.
Created & enhanced universes relating to General Ledger, Actuals, Budget and Forecast data.
Implemented row-level security on the universe level to manage user access & permissions.
Used filter, list view, accordion components, waterfall, combo charts & gauges to visually enhance
dashboards using Xcelsius 4.5 & 2008.
Environment: Business Objects XI R2/3.1, Crystal Reports 2008, Crystal Xcelsius 4.5/2008, Informatica
Powercenter 8.6, Netezza Performance Server, MS Visio, MS Office, Remedy ARS v.7.1, Windows
NT/2003,SAP R/3,Hyperion Essbase.
Fannie Mae (June’ 08 – Nov’ 08)
Domain: Mortgage/Credit Loss/Credit Risk
Sr. Business Objects Developer
Fannie Mae uses Business Objects for detailed analysis & reporting. The 2 broad mortgage related domains
in which Business objects provides intelligence/analytical data are CLM (Credit Loss Mgmt) & CRM (Credit
Risk Management). Reports & Dashboards provides analytics related to delinquent loans, foreclosed
properties & QAS (Quality Assurance System) to review the loans bought by Fannie Mae.
Responsibilities:
Coordinated with the business to design the scope & requirements for each release.
Created & enhanced existing universe(s) to add more classes & objects for querying & reporting
purposes.
Performed Extensive Data analysis & data validation whilst reporting.
Designed an Inventory Balance (Real Estate Owned) Score card showing the trend, variance & other
comparative analysis using Xcelsius 2008 & Web Intelligence XI R2.
Crystal Reports XI was the primary reporting tool used for mailing out reports on Foreclosures,
Disposed REO (Real Estate Owned) Properties & detailing state level performance.
Designed Interactive Dashboards for higher management using Crystal Xcelsius 4.5/2008.
Analyzed trends from foreclosures & sent out daily/monthly trending reports along with detailed
data analysis.
Tracked KPI’s (key performance indicators) by department to create interactive reports & scheduled
the same.
Used Crystal reports XI to deliver highly complex pixel perfect reports (PDF) to the higher
management on a weekly/monthly basis.
Extracted information from external data sources residing on the DB2 UDB database & Flat files, to
transform & load data onto the datawarehouse for reporting purposes.
Created High level design document(s) & Data flow diagrams using MS-Visio
Prepared Technical Specs & Reports Specifications for ad-hoc & canned reports.
Designed free hand SQL reports on Web Intelligence & Desktop Intelligence from different
domains.
Assisted in Extraction, Transformation & Loading processes into different dimension tables in the
RDW(Reporting Data Warehouse) & the CLM RE Data Mart
Worked extensively with the major functionality of Business Objects like Breaks, Ranks, Alerter,
inserted calculations, Filters, Sorts, and Query Prompts
Involved in Unit testing and created test cases for UAT for all reports and created documentation
(Report Specs) for all reports.
Involved in users training, providing technical support and resolved issues like bug fixing, updating
with patches by coordinating with the technical support team directly.
Used Remedy ARS v.7.1 & Rational Clear Quest to log change management request(s) & resolve
defects
Environment: Business Objects XI R2, Crystal Reports XI, Crystal Xcelsius, Business Objects EPM
(Dashboard Builder), IBM DB2 UDB for NT Unix 8.1,SQL Server 2005, DB2 UDB v7, MS Visio, MS Office,
Remedy ARS v.7.1, Windows NT/2003, Mercury Load Runner, Rational Clear Quest, AIX 5.3
Nortel Networks, NC (March ’07 – May’ 08)
Domain: Telecom & Finance
Data warehouse Developer
Nortel Networks is one of the biggest telecom providers, providing end to end communication solutions &
capabilities. This Project involves the design, development and maintenance of Business Objects Universes
and implementation of Web Intelligence XI as a reporting solution for the Extranet. This will be extensively
used by Nortel’s Internal revenue department(s).
Responsibilities:
Interacted with business/end users to analyze business requirements & develop detailed
requirement(s) document.
Worked with the DW Team to migrate from Business Objects 6.5 to Business Objects XI R2
Used Crystal reports XI to generate complex reports & Web Intelligence XI R2 for reports being
published over the Intranet.
Used the Import Wizard to migrate users, connections, reports etc to the new Environment.
Executed, tested & validated the reports on the new Environment (Business Objects XI R2)
Handled a team of 9 off-shore members sub-contracted to CSC India.
Utilized Desk I chart(s) to trend the orders received into the Order Management DB from different
regions across the globe.
Validated data using Free Hand SQL, before data was loaded onto the EDW (Enterprise Data
Warehouse) for reporting & analytics.
Created 2 new universes on different subject areas (Data Marts) for Nortel Network’s Internal
Finance Departments.
Defined cardinalities & checked the integrity of the existing Universes
Implemented Web Intelligence XI as a solution to reporting via the Extranet.
Participated in DSR (Daily Status Report), WSR (Weekly Status Report) Calls with team members &
higher management.
Configured the security & permissions of users/user groups across the organization using CMC
(Central Management Console) in BO XI R2.
Used TOAD to write/replace SQL Code for data validation.
Generated Master Detail charts, Cross Tab reports, Adhoc & dashboard reports from multiple data
providers. Generated complex reports involving formulas and variables
Performed stress & performance testing using loadrunner while extracting & loading data on the OLAP
database.
Created reports using the Universes, Stored Procedures and Free Hand SQL as the data providers.
Used Slice and Dice, Drill Down, Filters, Conditions, Cross Tab, Master Detail and Formulated and
developed Hierarchies to support drill down reports.
Involved in various discussions with the end users to analyze Meta Data.
Environment: Business Objects 6.5/XI R2, Microsoft SSIS/SSRS/SSAS, Crystal Xcelsius, Crystal Reports XI,
Import Wizard, Report Conversion tool, Broadcast Agent, PL/SQL, SQL Server 2005, QTP, Mercury Load
runner, TOAD, Windows 2000,
The Tile Shop, MN (January ’06 – February’07)
Domain: Retail Industry
Business Intelligence Analyst
The Tile Shop uses Business Objects XI to analyze sales, inventory turns, order fulfillment metrics, financial
expenditures, and marketing initiatives to help execute an aggressive growth strategy for the chain in the
coming months and years.
Responsibilities:
Coordinated the Complete Implementation of Business Objects XI as a Analytical & Reporting
solution
Converted Business requirements to meaningful data to serve the purposes of reporting, analysis,
forecasting & to drive the company’s strategic decisions.
Oracle e-business suite was used to handle the HRMS/SCM operations & Business Objects was
used to report off the data from the OLTP system(s).
Created reports with Multi-Level Scope of Analysis using drill down, drill across, drill up and slice
and dice by using different levels of hierachies
Analyzed store-by-store profitability and product performance to submit reports to business analysts &
end-users.
Worked extensively with @functions like @select, @prompt, @where and @aggregate_aware to
write flexible SQL queries.
Used design specifications drafted from CA’s ERwin Data modeler 7.1 ( Data modeling tool)
Enhanced existing universe to add more classes & objects for querying & reporting purposes.
Created complex Crystal Cross – Tab Reports, Parameterized Reports, Sub-Reports which contain
several Date and time Formulas, Conditional suppression, Conditional Grouping which uses
multiple data sources.
Tracked KPI’s (key performance indicators) by department to create interactive dashboards for
higher management using Crystal Xcelsius.
Worked extensively with the major functionality of Business Objects like Breaks, Ranks, Alerter,
inserted calculations, Filters, Sorts, and Query Prompts
Extraction, Transformation & Loading processes were done using Informatica
Used Informatica Powercenter to build & maintain projects, data flows based on the requirement.
Involved in the design, development & implementation of a UI tool using Web I & BO SDK
Used Broadcast Agent Publisher and Scheduler to publish and schedule reports.
Involved in Unit testing and created test cases for UAT for all reports and created documentation for all
reports.
Involved in users training, providing technical support and resolved issues like bug fixing, updating
with patches by dealing with Business objects technical support team directly.
Environment: Business Objects XI, Informatica Powercenter 7.1.4, Crystal Reports XI, Crystal Xcelsius, DB2
UDB v 7.1, SQL, ERwin 7.1 Data modeler, Oracle 9i, Windows NT/2003, UNIX
Wachovia Wealth Management, PA (March’05 – December’05)
Domain: Banking and Financial Services
Business Objects Report Developer
This project was mainly related to “Home equity loans”, “Personal & Business Loans”, “Cash Management”.
Data existed from different customers had to be executed in various formats for use by Business Analysts.
Reporting was the primary task, and each report had to be customized according to custom templates and
specifications given.
Responsibilities:
Interacting with Business Users and Business Analysts to understand and document the requirements
and Built Universes for end user reports generation using Business Objects 6.5 designer.
Created/Added classes & objects according to requirements.
Conducted an extensive analysis between Business Objects Data Integrator 6.5 & Informatica
7.1.4 for ETL Operations.
Performed integrity check & Checked the cardinalities, Joins of existing universe(s)
Extracted data from heterogeneous source systems & Designed Transformations using
Informatica Powercenter
Designed and developed the data transformations for source system data extraction; data staging,
movement and aggregation; information and analytics delivery
Worked with universes and Free Hand SQL as the main data providers.
Worked extensively with the major functionality of Business Objects like Breaks, Alerter, Filters, Sorts,
Query Prompts and Drill filters.
Resolved Loops and Traps using the functionality of Aliases and Contexts.
Used the Slice and Dice feature, set variables, alerts and group values in the reports.
Used the Drill Down/up function to analyze data and created multiple charts in Reports.
Created, managed and formatted standard reports, master/detail reports and cross tab reports using
Business objects.
Created Report Templates for consistency in the look and feel of the reports
Used SQL Loader to load flat files into oracle database and used PL/SQL stored procedures and
functions to a format data for the end-user report requirements.
Creating Complex reports according to the region/country/business on Demand and exported them to
the corporate repository.
Environment: Business Objects 6.5 (Designer, Supervisor),BO Data Integrator 6.5, Informatica Powercenter
7.1.4, Web Intelligence, Broadcast Agent scheduler & Publisher, Crystal Reports & Xcelsius 4.5, DB2, SQL,
PL/SQL, UNIX.
ICICI Securities, India (Jan’ 04 – Feb’05)
Domain: P&C, Insurance
Business Objects Report Developer
This Project involved the design & maintenance of Business Objects Universes, along with creating
canned & ad-hoc reports for business users based on the requirements.
Responsibilities
Created reports using Business Objects 6.5 using functionalities like slice and dice, drill down,
@functions, cross tab, master/detail tables, formulas and etc.
Designed reports with complex variables, multiple breaks, and sorts to meet the user requirements.
Flat Files acted as a source system to convert/analyze and validate data before it was loaded onto the
DW for reporting purposes.
Used Prompts in the reports as well as the Universe to create more interactive reports for the users.
Created complex reports using cascading prompts, decode objects and etc.
Extensively used page breaks for and section breaks for better & neat presentation.
Generated Ad-hoc reports as per request(s) from business users & exported them to the portal to
be viewed by users.
Used Stored-Procedures as data providers in canned reports scheduled to be delivered to a large
number of recipients.
Created Drill Down reports to examine a stock’s historical values & trends.
Trained team members on topics in reporting, Scheduling & trained end users to generate reports.
Environment: Business Objects 6.5, Windows 2000, SQL Server 2000, IBM DB2 for z/Os
Wipro Technologies, Chennai, India (Oct’ 01 – Jan’ 04)
Domain: Insurance (P&C)
Business Objects Report Developer
Wipro technologies, headquartered in Bangalore, India are one of the largest IT Services Company in terms
of size and revenue. This project is for a Fortune 500 telecom client of wipro, aimed at maintaining and
enhancing the current reporting system.
Responsibilities:
Responsible for Maintenance & Support of IVR (Interactive Voice Response) System reports and
Universe.
Collecting Requirements from the IVR team, Analyzing, Documenting, Building, exporting Universe to
Repository.
Responsible for the data quality in IVR reports.
Scheduling the reports through BCA, Monitoring and Converting Reports to PDF.
Demonstrated the reporting capabilities of Business Objects to business users & trained them on
various techniques used to build reports.
Created different types of reports like Master/Detail, Cross Tab and Chart.
Used Slice and Dice and Drill down functionalities.
As a part of report development created the reports using universes as a main data provider and using
the Powerful business objects functionalities like @ functions, user response and formulas
Used Prompts in reports to create more interactive reports for the Users
Established user groups and users and assigned privileges.
Environment: Business Objects 5.1.9, SQL Server 2000, MS Office, Windows NT.
Education:
Bachelors in Computer Science & Engineering
Contact this candidate