SUMMARY

• More than ten years of Data Analytics, Technical Design, Development, Data migration from one system to another, Testing and Documentation including ten years of BI experience and more than four years of programming experience in Application development and Application BI architecture.
• Having good experience as Business Analyst - requirements gathering, Business requirements writing, Use Case development, and Analysis & Organizational skills, Excellent analytical and logical skills with a good understanding at the conceptual level and possess excellent presentation, interpersonal skills with a strong desire to achieve specified goals.
• Able to interact effectively with other members of the Business Engineering, Quality Assurance and other teams involved in the Software Development Lifecycle.
• 10+ yrs.' experience of creating data visualization dashboards using, SAP BOBJ, Power BI, Tableau and SSRS.
• Proven experience in Banking Risk Reporting using SSIS, SSAS, and SSRS, Power BI in various projects.
• Superior Excel and VBA skills and working Knowledge of report creation for various Users
• Knowledgeable in using SAP Business Object 4.2 to produce detail financial report.
• Experience in creating Details documentation from SAP Business Warehouse data migration project.
• 10+ years of hands-on experience with a sound knowledge of MS BI Tools
• Costing and Financial analysis experience using SAP BOBJ, Lorenzo, and SAP Crystal report
• 7+ years’ experience SQL Server Integration Services ( SSIS ) and SQL Reporting Services (SSRS)
• Experience of testing Patient Administration Systems (PAS) in SAP and SQL Data Ware House
• Experienced using SQL Server Reporting Services (SSRS) over 5 years
• Advance Knowledge of using SQL 2008, SQL 2010, SQL 2014, SSAS, SAS EG
• Knowledgeable in using SAP Crystal Report to produce detail financial report
• Experience of using PivotTable for advance Dataset Analysis / Reconciliation
• Advance knowledge of Excel/VBA and MS Access Database, HP ALM experience
• Experience in Scheduling automated report using SSRS SSIS and SQL 2008
• Experience in MS SQL 2005, 2008 and 2012 reporting service

TECHNICAL SKILLS

• Programming Languages: SQL, VBA, Base SAS 9.3, SAS Enterprise Guide 5.1, ETL
• Operating Systems: Windows, UNIX, HP ALM experience, Mainframe (TSO, ISPF, JCL)
• Development Environment: 2010 Visual Studio, 2008/2010 SQL Server Management Studio (SSMS), SAP Business Object 4.2
• Database: SQL Server, Oracle, MySQL, Mainframe, SAP S4 BW MS SQL Server on Azure platform
• ETL: SSIS, Data Stage, SAP Hana Studio, SAS Enterprise Guide 5.1
• Cloud Services: Microsoft Azure Services, Cognitive Services
• Microsoft BI Tools: Microsoft Analytic, Reporting Services, Performance Point Services, Secure Store, Power BI Microsoft SQL Server Integration Services (SSIS)Microsoft SQL Server Analysis Services (SSAS)Microsoft SQL Server Reporting Services (SSRS)H - Lookup, V-Lookup, Excel, PowerPivot, Power ViewsMicrosoft Power BITeradata Fast Load, pivot tables, costing models, Business cases, and Fast Extract
• Data Knowledge History: Data Modelling, Data Mapping, Data transformation, Data Lineage and Data Catalogue
• Financial Skills: Knowledge of Capital Markets and financial products

PROFESSIONAL EXPERIENCE

Confidential

Senior ETL Data Integration Developer

Skill Used: SAP Business Object 4.2, Dashboard, Web Intelligence Report, MS SSIS, MS SSRS, MS SQL

Responsibilities:

