SUMMARY

• Innovative, strategic Business Intelligence, Data Management professional with a proven track record to identify, architect, and implement technology solutions in support of transformation initiatives.
• Recognized as a trusted adviser with a track record of creating successful technology solutions that support the organizational strategic vision and goals. Proven experience leading enterprise solutions in a variety of data science, complex data analytics, and business intelligence projects.
• Public Trust Clearance and Law Enforcement Clearance with the Confidential .
• Excellent oral and written communication skills, strong interpersonal skills.
• Strong analytical skills, including the ability to collect, extract, synthesize, and summarize relevant data, perform root cause analysis, and implement recommended scalable solutions.

TECHNICAL SKILLS

BI/DW: Tableau 2019.4.0, Power BI, SQL Server 2016, VBA, Amazon Redshift, AWS IBM Cognos 11.0.3, Cognos Enterprise Planning 8.2, Analyst, Contributor 8.2, Sql Server Technologies Azure, Power BI, SSIS 2008 R2, SSAS 2008, SSRS 2008 R2, I Dashboards, Informatica Power Center 7.1, SharePoint, MicroStrategy Web

BIG Data/Cloud: AWS Amazon Redshift.

Service Management: Service Now, ITIL

Databases: Oracle 11g, MS SQL Server 2016, Sybase, IBM DB2, Microsoft Access

ERPS: Salesforce, Deltek Costpoint6.0, Costpoint5.0, Deltek Time Collection, Softrax, Oracle Federal Financials, JIRA

Data Modeling: ER/Studio 3.5/4.0, Erwin 4.1, Visio Professiona2016

Operating Systems: WINDOWS 10, UNIX (Sun OS, Solaris), HP - UX, LINUX

Web Servers: WebLogic, WebSphere, Tomcat

Languages: Java, Python, SQL, PL/SQL, VBA, HTML, XML, Shell script

PROFESSIONAL EXPERIENCE

Confidential

Business Intelligence Architect

Responsibilities:

• Developing Advanced and Complex Reporting Solutions in multi-server environments.
• Advanced Report Development Solutions using Conditional Formatting, Prompts and Layouts.
• Deployed Complex reports for Costpoint Modules: Purchasing, Materials Management, Accounts receivables, Time Collection and Billing.
• Installation, Configuration and setup of Cognos Intelligence & Security, Ship Repair and IncSS environments
• Training Team Members on Server Administration.
• Tableau reports for the BAE App Commons Solutions.
• Expert in fixing problems with Financial models, sales orders,

Environment: Cognos 11.0.13, Tableau 2019.3.0,Oracle 19c, ServiceNow, MS Visio.

Confidential, Fairfax, VA

BI Architect

Responsibilities:

• Developed interactive Tableau dashboards and reports for Target Market, Bookings, Sales Pipeline, Operation Pipeline and Win Loss Reports respectively.
• Developed Visualizations for bookings and pipeline from AWS: Amazon RedShift data sources.
• Involved in problem definition, data exploration, data acquisition and visualization, evaluating and comparing metrics.
• Administered Tableau sales reports and configured detailed security based on regions and sales territories.
• Extensive data validation using Excel for the data extract taken from tableau Visualizations and for source data coming from AWS.
• Extensive SQL Server development involving views, tables and Stored Procedures for Target market analysis, which was classified as Confidential Owned or High, Medium and Low for 36 Different Confidential Product lines. Created SQL Server Views and Stored Procedures for Product Win and Loss.
• Developed ETL processes to load Product White Space data from Salesforce ODS to EDW. Experienced in data migrations and in sync processes between databases.
• Created source to target mappings and ETL design for integration of new/modified data streams into the data warehouse/data marts.
• Created Adjustment Tool to serve as prototype for adjusting and reconciling deals based on the pipeline and opportunity status. This involved data analysis in MS access and substantial development using VBA.
• Used MS Access extensively by utilizing tables, queries, forms, reports and macros for adjustment Tool.
• Processed and Maintained Inserts, updates and deletes into Salesforce Object: Product White Space
• Automated Target Marget ranking process. Saved the processing time from multiple days to 5 minutes.
• Embedded Python in Tableau for predictive analytics using tabpy, NumPy and pandas to forecast wins using Arma, Arima and Surimax Models.
• Enhanced the target market ranking process there by improving the sales by 40%
• Published and Maintained all the sales reports on the Tableau Server.
• Used Excel features like Power Pivot, Charts and Functions during data validations.
• Tested Tableau in multiple environments during Tableau version upgrades.
• Developed Budget vs Pipeline Dashboards.

