| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
PHONE NUMBER AVAILABLEEMAIL AVAILABLEhttps://LINKEDIN LINK AVAILABLESummary:12 years of Professional experience in the IT industry, involved in working on Tableau and in MSBI & PowerBI projects with extensive usage of ETL & Reporting tools like SQL Server Integration Services (SSIS) and SQL Server Reporting Service (SSRS).Working in Agile methodologies and conducting standup meetings and collating deliverables.Experience in Business Intelligence, Banking, Sales & Marketing,Extensive working skills with different reporting tools for all deliverable projects through the projects delivered.Leading a team of 4 and previously lead a team of 5 in earlier projects.Strong knowledge of Power BI and Paginated ReportsExperience leading a team of 8+ members onshore & offshore assigning and taking care of the deliverables in time.Using different sources form web APIs and build extract the source data from APIs and use it for reportingImplementing different query parameters and working with different data sources in Power Bi.creating detailed documentation such as business requirements documents, functional specifications, and process flows to communicate requirements and solutions to stakeholders and development teams Documentation & Stakeholder ManagementProficient in writing queries and converting business requirements into visualization.Proficient in DAX, SQL and Power Query, M-Query.Accomplished various tasks in big data environment which involved Microsoft Azure Data Lake Storage,Azure Data Factory, Azure Analytical Services, Azure Blob Storage, Azure Synapse, and SQL server.Experience in Data Analysis, Data Profiling, Data Validation, Data Cleansing, Data Verification, and DataMismatch Identification.Experience in different Project Management Methodologies like Traditional waterfall and Agile.Experience in designing Star Schema, and Snowflake schema for Data Warehouse, by using tools like Erwindata modeler.Knowledge in writing, testing, and implementation of the triggers, procedures, and functions at databaselevel and form level using PL/SQLGood Knowledge in designing the Data Mart using Ralph Kimballs and Bill Dimensional DataMartModelling techniques.Comprehensive knowledge and experience in process improvement, normalization/de-normalization, dataextraction, data cleansing, and data manipulation.Experience in modelling with both OLTP/OLAP systems and Kimball and Data warehousing environments.Extensive experience in the development of T-SQL, DML, DDL, DTS, Stored Procedures, Triggers,Sequences, Functions and Packages.Experience in Data Profiling, Analysis by following and applying appropriate database standards andprocesses, in definition and design of enterprise business data hierarchies.Experience in extracting, transforming, and loading (ETL) data from spreadsheets, database tables, and othersources using Microsoft SSIS.Experience in Data Transformation and Data Mapping from source to target database schemas and also datacleansing.Strong understanding of Data Modelling (Relational, dimensional, Data analysis, implementations of Datawarehousing using Windows and UNIX.Strong experience in using Excel and MS Access to dump data and analyse based on business needs.Performed Business Requirement Gathering and Analysis, Feasibility study, ROI Analysis, Process Flow and Process Modelling, Functional and Techno-Functional Gap Analysis of existing system. working withoffshore/onsite modelWorked with the team in designing new and improving existing table schema for complex scenarios.Hands-on designing and deploying rich Graphic visualizations with Drill Down and Dropdown menuoptions and Parameterized dashboards using Tableau, Power BI,and SSRS.Managed development and testing teams to keep deliverables on track and reported to stakeholders.Education:Bachelor of Technology Graduate in Computer Science as a specialization from Jawaharlal Nehru Technological University, 2012, Andhra Pradesh, India.Technical Skills:Cloud: Microsoft Azure, Azure Data Factory v2, Azure Analysis Server, Azure Data bricks, Azure DataLake Store, Storage Blob, Logic Apps, Log Analytics, Azure SQL DB,Azure SearchETL Tools:Server Integration Services (SSIS)Reporting Tools: Power BI Desktop (2.68), Power BI Service, Power BI Gateway, SQL Server Reporting,Services (SSRS), Tableau Desktop 9.3.1, Tableau ServerDatabases: MS SQL Server 2016/19, MySQL 8.0, Azure SQL DBLanguages: SQL,PythonPlatforms and Tools: Microsoft Visual Studio, Eclipse IDE, Windows,MicrosoftProfessional Experience:Zachry Construction, San Antonio, TX Jul 2021 to May 2024Description:Zachry Constructionis one of the leading Construction in San Antonio USA.Zachry Group is North America's pacesetter in turnkey construction, engineering, maintenance, turnaround and fabrication services to the power, energy, chemicals, manufacturing, and industrial sectorsPower BI LeadResponsibilities:Development of dashboards on Power BI.Developing visual reports, dashboards and KPI scorecards using Power BI desktop.Documenting changes and implementing them in new different environments like PROD, SIT, UAT.Implementing Drill Through & Hyperlinks in Power BI report.Worked with Microsoft Power BI, DAX expressions, Power View and Power Query integrated with share point. Working with different data sources and accumulating the data for the creation of dashboards.Creating paginated reports with cascading parameters for accurate filtering.Creating grouping mechanism to segregate data in paginated reports.Working on drilldowns and drill throughs in paginated reports to hide complexity of the data.Manages data sources and data connections for Power Apps and Power Automate.Ensures data integrity and security within applications and workflows.Designs and implements data models and structures to support app development and automation.Provides insights and analysis on data collected through Power Apps and Power Automate.Managing user accounts, permissions, and access levels within SharePoint sites and content.Designing and implementing of ETL Transformations with SSIS.Conduct accessibility audits and make recommendations for improving the accessibility of designs.Query Optimization Tuning SQL queries to ensure efficient data retrieval and processing. Data Integration Building and maintaining pipelines to ingest and transform data from various sources into Snowflake.Develop wireframes, prototypes, and mockups to visualize and communicate design concepts.Define interaction patterns, navigation structures, and information hierarchies to guide users through the interface.Leading a Team of 5 working with in assigning and proposing solutions.Creating research reports and presentations to communicate findings to stakeholders.Environnent: SQL, POWER BI,Agile, Power Apps,Power AutomateAIA-Health, MalaysiaNov 2020 to Mar 2021Application Developer SpecialistDescription:Working with AIA SYSTEMS by collating all the data of almost 18 BUs of all the Insurance domains related data and collating the data and from there transforming the data and analyzing on different systems and converting into meaningful visualizations that helps end users to relay on that and check the KPIs accordingly.Responsibilities:On boarding of new data sets into data warehouseDeveloping visual reports, dashboards and KPI scorecards using Power BI desktop.Created the Power BI Reports for the Financial Data and embedding the reports in Web Application.Involved in Architecting and developing the Azure data factory pipelines by creating the datasets and source and destination connections to move the data from oracle database to Azure Data Lake Data Lake Store Raw Zone.Created Calculated Columns and Measures in Power BI and Excel depending on the requirement using DAX queries.Manages access control and permissions for Power Apps and Power Automate environments.Monitors app and workflow performance, security, and compliance.Creates automated workflows using Power Automate.Designs and implements automation solutions to streamline business processes.Integrates Power Automate workflows with other applications and services.Configures triggers, actions, and conditions to automate tasks and processes.Provides technical support and troubleshooting for users encountering issues with apps or workflows.Manages licensing, updates, and version control for Power Platform components.Collaborates with other IT teams to ensure integration and compatibility with existing systems and infrastructure.Developing, publishing and scheduling Power BI reports as per the business requirements.To understand the business requirements and develop the reports accordingly.Environnent: SQL, POWER BI,SSIS, Power Apps,Power AutomateGENCO, Malaysia Jun 2020 to Oct 2020Senior Application EngineerDescription:Working with Genco Systems for the data reconciliation and migrating the data from different other systems to SQL Servers by using ETL. Once data into servers calculating the usage and generating the power bill Invoices based on the use age and plans. Applying promotions and several offers based on eligibility and creating the account details and tracking the usage. Once the usage is into dbs creating the power bi dashboards and calculating based on different KPIs.Responsibilities:Development & Maintenance of Data-Warehouse with MS SQL Server & SSISTrouble Shooting ETL workflow and working on the databases that bug has been raised.Involved in creating power BI reports in Direct Query Mode.On boarding of new data sets into data warehouse.Used complex SQL queries and Excel for data cleaning, transformation, profiling the customer data, which is extracted from various data sources.Extensive experience on SOAP & REST APIs for remotely interacting with Data Relationship Management server, Planning and Essbase instances.Performed DAX (Data Analysis Expressions) & MDX functions for the creation of calculations and measures in the Tabular Mode & multi-dimensional Cubes.Familiarity with data modeling, data warehousing, and ETL processesUnderstanding of data governance and security best practices Proficiency in SQL and data query languages (e.g., DAX, MDX) Experience with migration and integration projectsDeveloping visual reports, dashboards and KPI scorecards using Power BI desktop.Documenting the new changes and implementing them in new different environments like PROD, SIT, UAT.Sharing of Power BI reports and managing workspaces in Power BI service.Built a Tabular Model cube from scratch data and by MDX and DAX queries fetched data to SSRS and Power BI reports.Developing, publishing and scheduling Power BI reports as per the business requirements.Strong knowledge of both TIBCO Cognos and Microsoft Power BIExperience with data visualization, reporting, and business intelligenceEnvironnent: SQL, POWER Bi, SSIS,Paginated ReportingPETRONAS, MalaysiaDec 2019 to Jun 2020Senior BI DeveloperDescription:Working with GP Systems for the data reconciliation and migrating the data from different other systems to SQL Servers and embedding the data in the API with the help of .Net team working with Power bi desktop for the creation of Dashboards and helping on Maintenance of Data. Working on the daily subscriptions. Working around with direct Stake holders and gathering the requirements and developing the Power Bi desktop creating the dashboards and publishing them. Tracking the master data and the data of the systems that are requesting for the purchases and even embedding the billing information of the purchases and tracking the errors raised during this process been tracked with in the dashboard with the complete information in the reports.Responsibilities:Development & Maintenance of Data-Warehouse with MS SQL Server & SSIS.Power BI development and administration.On boarding of new data sets into data warehouseWorked with DAX/MDX queries in building expressions for various business calculations.Developing visual reports, dashboards and KPI scorecards using Power BI desktop. Connecting to data sources, importing data, and transforming data for Business Intelligence.Developed complex reports in Crystal Reports from multiple data sources like Universes and SQL queries.Worked in Creating Calculations using MDX and Supported DAX expressions which were using Pivot table reports.Developing, publishing and scheduling Power BI reports as per the business requirements.To understand the business requirements and develop the reports accordingly.Involved in designing and analyzing the requirement analysis.Developing reports with report builder.Environnent: Power Bi, SQL Server, SSIS,AgileDUTCH LADY, Malaysia Mar 2019 to Nov 2019Business Intelligence/Analyst DeveloperDescription:Working with DMS Systems for the data reconciliation and migrating the data from different other systems to SQL Servers by using ETLs and working with Tableau server for the creation of Dashboards and helping on Maintenance of Data. Working on the daily jobs. Working around with direct Stake holders and gathering the requirements and developing the Tableau Dashboards and ETLs they will be efficient in retrieving the data and scheduling the jobs to acquire the dataResponsibilitiesDevelopment & Maintenance of Data-Warehouse with MS SQL Server & SSISCreating the Dashboards in Tableau for the data representation in the form of dashboards for stake holders.Scheduling the data refresh in the Tableau server once the data source systems are populated with the data.Working on the Enhancements of Tableau dashboards as per the change RequestCreating users adding users to the tableau dashboards and maintaining themWorking on and creating ETL packages to load the data.Designing and implementing of ETL Transformations with SSIS.As a Business analyst working closely with stakeholders to understand their needs, document requirements, and analyze them to ensure they align with the business objectives based on Requirement Gathering and Analysis As a Business analyst Examining existing business processes, identify areas for improvement, and recommend solutions to streamline operations and increase efficiency Business Process Analysis.As a Business analyst need to analyze data to identify trends, patterns, and insights that can inform decision-making and drive business strategy based on Data Analysiscreating detailed documentation such as business requirements documents, functional specifications, and process flows to communicate requirements and solutions to stakeholders and development teams Documentation & Stakeholder ManagementAs a business analyst will be working on continuously monitoring and evaluating business processes and systems to identify opportunities for improvement and innovation for Continuous Improvement,Domain Knowledge & Effective communication skillsEnvironnent : SSIS, TABLEAU, Power Bi, SQL Server, AgilePETRONAS, MalaysiaAug 2018 to Mar 2019Business Intelligence SpecialistDescription:PETRONAS, short for Petroliam Nasional Berhad (National Petroleum, Limited), is a Malaysian oil and gas company. I am Working on the Project named IPPM (INTEGRATED PRODUCTION PERFORMANCE MANAGEMENT) which integrates the production data to the current data and forecast the future production of oil and gas and will be working on the data retrieving from other systems handling through ETL processing through below roles.Responsibilities:Development & Maintenance of Data-Warehouse with MS SQL Server & SSIS.Solution design and implementationCreation, Testing of ETL jobs.Working on and creating ETL packages to load the data.Designing and implementing of ETL Transformations with SSIS.Review test scenarios for UT, SIT, UAT and Production and Support team on defect analysis and resolution.Designed SSIS ETL Packages for extracting data from heterogeneous source systems, transforming and finally loading into the Target Tables.The packages created included a variety of transformations, for Execute SQL Task, Lookup, Aggregate, Derived Column, Conditional Split and Data Conversion.Expertise in providing Logging, Error handling by using Event Handler, for SSIS packages.Environnent : SSIS, Power Bi, SQL Server,WaterfallMindtreeOct 2017 to Aug 2018Module LeadDescription:Commercial Investment Trust and went by the initials of C.I.T. By that time, the company provided financing for wholesale suppliers and producers of consumer goods. The company added automobile financing to its product line in 1916, through an agreement with Studebaker, the first of its kind in the auto industry. During World War I, CIT financed the manufacture of 150 submarine chasers. It also added consumer financing of radios through an agreement with Thomas Edison, Inc. During the Roaring 20s following the war, consumer spending rose dramatically, and CIT prospered in its consumer appliance, furniture, and automobile financing groups.Responsibilities:Working on Denodo Sources to create the flow of the data.Working with Sql data sources by using the flow in Denodo.Working with sql server data to check the data flow and data sources.Checking the breakage of the data and work on data flow is successful from data source to destinations.Working on project Requirements BRDs delivering the deliverables as per the sprint time lines.Experience with data visualization, reporting, and business intelligenceDesign the overall data architecture leveraging Denodo's data virtualization capabilities.Access and analyze data through Denodos virtualized data layer.Oversee the implementation and adoption of Denodo within the organization.Provide technical support for Denodo users. Working with different data sources and accumulating the data for the creation of dashboards.Creating paginated reports with cascading parameters for accurate filtering.Creating grouping mechanism to segregate data in paginated reports.Working on drilldowns and drill throughs in paginated reports to hide complexity of the data.Manages data sources and data connections for Power Apps and Power Automate.Develop and implement data integration workflows using Denodo.Create and maintain virtual databases, views, and data services. Optimize queries and data retrieval processes for performance. Work with data architects to ensure data models are implemented correctly.Ensures data integrity and security within applications and workflowsUnderstanding of data governance and security best practicesEnvironment: SQL Server,Agile,denodo,Power BiAccenture Jun 2016 to Oct 2017Application Development AnalystDescription:Best Buy formed Redline Entertainment, an independent music label and action-sports video distributor. The Project will be able to provide the information of business of the client. The system helps in improving the sales of the business of audio-video, electronic goods all over the geographic locations by providing information of customer details according to sales and the report will be generated and supplied accordingly.Responsibilities:Designing the Reports as per client Requirement and created the reports using Excel file and SQL Server database.Analyzing user requirements, validate available data and propose usable designs.Experience in end-to-end development of a new set of reports, dashboards & KPI Scorecards.Mainly design and develop Tableau dashboards from scratch to support.Experience in connecting and extracting data from different data sources.Data blending to create views combining data from multiple data sources.Highlighted the views by Annotations (Point, Mark, and Area) wherever it requires.Designing and developing reports using Power BI Paginated Reports (formerly known as Power BI Report Builder)Collaborating with data analysts and business stakeholders to understand reporting requirementsTroubleshooting report rendering and data issues in Power Bi paginated reports Keeping up-to-date with new features and best practices in Power Bi Paginated ReportsCreating grouping mechanism to segregate data in paginated reports.Working on drilldowns and drill throughs in paginated reports to hide complexity of the data.Environment: Power BI, Tableau, SQL Server,Paginated ReportingAccenture May 2015 to May 2016Application Development AnalystDescription:TGP for BPO is the internal Client of Accenture Which handles most of all the Bpo clients of Accenture. These projects are handled by Avanade which works for all Microsoft technologies in Accenture.Responsibilities:Deployment and Job Scheduling of SSIS Packages based on Business Requirement using SQL Server Agent Job.Creating Tabular, Parameterized, Drill Through, Drill Down, Matrix and Sub Reports inSSRS.Doing Unit Testing and Data Validation to make sure the output data of the report is.exactly matching with Data Base Queries.using various control flow items for each loop, for loop and data Flow transformationsconditional split, multicast, derived column, lookup, union all, Merge, Merge join.Analyzing user requirements, validate available data and propose usable designs.Experience in end-to-end development of a new set of reports, dashboards & KPI Scorecards.Creation, Testing of ETL jobs.Working on and creating ETL packages to load the data.Designing and implementing of ETL Transformations with SSIS.Review test scenarios for UT, SIT, UAT and Production and Support team on defect analysis and resolution.Working on RDLs for paginated reports.Creating grouping mechanism to segregate data in paginated reports.Working on drilldowns and drill throughs in paginated reports to hide complexity of the data.Environment: SQL, SSIS, SSRS,Paginated ReportingUnilever Ltd (Saswin Consulting), India May 2012 to May 2015BI DeveloperDescription:The Project will be able to provide the information of business of the client. The system helps in improving the sales of the business by providing information on customer details according to the location. As the business of our client is expanding, he wanted to understand better about the business and to analyze the trendResponsibilities:Create and Modify SQL scripts to cater to the requirements.Creation and modification of SSRS reports meeting business requirements.Support and Resolve production incidents.Development of ETL packagesSupport for parallel run in Merge file comparisons.Comparing the data files generated with the actual live data.Creating Paginated reports and deploying them.Creating paginated reports with cascading parameters for accurate filtering.Assigning security to paginated reports which helps to provide access only to particular groupEnvironment: SQL, SSIS, SSRS,MSBI,Paginated Reportin,Waterfall |
