Keep in touch with meI'm using Intch to connect with new people. Use this link to open chat with me via Intch app
Work Background
Hudson TechnologiesBI Data Analyst
Jun. 2023Woodcliff Lake, New Jersey, United States
ParkerLifeOrgBusiness Intelligence Data Warehouse Consultant
Mar. 2021 - Jun. 2023Piscataway, New Jersey, United StatesBusiness Intelligence Data Warehousing consultant responsible for gathering requirements to design and build the foundation of an enterprise solution for a data warehouse and analytics platform with a QAPI, Clinical, and Executive focus in relation to operational standards across all Parker locations and line of business (Skilled, Assisted Living, Sub-Acute, etc.).
MarsBI and Report Data Analyst
Feb. 2018 - Feb. 2021Mount Arlington, NJBI Data Analyst for M&M Mars Retail Group. Responsible for creating interactive dashboards in Tableau and Power BI and updating reports in SAP/Business Objects. Additional tasks include performing data extracts and data mining, maintaining and updating data warehouse in Oracle-PL/SQL. This is in support of M&M Retail stores all over the world as well as sales through digital channels and call centers.
ETL performance enhancement enabled the daily BO reports to come out at 9:30 AM instead of 12:30 PM.
Was instrumental in creating the Daily Business Position report in Tableau and Power BI.
Formulated a notification system in TWS to issue an alert whenever an inbound file to the daily batch process is missing.
UnitedHealth GroupBI Data Analyst
Jun. 2017 - Feb. 2018Hamilton, NJBI Data Analyst for Optum/UHG in partnership with Molina Health in an engagement for the State of New Jersey to build and maintain their data warehouse for claims information. Responsible for building reports, performing data extracts and data mining using SAP/Business Objects and Oracle-PL/SQL. With more than 1M claims processed per week, the project is imperative for them in gaining real-time insights.
CrayolaSystems Analyst
Nov. 2016 - May. 20171100 Church Ln, Easton, PASystems Analyst for the E-Commerce Digital Applications team responsible for data integration between Salesforce Commerce Cloud and Order Management system, corporate SAP ERP, Oracle Business Intelligence and 3rd party web services (Amazon Marketing Service, DOMO, Listrak). • Perform business analysis for E-commerce application programming using agile software development principle.
• Ensure that the sales and inventory data feeds to and from Crayola online, Amazon and eBay sites are received and processed correctly.
• Investigate and resolve any XML data feed errors through three enterprise data warehouse (SQL Server, SAP and Oracle).
• Perform systems analysis function for E-commerce architecture and data flow for migration to new network infrastructure. These included functional documentation to ensure adherence to business requirements as well as test cases/expected results to verify correctness.
• Research and document new 3rd party software that can potentially by used to improve the e-commerce site.
• Monitor Salesforce Commerce Cloud and Order Management system and follow-up with responsible parties (Salesforce, TMP fulfillment center, Crayola warehouse, etc.) for any orders that remain open.
Town Sports InternationalBusiness Intelligence & Data Analyst
Oct. 2014 - Oct. 20165 Penn Plaza, New York, NY 10001Business Data Analyst for the Town Sports International/Strategic Planning Services responsible for providing timely information to business users. Proven aptitude for identifying information gaps, evaluating data from multiple sources, monitoring trends and interpreting events related to particular business issues. • Data Mining responsibilities include providing information to corporate users and club managers to support them in their daily business needs, analyzing monthly club membership sales/cances/usage data and generate analytics to support business forecast projections and trend analysis, and using club membership activity information to provide bonusable metrics at the club management level.
• Data Quality tasks involve ensuring the accuracy of the data that goes into the reports that support corporate and club managers in their day to day activities, identifying and resolving any discrepancies that arise between the reports and data sources, and reviewing and testing any changes to the DTS/ETL processing as coded and developed by consultants.
• Other responsibilities include the maintenance, modification and enhancement of IBM Cognos reports, using IBM SPSS Survey data to prepare Net Percent Ranking report that rates clubs based on their member satisfaction rating, providing ad-hoc reports in Excel with data extracted from data warehouse/data mart for instances when information needed are not available from the standard reports, and creating documentation of day-to-day data and reporting procedure in order provide a smooth hand-over to transitioning staff assignments.
UN/DM/OPPBA/FIOSBusiness Intelligence Analyst
Jan. 2012 - Sep. 2014New York, NYBusiness Intelligence Analyst and senior technical specialist for the United Nations/DM/FIOS tasked with maintaining and upgrading existing Business Intelligence (BI), web and distributed applications including Funds Monitoring Tool (FMT) and the Budget Information System (BIS/PK-BIS). Responsibilities include the maintenance, upgrade and enhancements to existing user system and continuing user support that include resolving problems, advising on the use of new technologies, monitoring transactions to measure performance and continued effectiveness of assigned systems in relation to changes in business processes and new business requirements.
• Subject matter expert for the integration of the Funds Monitoring Tool OLAP and Standard Reports into the new UN ERP (Umoja) and worked closely with the affected Umoja development team to create the new datawarehouse, BI cubes/views and on-demand reports.
• Tasked with setting up the infrastructure for the Web and Application servers for the BIS/PK-BIS project which involved migrating components (HTML, CSS, Javascript, .ASP, .NET, VB6) to Windows 2008/IIS 7 platform.
• Saved the department $200,000.00 by single-handedly upgrading the Funds Monitoring Tool application platform from Cognos 7.3 to Cognos 8.4.
• Prepared and wrote new Standard Operating Procedure (SOP) documentation for the administration, maintenance and support of FMT in the new Cognos 8.4 environment. This included installation reference, technical support documentation as well as user oriented manuals.
UN/DFS/ICTDBusiness Analyst/Technical Writer
May. 2007 - Dec. 2011Greater New York City AreaBusiness Analyst and Technical Writer for the UN/DFS/ICTD. Major responsibilities include analysis and development support for projects utilizing SharePoint, .Net, COGNOS, MS SQL Server and/or Lotus Notes.
• Business Process liaison between business client/user units and technology groups to facilitate project development by identifying client needs, systems analysis, design, development and implementation of new systems as a member of a development team.
• Project Lead for the Funds Monitoring Tool (FMT), a Business Intelligence OLAP system which involves the integration of many transactional systems and program elements; ensuring appropriate data quality, security and access controls with consideration to both local and wide area accessibility.
• Business Analyst and Technical Writer for SharePoint and .Net projects – developing detailed business rules documentation as well as technical and functional specifications, test plans, use cases and dashboard requirements for use in an outsourced development environment.
• Supervise and provide technical guidance for oversea development of SharePoint, .Net and MS SQL DTS/ETL components while keeping abreast of new user requirements and anticipating corrections for any problems that may arise. • Data Integrity Specialist tasked with monitoring, troubleshooting and resolving any data quality issues in FMT involving the Data Warehouse (DW) and Data Mart (DM) in a SQL Server platform as well as the OLAP in the COGNOS environment. This includes formulating and documenting Standard Operating Procedures (SOPs).
Intch is a Professional Networking App for the Future of WorkSee more people like Rafael on Intch
300k+ people
130+ countries
AI matching
Get Intch if you'd like to
1026939 people
17
Application Developer @ Nile27
16
Manager Solution Consulting @ Alkami Technology
16
Program Manager @ DISH Network
168956 people
17
Business Analyst
19
Manager @ Epic Force
15
Data Scientist