SUMMARY

• 8 years of Experience in IT including End - to-End Implementation of Siebel Analytics/Oracle Business
• Intelligence Enterprise Edition (OBIEE), Oracle BI Applications, Data Warehousing, Informatica, RDBMS, UNIX and IBM Mainframe.Over 7+ years of experience in Siebel Analytics (OBIEE) and ETL (Informatica).
• Strong retail domain knowledge in TMS and WMS applications. Managed huge transportation systems with 24X7 Oncall support model for Suite of Manugistics (TMS-JDA), Red Prairie (WMS-RP), OTM (TMS-oracle), FTI (OBIEE) products.
• Experience with complete Life Cycle with Agile methodology (gathering Business Users Requirements, Analysis, Design & Modeling, Development, and Testing) of Business Intelligence using Oracle Business Intelligence (OBIEE)/ Siebel Analytics.
• Data warehousing experience using Informatica Power Center 7.1 (Designer, Repository Manager, and Workflow Manager).
• Implemented BI solutions in various domains suchas Financial, Transportation, and Audit worked on end to end implementation ofBI APPS.
• Involved in development of Agents, Events and Mile stones (OTM).
• Involved in system reconciliation whenever system outage occur
• Expertise in Building Metadata Model (.rpd), Building Physical layer, Business Model and Mapping layer, Presentation layer using Oracle BI Administration tool along with development of dynamic and interactive Dashboards.
• Worked extensively on Siebel Analytics Administration Tool, Siebel Analytics Web, Answers (AdHoc), and Interactive Dashboards.
• Extensive experience in providing end-to-end business intelligence solution by dimensional modeling design, building business models, configuring metadata, Answers, Delivers / iBots, creating reports / Dashboards, cache monitor, and building Siebel Analytics Repository consisting of three layers (Physical Layer, Business Model & Presentation Layer) using Siebel Analytics.
• Experience in configuring Interactive Dashboards with drill-down capabilities using global and local Filters, Siebel Security Setup (groups, access / query privileges), Metadata Objects and Web Catalog Objects 3(Dashboard, Pages, Folders and Reports).
• Experience with various databases like DB2, VSAM, Oracle and SQL Server.
• Strong skills on transforming data from heterogeneous sources like flat files, Oracle to Data Warehouse using ETL Tool Informatica.
• Expertise in complete life cycle of Design, Development, Maintenance and Documentation of various functionalities of Data Warehouses and Data Marts.
• Expertise in OLTP/OLAP System Study, developing Database Schemas like Star schema and Snowflake schema.
• Very good understanding of Business Intelligence and Data Warehousing Concepts with emphasis on Analytical Reports and ETL.
• Expertise in Performance Tuning of Data Warehouses by implementing the materialized views, advanced database features.
• Experience in merging and migrating OBIEE repository content and web catalogs in development, testing and production environment.
• Proficient in working on production and development environment in different RDBMS (in Oracle 8i/9i/10g/11g, SQL Server) and strong troubleshooting skills.
• Extensive experience in business process reconciliation, design, configuration, testing, quality analysis and production support.
• Expertise in creating Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Designed complex mappings using Normalizer, Aggregator, Updated Strategy, Lookup, Joiner and Stored Procedure Transformations.
• Familiar in PL/SQL Procedures, Packages, Functions, Triggers and other objects
• Experience in performance tuning of sources, mappings, targets and sessions. Developed ETL migration procedures, production standards.
• Excellent verbal / written communication skills coupled with strong Organizational & Analytical Skills with the ability to perform effectively in a Team.

TECHNICAL SKILLS

Oracle Applications: OTM 6.1.X, OBIEE 10.1.3.X/11

Database: DB2, Oracle 9i&10G, SQL Server, MS Access

Testing Tools: HP Quality Center

Operating Systems: Windows NT, UNIX, windows 9x.2000, UNIX, Windows XP, 2003 server

Languages: Cobol, PL/SQL,, XML, SQL, PL/SQL, C

Other Tools: Informatica 7.x/8.x, Manugistics (TMS), Oracle Transportation Management system(TMS), Red Prairie (WMS), Ultra edit, Control-M, Preferred carriers, SQL Developer, SQL Navigator and TOAD

PROFESSIONAL EXPERIENCE

Confidential, Omaha, NE

Senior OTM FTI (OBIEE) Developer

Responsibilities:

• Responsible for providing production support on Fusion Transportation Intelligence (OBIEE) / OTM, which involves knowledge on OTM data.
• Building ad-hoc reports to test and validate the data in Finance, Freight Pay and Transportation areas.
• Created and customized Oracle BI metadata in the analytics repository with Oracle BI Administration Tool.
• Created materialized views and aggregates to improve performance of slowly and time consuming queries.
• Worked on the testing and validating the Repository in OBIEE 10G/11G.
• Experienced working on agile model project as well as Waterfall model.
• Creating new transformations to accommodate new fields/functionality as per the source system and generating informatica work flows to make source and target in sync.
• Involved in writing Unix shell scripts and scheduling jobs through control-M for ETL and well as OBIEE,
• Involved in OBIEE administration to maintain the Linux and windows servers, troubleshooting, transfer catalogs and migrations between different environments.
• Proficient in creating report templates using BI Publisher.
• Experience in BI Publisher with to calling templates from one template to another template and in calling stored procedures in BI Publisher reports.
• Extensively used OBIEE Administration Tool for Customizing and modifying the physical, business model, and presentation layer of the repository.
• Drill down Hierarchies and implemented Business Logics and Facts.
• Analyzed and validated the business model in Administration Tool by performing consistency check, validating logical source tables, logical columns, and also validating repository level calculations done in the Business Model & Mapping layer.
• Interacted with the business users to gather reporting requirements, regarding data issues and IT Overhead meetings.
• Converting the requirements gathered into Functional design and Technical design documents.
• Analyzing the requirements and converting into the technical documents. Identified the stars (Dimensions/Facts) that need to be populated.
• Performance tuning of Dashboard/Reports and made changes to database by implementing materialized views and partitions, rebuilding of indexes.
• Performed Unit, Integration and Regression testing to validate report and mapping functionality.
• Working closely with users/developers and administrators to resolve the production problems by reviewing design changes.
• Involved in modifying procedures, functions and packages according to data/report requirements.
• Involved in monitoring the Control-M jobs and control-m scripting.
• Responsible for moving the code to higher level databases and troubleshooting.
• Configured interactive dashboards by adding embedded content such as links/images, HTML objects and folders.
• Development and Configuration of new agents, mile stone monitors and events to in corporate new functionality.
• Monitoring bulk plans, executing on demand additional runs, turnoff/turn on auto decline activities, performance tuning of event management reports and other support activities.

Environment: Oracle 11G, OBIEE 10G/11G, Informatica, SQL, PL/SQL, SQL Developer, Control-M, OTM 6.1, 7.1, UNIX, Data Services.

Confidential, Omaha, NE

Senior Migration Engineer Manu to OTM

Responsibilities:

• Actively participated in gathering business requirements and documenting them for the OTM and complete FTI at a detailed level.
• Involved in standard report setup for OTD, Route guide compliance, Rate Inquiry, Load planner Scorecards, Freight cost reporting, carrier score cards and ad hoc reporting in financial module.
• Involved in config changes for TL, LTL, IM, RAIL and CPU workflows.
• Created “As is” and “To be” (Gap Analysis documents) system documents to show the current and proposed processes and functionalities of FTI system.
• Work with business partners to document the business requirements.
• Design the solution in the OTM application.
• Setup and configure the OTM application based on the customer requirements.
• Involved in development activities like Agents, Events & Milestones.
• Test and implement the OTM application.
• Involved in mapping of different EDI transmissions like Tenders, statuses and Invoices.
• Created FD and TD documents of Oracle OTM.
• Trained end users on Product functionality.
• QA testing and user acceptance testing with thorough documentation maintained at all stages.
• Involved in Provided post production support.
• Developed ETL processes to populate the Enterprise Product Orders data mart Dimensions and Fact using Informatica.
• Participated in the walkthroughs of the data models, identification of dimensional attributes, Facts and Star Schema to fulfill requirements

Environment: Oracle 11G, OTM 6.1.x, OBIEE 10.x, TOAD, Informatica 7.x,8.x, SQL, PL/SQL, SQL Developer, Control-M, UNIX, Data Services.

Confidential, Omaha, NE

Senior informatica /ETL Developer

Responsibilities:

• Designed the ETL processes using Informatica to load data from Flat Files, and Excel files to target Oracle Data Warehouse database.
• Designed, developed and documented multiple interfaces using the Informatica Power Center.
• Extensively worked on developing and debugging Informatica mappings, mapplets, sessions and workflows.
• Developed many complex Informatica mappings and mapplets to build key interfaces using transformations & reusable transformations (Source Qualifier, Joiner transformation, Update Strategy, Lookup transformation, Rank Transformations, Expressions, Aggregator) for loading the data into Data Warehouse.
• Experience in creating Reusable Tasks (Sessions, Command, Email) and Non-Reusable Tasks (Decision, Event Wait, Event Raise, Timer, Assignment, Worklet, Control)
• Optimal utilization of object-reusability features like reusable transformations, copying objects from other repositories, using variable/parameters for simplifying complex mappings.
• Performance Tuning of Informatica data warehouse loads, including Informatica Server Manager and PL/SQL procedures.
• Designed and Developed many Shell Scripts for pulling data from remote machines, Backup/Migration of metadata from version, development and production, FTP, untar & sending files to source directory, managing sessions files in the server directory.
• Involved in Unit testing, System testing to check whether the data loads into target are accurate.
• Developed unit test plans to test the designed mappings in various aspects; designed Informatica migration document and Implementation check lists to migrate the code from development environment to Dev, QA and Production environments.
• Involved in creation of FD, TD, Test plan and Migration plan along with backup plan.
• Creation of Unix shell scripts to call informatica jobs through control-M
• Monitoring and managing I/O file, log files, disk space utilization on unix server
• Creation of new users and managing long running sessions in Informatica.
• Involved in system reconciliation where there is unexpected system outage

