• Staging, Facts, and dimensions created in SQL DB to store data from IMDB, Critic sites, Personal Catalogue.
• SSIS ETLs to delta load year-wise data from IMDB files, scraping websites, My Catalogue into Staging, DW.
• 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 that support Audit and Error process and Recycle and 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 functional requirements. Creating Technical Designs, developing and managing data warehouse applications.
• Creating Data MAPPING documents based on the client requirement.
• Providing support to business users for resolving technical issues, solving data-related problems, and providing tool-based training for users.
• Creating Data visualization various Dashboards using MS Power BI and Tableau

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

Business Object Live Office, SAP BW

Roles and Responsibilities:

• Data gathering from client /Business and database understanding as per analytics requirement using SQL and SAP BO.
• Using MS Word Excel, VBA, and MS access as required by the client.
• Web intelligence report creation (SAP BO/DS / 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 requirements.
• 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 addressing performance issues.
• Web intelligence report creation with multiple queries, custom SQL, using complex functions.
• Created reports as per requirements and formatted reports as per the user requirement.

User requirements using the functionalities extensively in Business Objects, which allows the users to analyze the data

Lead analytics of Card product loss portfolio. Accountable for KPI measurement such as loss volumes, delinquency, roll rates, and charge off. In charge of weekly, monthly, and quarterly reports distributed to senior leadership. Core responsibility includes providing insights to support strategic decisions for credit card methodology (time series analysis).

• 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 the Business Objects Designer tool.
• Skilled 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.
• Using MS Words Excel, VBA, and MS access as required by the client
• 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 LaunchPad, SAP Business Objects Explorer

Lead analytics of Card product loss portfolio. Accountable for KPI measurement such as loss volumes, delinquency, roll rates, and charge off. In charge of weekly, monthly, and quarterly reports distributed to senior leadership. Core responsibility includes providing insights to support strategic decisions for credit card portfolio using SAS analytical tools, SQL, statistical modeling techniques such as regression, cluster, neural networks, etc. methodology (time series analysis).

• Liaise with risk Executives, IT, and Finance to ensure data accessibility, data quality, and data tools are
• aligned with analytics goals for predictive modeling, analytics, reporting across risk management ensuring TD bank data governance.
• Identifying irregularities and inconsistencies in data and using different strategies to ensure data is accurate and available for analytics and reporting.
• Implementation of automated BO tool for prediction of losses. Created a loss forecast model using SAS statistical analytics and stressed using economic variables for strategic segmentation scenario analysis.
• Prepare pre-campaign and post-campaign analytics on loan loss KPI and advise marketing on findings.
• Deep dive into data to find issues and trends on risk parameters such as channel analysis, credit scores, origination, month on book, product type, and customer segmentation.
• Knowledgeable in creating interactive reporting solutions including dashboards, ad-hoc reports, and visualizations in Microsoft Power BI
• Improve analytical and prediction processes by discovering new variables, analytical techniques, and control processes and continuous enhancement of the card portfolio strategy using power BI Tool