SUMMARY:

• Experienced Consultant recognized for superior work ethic, business acumen, professionalism, and productivity as well as fostering a sense of mutual respect amongst co - workers and team members.
• Data Warehousing
• Business Intelligence
• SQL

TECHNICAL SKILLS:

Tableau: MongoDB, NoSQL, MicroStrategy (Desktop, Web Services), Omniture, Windows Server 2008R2 (SSIS, SSRS), Microsoft Office 2010, SQL Server 2008 R2 (SSIS, SSRS), Visual Studio 2010, Confidential, Eclipse, Photoshop CS5, Dreamweaver CS5, Illustrator CS5, Visio 2010, Visual Studio 2010, Siebel CRM, Oracle 11i, Oracle Tutor, Oracle Portal, MS Project, iWork, DBvisualizer

Databases: MYSQL, DB2, Oracle, SQL Server

Languages: Python, HTML, XML, CSS, Java, T-SQL, MySQL, PL/SQL, C#

RELEVANT WORK EXPERIENCE:

Confidential, Argonne, IL

Business Intelligence Developer - Consultant

Responsibilities:

• Responsible for the design, development, implementation and support of extraction, transformation, and load (ETL) processes that automate the movement of data between business applications and data stores. Maintain ETL transformations and job processes to prepare data for analysis.
• Breakdown and debug complex Confidential jobs for more efficient and simplistic methods that promote automation.
• Perform ad hoc data analysis per business user requests.
• Analyze existing processes to introducing more efficient data delivery methods through Confidential best practices.
• Work cooperatively with others to resolve data and process issues.
• Provide support for account management teams and work with non-technical subject matter experts to understand underlying data behavior and characteristics. Work closely with business data analysts, and BI developers to understand requirements, develop ETL processes, validate results, and deliver to production. Provide performance tuning, troubleshooting assistance, and Confidential technical expertise.

Confidential, Argonne, IL

System Reports Developer - Consultant

Responsibilities:

• Identify business logic from current reports/visualizations produced from Python scripts (matplotlib, pandas libraries) and replicate existing graphs and charts utilizing design tools from Confidential 's Enterprise Edition Suite (4.8.3).
• Create automated processes in Confidential (Spoon) for the delivery of data-driven Business Intelligence reports produced with Confidential Report Designer.
• Plan and develop web-based report processes and email delivery applications to offer automated Business Intelligence Solutions for the Argonne Supercomputer community providing sponsors, users, management and staff, and the Department of Energy different views and access to reportable metrics.
• Implement BI standards and best practices to ensure more control and fewer data reporting inconsistencies.
• Create Kettle job scripts with Confidential 's Data Integration tool (Spoon) for the automation of the email report delivery processes which delivers daily snapshots and metrics to users by group and individually. Develop Kettle job scripts with Confidential 's Spoon to automate the generation of static data-driven reports for web-based reporting processes.
• Assist with data and system reports validation. Identify issues with source systems, ETL processes and warehouse data, working with the Business Intelligence team to provide solutions.
• Provide additional ad hoc reporting with Tableau and Ctools.
• Analyze ETL and reporting processes developed in Spoon 4.8.3 identifying efficient and simplistic improvements for all production ETL and reporting processes for Confidential 5.3 upgrade. Provide process steps, instruction and wiki documentation for Business Intelligence team on Confidential processes and tool configuration.
• Plan and develop strategy for IT outsourcing to meet business objectives.
• Evaluate and select service providers best suited to meet project objectives.
• Formulate and negotiate IT outsourcing contracts to meet outsourcing objectives.
• Manage project costs to ensure that projects achieve their planned benefits within budget.
• Manage project communications to ensure effective collection and dissemination of project information. Manage stakeholders to minimize conflicts and to address their diverse interests.

Confidential, Naperville, IL

ETL Analyst/Developer

Responsibilities:

