SUMMARY:

• A result oriented BI analyst with 5+ years of progressively responsible experience in Data Analysis, Design, Implementation and Administration.
• Experience Supporting Business Intelligence modules, OLTP, OLAP, ETL, Data warehousing, Data mining, DBMS and Data Modeling using SQL Server, SSIS, SSRS and SSAS.
• Experience working in ETL environment in Informatica, Business Objects, Microsoft Integration Service (SSIS), Microsoft Analysis services (SSAS) and PowerBi.
• Good experience of MSBI SUITE; creating Tabular models 1400 compatibility with Visual Studio for Azure analysis services for analyzing data and creating professional report using DAX studio, Power Query, PowerBi and QlikView.
• Quality experience in debugging, monitoring and troubleshooting BI solutions workflows.
• Worked on all phases of SDLC following SCRUM methodology in AGILE environment from gathering requirements to design, testing, implementation, production and support.
• Translated the business requirements into workable functional and non - functional requirements at detailed production level using Workflow Diagrams, Sequence Diagrams, Activity Diagrams and Use Case Modeling.
• Experience in various phases of Software Development life cycle (Analysis, Requirements gathering, Designing, Testing) with expertise in Data Validation, Source to Target mappings, SQL Joins and Data Cleansing.
• Experience in all phases of Data warehouse development from requirements gathering for the data warehouse to develop the code, Unit Testing and Documenting.
• Quality experience in Power Bi Desktop visualization using various transformations and custom report themes.
• Expert level skills in Application monitoring and Support, use of ETL tools, Reporting tools, SQL development and basics of scripting languages Unix/Linux.
• Publishing reports using Power bi desktop, share dashboard with Power bi service, publishing reports for mobile apps giving access to the end users like developers, stake holders, managers and clients
• Experience in sourcing data from different databases like Oracle, MS Access, SQL Server, HIVE, Azure Data Lake, HDInsight cluster and SAP HANA
• Experience in maintaining and reviewing complex Packages, Stored Procedures, Functions, Triggers, Cursors, Tables, Views, Joins, SQL, and T-SQL.
• Experience in Performance Tuning and optimization of ETL process, Data models and SQL queries.
• A versatile and a professional individual with a commitment of learning and solving challenging things. Strong client service and public relation experience.

TECHNICAL SKILLS:

ETL Tools: Informatica Power Center 9.1, SSIS, DataStage, Alteryx, Azure Data Factory

Data Modeling: Erwin, Power BI, SSAS, MS Visio

Databases: Teradata, Oracle, MS SQL Server, MS Access, DB2, SAP Hana, ADLS, Apache Ambari, HIVE, SPARK

Reporting Tools: Micro strategy OLAP Suite, Cognos, Business Objects, PowerBi, SSRS, QlikView, Tableau

Languages: SQL, PL/SQL, Shell Scripting, Python, C++

Operating Systems: Windows, Unix, Ubuntu, MAC OS, Sun Solaris, Linux

Testing Tools: HP ALM and Quality Center

Autosys, Azure Functions, Control: M

Domain: Telecommunication, Healthcare, Banking, Finance, Retail

PROFESSIONAL EXPERIENCE:

Confidential, Charlotte, NC

PowerBi/MSBI consultant

Responsibilities:

• Migration of reports from SAP Business objects to SSRS using SAP Hana report and base calculation views.
• Basic understanding of SAP Hana database systems for report making in SSRS.
• Reviewing developed Stored procedure, TSQL queries, reports in PowerBi for better understanding of the requirement.
• Modifying the SQL queries in SQL console in SAP Hana studio generated by Hana calculation views for accessing the data.
• Encapsulating, creating function and parameters in SSRS using the Hana SQL queries to access the data source.
• Creating reports similar to Business Objects in SSRS, publishing it on QA server for UAT by the business and the team.
• Changing existing stored procedures, SQL queries to meet the changing requirement for various modules within the organization.
• Manage and complete ad-hoc requests for data reports.
• Gathered and documented business requirements for analytical reports. Participated in requirements meeting and data mapping sessions to understand business needs.
• Involved in client meetings, stakeholder calls and scrum meetings to Identify and documented business rules.
• Creating and executing Test Plans and Technical Documentation.
• Managing various subscriptions for SSRS reports published on the production server to be shared with the customers, stakeholders and various clients.
• Performance tuning on Slowly running SSIS Packages by Debugging SSIS packages.
• Used Power BI Gateways to keep the dashboards and reports up to date.
• Installed and Configured Enterprise Gateway and Personal Gateway in Power Bi Services.

Environment: AWS cloud, SSRS report server, SAP Hana, SSRS, MSBI, Apache Ambari, Azure Data Lake Storage, PowerBi, Power Query, SQL, Visual Studio, MSBI suite, SSAS, Tabular models, Azure functions, Win Sql, DAX Studio, Cisco VPN, SSDT, SAP CRM, BOBJ, SSMS, TOAD.

Confidential, Charlotte, NC

BI Reporting Analyst (MSBI/Power BI)

Responsibilities:

• Provided time and cost-efficient reporting solutions to the client with problems related to sourcing the data from Hadoop ecosystem.
• Created and developed complex data models for retail sector in Visual Studio 2019, optimizing the data model as per the requirement.
• Developed reports using data from HIVE on HDInsight Cluster shaping and modeling the data as per the guidelines and requirement of the business.
• Key player in arranging requirement gathering sessions with the business and management, providing efficient solutions to the ongoing defects in the reporting environment.
• Laid the groundwork for building the self-sufficient reporting environment by testing the most time-efficient and cost-effective method to use data from Hadoop ecosystem reducing cost of data governance, data latency and loading time significantly.
• Created multiple dashboard, custom visuals, inter-connected tiles to demonstrate the key areas of business growth. Developed reports based on the location, product, time and customers in PowerBi.
• Extensively used DAX (Data Analysis expressions) to create calculated columns, calculated tables, calculated formulas to create measures to show various metrices.
• Implemented Role Based Security as part of security in Power Bi.
• Use of various DAX functions like Time intelligence, Logical, Date-Time, Filter to deliver effective and meaningful reports as per the given requirement to make the report presentable.
• Created partitions for Tabular models in SQL server analysis services (SSAS) for loading the transactional data getting updated in the Data Lake on daily basis.
• Wrote Azure trigger functions to schedule loading of data into the data model created in Visual Studio and deployed on Azure Analysis Services to be used for reporting by PowerBi.
• Excellent understanding of Data flow, Data management, Data governance and Data security, providing excellent solutions to the business and stake holders.
• Designed Tabular data models for various Business requirements, applied Row level security, use DAX functions, automating the partitions to ingest the data to deliver updated and latest self-service BI reports.
• Created and managed multiple Accounts, Workspaces in PowerBi Service to publish reports online to be shared within the team.
• Managed, optimized and updated various legacy reports according to the latest BI trends and best practices.
• Designed a roadmap and technical plan to convert reports in MicroStrategy to PowerBi by using MSTR connector for a smooth transition and desirable result.
• Highly familiar working with cloud technologies, deploying applications, governance and security, providing access, adding and removing users.
• Configuring and setting up data gateways for accessing and loading data from the source on private, on premise network of an organization.

Environment: Azure Analysis services, Hadoop ecosystem, Apache Ambari, Azure Data Lake Storage, PowerBi, Power Query, SQL, Visual Studio, MSBI suite, SSAS, tabular models, azure functions, Win SQl, HIVE, Citrix BI desktop.

Confidential, Phoenix, AZ

Sr. Software Engineer

Responsibilities:

• Developed modules based on the dimensions, facts, levels and measures required for the analysis.
• Work in an agile environment and contribute to the improvement of our development processes
• Optimizing the performance of Cubes, and Reports.
• Run and published reports in HTML, PDF, CSV, XML and Excel for analysis
• Involved in administrative tasks like: User authentication, creating new users for the cube
• Developed multidimensional cubes using Powerplay transformer
• Responsible for Scheduling and monitoring critical Jobs.
• Assisted the other ETL developers in solving complex scenarios and coordinated with source systems owners with day-to-day ETL progress monitoring.
• Created Oracle PL/SQL Functions, Procedures, Triggers, Packages, Records and Collections
• Maintaining entire documentation for BI solutions and related services together with associated communications documents.
• Providing support, maintenance and implementing changes to existing database and BI systems.
• Updating existing procedures, functions, triggers and packages to synchronize with the changes in transformations.
• Modified SQL queries using stored procedures, common table expressions (CTE’s), temporary tables to support SSRS reports.

Environment: ETL Tools Power BI, Informatica, Data stage and reporting tools Business objects, Cognos, MS office, BMC remedy, Toad, Putty, MS SQL server, SQL server management studio, Linux, Oracle 8i, PL/SQL, SQL, SQL*Loader, UNIX and Windows NT

Confidential

Software Engineer

Responsibilities:

• Gathered and documented business requirements for analytical reports. Participated in requirements meeting and data mapping sessions to understand business needs. Identified and documented business rules.
• Creating and executing Test Plans and Technical Documentation.
• Assists with the development of the data model(s) for the data warehouse. Provides recommendations for all data strategies and out of scope processes
• Work with the other IT groups such as Infrastructure, Networks, Web Application Development to design BI solutions for internal and external use.
• Implement process improvements (Automation, Performance tuning, Optimize workflows)
• Follows SDLC methodologies in performance of all development activities, including design, development, test and quality assurance support
• Developed workflows in Informatica to cater the need for reporting layer for efficiency.
• Work with Technical Program Management and Software Quality Assurance teams to develop means to measure and monitor overall project health
• Involved in the preparation of specifications for PL/SQL procedures and functions to do the data migration and conversion.
• Involved in extracting large volumes of data from different data sources into staging tables, performing transformations on them before loading into final tables
• Involved in debugging the code when Tickets are assigned to fix the issue

Environment: ETL Tools Power BI, Informatica, Data stage and reporting tools Business objects, Cognos, MS office, BMC remedy, Toad, Putty, MS SQL server, SQL server management studio, Linux, Oracle 8i, PL/SQL, SQL, SQL*Loader, UNIX and Windows NT