Resume

Sign in

Sql Server Project

Location:
Mysuru, Karnataka, 570001, India
Posted:
October 12, 2016

Contact this candidate

Sunil Kumar Rai

Mobile: +91-971*******

Email: acw0wp@r.postjobfree.com

Objective:-

To secure the challenging position where, I can effectively contribute my skills as software professional.

Career Summary:-

3 Years of working experience in SAP Business Objects (Version 3.1, 4.0 and 4.1) includes Web Intelligence Reports, IDT, UDT and Xcelsius Dashboards, developed universe with measures, dimensions, join conditions, filters, LOV, cardinality, aliases, contexts and aggregate awareness using IDT and developed complex reports including linking documents, cascading prompts.

Worked on SAP HANA 1.0 including data provisioning, modeling, reporting and administration.

Replication using Data Extraction Transfer Loading (ETL) using SAP BOBJ Data Services 4.0, SAP HANA Data Provisioning and using SLT and BODS, developed data modeling using Attribute View, Analytic View, and Calculation View and Implementation experience and knowledge of SAP HANA reporting for different functional area. Consuming SAP Hana views on IDT to deliver business layer using web intelligence and have proven experience with reporting specially handling complex scenario's using joins and SQL.

6 Months working experience in MS reporting tool SSRS including creation of reports, model for ad-hoc reporting and 3 months working experience in SAP BPC including development of reports and input forms.

Good knowledge of Microsoft SQL Server, Oracle and Azure SQL databases, SQL programming includes stored procedures, functions, triggers and complex SQL queries.

Deloitte Experience:-

Project: 1

Industry: Finance

Service Area: Business Objects, SAP HANA

Industry Segment: Finance

Role: Developer: SAP Business Objects, Oracle and SQL Server

Duration: May 2016 to Till Now.

Client Description: - Agilent Technology was created when it spun off from Hewlett-Packard Company in 1999. Since then the company has won hundreds of awards for innovations and has earned even more patents for its inventions. More important is that the number of customers we serve grows each year another reminder of the power of our partnership.

Project Description: - My Compliance is the module I have worked upon, it is the overall company balance sheet, p&l, operating expenses for different company code country wise. Analytics admin module uploads the data in BS (balance sheet) and PnL (profit and Loss), after uploading data in the BS and PnL, BS and PnL reports get refreshed for MEC, QEC and MIS Dashboards. Opex reports automatically refreshed after PnL data load. Opex reports picks 8 series NAs from backend and after grouping functional NAs form the PnL. SOB to Company Code changes made in all the My compliance module as per the project UNO. Currently data is coming from HFM, earlier it was from SAP.

Role: -

Experience in designing and development of Web Intelligence Reports in BO 4.1 and Oracle 11.2. Created calculation view in SAP HANA and used this view in the universe.

Creating Universe with Measures and Dimensions, Join Conditions, Filters, LOV, Cardinality, Aliases, Contexts and Aggregate Awareness using IDT and UDT.

Developed Web Intelligence Reports user Documentation guide for the end users reference.

Technical Environment: SAP Business Objects 4.1, Oracle 11.2

Project: 2

Industry: Banking and Insurance

Service Area: Business Objects, SAP HANA, Design Studio

Industry Segment: Banking and Insurance

Role: Developer: SAP Business Objects & Oracle

Duration: November 2015 to May 2016.

Client Description: - CNO Finance is a financial services holding company based in Carmel, Indiana. It is insurance subsidiaries provide life insurance, annuity and supplemental health insurance products to more than four million customers in the United States. These products are distributed through independent agents, career agents and direct to customers through television advertising and direct mail.

They were ranked 608 on the Fortune 1000 with 2014 revenues of $4.1 billion and 50 most trusted financial institutions by Forbes.

Project Description: - CNOFDW (CNO Financial Data Warehouse) is one of the key components of the overall CNO Finance Solution, which delivers key accounting information to help analyse policy, claim and suspense information. CNO has requested Deloitte’s assistance to perform a root-cause analysis and provide recommendations to address poor reporting performance and imparting added values to reporting system.

Role: -

Experience in designing and development of Web Intelligence Reports in BO 3.1 and 4.1 and Oracle 11.2. Created calculation view in SAP HANA and used this view in the universe.

Creating Universe with Measures and Dimensions, Join Conditions, Filters, LOV, Cardinality, Aliases, Contexts and Aggregate Awareness using IDT and UDT.

Tested the Reports and Universe as per developer.

Developed Web Intelligence Reports user Documentation guide for the end users reference.

Technical Environment: SAP Business Objects 3.1, Oracle 11.2

Project: 3

Role: Developer

Duration: Jan 2015 to November 2015

Client Description: - United States Golf Association (Abbreviation: USGA)

Project Description: - The USGA serves the game most visibly through the conduct of its national championships. Together with The R&A, the Association provides governance for the game worldwide, jointly administering the Rules of Golf, establishing equipment standards, and formulating the Rules of Amateur Status. The Association also maintains the USGA Handicap and Course Rating Systems, develops and promotes sustainable golf course management practices, and celebrates the history of the game.

Web Server: IIS

Framework: .Net Framework 4.5

IDE: Visual Studio Professional 2013

