Resume

Sign in

Data Sql Server

Location:
Hyderabad, Telangana, India
Posted:
January 29, 2018

Contact this candidate

Omur S

Sr. Data Analyst/Analytics

Email- ac38vo@r.postjobfree.com

Phone – 732-***-**** x 9088

PROFESSIONAL SUMMARY

Results oriented consultant with 8 years of professional experience in Data Science, Data Analytics, and Business Intelligence. Expertise in applying data science frameworks in sales, marketing, finance, operations domains and development of statistical and machine learning models in Python, R, Java, SQL. Strong communication skills in collaboration with business partners throughout the software development lifecycle in agile and waterfall methodologies. Flexible thinker and team player focused on delivering results driven solutions and continuous improvement throughout organization.

Collaborate with sales, business operations and product management to develop business analytics solutions for various business units.

Experience in extracting raw data from structured and unstructured data sources, transforming it using Python, R, SQL, regular expressions, and loading into an enterprise data warehouse (Extract-Transform-Load).

Furnish insights, analytics, and business intelligence needed to guide decisions.

Experience training supervised and unsupervised machine learning models: Clustering (k-means, c-means), Regression (linear, multivariate, logistic), Classifiers (decision trees, random forests, Naïve Bayes, support vector machines), principal components analysis (PCA), and survival analysis.

Experience evaluating machine learning models (ROC, AUC, confusion matrix) and hyperparameters tuning.

Wide array of experiences in interpreting and analyzing data using statistical techniques and systems.

Strong numerical, interpretative, analytical and diagnostic skills.

Excellent knowledge in creating Databases, Schemas, Stored Procedures, Triggers, Views, User defined data types, functions, cursors and indices.

Hands-on experience in data design and analysis using Machine Learning frameworks and algorithms.

Experience in Big Data Analytics, Design, Development, Testing, Maintenance and Documenting of various Web- Applications, Client/Server, and Distributed Applications.

In depth understanding/knowledge of Hadoop Architecture and various components such as HDFS, HIVE MapReduce and YARN concepts.

Experienced in performing in memory data processing for batch, real time, and advanced analytic using Apache Spark (Spark SQL &Spark-Shell).

Extensive experience in in-depth data analysis on different databases and structures. Strong knowledge in writing advanced SQL queries, sub-queries, and joins.

Skilled in providing analytic support including data importing, data wrangling and data visualization.

Expert in developing advanced models in MS Excel with proficiency in Vlookups, Pivot Tables and of VBA Macros.

Extensive knowledge of financial accounting, investment banking, fixed income products and financial system.

Experienced in developing test plans, cases, scenarios and strategies as per the business requirements to match the functional requirements and UML diagrams.

Strong understanding of CRM databases/systems, to query and analyze customer data. Experience with Google Analytics, Tableau, MS Excel and SQL Server Reporting Services (SSRS).

Expert in Visualizing, Conceptualizing, Specifying and Documenting the Business Architecture artifacts and Use case diagrams using MS Visio.

Experience in designing stunning visualizations using Tableau software, D3.js and publishing and presenting dashboards on web and desktop platforms.

Strong experience in Software Development Life Cycle (SDLC) including Requirements, Specifications Analysis/Design and Testing as per the Software Development Life Cycle.

Excellent communication, team oriented and interpersonal skills, Quick Learner, Exceptional Team Player and I have the ability to work independently as well.

TECHNICAL SKILLS

Databases

Relational Databases - Oracle 11g, SQL Server 2016, MySQL, Postgres, Amazon RedShift, Amazon SimpleDB.

Big Data

MongoDB, Cassandra, Neo4j, Hadoop, Hive, Spark.

Programming

Python, R, Java, SQL, PHP, HTML5, CSS3, JavaScript, jQuery, Angular.js.

Operating Systems

Linux, Windows Server, Mac OS.

Business Intelligence Tools

Tableau, QlikView, MS Power BI, Google Refine, MS Excel – Solver, VBA, SAS.

Statistics

Mean, Median, Mode, Probability Distributions, Standard Deviation, Variance, Hypothesis Testing, Z-test, T-test, Random sampling.

Machine Learning

Feature Selection, Supervised and Unsupervised Learning, Correlation Analysis, Linear Regression, Multivariate Regression, Logistics Regression, Cluster analysis, Classification, Decision Tree, Support Vector Machines (SVM), Naive Bayes, K- Nearest Neighbors (KNN), Clustering, K-Means Clustering, Random Forest, Principal Component Analysis, Factor Analysis, Correlation Matrix.

