Project Data
Resume:
NEERAJ WALIA
*****.******@*****.***
Summary:
. 10+ years of IT experience design, development and testing of
relational database applications, Data-Warehouse/Data-Mart, Data
Migration, Data Conversions, ETL, design development, Performance
Tuning, Application Development and product support on various
platforms
. Specialized in Business Intelligence technologies & tools like
Business Objects Enterprise Suite 4.0/3.1/XIR2/5.x/6.0, Crystal
Reports, and OBIEE.
. Experience in Data Modeling and working with Physical and Logical Data
Modeling
. Proficient in working in environments (development test, production)
in different RDBMS (Oracle, Sybase etc)
Technical Skills:
Business Business Objects 4.0, 3.1, XI-R2/6.x/5.x, Crystal Reports,
Intelligence Xcelsius Dashboard,
Oracle Discoverer, OBIEE, Explorer
Data Modeling Oracle Designer, Visio, Rational Rose
ETL Tool Informatica, Business Objects Data Services
Languages SQL, PL/SQL
Web HTML, XML
Technologies
RDBMS Oracle 8i/9i/10g, Sybase 12.5
Education:
. Masters in Systems Engineering, Oakland University, Michigan.
. Bachelors in Computer Science and Engineering, Oakland University,
Michigan.
Certification:
. Project Management Professional, PMP
Training:
. Informatica Level 1 Developer training.
. Oracle BI Suite EE 10g R3.
Projects Information:
Guident Technology May
2010 - Current
Role -Team Lead/Architect
Project - US General Services Administration (GSA)
December 2011 - Current
Business Intelligence EDW Support team is responsible for Operations and
Maintenance of EDW data warehouse and Business Objects Enterprise Suite.
Responsibilities
. As a Technical lead, architect the Dashboard solution to provide
Dashboards to the client with ease and quickly. It involves creating
and modeling a new Data Mart, adding tables, ETL designs and BO
Universe.
. Performance tuning methods are incorporated to lower the response time
of Dashboards. Methods include but not limited to creating aggregate
tables in the data mart, creating independent Dashboard Services in
CMC, assigning resources to Dashboard Services, table indexing, query
optimization, use of ad-hoc as well as scheduled instances in the
dashboard and use of connections like LIVE Office, Qaaws, Query
Builder, Flash Variables etc depending on situations and business
needs.
. Managed projects like Fiscal-year end project, conversion of Desktop
Intelligence reports to WEBI reports, consolidation of reports into
meaningful few reports etc and provided technical expertise. Also,
assigned roles and responsibilities to the team members and worked on
accomplishing the deadlines.
. Use Agile methodologies on the development projects.
. Evaluation of Business Objects 4.0 tools and worked on the issues,
updating service patch, fix patch and working directly with SAP on
bugs.
. Worked on upgrade to Business Objects 4.0 from BO XI3.1. This
includes server installation, customizations of nodes and setting up
of cluster environment, fixing issues, working with SAP on bugs to
resolving them.
. As Technical Lead/ Administrator, managed Business Intelligence
Helpdesk and work with the team to resolve issues and scheduled
maintenance.
. Technical Training to the Developer and power users, introducing new
tools and features of BO 4.0. This includes preparing training
materials, presentations and giving live demos to the groups.
. Work on Central Management Console (CMC) and Central Configuration
Manager (CCM) for various administration related activities,
performance tuning and rebuilding nodes.
Environment: Oracle 10g, Business Objects 4.0, BOXI Rel3.1 (Desktop
Intelligence, Crystal Reports, CMS, CMC, Import Wizard, Universe Designer,
Dashboard Designer (Xcelsius)), PVCS version control.
Project - United States Patent and Trademark Office (USPTO)
May 2010 - November 2011
Operation and maintenance of EDW data warehouse, new development projects
involving new schema design, Business Objects Universe and Reports.
Responsibilities
. Managed maintenance projects and successfully completed the projects
within deadlines. Worked with the team of 8 to 10 people. Used
Microsoft project to track the project items.
. Worked as an Administrator/Developer and managed Business Objects
Helpdesk, including responding to the issue tickets, research on bugs,
manage servers etc.
. Consolidated 84 Web Intelligence reports into 4 Business Objects
reports by using various functionality within WEBI reporting tool like
analysis contexts.
. Understood Business process and users requirements and developed
highly customized Web Intelligence report that saved user 4 hours of
manual work every day.
. Worked on Adhoc user requests as part of helpdesk, data analysis,
reporting, access errors etc.
. Worked on performance tuning of the reports by analyzing report query,
requirements, filters etc. Performance tuning of the database tables
like indexing, partition etc. Depending upon the report requirements
Views or materialized views were created.
Environment: Oracle 10g, BO XI Rel3.1 Suite (Desktop Intelligence, Crystal
Reports, Central Management Server, Central Management Console, Auditor,
Import Wizard, Universe Designer, Xcelsius), PVCS version control
Grant Thornton
Feb 2009 - April 2010
Role - Senior Consultant
Project - Veterans Benefit Affair: Performance and Analytic team
responsible for the Data warehouse, reporting and maintaining the database
and answer adhoc queries from the user.
Responsibilities
. Analyzed business requirements and developed new database schema for
the work-study group and 15 new Oracle discoverer reports based on new
schema that will provide the summary and detail figures to the
management.
. Design new physical and logical data model for the work-study schema
using the Oracle Designer. The new model is based on the Star schema
methodology. Created of the fact and dimension tables in the database
as per design specifications and defined constraints on the tables.
. Loaded data in the tables by creating Informatica Mappings and
Workflows.
. Testing and validation of the data in the database tables by running
SQL queries against the source tables and comparing it against the new
work-study tables. Designed new web page to display reports using
Oracle portal.
. Deployment and maintenance of reports, end user layers and business
areas to the Test, Pre-production and production environment for
testing and UAT testing.
Environment: Oracle 10g, Discoverer, OBIEE, PVCS version control
Fannie Mae, Reston, VA
Sept 2006 - Jan 2009
Role - Business Intelligence Developer
Project Details -Automated Underwriting Business Intelligence Team was
responsible for development, analysis, testing and maintain of over hundred
and fifty reports, universes and dashboards.
Responsibilities:
. Converted over hundred and fifty BO 6.5 reports into BO XI R2 Desktop
Intelligence or Web Intelligence reports.
. Designed and maintained production Universes and its data dictionary.
. Developed new Dashboards using Xcelsius for various business groups
for example Operational metrics dashboard, Credit Dashboard, AU
Metrics Dashboard, Weekly Dashboard, Monthly Dashboards etc.
. Worked on the upgrade of Business Objects 6.5 to Business Objects XI
R2. It involved conversion, development and testing of Reports and
Universes and documentation of the steps involved in migration.
. Conducted BO XI R2 migration meetings and discussing the project plan,
business requirements and goals of the project.
. Supported 350 Business Users with their issues on BO environment, ad-
hoc report requests and issues.
. Wrote Technical Design Documents for all the Reports and Universes and
creating their Mock Ups.
. Trained Business Users on using various BO tools. Also, gave
classroom sessions in Business Objects reports.
. Created reports using Free Hand SQL. Working on SQL tuning and
optimization of the Business Objects reports. Redesigning of the Info
View in the new BO XI R2, to make it more user friendly.
Environment: Oracle, Business Objects XI Rel2 Suite (Desktop Intelligence,
CMS, CMC, Auditor, Import Wizard, Universe Designer, Dashboard Manager,
Crystal Reports, Web Intelligence), Clear case, Clear Quest, Sharepoint.
Blue Care Network, Southfield, MI
Sept 2005 - August 2006
Role - Advanced Application Developer
Medicare Advantage: allows members to get health care, including
prescription drug coverage at a significantly lower cost. Many existing
Reports needed changes and new reports were developed and developed to
production.
Responsibilities
. Gathered requirements from business user for new reports or modifying
the existing reports.
. Created Web Intelligence and Desktop Intelligence reports usng
Business Objects XI. Worked on creation and modification of the
universes (Billing, Provider, Experience Reporting, Claims, and Care
Management) and various reports related to them.
. Software development life cycle SDLC was followed for the development
projects.
. Resolved linking table linking issues like "chasm trap" and "fan trap"
using Alias and context.
. Run queries using SQL Advantage in Sybase for analyzing data for
different reports.
. Developed new Crystal Reports as per the Business Requirements and
converted Crystal Reports to Business Objects Web Intelligence reports
as per the business requirements.
. Business requirement documents, Technical design documents were
written and Mock-ups were designed.
. Created new Views and Aggregate tables for report performance.
. Built test cases for reports testing and provided guidance to testing
team in their testing.
Environment: Sybase, SQL Server 2005, SQL Advantage, BO XI Rel2 Suite, Data
Integrator, PVCS version control
Chrysler, Detroit, MI
Jan 2003 - August 2005
Role - Application Developer/Analyst
This project was for testing new product, collecting data and making
improvements to make it a more efficient system. Testing, data gathering
and analysis was major part of the project.
Responsibilities
. Reliability Growth Study in DaimlerChrysler Transport Center. Fleet
of 400 trucks managed by DaimlerChrysler Transport Center, was
studied, analyzed by data collecting and building reports and
metrices.
. Created baseline for the fleet by collecting data of maintenance
history and calculated Mean Time Before Failure, Mean Time To Repair,
parts cost, labor cost and mean miles between failures.
. Automated the Maintenance and operational metrics to produce monthly
reports for top performing trucks.
. Built Business Objects reports showing operating metrics for the fleet
based on the data gathered and metrics.
. Communicated on personal level to different mechanics, supervisors and
vendors to figure out the requirements for the process and documented
it.
. Built and documented a step by step warranty claiming process that
resulted in savings of over $100,000 in one quarter for the company.
. Studied the PM scheduling of DCTI fleet and analyzed the ways of cost
cutting without sacrificing the service.
. Proposed new PM scheduling that would save trucks extra trip to the
maintenance shop and that would be a huge cost benefit as it saves
labor hours and increases operational hours.
Environment: Microsoft Office, Business Objects 6.0 (Designer, BO Reports,
Dashboards )
Contact this candidate