Daniel Estrada - Business Systems Analyst

Daniel Estrada

556 Susan Dr, King of Prussia, PA 19406 http://www.linkedin.com/in/danielestrada [email protected] C - (856) 816-5288

CAREER OBJECTIVE To obtain a position that will leverage my five-year experience as a business analyst and twelve-year technical background, as well as my database development and reporting experience.

BUSINESS / TECHNICAL SKILLS Soft Skills

Disciplines Databases

Programming Operating Systems Business Applications Language

Plan and manage a set of concurrent projects; Lead a group of subject matter experts and information technology professionals through a business problem definition process; Analyze business problems to separate problems from symptoms and predetermined solutions; Data Warehousing, Database Development, Database Reporting, Learning Management Systems, Project Management, Application Life Cycle Development, Web Development. Knowledge of SQL Server. Design, Normalization, Mapping, Report Development. Extraction, Transformation, and Load (ETL). Teradata, Oracle, SQL, PL/SQL, Crystal Reports, MySQL, Microsoft Access, SQL Plus, SQL Navigator, Toad. Apprentice knowledge of SQL Server. Unix Korn Script, Java Script, HTML, ASP, PHP, C, C++, .Net, Power Builder, Visual Basic. Windows Vista/2003/XP, Unix/Linux/Solaris. Microsoft Office, Microsoft Project, Visio, SumTotal, Pedagogue Profiler. Fluent in spoken and written Spanish.

PROFESSIONAL EXPERIENCE Independence Blue Cross – Independent Contractor: Business Systems Analyst Integrated Customer Reporting Deployment

• • • •

Philadelphia, PA 2008 to Present

Identified quickly the final phase project needs, channeling team efforts to develop, system test, user acceptance test to deploy nineteen (19) client reports on an aggressive time schedule. Assisted user acceptance test team by building SQL statements that follow the same report functional specifications to then run all scenarios. Built consensus between business clients and developers to come up with the best business and technical solution for each report to present final solution to the business clients for sign off. Documented each solution for all business requirement, prototype and functional specification documents.

Retire DB2 mainframe databases

• • • •

Compile eleven (11) mainframe processes data needs to build a common parameter and extract layout. Identify field gaps between common data requirements and Active Enterprise Data Warehouse (AEDW) by using the source to target mapping documentation and sampling DB2 and Teradata databases. Negotiate field gaps with developers and business clients to reduce the amount of fields to be backfield into AEDW. Joined efforts with BI team gathering UI needs to recreate and improve Legal Department interface built to replace application connecting to DB2 databases.

Wyeth Pharmaceuticals – Alliance Consulting: Business Systems Analyst 2004 to 2008

Collegeville, PA

Managed Student Evaluation System Upgrade (Pedagogue Profiler 2.0)

• •

Coordinated the rewrite of the Student Evaluation System to accommodate new business rules and GUI needs for 5,000 users

• • • •

Supervised the development efforts of internal and third party software vendors.

•

Managed full life cycle of the project including requirements, design, development, test and deployment. Reviewed and approved third party software vendor requirements gathering and documentation. Ensured that business owners and end-users were appropriately engaged in design decisions and development activities Developed and engaged testing efforts to find feature and design flaws. Recognized for delivering a user intuitive and feature complex system on time, within cost, and with no help desk calls when deployed.

•

Utilized Microsoft Project, Visio, Oracle, SQL Navigator, and PL/SQL.

Created Oracle Star Schema and rewrote Crystal Reports for Learning Management System (SumTotal 7.1)

• • • • •

Redeveloped reports to better monitor and assist 60,500 students worldwide. Process over 1.8 million training records daily by means of scheduled jobs and oracle package with emphasis on fast processing PL/SQL. Led requirements gathering sessions with senior management and end users, creating a list of improvements including a new security feature based on what domains the report administrator can view. Created MS Access repository, documenting and managing tool to track reports’ phases of development, enhancements, issues and resolutions by logging efforts and report details. Self taught new learning management database to support the development of new reports. Utilized Oracle PL/SQL, Crystal Reports and SQL Navigator.

Led the Integration of a new Learning Management System Module

• • • • •

Integrated new training module into existing Learning Management System (LMS). Performed extract, transformation, and load of historical data from source system into the LMS. Performed data integrity checks to ensure data definitions a preserved during the conversion. Identified and logged issues with converted data. Developed plan to correct the data in the destination database. Utilized Oracle PL/SQL, Unix and SQL Loader.

Developed Oracle Crystal Reports for Aspen 2.5 Learning Management System

• • • • •

Created over 80 reports based on client’s business needs using stored procedures and/or Crystal Reports SQL statements. Assisted the client in developing business requirements. Managed the requirements review and sign off process. Designed and developed reports using client defined standards and procedures. Tested and deployed finished reports. Provided reports training to end users. Provided end user support to mitigate issues with report results and data input issues. Utilized Oracle PL/SQL, Crystal Reports and SQL Navigator.

Subaru of America: Developer/Business Analyst 1999 to 2003

Cherry Hill, NJ

Deployed and Maintained new Ingenium Learning Management System Module (LMS)

• • • • •

Gather business system knowledge from end users. Developed project scope, business requirements, and project time line. Managed complete life cycle of the project including planning, design, development, testing, and deployment. Developed the Interface between the LMS and the human resources employee database. Translated business rules into Oracle stored procedures that were used to cleanse 1.5 million training records. Utilized Oracle PL/SQL, SQL Plus, SQL Loader, UNIX shell script, Crystal Reports, IIS, ASP and HTML/Java Script.

American Management Systems: Developer/Business Analyst Virginia Department of Taxation Consultant

Fairfax, VA 1998 to1999

Development of Compliance Management System

• • •

Customized the Customer Compliance Management System that identifies and manages non-compliant taxpayers. Gathered requirements from business owners and end users. Designed and developed the customizations. Developed code using Power Builder and C development.

Developed Interface Generator for State Bankruptcy System

• • •

Led technical team to develop the Bankruptcy Interface Generator, which transferred data from Virginia Bankruptcy Courts websites to the state Bankruptcy systems. Analyzed, selected and acquired appropriate hardware and software for Bankruptcy group. Developed code using Visual Basic.

One Beacon Insurance: Analyst/Technician

• • •

Provided Desktop and Network Technical Support to 30 insurance branch offices. Resolved hardware and software issues as well as network and mainframe connectivity issues. Gained experience in Microsoft Windows, UNIX, HTML, and Java Script.

Philadelphia, PA 1997

EDUCATION Drexel University, Philadelphia, PA Bachelor of Science, Information Systems (1998)

PROFESSIONAL ORGANIZATION Member of Society of Hispanic Professional Engineers, Greater Philadelphia Chapter (1998 to present) Secretary and Webmaster (2002-2007)

Created, maintain and administer SHPEGPC.org website. Assisted in reorganization and reactivation of chapter which resulted in 30% increase in membership.

Logistics Chair (2002) Assisted guiding and organizing logistics for 22 Eastern Technical Career Conference committees hosting event attended by 1500 students and professionals.

Provisions and Logistics Coordinator (2001)

Successfully supplied food-catering support to 100 regional members for 8 meals at SHPE Regional Summer Bash camping trip.

National Institute for Leadership Advancement (NILA)

Voted by Executive Board to attend NILA, where I coached student case study team to win third place out of 38 teams.