Deep Learning

Deep Neural Networks, Convolutional Neural Networks, Recurrent Neural Networks, Long Short-term Memory Networks, Optical Character Recognition, Pandas, NumPy, Scikit-learn, Keras, TensorFlow, Theano.

Development tool

Eclipse, IDEA, NetBeans, Visual Studio, PyCharm, Jupyter notebook, Spyder, R-studio, Anaconda, Git, subversion.

PROFESSIONAL EXPERIENCE

North Raleigh Endodontics Raleigh, NC

Role: Data Analyst/Analytics Jul’17 – Present

North Raleigh Endodontics is the leading dental office in the Raleigh-Durham area. The project consisted of three stages: 1) Initial P&L analysis and providing recommendations to improve profitability, 2) Conducting data analytics in customer database, and identifying customer lifetime value, assessing overhead efficiency, and improving profitability, 3) Developing a Business Intelligence dashboard for monitoring KPIs.

Responsibilities:

•Analyzed customer database and developed predictive linear regression model in Python with Scikit-learn to estimate customer lifetime value and expected annual revenue per referring doctor. Identified leaks in referrals and provided recommendations to increase referral patients from general dentists.

•Developed Extract-Transform-Load program in Python to extract patient data from different data sources (MS SQL Server, Hadoop), completed denormalization and aggregation of data for subsequent statistical analysis.

•Developed BI dashboard in MicroStrategy for real-time KPI monitoring: profitability, utilization rate, sales leaks, referral leaks, pricing leaks, overhead efficiency rate, and others.

•Applied linear regression in Python to understand the relationship between different attributes of dataset and causal relationship between them, applied Ridge, Lasso regressions with L1 regularization and identified statistically significant factors influencing a customer value.

•Implemented and customized website analytics and applied SEO and SMM optimization tools based on business needs, specifically Google Analytics.

•Initiated Hadoop adoption project, prepared the project roadmap, timeline, and implemented Hadoop storage solution for the patients database.

•Developed Simple Map/Reduce jobs using Hive.

•Created Hive tables, transferred data to Hive from existing databases, and queried data using HiveQL.

•Involved in running Hadoop jobs for processing millions of records of raw data.

•Handled importing of data from various data sources, performed transformations using Hive, MapReduce, loaded data into HDFS and extracted the data from MS SQL into HDFS.

•Completed financial analysis monthly and identified opportunities to reduce expenses by 15%.

•Prepared financial valuation model in MS Excel for the company using DCF and FCF multiple approaches and conducted due diligence for prospective merger deal. Advised shareholder on deal terms and provided negotiation points backed by data analysis.

Environment: MicroStrategy, Python, Jupyter Notebook, MS SQL Server, Hadoop, Hive, MapReduce, HDFS, Microsoft Access, MS Excel.

Intersect Project (intersectproject.com) Durham, NC

Role: Data Analytics Consultant Sep'16 – Jan’17

Intersect is a FinTech startup developing data analytics software to help institutional investors and asset managers making smarter investment decisions across asset classes, industries, geographies, focusing on a clean energy.

Responsibilities:

Analyzed existing algorithm for stock-market prediction and created visualizations with D3.js, Angular.

Created UX wireframes and prototypes of UI in Angular, Bootstrap.

Analyzed the existing MongoDB database and developed a roadmap for the enterprise data warehouse for future product development. Developed ETL solution in Python to import various structured, semi-structured, and unstructured data for further analysis.

Implemented financial portfolio analytics in Python using LCET algorithm – McKinsey’s algorithm for carbon emission analysis of companies.

Environment: Python, JavaScript, Node.js, Angular, Bootstrap, MongoDB, D3.js, AWS.

Varian Medical Systems Inc. (NYSE: VAR) Palo Alto, CA

Role: Data Analytics Intern Jun'16 – Aug’16

Varian Medical Systems is the Fortune 500 Company and the global leader in radiation oncology imaging and treatment. Their medical devices include linear particle accelerators and software for cancer treatment planning. For this summer internship, I completed four projects in data analytics and FP&A.

Responsibilities:

Extracted healthcare claims and reimbursement data from Medicare Provider Utilization and Payment Data for ICD-10 radiation oncology codes to develop financial model for linear accelerator investment.

Provided reporting and analysis on sales effectiveness and effective discounts provided to customers. Utilized Business Intelligence tools, like Tableau and QlikView to present visual presentation of salesforce effectiveness and pricing adjustments across the US and Canada.

