SUMMARY

• Nine + years of experience in Business Intelligence Development solutions using Crystal Reports and Business Objects 4.2/4.1/4.0/XIR3/R2/6.5/6i/6.0/5.X (Designer, CMC, WEBI, Tableau 10, Web Intelligence, Desktop Intelligence, Import Wizard, Crystal Reports XI, Crystal Xcelsius, Info View).
• EPIC Certified (Clarity, Tapestry AP Claims) report developer.
• Experienced in Business Intelligence/Business Objects (BI/BO) enterprise solutions that include Business Objects architecture, AWS Redshift, software deployment, Business Objects administration, Security, Universe/Report/Dashboard development, documentation, Production Support and user training.
• 5 years of experience in people soft HRMS v7.5/8.0/8.3 & v 8.9.
• Has good understanding of Functional and Technical aspects of various modules in PeopleSoft HRMS - HR, Payroll, Time & Labor and Base Benefits.
• Proficient in People Tools - Application Designer, Application Engine, Upgrade Assistant, Component Interface, Integration broker, Security Administrator.
• Extensive experience wif Universe design, Web Intelligence, Desktop Intelligence, creating ad-hoc reports and archiving reports along wif performing User acceptance testing and Data accuracy test.
• Strong understanding of the principles ofData warehousing, Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Expert in MS SQL Server suite of products me.e. SSRS (Reporting Services), SSAS (Analysis Services) and SSIS (Integration Services).
• Extensive experience using Crystal Reports, Performance Manager, Crystal Xcelsius, Live Office, QaaWS.
• Good experience in Data Warehousing technologies using Informatica Power Center Star Schema modeling, Snowflake Schema modeling, MS Access.
• Experience in migration of Business Objects.
• Proven abilities in generating complex queries by linking data from multiple data providers using free hand SQL, PL/SQL, Stored Procedures, Triggers, Functions and packages besides writing DDL, DML, DCL, and transaction queries wif development tools like TOAD.
• Thorough knowledge of different RDBMS like Oracle, SQL Server, DB2 and Sybase.
• Strong knowledge in all phases of Software Development Life Cycle (SDLC).

TECHNICAL SKILLS

Reporting Tools: Business Objects BO 4.2/4.1/4.0/XIR3/R 2/6.5/6.0/5.1 (Designer, Web Intelligence, Desktop Intelligence, CMC, Dashboard Manager, Crystal Reports XI, InfoView, BI Launch Pad, People Soft v 7.5/8.0/8.3 & v 8.9, BO Live Office, Import Wizard), Crystal Reports 2008/XI/10/9.0, SSRS, Cognos.

ETL: Ab Initio, Informatica 7.1, Data stage, SSIS.

Languages: C#.Net, Oracle Pl/SQL, NET Platform, VB, C, C++, Java, XML, AS/400.

Internet Technologies: ASP.Net, HTML, JSP.

Scripting Languages: Java Script, VB Script, Unix Shell scripts.

Databases: Oracle 10g/9i/8i, Teradata 14.0/14.1,MS SQL Server 2008/2005/2000 , Informix, DB2 UDB 7.x/8.x, DB2, MS Access, Teradata v2r6/v2r5/v2r4.

Databases Tools: TOAD, SQL Navigator, Quest Central, MS Sql Server Management Studio, SQL Assistant.

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Developer

Responsibilities:

• Responsible for development of National Financial reports consists of various regions like HI, NW, MAS, SCAL, NACL and CO as a part of KPIT’s financial reporting team.
• Developed and maintained National Universe in UDT for all the regions to source the Financial Reports.
• Involved in Design, Development, Testing, and Enhancement of PeopleSoft HRMS for HR, Payroll and Base Benefits modules.
• Worked and Developed Report on Aging of AP Claims wif logic of going back last 13 months for Business to check how long the claims status is in Pending.
• Modified, designed, configured and built fields, records, sub records, setting up keys to records, assign table edits like prompt table.
• Developed Ad-hoc Reconciliation Reports as per request of the business users for their Financial month-end Closure.
• Developed number of interface reports using SQR to read the data from file and load it into PeopleSoft tables and send data from PeopleSoft to other external applications.
• Supported the Multi source universes using IDT sourcing the Financial Reconciliation reports.
• Extensively worked in the project of UpgradingBusiness Objects universes and reports from versionXI 3.1 to 4.1.
• Involved in Unit testing of people soft delivered and modified functionality & customized SQR programs using HR, Benefits and Payroll Modules.
• Used Webi rich client to validate local connections and to pivot the reports from one universe to other across multiple regions.
• Created Rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.
• Worked on Versioning of reports to keep track of the changes made to the reports.
• Created BIAR Files in CMC for Migration of Reports and universes.
• Created TNS Entries and ODBC system DSN’s to connect to various reporting databases.
• Participated in the evaluation of business requests and/or modifications.
• Responsible for interaction wif business stake holders, gathering requirements and managing the delivery
• Connected Tableau wif share-point portal and setup auto refresh feature.
• Created Visualization for logistics calculation and department spend analysis.
• Generate KPI for Customer satisfaction Survey results and disease management.
• Maintained Test log and wrote test Evaluation, Summary Reports.

