We provide IT Staff Augmentation Services!

Software Application Developer/database Administrator Resume

3.00 Rating

Chicago, IL

TECHNICAL SKILLS

  • 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)
  • 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 / Machine Learning Algorithms (Classification, Regression, Clustering, Association Analysis, Dimensionality Reduction, Preprocessing, Natural Language Processing etc.)/ Mahout / R Statistical Software/ Python
  • Python /PyCharm IDE/ IPython Notebook/ SciPy/ Pandas /NumPy /SymPy/ Matplotlib/ Scikit-Learn/NLTK/ Web Scraping & Beautiful Soup / Python Magic/Latex/ Markdown
  • R / RStudio / RCommander / RGUI / Rattle GUI / Shiny

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 the 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 the data to be loaded to the 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 with 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 with financial products information for the12U.S. government-sponsored Federal Home Loan Banks MPF program.
  • Participated on ebanking Scrum team with senior executives, business analysts, project managers, QA team and external consultants to plan, estimate, develop, test and implement business initiatives to meet the functional and non-functional requirements of the 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 the Microsoft SQL Server business intelligence technology platform (SSRS, SSIS, SSAS, SharePoint, CRM Dynamics 2011), Crystal Reports, Tableau, and .NET framework programing languages.
  • Worked with 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 the 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 the 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.

Business Intelligence Developer Trainee

Confidential, Jacksonville, FL

Responsibilities:

  • Actively contributed to team effort of designing numerous simple to complex T-SQL statements, stored procedures with parameters to query databases according to business requirements.
  • Evaluated table relationships to determine the most efficient query designs to return requested results.
  • Designed impressive SSRS reporting solutions according to user specifications to bring meaning to the 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 with 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 the newly created databases using Restore Database T-SQL syntax.
  • 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.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 with appropriate codes and sent to Merchandise Managers and vendors for correction.
  • 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 with detailed query and metrics requirements for running reports.
  • Developed a dashboard report tracking system using BI tool SharePoint for the Audit Repository to monitor 45 types of reports and ensure Procurement Managers complied with reporting requirements, KPI’s, and deadlines.
  • Assisted Procurement Senior Manager with ad-hoc projects and analyses in preparation for Audit.

Revenue Management Coordinator

Confidential, Chicago, IL

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 with 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 2007 to 2010 and ensured validity or expensed back to the 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 the earned trade or freight discount.
  • Assisted Chief Financial Officer with 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 with 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 the 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 with up-to-date information and identified areas of opportunity to reduce fixed and variable cost drivers.

TECHNICAL SKILLS

  • 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 (Classification, Regression, Clustering, Dimensionality Reduction etc.) /Natural Language Processing /Mahout/R Statistical Software
  • R/RStudio/RCommander/RGUI/ Rattle GUI

We'd love your feedback!