RAJESH SAJJA E -mail ID:acwmj6@r.postjobfree.com

Mobile No: 309-***-****

Summary of Experience:

About 14+ Years of Total IT experience and Technical proficiency in the Data Warehousing teamed with Business Requirements Analysis, Application Design, Data Modeling, Development, Testing and Documentation. Implementation& Manage Data warehousing and Master Data Management for business Applications Domains Financial, Pharmaceutical/Medical Devices, Retail, Public Sector, Banking, Insurance and Manufacturing.

Experience in Preparing Project Initiation documentation. Responsible for ensuring best value is obtained for the project including supplier base, use of internal and external resources. Maintaining and completing Project KPI (Key Performance Indicators).Writing detailed and summarized project progress reports.

Experience in Identifying, costing and processing any contract variations, tracking activities against the detailed project plans. Updating project plans to include agreed changes. Producing accurate financial reports. Monitoring actual expenditure figures against project budgets, cost control.

Good Experience in Organizing and facilitating Project Steering / Operating Committees meetings. Conducted POC’s and RFP ‘s for the Projects on various technologies like Business intelligence and Data warehouse.

Proficient knowledge on SAP BI Architecture, Cognos, QLikview, Tableau Architecture, Administration and New features. Good Hands on Experience in Handling Multiple Projects with integration from SAP& Other Environments.

Technical hands-on expertise in Business Intelligence Tools From SAP (Crystal Reports, Dashboard designer, Reports, Designer, Information Design Tool (IDT), WebI, Lumira, Design studio, QAAWS, Live office and CMC&CCM),Qlikview (Management console, Publisher, Server, Qliksense),Tableau(Desktop, Server, Cloud) Microsoft (SSRS, SSIS, Power BI, Management studio).

Good Working Knowledge on IOT, Big Data &Analytics, SAP HANA As a Developer to create Packages,

Schemas, views (attribute, analytical, hierarchical) and load data from SAP systems by using SLT& SAP DS as well Administrator how to create the Users& Roles, Security on schemas tables and having good experience in Admin tasks like Backups.

Expertise in managing and Provide the solutions For Business intelligence Environments from SAP, Qlikview and Tableau for the Live and Data analytics on MDM(Master Data Management),Transactional Data,OLAP Data on the Big Data technologies like Hadoop and SAP HANA, Splunk

Good Technical and Functional Knowledge on the Technologies like Hadoop on HDFS, Hive QL, Map Reduce, Name node and Good Knowledge on Web, Social Analytics(IOT) tools like google analytics, Facebook insights,AWS, Predictive Analysis with R.

Extensively used Business Objects, Qlikview, Tableau reporting, Dashboard functionalities such as Master Detailed, Slice and Dice, Drilling Methodology, Filters, Ranking, Sections, Graphs and Breaks. Detailed knowledge of multi-tier architecture in Client/server environment.

Excellent knowledge of Data warehouse architectures, concepts and Technologies, dimensional Star Schema and Snowflakes Schema methodologies and Data Quality, SAP HANA, BW.

Expert in implementing the projects from End To End Applications on BI & Data warehouse, Manage Architectural, Functional, Technical and Training Documentations for the End users .Maintain Day to Day activities by the team in the work environment.

Expert in designing and developing complicate ETL mappings using SAP BODS Designer, Informatica Power Center, SSIS, Pentaho .Proficient in Optimizing performance issues using Informatica Power Center .In depth understanding in data modeling, Entity-relationship (E-R) modeling, slowly changed dimensions (SCD)

With Strong Knowledge in all phases of Software Development Life Cycle (SDLC) such as developing, testing, Migrating, Administrating, security management and production supporting on various platforms like UNIX, Windows NT/2000/XP/98.

Good Working with Functional and Technical Implementation on Different Environments With SAP and Traditional Databases and Integrate data Using SAP DS into SAP HANA,Hadoop and provide Predictive Analysis .

Design, Development and Coding with ORACLE 9i/8.x/7.x, SQL Server 2000/2008/2012. Good Knowledge on integrated SAP R/3 and SAP BI,BW systems with Java using SDK.

