For the given job description <<Provides analysis to different functions such as ManufacturingOperations, SIOP, Sales, Customer Service, Sourcing, Finance, Digital and management of the entire business in reviewing, analyzing, documenting and validating user requirements, applications and processes. Work with stakeholders throughout the organization to identify opportunities for leveraging company data to drive business growth in the current and new revenue streams.
Key Responsibilities
Gathers and evaluates data from multiple sources. Analyzes, reconciles and identifies measurable opportunities for improvement. Identifies and implements audit processes to ensure data issues are identified, tracked, reported and resolved in a timely manner. Develops and maintains processes to continuously monitor data quality and integrity across the business. Creates and maintains workflows and approval processes based on internal stakeholder requirementsActs as subject matter expert for new processes, KPIs, and data management. Collaborates with external and internal customers to analyze information needs and functional requirements. Partners with various leaders to design optimal solutions that meet the business needs of our internal and external customers. Coordinate with different functional teams to implement models and monitor outcomes. Develop processes and tools to monitor and analyze model performance and data accuracy. Develop custom data models and algorithms to apply to data sets. Mine and analyze data from company databases and web platforms to drive optimization and improvement of product development, marketing techniques and business strategies. Assess the effectiveness and accuracy of new data sources and data gathering techniques. 
Professional ExperienceQualifications
Have at least 3-5 years of experience as Data Analyst or a related field. Candidate must possess at least a Bachelors Degree. Detail oriented and accurate. Proficient in MS Excel (including pivot tables). Strong analytic skills related to working with structured and unstructured datasets. Flexible, able to work on own initiative, deal with more than one project at a time, can work under pressure and tight deadlines, and prioritize tasks accordingly. Very good communication skills, verbal and written. Self-starter and a strong team player. Sophisticated problem-solverHigh knowledge of Power BI or similar analytics toolsStrong knowledge of Google Analytics, Adobe Analytics or other web analytics platforms. Python andor R language experienceSolid experience building Microsoft Power Apps and in Power AutomateExperience in visualizationStrong understanding of SQLOracle Knowledge
Benefits
Medical, Dental, Vision and Prescription Drug CoverageSpending accounts (HSA, Health Care FSA and Dependent Care FSA)Paid Time Off and Holidays401k Retirement Plan with Matching Employer ContributionsLife and Accidental Death & Dismemberment (AD&D) InsurancePaid LeavesTuition Assistance
About Regal Rexnord
Regal Rexnord Corporation (Regal Rexnord) is a leading manufacturer of electric motors, electrical motion controls, power generation and mechanical power transmission products and sub-systems, serving customers around the world in the general industrial, consumer, commercial construction, food & beverage, and alternative energy end markets, among others. Regal Rexnord sells its products and solutions to OEMs, through distributors, and directly to end-users. Regal Rexnord is a $7.2B company with 36,000 associates globally.
You may not know it, but Regal Rexnord impacts your life every day. The companys products enable the fans in HVAC systems that keep us comfortable; the power source that keeps smart buildings running; the agricultural and food service equipment that keeps us fed; and the conveyer systems that keep e-commerce flowing, to name a few of the applications where our products are used.
Regal Rexnords business purpose is to create a better tomorrow by energy-efficiently converting power into motion. This means creating innovative solutions while focusing on both customer needs and the companys commitment to sustainability. The companys industrial powertrain and automation solutions offerings are an important part of the company's growth strategy. The companys strategy includes leveraging 8020 to prioritize all activities, including product excellence, operational excellence and commercial excellence (i) driving organic sales growth through the introduction of innovative new products, with a particular focus on improving energy efficiency, (ii) establishing and maintaining new customers, as well as developing new opportunities with existing customers, (iii) participating in higher growth end markets and geographies, and (iv) identifying and consummating strategic, value creating acquisitions.
Equal Employment Opportunity Statement
Regal Rexnord is an Equal Opportunity and Affirmative Action Employer. All qualified applicants will receive consideration for employment without regard to race, color, religion, sexgender, sexual orientation, gender identity, age, ancestry, national origin, marital status, citizenship status (unless required by the applicable law or government contract), disability or protected veteran status or any other status or characteristic protected by law. Regal Rexnord is committed to a diverse and inclusive workforce. We are committed to building a team that represents diverse and inclusive backgrounds, perspectives, and skills.
Notification to Agencies: Please note that Regal Rexnord Corporation and its affiliates and subsidiaries ("Regal Rexnord") do not accept unsolicited resumes or calls from third-party recruiters or employment agencies. In the absence of a signed Master Service Agreement or similar contract and approval from HR to submit resumes for a specific requisition, Regal Rexnord will not consider or approve payment to any third-parties for hires made.>> the resume: <<SummaryDynamic and motivated IT professional with around 7 years of experience as a Big Data Engineer with expertise in designing data intensive applications using Hadoop Ecosystem , Big Data Analytical , Cloud Data engineering , Data Warehouse / Data Mart, Data Visualization , Reporting , and Data Quality solutions .In - depth knowledge of Hadoop architecture and its components like YARN , HDFS, Name Node, Data Node, Job Tracker, Application Master, Resource Manager , Task Tracker and Map Reduce programming paradigm.Extensive experience in Hadoop led development of enterprise level solutions utilizing Hadoop components such as Apache Spark, MapReduce, HDFS, Sqoop, PIG, Hive, HBase, Oozie, Flume, NiFi, Kafka, Zookeeper, and YARN.Profound experience in performing Data Ingestion, Data Processing (Transformations, enrichment, and aggregations).Strong Knowledge on Architecture of Distributed systems and Parallel processing, In-depth understanding of MapReduce programming paradigm and Spark execution framework.Experienced with the Spark improving the performance and optimization of the existing algorithms in Hadoop using Spark Context , Spark-SQL , Dataframe API , Spark Streaming, MLlib , Pair RDD 's and worked explicitly on PySpark and Scala .Handled ingestion of data from different data sources into HDFS using Sqoop, Flume and perform transformations using Hive, Map Reduce and then loading data into HDFS.Managed Sqoop jobs with incremental load to populate HIVE external tables. Experience in importing streaming data into HDFS using Flume sources, and Flume sinks and transforming the data using Flume interceptors.Experience in Oozie and workflow scheduler to manage Hadoop jobs by Direct Acyclic Graph ( DAG ) of actions with control flows.Implemented the security requirements for Hadoop and integrating with Kerberos authentication infrastructure- KDC server setup, creating realm /domain, managing.Experience of Partitions, bucketing concepts in Hive and designed both Managed and External tables in Hive to optimize performance .Experience with different file formats like Avro , parquet , ORC , Json and XML .Expertise in Creating, Debugging, Scheduling and Monitoring jobs using Airflow and Oozie.Experienced with using most common Operators in Airflow - Python Operator, Bash Operator, Google Cloud Storage Download Operator, Google Cloud Storage Object Sensor.Hands-on experience in handling database issues and connections with SQL and NoSQL databases such as MongoDB , HBase , Cassandra , SQL server , and PostgreSQL .Created Java apps to handle data in MongoDB and HBase. Used Phoenix to create SQL layer on HBase.Experience in designing and creating RDBMS Tables, Views, User Created Data Types, Indexes, Stored Procedures, Cursors, Triggers and Transactions.Expert in designing ETL data flows using creating mappings/workflows to extract data from SQL Server and Data Migration and Transformation from Oracle/Access/Excel Sheets using SQL Server SSIS .Expert in designing Parallel jobs using various stages like Join, Merge, Lookup, remove duplicates, Filter, Dataset, Lookup file set, Complex flat file, Modify, Aggregator, XML.Hands-on experience with Amazon EC2, Amazon S3, Amazon RDS, VPC, IAM, Amazon Elastic Load Balancing, Auto Scaling, CloudWatch, SNS, SES, SQS, Lambda, EMR and other services of the AWS family.Created and configured new batch job in Denodo scheduler with email notification capabilities and Implemented Cluster setting for multiple Denodo node and created load balance for improving performance activity.Instantiated, created, and maintained CI/CD (continuous integration & deployment) pipelines and apply automation to environments and applications.Worked on various automation tools like GIT, Terraform, Ansible. Experienced in fact dimensional modeling ( Star schema, Snowflake schema ), transactional modeling and SCD (Slowly changing dimension)Experienced with JSON based RESTful web services, and XML/QML based SOAP web services and also worked on various applications using python integrated IDEs like Sublime Text and PyCharm .Efficient Cloud Engineer with years of experience assembling cloud infrastructure. Utilizes strong managerial skills by negotiating with vendors and coordinating tasks with other IT team members. Implements best practices to create cloud functions, applications and databases.
Skills·Big Data Technologies:Hadoop, MapReduce, HDFS, Sqoop, PIG, Hive, HBase, Oozie, Flume, NiFi, Kafka, Zookeeper, Yarn, Apache Spark, Mahout, Sparklib·Databases:Oracle, MySQL, SQL Server, MongoDB, Cassandra, DynamoDB, PostgreSQL, Teradata, Cosmos.·Programming:Python, PySpark, Scala, Java, C, C++, Shell script, Perl script, SQL·Cloud Technologies:AWS, Microsoft Azure·Frameworks:Django REST framework, MVC, Hortonworks·Tools:PyCharm, Eclipse, Visual Studio, SQL*Plus, SQL Developer, TOAD, SQL Navigator, Query Analyzer, SQL Server Management Studio, SQL Assistance, Eclipse, Postman·Versioning tools:SVN, Git, GitHub·Operating Systems:Windows 7/8/XP/2008/2012, Ubuntu Linux, MacOS·Network Security:Kerberos·Database Modelling:Dimension Modeling, ER Modeling, Star Schema Modeling, Snowflake Modeling·Monitoring Tool:Apache Airflow·Visualization/ Reporting:Tableau, ggplot2, matplotlib, SSRS and Power BI·Machine Learning Techniques:Linear & Logistic Regression, Classification and Regression Trees, Random Forest, Associative rules, NLP and Clustering.
ExperienceAWS Data Engineer,01/2022-02/2022Deloitte–Ann Arbor,MI,Designed and setup Enterprise Data Lake to provide support for various uses cases including Analytics, processing, storing and Reporting of voluminous, rapidly changing dataResponsible for maintaining quality reference data in source by performing operations such as cleaning, transformation and ensuring Integrity in a relational environment by working closely with the stakeholders & solution architectDesigned and developed Security Framework to provide fine grained access to objects in AWS S3 using AWS Lambda, DynamoDBSet up and worked on Kerberos authentication principals to establish secure network communication on cluster and testing of HDFS, Hive, Pig and MapReduce to access cluster for new usersPerformed end- to-end Architecture & implementation assessment of various AWS services like Amazon EMR, Redshift, S3Implemented the machine learning algorithms using python to predict the quantity a user might want to order for a specific item so we can automatically suggest using kinesis firehose and S3 data lakeUsed AWS EMR to transform and move large amounts of data into and out of other AWS data stores and databases, such as Amazon Simple Storage Service (Amazon S3) and Amazon DynamoDBUsed Spark SQL for Scala & amp, Python interface that automatically converts RDD case classes to schema RDDImport the data from different sources like HDFS/HBase into Spark RDD and perform computations using PySpark to generate the output responseCreating Lambda functions with Boto3 to deregister unused AMIs in all application regions to reduce the cost for EC2 resourcesImporting & exporting database using SQL Server Integrations Services (SSIS) and Data Transformation Services (DTS Packages)Coded Teradata BTEQ scripts to load, transform data, fix defects like SCD 2 date chaining, cleaning up duplicatesDeveloped reusable framework to be leveraged for future migrations that automates ETL from RDBMS systems to the Data Lake utilizing Spark Data Sources and Hive data objectsConducted Data blending, Data preparation using Alteryx and SQL for Tableau consumption and publishing data sources to Tableau serverDeveloped Kibana Dashboards based on the Log stash data and Integrated different source and target systems into Elasticsearch for near real time log analysis of monitoring End to End transactionsImplemented AWS Step Functions to automate and orchestrate the Amazon SageMaker related tasks such as publishing data to S3, training ML model and deploying it for predictionIntegrated Apache Airflow with AWS to monitor multi-stage ML workflows with the tasks running on Amazon SageMakerEnvironment: AWS EMR, S3, RDS, Redshift, Lambda, Boto3, DynamoDB, Amazon SageMaker, Apache Spark, HBase, Apache Kafka, HIVE, SQOOP, Map Reduce, Snowflake, Apache Pig, Python, SSRS, TableauAssessed organization technology infrastructure and managed cloud migration process.Configured computing, networking and security systems within cloud environment.Implemented cloud policies, managed technology requests and maintained service availability.Data Engineer,01/2016-11/2019Honeywell–Huntsville,AL,Worked on Azure Data Factory to integrate data of both on-prem (MY SQL, Cassandra) and cloud (Blob storage, Azure SQL DB) and applied transformations to load back to Azure SynapseManaged, Configured and scheduled resources across the cluster using Azure Kubernetes ServiceMonitored Spark cluster using Log Analytics and Ambari Web UITransitioned log storage from Cassandra to Azure SQL Datawarehouse and improved the query performanceInvolved in developing data ingestion pipelines on Azure HDInsight Spark cluster using Azure Data Factory and Spark SQLAlso Worked with Cosmos DB (SQL API and Mongo API)Develop dashboards and visualizations to help business users analyze data as well as providing data insight to upper management with a focus on Microsoft products like SQL Server Reporting Services (SSRS) and Power BIPerformed the migration of large data sets to Databricks (Spark), create and administer cluster, load data, configure data pipelines, loading data from ADLS Gen2 to Databricks using ADF pipelinesCreated various pipelines to load the data from Azure data lake into Staging SQLDB and followed by to Azure SQL DBCreated Databrick notebooks to streamline and curate the data for various business use cases and also mounted blob storage on DatabrickUtilized Azure Logic Apps to build workflows to schedule and automate batch jobs by integrating apps, ADF pipelines, and other services like HTTP requests, email triggers etcWorked extensively on Azure data factory including data transformations, Integration Runtimes, Azure Key Vaults, Triggers and migrating data factory pipelines to higher environments using ARM TemplatesIngested data in mini-batches and performs RDD transformations on those mini-batches of data by using Spark Streaming to perform streaming analytics in Data bricksEnvironment: Azure SQL DW, Databrick, Azure Synapse, Cosmos DB, ADF, SSRS, Power BI, Azure Data lake, ARM, Azure HDInsight, Blob storage, Apache Spark.Adept in troubleshooting and identifying current issues and providing effective solutions.Managed performance monitoring and tuning while identifying and repairing issues within database realm.Identified key use cases and associated reference architectures for market segments and industry verticals.Designed surveys, opinion polls, and assessment tools to collect data.Tested, validated and reformulated models to foster accurate prediction of outcomes.Created graphs and charts detailing data analysis results.Recommended data analysis tools to address business issues.Developed new functions and applications to conduct analyses.Cleaned and manipulated raw data.Collaborated with solution architects to define database and analytics engagement strategies for operational territories and key accounts.Big Data Engineer / Hadoop Developer,10/2013-12/2015Infosys Ltd–Irwindale,CA,AnsibleDenodoDenodoCloudWatchAvroPySparkPySparkPySparkMLlibDataframeNiFiNiFiInteracted with business partners, Business Analysts and product owner to understand requirements and build scalable distributed data solutions using Hadoop ecosystemDeveloped Spark Streaming programs to process near real time data from Kafka, and process data with both stateless and state full transformationsWorked with HIVE data warehouse infrastructure-creating tables, data distribution by implementing partitioning and bucketing, writing and optimizing the HQL queriesBuilt and implemented automated procedures to split large files into smaller batches of data to facilitate FTP transfer which reduced 60% of execution timeWorked on developing ETL processes (Data Stage Open Studio) to load data from multiple data sources to HDFS using FLUME and SQOOP, and performed structural modifications using Map Reduce, HIVED eveloping Spark scripts, UDFS using both Spark DSL and Spark SQL query for data aggregation, querying, and writing data back into RDBMS through SqoopWritten multiple MapReduce Jobs using Java API, Pig and Hive for data extraction, transformation and aggregationAvrom multiple file formats including Parquet, Avro, XML, JSON, CSV, ORCFILE and other compressed file formats Codecs like gZip, Snappy, LzoStrong understanding of Partitioning, bucketing concepts in Hive and designed both Managed and External tables in Hive to optimize performanceDeveloped PIG UDFs for manipulating the data according to Business Requirements and also worked on developing custom PIG LoadersDeveloping ETL pipelines in and out of data warehouse using combination of Python and Snowflakes SnowSQL Writing SQL queries against SnowflakeExperience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Parameterized, Cascading, Conditional, Table, Matrix, Chart and Sub ReportsUsed DataStax Spark connector which is used to store the data into Cassandra database or get the data from Cassandra databaseWrote oozie scripts and setting up workflow using Apache Oozie workflow engine for managing and scheduling Hadoop jobsWorked on implementation of a log producer in Scala that watches for application logs, transform incremental log and sends them to a Kafka and Zookeeper based log collection platformUsed Hive to analyze data ingested into HBase by using Hive-HBase integration and compute various metrics for reporting on the dashboardTransformed tPySpark using AWS Glue dynamic frames with PySpark; cataloged the transformed the data using Crawlers and scheduled the job and crawler using workflow featureWorked on installing cluster, commissioning & decommissioning of data node, name node recovery, capacity planning, and slots configurationDeveloped data pipeline programs with Spark Scala APIs, data aggregations with Hive, and formatting data (JSON) for visualization, and generatiPySparkEnvironment: AWS, Cassandra, PySpark, Apache Spark, HBase, Apache Kafka, HIVE, SQOOP, FLUME, Apache oozie, Zookeeper, ETL, UDF, Map Reduce, Snowflake, Apache Pig, Python, Java, SSRSOnfidentialDeveloped and implemented Hadoop code while observing coding standards.Optimized and tuned Hadoop environments and modified hardware to meet prescribed performance thresholds.Developed new functions and applications to conduct analyses.Created graphs and charts detailing data analysis results.Tested, validated and reformulated models to foster accurate prediction of outcomes.Python Developer,09/2012-10/2013Fiserv–City,STATE,AWS, S3, EC2, LAMBDA, EBS, IAM, Datadog, CloudTrail, CLI, Ansible, MySQL, Python, Git, Jenkins, DynamoDB, Cloud Watch, Docker, KubernetesLeveraged open communication, collective decision-making and thorough reviews to create performant and scalable systems.Worked with server-side and front-end technologies and leveraged common design patterns to code dynamic and user-friendly systems.Implemented new API routes, architected new ORM structures and refactored code to boost application performance.Harnessed version control tools to coordinate project development and individual code submissions.Introduced cloud-based technologies into Python development to expand on-premise deployment options.Wrote clear and clean code for use in projects.Resolved customer issues by establishing workarounds and solutions to debug and create defect fixes.
Education and TrainingMaster of Science:Data Engineering,Expected in05/2023-George Mason University-Fairfax,VAGPA:Status-Bachelor of Engineering:Computer Networking And Telecommunications,Expected in05/2019-University of Mumbai-India,GPA:Status->>. The result is, No Fit

Fit assessment: No Fit