ms sql server bi developer resume example with 20+ years of experience
JessicaClaire
Montgomery Street, San Francisco, CA94105609 Johnson Ave., 49204, Tulsa, OK
H: (555) 432-1000
C:
resumesample@example.com
Date of Birth:
India:
:
single:
:
Career Overview
BI SQL Server Developer adept at application development, testing and optimization. Excels at Microsoft SQL Server application development, including coordinating ground-up planning, programming and implementation for core modules.
Qualifications
Programming and design skills
Strong analytical skills
Experienced Structured query language (SQL) developer
Excellent problem solving skills
Optimizing and performance tuning
Agile development methodologies
Requirements analysis and design phases
Profile Summary
Over 8 years of experience in analyzing, designing, tuning, and developing Client/Server, Business Intelligence (BI) database applications and various segments of Software Development Life Cycle (SDLC), using MS SQL Server.
Skilled in Business Intelligence tools like SQL Server 2008 Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
Expertise in Extracting, Transformation and Loading (ETL) data using various tools including Bulk insert (BCP), Import/Export data, DTS packages and SQL server Integration.
Hands on experience with Dimensional Modeling, ER Modeling, Star Schema / Snowflake Schema, FACT and Dimensional tables.
Created and Configured Data Source & Data Source Views, Dimensions, Cubes, Measures, Partitions, & MDX Queries using SQL Server 2008 Analysis Services.
Extensive experience delivering OLAP solutions by developing Corporate Dashboard Reports using SQL Reporting Services and Strategy Companion Analyzer.
Experience in creating Ad hoc reports and reports with complex formulas and to query the database for Business Intelligence.
Extensive SQL Development experience in the Retail industry with a strong understanding of data & analytics.
Experienced in creating Tables, Stored Procedures, Views, Indexes, Cursors, Triggers, User Profiles, User Defined Functions, Relational Database Models and Data Integrity in observing Business Rules.
Broad experience in Query Optimization and performance tuning of stored procedures, functions etc.
Experience in creating jobs, SQL Mail, Alerts and schedule SSIS Packages using SQL Server Agent.
Experience in scheduling and deployment of reports and uploading files to a report server catalog from the report manger.
A well-organized, goal-oriented, highly motivated and effective team leader/member with excellent analytical, troubleshooting, and problem solving Skill.
Technical Skills
RDBMS/DBMS: Microsoft -SQL Server 2008/2005.
BI / Data model Tools: Microsoft SQL Server Reporting Services 2008/2005, Microsoft SQL Analysis Services 2008, Microsoft SQL Integration Services 2008, Strategy Companion Analyzer.
Database Tools: SQL Server Management Studio, SQL Server Business Intelligence Development Studio, Visual Studio 2010, Visual Studio 2005, SQL Server Profiler.
Work Experience
MS SQL Server / BI Developer, 06/2005 - Current Sbarro LLC – City, STATE,
Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and understanding the functional work flow of information from source systems to destination systems.
Designed and developed SSIS Packages to import and export data from DB2, SQL Server, and Flat files.
Involved in daily batch loads (Full & Incremental) into Staging and Data Warehouse areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
Involved in Dimensional modeling by identifying the fact and dimension tables based on the user & reporting requirements.
Designed and implemented Dashboards and Scorecards with business KPIs using Strategy Companion Analyzer.
Involved in designing and generating Ad-Hoc reports as per the client requirements.
Responsible for creating datasets using T-SQL and stored procedures.
BPCS 4.05 CD software modifications and additions using RPG and CL.
Provide technical support for users
Year 2000 program and file conversions
RPG Programmer / Analyst, 11/1995 - 1999 Bruckner Supply Company, Inc. – City, STATE,
Performing full project life cycle development including analysis, design, coding, testing and debugging of RPG and CL programs
Responsible for extensive interfacing with users, developing and enhancing systems. These applications include Sales Analysis and Tracking, Accounts Receivable, Order Processing, and Inventory Management.
Education and Training
Diploma in Computer Programming: Computer Programming, Expected in 1994 - Briarcliffe Data System Institute - Woodbury, NY GPA: Status -
Bachelor of Science: Electrical Engineering Technology, Expected in 1992 - New York Institute of Technology - Central Islip, NY GPA: Status -
Any information uploaded, such as a resume, or input by the user is owned solely by the user, not LiveCareer. For further information, please visit our Terms of Use.