• Lead team of BI Developers and Analysts on BI strategy initiative projects• Lead design and development effort on business intelligence dashboards, score cards and KPIs using Power BI Desktop• Design dashboard prototype (Excel Services), provide time-line estimate and work with developers to complete development of dashboards.• Architect the IT hardware infrastructure and lead effort on deployment of SQL servers for BI strategy projects• Perform design, develop and prepare time-line estimate for database schemas, tables, views, functions, stored procedure, SSIS packages (ETL) and SQL jobs for data warehouse project• Collaborate with business users to ensure that data warehouse, data mart and analytical cubes meet business needs for operational and analytical reporting• Design and create physical and logical (dimensional) data models for data mart project based on business requirements• Lead effort on data mart and OLAP cube analysis/design process• Oversee Jobs for executing the stored SSIS packages which were developed to update the database on daily basis

• Designed storage definitions for all enterprise data such as databases, tables, schema, etc.• Design and develop BI self-service report models and report templates using Report builder 3.0• Troubleshoot and work on performance tuning in database and reporting• Use SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases• Design and implement complex SSIS package to migrate data from multiple data sources for data analyzing• Prepared designed document, technical design and flow diagrams• Developed stored procedures for efficient access and manipulation of data• Developed ETL (SSIS) packages to transform data from legacy systems into ODS and to stage ODS data into EDW• Created several SQL Server Agent job scripts to execute SSIS packages• Utilized (Power BI, Pivot/View) to design multiple scorecards and dashboards to display information required by different departments and upper-level management• Created data marts and multi-dimensional models using Star schema and Snowflake schema approaches• Extensively used DAX (Data Analysis Expressions) functions in report measures and for the tabular models to improve business processes• Implemented Key Performance Indicators (KPIs), design of star schema and snowflake schema in Analysis Services (SSAS)

• Built data warehouse and reporting infrastructure from the ground up using T-SQL, SSIS, SSAS, SSRS and power bi to provide near real-time insights into credit monitoring - loan monitoring, loan origination and business units KPIs within project time allotted. It provided a 14 percent turnaround time to access information and making it possible to access the information at anywhere and at any time.• Designed and implemented channels performance for channel products and measure the KPIs of different officers, business units and provide management insights to understand the level of product performance and profitability• Developed ATM Management solution reporting using ETLs - Python, SQL, and other data sources Connecting to FEP - Postillion data, Banking solution GLs accounts and ATM E-journal for three-way reconciliation saving ~10 hours of daily labor to reconcile unbalanced accounts and avoid sanctions from regulatory body - CBN.• Used stored procedures, triggers, and views to provide structured data to business units by combining millions of rows of data from disparate data sources to create data-warehouse, data marts• Implemented security guidelines by using user filters and row-level security, reducing private data exposure• Schedule Jobs for executing the stored SSIS packages which were developed to update the database on daily basis

Configured and installed SQL Server on Windows 2003+ Server. Migrated databases from Oracle database to MS SQL Server 2008/2014. Involved in normalization of the Database in OLTP. Responsible for the creation of reports/cubes using SQL Server Reporting Services (SSRS) and Analysis Services (SSAS). Involved in Report Design and Coding for Standard Tabular type reports. Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS, Performance Point, Clarity. Skilled in Developing SSAS Cubes, Dimensions, Facts and data source view SSAS-Data Mining Models and Deploying and Processing SSAS objects also a designed and developed SSIS packages. Gathered requirements and design of data warehouse and data mart entities.Created visualization dashboards for Tavia clients to identify opportunities in their various businesses. Provide on-call support to production system to resolve any technical issues. Created tickets, prioritized, and escalated issues using Remedy based on SLAs.

Involved in requirements analysis, development, deployment, unit testing of components and activities and status reporting for all software projects both internal and external vendors. Developed and maintained software application for ALPS warehouse management using VB.NET and MS Access Database. Developed and maintained software application for ALPS Logistic operations using VB.NET and MS Access Database. Converted and maintained various daily operational excel files to MS Access. Worked with personnel or other departments as the IT resource person. Administered and managed ALPS’ physical network and mail servers. Picked knowledge of Logistics operations, other duties assigned.

Developed and designed three critical software programs for financial tracking and reporting.Optimized user effectiveness by creating a detailed feedback queue for users to discuss functionality, convenience, and effectiveness.With a team of software developers and lead weekly discussions to brainstorm ideas in software development and to track changes made in existing programs.