Environment: Business objects 4.2/4.1,XI 3.1,4.0, IDT, Crystal 11,Tableau 10,Info View, DB2,Business Objects Designer, BO Web Intelligence 3.1 UNIX, Windows 2003/NT, Oracle 10g, SQL Server 2008, Universe Designer, Information Design Tool (IDT), People soft 8.9,Web Intelligence, Explorer, Design Studio Windows Active directory 2003/2008,AWS Redshift, Windows server 2003/2008/2008 R2/2012R2, SQL server 2003/2008R2/2012/2014, and Microsoft Office 2010/2013, Epic Clarity, Epic Hyperspace, ECI Oracle 11.2, and Toad, SQL developer.

Confidential

Business Intelligence/Tableau Developer

Responsibilities:

• Extensively worked in the project of UpgradingBusiness Objects universes and reports from versionXI 3.1 to 4.0.
• Creation of metrics, attributes, filters, reports and Dashboards created advanced chart types, visualiazation and complex calculations to manipulate the data.
• Installing, configuring and administering the Business Objects 4.0 SP6 environment.
• Designed and maintained Universes using different schemas in the Oracle Database.
• Used Model Mart of Erwin for TEMPeffective model management of sharing, dividing and reusing model information and design for productivity improvement.
• Detected cardinalities, loops, and checked the Integrity of Universes.
• Created custom hierarchy in Universe using BO Designer.
• Created and refreshed quarterly Dashboard using SAP Business Objects Xcelcius Dashboard and Live office.
• Used Crystal Report XI Enterprise to design the front-end reports.
• Created classes, subclasses and objects including complex measure objects according to the business requirements from the Universe schemas and database tables.
• Modified the existing Universes by merging different Classes and resolving the Loops and Chasm Traps by context.
• Created and reviewed the conceptual model for the EDW (Enterprise Data Warehouse) wif business users.
• Analyzed the source system (JD Edwards) to understand the source data and JDE table structure along wif deeper understanding of business rules and data integration checks.
• Identified various facts and dimensions from the source system and business requirements to be used for the data warehouse.
• Created the dimensional logical model wif approximately 10 facts, 30 dimensions wif 500 attributes using ER Studio.

Environment: Tableau, Business objects 4.0, XI 3.1, IDT, Erwin r7.1, Crystal 11, Info View, DB2, Business Objects Designer, BO Web Intelligence 3.1 UNIX, Windows 2003/NT, Oracle 10g, SQL Server 2008.

Confidential, MN

Business Objects Admin/ Tableau Developer

Responsibilities:

• Inventory, Accounts Payable and Purchase Orders were the different subject areas wifin the data warehouse.
• Used advanced universe functionalities like Derived tables, Index Awareness, custom LOVs.
• Created Info providers & BEx queries to simulate/validate results achieved from Design Studio reports. Architected the Re-org of BW objects to maintain standards.
• Created custom hierarchies to aid in Drill-Through analysis of WebI documents and built cascading prompts.
• Participated in the complete development lifecycle: analysis, design, build and test reports.
• Created custom cloud formation scripts for automation and deployment of Windows CRM, SharePoint 2013 and RSA Archer platforms in AWS.
• Published and Migrated reports in Development/Test to Production Domains.
• Created Standard Reports, Cross-tab Reports, Sub Reports and Drilldown Reports using Web intelligence/Crystal Reports XI.
• Administered DB2 subsystems in Prod, Test and Development regions.
• Displayed pie charts, bar graphs more understandable for top-level management using Analyzer in the Crystal Reports.
• Created Solutions according to User requirements using SAP ECC and BW data sources.
• Designed Crystal reports for daily and monthly reports.
• Created hyperlinks to link between reports.
• Provided architecture guidance for selected AWS customers, assessing migration feasibility and deployment strategy based on AWS Architecture best practices
• Worked on Data Warehousing technologies using Informatica Power Center and data stage Star Schema modeling, Snowflake Schema modeling, MS Access.
• Performed extensive GAP analysis in the project as their were numerous 'As-Is' and 'To-Be' conditions.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Planned and designed web services using QAAWS to fed Xcelsius as a data provider.
• Extensively used QaaWS to query from Universes.
• Experience developing and supporting Invoice Reports including Time and Materials.
• Performed data maintenance using LOAD, UNLOAD, REORG, RUNSTATS
• Writing Custom SQL for reports performance in DB2, Oracle and MS Sql.

Confidential

Production Support

Responsibilities:

• Involved in Design, Development, Testing, and Enhancement of PeopleSoft HRMS for HR Payroll and Base Benefits modules.
• Involved in testing the reports while migrating fromXI 3.1 to 4.0.
• Involved in Unit testing of people soft delivered and modified functionality & customized SQR programs using HR, Benefits and Payroll Modules.
• Modified, designed, configured and built fields, records, sub records, setting up keys to records, assign table edits like prompt table.
• Performed extensive GAP analysis in the project as their were numerous 'As-Is' and 'To-Be' conditions.
• Involved in creating database objects like tables, views, procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Designed and maintained Universes using different schemas in the Oracle Database.
• Used Model Mart of Erwin for TEMPeffective model management of sharing, dividing and reusing model information and design for productivity improvement
• Detected cardinalities, loops, and checked the Integrity of Universes.
• Created custom hierarchy in Universe using BO Designer.
• Created and refreshed quarterly Dashboard using SAP Business Objects Xcelcius Dashboard and Live office.
• Created classes, subclasses and objects including complex measure objects according to the business requirements from the Universe schemas and database tables.

