| | | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate295 Durham Ave, Suite 207,South Plainfield, NJ Street Address PHONE NUMBER AVAILABLE eFax: PHONE NUMBER AVAILABLE www.ssgctechnologies.comVSPHONE NUMBER AVAILABLE EMAIL AVAILABLEPROFESSIONAL SUMMARYExperienced and autonomous Business Intelligence Analyst with 9+ years of industry experience. Proficient in requirement gathering, Documentation, Data Analysis, testing, client interaction, peer coordination. Played roles of Technical Developer, excelling in leveraging Tableau and other BI tools to streamline complex data and create impactful analytics narratives. My expertise in SQL and ETL/ELT, along with proficiency in data warehousing concepts, ensures precise data analysis for efficient BI solutions.Proven track record in crafting advanced Business Intelligence (BI) solutions facilitating data-driven decision-making processes across diverse industries, including finance, energy, and ride-hailing sectors. Ability to thrive in fast-paced and constantly changing development environments. Programming: SQL, Python (Statistical Modeling) BI Tools: Tableau suite, Power BI, SAP BusinessObjects, Advanced Excel (including complex financial models and data analysis using pivot tables, data validation, and macros) Databases: Experience with MSSQL, MySQL, Oracle, OLAP cube database Data preparation: Tableau prep, Alteryx Program Management: Requirements Management, SDLC, Change Management, Process- Mapping, GAP Analysis, JIRA Documentation Data Skills: Data Modelling, Data Architecture, Cleaning, Mining, ETL, Warehousing, Web Scraping with Python Data engineering: Database Development and Tuning, ETl Design and Development Data warehousing: Dimensional/Star/Snowflake MDM: Master Data Management of Customers, Trade management workflows, Products, Geographies, Promotions, and Time Analytics: Descriptive, Predictive, Forecasting, Statistical Analysis, Financial models, Trend identification, and root cause analysis, Business Insights, Visualization, Dashboard development, Data stories and Process ImprovementTECHNICAL SKILLS Data Warehouse ETL Data Modelling Tools Oracle Business Intelligence (OBI) Microsoft SQL Server DB2 Teradata Python PeopleSoft Oracle DB Power BI Tableau suite - Tableau Desktop, Tableau Server, Tableau Prep, SAP BO) ERP systems (PeopleSoft, Oracle ERP, Workday)295 Durham Ave, Suite 207,South Plainfield, NJ 07080 PHONE NUMBER AVAILABLE eFax: PHONE NUMBER AVAILABLE www.ssgctechnologies.comWORK EXPERIENCEUSAA San Antonio, TX June 2024 PresentData Analytics - Senior Data AnalystRoles and Responsibilities: Develop and maintain interactive Tableau dashboards, enabling the Insight Delivery team to visualize complex data patterns and trends for strategic decision-making. Write and optimize complex SQL queries for efficient data extraction and manipulation, ensuring high-performance database operations and reliable data access for the Insight Delivery team. Utilize SAS for advanced statistical modeling and analysis, identifying critical business trends and anomalies to inform strategic decisions in the Chief Strategy Officer division. Manage Snowflake data warehousing solutions, ensuring seamless integration and storage of large datasets. Implement ETL processes for accurate and timely data availability to the Insight Delivery team. Develop automated data pipelines and workflows using scripting languages like Python, reducing manual effort and improving the efficiency of data processing for the Insight Delivery team. Set up and manage job schedules for regular ETL processes. Monitor and troubleshoot job executions, ensuring the timely and reliable availability of data for strategic analysis. Identify, diagnose, and resolve data quality issues, Client reporting implementing validation and cleansing processes to maintain accurate, reliable datasets for the division. Conduct training sessions on data tools and best practices. Mentor junior analysts in the Insight Delivery team, fostering skill development and knowledge sharing within the team. Collaborate with business units to understand data needs, providing tailored analytical solutions. Communicate complex data insights clearly to non-technical stakeholders in the Chief Strategy Officer division. Propose and implement innovative data analysis solutions to enhance data capabilities and Data mapping drive business value for the Chief Strategy Officer division. Technical skills include Tableau, SAS, Snowflake. Programming languages include SQL and Python. SSGC Technologies, LLC San Jose, CA Feb 2024 May 2024 Revenue Operations - Senior Business Intelligence Analyst Roles and Responsibilities: Conducted comprehensive assessments of data warehouse and BI life cycle processes, including requirements gathering, logical design, ETL implementation, BI design, performance tuning, data quality, release/change management, Client Reporting and defect resolution. Analyzed and reviewed business and IT information reporting and analytical requirements across various domains including Customer Relationship, Data Mapping, Finance, Sales, Product Performance, Inventory, Marketing, and Operations. Designed and documented logical and physical data models using Oracle Data Modeler and Erwin, including normalized 3NF transactional and denormalized star-schema dimensional models, maintaining metadata and data lineage.295 Durham Ave, Suite 207,South Plainfield, NJ 07080 PHONE NUMBER AVAILABLE eFax: PHONE NUMBER AVAILABLE www.ssgctechnologies.com Developed scripts for creating necessary tables (master, reference, transaction, staging, facts, dimensions, lookups, aggregates) with appropriate constraints and designed indexing and aggregate strategies. Designed, documented, and implemented ETL processes using Oracle PL/SQL, Netezza SQL, Teradata BTEQ, Informatica, Talend, and DataStage, Data Mapping, along with reporting view layers and BI tool schemas. Led, mentored, and reviewed the work of data modelers, ETL developers, and BI developers, and integrated warehouse tables into the metadata repository using MicroStrategy Architect. Achieved a 100% on-time completion rate for all tasks, provided process improvement feedback resulting in a 10% increase in efficiency, and resolved healthcare data issues, specifically with Claims and Encounters data. Formulated and documented best practices and standards to enhance current processes, ensuring repeatable success in design and implementation. Credit Suisse Mumbai, India Oct 2018 Dec 2022Wealth Management - Senior Data AnalystRoles and Responsibilities: Examples of Dashboards Deployed and Supported: Monthly Key Financials Outlook, Net New Assets Daily and Weekly Update Dashboard Subscription to Email, Transactional Run Rate Daily Refresh, Relationship Manager (RM) Scorecards, Market-wise Financial Outlook to Market Heads, Product Trends Dashboard. Transition to BI Dashboards: Revamped APAC private banking financial reporting from static Excel to interactive Tableau dashboards hosted on Tableau Server, cutting monthly reporting time by 200 hours and accelerating report access for senior management, including Business heads and Market Heads. Empowered business leaders with comprehensive insights through easily accessible client-facing reports. Tableau Deployment Leadership: Directed Tableau implementation, overseeing setup, developing cutting-edge visualizations, dashboard development, user access, and project configuration. Enabled stakeholders to easily interact with complex datasets and derive actionable insights. Acted as a key liaison between senior management, finance, and end users for cohesive operations. Enhanced RM Ranking Methodology: Conducted comprehensive analysis of client, market, and performance data to enhance Relationship Manager (RM) ranking methodology, yielding a 15% increase in Net New Assets (NNA). Utilized Python (Pandas, NumPy), Excel (Solver, Data Analysis ToolPak), and financial modeling techniques (DCF, scenario analysis) to identify opportunities, insights, and anomalies. Client Attrition Model Development: Developed a client attrition model using logistic regression resulting in improving forecasting accuracy by 25% through a thorough analysis of historical data and engagement metrics in Python with scikit-learn and stats models. Engineered APAC Private Banking weekly P&L forecast model: Reducing prep time from 15 to 2 hours through advanced Python-based data analysis. Integrated prorated monthly forecasts and applied volatility adjustments for enhanced reliability. Verified accuracy with monthly MAE evaluations.295 Durham Ave, Suite 207,South Plainfield, NJ 07080 PHONE NUMBER AVAILABLE eFax: PHONE NUMBER AVAILABLE www.ssgctechnologies.com Budget Implementation: Implemented top-down budgeting for APAC and markets using advanced SQL. Aggregated data and applied growth rates and allocations via SQL calculations. Integrated currency exchange rates, adjusting for inflation, significantly improving the budget allocation process. Data Reconciliation and ETL Optimization: Improved ID mapping accuracy by 20% and streamlined workflows with advanced reconciliation algorithms. Implemented data profiling, established validation mechanisms, and integrated data cleansing to enhance data warehouse using Data Build Tool (DBT).Capgemini Mumbai, India Oct 2015 Aug 2018Business Intelligence EngineerRoles & Responsibilities: Implemented a two-phase initiative to engineer intuitive Tableau dashboards for tracking radioactive equipment, integrating internal dimensional, equipment maintenance, and time series data into an Oracle database. Resulted in a 40% increase in production quality and annual savings of $500,000 through enhanced insights into equipment failures. Managed and maintained Tableau Server, including user access, permissions, and security settings for 2000+ users across 10 projects, ensuring optimal performance, availability of dashboards, and maintaining data integrity and confidentiality. Implemented indexing and query optimization for Oracle databases to enhance query performance. Achieved a 50% increase in data processing speed, resulting in improved performance and reduced dashboard loading time with live connection to Tableau dashboards. Worked extensively with member, subscription, medical claim, and pharmacy claim data, including procedure, diagnosis, drug, and lab information; reviewed user reporting and analysis requirements and specifications. Architect, designed, developed, implemented, and maintained conceptual, logical, and physical data models for BI/DW environments, adhering to enterprise standards and best practices; developed and maintained data dictionaries, ETL high-level designs, and source-to- target mapping specifications. Designed, developed, and tested ETL mappings and packages using Microsoft SSIS, Informatica 8, and Oracle Warehouse Builder (OWB); developed Oracle PL/SQL scripts for tables, indexes, triggers, and stored procedures; integrated warehouse tables into metadata repository catalogs using MicroStrategy Architect. EDUCATIONBachelor of Technology Amity University, India Jun 2011 May 2015 Computer Science EngineeringAcademic projects: Led Techno Trendz Website (University internal website) Data Analysis utilizing MSSQL database, Python for data modeling, and Excel for reporting. Revealed high user satisfaction, predicted 15% event registration growth, guiding strategic decisions. 295 Durham Ave, Suite 207,South Plainfield, NJ 07080 PHONE NUMBER AVAILABLE eFax: PHONE NUMBER AVAILABLE www.ssgctechnologies.com Udemy Coursework: Business Analytics Foundations: Predictive, Prescriptive, and Experimental Analytics.AWARDS & RECOGNITION Received recognition through 12 RAVE (Recognizing and Valuing Excellence) awards from peers at Credit Suisse for consistently surpassing expectations and embodying the organization's six core values. Acknowledged with the "Rising Star Award" in Q4 of 2016 at Capgemini, recognizing outstanding performance and significant contributions to the Insights & Data Domain. Granted the "STAR Award (Special Thanks and Recognition)" in Q3 of 2017 at Capgemini for exceptional performance and enduring contributions in the Insights & Data Domain. |
