Redwood City, California, United States
Experienced data analyst with 8+ years of expertise in E-commerce, Retail, and Supply Chain. Proficient in data analysis, modeling, and validation, using reporting tools like Cognos, Tableau, and MicroStrategy. Skilled in data management, utilizing Kimball's Star Schema methodology for enterprise data warehouses. Expertise in data governance, integration, and master data management. Proficient in ETL processes with tools like DataStage and Informatica, working with various data sources. Hands-on experience in Supply Chain Management modules, B2B and B2C commerce applications, and multi-channel fulfillment. Experienced in requirements gathering, system specifications, and category management. Skilled in VBA functions, SQL, and T-SQL queries. Strong understanding of Business Intelligence and Data Warehousing. Proficient in Tableau and Tableau Server troubleshooting. Familiarity with web application development and content management systems. Adept at converting legacy reports and proficient in SQL and relational database management. Furthermore, I have a strong foundation in databases like MySQL, Microsoft SQL Server, Oracle, and Teradata, and I am familiar with web technologies such as HTML5, CSS, JavaScript, and XML. Operating systems including Windows and LINUX are well within my expertise.
• Execute test cases in HP ALM, mapping them to requirements using requirements coverage, and maintain test cases and reports in Quality Center. • Analyze B2B customer data to identify cross-selling and upselling opportunities, leading to increased revenue and customer loyalty. • Conduct market segmentation analysis to identify potential B2B customer segments with high growth potential, enabling targeted marketing strategies. • Apply multinomial logistic regression, random forest, decision tree, and support vector machines (SVM) to classify whether packages would be delivered on time for new routes. • Perform customer segmentation analysis in the B2C market to identify different customer profiles and personalize marketing campaigns. • Analyze B2C customer journey data, including website interactions and purchase behavior, to identify opportunities for enhancing the customer experience and increasing conversion rates. • Utilize social media analytics to understand B2C customer sentiment and preferences, driving targeted marketing strategies and brand positioning. • Transform reports into interactive business intelligence dashboards for data visualization purposes using I Dashboards software. • Extract and analyze data from Oracle databases using SQL queries to retrieve relevant information for analysis and reporting. • Perform extraction, transformation, and loading (ETL) using Informatica PowerCenter. • Analyze the Payment Card Industry Data Security Standard (PCI DSS) to ensure compliance with minimum security levels for storing, processing, and transmitting cardholder data. • Integrate and enhance existing web-based e-commerce platforms using WebSphere Commerce to provide web analytics, product catalog, targeting, and profiling capabilities. • Assist in data compilation, mining, and analysis to evaluate given data. • Create reports and presentations to communicate findings to stakeholders within the company.•
• Integrate and enhance existing web-based e-commerce platforms using WebSphere Commerce to provide web analytics, product catalog, targeting, and profiling capabilities. • Utilize statistical software tools like R, Python, and SAS for data analysis and model development. • Analyze return and cancellation data to identify root causes, reduce return rates, and improve customer satisfaction. • Develop data visualizations, charts, and dashboards to present insights and trends, supporting informed decision-making and enhancing supply chain performance. • Monitor key performance indicators (KPIs) related to inventory, order fulfillment, and production efficiency using APO, Kinesis, and IBP, generating regular reports and performance dashboards. • Analyze data to identify patterns and trends in warehouse operations and make recommendations to improve efficiency and reduce costs. Analyze shipping costs and identify ways to optimize expenses. • Integrate middleware APIs with front-end clients like QuikView, Retail .Net platform, Magenta UI, and back-end systems like Identity Access Management, Customer Hub, and Documentum. • Stay updated with industry trends, consumer preferences, and new merchandising tools or technologies to provide recommendations on optimizing the merchandising strategy. • Follow the SCRUM Project Management Agile Methodology throughout the SDLC, creating full life-cycle documentation from product requirements to functional specifications, including BRDs. • Involve in physical modeling, logical modeling, relational modeling, dimensional modeling (star schema, snowflake schema), entity-relationship diagrams (ERD), and OLAP/OLTP. • Utilize data warehouse architecture and design concepts such as star or snowflake schema, fact and dimensional tables, and data flow diagrams.
• Extract and manipulate specific datasets from the operational database using PL/SQL queries for data cleansing and new feed processing. • Collaborate with the data warehouse/ETL and reporting team to review data models and reporting requirements for Cognos Reports. Conduct maturity assessment of data governance and use Collibra for data governance. •Create matrix reports, drill-down reports, drill-through reports, sub-reports, and chart reports using SQL Server Reporting Services (SSRS). • Develop ETL processes for extracting data from OLTP systems to the target market data warehouse using complex SQL queries. • Utilize SQL queries to perform data transformations, aggregations, and joins to derive meaningful insights from complex datasets. • Create and maintain reports, dashboards, and visualizations using Oracle Business Intelligence tools or other reporting platforms. • Write Scala code to load source data from Amazon S3, run SQL queries, and save results to Elastic Search. • Work with users to convert folder structures into metadata-based views. • Create dynamic and interactive dashboards for root cause analysis, KPI analysis, and trend analysis, reducing man-hours. • Generate matrix reports, drill-down reports, drill-through reports, sub-reports, and chart reports using SQL Server Reporting Services (SSRS). • Create QA plans and test plans, participate in daily Scrum meetings, write scripts, execute test cases, and debug issues. Coordinate offshore team activities. • Develop ETL processes for extracting data from OLTP systems to the target market data warehouse using complex SQL queries.
• Develop and implement logical and physical database models using the Data Vault Methodology and ER diagrams (Physical and Logical using Erwin). Identify Facts and Dimensions based on business requirements and translate them into database objects. • Implement metadata standards, data governance, stewardship, master data management, ETL processes, operational data stores (ODS), data warehouses, data marts, and other data-related systems. • Develop and optimize complex SQL queries to support data analysis, reporting, and ETL processes. Utilize Oracle SQL queries to access data stored in the data warehouse for analysis and ensure the proper implementation of the database. • Utilize IBM Cognos Business Intelligence and customized SAP Crystal Reports tool for data visualization and generate various report layouts to meet stakeholders' needs. • Develop mappings using various transformations to meet business partners' requirements. Implement ETL processes for enterprise migration systems. • Analyze the conversion of claims and members files from legacy systems into Facets and downstream systems. Perform Facets data analysis, data mapping, and write SQL queries for documentation purposes. Conduct functional and user interface testing. • Track and manage issues using JIRA, ensuring that defects are properly located, fixed, and documented. • Brainstorm new solutions both within and outside the project scope, and maintain documentation such as requirement analysis reports, preliminary design specifications, detailed design specifications, workflow specifications, and future operational procedures. • Utilize Query Analyzer and Execution Plan to optimize SQL queries and improve database performance.