We provide IT Staff Augmentation Services!

Ms Sql Server Developer/ms Business Intelligence Developer Resume

0/5 (Submit Your Rating)

Redmond, WA

SUMMARY

  • Over 8+ years of extensive experience in database activities like Data Modeling, Database Design and Development, Coding, Implementation, Maintenance and Performance Monitoring and Tuning using tools such as Index Tuning Wizard, SQL Profiler, Troubleshooting and Replication on Windows and Unix environments.
  • Experience in Analysis, Design, Documentation, Development, Testing and Implementation in Client/Server applications using Confidential SQL Server 2005/2008/2012 and BI Suite for various Business, Finance and Health care domains.
  • Expertise in Relational Database Management Systems using SQL Server 2000/2005/2008/2012.
  • Proficient in Database Programming and Development using SQL Server and good experience in creating T - SQL (DDL, DML), Triggers, Views, User Defined Functions and Complex Stored Procedures.
  • Expertise in Data Extraction and Transforming and Loading (ETL) using DTS package in MS SQL Server 2000 and SQL Server Integration Services (SSIS) in MS SQL Server 2005 with Import/Export data, Bulk insert and BCP.
  • Experience in SQL Server 2005 OLAP database development including KPIs, Data Mining, working with slowly changing dimensions (SCD).
  • Expert in creating Jobs, Alerts, SQL Mail Agent, Scheduling DTS packages.
  • Expert in Confidential SharePoint Server and IIS web server to produce sites for file sharing, web databases and web publishing.
  • Supported team in resolving SQL Reporting services and T-SQL related issues and proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Sub reports and formatting them.
  • Expert in using different Recovery Models simple, full and bulk-logged depending on availability of database.
  • Proficient in creating logical and physical data models using Erwin data modeling tool.
  • Managed full life cycle Custom Development for several business applications from inception to completion.
  • Ability to quickly learn and adapt to the rapidly changing Internet economy.
  • In-depth noledge in Object Oriented Concepts and experience in OOAD Technologies, developing Use Cases, Activity diagrams, Sequence Diagrams and Class Diagrams using case tools like Rational Rose.

TECHNICAL SKILLS

  • MS SQL Server 7.0
  • Confidential Visual Studio 2010
  • Confidential Reporting services
  • Windows 2000/2003 Advanced Server
  • Windows Exchange Server 2003
  • Windows NT 4.0/3.5
  • Windows9.x
  • Windows XP
  • Unix
  • Linux
  • Red Gate
  • MySQL
  • MS-Access
  • Oracle8.i
  • Oracle 9.i
  • C
  • C++
  • C#
  • T-SQL
  • Java
  • HTML
  • DHTML
  • ASP.Net
  • XML
  • Java Script
  • Perl Script
  • MS Visual studio 2005
  • Crystal Reports
  • ERWIN 7.1
  • Confidential SharePoint
  • Confidential Visio 2003

PROFESSIONAL EXPERIENCE

Confidential, Redmond, WA

MS SQL SERVER Developer/MS Business Intelligence Developer

Environment: MS SQL Server 2012/2008/2008 R2,SQL server Reporting Services 2008, SQL Integration Services 2008, Confidential Visual Studio 2010, SQL Server Management Studio, MS Excel, T-SQL, ERWIN.

