| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Candidate's Name Phone: PHONE NUMBER AVAILABLE Email: EMAIL AVAILABLEEDUCATION
Nova Southeastern University, Fort Lauderdale, FL Dec Street Address
Master s in management of Information Systems (Business Intelligence and Data Analytics)Jaypee Business School (JBS), JIIT, India April Street Address
Master of Business AdministrationTECHNICAL SKILLS
Database toolsMS-SQL Server (2019/2016/2012/2008), SQL Query AnalyzerETL ToolsSQL Server Data Tools (SSDT), SQL Server Integration Services (SSIS), Data Transformation servicesToolsMicrosoft SQL Server Management Studio, XLMiner, Studio3T, Heap AnalyticsOffice ToolsMS Word, MS Excel Advance (Analytics), MS PowerPoint, Macro-based Excel, MS Access, Visio, OutlookVisualization toolsPower BI, TableauProgramming LanguagesSQL, PythonMiscellaneous toolsAgile, JIRA, SharePoint, MS Azure, MS Visio (2010), ServiceNow, Project requirement gathering & Analysis, Project budget planning, Project Scope, Planning, and Prioritizing, Ability to communicate technical concepts to non-experts, Amazon RedshiftPROFESSIONAL EXPERIENCE
Invicktus: Data Engineer Feb 2022 - Present Provide data analysis support to the Digital Strategy team by means of data mining, research, analysis, building reports, and data visualizations for enhancements related to all Digital touchpoints and the associated business metrics Use analytics tools and click stream data to identify customer traffic and behavior across the process funnel, quote completion, and purchase rates, and create hypothesis testing/ A/B tests to make recommendations for enhancement. Experience with Heap Analytics in understanding and optimizing the customer s digital experience and built dashboards to monitor website conversion rate using Heap Analytics. Created, deployed, and executed the SSIS package using SQL Server Agent. Worked with Software Engineering and QA teams (Agile) to develop, product managers to interpret, and deliver data and reporting requirements to ensure technology solutions directly align with and meet business objectives Designed Tableau dashboards to monitor team metrics, providing insights that allowed team members to focus on user behavior and make strategic decisions to improve overall business performance. Deployment of Reports, Packages, and Dashboards from testing to production. Worked with the Data Warehouse team to develop, interpret, and deliver data and reporting requirements to ensure technology solutions directly align with and meet business objectives. Integrated and join the data with limited supervision from various of data sources to create meaningful insights and presentations. Troubleshoot and provide support on existing projects or application efforts. Experience in developing complex reporting with an understanding of current business processes and metrics. Created database objects like tables, reports, user-defined functions, and cursors using DDL, and DML statements. Developed various solution-driven views and dashboards by developing different chart types including Pie Charts, Bar Charts, Tree Maps, Circle Views, Line Charts, Area Charts, and Scatter Plots in Tableau. Worked on Agile methodology to design, develop, test, and implement analytics and reporting features and functions. Experience in identifying patterns and relationships in large data sets, as well as applied mathematical, statistical, and other data-driven analysis to address questions. Worked with a variety of data sources using SQL (Redshift).Tools and Environment: SQL Server 2000/2005/18, Excel VBA, Tableau, SQL Server Integration Services (SSIS), MS Excel, Excel VBA, Data, MS Visio, MS Power BI, Oracle SQLProcess Advisor: Barclays Feb 2015 - Oct 2015 Experience in data analysis and understanding of how data is sourced, collected, transformed, validated, managed, used, and controlled in an organization. Implemented several calculated measures for various fact calculations for efficient data visualization in Tableau. Created complex stored procedures, triggers, functions, Indexes, tables, views, and SQL joins for applications following SQL code standards. Created various workflows for incident management, change management, service request, and SLAs with Service Now. Performed data profiling, cleansing, validation, and verification with SSIS tasks and SQL stored procedures. Monitored and configured SSIS packages for dynamic execution and deployed packages to the testing environment. Developed drill through, drill down, linked, sub, and parameterized reports for improved analysis. Responsible for creating SSIS packages to extract data from different sources consolidate and merge it into one single source. Performed analysis of data for extraction, transformation, and load (ETL) strategies using SQL Server Integration Services.Tools and Environment: SQL Server 2000/2005, Excel VBA, Tableau, SQL Server Integration Services (SSIS), XLMiner, MS Excel, Excel VBA, Data, MS Visio, TableauAnalyst: KPMG Sep 2013 - Oct 2014 Collaborated with several teams (IT, Payment, QC) as a subject matter expert to define business requirements. Performed analysis of data for Extraction, Transformation, and Load (ETL) strategies, pattern recognition, and application of analytical tools. Build several reports, dashboards, and perform data analysis in Power BI and Excel Performed research and analysis for decision-making by extracting and manipulating large data sets from various relational databases using SQL Performed Pivoting and un-pivoting of the data model in Power BI using Power Query for data cleansing and massaging. Experience in designing expressions to calculate, group, filter, parameterize, and format report contents. Experience in analyzing complex data, drawing conclusions, and making recommendations. Developed test cases for deployment verification, ETL data validation, cube testing, and report testing. Experienced working with the ETL team for extracting the relevant data from OLTP by analyzing and gathering user requirements. Created complex reports such as customer profitability, total revenue, total expense, product analysis, and sales analysis. Developed an end-to-end project plan using agile methodologies (SDLC) to serve the clients using a project management approach.Tools and Environment: Oracle SQL, SQL Workbench, SQL Server 2000/2005, Power BI, ETL Packages (SSRS, SSIS), Microsoft Excel, Windows XP, MS Access, Macro-Based Excel, MS Office. |