• Design, develop, test, debug and document highly complex SSIS packages and Confidential transformations in an Agile development environment.
• Maintain and make significant enhancements to existing packages working with business leaders and users to refine and enhance ETL processes and dimensional data model.
• Lead Engineer for data quality process implementation.
• Validate data consistency of ETL processes from source to destination through stored procedures, Confidential transformations, Python scripting, Tableau dashboard reporting, and SSIS solutions.
• Provide analysis to ensure the accuracy and integrity of the data is centralized from disparate sources in order to deliver actionable Business Intelligence. Perform performance tuning, error, repair, and process scheduling. Create and maintain project tasks and schedules.
• Create dashboards with Tableau for users that provide business intelligence which improves decision making.
• Create dashboards for internal management and staff for analysis and data validation to ensure accuracy of ETL loads.
• Lead Analyst in the validation of all archived visuals to maintain consistency throughout several data sets.

Confidential, Hoffman Estates, IL eCommerce Analyst - Consultant

Responsibilities:

• Determine relevant source data for the purpose of providing useful information through analysis.
• Developed technical best practices for data movement, data quality, data cleansing and other ETL-related activities through the use of open source tool Confidential, and SQL Server 2008 R2 (SSIS).
• Designed and maintained SSIS packages and Kettle transformations in Confidential .
• Provide data validation to ensure accuracy of ETL process.
• Collect and compile online data for Confidential .com and Kmart.com utilizing web analytics tool Omniture.
• Provide dashboards that gauge conversion rates of consumers, and trend analysis for ongoing marketing initiatives.
• Create ad hoc reports that measure the performance of various initiatives.
• Examine and evaluate purpose and content of business reports to develop new, or improve existing format, use, and control:
• Reviews reports to determine basic characteristics, such as origin and report flow, format, frequency, distribution and purpose or function of report.

Confidential, Chicago, IL

Consultant

Responsibilities:

• Performed a multifaceted role as a consultant for various clients.
• As a consultant for a fund of fund hedge fund investment group, I provided various business intelligence solutions analyzing asset management data.
• Converted manually executed Excel asset exposure reports creating automated web based reports in Microstrategy.
• Troubleshooting of reporting inaccuracies through reverse engineering of SQL scripts for manually executed reports and data validation.
• I analyzed SQL scripts and relational databases, extracting data to plan and create Microstrategy reports and dashboards. Served as support providing ad-hoc management reporting requests. Met regularly with Project Managers and teams to validate report results against requirements for consistency and accuracy and identified improvements and efficiencies.
• I provided business intelligence for a pharmaceutical company, designing and developing complex reports and dashboards with Microstrategy Mobile Platform for iPad reporting. Interfaced with the customer to convert business needs into accurate functional and non-functional requirements.
• I fulfilled the role of server administrator installing Windows Server 2008 R2 on a HP ProLiant server to be used as a FTP server.
• Partitioned and configured the hard drive, configured IIS, opened necessary ports for FileZilla FTP Server software, and configured internal and external remote desktop services.
• Assisted in server support for end-users for the entire US.

Confidential, Sturtevant, WI

Data Warehouse Engineer

Responsibilities:

• My responsibilities as a Contractor were assisting in the conceptual design of the data warehouse based on business requirements.
• I identified entities, relationships, and attributes constructing an entity relationship model.
• Created the physical data models dimensions, fact tables, and indexes utilizing a MySQL database.
• Developed ETL transformation processes in Confidential Spoon, extracting the data from a SQL Server databases and XML files to the newly developed data warehouse.
• I created an OLAP multi-dimensional cube using Confidential ’s Schema Workbench.
• Documented the ETL Staging process for training and reference on future ETL processes.
• Provided database administration with population tuning and performance testing.
• Wrote complex SQL queries for data extraction/mining for creation of reports in Confidential ’s Report Designer and to provide Business Intelligence.
• Designed BI reports based on business and user requirements.

Confidential, Skokie, IL

IT PMO Business Analyst

Responsibilities:

• Provided IT process analysis and improvement projects through the management on Project Management documentation.
• The Project Management Methodology Roadmap was a repository of internal process documentation in which I made several modifications to documents, and templates for standardization purposes.
• Provided updates for IT-specific process documents and tools in support of a more robust Project and (ITIL) Change Management process.
• I performed process reviews and also developed new templates and procedural documentation for the PMM Roadmap.