An enthusiastic and project-oriented team player with solid communication and leadership skills and the ability to develop creative solutions for challenging client needs.

CERTIFICATIONS:

SAP Business Objects Certified Professional SABE 201

SAP Business Objects Certified Professional SABE 301

SAP Business Objects Certified Professional SABE 401

SAP BI 4 & EIM Solution Management

Oracle Certification for SQL, PL/SQL.

TECHNICALSKILLS:

Languages : C,C++,JAVA,PL/SQL,SQL, Shell Scripting.

RDBMS : Oracle 8i, Oracle 9i, MS SQL Server.

Reporting Tools : Business Objects 6.5, XIR2, XIR3.1,4.0, Info View, and Web

Intelligence, crystal reports xir2/2008,SSRS 2005/2008,QAAWS.

Dashboards : SAP BO Dashboards 4.5/5/6,2008, SAP Lumira, Tableau, Qlikview

ETL Tools : Informatica 5.1, 6.2, 7.1, SAP BODS 3.1/4.0, Pentaho

BIGDATA : SAP HANA, HADOOP

Operating Systems : Windows98/NT/2000/XP, UNIX, LINUX, VxWorks

Data Modeling : E-R Modeling, Dimensional Modeling, and Star Schema, Snow Flake

Schema, Fact and Dimensional tables, Erwin 4.0/4.1.

Other Tools : SAP BO on Demand, voyager, SQL * plus, Quest Toad,

PL/SQL Developer, SQL *Loader,QT4/3.4/3.3.

Software concepts : Relational database design, Object Oriented analysis and design.

Technical Experience : Proficient with Microsoft packages Word, Access, Excel, and Power Point.

PROFISIONAL EXPERIENCE:

Rps Tek Sol June2016-Tilldate

Frankfort,KY

Role: Big Data Analytics /BI Architect

Project: Integration & Big Data Analytics

Contribution:

Conduct Meetings with Stake holders in gathering, analyzing, and documenting business requirements, functional requirements and Data Specifications for the Analytics software implementations and BigData specifications on Hadoop, Tableau and SAP BI.

Providing technical leadership to the Data warehouse/Business Intelligence/Big Data initiatives being undertaken at Insurance Solutions . Leading the Agile DW delivery at Insurance solutions with complex data sources. Heading the Agile Data warehouse and Business Intelligence Implementation.

Building a culture of excellence and high proficiency to ensure that the team has a focus and pride on the delivery of high quality data and services. Heading MDM(Master Data management) and strategic initiatives like BFF, Advanced Analytics, etc.

Providing, maintaining and delivering the high-level business case for the immediate and strategic value of the ISDW. Responsible for ensuring the ISDW delivery stays on time, on target, and in budget.

Leading the DW/BI architecture and infrastructure to support huge loads of premium, claims data(>30TB) to DW

Worked And Managed on Multiple Projects simultaneously on Data warehouse & Business intelligence and involved in Integration analytics MDM data acquisition, Performance tuning and develop the analytic solutions using Tableau Dashboards, Webi, Design studio and BW on HANA.

Mentor on the Tableau, PowerBI visualizations, Data integration Using BODS to create the documents & story’s in Non-SAP Environments.

Partner with senior business leaders in each business function to create a single, enterprise BI and governance strategy consisting of technical and non-technical pillars.

Environment: Cloudera 5,Hadoop, HDFS, Hive, Pig, HBASE, Unix, Erwin 3.2.5, WinNT & UNIX,SAP HANA, Micro strategy, WIN SQL, BODS, Oracle 11g, Agile Warehouse, MS Project,, SAP BO,Power BI, Qlikview, Tableau

Tyson,

Hitachi consulting Sep 2014 – May 2016

Springdale, AR

Role: Big Data /SAP BI&A Performance Manager

Projects Managed:

Integration Data Analytics Trade, Sales (Precom with SAP HANA &SQL

Postcom with SAP BW AND HANA),

Core Program integration,

Parallel Testing on Integration analytics (PTT ),

Auditing and Performance monitoring (Architecture& Admin)

Contribution:

Conduct Meetings with Stake holders and Managers in gathering, analyzing, and documenting business requirements, functional requirements and Data Specifications for the Analytics software implementations and DWH specifications.

