SUMMARY:

• 14+ years of experience in Data Warehouse & Application Development Systems. Experience in implementing the complete Software Development Life Cycle (SDLC) process.
• Expertise in creation of Data Warehouses, Data Marts and Dimensional Data Modeling. Created various Logical/Physical Data Models for many Data Confidential implementations.
• Involved in continuous Performance Tuning & improvements for existing OLAP systems. Strong in developing reports and implementing Business Intelligence solutions.
• Successfully installed and upgraded lower versions to higher versions & migrated application data.
• Captured Requirements related to ETL, Data Quality, Scorecards, Dashboards and Reports. Captured the enhancements from various entities and provided Impact analysis.
• Designed & implemented pilot projects using various set of BI tools involving the latest features & product trends available in the market.
• Evaluated various tools & technologies related to Databases, ETL, OLAP & BI Systems
• Expertise in Business Objects and worked extensively on Xcelsius Dashboard & Performance tuning.
• Have good experience in other BI Tools, ETL tools & worked with many high performance databases.
• System Optimization, performance monitoring and tuning experience in Business Intelligence systems.
• Good experience in debugging SQL Code developed PL/SQL scripts, stored procedures and triggers to extract and load the data. Experience in Unix shell scripting to Automate and schedule the jobs.
• Supported and maintained many application systems thereby ensuring all deliveries are met within time
• Self - initiative, Excellent Analytical, Communication skills, can work independently & good team player.
• Designed key system architectures with complete Systems integration involving various modules.
• Created first of a kind unique Data Model for Intelligence Domain, which was appreciated by Client.
• Developed Multiple ETL processes for data loading data to Facts, Dimensions & other tables
• Developed various Semantic layers such as Universes, RPD, Framework’s and fine tuned the queries generated. Developed complex reports and Dashboards as per the business requirements.
• Coordinated test plans, test cases which provided feature / functionality / usage scenarios. Created Strategy & Roadmap with execution plan, there by monitoring the progress of the projects.
• Provided Training for the Technical and Business users in terms of operations & usability.
• Implement various data warehouse projects in Waterfall & Agile methodologies.
• Worked as Solution Architect, Business Analyst, Technical Lead, ETL Lead & Developer and BI Lead.

TECHNICAL SKILLS:

Core: Business Intelligence(BI), Data Analytics & Data Warehouse Implementation.

Verticals & Domains: Advanced Intelligence & Crime Analytics, Banking, Education, Energy Markets, Equities, Finance, Insurance, Retail, Telecom

Primary: Reporting Skills

SAP Business Objects XI 4.1 (IDT, UDT, Webi, Deski & Administration): SAP Business Objects Xcelsius / Dashboards 4.1

SAP Crystal Reports XI/2008/2013: SAP Business Objects Query Browser, QAAWS & Live Office

SAP HANA Modeler 1.0 SPS7: SAP Lumira 1.8 & Design Studio 1.3.

Secondary Reporting Skills: IBM Cognos (8.4 & 10.1) Report/Query/Analysis/Metric Studios.

IBM Cognos Administration & Framework Model.: Oracle Business Intelligence Ent. Edition(OBIEE) v10.1.3 & 11g

Tableau.: MS SQL Server Reporting & Analytical Services(SSRS & SSAS) 2008 R2

IBM Identity Insight 8.1 & SPSS 14.2: Oracle Financial Services (OFSAA) v8.0

SAS (Statistical Analysis System) BI Suites of Tools 9.3SAS DI 4.2 & SAS Data Flux v2.1, Enterprise Guide 4.3Information Map Studio, OLAP Cube Studio.: SAS Activity Based Management (ABM).

ETL Tools: Informatica, IBM Data Stage & Quality StageMS SQL SSIS, SAP Data Integrator / Data Services.

Databases: Oracle EXADATA 11g, SAP HANA, Oracle 10g/11i, IBM DB2 v7/8/9/10ISAS DB2 10, Netezza, NCR Terradata 12 & MS SQL 2005/8

Modelling Tools: Erwin, InfoSphere Data Architect, Viso Data Modeler

Programming: Java v6, C++, VB Macro, PL/SQL & Unix Shell Scripting.

Scheduling Tools: AutoSys 4.0/4.5, Corntab & Control M.

Operating Systems: HP Unix, Linux, Windows 2003/2008 & Sun Solaris 9/10.

PROFESSIONAL EXPERIENCE:

Confidential

Technical Lead

Responsibilities:

• Implementation of complex dashboards with best visualisation capabilities demonstration.
• Design and develop the SAP reports and universes using IDT and based on HANA Models.
• Working on creation of Dashboards with supported features for Mobile(iPad) based devices
• Creation of HANA models such as Attribute Views, Analytical & Calculated Views
• Created Tableau Scorecards and dashboards.
• Providing the Support & Warranty thus ensuring that the reports / dashboards are properly delivered to the authorised recipients’ and into their hand held devices within the stipulated time.

Technologies Skill Set: Business Objects, HANA, Lumira, BODS, Tableau, Erwin, Suse Linux.

Confidential .

Solution Architect

Responsibilities:

• Understand the requirements & business logic to implement the same into report.
• Created the Data Model as per the requirement and considering all the functional inputs.
• Created ETL Mappings in Informatica, besides Testing & validating the deliverables of the subordinates.
• Design and develop user specific complex reports and universes as per the user requirement.
• Involved in the Creation of the Reporting requirements using Business Objects Dashboards with Implementation of Key row level, role based Security based on Zone, Region and Location.
• Ensuring that each Sprint wise deliverables in the agile methodology are properly rolled out in production environment without any slippage with proper support and warranty SLA’s meet.

Technologies Skill Set: Business Objects, Informatica, Java, Oracle, Erwin .

Confidential .

Solution Architect & Project Manager

Responsibilities:

• Currently assigned the responsibilities of the Solution Architect and Data Modelling along with the leading the delivery of ETL with Data quality routines & Reports Modules.
• As a Business analyst to captured the requirements / enhancements from end business users and analysing the gap / Impact analysis.
• Create first of its kind unique Data Model for Crime Intelligence Domain, which was well appreciated.
• Provided a robust architecture by integrating all of the solution components provided by the IBM Stack.
• Providing the Roadmap and execution plan for all the deliverables and monitoring the progress as per the schedule. Providing the Status report to the Senior Executive Management.
• Created ETL Mappings with DQ routines, used Information Analyser to profile various source systems
• Various Models and Packages were created using Framework Manager and published the reports.

Technologies Skill Set: Cognos, Data Stage, Quality Stage, Identity Insight, ISAS DB2, InfoSphere Data Architect.

Confidential

Project coordinator & Consultant

Responsibilities:

• Assigned responsibilities of the Project coordinator & Business Analyst for the Group and all six Entities.
• Providing the Roadmap & execution plan for all entities and there by monitoring the progress.
• Capturing the requirements from all the Entity business users and provide the gap / Impact analysis.
• Assist the Entity Finance users in identifying the reconciliation logic and validating the group.
• Testing the reports and deliverables and ensure that the UAT is executed properly.

Technologies Skill Set: SAS BI Enterprise Guide, SAS DI, SAS Data Flux, SAS ABMConfidential

BI Lead

Responsibilities:

• Currently assigned the responsibilities as a Technical Lead involving the following list of Task
• Analyse the Business requirements and identifying the requirements feasibility.
• Providing the team with all the technical and functional assistance in terms of design and development.
• Testing the MIS & Analytical reports and deliverables and ensure that the UAT is completed.
• Reconciliation of data for the different source systems and thereby validating data loads / Rejections.

Technologies Skill Set: Business Objects, PL/SQL, Terradata, Unix .

Confidential

Consultant & Project Manager

Responsibilities:

• Creation of BI Implementation Strategy & Roadmap with best practice recommendations
• Evaluation of various tools & technologies for Databases, ETL, OLAP & BI solutions (evaluated SAP, Microsoft, Informatica, IBM & Oracle OEM’s)
• System Requirement Specification Document including the recommendations & Capturing of KPI’s, Scorecards, Dashboards, Operational Reports, Analytical Reports & Balanced Scorecard.
• Development of Pilot projects Implementation involving the various products.
• Data Model Design Document, BI Architecture, ETL Mappings & OLAP Reporting systems.

Technologies Skill Set: Business Objects, OBIEE, SSRS, SSIS, SSAS, PL/SQL, SQL Server, .Net, SharePoint .

Confidential

BI Lead

Responsibilities:

• Designed the ETL process to load data from multiple LOBs source to target Data Warehouse.
• Implementation of POC using QAAWS, Live Office, Reports, universe and Security Implementation.
• Implementation of Key row level, role based, folder and application level Security.
• Developed and delivered the critical Management and CFO Dashboards.

Technologies Skill Set: Business Objects, PL/SQL, Oracle, Windows 2003 .

Confidential

Technical Lead

Responsibilities:

• Assigned the responsibilities as a Solution Architect involving the following list of Task
• Implementation of best practices in terms of design, development and Support.
• Gathering the Business requirements and identifying the requirements feasibility.
• Design and develop the reports and universes as per the user requirement.
• Involved in the Creation of the Reporting requirements and Dashboards.
• Implementation of Key row level, role based Security based on Zone, Region and Location.
• Completing the UAT phase and providing support phase.

Technologies Skill Set: Business Objects, BODI, PL/SQL, Oracle, Erwin, Solaris .

Confidential

Solution Architect

Responsibilities:

• Designed the key System Architecture as per the client’s requirement.
• Implementation of best practices in terms of design, development and documentation standards.
• Provide the Complete System integration involving the BOXI and BODI.
• Provide the training the technical staff & Business user.
• Review and communicate with business users and getting sign off at each phase of the project.
• Completing the SIT & UAT phase and providing adequate support for Warranty and project closure.

Technologies Skill Set: Business Objects, Crystal Reports, BODI, PL/SQL, Oracle, Erwin .

Confidential

Project Lead

Responsibilities:

• To Perform System Analysis & Identifying Key Requirements of the user with Gap analysis.
• Analyze Business requirements, review and communicate with business users and get sign off.
• Designed and implemented the necessary Data Marts & architecture for the reporting services.
• Implementation of necessary Pl/Sql scripts which extract and load the data into Data Mart
• Created system delivery specification documents, Technical Specification documents and test plans.

Technologies Skill Set: Business Objects, PL/SQL, Oracle, Netezza, Unix .

Confidential

Team Lead

Responsibilities:

• To lead the project, Designing mock-up summary and detail reports for the same.
• Performed studying the existing system and gathering the requirements and identifying the gaps.
• Converting the gap items into technical design documents and created the necessary views and Aggregate tables to enhance the performance of the reports to satisfy the customer requirement.
• Designed customized reports to supply the business with improved flexibility and functionality.
• Coordinated test plans, and provided feature / functionality / usage scenarios for the Managers.

Technologies Skill Set: Business Objects, PL/SQL, Oracle, Java .

Confidential

Senior Software Developer

Responsibilities:

• To design and implemented the necessary Data Mart & architecture for the reporting services.
• Implementation of necessary pl/Sql scripts which extract and load the data into Data Mart.
• Created cross linking reports as per the requirements by providing hyperlinks between reports.
• The complete drill features of the Full client reports is implemented in the web Interface reports
• Handling ad-hoc user requirements and providing status reports to management.
• Designed complex reports that suffice the business needs with improved flexibility & functionality.

Technologies Skill Set: Business Objects, PL/SQL, Oracle, Netezza, Unix .

Confidential

Senior Software Developer

Responsibilities:

• To lead the Team, Understanding the Business needs and the Workflow.
• Providing the Production Support, thus ensuring that the Batch procession is completed and the status report are delivered to the users on time and solving all the issues related to the support.
• Interact with the various users across the globe, understand requirements and provide solutions.
• Handling ad-hoc user requirements and providing status reports to management
• Providing and maintaining security implementations for data and reports

Technologies Skill Set: Business Objects, Informatica, DB2, Unix, Autosys & Perl script .

Confidential

Software Developer

Responsibilities:

• Providing the Production Support, thus ensuring that the Batch procession is completed and the status report are delivered to the users on time and solving all the issues related to the support.
• Creating various Universes as per the specific Domain and tuning the queries generated and suggesting the various indexes to be created.
• Developed ETL process for data loading data to target facts & Dimensions.
• Generated reports as per the business requirements. Ensuring the reports are delivered to the users on time and solving all the issues related to the support.

Technologies Skill Set: Business Objects, Informatica, DB2, Unix, Autosys & Perl script .

Confidential

Software Developer

Responsibilities:

• As a team player, Analysis of software modification request and change request from customers and defining the time frame for delivery and development, testing and delivery of the application.
• Involved in the designing of the front-end applications. Developed & tune the PL/SQL stored procedures, triggers.
• Handling ad-hoc user queries and providing status reports to management, Responsible for end user training to work on reports.
• Designed the ETL process to load data from source to target databases using Informatica.
• Developed mapping and sessions for data loading, developed mapping to load the data in slowly changing dimension
• Used workflow Manager to create, schedule, monitor session, and send the messages in case of process success/failure. Involved in the development/tuning/debugging of mappings.

Technologies Skill Set: Business Objects, Informatica, Java, Oracle .