SUMMARY

• Experience with complete SDLC processes and Agile methodology of Project Management. Emphasis on BI Data Warehouse. Worked for companies including Confidential, Confidential, NYSE, GE, Motorola, Oracle, Confidential Digital and Electrolux to name a few.
• Experience includes all phases of project management from Business Requirements gathering, planning, design, development, data modeling, reporting, testing, implementation and user training.
• Involved in SOX testing periodically.
• Effective communicator with excellent interpersonal skills, ability to multi - task, prioritize and meet critical deadlines
• Enterprise data warehouse and BI design and implementations.
• 10+ years of strong experience in designing and implementing complex dash boarding and reporting solutions using COGNOS Suite 11, 10.2 / 8.4 / series 7 ver 4
• Great functional noledge of procure to pay and order to cash cycles.
• Experience in PL/SQL and query optimization techniques

PROFESSIONAL EXPERIENCE

Confidential

Architect/ Sr Programmer Analyst

Responsibilities:

• Subject matter expert and to serve teh needs of Business Intelligence dashboards and reporting and data warehousing needs.
• Establish best practices, methodology, strategize and standards for DW and BI design and development to execute projects.
• Coordinate and setup data warehouse environment with teh help with DBA, system administrator and infrastructure and Hadoop and HANA development teams.
• Create an ERWIN diagram data modeling and setup teh relations.
• Analyzing data by locating, profiling, cleansing, extracting, mapping, importing, transforming, validating and modeling.
• Transformation and data exploration, use statistical formulas and methods to visualization techniques by business insights in cognos,
• Communicate effectively to teh business users so that it is easy to understand and they can leverage teh information right way
• Responsible for teh overall requirements gathering, design and development of framework model, cubes, dashboard reports, portals, events, batch scripting, scheduling and distribution to teh end users, establish user/folder security in BI analytics/reporting solutions.
• Design teh star schema and snow flake schema by defining relationships in Cognos Framework manager modules.
• Design formats, generate graphs, drill down reports, and create trending using Cognos Report studio.
• Responsible for administering BI tool and designing a scalable infrastructure.
• Design & development specifications, metadata and documentation.
• Setup end user training and document tool for new developments/enhancements.
• Discuss teh data issue and if possible provide teh alternate best solution to resolve it.

Confidential

Architect/ Sr ProgrammerAnalyst

Responsibilities:

• Subject Matter Expert (SME) for software application data to facilitate discussions for requirement gathering and design to build data marts (Logical and Physical) in data Warehouse and BI projects.
• Standardization design and tasks to build generic objects to utilized across organization.
• Task planning and allocation, change management and timely delivery of projects to customers.
• Extensively worked on new projects end to end design/ enhancement for data marts in DW and BI by using oracle ERP as a main source to DW.
• Extensively created design documents for BRD, Functional and Technical documentation.
• Established teh data governance through BI platform.
• Core business modules includes Purchasing, Order Management, RMA, Finance, Inventory from oracle EBS systems and other custom applications like Channel sell through, BOS, DMAP. Also used Salesforce CRM for Chaneel sell through, Orders, RMA as a source to data warehouse. .
• Extensive usage of data modeling using Ralph Kimball and Bill Inmon
• Expertise in performance tuning of SQLs by utilizing proper indexes, analyzing, optimization, Statistics gathering for best results.
• Analyzing data by locating, profiling, cleansing, extracting, mapping, importing, transforming, validating and modeling.
• Extensively used Cognos with framework modeling on star and snow flake schema.
• Designed and Implemented new dashboards using Portlets pages, Tabs and cognos workspace
• Cognos administrative activities including creating users, manage security at user level, folder level, storage, create and manage data source
• Developed Active reports for users to use offline and on mobile devices.
• Designed and Implemented metadata models in Framework Manager and Power play cubes for Sales, Finance, Shipments, Purchasing, Inventory etc.
• Established an audit reporting system for teh internal team to monitor, analyze performance and usage of different reports, cubes and other objects.
• Authored various types of reports in Report Studio using dimensional (Cube & DMR) and Relational data sources.
• Migrated Cognos7 to cognos 8.4 and then to cognos 10.2.1
• Explain teh technical architecture and business functionality of teh systems to teh developers to facilitate and mentor them to better turn around on tasks assigned.
• Closely work with oracle DBAs, sysadmin and infrastructure teams to maintain database, servers, storage and security of Data warehouse and BI Servers.
• Ongoing production support activities to maintain DWBI environment.

Confidential

Techno functional Lead

Responsibilities:

• Business Requirements gathering
• Impact analysis with other software application systems
• Design data modeling for business modules
• Functional, Technical and Test Design documents
• Design oracle pl sql packages, procedures and functions
• Worked in Sales Order Acnoledgement, Packing slip, shipping tag, Mailing Label and Quote reports developed using oracle reports and XML publisher.
• Designed several reports for Decision Support system using Oracle Discoverer
• Involved in teh testing of Bonus and Penalty change workflows
• Item inbound and outbound Interface for EDI888.
• Material transactions for onhand quantity.

Confidential

Project Lead, Implementation Lead, Module lead, Business Analyst, Quality analyst and Developer

Responsibilities:

• Implementation of Procure to Pay module of Oracle Applications (OLTP).
• Help implementation of Global Purchasing, iProcurement, Accounts Payables of oracle applications and its integration to eLance that have been used by various GE businesses across teh world .
• Lead team of professionals to maintain and enhance manufacturing modules including order management in oracle applications (OLTP) and demand and supply (custom) .