Worked And Managed on Multiple Projects simultaneously on Data warehouse & Business intelligence and involved in Integration analytics MDM data acquisition, Performance tuning and develop the analytic solutions using Tableau Dashboards, Webi, Design studio and BW on HANA.

Mentor on the Tableau, PowerBI visualizations, Data integration Using BODS to create the documents & story’s in Non-SAP Environments.

Manage Data warehouse& Business intelligence Teams for both Onsite and Offshore Coordination and Distribute and monitor the workloads among the teams.

Mentor on the Tableau and SAP BI server administration in Performance tuning and server management for the client Environment worked on the auditing and cluster, nodes which improved the Performance 30% in BI environment.

Designed, Developed and managed Universes in SAP BI IDT for Generating the Reports using WEBI, Business object Design Studio, Tableau story boards for SAP BI PTT on Teradata Warehouse for Core Business Simulation as Well Service and Repair Groups.

Design and Developed the Reports by using WEBI and SAP Lumira, Analysis for OLAP,Tableau Cloud based story’s, from Different universes and train to the end clients regarding development of ad-hoc reports.

Implement Test plan for the Upgrades on the Sap business objects Webi from 4.0 to 4.1 and involved for the Upgrade Plan for the Data services from 4.0 to 4.1.

Implement the test plan to synchronize the environments in Dev, QA and Prod for the business objects universes and Webi Reports.

Environment: SAP Business Objects 4.1/4.2, BODS 4.0/4.1, SAP HANA1.4, SAP Lumira 1.29, SAP BI Mobile 4.1,Tableau 9.0, Analysis for OLAP, Power BI,SAP Design studio, Crystal Reports 2012, Live Office, Oracle 11i,MS Access, SQL Server,CMC, CCM, Webi, Dashboard Designer, info view, Toad 10, SQL, PL/SQL, and Windows .

COMMON WEALTH of KY, Oct 2009 – Aug 2014

Frankfort KY

Role: Business intelligence Manager /Architect (SAP,Qlikview,Tableau)

PROJECTS Implementing, Supporting & Managing:

P20 : This Project is intend to load the Data from Multiple Departments and Databases and build the Universes, Reports and Dashboards on central Data warehouse for all Education Institutes(KDE,CPE,HSFB,EPSB,MUNIS) in Kentucky.

Unemployment Insurance: This Project is intend to Build the Universes, Reports and Dashboards on Data warehouse for Unemployment insurance and Education together in state of Kentucky.

WIA & EKOS : This is intend to Build the Universes, Reports and Dashboards on Workforce Investment and EKOS .

Work now: This is mainly intended to build the reports on Work now database system.

Contribution:

Conduct Meetings with Stake holders and Managers in gathering, analyzing, and documenting business requirements, functional requirements and Data Specifications about Government of Education (EKOS, WIA) System in KY for Business Objects Universes and Xcelsius Dashboard’s, Business object Explorer 3.2 spaces.

Worked And Managed on Multiple Projects simultaneously on Data warehouse & Business intelligence and involved in Integration analytics Universes in Business objects Designer for Generating the Reports using WEBI, Design and Develop the Dashboards Using Business object Explorer 3.2, Dashboard Designer for WIA Group.

Design and Developed the Reports by using WEBI from Different universes and train to the end clients regarding development of ad-hoc reports.

Implement and maintain polestar (Explorer) spaces for UI and P20 Projects and Develop complex Dashboards Cloud based analytics, AWS and webi Reports for Month, Qtr and year bases.

Created Quarterly and annual dashboards for Ekos and Wia systems by using Crystal Xcelsius 2008 as per the analysis requires for End User.

Developed the dashboard for Ekos systems by using Web services through the Qaaws in Business objects environment and integrate to Xcelsius, Tableau.

Test the Universes, Reports as per the Business requirements Using Toad on Oracle Database and implement the SDLC on Business objects Environment.

Defined Aliases and Contexts to resolve loops in the universes. Design aggregate awareness, objects and Prompts for complex reports.

Created and Deploy the Reports in the BW Environment by created BICS Connection for The Direct Reporting Using Bex Query.