Environment: Crystal 11, Business objects 4.0, XI 3.1,4.0, Info View, Business Objects Designer Studio, BO Web Intelligence 3.1 UNIX, Windows 2003/NT, Oracle 10g, DB2 10.5, SQL Server 2005, Crystal Reports, People soft v 8.3/v7.9 Xcelsius, AWS Redshift, QaaWS, CMC, BO Data Service 3.1, ASP.NET, C#, HTML, XML, ERWIN, MS OFFICE, Visio, JIRA, Subversion.

Confidential

Responsibilities:

• Installing the Business Objects 4.0 SP04 on the server and setting up the environment, and configuring Secure Socket Layer (SSL).
• Involved in project planning sessions wif project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
• Extensively worked on Crystal and Webi reports for Elections and Addendums in modifying the existing templates and in creating new ones and worked on the functionality to reduce the number of Webi reports needed to a minimum.
• Created Complex reports in crystal using DB2 as Database.
• Experience developing and supporting Invoice Reports including Time and Materials.
• Created pages for selecting addendums and contractors from the list that comes up for a department.
• Worked at conceptual/logical/physical data model level using SAP ECC and BW data sources according to requirements.
• Worked on making changes in the existing queries and renaming them, tan on making the database up to date to make previous versions compatible to the existing ones.
• Extensively worked on Logic behind the Formula fields created and used in Webi reports according to the requirement.
• Tested the templates in 2-tier and 3-tier for different environments like Dev, New, Prod and Training.
• Generated Reports using the Universe as the main Data provider and using the personal data files provided by the users and Free-hand SQL as data provider.
• Worked at conceptual/logical/physical data model level using Erwin according to requirements
• Created New Classes and User Objects according to the requirements.
• Created various simple and complex reports using drill down, filters and alerts.

Environment: Business Objects XI R2, Web Intelligence, Crystal Reports XI R2,, Design Studio, SAP Luminar, Xcelsius, Oracle SQL Developer, Oracle 10g,DB2 10.5,PL/SQL, T-SQL, SQL SERVER 2008, Info Advantage, AMS,ERWIN,Advantage, Java, J2EE Business View Manager.

Confidential

Business Object Admin/Developer

Responsibilities:

• Development of the Advance Clinical System using Crystal Reports.
• Created nested and conditional groups and formatting features in reports.
• Created New Classes and User Objects in designing the universes.
• Created reports like Slice and Dice, Drill Down, Combined Queries, Functions, Cross Tab, Master Detail and Formulae for easy-to-use benefit information system by using Webi.
• Created Solutions according to User requirements using SAP ECC and BW data sources.
• Created Linked, Unlinked, Parameterized and On-demand reports for various business needs, reports scheduled for different file based / schedule based events, distributed in email, PDF, HTML, EXCEL, EXCEL2K format.
• Modifying the existing universes, adding new objects editing joins mapping the existing objects wif renamed tables.
• Create/Modify/Troubleshoot Report issues in Webi, Deski and Crystal reports.
• Worked wif modelers on designing a STAR schema for the detailed data marts and Plan data marts involving confirmed dimensions.

Environment: Crystal Server 10/XI, SQL Server 2005/2008, DB2 9.7, T-SQL, Design Studio, Xcelsius, SAP Luminar, Informatics 8, Windows.

Confidential

System Administrator

Responsibilities:

• Analyzed functional specification and business requirements.
• Installed, configured and administered of IBM WebSphere Application Server on AIX/Linux platforms.
• Involved in creation and execution of complex SQL queries and stored procedures.
• Documented, supported, maintained and updated the applications in the Web sphere Application Server environment and implementing load balancing.
• Deployed J2EE applications onto WebSphere managed servers for QA, Pre-Production and Production environments.
• Implemented and used Web Services wif the help of WSDL, SOAP and JAX-WS.
• Developed user interfaces using JSP, Tiles Framework, JQuery, HTML5, CSS3, JavaScript, AJAX and JSTL.
• Created new universes, reports and modified existing universes and reports using Business Objects.
• Involved in design, configuration and integration of LDAP autantication, mapping extended user attributes in the LDAP Directory to Business Objects and applying security

Environment: Web sphere, Web sphere Portal, CSS3, JavaScript, AJAX, JSTL, IBM MQ Series, Web Services, WSDL, SOAP, JAX-WS, JSP, Tiles Framework, Query, Java, J2EE, JSP, ESB, WSRR, WODM, JSTL, AJAX, Web logic Portal, LDAP, DNS, SSH, DHCP, HTTP, NFS,TCP/IP, LAN, WAN, RMI, Oracle, DB2, SQL Server, Business Objects, Windows, Linux, AIX.