Responsibilities:

  • Database planning in relation to physical and logical data architecture.
  • Analyzed business requirements and build logical data models that describe all the data and relationships between the data.
  • Created data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes).
  • Deploying new Database objects in production environment.
  • Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
  • Created different Parameterized Reports (SSRS 2005/2008) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
  • Create ad-hoc SQL queries for customer reports, executive management reports
  • Testing and loading the data on Development and Production.
  • Managing the use of disk space, memory and connections.
  • Running DBCC consistency checks, and fixing data corruption in application databases Monitor and tune SQL scripts.
  • Creating upgrade scripts for production database and supporting it.
  • Exported and imported data from text files and Excel to SQL Server database using bulk insert and BCP utility.
  • Checked Performance Tuning, Indexing, Query Optimization.
  • Worked with project manager and technical leads for resolution of technical issues.
  • Create reports based on data analysis and provide Heat-Mapping and Indicators in reports to halp in TEMPeffective handling of fraudulent activity.
  • Created UDF’s, triggers, Stored Procedures for maintaining real-time servers which has 3 months’ worth of data which pull data from data warehouse.
  • Created Indexes, both clustered and non-clustered for improving in performance as the tables contain huge pile of data.
  • Monitoring jobs to pull huge data into real-time server for analysis purposes.
  • Attending meeting with clients and upgrading and handling existing reports based on end-user requirements.
  • Carried out migration to a secure sandbox environment and implementing security levels, encryption and certification on the server to ensure safety to sensitive data.
  • Created cube for daily calculations of customer feedback based on different attributes and figuring out the satisfaction of customer and time and money spent on handling the call.
  • Created multiple SSIS packages and deployed them to pull in data from 5 different sources regularly and use stored procedures for modifications in data and obtained derived tables to be used in reports.
  • Involved in implementing SSIS package security, protecting packages, executing, monitoring and managing them.
  • Added filters, columns, parameters, color coding to existing reports for user - friendliness.
  • Monitored report manager granting access to end users based on level they need to look data at and providing the end-user with a clean and easily understood user-interface.
  • Automating and Daily monitoring of jobs, figuring out errors and solving any Blocking issues that arise

Confidential, Philadelphia, PA

MS SQL SERVER Developer/MS Business Intelligence Developer

Responsibilities:

  • Created Star schema dimension modeling for the data mart using Visio and created dimension and fact tables based on the business requirement.
  • Gatheird report requirements and determined the best solution to provide the results in either a Reporting Services report, Analytical Cube or an Excel pivot table
  • DesignedSSIS packages to Extract data from different sources like SQL server 2008,MS Excel, MS Access, transform and then load into Dimension and Fact tables in Data Warehouse using SSIS
  • Developed SSIS packages using for each loop in Control Flow to process all excel files within folder, File System Task to move file into Archive after processing and Execute SQL task to insert transaction log data into the SQL table
  • Produced operational reports in SSRS 2008 i.e. drill-down, drill-through, dashboard and matrix reports.
  • Developed SSAS Cubes for building reports using SQL Server Business Intelligence Development Studio to support reporting and forecasting processes
  • Wrote complex SQL queries and stored procedure to create reports using SSRS 2008 from the relational database and OLAP as SSAS 2008 source
  • Generated monthly and quarterly reports as bar charts for the management using different techniques like data filtering, adding interactivity, deploying reports to report server using SSRS
  • Converted manual reports pasted together into parameter driven stored procedures to be used with Confidential Reporting Services 2008
  • Attained legacy data to use as a source to develop new reports previously compiled and maintained manually
  • Developed functional and technical documentation to assist in the design, development and/or maintenance of deliverables
  • Created SSRS Data Model projects using Confidential Visual Studio 2008 and using Report Builder for report server to create reports
  • Configured the report server and generated the report models for user interactions
  • Responded to ad hoc requests and special projects that require immediate attention while at the same time maintaining deadlines on existing requests.
  • Developed and maintained system documentation, diagrams and flowcharts.
  • Worked with project manager and technical leads for resolution of technical issues.

Confidential, Troy, MI

MS SQL SERVER/SSIS/SSRS Developer

Environment: MS SQL Server 2005/2008, SQL Server Reporting Services 2005/2008, SQL Server Integration Services 2005/2008, MS Excel, MS Windows Server 2003, Oracle 10g/9i.

Responsibilities:

  • Migrating databases from SQL 2005 to SQL 2008 in production and test environments.
  • Wrote complex queries, DDL, DML, functions, triggers, stored procedures, and views for new and existing applications.
  • Used SSRS to create, execute, and deliver tabular, matrix, and charts reports.
  • Designed, developed, modified and enhanced the database structures and database objects.
  • Used conditional formatting to change the behavior of the report depending upon the requirement.
  • Debugged and deployed reports in SSRS.
  • Generated various Report models on Views (due to security issues) and deployed them on to the production reporting server and generated various Report models and ad-hoc reports.
  • Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report according to the requirement.
  • Created standard report Subscriptions and Data Driven report Subscriptions
  • Created several SSIS packages in Confidential SQL Server 2005.
  • Transferred data into various formatted files and immediately updated my managers with the automated email systems.
  • Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases
  • Tuned several slow running queries in Production. Implemented Indexes to achieve time performance.
  • Used config files in SSIS to ease the process of moving the packages across servers (development to production)
  • Used Confidential SharePoint Server to provide a framework for web application development.
  • Optimized queries by looking at Execution Plan for better tuning of the database.
  • Monitored, optimized and Performance Tuning of Regression Servers using Performance monitor, SQL Profilers, Activity Monitor.
  • Tested applications for performance, data integrity, validation issues, job scheduling and alerts.

