Developer Sql Server
Resume:
Elmer Parica
National City, California, 91950
ac6i18@r.postjobfree.com
Areas of Expertise
Programming: .NET / ASP.NET Frameworks 1.0 – 3.5, C#, VB.NET, VBScript, VB6.
Database: Microsoft SQL Server 2000 – 2008R2, T-SQL, DTS, SSIS, SSRS, SSAS, database diagrams, SQL Profiler, data normalization, transactional database design, data warehousing, referential integrity, index analysis, execution plan analysis.
Architecture & Design Patterns: Object Oriented Architecture & Design (OOD), N-Tier / 3-Tier Architecture.
Operating Systems and Platforms: Desktop: Windows XP/7/8, Server: Server 2003 / 2008, Information Services (IIS) 6.0 - 7.5.
Toolset: Microsoft Visual Studio Team System (VSTS) 2003 – 2008, Microsoft SQL Enterprise Manager 2000 – 2008R2, Microsoft Business Intelligence 2003 – 2008, Microsoft Report Builder 2.0 – 3.0, Microsoft Visual Basic 6.0
SUMMARY:
• More than 15 years of experience in Database Designing, Data Warehousing using MS SQL Server
2000/2005/2008/2008R2, both in OLTP and OLAP environments along with experience in Microsoft
Business Intelligence tools like SSIS, SSAS and SSRS.
• Experience in database design with T-SQL through conceptual Entity Relationship Diagrams and
Erwin.
• Expertise in creating database objects such as Stored Procedures, Tables, Constraints, Indexes, Views,
Indexed Views, and Triggers on SQL 2000/2005/2008/2008R2.
• Created Indexes, Views, Index views, Constraints, Stored Procedure, User-Defined functions, CTEs,
and effective DDL/DML Triggers to facilitate efficient data manipulation and data consistency.
• Experience in performing integrity checks. Methods include configuring the database maintenance
plan wizard and DBCC utilities.
• Experience in troubleshooting SQL issues by using SQL Tools, Execution Plans, Trace, Statistics and
Index Tuning Wizard.
• Experienced with the creation on SSIS packages in Data Extraction, Transforming, and Loading (ETL).
• Experience in Error Handling and Debugging packages using Checkpoints, Data Viewers, Breakpoints,
Event Handlers and Loggings (SSIS or Custom Loggings) and securing packages secured packages with
Encryption in conjunction with passwords.
• Created package configurations to provide an easy solution to migrating packages from different
business environments.
• Designed drill down, parameterized reports, linked, and cascaded parameterized reports using SSRS.
• Knowledge of applying various kinds of formatting on report data items at report level, as well as
using conditional formatting and templates.
• Experienced in sorting the data, defining subtotals for reports, and designing report layout.
• Experienced on setting up schedules for push and pull delivery methods for SSRS reports.
Experiences:
Phoneware – San Diego, CA (2003 – present)
Application Developer /SQL Developer / BI Developer
Current Position: Senior Programmer, SQL Developer, BI Developer.
Role Responsibilities and Accomplishments:
Built ASP.NET Windows application using .NET Framework 2.0 and VB.NET with SQL 2000/SQL2008 backend.
Played a major role in the development and support of SSRS project.
Migrated data from different sources (text based files, Excel spreadsheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS) and DTS Packages.
Examined and evaluates data structures in the source and destination databases.
Created Database objects including Stores Procedures, UDF, Indexed and Views using T-SQL in OLTP
Created pre staging and staging database as intermediate stage for populating Data Mart.
Created several ad hoc reports, drill down, drill through, sub, linked, cached and snapshot reports using SSRS.
Formatted and extended interactive SSRS reports by creating parameters within reports, multi value parameters as well as embedding functions with expressions.
Created many complex stored procedures and used them in Reporting Services directly to generate reports on the fly
Designed large number of reports using table filters, single value parameters, multi value parameters, dependent parameters and Cascading Parameters.
Optimized the performance of server by using SQL Server Profiler and text files generated from applications to resolve slow-performing issues
Bouton and Associates – San Diego, CA (2000 – 2003)
SQL Developer / BI Developer
Current Position: SQL Developer, BI Developer.
Designed, developed, or reviewed every element (tables, stored procedures, views, user defined functions, etc.) of the Anti-Money Laundering databases.
Played a major role in the production, design, support of SSIS Jobs.
Created SQL Agent Jobs to handle timed processes (daily, weekly and monthly data transfers,, database backup and database maintenance)
Interacted with various upstream and downstream customers in interfacing various systems for data extractions, ETL, Analytics and Reporting needs.
Migrated data from different sources (text based files, Excel spreadsheets, and Access, Oracle/Progress/DB2) to SQL Server databases using SQL Server Integration Services (SSIS)
Designed & developed ETL procedures, Data dictionaries, data mappings involving data analysis, data validations and data migrations
Created database objects like Tables, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers
Monitored and Tuned MS SQL Server databases with tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for optimal Performance.
Education
Bachelor of Science in Accounting
Philippine Air Force College, Philippines
Certification:
Licenses/Certifications
Microsoft Certified Professional - ID # 3064556
Microsoft Certified Solutions Developer for .NET
Microsoft Certified Applications Developer for .NET
References:
Gladys Leones Lito Dominguez
Account Manager DBA
Email: ac6i18@r.postjobfree.com Email: ac6i18@r.postjobfree.com
Tel: 1-408-***-**** Tel: 619-***-****
Steve Bouton
President Integrated Tracking System
Email: ac6i18@r.postjobfree.com
Tel: 619-***-****
Contact this candidate