SUMMARY:

• Seeking Data Scientist position to utilize my exceptional data science, econometrics, information technology and business analysis skills I gained from nine years of corporate financial analysis, software development and project management experience.
• SQL Server 2000/2005/2008 R2/2012/2014
• SQL Reporting, Integration, Analysis Services & Database Administration (T - SQL, MDX, DAX, DMX, SSRS, DTS/SSIS/ETL, SSAS/BISMs/Cubes - Multidimensional/Tabular, Data Mining, Self-Service Business Intelligence, PowerPivot, Power View, GeoFlow/Power Map, Power Query, Power BI, Q&A/InfoNav/ Natural Language Search)
• Microsoft Visual Studio 2008/2010/2012 (IDE), .NET Framework (Visual Basic.NET, Visual C#, Visual C++, ASP.NET, LINQ)
• Microsoft SharePoint 2010/2013
• Microsoft Dynamics CRM 2011
• Oracle Business Intelligence Enterprise Edition(OBIEE)/ BI Publisher 10g/11g, PL/SQL
• Object Oriented Programming. (OOP), Java, JVM/ Java SE 7 /JDK, Windows/Linux, Eclipse (IDE)/ Eclipse CDT (C/C++ Development Tools)
• Big Data/ Hadoop 1.0/ Hadoop 2.0 YARN/ NoSQL/ MapReduce/ Ubuntu/Linux/UNIX/ Cloudera
• Hadoop Distributed File System (HDFS), Hive, Pig, Sqoop, Flume, HBase, Zookeeper, Oozie, MongoDB, Storm
• Data Science / Statistics/ Econometrics, Data Visualization/ Machine Learning Algorithms (Classification, Regression, Clustering, Bayesian Methods, Association Analysis, Dimensionality Reduction, Ensemble Methods, Time Series Analysis, Cross Validation, Sentiment Analysis, Neural Networks, Anomaly Detection, Preprocessing, Natural Language Processing etc.)/ Scientific Python / R Statistical Software/ Mahout
• Models/Algorithms (Linear Regression, Logistic Regression, Naive Bayes, kNearest Neighbor, Classification and Regression Trees (CART), Support Vector Machines (SVM), Random Forest, Adaptive Boosting (AdaBoost), Kmeans, Principal Component Analysis, Truncated Singular Value Decomposition, Density Estimation, Cross validation, Metrics, Grid search, Random Search, Imputing, Pipeline, Feature Extraction etc.)
• Python /PyCharm IDE/ IPython Notebook/ SciPy/ Pandas /NumPy /SymPy/ Matplotlib/ Scikit-Learn/ StatsModels/SQLAlchemy/ pyodbc/ NLTK/ Web Scraping & Beautiful Soup / Python Magic/Latex/ Markdown
• R / RStudio / RCommander / RGUI / Rattle GUI / Shiny
• Tableau Software
• Amazon Web Services/ Cloud Computing
• ITIL® Foundation Certification - 2013
• Professional Scrum Foundations - 2013
• Enterprise Financial Systems, Applications, Information, Software Development and Programming
• Data Warehousing/ Data Modeling
• Database Administration, Design and Development
• OLAP
• Corporate Finance, Banking, Financial Markets
• Securities- Derivatives, Equity, Debt. (Advances, Derivatives, Stocks, Bonds, Mortgages)
• Financial Engineering
• Financial Modeling
• Financial Statements/ Board Reports
• Financial Analysis, Accounting and Reporting
• Business Analytics
• Predictive Analytics/ Data Mining
• Statistical Modeling
• Profitability & Cost Control Analysis and Modeling
• Key Performance Indicators (KPI’s)
• Revenue Forecasting
• Business Analysis/ Requirements Gathering and Documentation
• Quality Assurance Testing
• Project Implementation and Management
• Budget Development and Management
• Inventory Control
• Credit & Collections
• Audit Reporting
• Software Development Life Cycle (SDLC)
• Enterprise Business Intelligence Trainer
• Microsoft Office: SQL Server 2000/2005/2008 R2/2012/2014 - SSRS, SSIS, SSAS, BISMs, MDX, DMX, Management Studio, Visual Studio/Business Intelligence Development Studio/SQL Server Data Tools, Excel, Access, Word, Self-Service Business Intelligence. Outlook, PowerPoint, and SharePoint, MS Dynamics CRM 2011, PerformancePoint, Self-Service Business Intelligence, PowerPivot, DAX, Power View, GeoFlow/ Power Map, Power Query, Power BI, Q&A/InfoNav/ Natural Language Search, Report Builder
• Crystal Reports XI/Crystal Syntax
• Object Oriented Programming. (OOP), Java, JVM/ Java SE 7 /JDK, Windows/Linux, Eclipse (IDE), Eclipse CDT (C/C++ Development Tools)
• Big Data/ Apache Hadoop 1.0/Apache Hadoop 2.0 YARN/ NoSQL/ MapReduce/ Ubuntu/Linux/ Cloudera
• Hadoop Distributed File System (HDFS), Hive, Pig, Sqoop, Flume, HBase, Zookeeper, Oozie, MongoDB, Storm
• Data Science/ Machine Learning Algorithms Econometrics, (Classification, Regression, Clustering, Dimensionality Reduction, Association Analysis, Time Series Analysis, Ensemble Methods etc.) /Natural Language Processing /Mahout/R Statistical Software
• R/RStudio/RCommander/RGUI/ Rattle GUI
• Tableau Software
• Python/PyCharm IDE/SciPy/IPython/Pandas/NumPy/Matplotlib/SymPy/Scikit-learn/StatsModels/ SQLAlchemy/ pyodbc/ NLTK/Beautiful Soup/Web Scraping
• Cognos
• SAP ERP (FICO, SD)
• Adage ERP
• Mainframe
• Receivables Edge
• Lotus Notes
• Paradox
• Business Objects
• Webcon
• MicroStrategy
• Jira
• Lawson ERP Software
• IntelliCapture/Perceptive Software
• XML/ CAML queries/FetchXML
• OLAP/OLTP/Data Modeling
• Microsoft Visual Studio 2008/2010/2012 (IDE), .NET Framework (Visual Basic.NET, Visual C#, Visual C++, ASP.NET)
• Control-M
• VMware
• Embarcadero
• ITIL
• Microsoft Visio
• Microsoft Team Foundation Server
• Putty
• Visio

PROFESSIONAL EXPERIENCE:

Software Application Developer/Database Administrator

Confidential, Chicago, IL

Responsibilities:

• Designed, developed, and managed enterprise production data warehouses and business intelligence and analytics platforms and applications.
• Develop and manage federal financial instruments and securities data, reporting, analytics, and systems solutions using teh Microsoft SQL Server business intelligence technology platform (SSRS, SSIS, SSAS, SharePoint, CRM Dynamics 2011), Oracle(PL/SQL, OBIEE, BI Publisher 10g, 11g), Java and .NET framework programming languages.
• Lead analysis, design, development, implementation and support of FHLBC ebanking web application.
• Used basic and scientific python libraries such as SciPy, NumPy, Pandas, and beautiful soup to develop dynamic ETL processes using python scripts to read and load vendor files from external web applications, and performed data transformations to prepare teh data to be loaded to teh data warehouse for analytics and reporting.
• Developed and maintained SQL, Java, XML and Oracle Business Intelligence Publisher analytics, reports and dashboards for ebanking Application.
• Maintained and developed executive level reporting analytics and insights wif tools such as SSRS, SSAS, Tableau, Crystal reports and dashboards, and also provided enhancements for enterprise MS Dynamics CRM Application.
• Designed and developed dynamic advanced T-SQL, PL/SQL, MDX queries, VB.NET Scripts, stored procedures, XML, user defined functions, parameters, views, tables, triggers, indexes, constraints, SSIS packages, SSAS Cubes, SQL Server Agent jobs, deployment scripts and installation instructions for enterprise data warehouse and applications.
• Developed SSIS ETL solutions for data warehouse wif financial products information for the12U.S. government-sponsored Federal Home Loan Banks MPF program.
• Participated on ebanking Scrum team wif senior executives, business analysts, project managers, QA team and external consultants to plan, estimate, develop, test and implement business initiatives to meet teh functional and non-functional requirements of teh application.
• Troubleshoot, performance tuned, monitored and provided 24/7 enterprise production database support for critical situations and ensured overnight processes completed successfully to meet business service level agreements.

Software Application Developer

Confidential, Chicago, IL

Responsibilities:

• Designed and developed federal financial data models, information, reporting, analytics and systems solutions using teh Microsoft SQL Server business intelligence technology platform (SSRS, SSIS, SSAS, SharePoint, CRM Dynamics 2011), Crystal Reports, Tableau, and .NET framework programing languages.
• Worked wif senior executives, business analysts, project managers, QA team and external Microsoft consultants to interpret high level design requirements from a technical perspective for federal financial data models and ensured that solutions are deliverable.
• Maintained and developed executive level SSRS and SSAS reports, Crystal reports, Tableau dashboards and enhancements for Enterprise MS Dynamics CRM Application.
• Designed and developed dynamic advanced T-SQL, SharePoint CAML, FetchXML and MDX queries, VB.NET Scripts, stored procedures, parameters, views, tables, triggers, SSIS packages, SSAS Cubes, SQL Server Agent deployment scripts and installation instructions for enterprise data warehouse and applications.
• Developed ETL solutions to migrate existing and new database objects into teh newly created databases using T-SQL, SSIS packages and stored procedure scripts.
• Designed and implemented an enterprise SQL Server Reporting Services Training Program.
• Converted existing MS Access and Crystal Reports to SQL Server Reporting Services.
• Developed detail design and code programming statements that effectively manipulate data to achieve desired output.
• Trained junior and senior developers including my manager to develop and code interfaces for both “off teh shelf” and proprietary software application products.
• Performance tuned, administered, gathered requirements and also develop new database objects for enterprise databases and applications.
• Enterprise business intelligence trainer.

SQL Server 2008 R2 Business Intelligence Developer Trainee

Confidential

Responsibilities:

• Actively contributed to team effort of designing numerous simple to complex T-SQL statements, stored procedures wif parameters to query databases according to business requirements.
• Evaluated table relationships to determine teh most efficient query designs to return requested results.
• Designed impressive SSRS reporting solutions according to user specifications to bring meaning to teh data and solve complex business requirements using maps, dashboards, sparklines, data bars, drill downs, subreports, indicators, and gauges.
• Leveraged SSIS Extraction, Transformation and Loading tools wif Flat Files, XML, Excel, OBDC, BD2, SQL, Oracle sources and Databases.
• Configured Reporting Service Configuration Manager & Report Manager and deployed reports for End-User access.
• Created new databases, database backups/restores, and migrated existing tables into teh newly created databases using Restore Database T-SQL syntax.

SAP/Finance Data Analyst

Confidential

Responsibilities:

• Perform data analysis and update newly negotiated contract terms between vendors and sales department to reflect changes in SAP system.
• Create SAP queries to extract, transform, and load updated invoice and contract data in SAP for Finance department.
• Analyze and audit corporate-wide travel and expense reports for Finance department.
• Perform ad hoc duties as requested.

Data Analyst

Confidential

Responsibilities:

• Developed merchandise content for Kmart website and resolved any content issues.
• Created weekly sales and inventory reports using business intelligence tools such as Business Objects, Microstrategy, and MS Excel to design complex queries, V-lookups and Pivot tables for management.
• Analyzed data and website merchandise content and resolved errors by developing reports wif appropriate codes and sent to Merchandise Managers and vendors for correction.

Financial Data Analyst/Project Analyst

Confidential

Responsibilities:

• Designed and developed Intranet Audit Repository for Sara Lee Indirect Procurement E-Buy team site using business intelligence tool Microsoft SharePoint/ Moss.
• Analyzed and managed Control Point data and Process Definition Documents to ensure all E-Buy system audit processes and requirements were up-to-date.
• Created Audit Compliance Report Instructions wif detailed query and metrics requirements for running reports.
• Developed a dashboard report tracking system using BI tool SharePoint for teh Audit Repository to monitor 45 types of reports and ensure Procurement Managers complied wif reporting requirements, KPI’s, and deadlines.
• Assisted Procurement Senior Manager wif ad-hoc projects and analyses in preparation for Audit.

Revenue Management Coordinator

Confidential

Responsibilities:

• Managed trade deductions and freight claims for direct customers and resolved customer billing discrepancies for Western, Special Markets, and VTC Divisions of Wrigley Sales.
• Managed all customer accounts using SAP and Microsoft Excel to create reports, track contracts, invoices and multiple general ledgers.
• Analyzed contracts and invoices to resolve unearned cash discounts and recovered over $20,000.
• Collaborated wif logistics department and distribution companies and investigated all disputed freight deductions to ensure customer repayment or issued credit for authorized product returns.
• Verified logistics proof of delivery documents, billed customers for all product shipment overages, and requested repayment.
• Researched open and unapplied aging credits of over $400,000 from between and ensured validity or expensed back to teh appropriate general ledger account.
• Compiled all supporting documentation for credit and debit approvals and forwarded for approval.
• Advised customers of all approved open credits and sent memos informing customer to deduct teh earned trade or freight discount.

Financial Analyst

Confidential, Chicago, IL

Responsibilities:

• Assisted Chief Financial Officer wif profitability and cost control analysis based on sophisticated business intelligence data modeling tools using Microsoft Access, Excel pivot tables, and Cognos.
• Developed and analyzed Key Performance Indicators (KPI’s) reports using Cognos for senior management including revenue growth, margin/mix analysis, profitability, and breakeven levels.
• Analyzed 2008 and 2009 sales growth, marketing budget, and spending for our largest customer.
• Developed sales growth, forecast, marketing budget, and credit memo reports for senior management using Cognos.
• Analyzed financial data and performance of various business segments and customers, and worked wif management to determine action plans to improve profitability levels.
• Developed company’s first energy reporting and tracking database using business intelligence tool Microsoft Access to capture daily electricity, natural gas, and water usage and costs for teh four main manufacturing facilities, and verified supplier invoice charges against daily usage data.
• Performed database administration duties for database and ensured deals and claims were properly set up.
• Tracked deal performance and provided reporting metrics to management on overspending on deals, duplicate claims, and claims not deducted by vendors.
• Maintained various databases and spreadsheets wif up-to-date information and identified areas of opportunity to reduce fixed and variable cost drivers.