SUMMARY:

My objective is to provide quality service and commitment to my internal and external customers and to continue to strive for excellence.

EXPERIENCE:

Confidential, West Des Moines, IA

ETL & Reporting Developer

Responsibilities:

• Develop, document and support ongoing functionality of data driven applications to meet business needs.
• Creation of reports using SSRS, PowerBI, SSIS or comparable tools .
• Monitor and maintain integrity and tuning of databases in the environment, supporting or managing migrations, upgrades and enhancement as well as system checks and troubleshooting errors.
• Create database tables, views, stored procedures, Data Transformation Service packages and queries to support data driven applications and reporting.
• Coordinate and support outside development projects, including integrating third party software solutions and other outside tools and content.

Confidential, West Des Moines, IA

ETL & Reporting Developer

Responsibilities:

• Design, develop, test, deliver integration solutions using SQL Server Databases, SSIS ETL/Integration packages, and stored procedures.
• Analyze business requirements for external customer integration data feeds and internal application integration data requirements to define ETL mapping requirements.
• Develop test cases for Integration solutions to support high quality deliverables.
• Write T - SQL code, build SSIS ETL Packages using sound Integration design, data architecture, and high performance techniques.
• Develop and maintain reporting databases including tables, views, stored procedures, functions, triggers, etc.
• Troubleshoot data issue, validate result sets and recommend/implement process improvements.
• Interact with internal/external customers on a daily basis in a professional manner.
• Adhere to security and compliance standards.
• Maintain documentation and versioning control.
• Manage client and enterprise information and reporting needs.
• Develop and maintain SSRS reports and dashboards.

Confidential, West Des Moines, IA

Data Analyst

Responsibilities:

• Responsible for supporting reporting and project efforts related to participant retirement plans.
• Duties include combining data from multiple sources using query tools such as MySQL, SAS Enterprise Guide and MS Access, summarizing results into meaningful information and presenting the results to business partners and management.
• Project lead on participant web page tagging effort.
• Responsible for researching/reviewing all existing web page item tags for accuracy and functionality, as well as ensuring all elements the business requires for their reporting needs are represented.
• Also responsible for initiating JIRA trouble tickets when issues are located, or data elements that are untagged are located, and facilitating meetings with developers and business partners to coordinate QA review and production fix implementation.

Confidential, West Des Moines, IA

Analytic Consultant

Responsibilities:

• Responsible for very complex client/partner assignments to identify and define strategic business issues requiring database analysis and translates this information into insight, knowledge and understanding of the business and the industry.
• Using multiple databases, performs very complex analyses/analysis design involving data and comparative analysis.
• Responsibilities also include participating in and/or leading information capabilities development work and presenting the results of analyses and recommendations to senior management.
• Ensures adherence to data management regulations and policies. Responsible to lead project/virtual teams and mentor lower level staff.
• Handle multiple projects at the same time and meet strict/changing deadlines.
• Research data/report issues.
• Build scalable/maintainable data processes (SSIS, SQL stored PROCS, Triggers) and relational databases.
• Sophisticated Report/Dashboard Development using SQL Server Analysis services and SQL Reporting Services while adhering to change controls through Team Foundation Server and JIRA/MISBITS production tickets.
• Responsible for entire SDLC to include: project meetings, requirements gathering, development, QA testing, UAT, production deployment and ongoing support.
• Identify opportunities for reporting efficiencies (consolidation and streamlining) and data mining techniques from multiple systems such as DB2, SQL, Terradata and Oracle.
• Provide support to our customers with an emphasis on finance reporting, audit, and compliance requests, with a special emphasis on data integrity.
• Interaction with the customers to develop solutions that may result in customer files and/or reporting requirements including the development of complex file processes.
• Interact with non-technical team members and business partners to follow internal processes.
• Lead junior WFIS analysts and contractors in support of report automation. Interact with WFIS, other analysts and contractors in support of report.

Confidential, West Des Moines, IA

Database Analyst

Responsibilities:

• Gathering business unit requirements; researching various data source metadata; designing ETL processes, stored procedures, functions and RDL’s; testing processes in a UAT development environment, which includes working with the business unit to recruit UAT testers to validate the data/results and generating testing scripts; implementation through controlled deployment with release coordinators.
• These solutions vary in type and scale from quick-hit ad-hoc reports to new production reports, with moderate to large scope requiring new infrastructure processes, developing MS SQL Server BI 2008 SSIS packages, MS SQL Server Reporting Services, Teradata SQL queries, Oracle SQL queries and Shaw mainframe account modification queries.
• Develop, implement and monitor reporting system processes.
• Work with Confidential Servicing management and team members, Confidential Business Intelligence co-workers, and Confidential business partners to identify and/or update data and report needs.
• Develop new report and data processes. Partner with appropriate business personnel on User Acceptance Testing of new reporting. Document research and resolution methods related to report or process development. Complete activities as assigned related to Confidential Servicing reporting and/or business processes. Participate in various activities around data modeling, design, SQL code development, as well as planning and developing data architecture.
• Building reliable, scalable relational databases, tables and views.
• Provide consulting services in the identification and resolution of database and Reporting Services issues.
• Utilize extensive knowledge of SQL Server back-end development (ETL, transact SQL, DDL/DML), and strong Reporting Services development skills, with reliability and attention to detail. Demonstrated ability to quickly learn, retain, and apply business rules and terminology; apply good interpersonal skills; and perform effectively under time.
• Subject matter expert during the Customer Care transition to WFCC.
• Responsible for the daily monitoring of recurring processes and jobs that execute within the development and production environments.
• Issues are escalated appropriately within the Servicing team and to HEBI Architecture.
• Collaborates within the team to adhere to existing reporting conventions. This includes performing peer code review prior to deployment into development environment.
• Support SLA adherence with goal of 90% achievement from customers' viewpoint Maintain accuracy of data, information and processes.
• Implement actions that improve SLAs and uptime.
• Support the use of common tools.
• Ensure all compliance requirements are met.
• Ensure all information security requirements are met.
• Fully document all recurring processes and load into TFS for team reference.
• Develop and maintain daily checklist of responsibilities.
• Provide weekly update of accomplishments consistently and on time. Implement manual quality checks on critical reports including SDP Scorecards.
• Implement confidential folder structure for Customer Care reports on LPWVW6064.
• Ensure that all reports with confidential information have user access controls in place.
• Complete SLA documentation by the 15th of each month.
• Leverage the creation of user groups to help administer report and data access.
• Report/System optimization and performance tuning.