• Experience in DataStage, Data Warehousing, DataMart's, Data Migration and DWH Testing with exposure to industries like Banking and Insurance.
• Power Query - import DW, transform, add, extract, group, custom column, replace, change type, M functions.
• Power Pivot - star data model, active and inactive relationships (1-1/M, M-M), bi-directional cross filtering.
• DAX - measures by calculate, filter, all, aggregate, variables, if, format, related, lookup. Decade, Year trends
• Power BI View - Synced Slicers, Filters - visual, page, report, advanced like TOP N. Conditional formatting,
• Visuals - table, column, bar, charts. Drill through. Dynamic chart axes by Bookmarks. Deploying to Service.
• Extensive Experience in full life cycle development of Data Warehouse including requirement gathering, source data analysis & profiling, identification of business rules and development of ETL jobs.
• Very proficient in building Metadata driven ETL frameworks which supports Audit and Error process and Recycle and 2 implementations, variable frequency loads by handling Late Arriving Dimensions etc.
• Experience in coordinating deliverables through a global delivery model using Agile & waterfall methodologies.
• Interacting with the Business team and collecting the functional requirements. Creating Technical Designs, developing and managing data warehouse applications.
• Creating Data MAPPING documents based on the Client's requirement. Beginner's experience on Hadoop Hive database and worked on extracting data into Netezza.
• Providing support to business users for resolving technical issues, resolving data related issues and providing tool-based trainings for users.
• Creating Data visualization various Dashboards using MS Power BI and Tableau
• Staging, Facts and dimensions created in SQL DB to store data from IMDB, Critic sites, Personal Catalog.
• SSIS ETLs to delta load year wise data from IMDB files, scraping websites, My Catalog into Staging, DW.

Confidential

Senior SAP Business Object Developer

Skill Used: SAP Business Object 4.2, Information Design Tool, Dashboard, Web Intelligence Report, SAP

Responsibilities:

• Data gathering from client /Business and database understanding as per analytics requirement using SQL and SAP BO.
• Web intelligence report creation (SAP BO / SSRS) with multiple queries, custom sql, using complex functions, merging dimensions, drill down, input controls, filters, ranking, sorting.
• Create Users and groups and apply access rights. Schedule reports as per client requirement.
• Publish reports (Publications) to end users using dynamic recipients in SAP BO and SSRS.
• Dashboard Creation using SAP Microsoft Analytics office with BEX Query.
• Have resolved loops using context and alias and have built custom hierarchies and predefined filters to facilitate easy drill down and addressed performance issues.
• Web intelligence report creation with multiple queries, custom sql, using complex functions.
• Created query as per requirements and formatted reports as per the user requirement.
• User requirements using extensively the functionalities in Business Objects, which allows the users to analyse the data.
• SAP BEX Query design using SQL Codes as per business user requirements.
• Created various user defined objects including Dimensional, Detail and Measure objects and tested them to ensure correct mapping of data.
• Define alias and Contexts to resolve loops and tested them to ensure that correct results are retrieved.
• Documentation: Documenting the current business processed and customizing in the existing landscape and mapping the same to the S4HANA landscape requirements.
• Expert in preparation of reports using SAP Query and Report writer/Report Painter.
• Strong hands on experience in Record to Report (R2R) by designing the various business process flow in to the management & profitability analysis report build on report painter (Profit centre and business area dimensions).
• Expert knowledge of Quality Assessment Process and testing methodologies (HPQC tool & Live Compare for automated test scripting to ensure ZERO defect density through 360 degrees' analysis).

Confidential

Team Lead SAP Business Object Developer / Data Analytics

Responsibilities:

• Responsible for technical analysis, design, development, and testing of data connections, universes, and dashboards/reports creation.
• Build report/visualizations within the analytic framework to support key performance indicators (KPIs) and metric
• Review functional requirements, performance criteria, and data consumption needs to complete the design of technical components.
• Design and development of complex analytical queries, reports and visualizations utilizing the Enterprise Business
• Objects Suite of tools (e.g. Crystal Reports, Web Intelligence Reports, Lumira Visualizations and OLAP queries).
• Proficient in designing universes for querying, reporting and analysis using Business Objects Designer tool.
• Proficient in managing Business Objects in Development, Test, and Production environments, including migrating universes and reports from one environment to another.
• Experience with performance tuning Business Objects linking with MS SQL Server on Azure platform.
• Experience writing SQL, developing SQL stored procedures and highly interested in exploring data for anomalies and trends.
• Possesses excellent communication skills, both written and verbal.
• Extensive recent experience with Business Objects R3 (Designer and Administration) with bursting functionality including Desktop Intelligence and Web Intelligence.
• Expert in SAP Business Objects 4.1, 4.2 (SAP Crystal Reports 2013, Enterprise, SAP Business Objects Analysis, Information Design Tool, SAP Business Objects Dashboards, SAP Business Objects Web Intelligence, BI Launch Pad, SAP Business Objects Explorer
• Strong knowledge of Tableau 9.3, Tableau 10 design and development
• Strong knowledge of Data modelling, ETL design and development, and report development.