Upgrade the complete Business objects Environment from Business objects 3.1 to Business objects 4.0 By Wdeploy tool in SAPBO4.0.

Environment: Business Objects Xi3.1/4.0, BODS 3.1/4.0, Crystal Dashboard 2008/6.0,Business object Explorer 3.2, Qaaws, Google analytics, AWS,Tableau, Crystal Reports 2008, Live Office, Oracle 11i, SAP BW 7.3,CMC, Deski, Webi, Dashboard analytics, info view, Toad 10, SQL, PL/SQL, and Windows XP.

SIEMENS,

Pittsburgh PA Nov2008- Aug2009

Role: Sr. SAP Business Objects/Qlikview Architect

Contribution:

Involved in gathering, analyzing, and documenting business requirements, functional requirements and Data Specifications about the Water system for Business Objects Universes and OLAP Reports.

Designed, developed and managed Universes in Business Objects Designer for generating the pay roll reports for sales, crystal reports and supply chain, trading reports for marketing group users.

Created derived tables in Universe for some specific Ad hoc report generation.

Created Universes by defining connections and retrieving data from database. Created BOXiR3 Deski reports for Data Marts and Data warehouse.

Developed the dashboard for Inventory using Web services through the Qaaws in Business objects environment and integrate to Xcelsius 2008, Business object Explorer 3.2 spaces.

Made Enhancements to Securities Data mart Universe based on user requirements. Build universes for data from Oracle apps11i and generate the reports.

Creation of Dashboards using Qlikview as per the customer requirement depends on Quarter, monthly And analyzes the report with charts provided by Qlikview

Imported the Data sources from databases and file formats create the Schema's,QVD’s as per the requirements and generate the reports by using QLikview

Maintain and Prioritize Security restrictions for QVW as per the industry standards.

Migrated & upgraded Business Objects from XIr2 Universe designing and establishing BO environment,

And update the dashboards depend on Universe using QAAWS

Worked on The ETL Mappings, Store Procedures, Packages using SSIS to import the data from multisource and develop the reports using SSRS and Qlikview Documents.

Defined Aliases and Contexts to resolve loops in the universes. Design aggregate awareness for complex reports and views and Prompts.

Integrate the Webi documents using Business objects SDK by using Java programming.

Performed unit testing, system testing and user acceptances test (UAT) for universe, reports and security Management.

Created User Conditions and Filters to improve report generation & readability of report and displayed the summary of data by creating Charts.

Environment: Business Objects Xir3,Crystal Xcelsius 2008,QLikview 9,Crystal Reports 2008, Qaaws Oracle Apps 11i,SSIS,SSRS 2008,CMC, Deski, Webi, SqlServer2005,Erwin, JAVA Net Beans 6.5, JDBC, SQL, PL/SQL, Toad, Windows2000/XP.

LANTHEUS Medical Imaging, MA SEP 2007-OCT 2008

Role : QLikview/SAP Business Objects Analyst

Contribution:

Involved in gathering, analyzing, and documenting business requirements, functional requirements and data Specifications about the financial system for Business Objects Universes and Reports.

Designed, developed OLAP and managed Universes in Business Objects Designer for generating the pay roll reports for sales, crystal reports and marketing reports for marketing group users.

Created derived tables in Universe for some specific Ad hoc report generation.

Creation of reports like Reports by Period, Demographic reports and Comparative Reports.

Created New Classes and User Objects in designing the universes and maintain data cleansing and data Conversion by using Business Objects tool.

Created custom reports like Gross Margin, Account Query, Aging, Balance Sheet, Income Statement, Bad Debt and Payment Reports in response to user needs.

Created and modified the Crystal Reports for various financial groups using the Universe as a main data Provider. Created Charts to display summary data using universe as main data provider.

Creation of Dashboards using Qlikview as per the customer requirement depends on Quarter, monthly And analyzes the report with charts provided by Qlikview

Imported the Data sources from databases and file formats create the Schema's as per the requirements and generate the reports by using Qlikview

Worked on The ETL Mappings, Store Procedures, Packages using SSIS to import the data from multisource and develop the reports using SSRS and Qlikview Documents.

