| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateHEMANTH VEMURIEMAIL AVAILABLE PHONE NUMBER AVAILABLEPROFESSIONAL SUMMARY:10+ years of Software Development Life Cycle experience in a Data Warehouse environment including requirement gathering, analysis and development.Hands-on experience working in Visualization tools like Tableau and Qlikview.Good understanding of traditional RDBMS systems and SQL.In-depth knowledge in data visualization using Tableau desktop to publish and present dashboards.Good working knowledge of various ETL and ELT techniques using Informatica to load data from different sources into a Data Warehouse.Prepared Dashboards using calculations, parameters and various reporting objects like Facts, Attributes, Hierarchies, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in TableauGood understanding of data quality standards and processes that lead to Data Governance.Excellent presentation skills and able to proficiently communicate with technical and non-technical audiences.Learned computer vision and developed object detection models carrying multiple classes.Developed and maintained web applications using Python, Django, HTML, and CSS, ensuring a user-friendly and responsive interface.Managed and optimized SQL Server databases, implementing efficient queries and database design to enhance overall system performance.Expert understanding of the Software Development Life cycle (SDLC) and exposure to deliver the projects using Agile and Waterfall Methodology.Experience in Tableau Desktop v2020.X, 2019.x, Tableau Server, creating highly interactive Data visualization Reports and Dashboards using feature.Extensively working with databases Oracle 10g/11g/12c, Oracle RDBMS, MS SQL Server, DB2, SSIS, SSRS, and SSAS in SQL Server.Adept in utilizing Power Query, Power Pivot, and Power View to craft compelling reports and dashboards within Power BI.Experienced in Power BI working with different Enterprise Data sources like SAP HANA, SSAS Cubes, Hadoop HDFS, SQL Servers, AWS Redshift, DB2 and the Extracts (auto/incremental) using RDBMS systems.Designed and deployed rich Graphic visualizations with Drill Down and Drop down menu option and parameterized using Power BI.Successfully orchestrated data mapping for all migration tasks utilizing SSIS (SQL Server Integration Services).Executed Python and R scripts seamlessly within Power BI Desktop.Developed a Face Recognition model for Face Verification and Identification purposes and developed a basic API using Flask and ARC on python.Proficiently utilized PL/SQL to create Stored Procedures, Functions, Triggers, and Packages across Oracle database versions (10g/9i/8i/8.0/7.x).Developed Paginated Reports using Power BI Report Builder.Expertise in managing Relational Database Management Systems (RDBMS), encompassing E/R Diagrams, Normalization, De-Normalization, Constraints, Data Import-Export operations, and more.Built multiple object detection models using multiple versions of YOLO.EDUCATION:MS in Industrial & Systems Engineering from Northern Illinois, UniversityB. Tech, Mechanical Engineering from VRSEC, India.CERTIFICATION:Python 3, SQL, Snowflake and Tableau certification from UdemyTECHNICAL PROFILE:BI ToolsTableau, Qlikview 8/9, MS Power BIAI/MLOpenCV, YOLO V3/V4, Darknet, Tensorflow, FaceNet,Programming LanguagesPython 3, SQLData Integration/ETLHaarCascade.SnowFlakeInformatica PowerCenter 9.6Operating SystemsLinux, Windows 8/10Office ToolsMS Word, MS Excel, PowerPointTECHNICAL SKILLS:RDBMS/DBMS:MS SQL Server 2016/2014/2012/2008R2/2008/2005/2000, MySQL, Oracle 11g/10g/9i/8i, and MS Access 2003/2000/97Database Technologies/Tools:SQL Server Entreprise Manager, Microsoft Management Console, SQL, T-SQL, Data Transformation Services (DTS), OLTP, SSIS, OLAP, Microsoft Visio, ER StudioDatabases:Azure SQL Database, Azure data warehouse, Azure Data Factory, MS SQL Server 2008 R2, 2012, 2014,2016, Snowflake, MySQL and Oracle12c.Azure Cloud:Azure SQL Database, Azure Data Lake, Azure Data Factory (ADF), Azure SQL Data Warehouse, Azure Service Bus, Azure Analysis Service (AAS), Azure Blob Storage.Reporting Tools:Power BI, SSRS, Crystal Reports, Report Studio, Report builder, Oracle Discoverer.Operating Systems:Windows XP, 2000, NT, 98, Windows 2003, Windows Vista, Windows 7Programming Languages:T-SQL, PL/SQL, HTML, VB.Net, C++, R script, jQuery, Python, Windows ScriptsDesign Technologies/Tools:Erwin, MS Visio, Rational RoseData Warehouse / Business Intelligence ToolsSQL Server Reporting Services (SSRS), SQL Server Integration Services (SSIS), Visual Studio 2016/2014/2013/2010/2008, Visual Studio Shell, Cognos11,8.xETLSQL Server Integration Services (SSIS), Informatica 8.xPROFESSIONAL EXPERIENCE:Client: Citi Bank, Irving, Texas July 2022 - PresentRole: Sr. Power BI DeveloperResponsibilities:Produced impactful reports enriched with visualizations using Power BI Desktop.Routinely generated weekly and monthly reports with scheduled refreshments in Power BI Service.Demonstrated proficiency in M code and the Advanced Editor within Power Query.Seamlessly worked with diverse data sources, including SQL Server, CSV, MS Excel, and Oracle Database.Developed intricate SQL queries for data extraction and manipulation.Shared Power BI reports within the Microsoft Dynamics 365 environment.Constructed Paginated reports using the Power BI Report Builder.Masterminded and crafted Dashboards within Power BI Service.Designed KPI Scorecards, Dashboards, and Reports to facilitate data-driven insights.Published and scheduled reports through Power BI Service, ensuring the generation of daily, weekly, monthly, and quarterly reports.Seamlessly integrated Power BI Dashboards into Microsoft Dynamics 365.Proficiently published Power BI reports on the Power BI Service platform.Took charge of building Power BI Dashboards utilizing both Tabular and Multi-Dimensional Models.Implemented a range of DAX functions to enhance fact calculations, resulting in efficient data visualization within Power BI Dashboards.Environment: MS SQL Server 2016, MS D365, Management Studio (SSMS), Power BI Dashboard, Power BI Service, DAX Studio, Power BI Report BuilderClient: WellsFargo, Irving, TX, USA Jan - 2019 - July 2022Role: Power BI DeveloperResponsibilities:Employed DAX functions extensively to compute data sourced from CARDINAL.Crafted highly effective reports enriched with visualizations in Power BI.Took charge of constructing Power BI Dashboards utilizing both Tabular and Multi-Dimensional Models.Designed data sets within Power BI Desktop, aligning them with the measures and dimensions requested by business users and dashboard requirements.Executed Forward and Reverse Engineering Data modeling techniques.Regularly produced bi-weekly reports with scheduled refreshes in Power BI Service.Leveraged Microsoft Power BI Power Query for efficient ETL activities.Demonstrated proficiency in M code and the Advanced Editor within Power Query.Utilized Dynamics 365 for user management and security purposes.Seamlessly interfaced with diverse data sources, including SQL Server, CSV, MS Excel, and Oracle Database.Developed complex SQL queries to extract and manipulate data.Generated Paginated reports using SSRS (SQL Server Reporting Services).Possessed strong expertise in crafting KPI Scorecards, Dashboards, and Reports.Demonstrated proficiency in publishing Power BI reports on the Power BI Service platform.Translated business requirements into logical structures using DAX Studio.Implemented a variety of DAX functions to facilitate diverse fact calculations, enhancing data visualization efficiency within Power BI.Created both Static and Dynamic Row-Level Security (RLS).Generated reports by establishing a connection between Power BI Desktop and Dynamics 365 data.Employed Incremental Refresh strategies utilizing parameters.Collaborated with MS SQL Stored Procedures to enhance data processing efficiency.Showcased extensive experience in crafting various report types, including Tabular forms, Matrices, List items, Charts, and Subreports.Environment: MS SQL Server2014, Management Studio (SSMS), Power BI Dashboard, Power BI Service, DAX Studio, SSRS, D365.BCBS, Atlanta, GA Apr - 2018 To Dec - 2018Role: Python Developer/AI TraineeResponsibilities:Carried out web scraping using Python and Selenium to extract data of places of interest throughout India.Took over the duties of developing a Face Recognition model using Haar Cascade. Successfully demonstrated it and developed a basic API using Flask & Python.identified the defects in visitor data, performed root cause analysis and Re-Categorized the visit purposes to suit the context of data collection.Proposed methods to streamline the data collection process and suggested UI changes to simplify the user experience in order to reduce data collection error and increase data integrity.In-house product:Carried out web scraping using Python and Selenium to extract data of places of interest throughout India.Built a single class object detection model, successfully demoed it and transformed it to multiclass object detection model.Converted the weights of the above-mentioned model to TFLite to run in on a rudimentary mobile application to test the concept.Developed a face recognition system with keras using FaceNet and improving the accuracy of the existing models mentioned above.Scaled up the FaceNet model to 10000 classes to while achieving of minimum the loss of accuracy.Trained wav2lip and wav2lip-Emotion models to demo a digital avatar POC.Environment: Python, Django, HTML, CSS, SQL Server, SOAP, NumPy, Pandas, SVN, Bugzilla, PyTest, NetBeans, UML.SA Group, Detroit, MI Aug - 2016 To Apr - 2018Role: Tableau/Data AnalystResponsibilities:Excellent PL/ SQL skills for daily testing of data using various SQL queries.Managed Power BI Portal-Data refreshes/ User management and setup gateway data refresh.Used Parameters and Quick filters, Dynamic X and Y axe using Parameters, Table Calculations.Received METAL file from GEPICS team every week and run the ETL process to load the data in to XM tables.Built interactive reports, dashboards, and/or integrating modeling results and have strong Data Visualization design skills and analytic background by using Power BI and Tableau desktop.Developed Stored Procedures to test ETL Load per batch and provided performance optimized solution to eliminate duplicate records.Created and run jobs on AWS cloud to extract transform and load data into AWS Redshift using AWS Glue, S3 for data storage and AWS lambda to trigger the jobsDesigned the Functional Requirements and Mapping Technical Specifications based on Functional Requirements. Analyzed large, disparate data sets from a variety of sources to better understand viewers, increase consumer engagement, optimize ad placement, and improve marketing.Integrated Hadoop with Tableau and SAS analytics to provide end users analytical reports.Provided the team with technical leadership on ETL design and development best practices.Automated GLUE ETL jobs using S3 events and AWS lambda functions.Developed back-end interfaces using PL/SQL Stored Packages, Procedures, Functions and Triggers.Supported data management process through queries, functions, stored procedures, views, indexing in SQL Server, MySQL databases.Ensured data quality from various sources, cleaned, and transformed data and loaded into a datawarehouse using SSIS.Created views and structured and efficient queries on large data sets using multi-type table joins, multiple keys, and nested queries.Analyzed and report key data quality health KPIs through regular metric monitoring and revise as needed as the number of datasets and critical systems expand.Translated complex reporting needs into technical specifications, including calculations, custom groups, parameters, filtering criteria and/or aggregations.Wrote queries & data dictionaries to analyze data and create visualization/dashboards related to audience and direct-to-consumer insights allowing departments to interact with data.Environment: T-SQL, PL/SQL, SSIS, SSAS, SSRS, MDX, Visual Basic, MS Excel, Toad, PPSHiral Technologies, Durham, NC Jan - 2015 To Jun - 2016Role: Tableau DeveloperResponsibilities:Deep experience with the design and development of Tableau visualization solutions.Created extracts, published data sources to tableau server, refreshed extract in Tableau server from Tableau Desktop.Used groups, combine fields, calculated fields and aggregated fields and spotlighting to compare and analyze data in different perspectives.Worked on creating interactive, real-time dashboards using drilling down and customizations.Published Workbooks and Dashboards to the Tableau server.Importing tables using Warehouse catalog and Creating Logical TablesExtensively used analytical features in Tableau like Statistical functions and calculations, trend lines, forecasting etc. in many tableau reports.Created Actions in Worksheets and Dashboards for interactivity and to compare data against different views.Environment: T-SQL, PL/SQL, SSIS, SSAS, SSRS, MDX, Visual Basic, MS Excel, Toad, PPSIndwell PVT LTD, India Mar - 2013 To Dec - 2014Role: Data VisualizationResponsibilities:Worked on the development of Dashboard reports for the KPIs for the executive management.Published numerous interactive visualizations, workbooks from Desktop to Servers.Designed a database using SQL - Server 2012 R2 and established the connection with application for update and retrieval of data.Tuning ETLUtilized SSIS to develop data integration processes and views to create result sets to meet varying reporting requirementsAnalysis of source to target mappings and logic design of the same.Migrated data from source to target, performed Ad-hoc analysis and scheduled daily reports on QlikView. |
