SUMMARY

• Over 10 years of Experience in Software Development life - cycle and implementing Data Warehouse, Business Intelligence, Client/Server Technologies and E-Commerce Applications for Financial, Insurance, Banking, and Production systems.
• Experienced in Translating Business needs into end-user reports with Business Intelligence Tools like Business Objects, Crystal reports and Crystal enterprise.
• Data warehousing experience in Data Modeling, Data Extraction, Data Integration, and Data Mining for Decision Support System as a Data Warehouse Developer using ETL and OLAP tools.
• Strong Experience in Logical and Physical Data Modeling using Erwin tool including Star Schema and Snowflake Schema, designing of Data Mart, Fact and Dimension Tables.
• Strong experience in RDBMS (Oracle, SQL Server, and MS Access).
• Excellent in coding using C, C++, ASP, .net, Visual Basic, Java Script, VB Script.
• Expertise in writing and implementation of the Packages, Triggers, Stored Procedures, Functions, Views, Materialized Views, Indexes at Database level and Form level using PL/SQL and Oracle.
• Excellent Programming skills using Shell scripts and PL/SQL for Automation of ETL process.
• Excellent knowledge in Batch Jobs using UNIX CRON, AWK, UNIX Shell Script (csh, bash, ksh) and PERL Scripts.
• Good experience especially in the domain areas of E-Commerce and Client/Server technologies using Visual Basic, ASP, COM/DCOM, XML, MTS, Developer 2000, MS SQL Server and Oracle.
• Clear understanding of business procedures and ability to work as an individual and as a part of a team.
• Excellent analytical and logical programming skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals

TECHNICAL SKILLS

ETL and Reporting: SAP Data Services, Ab Initio, Business Objects, Crystal Reports, Crystal Enterprise, Tableau, Power BI, Alteryx.

Data Modeling: Erwin 3.5/4.0

Languages: Java, C++, C, C#, SQL, PL/SQL, PERL 5

Web Technologies: Python, ASP, VB script, JavaScript, JAVA 2.0, EJB, JNDI, Servlets, JSP, XML, JDBC, Java Beans, HTML, jQuery, RMI, CORBA

Databases: SAP HANA, Teradata, MongoDB, MySQL Server, Oracle, MS/SQL Server, DB2UDB, Red Brick 5.1, Kognitio, Infobright.

Enterprise Planning Software: Cognos Financial Planning 8.4

AWS Cloud Services: EC2, VPC, S3, EBS, Route53, SNS, SQS, RDS, IAM, DynamoDB, Cloud Formation, and Cloud Watch

PROFESSIONAL EXPERIENCE

Confidential - Dublin, OH

BI Platform & Cloud Architect

Responsibilities:

• Designed and Provisioned AWS Cloud BI Solutions leveraging various cloud services EC2, EBS, S3 etc. providing cross geographic performance with CloudFront services with bootstrap scripts AWS CLI for automated provisioning and instance uptimes.
• Architected SAML OKTA based integration for AWS Cloud based BI&A application.
• Ported Teradata DB’s into RedShift using Attunity 3rd part services.
• Implemented the SAP HANA based Sales, COPA and Finance solutions using SAP BO Explorer as front end.
• Implemented SAP HANA as a side car approach to the existing Teradata solution.
• Involved in Design of Analytic Views, Calculation Views and Attribute Views while keeping Row level security of access intact across Sales Force based reporting.
• Involved in leveraging SAP SLT based replication from the source SAP ECC 6.0 system.
• Member of POC team implementing Horton Hadoop for legacy Inventory data from Distribution centers to run predictive analytics on Pick-pack ship.
• Managed implementation of SAP Information Steward and SAP Data Services for Metadata management and lineage analysis.
• Leveraging SAP Information Steward to run Data profiling for greater insight into data and developing cleansing package builder for permanent Data Services transforms.
• Implementation and Administration of SAP Data Services 4.2 system for migration of multiple applications from the legacy AS/400 to the new IBM DB2 solutions.
• Provide Business Objects subject matter expertise; Plan and perform environment
• Consolidation/reduction/optimization; Perform and maintain integration with SAP, SharePoint, Identity Management, and other applications; Provide 24x7 platform support
• Assist the Enterprise Architecture and application teams to design BI solutions; Participate in the design development, testing, implementation and documentation of the solution; Assist in estimating tasks and the preparation of project plans; Install and maintain Linux/Unix environment.
• Solved complex HADR DB2 Databases node failover with Business Objects repository database.
• Provided an automated scripted solution for Business Objects user account issues in a scenario of network get disconnected.
• Managing the Tivoli and MIR3 alerting system for disaster recovery and primary alerting services
• Report development & migration from Business Objects, Canned & Analytical reports for advance analysis ;OLAP cube & Teradata Aggregate structures query design for advanced analytics
• Configured user security and LDAP configuration at the Order Express, Specialty Online, Retain Independent, PYXIS, Yong Yu China etc projects and report level and integrating with Site Minder application, F5 Load Balancer, SDK and mod-jk reverse proxy.