Worked with different teams (sales, marketing, business development, finance, IT, etc.) to gain insights about the data concepts behind the enterprise data warehouse and database schema.

Extracted large amounts of data for analysis and reporting using ETL scripting in Python. Responsible for documentation of all analysis as well as data discrepancies.

Determined the missing data, outliers, invalid data, and applied data cleansing and transformation techniques.

Evaluated data for distribution, classification and correlation.

Used Spark SQL to process the large amount of structured data and Implemented SPARK RDD transformations, actions to migrate Map/Reduce algorithms.

Analyzed different customer segmentation based on historical sales data, geolocation data, identified and presented opportunities for improvement in sales. Applied time series and autocorrelation analysis.

Designed custom reports, charts, tables and data visualization dashboards using Tableau for marketing and business development teams to support decision-making process.

Environment: Python, Excel, Hadoop, Spark, QlikView, Google Analytics, CRM, Tableau, MS Access.

European Bank for Reconstruction and Development (EBRD) London, UK

Role: Business Intelligence Consultant/Project Manager Sep’14 – May’15

Led the project financed by the Bank for the municipal water company financed by the sovereign debt issuance. The project goal was to implement new billing system for 500K+ accounts and streamline billing department’s operations.

Responsibilities:

Gathered business requirements through extensive interviews with all stakeholders and prepared the final Product Requirements Document (PRD).

Prepared system architecture and technology stack for the new billing system, created database schema in MS SQL Server.

Established version control repository (Subversion) and continuous integration (Team Foundation Server) for the development team.

Oversaw the software development lifecycle and weekly Scrum meetings with the development team. Served as a Product Owner and managed Sprint backlogs for each iteration.

Developed data reporting and data visualizations with D3.js, and Grafana, implemented complex analytical reports and drill-down capabilities for smarter analytics.

Collected requirements for data migration from the legacy systems into new database. Developed ETL program in C# to automatically transfer accounts data into new system for each software deployment.

Collaborated with tax consultants and implemented automatic invoicing, tax calculation and tax compliance submodule. Ensured compliance with applicable state and local laws in regards to revenue recognition and tax.

Conducted interviews with billing system users and prepared business requirements for reports, reconciliations, and integration with accounting system. Developed algorithm for automatic posting of entries into the General Ledger and account reconciliation between billing system and accounting ledger.

Conducted final presentation and provided trainings for senior executives on new billing system features and capabilities. Presented a product roadmap and ensured management buy-in.

Environment: MS Visual Studio, ASP.NET, MS SQL Server, Windows Server, IIS, Subversion, Foundation Server, JavaScript, jQuery, D3.js, Grafana.

The World Bank Group Washington, D.C.

Role: Data Analytics Consultant Jan’14 – Aug’14

The World Bank Group is an international organization headquartered in Washington, D.C. The World Bank Group has financed an International Development Aid project to help Tajikistan’s united energy corporation (OJSC “Barqi Tojik”) streamline business processes across 18 subsidiaries in billing, accounting, and enterprise analytics.

Responsibilities:

Conducted interviews with stakeholders across organization, analyzed the current state of the business intelligence at the company, and outlined the plan for the new BI implementation and required features.

Collected requirements for business intelligence system and prepared new database schema. Developed data migration plan into the new database. Developed ETL scripts in MS SQL to transfer business data into the new system. Transferred 5M+ accounts from separate regional databases into one unified customers database.

Managed the Hadoop adoption project, prepared the project roadmap, timeline, and implemented Hadoop solution for customer database.

Created Hive tables, transferred data to Hive from existing MS SQL databases, and queried data with HiveQL.

Designed easy to follow visualizations using Tableau software and published dashboards on web and desktop platforms.

Collaborated with financial and tax consultants to ensure tax compliance in accordance with applicable state laws in regards to revenue recognition and tax accruals and withholdings.

Developed and executed Hadoop jobs for processing millions of records of raw data.

Imported of data from various data sources, performed transformations using Hive, MapReduce, loaded data into HDFS, and extracted the data from MS SQL into HDFS.

Conducted interviews with billing system users and prepared business requirements for reports, reconciliations, and integration with accounting system. Developed algorithm for automatic posting of entries into the General Ledger and account reconciliation between billing system and accounting ledger.

Conducted final presentation and provided trainings for senior executives on new billing system features and capabilities. Presented a product roadmap and ensured management buy-in.

Environment: Hadoop, Hive, MapReduce, MS Excel, MS SQL Server, Windows Server 2008, Tableau, Visio.

