Lucy P Email and Phone Number
Experienced and results-driven SQL Power BI Developer with a proven track record of success in data visualization, dashboard design, and data modeling. With 6 years of hands-on experience, I have honed my expertise in SQL, DAX, and M Query for data extraction, transformation, and analysis. My proficiency extends to various databases including MS SQL Server, Oracle, MySQL, and PostgreSQL, as well as cloud platforms such as Microsoft Azure.Throughout my career, I have demonstrated a strong understanding of statistical analysis, data modeling, and machine learning techniques, allowing me to deliver actionable insights to drive business decisions. Notably, I have spearheaded the development and support of Business Intelligence solutions using a range of tools including Power BI, SSAS, SSIS, SSRS, Qlik, and Tableau, ensuring the effective utilization of data assets to meet organizational objectives.One of my key strengths lies in my ability to communicate complex technical concepts to non-technical stakeholders, facilitating collaboration and alignment across diverse teams. Additionally, my commitment to staying abreast of emerging trends and technologies in data analytics, visualization, and cloud computing enables me to continuously enhance my skills and deliver innovative solutions.In my most recent role at Hitachi Solutions America Ltd, I collaborated closely with IT service management teams to develop customized solutions using SQL, Power BI, Python, and Azure. Leveraging advanced features of T-SQL and tools like Spark and Databricks, I designed and implemented robust data pipelines to support large-scale analytics solutions. Furthermore, my experience in mentoring and guiding business power users underscores my dedication to knowledge sharing and capacity building within the organization.As a US Citizen holding an MBA with System from Sambalpur University, India, I bring a unique blend of technical expertise and business acumen to the table. I am passionate about leveraging data-driven insights to empower organizations and drive sustainable growth. Looking ahead, I am excited about the opportunity to contribute my skills and experience to further advance the goals and objectives of a dynamic and forward-thinking organization.
Hitachi Solutions America
View- Website:
- hitachi-solutions.com
- Employees:
- 701
-
Sql And Power Bi EngineerHitachi Solutions AmericaFrisco, Tx, Us
-
Sql/Power Bi EngineerHitachi Solutions America May 2022 - PresentIrvine, California, United States• Extracted, transformed, and loaded data from various sources, including ERP systems and manufacturing databases, using SQL and ETL tools.• Developed interactive dashboards and reports using Power BI to visualize manufacturing KPIs and performance metrics.• Collected and analyzed data from manufacturing equipment and systems to monitor performance and detect anomalies.• Developed and maintained SQL queries and stored procedures to extract and manipulate data from relational databases.• Collected, cleaned, and analyzed large datasets to identify trends, patterns, and correlations.• Created interactive dashboards and reports using Tableau to visualize key metrics and KPIs.• Conducted ad-hoc analysis and provided data-driven insights to support business decision-making.• Collaborated with cross-functional teams to understand business requirements and address data-related challenges.• Participated in the development of predictive models to forecast sales, customer behavior, and product demand.• Designed and implemented custom reports and visualizations to track production yield, quality, and downtime.• Conducted exploratory data analysis to uncover insights and identify data quality issues.• Contributed to the development of data visualizations and reports to communicate findings to stakeholders• Supported the implementation of machine learning algorithms for predictive modeling tasks• Participated in team meetings and brainstorming sessions to discuss project progress and findings• Participated in continuous improvement initiatives and lean manufacturing projects to streamline operations and reduce waste.• Created automated ETL processes using SQL to extract, transform, and load data from multiple sources into Power BI.• Contributed to the creation of Python scripts for automating repetitive data processing tasks, improving workflow efficiency.Environment: Power BI, SQL Server, SSIS, SSAS, SSRS, SSMS, SSDT, T-SQL, TFS, Tableau, SQL Profiler, DTA.
-
Power Bi DeveloperTandem Diabetes Care Sep 2020 - Apr 2022San Diego, California, United States• Translated business needs and requirements from JRD sessions to technical and functional specifications/documentation.• Crafted and built data system that serves as the backbone for transformation project data management and analytics capabilities• Developed and executed SQL queries and conducted analysis for data preparation.• Worked closely with internal and external business partners for business intelligence solutions; from gathering requirements, to preparing data, to building reports and dashboards in Power BI Desktop, to demonstrating functionalities and insights capabilities with end users.• Used various sources to pull data into Power BI such as SQL Server, Oracle SharePoint online Excel, CVS etc.• Involved in Data Validation on the SaaS form of data using SOAP UI, SQL Developer to ensure and perform accurate data mapping.• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.• Developed visual reports, dashboards and KPI scorecards using Power BI Desktop.• Monitor and Create Alerts for critical KPI’s, Metrics, Data Visualization for Business Process.• Implemented report integration among Power BI, Tableau, SSRS and Python reports.• Created letters, reports with BI Publisher and Oracle HCM.• Used advance features of T-SQL in order to design and tune T-SQL to interface in Azure cloud and other applications in most efficient manner.• Presented/demonstrated data analytics insights through reports and visualizations.• Wrote efficient complex DAX calculations and M-code programming in Power BI Desktop.• Medical Cost Personal Dataset Research: utilized data mining methods, linear regression, regression tree and clustering algorithms in R, using statistics to provide validated predictions of medical costs among different groups of people.Environment: Power BI Desktop, Power BI Service, SQL Server 2017/2016, SSIS, Oracle HCM, BI Publisher, SSMS, T-SQL, SQL Profiler, DTA, SharePoint. -
Power Bi Data AnalystParker Hannifin Jul 2017 - Aug 2020Cleveland, Ohio, United States Gathered business requirements through end-user collaboration through JRD and JAD meetings. Documented business logics, and requirements and worked closely with the solutions architect, project managers, developers to design data model, reports, dashboards to answer leaders’ questions. Successfully enhanced and implemented pre-existing logical and physical databases. Worked with IT and business partners to resolve production issues that may arise. Worked in conjunction with the Data Warehouse team to develop solutions and support organization-wide reporting, and data analysis and alternative practices. Wrote complex reports in SSRS, Power BI and shared dashboards and reports with user groups as per their roles in the organization. Created stored procedures for generating reports using SQL Server Reporting Services (SSRS), Crystal Reports. Highly experienced in whole cycle of DTS/SQL server integration services (SSIS, SSAS, SSRS, Power BI, QlikView, and Tableau) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers Business Analysis. Troubleshot bugs, maintained the existing reports, and optimized them based on user requirements. Created complex SQL statement structures with joins, sub queries, and correlated sub queries. Wrote custom T-SQL stored procedures and indexes to improve performance and preserve referential integrity Designed and optimized dynamic SQL batches to perform bulk operations in the OLTP environment. Migrated SSIS packages from development to production environments with package configurations. Implemented SSIS projects monitoring framework in terms of its performance and debugging capabilities Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse. Implemented TFS for version control and change management of BI solution for cross-functional communications.
Frequently Asked Questions about Lucy P
What company does Lucy P work for?
Lucy P works for Hitachi Solutions America
What is Lucy P's role at the current company?
Lucy P's current role is SQL and Power BI Engineer.
Who are Lucy P's colleagues?
Lucy P's colleagues are Mark Guinan, Evan S., Jonalyn Gualberto, Charlotte Clark, Mitch Grande, Shyrlene Shelton, Katie O'donnell, Mba.
Not the Lucy P you were looking for?
-
3bestbuy.com, live.com, agile-defense.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