SUMMARY

• Want to be valuable resource to team, participate in various Data Warehouse activities from Data Architecture to Production support.
• Interested to Gather and analyze business requirements, legacy application enhancements, interfacing wif users, and provide information to upstream and downstream systems.
• Love to make my hands dirty and learn New technologies. Bring cheerful environment while working.
• Well Versed wif SDLC, Data Warehousing Concepts, Data Mining and DBA Concepts. Modeling entities star and snowflake schemas, designing fact tables, dimension tables, normalization.Process Design, Process Automation and Data Architect. Expert in application integration, securing, improving performance and tuning, maintain Oracle database and data warehouse systems on different operating systems UNIX, Linux and/or MS Windows server environment.
• Communicating wif Business in identifying problems, giving robust solutions, halping them to put requirements together BR documentation, Writing Technical specifications, clearly mentioning different sources and Impact analysis wif in enterprise. Working and designing requirements wif rest of teh team. Making sure product is delivered in time after passing thorough Quality Assurance test cases.
• Oracle Expertise include Creating altering all Oracle objects, Table spaces, Tables, Indexes, Synonyms, Views (materialized, Object, Standard), Packages, Procedures, Function, Sequences, Grant and Revoke Privileges, parallel processing, SQL* Loader.
• Worked wif INFORMATICA, ETL Tools, using teh various data sources and targets. Installing Server and client configurations, Repository server maintenance, scheduling teh various options to automate teh data loads. Optimizing teh Mappings to get teh optimal data output.
• Using, writing Perl Scripting, Shell Scripting, ERWin. Well versed wif CSH, KSH, Trillium, Control - M, Data fuse, ftp, sftp, and wget and integrating wif automated processing and data feeds.
• Experienced in writing teh design documents for user exits, interfaces, reports for ABAP Development. Worked extensively on all modes of SAP Transportation, includes Express, LTL, TL, Rail, Barges and Ocean mode for outbound as well as inbound.

TECHNICAL SKILLS:

Operating Systems: Windows, UNIX, Linux, Ubuntu, Dos

ERP: SAP R/3 Version 4.7, 4.6C, 4.6B, 4.0B, 3.1H, Adage, People Soft.

RDBMS: Oracle 11G, 10G, 9i, 8i, 7.x, PL/SQL, Sql Loader, Warehouse Builder, Data Mining, DBArtisan Sql Navigator, Microsoft Sql Server 6.5, 7.x, TOAD, MySql

ETL tools: Informatica 5.1.1/6.1/6.2.2/7.1.1/7.2.1

Data Modeling: ErWin 4.0

Front End Tools: Visual Basic, Cobol, Java, Jscript, VBScript, Object View, Clipper, Microsoft Office, Front Page.

Reporting tools: Cognos, Actuate, Crystal Reports, Brio, IQObjects, MyEureka, SAS.

Version Control: PVCS, Source Safe, Subversion

Other Tools: Trillium Ver 12 and 13, Microsoft Project, WS Ftp, Hyperion, Datafuse, Mindbase, Anchor, HTTP(S), SSH, DNS, TCP, UDP, IMS, VMWare, Citrix, Control-M, Hadoop Ecosystems. PCI/PII Compliance.

PROFESSIONAL EXPERIENCE

Confidential, Houston, TX

Skills Used: Informatica, Oracle 11G, SAP., AIX UNIX, Trillium, Anchor, Datafuse, Mindbase

Environment: Informatica 8.1, 8.6, Oracle 10G/11G, SAP 7

Responsibilities:

• Responsible for developing, implementing, and supporting operation of Smart Energy Portal Operational Data Store and Mass Marketing Analytical System (MASS) systems using various development tool sets. Identify system requirements and define problem solving procedures; Develop system technical requirements for applications; Develop and enhance system functionality, including through custom code and packaged application configuration; Work wif application owners to identify and implement process improvements; Comply wif architecture and quality processes, principles, policies, and standards, Participate in software inspections and quality reviews, Ensure successful transition from development to operations; and implement software enhancements.
• Creating Logical models of data and converting them to Physical designs, implementing them thru following standards wif Version control for releases.
• Designed, developed address standardizing Trillium process and creation of merge purge process of data to integrate wif marketing data. Providing innovative solutions on Security wif registering seamless Keys thru UNIX servers, Trillum, PGP Encryption, PII Applications for credit cards and Social security numbers.
• Worked on Performance Management Data Repository (PMDR) for Plant Ops KPI Dashboard Project. Master Data References include Program, Scenario, Region, Fuel Type, Plant, Unit, Cost Center, Cost Element, SWBS Element, SAP Cost Element Grouping, SAP Cost Center Grouping.
• Designed processes by configuring SAP adaptors, to pull data into oracle using Informatica Hyperion Dim, and tan pushing data on to Essbase Cubes.
• Problem Solving and Analytical Skills: Ability to analyze wide range of problems, assess risks/benefits of alternatives, develop and implement creative solutions using multiple technologies while adhering to change control methodology to meet business objectives. Job Execution Automation using Cron and Control-M.

Confidential, Rockaway, NJ

Skills Used: SAP SD-LE/Shipping Production Support/Enhancements, RCX and RGX

Responsibilities:

• Designed and analyzed customization of Rail Shipment reports. Designed teh process of sending EDI messages to Rail Carriers and receiving teh status information and updating teh status back to Shipments.
• Designed process for outbound ASC X12 EDI 404 and inbound 824 message numbers wif Shipment 05 message type. Involved in brainstorming sessions, analyzing teh business processes, requirement gathering, as is and to be processed, documenting, communicating wif users and third party vendor QTS.
• Designed process to refresh all teh RCM-CLM locations in Rail shipments and relating all teh CLM Locations to Routes. Designed process wif Own iDOC segments, Own EDI Messages to communicate wif third party vendor QTS.

Confidential, Pittsburgh, PA

Loading SAP Tables, Cognos Frame work Manager

Pittsburgh, PA

Responsibilities:

• SCCR Reporting. Designed and Developed Cost Center based performance reports. Various configurable parameters like BG, SBE, Ru based reporting structures. Designed shell scripts and scheduled loads in cron tabs. Monitored regular refreshing of various departments transactional data and maintaining master data.
• Configured Frame work manager meta data information, Administered user groups and maintained permissions on user level and groups. Developed complex business views wif customized parameter maps.
• Distributor Sales analysis, scheduling loads of various distributor sales and developed reports.