Environment: Tableau 2019.3.0, AWS: Amazon RedShift, MS SQL Server 2016, SSIS, Python, Salesforce, Excel, MS Access and VBA

Confidential, Mclean, VA

Senior BI/DW Consultant

Responsibilities:

• Built relational SQL Server 2016 database for OPA 340B. Involved in creation of schemas, tables, indexes and constraints.
• Designed and Developed ETL jobs for the HRSA 340B Project using SSIS.
• Strong expertise in creating BAT scripts and Automation of SSIS jobs.
• Developed Scripts for SQL Server for enabling and disabling constraints before SSIS Load Process.
• SSIS Packages were automated so that they can run independently whether Trusted or SQL based Security.
• Developed SSRS Reports for the HRSA 340B (an HHS Agency) Compliance Management Tool

Environment: Microsoft SQL Server 2014, SSIS, SSRS, JIRA(Issue & Project Tracking)

Confidential

BI Architect

Responsibilities:

• Developed Complex Reports using Cognos 10.2 Report Studio for Confidential .
• Triggering of Event Studio reports based on triggered events.
• Cognos Administrator for All Cognos Servers, Dev, UAT and Production.
• Cubes Developed in Cognos Analysis Studio were used as source for the Cognos Workspace Dashboards.
• Developed and Maintained Cognos BI and Cognos Framework Manager Models.
• Mission Critical Reports were developed in Cognos for Arrest and Crime data. Worked with Informatica Team in loading Arrests and Crime data.
• Developed Arrest Summary Report and Crime Summary Reports and respective dashboards.
• Developed Reconcile reports between Unified Crime Data Reports vs DC Crime reporting data that is submitted to FBI.
• Weapons Audit Reports were delivered in Cognos and matched the I Leads application.

Environment: IBM Cognos Platform: Cognos 10 Report Studio, Cognos 10 Analysis Studio, Oracle 11g

Confidential, Washington, DC

BI Team Lead

Responsibilities:

• Worked on conversion project to develop SSAS models. Delivered EIS Module in SSAS.
• Used SSIS to convert and improve data collection and integration from MS Access to SSIS.
• Provided ongoing support for Cognos for SBA Users on the existing production apps.
• Streamlined the BI processes and maintained documentation for process and best practices for BI.
• Helped/Trained Team members in Cognos and SSAS, SSIS and Report Builder Technologies.
• Used SSIS to convert and improve data collection and integration from MS Access to SSIS.
• Designed and Developed Analysis and Reporting solutions for SBA in IBM Cognos 10 platform.
• Lead the Business Intelligence team in delivering SBA BI requests.
• Developed and maintained Aging Reports, for EIS apps, Aging, Risk Lenders, 504 Loans, 8aReports, EDMIS and SPGPSB, 7a Lenders.
• Developed and maintained the Framework manager Models for all the Cognos Applications.
• Developed and maintained powerplay cubes and Analysis studio reports for EIS, Aging, Risk and AWS applications. Incorporated the Fund Sum and GLAccount changes that occur in Risk Lenders and Aging.
• Prototype development in SharePoint integrated mode. Report Builder 3.0 and SSAS reports were completed.
• Managed Permissions on Web applications, Site Collections, Webpart, Subsites and Report Viewer Webpart under SharePoint 2010,
• Upgraded all the SBA reports from Impromptu7.0 to 7.3 and Powerplay 7.3 cubes to Cognos8.2 Analysis studio reports.

Environment: IBM Cognos Platform: Cognos 10 Report Studio, Cognos 10 Analysis Studio, Cognos Powerplay Transformer 10, Cognos Powerplay 10, Cognos 10, Sybase, Oracle 11g, SSAS 2008 R2, SSRS 2008 R2

Confidential, Dulles, VA

Principal Business Financial Analyst

Responsibilities:

