Bi Architect / Reporting Lead Resume
Houston, TX
SUMMARY:
- Over 16 years of IT experience with expertise in Analysis, Design, Development and Implementation of Business Intelligence (BI) solutions in Data Warehousing Systems using Reporting / ETL tools such as Microsoft BI Suite (Azure Data warehouse, Azure Datalake, ADF/SSIS, AAS/SSAS), Power BI, Tableau, Cognos and Informatica.
- Expertise in Microsoft toolsets such as Azure Data Warehouse, Azure Datalake, Microsoft Azure Data Factory/SSIS, Azure Analysis Services/SSAS, and Power BI.
- Strong expertise in using other ETL and Reporting tools Informatica and Cognos.
- Created Complex Dashboards, Reports in Power BI and Cognos Report Studio for different Business user needs and Ad - Hoc reports.
- Proficient in developing reporting applications employing Cognos 11 & its components Framework Manager, Report Studio, Query Studio, Analysis Studio, Cognos Connection.
- Installed and configured Microsoft software across multiple environments with expertise in version upgrades and migrating SSAS Cubes and Power BI reports.
- Experienced in working with business users, Analysts, IT leads and developers in analyzing business requirements and translating them into functional and technical specifications.
- Strong understanding of dimensional modeling of Star Schemas, Snow-Flake Schemas Methodologies for building enterprise data warehouses.
- Strong Experience in creating/modifying Table, Views, Store Procedure, Functions, and User Defined Functions.
- Experience implementing, configuring, testing the ETL & reporting Application, and tuned for performance to increase the processing efficiency.
- Excellent analytical, problem solving, communication and interpersonal skills, with ability to interact with individuals at all levels.
TECHNICAL SKILLS:
BI / ETL Tools: Microsoft Azure AAS/SSAS, Power BI, Cognos, SSMS, Tableau, Informatica, Azure ADF/SSIS
Databases: Azure Data warehouse, SQL Server, Oracle, MySQL
Web Development: ASP.Net, ASP, VBScript, JavaScript, HTML, XML, XSL, XSLT
PL/SQL, T: SQL, .NET 3.0, C#, VB.Net, VB 6.0, C, C++
Database tools: SSMS, MYSQL Workbench, TOAD for Oracle
Platforms: Windows & Unix
PROFESSIONAL EXPERIENCE:
Confidential, Houston, TX
BI Architect / Reporting Lead
Responsibilities:
- Lead the BI Scrum team with Stakeholders to understand their reporting needs and requirements.
- Analyze the different source systems for reporting needs.
- Co-ordinate with data lake team to move the required data to BI bond.
- Design and create the tables in ADW for reporting needs and move the data to ADW using ADF/SSIS.
- Build an AAS model to develop the report/dashboard and ad-hoc reports.
- Build a dashboard/report using Power BI and publish in the workspace/apps.
Environment: Azure, ADF, AAS, Power BI, SSIS/SQL Server Analysis Services, Azure Data warehouse.
Confidential, Houston, TX
BI Architect / Reporting Lead
Responsibilities:
- Identified and Analyzed the gaps in functionality between Cognos and Power BI
- Mitigated the functionality gaps with alternate design leveraging Power BI functionality
- Created design mockups and prototype
- Socialized the new design prototype with stakeholders and got their approval
- Designed and developed the Principal Dashboard in Power BI
Environment: Power BI, Cognos, Azure, SQL Server Analysis Services, Informatica, SQL Server 2016.
Confidential
Reporting Lead /Data Architect
Responsibilities:
- Lead the design workshops with the Business users to understand their reporting needs and requirements
- Designed the models and packages using Microsoft Power BI and Microsoft Analysis Services in an agile, iterative method and had those reviewed and enhanced in the bi-weekly workshops
- Facilitated monthly Power user meetings and Advisory group meetings.
- Created relational, dimensional model and dynamic cubes.
- Conducted on Microsoft technology to the Business users.
- Managed and motivated the team to deliver and support the Power users
Environment: Microsoft SSIS/SSAS, Microsoft Power BI, Microsoft SQL Server 2012/2016, Tableau, Informatica Power Center.
Confidential
Reporting Lead
Responsibilities:
- Designed and developed complex Dashboards and reports for multiple departments.
- Designed and published the framework manager Models as packages for enterprise dashboards.
- Extended the Cognos functionality by incorporating JQuery, Java script and Cognos SDK for the dashboards.
- Established best practices, development standards and reusable templates for report development.
- Deployed on different data delivery mechanism that suits different business users needs such as Mobile.
- Migrated all the dashboards and reports from Cognos 10 to Cognos 11.
- Used Motio CI for version control and deployment of reports for different environments such as Dev, Stage and Prod.
Environment: Microsoft SSRS/SSAS, Cognos, SQL Server 2012
Confidential, Baltimore, MD
Reporting Lead
Responsibilities:
- Created the BI health check report based on the company maturity level and AS-IS status.
- Created the TO-BE structure based on the strategy and identified the gaps.
- Created the Business Case to evaluate the different Architectural options and its benefits.
- Effectively interacted with the Business users to gather the requirements.
- Suggested the Business users and Executives on different data delivery mechanism that suits their needs.
- Created the Technical Architecture that covers all the technical requirements such as type of reports, delivery mechanism, process automation etc.,
- Created the security view point for the Architecture.
- Worked with Project Manager in creating the Estimation.
- Co-ordinating the team members to resolve any discrepancies.
- Implemented the Best Practices in Reports creation. Created the data level security in reports.
- Coordinated with DBAs to create the required physical structure for the reporting layer.
- Advised the Report Developers in effectively utilizing the latest techniques available in Cognos suite.
- Involved in creating the User manual to help the Business Users understand the reporting architecture.
- Documented the Lessons Learnt and Best Practices.
Environment: Cognos, Microsoft SSIS/SSRS, PowerPlay Transformer v7.4, SQL Server 2008, Oracle 10g, PL/SQL, Erwin.
Confidential, Baltimore, MD
Cognos Lead
Responsibilities:
- Understood the source system and interacted with users to acquire the elaborate technical and business requirements and required documentation for clear understanding and traceability of requirements.
- Experience in building models using Framework Manager & creating simple to complex reports in Report Studio. Created database layer and business layer, defining appropriate relationship between query subjects in Framework Manager.
- Created Star schema dimensional model.
- Created Dashboard reports using the Cognos Report Studio.
- Developed List, cross tab, drill through, master-detail, chart and complex reports which involved Multiple Prompts, multi-query, Cubes in Report Studio, Burst Reports against database.
- Extensively worked on Analysis Studio to develop multi dimensional reporting.
- Created custom prompted reports in Report Studio, Bursting reports to different user groups.
Environment: Cognos 8.2 (Query Studio, Report Studio, Analysis Studio, Event Studio, Cognos Connection, Framework Manager), PowerPlay Transformer v7.4, SSIS, SQL Server.
Confidential, Baltimore, MD
Cognos Developer
Environment: Cognos 8.2 (Query Studio, Report Studio, Analysis Studio, Event Studio, Cognos Connection, Framework Manager 8.2), PowerPlay Transformer v7.3, Cognos series 7.3 Impromptu, Cognos Upfront, Power Play for Windows, SSIS, SQL Server, PL/SQL.