Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download
OBJECTIVE
Reporting
Solutions Developer and data warehouse developer in an environment where I can continue to advance my skills in
Reporting Design, Data Warehousing, OLAP, Dimensional Cubes and Analysis
Services
EXPERIENCE
Providence Hospital (K-Force) 2/1/2011 - Present
Database/Report
Developer
- Created stored procedures in
T-SQL for all reporting
- Developed Crystal Reports from
Remedy (Business Objects) with complex statistical graphing
Epiq Systems (Van Der Houwen) 2l2/2010
-7/1/2010
BI
Developer/.NET Developer
- Created stored procedures in
T-SQL for all reporting
- Developed SSIS packages both as
ETL to load into databases and data source for SSRS reports
- Created reports displaying
transactional data accessing heterogeneous data sources
- Wrote applications to access
data and deliver encrypted files to client ftp sites (an automation
project)
- Developed QA processes for
moving applications from a development environment to production.
- Authored utility (console)
applications in C# to drive check printing operations, system utilities
- Designed and implemented Data
Marts for efficient reporting data sources
Microsoft (ExcelData
Contractor) 3/17/2009-06/30/2009
Report
Developer/.NET Developer
- Financial reporting for
Corporate. Executive views and Accounting views
- Created reports displaying
Profit/Loss in Excel as pivot table reports
- Developed report templates for
consistent presentation to users and could be used for ad hoc user defined
reports
- Maintained and created schema
changes to the data warehouse used as reporting source, new tables, stored
procedures in T-SQL and functions to support ongoing development and new
requirements.
- Designed and created Data Marts
for SSAS and SSRS consumption
- Authored C# assemblies to be
consumed by SSIS packages for complex data manipulation and
transformations that were not supported by SSIS (data typing)
Microsoft (Volt Contractor) 3/17/2008-11/7/2008
Report
Developer/.NET Developer
- Gathered requirements from
managers and other stakeholders to develop a suite of reports and
infrastructure to support online report access
- Created reports displaying
server/network performance metrics for Microsoft Live Storage project.
Reports were complex and used numerous sub reports for drill-down detail.
- Developed report templates for
consistent presentation to users and could be used for ad hoc user defined
reports
- Maintained and created schema
changes to the data warehouse used a a reporting source, new tables,
stored procedures and functions to support ongoing development and new
requirements.
- .NET web application for
internal manager reporting portal.
Triad (Integra Telecom) 8/2006-3/2008
VB
Developer/Report Developer/.NET Developer
- Work performed in IT department
for mostly internal reporting and applications
- Authored stored procedures
(T-SQL) for SSRS reports
- Added functionality to existing
VB6 applications (new screens, classes, and related database queries to
support the app)
- Worked with team in converting
some VB6 apps over to C#. NET
- Converted Crystal reports for
billing and marketing reports to SQL Server Reporting Services. Extensive
report writing, close to one hundred reports authored for management teams
throughout the organization.
- Extensive use of SQL Server
Open query to obtain information from the production billing system
running on an instance of Oracle
- Gathered requirements for new
applications and reports from non-technical users
- Performance tuning of Data
Warehouse that was populated from an instance of Oracle using SSIS
Star Technical (Safeco) 12/2005-4/2006
Data
Warehouse/Report Developer/.NET Developer
- Designed and built automated
cube processing, archiving and restoration system for Analysis Services
- Extensive use of NT scripting
and windows scheduler to implement cube processing automation and related
tasks.
- Designed Reporting Services
reports against a TeraData database warehouse using both 2000 and 2005
versions.
- Created and maintained
.NET website for Business Intelligence group
- Designed and built SQL Server
database for Work Order Tracking system for the Demand Management team
- Team member on Demand
Management developing processes and procedures using the Work Order System
I designed
- Worked with Business Analysts
gathering requirements for customer requests and developing solutions for
them.
- Worked with SQL server 2000,
2005 and .NET 2005
- Authored numerous stored
procedures in T-SQL for consumption by SSRS and many SSIS packages for
populating data ware house and cubes (SSAS)
- Developed and maintained .NET
website using C# for presentation
of cubes to internal analysts
Safeharbor Technologies,
incorporated 5/2002-11/2005
Data
Warehouse/Report Developer
·
Created
Stored procedures for Crystal Reports and MS Reporting Services
·
Designed
application to configure and deploy client facing report websites
·
Created
MS Analysis Services cubes for internal analysis of client activity
·
Automated
call center reporting and internal reporting saving several thousand man hours
of manual effort
·
Wrote
ETL process for loading fact and dimension tables for cubes utilizing SQL
Server DTS
·
Chaired
user groups that spanned business units in the company for intercommunication
and feedback documenting data and reporting requirements to be used in
designing reporting proposals
·
Developed
ASP websites for external customers to review their activity
VoiceStream Wireless (Bellevue,
WA) 2/2000-5/2002
Data
Analyst/Developer/Database Architect
·
Designed
and built SQL Server Databases, Analysis Cubes, Applications and Websites to
publish data via a corporate Intranet. Built a Website portal for separate
departments.
·
Put
into production an Analytic Cube for Call Center Collection Payments, which
measures performance by Representative at their location. Utilized SQL Server
DTS to connect to production server, which gathers data, performs an ETL, runs
data into a fact tables and dimension tables, and performs incremental process
on Cube. This is an automated process.
·
Created
Visual Basic Applications with embedded Crystal Reports, including sub-reports,
master links, hyper links, and key-field links. This linked to both SQL Server
7.0 and Oracle 8i DB’s.
·
Responsible
for interviewing Managers, DBA’s, Developers and Dept. Directors to gather
requirements for their unique reporting needs.
·
Provide
Ad Hoc report services for different teams, including Fraud, Sales &
Marketing and Accounting. Reports are published on-line using Crystal Reports
and SQL 2000 Analysis Services.
·
Currently
provide Analytic Cubes for individual and business accounts for Financial
Systems Analysts in Tampa, FL.
·
Regularly
merge application data from ONYX and account data from SAMSON, the production
billing system from AMDOCS utilizing SQL DTS and SAS.
·
Provide
data mining services using decision tree from SQL Server Analysis Services and
several 3rd party tools, including Knowledge Seeker and SAS
Enterprise Miner.
·
Created
dashboards for management tracking leading KPI’s and automated notification of
events that required management overview
·
Tools: SQL Server 2K,
Crystal Reports version 7 and 8.5, Oracle 8i, Informatica, Access, Excel,
Visual Studio
PED Manufacturing, Ltd. (Oregon
City, OR) 1/1999
– 2/2000
Senior
Programmer/Analyst
·
Responsible
for maintaining four SQL Server 6.5 databases and two instances of Oracle and
Visual Manufacturing software, barcode hardware and software, QA applications,
parts certification software, and e-mail using MS Exchange Server and Proxy
server.
·
Programmed
Access and VB6 interfaces for reporting, sales analysis and forecasting
utilizing various 3rd party reporting tools with extensive use of
very complex Crystal Reports 7.0 and Active Reports.
·
Developed
numerous applications for reporting, HR applications for OSHA reporting, and
mission critical part certification for medical parts. Converted existing SQL
Server 6.5 databases to 7.0
·
Functioned
as DBA for SQL Server 6.5 and 7.0 databases as well as several instances of
Oracle.
·
Designed
and programmed reporting and analytical applications against SQL Server and
Oracle databases
ADT Solutions (Sherwood, OR) 1998
- 2000
Programmer/Analyst
·
Designed
Corporate Database to consolidate data existing in separate applications;
built-in web functionality to provide for remote data access and record entry
via a web browser.
·
Utilized
Crystal Reports to print invoices and employee timesheets.
·
Designed
Corporate Presence website and links to the corporate database for timesheet
entry, document posting, and data access.
·
Designed
and built office intranet with Windows NT 4.0 as server platform with
cross-platform connectivity (Macintosh, Windows, and various flavors of Unix).
·
Responsible
for network security, data integrity, and computer training for management and
staff
·
Developed
an ASP database using SQL Server 7.0 and IIS4 for employees in remote locations
to enter timesheets and project documentation over the Internet; adding dynamic
content and functionality to ADT’s website.
·
Built
office intranet, firewall and security utilizing Windows NT 4.0 with TCP/IP and
transparent cross-platform connectivity.
Hosts, Inc. (Vancouver, WA) 1997 - 1998
Programmer/Database
Architect
·
Member
of design team for SQL Server 6.5 implementation for the Houston School
District, TX.
·
Responsible
for data conversion of existing in-house databases to the SQL Server
application.
·
Programming
for the Houston database and database administrator for the database and
in-house systems.
·
Responsible
for network administration while CIO was absent during vacations and
conventions.
·
Developed
new functionality and optimized existing code on IBM Compatible and Macintosh
platforms.
·
Ported
core products from Macintosh to PC platform
Columbia Learning Systems
(Vancouver, WAhttps://docs.google.com/uc?id=1qB-ttDmuoPi3-frpH-H_Y7tbEZ3msziK&export=download) 1994
- 2000
Partner,
Programmer
·
Responsible
for technical issues, Application design, and technical support for various
clients.
·
Responsible
for programming and contributions to user interface design issues.
·
Developed
a platform-independent model for statewide IEP reporting and administration to
be used in special education programs.
This model utilizes a distributed thin client web accessible database
for data entry retrieval and report generation.
·
Developed
a client/server RDBMS currently in use at Goldendale School District, Washougal
School District, and Ocosta School District.
·
Developed
an integrated system of multiple stand-alone versions is in use at ESD 112 in
Vancouver, WA.
·
Current
Projects: building browser-based access to current products and porting over to
SQL Server 7.0 and Oracle.
EDUCATION
Computer Programming 1998
– 1998
WASU Vancouver, WA
Completed
courses on Object-Oriented Program, Analysis and Design RDBMS systems,
Relational and object-oriented Programming, Language Development, and Compiler
Development.
Computer Sciences Curriculum,
Personal Programming Projects 1997 – 1997
Whatcom
County Community College, Bellingham, WA
Mathematics
1971
– 1973
Idaho
State University Pocatello, ID
Download Resume Format
0 comments:
Post a Comment