• Converted all the Business Intelligence reports for the LSG and SSG from Impromptu to Cognos8.
• Created the three-year budget and forecasting model for Backlog revenue MMR and Monthly management Report Model using Cognos Planning.
• Built Corporate Indirect Expenses, Corporate Indirect Salaries model, Backlog revenue MMR and Monthly management Report Model. Built, maintained and monitored admin links, system links.
• Involved creation of Balance Sheet, Income Statement, Cash flow.
• Published the model for reporting purpose, Creation of BIFs, Elist Configuration
• Improved planning Server performance by analyzing server performance
• Configured the Security infrastructure for the planning, reporting environment and maintained User Security

Environment: Cognos 8 Report Studio, Cognos 8 Analysis Studio, Impromptu, Cognos Enterprise Planning 8.2, Analyst, Contributor 8.2, Cognos 8 Planning Manager Excel, Deltek Costpoint, Time and Expense

Confidential, Herndon, VA

Lead Consultant/ BI Architect (Application Reporting Team)

Responsibilities:

• Completely built company Balance Sheet through a Powerplay Cube to drill through to the lowest level of granularity of Balance Sheet transactions.
• Completely created the Income Statement Line Cube with complex security and ability to drill through to
• The lowest level of GL Transactions. Built the security model to give specialized access to different organizations for the company Income Statement Line Cube (Depart Financial Detail Cube). Maintained the Security model by giving specialized access to VPs, Directors, Managing Directors and Financial Analysts in different organizations at Deltek. The types of access profiles were Sales, Marketing, IT, Finance
• Accounting and Product Support. Labor and Non-Labor access for all profiles were properly tested and deployed the Cube to the targeted End Users. Improved the performance of the cube as it was large amount of data.
• Maintained overall security, administration and scheduling of Cognos Reports and Cubes.
• Improved the Performance of the Server by running performance counters and taken appropriate measures.
• Built the AR aging Cube with the AR Buckets and gave the drill through capability to the detailed transactions.
• Was responsible for Application Reporting and supported all users from different organizations in the

Environment: Cognos 8, Cognos Series 7.3, Cognos Powerplay 7.3, Cognos Transformer 7.3, Deltek Costpoint 5.0, Costpoint 6.0, Deltek Time and Expense, Softrax (Revenue Recognition Software).

Confidential, Washington, DC

Senior Technical Specialist

Responsibilities:

• Translated high-level requirements into effective BI solution for the CFS Ad hoc Reports for the modules General Ledger, Purchasing, Accounts Payables and Federal Administrator.
• Performed Data Modeling, Dimensional Modeling for the BI application specification, performance tuning and deployment support in the process of developing CFS Ad hoc Application.
• Developed System Test Plans and performed User Acceptance Testing. Fixed the issues with CFS that were identified during UAT and successfully deployed the CFS Ad hoc reporting application for Production.
• Developed Framework Manager Models for CFS Ad hoc reporting.
• Helped BAPD by peer reviewing the Reports, Training Manuals and Documents.
• Created Detailed BET reports to support Summary report BPR016
• Provided assistance to team members in the Deloitte team with Cognos implementation.
• Built the Framework Manager Package for CFS Ad hoc reporting in line with end user requirements
• Completed the Cognos Quick Reference Guide for the CFS Ad hoc Query application.
• Peer reviewed Design Documents, training manuals and users guides that are produced in ADM.
• Completed CFS Ad hoc Query tool by streamlining and performance tuning the model and reports.
• Reviewed all scenarios in CFS by testing them multiple times to make sure the joins are functional, and relationships are properly coded into the Package.

Environment: Cognos Report Net 1.1, Report Studio, Query Studio, Framework Manager, Powerplay 7.3, Transformer 7.3, Metrics Manager, Oracle Applications 11i Federal Financials

Confidential, Bloomington, IL

Decision Support/BI Team

Responsibilities:

• Modeled and authored reports in Report Studio, Query Studio and Framework Manager
• Installation, Configuration, troubleshooting and maintenance of Report Net environment.
• Multi Server Deployment, System design, Upgrade, Migrations, Development, and Testing and maintenance of servers for Development, UAT and Production environments.
• Worked with cross functional teams to enable the upgrades of Cognos 7.0 from Windows NT to Win2K and Cognos Series 7.0 to Cognos Series 7.1 and from Cognos Series 7.1 to 7.3.

Environment: Cognos Report Net 1.1, Report Studio, Query Studio, Framework Manager, Cognos Powerplay 7.3, Cognos Powerplay Web, Upfront, Sun One Directory Server, Windows 2000, UNIX.