Neelam Mishra Email and Phone Number
PROFESSIONAL SUMMARY:• 8+ years of industrial experience on big data analysis, data mining, statistical inference, and ETL pipelines.• Expert level experience in MS Excel including Macros, Lookups and Pivot Tables. Strong expertise in writing complex SQL queries.• Experienced in Project management skills, keeping in mind the objectives of the project and constraints affecting time, scope and budget.• Worked on Use Case design and analysis, Use Case specifications, Scenarios, Business processes, Work flow diagrams, process flows and technical documentation, using Unified Modeling Language UML, MS Office Suite and Rational Suite.• Experience in dealing with different data sources ranging from Flat files, SQL server, Oracle, MySQL, MS Access and Excel.• Skilled in data preparation tasks within SPSS, including data cleaning transformation, and handling missing values to ensure data quality.• Analyzed the effectiveness of marketing campaigns by tracking and measuring campaign data in Salesforce.• Created visually impactful dashboards in Excel and Tableau for data reporting by using pivot tables and VLOOKUP.• Experienced in designing and developing data extraction, transformation and load (ETL) processes using Informatica and SSIS.• Worked on coordinating User Acceptance Testing and Functional Testing with the Business Users and System Testing, Unit Testing with the Team.• Implemented projects using both Agile Methodology and Waterfall Methodology for software development, creating several documents like System Architecture diagrams and Specification documents.• Strong understanding of data lake approaches, industry standards best practices and Machine Learning for driving business solutions using SQL, Advanced Excel, tableau, and Power BI.• Hands-on experience in working on Agile SCRUM projects and TEMP effectively managing cross-functional teams and leading projects across the product roadmap.• Worked on publishing of various kinds of interactive dashboards and workbooks from Tableau Desktop to Tableau Servers.• Skilled in Excel, Power BI, Cognos and Tableau for data visualization, Reporting and Analysis, Cross Map, Scatter plots, Geographic Map, Pie Charts and Bar Charts, Page Trails and Density Chart.• Involved in optimizing ETL jobs for efficiency, focusing on performance tuning, parallel processing, and batch optimization to reduce data processing time and enhance overall system performance.
Florida Blue
View- Website:
- floridablue.com
- Employees:
- 6602
-
Senior Data AnalystFlorida Blue Mar 2021 - PresentJacksonville, Florida, United StatesResponsibilities:• Worked on technical data governance, enterprise-wide data modeling and database design and developed multi-dimension data models to support BI solutions developed as well as other common industry data from external systems.• Loaded data into Hive Tables from Hadoop Distributed File System (HDFS) to provide SQL access on Hadoop data.• Developed workflow in Oozie to automate the tasks of loading the data into HDFS and pre-processing with Hive• Involved in scheduling Oozie workflow engine to run multiple Hive and Pig jobs. Developed Oozie workflow jobs to execute HIVE.• Used SQL on the new AWS Databases like Redshift and Relation Data Services and worked with various RDBMS like Oracle 11g, SQL Server.• Responsible for full data loads from production to AWS Redshift staging environment and responsible for creating Hive tables, loading data, and writing hive queries.• Created SQL tables with referential integrity and developed SQL queries using SQL Server and Toad.• Worked with project management, business teams, and departments to assess and refine requirements to design/develop BI solutions using Tableau.• Created Tabular Data Models and implemented Tableau for POC in Share Point Environment.• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XML etc.) and loaded the data into target data sources by performing different data transformations (DTS) using SSIS.• Created and Designed logical database schema layout structure to prepare for ETL processes, data mining, extraction, analysis and reporting system.• Designed and developed UNIX shell scripts as part of the ETL process, automate the process of loading, pulling the data.• Authored User-Defined Functions and Stored Procedures while defining Roles and Privileges to control database access.
-
Senior Data AnalystCity Of San Antonio Oct 2019 - Feb 2021San Antonio, TxResponsibilities: • Designed process for automation of data reports by writing SQL queries and setting up data connections in Excel.• Create and manage all management reports/data files submitted to SSA.• Collaborated with the Database Developed in the automation process for the data files by developing Access queries to load them in the SQL Server platform.• Produce quality control logs/producers for different management reports to assure the quality and accuracy of the data provided to SSA.• Created and manage Batch Processing Database (Access) to produce all batch files for individual financial institutions and Early Warning service.• Contributed in the design process of the batch testing plan that outlined the test cycles and data requirements.• Prepared Business Requirement Documents (BRD’s) after the collection of Functional Requirements from System Users that provided appropriate scope of work.• Created Data mapping, logical data modeling coordinating with data architects, created class diagrams and ER diagrams and used SQL queries to filter data within the Oracle database.• Redefined numerous attributes and relationships in the reverse-engineered model and cleansed unwanted tables/columns within the Teradata database as part of data analysis responsibilities.• Participated in SQL Development, Unit Testing, and Performance Tuning to resolve testing issues based on defect reports.• Experienced in Agile methodologies, utilizing JIRA to facilitate sprint planning, daily stand-ups, sprint reviews, and retrospectives.• Designed the ER diagrams, Logical model (relationship, cardinality, attributes, and candidate keys) and physical database (capacity planning, object creation and aggregation strategies) for Oracle and Teradata as per business requirements using ERWIN. -
Data AnalystWalmart May 2017 - Sep 2019Bentonville, Arkansas, United StatesResponsibilities:• Develop proof of concepts (POC) using Azure Cloud services such as Azure Data factory (ADF), Logic Apps, Data Bricks, Azure SQL DB, Power BI and Azure Data Lake storage (ADLS) to validate proposed solutions and seek feedback from stakeholders. • Working on getting the data from on frame SQL server database to a Raw Zone in Azure Data Lake by using Azure Data Factory. • Used Parquet file formats on Azure Blobs to store raw data. • Monitored the SQL scripts and modified them for improved performance using PySpark SQL Develop Azure Databricks notebooks to apply business transformations and perform data cleansing operations. • Generated various types of reports, including Drill-Down Reports, Parameterized Reports, Linked Reports, Sub Reports, and Ad-hoc Reports using SQL Server Reporting Services (SRSS).• Supported the team in creating Data Mapping and logical data models, collaborating with data architects, constructing class diagrams, ER diagrams, and utilizing SQL queries to filter data within the Oracle database.• Coordinated and conducted meetings for business and system requirements analysis, involving business stakeholders, technology partners, business analysts, data modelers, and project managers.• Executed performance tuning tasks, particularly optimizing complex queries, procedures, and indexing strategies, along with managing Data Import/Export and Database Recovery/Backup processes.• Used spark, python, delta while reading data from parquet files in ADLS to Data frame and writing to destination ADLS location. Partitioned data and implemented schema drift by using metadata JSON file before writing data to destination location in ADLS. • Implemented ETL platform using Azure Data Factory, Data Bricks, Data Lake, Azure SQL. -
Sql Server DeveloperAt&T Jul 2015 - Apr 2017Dallas, TxResponsibilities:• Involved in designing the data warehouse and core Database for the system using Star Schema including tables, Stored Procedures, Indexes. • Implemented SSIS (ETL) to extract and transform data from Oracle RDBMS, Teradata and Flat files/CSV, SQL Server 2005 instances and to load into staging and then to DW for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all; Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks. • Created/updated Stored Procedure, Triggers, User Defined Functions, User defined data type, Scripts and batches. • Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database. • Generated SQL Server Drill down, Drill through, Adhoc, Sub-Reports using SSRS to fit business requirements.• Created VB.Net Script for Data Flow and Error Handling in Script component. Used Query Optimization and SQL Server Profiler for tuning report queries and improves performance in SQL Server. • Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.• Configured SQL Mail agent for sending automated alerts/email.
Neelam Mishra Education Details
-
Honors/Regents High School/Secondary Diploma Program
Frequently Asked Questions about Neelam Mishra
What company does Neelam Mishra work for?
Neelam Mishra works for Florida Blue
What is Neelam Mishra's role at the current company?
Neelam Mishra's current role is Senior Data Analyst @ Florida Blue.
What schools did Neelam Mishra attend?
Neelam Mishra attended Delhi University.
Who are Neelam Mishra's colleagues?
Neelam Mishra's colleagues are Haydee Gil, Mirna Haddad, Jim Mozingo, Milly Nemes, Kathryn Youngberg, Ileana Diaz, Stephen Asare.
Not the Neelam Mishra you were looking for?
-
Neelam Mishra
Sr Solutions Analyst | Workforce Analytics Analyst |Descriptive Analytics| Python| Ml| Power Bi| SqlRaleigh-Durham-Chapel Hill Area1opsveda.com -
Neelam Mishra
Student Body President @ Idaho State University | Inbre Research Fellow 2024 | Case Management, Addiction Counseling, Treatment PlansPocatello, Id -
-
1cisco.com
Free Chrome Extension
Find emails, phones & company data instantly
Aero Online
Your AI prospecting assistant
Select data to include:
0 records × $0.02 per record
Download 750 million emails and 100 million phone numbers
Access emails and phone numbers of over 750 million business users. Instantly download verified profiles using 20+ filters, including location, job title, company, function, and industry.
Start your free trial