Server Side Technology: ASP.NET using C#

Scripting Language: JAVA SCRIPT/ JQuery

Markup Language: HTML /XHTML

Advanced Features: AJAX, SSRS

Database: SQL Server 2012, Azure SQL

Project: 4

Role: Developer

Duration: May 2014 to December 2014

Client Description: - International Initiative for Impact Evolution (Abbreviation: 3IE)

Project Description: - 3ie Grant Management System is an online web portal for managing and tracking 3ie’s various grant cycles. It automates the application submission and application review processes. It enables applicants to register and submit detailed applications online. Program office at 3ie allocates these applications for review to internal and external reviewers who comment and score the applications online. Selection of the final candidates is done based on these scores and reviewer recommendations.

Web Server: IIS

Framework: .Net Framework 4.5

IDE: Visual Studio Professional 2013

Server Side Technology: ASP.NET using C#

Scripting Language: JAVA SCRIPT/ JQuery

Markup Language: HTML /XHTML

Advanced Features: AJAX, SSIS, SSRS

Database: SQL Server 2008 R2

Project: 5

Industry: Banking and Insurance

Service Area: Business Intelligence

Industry Segment: Banking and Insurance

Role: Developer and Tester

Duration: January 2014 to May 2014.

Client Description: - Monitoring Authority of Singapore (Abbreviation: MAS).

Project Description: - The Monetary Authority of Singapore is Singapore's central bank and financial regulatory authority. It administers the various statutes pertaining to money, banking, insurance, securities and the financial sector in general, as well as currency issuance. The MAS has been given powers to act as a banker to and financial agent of the Government. It has also been entrusted to promote monetary stability, and credit and exchange policies conducive to the growth of the economy.

Role: -

Experience in designing and development of Web Intelligence Reports.

Experience in creating Universe with Measures and Dimensions, Join Conditions, Filters, LOV, Cardinality, Aliases, Contexts and Aggregate Awareness using Business Object Designer (IDT).

Experience in designing and developing Dashboards using Xcelsius2008.

Tested the Reports, Dashboards and Universe as per developer and user level.

Developed Web Intelligence Reports/Dashboard user Documentation guide for the end users reference.

Project: 6

Industry: FMCG Sector

Service Area: Business Intelligence

Industry Segment: State Government

Role: Developer

Duration: September 2013 to January 2014

Client Description:

Coca-Cola Company is the world's leading owner and marketer of nonalcoholic beverage brands and the world's largest manufacturer, distributor and marketer of concentrates and syrups used to produce nonalcoholic beverages.

Project Description: The Inventory Planning and Reporting at Coca Cola continues to be in Excel in which the client was facing problems in ad hoc reporting and doing variance analysis which was prone to problem of manual intervention of Inventory department. The client wanted a single system to hold their data and help in their product wise as well as bottler wise comparisons. So, proof of concept was created by Deloitte showcasing the various functionalities of Inventory Analysis and how easily they can achieve their goals by the use of this Solution.

Role:

Actively participate in requirement gathering and analysis.

Actively participate in discussion for Data Modeling.

Developed Data Base Scripts based on Business Logics.

Designed, developed and execute ETL scripts for data loading into new system

Developed Dashboards and Reports.

Technical Skills:-

Programming Languages : ASP.NET, C#, C

Database : SQL Server, Oracle, Azure SQL.

Operating Systems : Windows, Windows Server 2008 R2.

Other Technologies and tools: SAP Business Objects, SAP HANA, Web Intelligence,

IDT (Information Design Tool), UDT (Universe Design Tool), Xcelsius Dashboards, SAP BPC, HTML, XML, Java Script, CSS, SSRS (SQL Server Reporting Services), SAP Design Studio.

Academic & Professional Qualifications:-

Completed Master of Computer Applications (MCA) from Ajay Kumar Garg Engineering College, Ghaziabad with 75% in the year 2013.

Completed Post Graduate Diploma in Computer Application (PGDCA) from Concept Institute of Technology Varanasi with 67% in the year 2010.

Completed Bachelor of Science (BSc) from Dr. Ghanshyam Singh P G College, Varanasi in the year 2009.

Passed Senior Secondary School Certificate Examination from Queens Inter College, Varanasi in the year 2006.

Passed Secondary School Examination from Queens Inter College, Varanasi in the year 2004.

Extra-Curricular Activities:-

Awarded for 100% Attendance in my college AKGEC.

Received excellent performance award from Deloitte for year 2014.

Completed CCP (Campus Connect Program) conducted by Infosys in AKGEC.

Participated in workshops on Linux, Webtech and Android.

Participated in various programming competitions in college quiz competitions.

Mentored students under Mentorship Program conducted by AKGEC.

Participated in Tech-Trishna and Java Guru events in my college.

Done Industrial Training from HP Education Services Noida in .Net Technology.

Completed Training in Automation Anywhere tool from company’s development center in Vadodara.

Completed STEP (Strive towards excellence program) training conducted by Deloitte.

Awards:-

Best Employee of the Year Award 2014 - Deloitte Consulting, Technology Integration.

I, Sunil Rai hereby declare that the above-mentioned information is true to the best of my knowledge.

Place: Gurgaon

Date:



Contact this candidate