Candidate Information Title Business Intelligence Power Bi Target Location US-TX-Irving Email Available with paid plan Phone Available with paid plan	20,000+ Fresh Resumes Monthly     View Phone Numbers     Receive Resume E-mail Alerts     Post Jobs Free     Link your Free Jobs Page     ... and much more Register on Jobvertise Free
Search 2 million Resumes Keywords: City or Zip:	Related Resumes Power Bi Business Intelligence McKinney, TX Power Bi Business Intelligence Frisco, TX Business Intelligence Power Bi Frisco, TX Business Intelligence Data Warehousing Irving, TX Business Intelligence Developer Forney, TX Data Analyst Business Intelligence Dallas, TX Business Intelligence Sql Server Irving, TX

GOPIKRISHNAPHONE NUMBER AVAILABLE EMAIL AVAILABLEProfessional Summary:Overall 7+ years of experience in Analysis, Design, Development, and Implementation of Data warehouse applications in various roles.Strong expertise in designing and developing Business Intelligence solutions in staging, developing data modeling, designing analytical dashboards to business users by populating Operational Data Store (ODS), Enterprise Data Warehouse (EDW), in Power BI, QlikView, Qlik Sense, and Informatica Power Center 9.x/8.x ETL tool.Extensive knowledge of using multiple data sources such as Snowflake, SQL, SharePoint files, Power BI datasets, Azure SQL DB, etc.Expertise in DAX Functions usage (Row and Filter Context) and in creating calculated columns and measures.Gathered fair understanding of BI Stack in application administration encompassing Planning/ Implementing User, Resource and Password Management, Backup & Recovery Strategies, Performance Tuning.Proven track record on successful completion of Long Term and Short-term projects within deadline while adapting to rapidly changing environments and priorities.Define and implement security policies, access controls, and data governance practices to ensure data integrity, privacy, and compliance with regulations.My project experience includes analysis, plan, implementation (migration, enhancement and development) and testing as well as production support.Experience in Azure Devops, GIT for code deployment.Worked on multiple POCs for Power BI integration with Cloud using Azure BI Stack (Azure Synapse Analytics, ADF) and Snowflake.Technical Skills:OLAP ToolsPower BI, QlikView, Qlik SenseETL ToolsInformatica 9.6.0/9.1.1,TDM,ODIMethodologiesStar Schema, Snowflake Schema.Data ModelerMicrosoft Visio Professional, Erwin 3.5/4.0.ProgrammingSQL, PL/SQL, DB2 SQL PL, PythonFront End ToolsSQL*Loader, TOAD, MS OfficeOffice ToolsMS Word, PowerPoint, Excel, Visio, One note, MS Operations ManagerEducation & Certifications:Bachelors degree in computer science at JNTUK, India.Master of science in Information studies at Trine University, Angola, IN(USA).Certifications:MCSA: 70-765Work History:Role: Power BI DeveloperClient: Bank of New York Mellon Feb 2023 to CurrentLocation: Jersey City, NJRoles and Responsibilities:Environment monitoring pro-active monitoring to ensure performance on the server.Provide troubleshooting and diagnostic support at L2 / L3 level for Qlikview and other related products.Lead the Reverse Engineering effort to identify System of Records (SORs) for report attributes that needed to be re-platform into ICDW.Defined the framework for capturing the reverse engineering analysis at each hop level and tracing it back to SOR level along with code logic.The code base for performing reverse engineering involved several platforms and technologies including Unix scripts, PL-SQL procedures, SAAS, ETL code like Informatica and AbIntio and application code like java.The entire reverse engineering effort was divided into Level1, Level2 and Level3 analysis. Level1 analysis required identifying list of SOR systems for report schema. Level2 analysis required identifying at table level mapping target tables to SOR tables and level3 involved mapping at attribute level.Stitching logic was performed once reverse engineering analysis was complete for a reporting attribute to get a holistic picture of attributes, logic and transformations involved in arriving at reporting attribute from SOR attribute.Responsible for converting the reverse engineering output to a pre-defined format and loading to MDR.Organized meetings with SOR teams to review the reverse engineering output and work on recommendations.Environment: Informatica Power Center 9.6.0/9.5, Power Exchange, J2EE, Oracle, MS SQL Server, Control-M, Oracle 11g, DB2, putty, reflections, Toad, Winscp, Subversion.Role: BI DeveloperClient: CVS Health Jan 2022 to Jan 2023Location: Princeton, NJRoles and Responsibilities:Worked on Multiple projects with different internal teams of CVS Health.Involved in developing project plans, including timelines, budgets, and resource allocation.Identify and mitigate risks and resolve project issues.Participated in yearly Project estimations and helped business in creating stories and estimate story points in ADO Sprint planning dashboards.Business intelligence reporting (using SQL, Oracle, Power BI, Qlikview, Qliksense)Reporting related to MA, PDP, SUPP membership plans (Medicare Advantage, Prescription Drugs, Supplementary benefits)Configured user access in Power BI workspace using Azure groups.Data reporting consolidation of Medicare, Dental, Vision, Provider Information.Enabled Row level security on Power BI to maintain data privacy.Optimize the long running reports and queries by applying performance tuning mechanism.Created Page Level Filters, Report Level Filters, and Visual Level Filters in Power BI according to the requirements.Monitor report performance and optimize resources as needed.Worked on connecting ADF to various data sources like files, databases, and APIs.Gathering business requirements and created functional and technical specs and worked with business clients to confirm and clarify requirements and business logic.Enhanced the Business discovery process, by adding new features into the Dashboard, for the users to deep dive into the sales data.Facilitated data mapping process for the Dashboard Metrics, to standardize the Data warehouse component.Created several measures and calculated columns using DAX to provide advanced analytics in the Power bi reports.Conducted in-depth analysis of data sources, structures, and relationships to inform Tableau development.Effectively migrated Azure Analytical Service (AAS) model to Power BI dataset.Implemented 3-Layer architecture, Binary loads, and Incremental Loads for optimal performance of the Dashboard reloads, rescaling and to adhere to data retention standards.Worked on different connection modes - import, live connection, and Direct Query to meet client requirements. Developed paginated reports using Power BI.Performed data modelling on requirements analysis by creating table displays, logical data model, star schema models and table designs.Environment: Power BI, QlikView, Qlik Sense, ASA, ADF, Oracle, SSRS, DB2 Toad, Java Script, HTML.Role: Jr. Power BI Developer,Client: Sim form Solutions Jan2019 to July2021Location: Hyderabad, IndiaRoles and Responsibilities:Involved in the requirements definition and analysis in support of Data Warehousing efforts.Worked on Power Center9.5 Designer tools like Source Analyzer, Warehouse Designer, Mapping Designer, Mapplet Designer and Transformations Developer.Developed Informatica mappings and tuned them for better performance.Involved in designing the procedures for getting the data from all systems to Data Warehousing system. The data was standardized to store various Business Units info in tables.Used most of the transformations such as the Source qualifier, Aggregators, Lookups, Filters, Sequence and Update strategy, Router.Created and monitored workflows and tasks using Informatica PowerCenter Workflow Manager. Analyzed newly converted data to establish a baseline measurement for data quality in data warehouse.Created and ran various tasks like Sessions, command, Email & Workflows to load the data into the Data warehouse components.Developed and documented data Mappings/Transformations and Sessions.Environment: Informatica - Power Center9.5/9.1, Oracle 9i, MS SQL Server, SQL, PL/SQL, UNIX Shell Script, SQL*Loader, OBIEE, Windows 2000.Role: Software EngineerClient: Heritage Foods Ltd, Jun 2017 to Dec 2018Location:  Hyderabad, IndiaRoles and Responsibilities:Partly involved in gathering business requirements and worked closely with various Application and Business teams to develop Data Model, ETL procedures to design Data Warehouse.Involved in designing and developing star schema model for target database using ERWIN Data modeling.Extensively used ETL Informatica tool to extract data stored in MS SQL 2000, Excel, and Flat files and finally loaded into a single Data Warehouse.Tuned performance of Informatica Session by increasing block size, data cache size, sequence buffer length and Target based commit interval, and mappings by dropping and recreation of indexes.Worked along with the QA Team and provided production support by monitoring the processes running daily.Involved in pre and post session migration planning for optimizing data load performance.Interfaced with the Portfolio Management and Global Asset Management Groups to define reporting requirements and project plan for intranet applications for Fixed Income and Equities.Performed Unit testing during the mapping phase to ensure proper and efficient implementation of the transformations.Environment: Informatica Power Center 8.6,, MS SQL 2000, Oracle 9i, SQL, T-SQL, SQL Navigator, Erwin 4.1, UNIX Shell Scripting, Windows XP and 2000, Flat files, SQL, Windows NT.