Develop Views and Store procedures in the database level as per the requirement for to build the Universe and reporting purpose.

Test the Universe, Reports as per the Business requirements Using Toad on Oracle Database and implement the SDLC on Business objects Environment Created Crystal Reports using Crystal XI for Securities Data mart and using Security DM Universe as data Provider.

Create the Scripts as per the Data modeling Created for the user Requirements and Generating Complex Reports Drill Reports and Charts By Using Qlikview

Environment: BusinessObjectsXIR2, CMC, Qlikview 8.5,BODI,InfoView,Toad9.0,Teradata,SQL,PL/SQL,

Windows2000/XP, Ervin, SSIS,SSRS 2008,Crystal Reports 2008.

CONVERGENCE MANAGEMENT SYSTEM, JUL2006-AUG2007

ADELPHIA BUSINESS SOLUTIONS, BUFFALO NY

Role : Business Objects Developer

Adelphia Business Solutions is a one of largest cable TV & Telecom companies in USA. Convergence Management System provides faster response time, which permits scalable growth as the customer base expands. The system is developed to handle the sales & services.

Contribution:

Directly coordinating with user to gather the new requirements and working with existing issues.

Designed & Implemented security architecture for Telecom Group. Involved in Data Modeling and SQL server Database

Installation and Configuration of Business Objects XIr2 along with performance manager.

Migrated & upgraded Business Objects OLAP from 6.5 to XI r2 Universe designing and establishing BO environment.

Designed Universes for Telecom Billing system and Order processing

Created Objects and prepared Reports like Telecom reports, HR reports, Crystal and ad hoc reports, and Universes and maintain the Design aggregate awareness for complex reports..

Created Users, groups assigned privileges. Restrictions on Universes, Documents through CMS.

Created the crystal reports for sales of the different products for different regions and demands for future forecasting using Crystal Reports Xi.

Used Aggregate Awareness feature of Business Object Universe for better performance and smooth execution Of BO reports.

Created multiple Universes using Business Objects and resolved Loop and Join problems by creating Aliases And Context

Improve the performance and Data Cleansing,Data maintaining through the Data Quality for Better Decision

Develop Views and Store procedures in the database level as per the requirement for to build the Universe and reporting purpose.

Test the Universes, Reports as per the Business requirements Using Toad on Oracle Database and implement the SDLC on Business objects Environment.

Generated the Business Objects reports involving complex queries, sub queries, Unions and Intersection and having generation of Dashboards using Crystal Xcelsius.

Performed unit testing, system testing and user acceptances test (UAT) for universe, reports and security Management.

Developed universe user documentation guide for the end users reference

Environment: Business Objects 6.5.1/ XI, Crystal Reports Xi, CMS, CCM, Webi, Deski, Designer, Info View, Toad9.0, Oracle 9i, DB2, SQL, IBM-AIX, PL/SQL Windows 2000/XP, Qlikview.

CIT Financial, Livingston APR 2005 – May2006

Role :Sr. Business Objects Consultant/Admin

Contribution:

Directly coordinating with user to gather the new requirements and working with existing issues.

Designed & Implemented security architecture for Financial Group.

Involved in Data Modeling and SQL server Database.

Migrated & upgraded Business Objects from 6.5 and Crystal Reports 10 to XI Universe designing and establishing BO environment.

Designed Universes for Financial Billing system and Order processing.

Created Objects and prepared Reports like financial reports, Commodities, HR reports, standard and adhoc reports, and universes.

Involved in joining the tables by creating aliases to resolve the loop.

Created Reports based on subtotal of Currency and General Ledger category.

Created many reports according to the investment deals, facility and outstanding to know the exact amount of net investment in each deals.

Prepared month-end reports for General Ledger, Commodities, Net Investment, Interest, Fees and Incomes.

Worked as Dashboard / Performance Manager for the Net Investment and Interest to analyze the investment return.

Installation and Configuration of Business Objects XI along with performance manager.

Converted Desktop Intelligence Reports to Web Intelligence using Report Conversion Tool.

Implemented Security Features of Business Objects like row level, object level and report level to make the data secure.