Environment: Business Objects Server & Client Tools, Teradata, HANA Rev 82, SAP Information Steward, SAP Data Services, IBM DB2, Suse Linux, Windows 2000/2003/2008 , Tomcat, Java, XML, Microsoft Project Server, Microsoft SharePoint.

Confidential - Brentwood, TN

Business Objects Administrator / Developer

Responsibilities:

• Involved in end to end implementation of Business Objects XI 3.1 infrastructure architecture installation configuration and software delivery to the business users.
• Installed Business Objects XI 3.1 on 4 different environments including a cluster environment.
• Created and implemented the security model with Windows AD authentication for Business Objects XI 3.1
• Implement Java SDK based solution for Universe Level Security to implement Vendor data access business requirement.
• Implement VB based SDK solution for metadata update of universe objects for end users accessibility as part of quarterly goal.
• Played the role of Project Manager of Business Objects XI 3.1 Upgrade from BOXI R2 environment.
• Designed the strategy of migration cut over planning for the BOXI 3.1 Upgrade.
• Implemented multi-layered backup strategy for Business Objects 3.1. This included BIAR, CMC database and File Repository Servers backup.
• Implemented about 15 multiple universes across multiple data marts.
• Designed complex Xcelsius 2008 SP3 - Live Office/QaaWS based Dashboard for deployment over InfoView
• Xcelsius 2008 Dashboard now forms the cornerstone of Executive Reporting which reports over 6 years of DW data with a small footprint over CPU and memory
• Involved in installing, configuring and development for Oracle-HyperRoll Release 5.1.1 aggregation engine. Streamlined the load processes of the Hyperroll Environment on a daily/weekly/adhoc basis through the Enterprise Scheduler.
• Oracle-HyperRoll was the primary reporting composite data mart of Sales, Inventory, On Order, Replenishment etc which was used for 90%.
• Involved in developing new HyperRoll Definition Files (HDF) for instant reporting through business objects front end with HyperRoll-Oracle heterogeneous services.
• Involved in developing and automating jobs through the Enterprise scheduler in Tidal. The process also involved gathering business requirements and developing the datawarehouse load process around the down time designated by business
• Involved in configuring Business Objects Xi R2 environment, also participated in development of reports on Desktop Intelligence, Web Intelligence and Crystal Reports XI.
• Primary contact for the Business Objects 3.1 R2 upgrade from the previous environment. Involved in the process of reviewing the software with the vendor, arranging a demo with the business team, procurement, formulating the architecture of the new environment, installing, configuring and migration from the earlier environment etc.
• Completed the upgrade of Cognos Planning 7.3 to Cognos Planning 8.4 FP 1 was involved in all tasks right from procurement to final delivery of the configured software with the migrated libraries to the new environment while meeting the objectives as defined in the project plan in the defined timeframe.
• Rated as Tier 1 in the first year for quality and timely delivery of projects.
• Involved the assessment (both software and business), design, prototyping, test and delivery of the existing legacy Oracle Forms application into a Crystal Reports 2008 V2 based application which is visible both to vendors and to the Support Centers. Estimated users are about 4000.
• Involved in writing several ETL processes to enable migration and cleansing of data between POS, SAP, E3-Replenishment, Intactix (Planogram Design) systems to the Datawarehouse on a daily/weekly/monthly/adhoc basis based on the requirements using Data Integrator XI R 2 on both Windows and AIX.
• Also involved in maintenance the legacy datawarehouse process designed around Oracle 9i, 10 g with Oracle job scheduler. These processes were automated to an extent using the new development in Tidal Scheduler.
• Involved in training both business users and IT support in the new tools for automation.
• Was critical in designing a new process for Change Control and IT Support Ticket management using the Remedy software while working closely with First Level Helpdesk Support. Helped them get visibility of the data in a simple dashboard format using Business Objects on the Remedy Application Database.
• Was also assigned the role of an Administrator for Source Code Version management System Spectrum for any code moves to production.
• Duties also included being on-call on a rotation basis for any production related issues.

