Saheb Jain

• 10+ years of IT experience in Business Intelligence, Datawarehousing and Application Integration. • Associated with TCS Publishing Vertical for a considerable amount of time and have in-depth knowledge on Publishing business processes. Engaged in multiple activities like Proposal writing, Proof of Concept activities, Solutioning, Delivery etc. • As a system integration architect, led a large team to define system requirements, design interface, define policies according to which these subsystems interact, design migration, delivery ownership, cutover and handover planning. • Played pivotal role in gathering business requirement data and proposing Solutions design in numerous application/ database upgrade projects. • With the expertise in Solutions mapping for requirements, designed ‘To be Process Flow’, conducted UAT and Performance tuning, managed Go-Live and Post Implementation Support, and successfully delivered service to meet client satisfaction. • Initiated and implemented several Datawarehouse projects with knowledge of Data warehousing Concepts, OLAP, Star schema, Snowflake Schema, Business Process Analysis, Dimensional Data Modelling. • Handled and led various projects to build ETL structures from scratch with heterogenous data sources like flat file, xml, relational database, mainframe etc., identify distinct functional areas, interact with end users and create analytical BI reports. • Conducted several techno functional trainings on integration and datawarehousing concepts for peers and colleagues.

Tibco To Informatica Project • Successfully carried out migration transformation and helped customer to consolidate middleware tools and technologies in their ecosystem. • Achieved 20% reduction in terms of licensing cost, operational IT cost and infrastructure cost. • Converted more than 100 integrations into Informatica ETL components achieving 30% overall performance improvement in the total execution time. Interim Reporting Solution for Global Permissioning System • Understood functional specification and requirement from business and created technical design/solution documents. • Created new DataMart and SAP Business Object Universe to cater the reporting requirements. • Created dimensions, measures and hierarchies for providing drill down options in the reporting environment. Supplier Data Depot Replacement with Zycus • Created Functional Documentation in accordance with business requirement. • Developed Informatica Mappings and PL/SQL Packages and involved in integration and user acceptance testing. • Created a data extract to enable Spend Management Reporting from Zycus.

• Managed assignments/workload for team of 4 developers to meet project milestone and delivery goals. • Managed complete project cycle right from requirement analysis to system study, functional and technical designing, coding, testing, de-bugging, documentation and implementation. • Performed as technical leader for projects Exadata upgrade 11g to 12c, SAP BO Upgrade to 4.2 SP4 and various small enhancement projects. • Expert knowledge in Informatica PowerCenter ETL, SAP BO4.x, SQL, PL/SQL and Performance Tuning. • Competent in data warehouse project planning, data modeling, maintenance, development, and enhancements. • Ability to write complex SQL queries to perform Data Validation and Data Integrity testing. • Ability to create BO WEBI reports and highly formatted Crystal reports. • Hands on experience with Core Java, J2EE- JSP and Servlet. • Possess knowledge on source systems like Oracle EBS, SFDC and PDH.

Data Warehouse management with good knowledge in ETL tool like Informatica Power Centre, Oracle db, scripting language like SQL and PL/SQL Responsibilities: • Maintenance and enhancement of a large datawarehouse system • Design basic and complex ETL interfaces based on business requirements • Thorough testing of ETL components and performing required bug- fixes • Design of Functional and Technical Design documents for the ETL process • Tuning of ETL component for performance improvement. • Designing PL/SQL processes for handling many business scenario as well as tuning the same • Developing Unix scripts to integrate other system with ETL • Regular communication with the peer team member as well as client persons