Generated the Business Objects reports involving complex queries, sub queries, Unions and Intersection.

Performed unit testing, system testing and user acceptances test (UAT) for universe, reports and security management.

Developed universe user documentation guide for the end users reference.

Environment: Business Objects 6.5.1/ XI r2,CMS,CCM,Crystal Xcelsius, Import Wizard, Webi, Deski, Designer, Info View, Toad9.0, Oracle 9i, SQL, PL/SQL Windows 2000/XP.

UNITED HEALTH CARE, NC Mar 2004 - Feb 2005

Role : ETL/Cognos Consultant

United Health Care is one of the leading Health Care companies in North Carolina. It is a vertically integrated, global Health Care company with proven research capabilities and presence across the pharmaceutical value chain. United Health Care will manufacture Active Pharmaceutical Ingredients and Finished Dosage forms and market them globally, with a focus on United States, Europe, and Russia.

Contribution:

Understanding business requirements in terms of technical specifications for reporting and data analysis.

Business Object Universe, Business Objects Reports and Business Objects repository used extensively.

Developed advanced mappings using Informatica Power Center. Extensive analysis to design the Universes and assigned those to respective domains.

Created complex views to overcome loops and contexts. Optimize the database by creating materialized view and aggregate awareness.

Generated Reports using the Universe as the main Data provider and also using the personal data files provided by the users.

Developed critical reports like drill down, Slice and Dice, master/detail for analysis of parts benefits and headcount.

Implemented Aggregate, Filter, Join, Expression, Lookup and Update Strategy transformations. Used debugger to test the mapping and fixed the bugs. Developed reusable transformations using Mapplet Designer. Implemented the ETL process and business logic by using PL/SQL.

Developed universe user documentation guide for the end users reference.

Environment: Windows NT, Oracle 9i, IBM-AIX, Cognos, Sql Server 2003, MS-Excel, Informatica 6.2, Business Objects 7.1.

MOBILE TELE SERVICES (MTS) June 2003 -Feb 2004

Role: ETL Consultant

The largest telecommunication vendor `MTS' that serves 123 million customers.

http://www.mts.ru

Project: Extending & Support Enterprise Data warehouse.

In large data warehousing (more than 20+ Tb) implementation and Oracle large-scale VLDB (as a main source) 10+ Tb environments:

Contribution:

Developed advanced mappings using Informatica Power Center.

Resolved performance issues in Informatica Power Center work flows;

Tuned heavy-load Oracle database queries (billions rows) by implementing partition, indexing and materialized Views for using in Informatica Power Center mappings;

Implemented Aggregate, Filter, Join, Expression, Lookup and Update Strategy transformations. Used debugger to test the mapping and fixed the bugs. Developed reusable transformations using Mapplet Designer.

Involved in performance tuning of the Informatica mapping using various components like Parameter files, Variables and Dynamic Cache.

Collected business requirements and objectives and transformed business requirements into technical Specifications;

Involved in writing Unix Shell scripts to automate loading process, schedule them at crontab, and notified the Success / failure to users.

Environment: Informatica Power Center 6.1, Oracle 9i, SAS MDDB Server, Incremental loading and testing.

Dr.Reddys Mar 2002 to APR 2003

Role: ETL/ Pl/sql Developer

The Largest Pharmacy Company in India. involved in full project life cycle utilizing Oracle Data warehouse methodology (DWM).

Contribution:

Played a key role in designing and developing ETL model for the project.

Analyzed data sources and targets using Informatica Data Profiling option.

Designed and implemented ETL mappings/processes using Informatica Power Center.

Migrated the legacy PL/SQL code functionality into a mappings using Informatica Power Center;

Identified and resolved performance issues in Informatica Power Center mappings and work flows.

Designed some dimensions, especially slowly changed dimensions type 2 and type 3.

Created some applications modules and stored procedures, views, triggers using Oracle PL/SQL.

Determined data acquisition requirements.

Environment: Informatica Power Center 6, Oracle Database 9i/10g, Toad, and win 2000.

EDUCATION:

Bachelors of Engineering in Electronics,

Nagpur university, Electronics -2002

Contact this candidate