Lead Data Analyst Resume
SUMMARY
- Around 9+ years of experience as a Cross functional Data Analytics expertise in quantitative analytics, real - time optimization, processing/automating processes, discovering trends/anomalies and building scalable solutions
- Provide thought leadership and strategic direction for where Decision science can solve challenging problems across the organization - determining where to focus, how to prioritize, where to make investment, marketing trends
- Expertise in Statistical data analysis, data profiling, data designing and data management for large and complex data sets.
- Experienced in Gathering, Cleaning, and Visualizing Data
- Well conversant writing Sub Queries, Stored Procedures, Triggers, and Functions on SQL database.
- Excellent understanding of Business / Market Intelligence, Insurance segments, Sales Analytics, Databases, Data Warehousing, Data Mapping, Data Modeling, Data Migration and Data Integration.
- Performed data analysis, statistical analysis, predictive analysis and generated reports listings and graphs using SAS, Python, Excel, and Power BI.
- Experience in Hadoop, Cloud platforms, performing OLAP tools and creating Reports.
- Expertise at designing tables in Hive, MySQL and processing data like importing and exporting of databases to the HDFS.
- Provide scaled support to resolve user issues, identify user trends, and work with cross- functional partners to resolve issues
- Experience in managing and reviewing Hadoop Log files also developed the Pig UDF's and Hive UDF's to pre-process the data for analysis.
- Experience in Business Intelligence, Data Modeling, Data Warehousing concepts, OLAP, ETL tools and Analytics.
- Expertise in creating filters, quick filters, data source filters, global filters, context filters, user filters and creating Dashboards for key Performance Indicators.
- Worked with python libraries like Matplotlib, NumPy, SciPy and Pandas for data analysis. Connected Python with Hadoop to perform Hive and Spark to perform data analysis.
- Developed PowerBI from multiple data sources using Data Blending.
- Proficient in Data Visualization techniques - creating reports and dashboards
- Highly experienced in gathering, understanding, and analysis of business requirements, design, execution, time and cost estimates.
- Experience on Python for statistical computing. Also experience with Excel and SAS.
- Excellent team player with ability to work independently along with strong analytical and communication skills.
TECHNICAL SKILLS
Programming: SAS, Python-|NumPy, Pandas, Scikit-Learn, Matplotlib.
Database Management: Oracle - SQL and NoSQL, Microsoft SQL Server, MySQL.
Tools: Omniture, Power BI, Tableau, Linux, QlikView, MS Excel, Jupiter, RStudio, Putty, Jira, Control-M
Cloud Platforms: AWS - |Lambda| MS Azure, Big Query
Big Data: Apache Spark, Hadoop MapReduce, Hive, Impala, Pig
Analytics: Data Cleansing, Data Mining, Data Wrangling, Data Analysis, EDA, PCA, Linear Algebra, Biostatistics, Calculus Statistical Modelling Central Limit Theorem, Regression, Classification, A/B Testing, Dimension Reduction, Segmentation
Machine Learning: Decision Tree, Random Forest, Reg. (Linear & Logistic), Naive Bayes, KNN
PROFESSIONAL EXPERIENCE
Confidential
Lead Data Analyst
Responsibilities:
- Designing huge datasets for the marketing and predictive modeling
- Creating and modifying SAS, python and SQL queries for pulling data from different Data sources for aggregate data and automate
- Utilized analytical applications to identify trends and relationships between different pieces of data, draw appropriate conclusions and translate analytical findings into risk management and marketing strategies that drive value
- Collating data sources and building databases which can be accessed by end-users according to their intent by SQL
- Pricing the customers based on the credit bureau and the other data points
- Implementing the change requests as a part of Business updates
Environment: SAS EG, Python 3X, NumPy, Pandas, Matplotlib, Seaborn, Scikit-Learn, Putty, Teradata and Git
Confidential
Lead Data Analyst
Responsibilities:
- Collaborated with multiple business stakeholders, data owners, Cloud teams Azure and AWS Architects
- Collaborated with developers and technical leads on detailed data designs and specifications to ensure alignment with project goals and long-term data strategy.
- Designed and built a framework to orchestrate data pipelines and Machine Learning models
- Performed both advanced qualitative and quantitative analysis of high-volume databases as a means to identify developing trends, patterns, and correlations that could improve overall business performance by Python
- Ensured data management best practices are being followed when developing new data assets.
- Managed technical aspects of data model maintenance, migration, and deployments.
- Designed, developed, and implemented, data warehouse architectures using logical and physical data models.
- Root cause analysis, Contact reduction and Website Transformations (OMNITURE)
- Incident Management, Risk and Business Controls
Environment: SAS, R, Python, Hadoop, Hive, Azure, Oracle, SQL server, Teradata
Confidential
Analyst
Responsibilities:
- Reporting and implementing BI dashboards
- Gathering requirement and updating the user stories
- Team Engagement and offsite planning
- Evaluating Risk and cost saving opportunities
Environment: Internal reporting tools
Confidential
Analyst
Responsibilities:
- Requirement gathering and writing user stories
- Handling RFP and RFI
- Client and stake holder management
- Estimation of cost and time lines of the project
- Project management and project delivery
- Lead generation and pre- sales functional consulting
Environment: Internal tools
