SUMMARY:

• Extensive experienced in performing integrative analysis, providing support and technical guidance throughout all phases of software development life cycle in a multi - platform environment including design, development, testing, implementation and maintenance of IT applications for Advertising, Marketing, and Financial business needs.
• Strong understanding of business intelligence components, from data modeling and ETL concepts to queries, reports and dashboards. Advanced skills in report automation, solving reporting and system problems while working independently and in collaboration with a diverse group of developers and managers.
• Strong technical proficiency with relational and multi-dimensional databases, Microsoft Excel, Access, SQL, SSAS. Experience with SSMS, SSIS, and SSRS and Tableau data visualization. Highly motivated and results-oriented. Always succeed at researching new technologies and applying skills. Excellent interpersonal skills.

TECHNICAL SKILLS:

• Extensive experience with the following technologies: Microsoft Excel, PowerPivot, Excel Pivot tables and functions, Access, VBA, SQL, SSAS with Microsoft Dynamics, and Share Point.
• Experience with PowerPoint, Visio.
• Experience with Microsoft BI Reporting and Analysis Tools including SSIS, SSRS and SSAS, and Tableau.

PROFESSIONAL EXPERIENCE:

Confidential, Baltimore, MD

Sr. Programmer / Analyst

Responsibilities:

• Gather and document project and data requirements for ad hoc, weekly, monthly, quarterly, and annual analytics and reports to support Advertising and Finance management through the development of short-term and long-range business planning. Deliver a broad variety of reports and dashboards to provide data aggregation and visualization for revenue and volume reporting across the company for budgeting, sales scorecards, goals setting and commission calculations.
• Assess available data sources to identify best reporting solutions; use SSAS, Excel and Power Pivot to extract data for cube preparation, analysis and reporting that enable upper management meet company goals and objectives. Collect, convert, blend and analyze data from multiple sources to identify trends and overall effectiveness, and present information in a way that drives fact based decision making. Perform data profiling to identify and illustrate data discrepancies between multiple data sources such as SQL Server, TM, CRM, and online reporting system using SQL Server components, PowerPivot, Excel VLOOKUPs and IF functions to ensure data integrity on all levels of detail for customers and products.
• Generate complex analysis and reports using SSAS cubes, Excel Pivot tables and dashboards to help department leaders gain real time insight into such KPIs as sales target, performance trends and top revenue drivers. Generate weekly, monthly and quarterly reports for Advertising, Finance and Marketing staff using Microsoft SQL Server to query data dump files for reporting on various level of customer-product-order details, data mining and validation.
• Evaluate variety of technology platforms and databases, and use advanced techniques to automate advertising and finance reports. I redesigned key reporting applications using Excel VBA macros to automate workflow which was crucial for the timely delivery of executive reports and enhanced process efficiency. Adapted quickly to SSIS application for various data extract, transformation, load scenarios. Created Microsoft Access databases and queries to enable our team make necessary data changes effectively.
• Communicate effectively with technology team during the evaluation of new software products and participate in integration process. Review input and output data of the newly implemented solution, proactively ensure the solution works successfully; monitor changes and resolve issues by responding as they occur to provide a smooth transition to the new system. I have made valuable contribution during migration from mainframe databases to Microsoft Dynamics, Excel, and internet applications. Involved in defining, documenting functional requirements, and creating OLAP cubes in SSAS. Responsible for application testing and validation to ensure that our staff is satisfied with the final product. My efforts contributed to the transition going well in Baltimore, and helped to avoid disrupting the delivery of accurate reports to management and staff.
• Collaborate with IT and business teams to implement solutions to minimize data quality issues including inaccurate, incomplete, missing or invalid data, outdated information and inconsistent data across systems. Actively participate in functional, regression and system testing, which includes creating, executing various test cases and developing test data; analyzing usability and system defects to ensure data and reporting quality. Represent the Baltimore business unit in weekly UAT sessions led by Chicago Tribune Technology team during development process of new reporting applications and features.
• Assist technology team with data modeling including analysis, design and documenting data gathering processes, data table structures and relationships. Create PowerPoint presentations on project scope, deliverables, timelines and milestones. Participate in group presentation to discuss application effectiveness and improvements strategies to ensure data and reporting quality, test schedule and acceptance criteria.
• Work closely with Advertising and Finance managers and staff to gain a deep understanding of their reporting needs, assist them with using new applications to provide them with insights into their business through data analysis and presentation; and maintain their feedback for continuous improvement.

Confidential, Rockville, MD

Programmer / Analyst

Responsibilities:

• Provided quality customer service and sound problem solving for SHA management and customers. Worked with clients to assess their needs, gather their software requirements, and provided assistance with resolving their issues.
• Identified and documented multiple business requirements, analyzed options, provided recommendations and reported results to management. Performed planning and analyzing data requirements throughout all phases of Systems Development Life Cycle, which included design, development, testing, and quality assurance.
• Supported SHA clients’ front-users with their applications needs, provided assistance explaining and analyzing requirements for new programs and interfaces, evaluated alternatives to make recommendations on using database applications.
• Worked with clients’ technical representatives across various SHA companies and other developers to analyze and create data standards, and provided technical guidance on data formats, retrieving, import and export, storage and maintenance.
• Migrated MS Access 97 applications to MS Access 2000 and XP. Identified best practices and processes for ensuring data integrity for smooth and efficient transition between these applications.
• Collaborated with clients’ representatives to help them develop data requirements for applications, prepared test data for testing multiple relational databases and internet-based applications to ensure that data collection forms meet data quality policies.
• Used wide variety of analytical tools and techniques for performing detailed analysis and studies necessary for design and maintenance of large-scale data bases and assessed ways to improve data flow in new and existing applications.
• Made effective oral and written presentations, prepared various written documentation for meetings with managers and technical personnel of SHA, including data processes and business flow charts, graphs and spreadsheets. Reviewed design documents and translated technical information into readable documents for non-technical personnel.