Confidential, Moosic, PA

MS SQL Server/SSRS/ SSIS Developer

Responsibilities:

  • Installed, upgraded and migrated databases from Oracle database to MS SQL Server 2005/2008.
  • Created business process diagrams defining current business processes.
  • Generated reports using MS SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
  • Developed ad-hoc reports, drill through reports, drill down reports, parameterized reports, and other report models using MS SQL Server 2005 SSRS.
  • Constructed the OLAP cube using SSAS and used SSIS to transform the data into OLAP.
  • Created T-SQL queries for schemas, views, stored procedures, triggers and functions for data migration. Involved in the project from planning stage to pushing codes to production.
  • Designed ER diagrams and mapped the data into database objects and performed normalization of the database in OLTP.
  • Scheduled Cube Processing from Staging Database Tables using SQL Server Agentusing SSAS.
  • Wrote MDX scripts to create name sets and calculated members and created reports by dragging data from cube in SSAS.
  • Worked as a technical expert in the design, development, and maintenance of OLAP cubes and databases
  • Created new logical and physical design of database to fit new business requirement and implemented new design into SQL Server 2005.
  • Performed system study and requirements analysis, prepared data flow diagrams, entity relationship diagrams, data diagrams, and table structures to store the data.
  • Created SQL scripts to insert/update and delete data in MS SQL database. Created database tables, wrote stored procedures to update and clean the old data and also halped the front end application developers with their queries.
  • Created SSIS packages to import and export data from Excel, Xml and Text files and transformed data from various data sources using OLE DB connection by creating various SSIS packages.
  • Designed and created different ETL packages using SSIS and transferred data from Oracle source to MS SQL server destination.
  • Performance tuning of SQL queries and stored procedures using SQL profiler and index tuning advisor.
  • Configured SQL mail agent for sending automatic emails on errors and developed complex reports using multiple data providers, user defined objects, charts, and synchronized queries.
  • Used business object tools to develop reports and accessed, formatted, and delivered information to large populations of users.
  • Developed complex reports using multiple data providers, user defined objects, charts, synchronized queries, and created star schema in SSAS to develop ad-hoc reports for the clients as per their requirements using SSRS in MS SQL 2008.

Confidential, Tampa, Florida

MS Business Intelligence Developer

Responsibilities:

  • Migrating databases from SQL 2000 to SQL 2005 in production and test environments.
  • Gatheird user requirements and analyzed and designed software solution and database.
  • Updated functional specification and technical design documents.
  • Created complex Stored Procedures, triggers, tables, views and SQL joins and statements for applications.
  • Developed T-SQL (DDL-Data Definition Language, DML-Data Manipulation Language) statements using dynamically generated SQL.
  • Implemented triggers for automating tasks.

Confidential

SQL Server Developer

Responsibilities:

  • Involved in gathering user requirements, draft specifications, design and create Database objects for performance tuning.
  • Part of team for analyzing and implementing the physical design for the database.
  • Responsible for drafting documentation for describing the metadata and writing technical guides.
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
  • Involved in Implementation of database design and administration of SQL based database.
  • Optimized queries and stored procedures.
  • Wrote T-SQL procedures to generate scripts that modified database objects dynamically based on user inputs.
  • Created Stored Procedures to transform the Data and worked extensively in T-SQL for various needs of the transformations while loading the data.
  • Created Stored Procedures, Triggers, Tables, Views and SQL Joins and other statements for various applications
  • Responsible for transferring of the databases and database objects from Development to Production Server using DTS.
  • Analyzed and tuned complex Queries/Stored Procedures in SQL Server 2000 for faster execution and developed database structures

We'd love your feedback!