Huawei Technologies Tajikistan Dushanbe, TJ

Role: Data Analyst/Analytics Jan’13 – Dec’13

Huawei Technologies is the largest networking and telecommunications equipment manufacturer and service provider in the world. The project’s goal was to analyze enterprise data warehouse, streamline operations, and provide recommendations for improvement in inventory management, supply chain, accounting, and reporting.

Responsibilities:

Led a team of four consultants to work on client’s requests, managed regular deliverables/weekly reports as per client's requirements. Extracted data from the sales database, completed denormalization and applied data analytics methodologies to solve business problems.

Interfaced with internal business users as well as IT development groups, managed expectations and initiated changes to the business systems. Act as the point of contact between the business units and IT.

Automated reporting processes by writing VBA macros for MS Excel and develop import-export functionality to MS SQL Server.

Acquired, and cleaned data using from multiple source including external and internal databases.

Performed data extraction, manipulation, analysis and data mining using SQL.

Conducted exploratory data analysis using Python to deep dive into internal and external data to diagnose areas of improvement and to increase efficiency.

Designed easy to follow visualizations using Tableau software and published dashboards on web and desktop platforms.

Involved in running Hadoop jobs for processing millions of records of raw data.

Handled importing of data from various data sources, performed transformations using Hive, MapReduce, loaded data into HDFS and extracted the data from MS SQL into HDFS.

Created data mapping document to map customer data from different systems to the enterprise customer database.

Led the company's machine learning and statistical modeling efforts including building predictive models and generating data products to support customer segmentation, product recommendation and allocation planning. Conducted experiments with predictive analytics algorithms and iterated into production system for various business needs.

Used Decision Trees, Logistic regression, Regression and Linear Regression algorithms to develop models.

Involved in start to end process of Hadoop project initiation, planning, executing, monitoring and controlling.

Involved in running Hadoop jobs for processing millions of records of raw data.

Handled importing of data from various data sources, performed transformations using Hive, MapReduce, and extracted the data from MS SQL Server into HDFS.

Provided first-line problem resolution or escalation, as well as technical assistance. Analyzed end user needs and developed customer oriented solutions communicating with existing applications.

Environment: Hadoop, Hive, MapReduce, Python, scikit-learn, MS Excel, MS SQL Server, Microsoft Office, Tableau.

Gazprom Oil Kyrgyzstan, subsidiary of Gazprom (LSE: GAZ) Bishkek, KG

Role: Business Intelligence Consultant Sep’11 – Dec’12

Gazprom Oil Kyrgyzstan is the largest vertically integrated oil&gas company in Kyrgyzstan, wholly owned subsidiary of Gazprom-Neft, headquartered in Russia. The project’s goal was to update internal accounting system and introduce new business intelligence suite of tools.

Responsibilities:

Conducted interviews with stakeholders across organization, analyzed the current state of the business intelligence at the company, and outlined the plan for the new BI implementation and required features.

Collected requirements for business intelligence system and prepared new database schema. Developed data migration plan into the new database. Developed ETL scripts in MS SQL to transfer business data into the new system.

Collaborated with financial and tax consultants to ensure tax compliance in accordance with applicable state laws in regards to revenue recognition and tax accruals and withholdings.

Performed maintenance and develop documentation for all developed programs

Wrote structured application/interface code from specifications conforming to established methodology and standards. Provide first-line problem resolution or escalation, as well as technical assistance.

Analyzed end user needs and developing customer oriented solutions, with interface to existing applications. Designed and analyzed the SQL Server database and involved in gathering the user requirements.

Designed easy to follow visualizations using Tableau software and published dashboards on web and desktop platforms.

Gathered all data, cleaning and analysis of the data from different databases using time series analysis in Python.

Code, debug, document and install new programs and make changes to existing programs/technologies.

Designed custom reports, charts, tables and data visualization dashboards using Tableau for marketing, accounting, finance, and operations teams to support decision-making process.

Environment: Python, MS SQL Server, Tableau, Scikit, Excel.

Tcell, subsidiary of Telia Sonera (STO: TELIA) Dushanbe, TJ

Role: Data Analyst/Analytics Oct’10 – Sep’11

Tcell is the leading mobile network operator in Tajikistan, subsidiary of the Telia Sonera Company (STO: TELIA). The project’s goal was to apply data analytics in solving various business challenges, like customer churn, lifetime value, ARPU trends tracking, marketing channel effectiveness, and others.

Responsibilities:

Analyzed end user needs and developing customer oriented solutions with interface to existing applications. Designed and analyzed the SQL Server database and collected user requirements through extensive interviews and document review.

