| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
COLUMBUS OHIO /PHONE NUMBER AVAILABLE, EMAIL AVAILABLEPROFILE SUMMERYOver 7 years of Business Intelligence Developer with technical knowledge to design, Developed and implement data and analytical solution.Data warehouse design,Data analysis/reporting with power bi experience,verbal and written communications. I have over the years leveraged my bi experiance and expertise to contribute to numerouse project helping organizations achieve business goals.Hands on experience in Gathering Data from Variouse source and transforming it into Insightful Report and Dashboards.Proficient in Data Modelling and Integrating Reporting components from multple data sources.Skilled in performing data transfer between different heterogeneous systems (Excel,Flatfile,Snowflake, OLTP,DB) and SQL Server as part of Migrations,Date Maintenance.Managing and Develoing BI Reports to truck new and existing claims.ie interactive Dashboards,mobilized Business Intelligence,Online Reports and scorecard.Reviewing Changing Market condition and Historical Performance,Identifing opportunities,Delvering insight,and Assessing the impact of Strategic initiatives that improve business profitability and shareholder value.Developed and implemented reporting,analytics and data visualization solution with power bi,tablue.working knowledge of power bi(power pivot,power view,power bi online,powerbi desktop,power bi publisher)and dax. Design and Implement reporting solution using reporting service,power bi or other data visualization tools.Design and Implement Complex Data Model reporting solution using reporting service,power bi or other data visualization tools.Design and Developing Big data model using different performance optimization technique and make multiple dimension table and fact table using star schema.Creating Static and Dynamic Row Level Security with power bi desktop and integration with power bi service portal.Experience in optimizing reports and setting up power bi service,geteways,and scheduling data refresh.Experinence of creating,configuring,and maintaining system database.Collaboation in software developement life sycle (SDLC) using different methodologies.Full lifecycle development from analyzing current processes, providing functional specification, designing, and developing solutions, and testing and providing ongoing support.Managing Business intelligence initiativesExperience of Data flow /power query online/to import big data to cloud.Configuring DatacenterMigration to Azure/azure data factory/Supporting, Structuring and Delivering concise data driven narrative to drive the companys priorities; by translating data into compelling stories which connect finding from different sources and synthesize them into one complete pictureExpertise in dealing with RDBMS including E/R Diagrams, Normalization and De-Normalization, Constraints, Data Import and Export for existing table for faster query retrieved.Design,Developed and maintain data warehouse using ODICreate and modify reports and report template using SQL Server Reporting Service (SSRS)Maintain Legacy SSRS report & Migrate SSRS report to POWER BIIntegerate power apps with power bi to expand capablity of power plat formcreate power automate pipe line to automate some report in power biDeveloped a complate SSIS life cycle creating SSIS packages including building, deploying, excuting, and scheduling the package.created test scripts to evaluate database and application reliability.TECHNICAL SKILLSData Source:SQL Server Database, EXCEL, CSV, SALSEFORCE, JSON, SNOWFLAKEBI ToolsPower BI, SSRS,SQL Server and SSIS,ODICloud Computing:AzureOperating System:Windows, MacDatabase:DBA, SQL Server, Oracle, MS Access,ODIData Visualization & Reporting of Database Management Systems Enterprise Data WarehousingETL Workflow DevelopmentMethodology:Agile with Multiple Sprint CyclesCustomer focused & Rapid deliveryAdaptive to changes in technologyAdaptive to changes in requirementsHighly collaborative with Daily ScrumPROFESSIONAL EXPERIENCEPOWER BI DEVELOPER/ ADMIN/DATA ANALYSTTATA CONSULTANCY SERVICECOLUMBUS,OHIO DEC 2022 PRESENTResponsibilities:Gazering data from sql server database,excel,snowflake,dataset,and other sources.transformed the data and produced reports using power bi platform.optimized the dashboard with focus on usablity and performance.Design and Create innovative and valuable visualization to identify patterns,trends,and exceptions which enables the business excutives and senior leaders to make data driven decision.Collaborate with cross-functinal teams to identify data sources and streamline data collection resulting in reduction in report development time.Improve dashboard usablity by implementing interactive visualization resulting increase in user engagement.Optimized dashboard performance by implementing different performace improvement technique /lower data model size,limit number of visual per page,and using correct dax logic/.Interpret business requirement and translate them into power bi, transform, build, maintain and automate the dashboard to refresh the data Support the transfer excel based analysis tools to advance analysis product.Understand,own,and supports operational dashboard,business performance dashboard,interprate the result,and summarize opportunities for improvment and make recommendation to senior leadership.Provide technical support across the division as directed by client including providing SharePoint Online and Microsoft Office 365 support to stakeholders and end usersInterpreting business request and translating them into SQL. build, maintain and automate complex SQL queries to research, compile performance data, investigate for any strategy analysis or build reportCreate and Manage the work space,Grant access,deny access for the end user.POWER BI/SQL/ETL DEVELOPER /DATA ANALYSTCAPGEMINISILVER SPRING, MD MAY 2016 DEC 2022Responsibilities:Developed and Implement ETL process using SSIS to increase data integration efficiency.Understand,Identified,acquired,and analyzed data from multiple sources to streamline.The delivery of information across the company platform using ETL and Ms.SQL Server.Developed complex T-SQL codes to create/update database objects such as Tables, Views, Stored Procedures, User Defined Functions, Triggers, Indexes, and Cursors.Used SSIS to create ETL packages to Extract, Transform and Load data to Data Warehouse and Data Mart Databases.Developed, Maintained, and Monitored all import/export and Data Transformation into the Staging Database.Extracted data from different sources (CSV, Excel, and MSSQL and Oracle database sources) and load to Data Warehouse using SSIS complex data transformations (Data Conversion, Export Column, Merge join, Sort, Union all, Conditional Split, Lookup, Fuzzy Lookup, Slowly Changing Dimension, Derived Column, Row Count, and more) for existing/new packages.Developed SSIS packages using For Each Loop Container in the Control Flow elements to process all Excel files within folder; File System Task to move file into Archive after processing; and Execute SQL task to insert transaction log data into the SQL Table.Involved normalization and demoralization of existing table for fast query retrieval cleansing data in power query using power apps and power automate and its visualization for better utilization and performance of power BI.Created a reusable /repeatable process in Power automate by integrate with power biConfigured varies event driven e-mail notification process in SSIS packageIntegrate power bi with power apps to connect to business data provide data insight and visualization, and enable users to take action from within power bi report and dashboard.Worked with type 1and type 3 dimensions, fact table, star schema, operational data store (ODS), levelling and other data warehouse conceptDevelop ETL process using data integration tools, scripts, and stored procedures to extract data from multiple system, application, and other sources, and load data into enterprise data warehouseConfigured and manage power bi clustered data gateway in power BI service to avoid single point frailer.Worked as power bi admin, granted /denied access for user, managed data getaway and upgrade workspace to premium.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.Environments: Microsoft SQL Server 2012/2008, T-SQL, Power bi,SSISEDUCATIONBAHIR-DAR UNIVERSITYBACHELOR OF ELECTRICAL ENGINEARING 2000CERTEFICATIONCERTIFICATIONS OF POWER BI (FROM MICROSOFT)TRAININGSDATA VISUALIZATION & REPORTING OF DATABASE MANAGEMENT SYSTEMSENTERPRISE DATA WAREHOUSINGETL WORKFLOW DEVELOPMENT |
