| Candidate Information | | Title | Data Analysis Power Bi | | Target Location | US-NC-Charlotte |
| | 20,000+ Fresh Resumes Monthly | |
|
|
| |
Click here or scroll down to respond to this candidate Over 10 years of expertise in data analysis, warehousing, and modeling across multiple platforms within the banking sector. Highly skilled in statistical analysis, data visualization, and management, leveraging tools such as SQL, Python, R, Power BI, and Tableau. Extensive experience with ETL processes, data quality assurance, governance, and business intelligence tools including Business Objects and Informatica. Proficient in identifying trends and patterns to support strategic business decisions. Expertise in implementing machine learning algorithms for predictive modeling and pattern recognition. Experienced with cloud services such as AWS and big data technologies like Hadoop and Spark. Competent in data profiling, cleansing, transformation, integration, and metadata management. Proven ability to generate actionable insights, enhance processes, and drive business growth through comprehensive data analysis and visualization. Hands-on experience with database systems including SQL Server, Oracle, MySQL, PostgreSQL, and Teradata, as well as data visualization tools like Splunk, Power BI, and matplotlib. Strong foundation in banking and financial software, with deep knowledge of SWIFT messaging standards and payment processing systems. Proficient in the full life cycle of Master Data Management (MDM) development, encompassing data analysis, database design, data mapping, and batch data loading. Adept at developing and deploying efficient data pipelines and ETL workflows. Skilled in gathering, organizing, and analyzing data from diverse sources to ensure accuracy and reliability. Expertise in feature engineering and selection to boost model performance and reduce overfitting. Experienced in designing and conducting A/B tests to assess strategy effectiveness. Extensive IT background in data analysis, ETL development, data modeling, and project management. Capable of performing exploratory data analysis (EDA) to detect patterns, outliers, and trends. Proficient in communicating complex findings to stakeholders through effective data storytelling and visualization techniques. In-depth understanding of agile development methodologies and project management practices. Programming Languages: Python, PL/SQL, SQL, HTML, R, C++, C, JavaScript, CSS Reporting Tools: BO, OBIEE.ETL Tools: Informatica.Big-Data Frameworks: Hadoop, Spark FrameworkDatabases: Oracle, SQL, MySQL, DB2, MongoDB, Teradata, MS access Version Control: Git, GitHub, SVN, CVSOperating Systems: UNIX, Linux, WindowsMethodologies: SDLC, JAD Sessions, Ralph Kimball Methodologies Bachateros in computer scienceKoneru Lakshmaiah Education Foundation (KLEF), Vaddeswaram, India Relevant Coursework: Data Warehousing & Mining, Data Science, Data Visualization Using Tableau, Algorithm Design and Analysis, Performance Engineering, User Interface Design, Artificial Intelligence, Network Security, Entrepreneurship Project.NCDHHS, Raleigh, NC Sep 2022 to PresentSr Data AnalystResponsibilities: Conducted data analysis and profiling on source systems, including Oracle and Teradata, using complex SQL. Performed data quality analysis and created source-to-target data mapping documents for SSIS bridge development. Served as the primary contact for client stakeholders, supporting onshore and offshore agile teams, and developing Agile backlog items. Extracted data from databases with SAS/Access and SAS SQL procedures, creating comprehensive SAS datasets. Generated advanced Excel reports, including charts, graphs, pivot tables, and PowerPoint presentations, and developed data models in Power BI. Designed and implemented Power BI and Tableau dashboards, creating filters, custom visualizations, and analytical reports. Demonstrated strong Excel skills, including pivot tables, VLOOKUP, and conditional formatting. Developed use cases with UML and MS Visio, creating business flow diagrams and defining workflows. Created Tableau calculations and ETL mapping specifications based on business requirements. Conducted data analysis, migration, preparation, graphical presentation, statistical analysis, and reporting. Conducted data analysis to identify data sets, source data, metadata, definitions, formats, validation, cleansing, verification, and mismatches. Analyzed bank data and business terms for quality and integrity. Implemented MDM processes, delivering MDM roadmap and architecture. Delivered solutions for data governance, analysis, metadata, and ETL using Informatica. Troubleshot ETL mappings and addressed performance tuning and production issues. Performed root cause analysis on data processes and assisted in defining source-to-target mappings. Created profiles using Informatica IDE and IDQ, aiding business analysts in strategy definition. Generated portfolio and P&L reports by conducting risk analysis based on client investment objectives. Designed and implemented dashboards using Power BI tools. Worked on MDM data models and WebSphere Process Server integration. Environment: Tableau, SQL, Power BI, Excel, Access, R Studio, Python, Informatica (IDE, IDQ, ETL), Power BI, SQL Server, Oracle, Tableau, WebSphere Process Server, UNIX (for server performance analysis) State of MD, Baltimore, MD May 2020 to Aug 2022Data AnalystResponsibilities: Managed and optimized relational databases for critical business operations. Developed predictive models for customer retention, reducing churn rate by 10%. Conducted exploratory data analysis to inform data-driven decision-making. Implemented machine learning algorithms for personalized customer recommendations, increasing upsell opportunities by 15%. Engineered scalable data pipelines using Apache Spark and Hadoop. Utilized clustering techniques for targeted marketing campaigns, boosting customer conversion rates by 7%. Created time series forecasting models for network capacity planning. Identified and resolved performance bottlenecks in SQL and NoSQL databases. Implemented recommendation systems, increasing user engagement by 25%. Developed Splunk dashboards for real-time tracking of business metrics. Analyzed network infrastructure data to enhance performance and reduce downtime. Built chatbots using natural language processing, reducing support costs by 25%. Collaborated with external institutions to apply advanced techniques like deep learning. Leveraged Splunk for data visualization and reporting. Gathered requirements and feedback to enhance Regulatory Reporting processes. Participated in agile project management methodologies. Maintained compliance with industry regulations and data security standards. Created filters in Power BI as per requirements. Processed various SWIFT messages for payments. Participated in data architecture design and developed a central data repository for Syndicated Loans. Designed STAR schemas for detailed and plan data marts. Conducted count validation, dimensional analysis, statistical analysis, and data quality validation during data migration. Ensured compliance with KYC and BSA standards for account opening documents. Implemented MDM concepts in an agile environment. Developed a roadmap for MDM solutions post-mergers and acquisitions. Ensured data consistency across diverse sources, including flat files, XML, and SQL databases. Environment: SQL, NoSQL, Python, R, Apache Spark, Hadoop, Python, Tableau, SQL, Power BI, EXCEL, VBA, Access, SharePoint, JiraFarmers Insurance, New York NY Feb 2019 to Apr 2020 Data AnalystResponsibilities: Utilized Informatica Data Explorer (IDE) & Informatica Data Quality (IDQ) for data profiling and rule validation. Developed data flow diagrams for the Enterprise Data Warehouse (EDW) and created visualizations in Power BI. Designed dashboards and ad-hoc reports using MS Power BI and SSRS for senior management. Built SSIS Packages for data extraction, transformation, and loading (ETL) processes. Implemented Master Data Management (MDM) processes to ensure data integrity. Provided maintenance and bug fixes for Power BI Reports. Developed data warehouse models using Star schema. Collaborated with teams to align repository objects with business requirements. Managed requirements for interfaces, conversions, enhancements, and reports. Conducted SQL queries for ETL process validation and data analysis. Documented logical, physical, relational, and dimensional data models. Created Data Flow Diagrams and Process Flow Diagrams for various load components. Wrote and executed test cases for Enterprise Data Warehousing (EDW). Conducted performance tuning and loading data for fast report access. Produced functional decomposition and logical models for enterprise data. Created data mapping specifications and executed system test plans. Utilized SAS ODS for creating output.Environment: Power BI, SQL (Oracle, TSQL), Data Modeling Tools, SAS ODS. Tek Collab, Hyderabad, India Sep 2014 to May 2018Data AnalystResponsibilities: Converted Visual Basic Application to Python, MSQL. Employed advanced campaign management techniques and centralized dashboards to analyze key digital marketing and user engagement metrics across multiple banking websites. Led conversion optimization initiatives for major clients like Citi and Amex, resulting in significant improvements in checkout funnel flow and submission rates. Utilized predictive analytics to identify common user journeys leading to purchases and implemented website restructuring strategies to increase overall conversion rates. Developed a sophisticated multithreaded crawler to extract text from thousands of web pages for the ALPS data model, which predicts Google's organic search performance using regression models. Orchestrated end-to-end conversion optimization activities, including planning A/B tests, and analyzing results, resulting in a notable 20% improvement in website page performance. Achieved a remarkable 30% increase in conversion rates for the Amex travel insurance product through strategic website flow modifications guided by predictive analytics. Successfully resolved a traffic allocation issue, leading to a significant revenue increase of over $400K for the company. Collaborated on the development of an SEO Optimization tool, ALPS, aimed at predicting Google's search algorithm and improving search engine rankings for stakeholders. Leveraged tools such as Adobe Analytics, Google Analytics, Tableau, and Google AdWords to gather insights and optimize digital marketing campaigns. Contributed to the creation and enhancement of a robust SEO Optimization tool, ALPS, as part of a dedicated team effort. Utilized Visual Website Optimizer and SEM Campaign Manager to refine marketing strategies and enhance online visibility for clients.Environment: Adobe Analytics, Google Analytics, Tableau, Google AdWords, Google Search Console, Visual Website Optimizer, SEO Optimization, SEM Campaign Manager. |