Wrote simple and advanced SQL queries and scripts to create standard reports for senior managers.

Designed custom reports, charts, tables and dashboards using Tableau and for marketing and operations teams to support decision-making process.

Gathered data, cleaned and analyzed the data from different departments using time series analysis in Python.

Code, debug, document and install new programs and make changes to existing programs/technologies.

Imported the customer data into Python using Pandas libraries and performed various data analysis - found patterns in data which helped in key decisions.

Provide data analysis, finding Root/Cause data integrity problems in HRMS, Report generation. Ensured all data has a complete and accurate definition

Determined the cost of operations by establishing standard costs, collecting operational data and by using research analytics and data modeling techniques.

Guided cost analysis process by establishing and enforcing policies and procedures, providing trends and forecasts, explaining processes and techniques, recommending actions by Regression, Logistic and cluster modules.

Improved financial status by analyzing results, monitoring variances, identifying trends, recommending actions to management with different time and place using time Series Analysis.

Conducted team meetings & ensured project documentation is completed.

Responsible for data aggregation, data pre-processing, missing value imputation and descriptive and inferential analysis.

Environment: Python, Jupyter notebook, SQL, Microsoft Office, SQL Server Reporting Services (SSRS), Microsoft Excel, Tableau.

Alliance One Tobacco Osh, subsidiary of Alliance One International (NYSE: AOI) Morrisville, NC

Role: Data Analytics Consultant Sep'09 – Sep’10

Alliance One Tobacco Osh is part of Alliance One International, headquartered in Morrisville, NC. AOI is the world’ leading tobacco trading company. The project’s goal was to help analyze enterprise data and build predictive statistical models.

Responsibilities:

Implemented the MS SQL Server database to interact with application and database through SQL queries.

Performed data extraction, manipulation, analysis and data mining using SQL.

Conducted exploratory data analysis using Python to deep dive into internal and external data to diagnose areas of improvement and to increase efficiency.

Designed custom reports, charts, tables and data visualization dashboards using Excel and PowerPoint for marketing and business development teams to support decision-making process.

Created use cases, class diagrams, activity diagrams and collaboration diagrams.

Involved in System documentation, object documentation and User documentation.

Environment: Python, MS SQL Server, Microsoft Excel, VBA, MS Access.

Kumtor Gold Company, subsidiary of Centerra Gold (TSE: CG) Bishkek, KG

Role: Business Intelligence Consultant Sep'08 – Aug’09

Kumtor Gold Company is the largest gold mining company in Central Asia, wholly owned subsidiary of the Canadian corporation Centerra Gold, headquartered in Toronto.

Responsibitilies:

Designed easy to follow visualizations and published dashboards on web and desktop platforms.

Created data mapping document to map customer data from different systems to the enterprise customer database.

Analyzed end user needs and dementing Activity Based Costing methodology, and developed a customer-oriented solution with interface to existing enterprise application platform. Designed and analyzed the SQL Server database and collected user requirements through extensive interviews and document review.

Wrote simple and advanced SQL queries and scripts to create standard reports for senior managers.

Designed custom reports, charts, tables and dashboards using Excel and PowerPoint for finance and operations teams to support decision-making process.

Determined the cost of mining operations in Excel, collected operational data by using research analytics and data modeling techniques.

Guided cost analysis process by establishing and enforcing policies and procedures, providing trends and forecasts, explaining processes and techniques, recommending actions by Regression, Logistic and cluster modules.

Conducted team meetings & ensured project documentation is completed in accordance with Sarbanes-Oxley Act.

Responsible for data aggregation, data pre-processing, missing value imputation and descriptive and inferential analysis.

Environment: MS SQL Server, Microsoft Excel, VBA.

EDUCATION:

DUKE UNIVERSITY, FUQUA SCHOOL OF BUSINESS, DURHAM, NC MASTER OF BUSINESS ADMINISTRATION

Concentration: Finance, Decision Sciences

Certificate: Health Sector Management Certificate

AMERICAN UNIVERSITY IN CENTRAL ASIA BACHELOR OF ARTS

Major: Business Administration

Concentration: Accounting and Management Information Systems

CERTIFICATES:

Amazon Web Services Big Data Technology Fundamentals

Advanced SQL for Data Science

Advanced NoSQL for Data Science

Machine Learning & AI: Advanced Decision Trees

Machine Learning & AI: Building a Recommendation System with Python

Data Science and Machine Learning with Python



Contact this candidate