Piyush Vijayvargiyaa Email and Phone Number
Piyush Vijayvargiyaa work email
- Valid
- Valid
- Valid
- Valid
Piyush Vijayvargiyaa personal email
- Valid
Piyush Vijayvargiyaa phone numbers
Over 17+ years of hands-on experience in software industry. Experience includes requirement analysis, design, development, implementation and deployment. Seasoned Business Intelligence Professional Securing 14+ years of experience in ETL, Data Warehousing, Business Intelligence & Big Data.14+ years of live experience in ETL, Data Warehousing & Business Intelligence on various databases like SQL Server, Oracle, MPP database Vertica, AWS and MS Azure. 14+ years of experience working in complex data environment and producing KPI along with corporate business metrics in real time transactional database and data warehouse environment. 14+ years of experience in conducting research, analysis and reporting on data patterns in large scale and highly transactional production environment as well as data warehouse environment. 14+ years of experience in integrating data from disparate sources and generating production reports using multiple reporting environments. Manage and work on simultaneous projects, adapt to frequently changing business priorities, and handle competing interests fairly and effectively. Lead BI team in Enterprise information Management process to ensure data quality and accuracy by analyzing data for unusual patterns and sync data across different sources and destination to maintain data consistency. Involved in developing and designing of self-serviced data-marts to answer complex business questions as requested by the Executive / Senior Leadership Team Excellent verbal and written communication skills, learning attitude, self-motivation and ability to work in team or alone. Specialties: Microsoft SQL Server, VerticaMicrosoft SQL Server Reporting services, Tableau, Microstrategy, Power BIMicrosoft SQL Analysis ServerMicrosoft SSIS
Ps3Systems
View- Website:
- ps3systems.com
- Employees:
- 3
-
Founder And Solution ArchitectPs3SystemsCalifornia, United States
-
Founder & Solution ArchitectPs3Systems Jun 2021 - PresentIrvine, California, United States
-
Lead Bi ArchitectThryv Jul 2019 - PresentDallas-Fort Worth• Design, develop and maintain data integration (ETL), business intelligence (BI) and Enterprise Information Management (EIM) by rationalizing the data architecture to support reuse.• Developed and Designed Models to Integrate data across multiple acquired company's data warehouse (DW) across the world to report needed KPIs for Quarterly earnings.• Design and implementation of Governance Foundation components as part of Enterprise Information management (EIM), execution of single-source-of-truth for analytics and reporting in the enterprise.• Design and develop processes for all activities related to data cleansing, data quality, and data consolidation, data governance including data management, data quality and master data management.• Key Member in design of Enterprise Data Warehouse (EDW) with Self Service BI capabilities and dashboards.• Research, identify technology products and Communicate IT business requirements and guidelines to vendor partners, Conduct Proof of concept (POC), Evaluate and select vendor tools /Packages/solutions.• Rationalize existing Business Intelligence tools to establish enterprise-wide awareness and training for Business intelligence. -
Lead Bi Data Analyst Yp/Yp Holdings /DexypDexyp Nov 2015 - Jun 2019Dallas-Fort Worth• Designed and developed data modeling standards and best practices that enforced high level of data quality.• Designed, developed and maintained Data Models, data quality and integration strategies supporting data migration post acquisition.• Worked on Building ETL Design, ER Diagram, and Data Modelling to ensure data integrity and accuracy across all systems.• Worked closely with Project Management to prioritize tasks to ensure all the reporting needs to the Senior leadership team and stakeholders are addressed on time.• Developed end to end Data migration process to optimize data collection to ensure Automated Revenue and performance reports are delivered. -
Senior Bi Data AnalystYp, The Real Yellow Pages® Nov 2011 - Oct 2015Glendale, California, United States• Designed, programmed and managed end-to-end processes for data aggregation, ETL processing and analytics from multiple disparate data sources for strategic and operational needs.• Optimized data collection procedures and automated reports on a weekly, monthly, and quarterly basis.• Designed and implemented high quality data accuracy through creation and implementation of data integrity queries.• Successfully interpreted data & presented findings to Executive Management to improve strategies and operations.• Proposed business solutions through analyzing data that led to cost savings and higher quality lead generation that impacted bottom line.• Created reports to inform marketing strategies, leading to low churn of highly paying customers -
Senior Data AnalystMyspace Mar 2008 - Sep 2011Beverly Hills• Interfaced with key business owners / multiple stakeholders and draw out what their requirements are, what they expected to accomplish and interpreted their business needs into technical solutions.• Designed, developed and maintained processes that systematically identified patterns in data and organized, classified, compared and displayed gathered information that furnished the data need for business, engineering, marketing, sales, security abuse, legal and online relationship marketing.• Designed, developed, maintained and modified existing and new standalone stored procedures, functions, new feed loading and data extraction packages that includes but not limited to XML tags to handle XML parsing, extracting and feeding data from and to disparate data sources, sharing encrypted data to and with external 3rd party vendors and clients, identify spam on MySpace website using regular expressions, fuzzy logic and pattern matching and consolidate profile information.• Designed, developed and maintained processes that ensured data consistency, integrity and run data quality checks to provide immediate and permanent solution to make sure that accurate data inputted by users is displayed on the website and populated across all the relevant databases.• Worked on data reporting life cycle to conduct quantitative and qualitative analysis on ad hoc requests and accumulated data that will show hourly, daily, monthly and trending within the requested time window.• Executed and measured success of A/B testing to find the most effective combination of target demographics, subject lines and content to help the online relationship marketing team to engage right and intended audience. -
Programmer AnalystGlobal Care Quest Nov 2006 - Mar 2008Aliseo Viejo• Interacted with the users and stake holders for system study, requirements gathering and analysis and transform their requirements into rounding lists which were used by different departments at different client locations.• Designed, developed, maintained and modified existing and new database objects and data extraction packages and ETL tools that extracted data from different databases and displayed requested aggregated data in specific time frames for physicians and attending to ensure high level of patient care.• Supported and Maintained the Essentris (UCLA) or any central hospital database Interface that fed the data for active patients in GCQ database at different client locations.
-
Programmer Analyst IvUcla Medical Center Mar 2005 - Mar 2008Los Angeles• Interacted with the end users and stake holders for system study, requirements gathering and analysis and transform their requirements into technical solutions.• Designed, developed, maintained and modified existing and new database objects and data extraction packages and ETL tools that fed and extracted data from disparate data sources to push data to and from the front end clinical trial databases across different UCLA medical center departments and provided an aid in creating daily digital notes, rounding lists which were signed by the physicians at different levels and pushed into central data repository at UCLA (PCIMS & CDS) and timely to NIH’s data repository for research purposes and also guaranteed high level of patient care.• Designed, developed, maintained, troubleshoot and modified existing and new front end clinical trial websites that were used by attending and physicians to input and retrieve the specific data that interested them using any nursing station or bed side monitors and can see /plot the hourly, daily, weekly or monthly trends for any interested data points.
Piyush Vijayvargiyaa Skills
Piyush Vijayvargiyaa Education Details
-
Computer Science -
Jawaharlal Institute Of TechnologyComputer Science
Frequently Asked Questions about Piyush Vijayvargiyaa
What company does Piyush Vijayvargiyaa work for?
Piyush Vijayvargiyaa works for Ps3systems
What is Piyush Vijayvargiyaa's role at the current company?
Piyush Vijayvargiyaa's current role is Founder and Solution Architect.
What is Piyush Vijayvargiyaa's email address?
Piyush Vijayvargiyaa's email address is pi****@****ail.com
What is Piyush Vijayvargiyaa's direct phone number?
Piyush Vijayvargiyaa's direct phone number is 888-573*****
What schools did Piyush Vijayvargiyaa attend?
Piyush Vijayvargiyaa attended California State University, Northridge, Jawaharlal Institute Of Technology.
What skills is Piyush Vijayvargiyaa known for?
Piyush Vijayvargiyaa has skills like Databases, Microsoft Sql Server, Business Intelligence, Analytics, Sql, Ssis, Requirements Analysis, Agile Methodologies, Data Warehousing, Data Modeling, Ssrs, Xml.
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