| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidateCandidate's Name
Email: EMAIL AVAILABLEContact No: PHONE NUMBER AVAILABLEPROFESSIONAL SUMMARY8+ years of experience working in IT Industry with SQL developer and BI report services document delivery.Experienced in all aspects of Software Development Lifecycle (SDLC) from inception to delivery including requirements gathering, use cases, functional specification, design, estimation, implementation and debugging, documentation and maintenance.Highly proficient in Agile, Test Driven, Iterative, Scrum and Waterfall software development life cycle.Hands-on experience in end-to-end Data warehousing process methodologies, which includes developing warehouse SQL scripts, ETL Ab Initio Routines, stress testing, and data quality processes.5+ years of experience in Alteryx platform, and involved in data preparation, data blending, and the creation of data models, data sets using Alteryx.Good experience in Data Science tools and techniques like Python, R, SQL, NoSQL, and Tableau within the IT industries.Experienced in working with various Python IDE's using PyCharm, PyScripter, Spyder, PyStudio and PyDev.Knowledge about setting up Python REST API Framework using Django.Generated interactive charts with Matplotlib and Seaborn library in Python for exploring and explaining data.Provided BI Analysis for the marketing team to review impact on key metrics in relation to the project.Used Python to analyze the data, run statistical analysis and create reports or dashboards.Used Alteryx to enable integration with virtually any data source from any location and enrich them with third-party spatial, location-based, and demographic data to get the richest set of data available for analysis in Tableau.Expertise in building visualization using Power BI, Power APP, Power View, Power Query.Proficiency using Power BI, Power BI Service, Tableau Server, Tableau cloud, Tableau Online.Developed complex Power BI dashboards and created appealing visualizations for derived datasets.Outstanding knowledge& working experience of slice & dice Looker, Power BI & Cognos.Created queries using DAX functions in Power BI desktop.Adept at utilizing Data Analysis Expressions (DAX) and Power Query to create complex calculations, custom measures, and efficient data transformations, ensuring data accuracy and relevance.Deploying Azure Resource Manager JSON Templates from PowerShell worked on Azure suite: Azure SQL Database, Azure Data Lake, Azure Data Factory, Azure SQL Data Warehouse, Azure Analysis ServiceConsulted with stakeholders to gather and document requirements for data governance projects, helping to establish agreed upon data definitions and consistent data capture across the company.Critically evaluated information gathered from multiple sources and worked with customers to assess whether data conformed to data governance approved mappings and standards.Combined the data blending and advanced analytics of the Alteryx Analytics platform with the rich visualizations of Tableau.Evaluated existing DWH, including data sources, data model, schema, and queries and used for migrating to cloud.Managed and administered MS Dataverse instances for data storage, sharing, and collaboration.Evaluated cloud providers based on requirements, such as security, scalability, pricing, and features. Some of the popular cloud providers for DWH migration are Amazon Web Services (AWS), Microsoft Azure, and Google Cloud Platform (GCP).Used Alteryx Analytics to simplify the complex task of determining and gathering the relevant data and then cleansing the data for consumption.Expertise in all aspects of Snowflake, including data modeling, ELT utilizing Snowflake SQL, and the seamless implementation of intricate stored procedures.Experience in designing Data Marts by following Star Schema and Snowflake Schema Methodology.Used Alteryx Analytics to easily add powerful third-party geospatial, location intelligence, firmographic, and demographic tools as part of any analytic workflow, allowing not only to visualize where events are taking place but also to drive location-specific decision-making.Used Alteryx Analytics to enable and make critical business decisions based on forward-looking, predictive analytics, rather than on past performance or simple guesswork.Used embedded predictive analytics tools and Alteryx Analytics to make sophisticated statistical techniques accessible to everyone.Preparing dashboards using calculated fields, parameters, calculations, groups, sets and hierarchies in Tableau.Experience in using Tableau functionalities for creating different Requests, Filters, Chart, Interactive dashboards with Page and Dashboard Prompts.Implemented and designed dashboards using Qlik View, Qlik sense.A combination of technical skills in Power BI and ServiceNow, as well as the ability to bridge the gap between IT and business stakeholders to deliver meaningful insights and solutions.Strong knowledge of Power BI to import data from various sources such as SQL Server, MS Excel, etc.,Skilled in developing visually rich charts, matrices, maps, slicers, funnel, and gauges utilizing Power BI, delivering actionable insights.Good experience in implementing Row Level Security, and security groups to restrict data.Experience in Performing data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.Involved in creating database objects like tables, views, stored procedures, triggers, and functions using T-SQL to provide definition, structure and to maintain data efficiently.Proficient in working with various data sources such as Oracle, SQL Server, ODBC, and flat file sources.Proficient in design and development of various dashboards using Tableau Visualizations like Dual Axis, Bar Graphs, Scatter Plots, Pie-Charts, Heat Maps, Bubble Charts, Box Plots.Strong hands-on Tableau Charts/Graphs, filters, Parameters, sets, user filters for preparing dashboards and worksheets, calculated fields, Table Calculation, Action(s), Date and GEO (MAP).Ability to analyze and obtain insights from complex/large data sets, Building and publishing interactive reports and dashboards, report scheduling using Tableau server.Experience in building Groups, Hierarchies, Bins and Table calculations.Conversant with all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development, and Implementation.Experience in developing Performance Dashboards, Score Cards, Metrics, What If Analysis, Prompts, Drills, Search (Using Add-ons), Reports/Dashboards for all the functional areas including Finance, Change Management, Order Management, Pricing, Purchasing, HR, Demand Planning, Discrete Manufacturing, Quality, Inventory, Warehouse Management, Supply Chain, Transportation, Sales/Marketing, Variable objects with formulas.Strong interpersonal skills with demonstrable verbal and written communications to maintain effective work relationships with all levels of personnel.TECHNICAL SKILLSBusiness Intelligence ToolsTableau Desktop 2019.x/2018.x/10.x/9.x/8.x, Tableau server, Tableau Online, Tableau Prep, Microsoft Power BI, SAP Business Objects, Power BI, QlikView, Qlik SenseOperating SystemsWindows 10/8/7, LINUX/UNIX.DatabasesMS SQL Server, Oracle, HP Vertica, IBM UD2 DB2, Teradata, MS Access, HANA, SAP BW, AWS S3, Dynamo DBToolsMS Visio, Requisite Pro, MS Office, MS Project, OLAP, JIRAMethodologiesSDLC, Agile, Waterfall, RUP, RADETL ToolsSSIS, SSAS, Informatica, Power BI, SnowflakeProgramming LanguagesPython, R, Java, PL/SQL, SQL, CWORK EXPERIENCESignet Jewelers, RemoteSr BI Consultant/Sr Data Analytics March 2022 PresentResponsibilities:Involved in design and development of Tableau visualization solutions.Developed effective dashboards according to the requirements of the clients by using Tableau Desktop.Designed and created Data Quality baseline flow diagrams, which includes error handling and test plan flow dataUsed Alteryx Analytics to easily add powerful third-party geospatial, location intelligence, firmographic, and demographic tools as part of any analytic workflow, allowing not only to visualize where events are taking place but also to drive location-specific decision-making.Created a new BigQuery project in the Google Cloud Console and set up billing for the project.Planned the design of BigQuery data model, including data storage, data processing, and data integration.Developed storytelling dashboards in Tableau Desktop and published them on to Tableau Server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.Created rich dashboards using Tableau Dashboard and prepared user stories to create compelling dashboards to deliver actionable insights.Proficient in navigating the Adobe Analytics interface, setting up reports, creating custom segments, and interpreting data insights to drive business decisions.Designed and implemented data models using entities, fields, and relationships within MS Dataverse.Customized data entities, attributes, and forms to align with specific business requirements.Performed website optimizations, user experience, and marketing efforts by analyzing large datasets using Adobe Analytics, even the Visualizations.Integrated the insights from various analytics platforms helping to draw conclusions.Integrated MS Dataverse with external systems using Power Automate (formerly Microsoft Flow) for seamless data flow and synchronization.Enabled data-driven decision-making by presenting information in a clear and accessible format.Created automated workflows to trigger actions based on specific data changes or events.Collaborated closely with business stakeholders, analysts, and IT teams to understand existing reporting requirements and design data migration strategies.Conducted thorough data mapping and transformation, ensuring data consistency and accuracy during the migration process.Developed and implemented ETL processes to extract data from Cognos, transform it to align with Power BI requirements, and load it into the new system.Leveraged Power BI to create interactive and visually compelling reports, translating complex data into actionable insights for decision-makers.Deploying the code into all other test environments and making sure QA passes all their test cases.Resolving the defects that have been raised by QA.Established best practices for DataStage jobs to ensure optimal performance, reusability, and restart ability.Extracted the data from the DB2 database and loaded it into downstream Mainframe files for generating the reports.Implemented advanced analytics techniques in Power BI, such as forecasting, clustering, and regression analysis, to uncover hidden trends and patterns, contributing to data-driven strategies.Designed and developed logical and physical data models in Snowflake, ensuring efficient storage, optimized querying, and adherence to industry best practices.Developed end-to-end ETL pipelines using AWS services like Glue, Data Pipeline, or custom Python/Spark scripts to extract, transform, and load data into Snowflake data warehouse from various data sources, such as S3, RDS, or DynamoDBIdentified and resolved performance bottlenecks in Snowflake data warehouse, utilizing query optimization techniques and Snowflake-specific features like clustering and materialized views to enhance query speed and reduce costs.Implemented robust security measures in Snowflake, including role-based access controls, virtual warehouses, and encryption mechanisms, ensuring compliance with data governance policies and industry regulations.Optimized Snowflake usage to control costs, right-sizing virtual warehouses, and utilizing Snowflake's auto-pause feature when not in use, resulting in significant cost savings for the organization.Involved in creating stored procedures, views, and custom SQL queries to import data from SQL server to tableau.Worked extensively with Advance analysis Actions, Calculations, Parameters, Background images, Maps.Tested reports and uploaded tableau dashboards on to server and provided production support for tableau users.Develop, test, and maintain .NET applications using languages like C#, VB.NET, or F#.Design software architecture and system frameworks using .NET technologies.Develop and execute test plans, test cases, and test scripts for .NET applications.Implement continuous integration (CI) and continuous deployment (CD) pipelines for .NET applications.Lead and manage .NET development projects from inception to delivery.Write and optimize T-SQL queries, stored procedures, functions, and triggers.Install, configure, and maintain T-SQL Server instances and database servers.Extract, transform, and load (ETL) data from various sources into T-SQL databases.Write complex T-SQL queries to retrieve and analyze data for reporting and decision-making purposes.Design and implement data pipelines for streaming and batch processing of data using technologies like T-SQL Server Integration Services (SSIS) or Azure Data Factory.Ability to work quickly and under tight delivery deadlines with focus on details.Hands-on development assisting users in creating and modifying worksheets and data visualization dashboards.Defined and created procedures to install Tableau desktop in silent mode and best practices for Tableau report development.Created Data Integrator mappings to load the data warehouse. The mappings involved extensive use of simple and complex transformations like Key Generator, SQL Query Transform, Table Comparison, Case, Validation, Merge, lookup etc. in Data flows.Created Metrics, Analytics, Rules, Goals for the Corporate Dashboard.Created mockup dashboards and presented to the higher-level end users to have them a look and feel of the dashboards.Performed Data Analysis using SAS and statistical Modelling to support decision making process at higher level.Created the SAS modules for the applications to assist in predictive modeling of the real time market for the vaccine department.Familiar with SAS Visual Analytics, SAS Enterprise Guide applications.Develop and maintain reporting and analytical tools, including Business ObjectsLead BI work stream projects in the implementation and use of new BI software tools and systems.Got involved in designing the Data model for the Data warehouse and for different Data marts.Performed End to end testing using SQL Queries in Oracle.Prepared many other reports by using master details, crosstabs, slice and dice and drill mode as per the requirement of the end-uses.Developed predictive analytics and forecast models to help clients gain deeper insights on existing data and information, improve business performance, and shape the future of the companies.Used SQL skills for daily testing of data using various SQL queries.Extract, transform, cleanse, and load (ETL) data into Microsoft SQL Server, Staging Databases using Microsoft SSIS.Developed complex mappings/sessions using Informatica Power Center for data loading.Created, maintained & scheduled various reports in SSRS like Tabular Reports, Matrix Reports & Parameterized Reports & Paginated reports using SQL Server Reporting Services SSRS.T-Mobile, Seattle, WASr BI Consultant/Data Analytics Jan 2021 Feb 2022Responsibilities:Involved in BI work stream projects in the implementation and use of new BI software tools and systems.Ensured Product, Operations and Product Strategy groups have access to reliable data to make real-time business decisions.Design, develop, and maintain server-side logic and APIs using .NET technologies such as ASP.NET MVC, ASP.NET Core, or Web API.Stay updated with the latest .NET technologies, frameworks, and best practices.Optimized DWH performance and scalability based on usage patterns and changing business needs.Validated the data accuracy and consistency, as well as the performance of queries and reports.Construct the AWS data pipelines using VPC, EC2, S3, Auto Scaling Groups (ASG), EBS, Snowflake, IAM, CloudFormation, Route 53, CloudWatch, CloudFront, CloudTrail.In-depth knowledge of programming languages Python and expertise in SQL.Experience in creating Dashboards and visualization charts using Tableau, Python (Matplotlib, Seaborn).Extensively used Pandas (Python) for Data Munging, NumPy and SciPy for numerical computations.Worked on Machine Learning Algorithms, Stochastic Process and Modeling, Data Mining, Model development, Validation and Scoring / Projections in R, Python and SAS environment.Excellent hands-on experience with coding in Perl or PythonAdvanced Perl and/or Python scripting skills are used in applications.Managing and monitoring the AWS EC2 instances and copied and then synchronized the schema and data from the legacy data warehouse.Identified and migrated data warehouse to big query.Worked on creating schemas and connecting tableau to AWS Redshift.Design and construct of AWS Data pipelines using various resources in AWS including AWS API Gateway to receives response from AWS lambda and retrieve data from snowflake using lambda function and convert the response into JSON format using Database as Snowflake, DynamoDB, AWS Lambda function and AWS S3.Worked on creating schemas and connecting tableau to AWS Red shift and Hive.Experience with Tableau reporting/data visualization tool and integration between Alteryx and Tableau.Designed and developed ETL workflows and datasets in Alteryx to be used for Reporting (ETL tool specific for creating datasets) Tableau Data Extract for BI.Designed, developed, and tested various Power BI/Tableau visualizations for dashboard and ad-hoc reporting solutions.Deploying SSRS Reports across multiple environments including Test and supporting environments.Created effective dashboard and made the reports user friendly and interactive.Good SQL reporting skills with the ability to create SQL views and write SQL queries.Successfully performed the report migration from Cognos to Power BI, which was ongoing project.Extensively worked on micro strategy administration that includes intelligence server administration, configuration of memory settings and performance monitoringHandled user licenses for projects.Identify opportunities to develop forecasts, statistical models, segmentation schemes, and data-driven analyses to drive marketing and merchandising efforts around customer acquisition and conversion.Importing tables using Warehouse catalog and Creating Logical TablesInvolved as a technical expert providing input to application design regarding production tuning and administration requirements.Lead the design and development of analytical projects designed to understand key business behaviors that drive customer acquisition, retention, and engagement.Involved in creating data blending in case of merging different sources, used Alteryx for Data blending for Tableau.Utilize T-SQL for database interactions, including querying, inserting, updating, and deleting data.Design and maintain database schemas using T-SQL Server or other relational database management systems.Write complex T-SQL queries, stored procedures, triggers, and functions to manipulate and retrieve dataStay updated with the latest T-SQL features, database technologies, and development best practices.Used embedded predictive analytics tools and Alteryx Analytics to make sophisticated statistical techniques accessible to everyone.Familiarity with SAS programming knowledge and features.Designed and developed ETL workflows and datasets in Alteryx.Used Alteryx for Data Preparation and then Tableau for Visualization and Reporting.Used ETL (Alteryx) process to Extract, Transform and Load the data into stage area and data warehouse.Cleaned and Structured data from multiple sources to discover and interpret trends, patterns, and relationships.Worked with business owners to identify key data elements that will be monitored on an on-going basis to ensure a high level of data quality within the Warehouse.Developed reports to the specification of Business Intelligence group by using Tableau DesktopBuilt Tableau visualizations by connecting to various Data Sources Relational Databases (Oracle, SQL Server).Created views in Tableau Desktop that were published to internal team for review and further data analysis and customization using filters and actions.Developed paginated reports utilizing Power BI Report Builder and SQL Server Reporting Services (SSRS), presenting critical business insights to stakeholdersWrote, tested, and implemented Teradata Fast load, Multiload and BTEQ scripts, DML and DDL.Santander Bank, Chicago, ILData Analyst May 2018 Dec 2020Responsibilities:Worked on the requirement gathering of the reports.Worked closely with other developers, testers, and business stakeholders to ensure that the application meets the requirements and is delivered on time while working on MongoDB.Used various features and functionalities of MongoDB, such as indexing, sharding, and replication, to optimize the performance of the database.Analyzed the database tables and created database views based on the columns needed.Created dashboards displaying sales, variance of sales between planned and actual values.Implemented calculations and parameters wherever needed.Published dashboards to Tableau server.Server setup and maintenance and scheduling the server backups.Developed SQL Server Impersonation for Impersonation Requirements, How Impersonation Works, impersonating with a Run as User Account, Impersonating with Embedded SQL Credentials.Created Tableau scorecards, dashboards using bar graphs, scattered plots, stack bars geographical maps, Gantt charts using show me functionality.Created detailed level summary report using Trend lines, Statistics, log axes, groups, and hierarchies.Performed calculations in Tableau using SQL queries.Reviewed basic SQL queries and edited inner, left, and right joins in Tableau Desktop by connecting Live/Dynamic and Static datasets.Responsible for different Data mapping activities from Source systems to EDW, ODS and data marts.Created the test environment for Staging area, loading the Staging area with data from multiple sources.Performed ad hoc analyses, as needed, with the ability to comprehend analysis as needed.Responsible for creating test cases to make sure the data originating from source is made into target properly in the right format.Tested several stored procedures and wrote complex SQL syntax using case, having and connect byInvolved in Teradata SQL Development, Unit Testing and Performance Tuning and to ensure.Performed extensive Requirement Analysis including data analysis and gap analysis. Designed and developed project document templates based on SDLC methodology.Developed interactive story telling dashboards in Tableau Desktop and published them to Tableau server which allowed end users to understand the data on the fly with the usage of quick filters for on demand needed information.Proficient in developing Entity-Relationship diagrams, Star/Snowflake Schema Designs, and expert in modeling Transactional Databases and Data Warehouse.Demonstrated ability to write complex SQL queries in Snowflake to extract, transform, and load (ETL) data from various sources, ensuring data integrity and accuracy.Designing and implementing data models within Snowflake, including schema creation, table structures, and optimizing database performance.Experienced in integrating and consolidating data from diverse sources into Snowflake, facilitating streamlined data pipelines and enhancing data accessibility.Created Power BI (Power Pivot/ View) to design multiple scorecards and dashboards to display information required by different departments and Upper-level management.Explored data in various ways and across multiple visualizations using Power BI. Strategic expertise in the design of experiments, data collection, analysis, and visualization.Spearheaded the development and maintenance of QlikView and Qlik Sense applications, enabling Santander Bank to extract critical insights from vast financial datasets and make data-driven decisions.Designed and implemented ServiceNow integrations with Power BI, automating the extraction of IT service management (ITSM) data for reporting and analysis.Collaborated with IT teams to streamline incident, problem, and change management processes, resulting in improved efficiency and cost-savingCreated Parameterized Report, Dashboard Report, Lined Report, and Sub Report by Year hierarchy. Scheduled Automatic refresh and scheduling refresh in Power BI service.Capital One, Chicago, ILBI Consultant Mar 2016 April 2018Responsibilities:Created and published Tableau reports using Sets, Filters, calculated fields, Table Calculations and Parameters.Created views in Tableau Desktop that were published to internal team for reviews and further data analysis and customization using filters and actions.Using MongoDB implemented appropriate security measures to protect the data stored in the database.Designed developed and maintained applications that use MongoDB as the backend database.Blended data from multiple databases into one report by selecting primary keys from each data for data validation.Combined views and reports to create interactive dashboards in Tableau Desktop that were presented to Project Managers, Business Users and End Users.Scheduled data refresh on Tableau Server for daily, weekly, and monthly increments based on business change to ensure that the views and dashboards were displaying the updated/changed data accurately.Involved in creating complex stored procedures, triggers, cursors, tables and views and other SQL joins and statements for applications.Involved in creation and updates of several SQL index, views, complex stored procedures, triggers, and appropriate user defined functions.Used ETL process to Extract, Transformation and Load the data into the stage area and data warehouse.Documented complex server architecture and solutions to troubleshoot performance, scheduling, and server related issues.Developed and maintained complex SQL queries to extract and manipulate large datasets.Analyzed data to identify patterns and trends that informed business decisions and improved customer experience.Built and maintained dashboards and visualizations using Tableau and Power BI to communicate insights to stakeholders.Collaborated with cross-functional teams to identify business problems and develop data-driven solutions.Developed predictive models to identify high-risk customers and inform retention strategies.Participated in Agile sprints to deliver data-driven solutions to stakeholders.Improving operational efficiencies and effectiveness.Conducting analysis to evaluate processes and tests.Extracting and analyzing data to gauge product offerings.Consulting on the design and implementation of new production and data storage systems.Create meaningful visualizations and reports.Education:Masters in computer science, University of Texas at Arlington, TX (2015-2016)Bachelors in computer engineering, IIIT Bhubaneswar, India (2011-2015) |