Environment: Informatica 7.x/8.x, SQL, PL/SQL, Unix, Manugistics planning, Manugistics Freight pay, VB, DB2 and control-M

Confidential, Omaha, NE

Senior informatica /ETL Developer

Responsibilities:

• Designed the ETL processes using Informatica to load data from Flat Files, and Excel files to target Oracle Data Warehouse database. This design includes multiple work flows for inbound and outbound shipments.
• Involved in developing the Incremental ETL process i.e., Mappings & Maplets using various Transformations and Workflows with Sessions / Tasks.
• Identified all the fields in source system and defined the source template with additional fields for future use.
• Created and archive workflow which runs on weekly basis and scheduled through control-M.
• Developed unix shell scripts to call informatica work flows through control-M.
• Extensively used DAC, to configure, monitor and schedule ETL routines.
• Worked closely with Users, Developers and Administrators to resolve ongoing Production problems by reviewing design changes made to production systems and made corresponding changes to Metadata Repository.
• Involved in creation of FD, TD, Test plan and Migration plan along with backup plan.
• Creation of Unix shell scripts to call informatica jobs through control-M
• Monitoring and managing I/O file, log files, disk space utilization on Unix server
• Creation of new users and managing long running sessions in Informatica.
• Involved in system reconciliation where there is unexpected system outage

Environment: Informatica 7.x./8.x, SQL, PL/SQL, Unix, Manugistics planning, Manugistics Freight pay, VB, DB2 and control-M

Confidential, Omaha, NE

Developer

Responsibilities:

• Provides Maintenance, Production Support, manual testing for PIMS, DAIRY Legacy and costing applications.
• Requirements gathering for New Batch schedule from Development create Impact Analysis on the batch, debugging for any abends and manual testing are done at offshore.
• Experience on call Support for the Mission critical applications across 24X7.
• Changes to the COBOL Programs are done via Change Request from Clients.
• Change in JCL, PROC and update the Control Cards in Production Environment on Mainframes
• Deployment of the applications that runs on IBM Mainframe and Unix .
• Work with DB2 teams on version updates for both test and Production regions
• Work on Disaster recovery(DR) documents for the applications we are subject matter expert
• Monitoring and Maintenance of the ETL workflows to make sure data in DB2 table ready and available before ETL batch job kick off through control-M.
• Involved in integration testing from legacy to ETL system .
• Monitor the jobs in workflow manager when processing bulk loads and through put records.
• Monitoring of application performance & growth and Monitor application Environment & respond to alarms.
• Responsible to work on CONTROL-M Enterprise Manager GUI 6.3.01 on UNIX environment and this is used to schedule & execute the batch jobs.
• Responsible of shift schedule for the team and assigning the tasks on day to day basis for the Module and also assigning of Production Release over the weekends.
• Data availability assurance and reducing the frequency of errors and eliminating recurring errors.
• Coordinating with onsite developers and ensure the application is available as per the service level agreement.
• Conduct technical and process related sessions for the team.
• Schedule any new jobs and change any existing jobs in the schedule by working with Scheduling team.
• Build, maintain, and test production JCL and other job schedules for the applications.
• Usage of TOAD tool to validate the records in SQL DB and possible changes are made as per the development request.
• Provided Root cause analysis and permanent fixes for Service Order application batch Job abends and online user issues.
• Actively involved in SWAT calls for any possible outages and make sure to involve Leadership on client end.
• Setting up of Test Environment including modifying the JCL, creating data using SPUFI, QMF and executing the JCLs for validating the data in DB2 tables.
• Assists the Testing team and also participate in Load testing for Production environment.
• Coordinating with DBA to get the worked on the modified DB2 programs - Like adding a Column for the DB2 table for the Deployments.
• Providing production support activities to the users of the system and resolved it based on priority.Work with Service Center (Computer specialist) on day to day abends

Environment: Informatica, control-M,Cobol,DB2 and CA-7

Confidential

COBOL Developer

Responsibilities:

• Requirement gathering from the existing system.
• Create Flow chat diagrams for the application flow that helps the team to understand the flow of system Architecture.
• Involved in preparation of Process flow diagrams based on the existing business functionality.
• Involved in preparation of Functional Understanding documents.
• Preparing the Analysis & Design Document for the new system.
• Coding of new programs in COBOL and JCL based on the technical specifications.
• Making unit test plans, test cases
• Preparing Integration Testing Document, System Testing Document, User Acceptance Document
• Resolving abends as part of production support.
• Doing Internal Quality Assurance and External Quality Assurance for Deliverables to clients

Environment: COBOL, SQL, VSAM, DB2 and OS 390