Environment: Crystal Reports 2008 V2, Business Objects Designer 11.5, XIR2, HyperRoll 5.1.1.1, Central Management Services, Central Management Console, Import Wizard, BO-XI Query Builder, Desktop Intelligence, Web Intelligence, BO-XI Instance Manager, PL/SQL, XML, Windows 2000, Windows 2003 Server, Microsoft Project Server, Oracle 9i,10g, Cognos Planning 8.4 FP1, Data Integrator XI, 3.1, Data Services, 3.1 Business Objects Enterprise XI R2, 3.1 SP2, Xcelsius 2008, Live Office, QaAWS.

Confidential, Harrisburg, PA

Business Objects Administrator

Responsibilities:

• Involved in meeting and gathering requirements from clients and creating Sup-Spec’s to be uploaded to e-room a content management site.
• Involved in integrating the Business Objects XI R2 platform to the in house .NET application portal with SSO.
• Involved in installing,configuring and daily administration actives of Business Objects XI R2 Enterprise system for DEV,QA, PROD environment deployed over ISS Web Server.
• Involved in performance tuning the Web Intelligence and Desktop Intelligence Processing Servers for better response time.
• Involved in maintaining the visual source safe for reporting subsystem
• Involved in maintaining the e-room a share point platform of Microsoft for content management
• Created complex crystal reports with dynamic LOV’s along with complex sub reports.
• Created complex Desktop Intelligence and Web Intelligence reports based on business views
• Designed complex linked Universes for Ad hoc reports
• Involved in designing and creating business views with location based groups to filter user based on their LDAP group association.
• Designed and implemented a normalized method of data population for easy development of ad hoc reports
• Developed highly complex Stored Procedures, Views and also helped in performance tuning using an explain plan for better performance.
• Created a Visual Studio .NET 2003 solution to enable an overnight run of a batch process to run and populate tables used in the reports.
• Involved in scheduling nightly, weekly, monthly run of the batches in the Dollar universe
• Involved in Repository management and migration across development, testing and production environments.
• Involved in clustering business objects servers for a fail over system
• Working closely with the security team to integrate Site Minder Single Sign On authentication with Info view.
• Involved in designing change management processes for Rational Clear Quest administrator around reports testing process
• Also involved in designing pivot table for incident management for better defect tracking.

Environment: Crystal Reports XI, Crystal Enterprise XI, Crystal Analysis 10.0, Business View Manager 11.5, Business Objects Designer 11.5, Central Management Services, Central Management Console, Import Wizard, BO-XI Query Builder, Desktop Intelligence, Web Intelligence, BO-XI Instance Manager, BO-XI Schedule Manager, SQL Server 2005, SQL Server 2000, Microsoft Visual Source Safe 6.0, Rational Clear Quest, Rational Requisite Pro, PL/SQL, XML, Visual Studio .Net 2003, Windows 2000, Windows 2003 Server, Microsoft Share Point Server.

Confidential - Herndon, VA

Business Objects Administrator

Responsibilities:

• Install and Configure Business Objects XI system for ninety crystal report and universe developers.
• Guided the universe developers to in corporate indexing into the object definition for better performance.
• Was on call for support of both systems, for round the clock scheduled reports jobs involved in CIT and SIT testing.
• Involved in managing users, groups, folders and published reports using crystal management console, in exporting and scheduling of reports using Crystal Enterprise and generated WEB Reports by using Reporting Portal.
• Design and development of the complete Decision Support System using Crystal Reports
• Developed various PL/SQL stored procedures, cursors and functions for data input to the Crystal Reports
• Created complicated formula's and running totals for business measure calculations based upon various end user requirements.
• Created various reports like the Combined Queries, Drill Down, Cross Tab, Master Detail to make the reports easier for analysis.
• Generated sub reports, linked and unlinked reports, reports on demand.
• Used prompts to generate Parameterized reports allowing the user to limit the reports to particular cases.
• Raised report alerts when certain conditions are met as requested by the user.
• Involved in creating measures and metrics required in Crystal Analysis Reports (CAR) for slicing and dicing.
• Exported the reports developed using the Crystal Reports to the Repository.
• Scheduled the reports, maintained the events, set permissions using Crystal Management Console.
• Created nested and conditional groups and formatting features in reports
• Published reports on web using the e-Portfolio to make the reports available on the web.
• Performed data validation using validate components and Sample Component

Environment: Crystal Reports 10.0, Crystal Enterprise 10.0, Crystal Analysis 10.0, Erwin 3.5.2, HTML, VB 6.0, ASP 2.0, IIS 4.0,Oracle 8i/9i, MS Access, SQL Server 2000, ODBC, ADO, SQL Query Analyzer, SQL* Loader, PL/SQL, XML, Sun Solaris 2.8, Windows NT, UNIX

Confidential - Jacksonville, FL.

Crystal Reports Developer

Responsibilities:

• Developed several Complex Reports (include multiple groupings, drilldowns, parameter fields, formulas and retrieving data from more than one database) using Crystal Reports.
• Involved in gathering Business Principles and standardization for reports.
• Worked on complex reports that require running totals, sub-totals, sub-reports, cross-tab, multiple groups and conditional display of groups, fields, and messages.
• Created number of formulae, running totals conditional display of fields for complex calculations and used them in different sub reports, container reports.
• Created design for running multi flavor reports like - Date,Weekly and Monthly as well.
• Experience in Data Modeling, Data Extraction, Data Migration, Data Integration, Data testing and Data Warehousing using Crystal Reports.
• Involved in the operations for migrating legacy data from old system to Oracle database.
• Involved integration of reporting portal with the company Intranet. Involved in creating the custom web pages using HTML, JavaScript, Visual Basic and ASP.
• Involved in displaying data from legacy systems and relational databases and also in creating, modifying reports using tables, views, functions and stored procedures.
• Created and Tuned complex Stored Procedures for faster execution.
• Published reports using Crystal Management Console, in exporting and scheduling of reports using Crystal Enterprise and generated Web Reports by using e-portfolio.
• Developed required SQL scripts for database testing using SQL and PL/SQL. Extensive experience in Database Testing on Oracle.
• Involved in customization of the Web Reporting portal using HTML, Java Script and ASP.
• Scheduled the report by setting the run-time parameters and charted by customizing the options.
• Involved in unit testing, Integration Testing and UAT testing of the crystal reports generated. Developed user guide for the web-reporting portal.
• Involved in production support and user support for the implemented reports in production.
• Provided guidance/training to Application Users.
• Prepared timely and accurate financial modeling scenarios to assist network management with provider network strategies.
• Created detailed analytical information to support critical decision-making in contract negotiations with providers
• Communicated with various business units to ensure consistency with enterprise reporting standards and financial goals while utilizing advanced information access tools and relational database software.
• Worked closely with the Provider Contracting department in assisting with open negotiations including review of contract terms and implementation of standard model contract agreements while assisting network managers in understanding key modeling points, issues, and financial impact of new legislation.
• Assisted in the preparation and distribution of internal financial reports, including division reporting.
• Prepared internal supplemental reports for the technology services companies.
• Prepared and distributed the internal financial reports.
• Participated among cross-functional teams in projects related to understanding and improving the business and financial performance of the company.
• Prepared ad hoc supporting documentation for senior financial management.

Environment: Crystal Reports 10.0/ XI Crystal Enterprise 10.0/XI, Visual Basic 6.0, HTML, Java Script, ASP 2.0, ODBC, ADO, IIS 4.0,Oracle 8.1.6, DB2 UDB 8.0, SQL Server 2000, SQL* Loader, PL/SQL, Sun Solaris, and Windows 2000