We provide IT Staff Augmentation Services!

Server Developer Resume Profile

Professional Summary:

  • Proficient in installing, configuring, managing, upgrading and migrating ,Backup/Restore, monitoring and troubleshooting SQL Server 2008 R2/2005.
  • Over 10 Years of IT experience which includes System Analysis and Design, Development Support of MS SQL Servers 2008 R2/2008/2005/2000 in Production, QA and Development Environments.
  • Strong experience with T-SQL DDL DML in Implementing Developing Stored Procedures, Triggers, Nested Queries, Joins, Cursors, Views, User Defined Functions, Indexes, User Profiles, Relational Database Models, Creating Updating tables and checking the database consistency by executing DBCC Commands.
  • Extensively used tools like Database Engine Tuning Advisor, SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
  • Expertise in SQL Server Reporting Services SSRS , SQL Server Integration Services SSIS and in SQL Server Analysis Services SSAS in Business Intelligence BI .
  • Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and Event Handlers, Error Handlers etc.
  • Transformed data from one server to other servers using tools like Bulk Copy Program BCP , Data Transformation Services DTS 2000 and SQL Server Integration Services SSIS 2005/2008 R2 .
  • Excellent knowledge of Scheduling Jobs and Alerts using SQL Server Agent.
  • Ability to work in all stages of System Development Life Cycle SDLC .
  • Proven ability to develop Dashboard, Ad-hoc and Parameterized Reports, Create complex reports ex: drill down reports using different objects using SSRS.
  • Configure and maintain Report Manager and Report Server for SSRS, Deployed and Scheduled the Reports in Report Manager.
  • Solid understanding of Integration of SSRS Reports using various web parts into Sharepoint MOSS 2007 and various delivery mechanisms.
  • Exceptional ability in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
  • Strong Experience in Creating, Configuring, Deploying and Testing SSIS Packages.
  • Worked extensively on Extraction, Transformation, Loading data from Oracle, DB2, Access, Excel, Flat Files and XML using DTS, SSIS.
  • Good understanding of Normalization /De-normalization, Normal Form and database design methodology. Expertise in using data modeling tools like MS Visio and Erwin Tool for logical and physical design of databases.
  • Experience in Data Marts, Data warehousing, Operational Data Store ODS , OLAP, Data Modeling like Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling, FACT and Dimensions Tables using MS Analysis Services.
  • Solid ability to create OLAP cubes using SQL Server analysis services SSAS .
  • Worked with Business Analysts, Web development team, and users on database solutions.

Business Technical Skill:

MS SQL Server 2012/2008 R2/2005/2000, MS Access, My SQL SSIS 2005/2008/2012,SSRS 2000/2005/2008 R2, DTS, SSIS, Management Studio, Visual Studio, C, C , Shell Scripting, SQL, XML, C , VB.NET, MDX, Windows NT 4.0,Windows 2000/2003/2008 R2 Enterprise/Datacenter Server, XP Professional, UNIX

Project Summary:

Confidential

Sr.SQL Server Developer SSIS/SSRS/SSAS Developer

Responsibilities:

  • Worked with application developers and production teams across functional units to identify business needs and discuss solution options.
  • Took part in Architectural team to Design the Application which follows Company standards and requirements.
  • Agile methodology was used throughout the project. Performed pivotal role in planning and developing as well as aligning with the assigned sprints.
  • Studied and analyzed similar applications and brainstormed with business team to gather effective requirements for the system along with dashboard development.
  • Worked with development teams in the design of physical databases and in modification.
  • Formulated and documented the physical ETL SSIS process design based on business requirements and system specifications with strong ETL SSIS design skills, including source to target mappings, transformations, lookups, aggregations, expressions.
  • Highly responsible for scheduling and delivery of jobs using SQL Server Agent. Performed T-SQL tuning by using Database Engine Tuning Advisor for long execution plans.
  • Transformed complex business logic into database design and maintaining it by using SQL objects like store procedures, User defined functions and Views.
  • Studied and analyzed similar applications and brainstormed with business team to gather effective requirements for the system along with dashboard development.
  • Configure SSIS Email attachment task for sending automated alerts/email with Alerts for successful or unsuccessful completion of SSIS packages with appropriate error message.
  • Generated Daily, Weekly, Monthly, Subscriptions, Dashboard reports for the analysis of managers and end users by using SSRS.
  • Responsible for ongoing maintenance and change management to existing reports and optimize report performance SSRS .
  • Validated reports to ensure quality of data and conducted Meetings with business users to review reports and obtain continuous feedback.

Confidential

Sr.SQL Server Developer/SSIS/SSRS/SSAS Developer

Responsibilities:

  • Gathered user requirements to develop the business logic and analyzed and designed database solutions.
  • Transformed complex business logic into database design and maintaining it by using SQL objects like store procedures, User defined functions and Views.
  • Created SSIS packages to extract data from OLTP data sources to data warehouse systems and scheduled jobs to call the packages.
  • Developed logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
  • Developed a packages to handle data cleansing, loading multiple files and executing tasks multiple times using for each loop container.
  • Developed Master Child Package using Execute Package Task and Parent Package Variable Configuration.
  • Developed a package that transfer multiple files between local machine and FTP server using FTP task in SSIS.
  • Identified data source and data views for building the OLAP cube in SSAS.
  • Identified and defined Fact relationships, calculated members while designing OLAP cubes in SSAS.
  • Created OLAP cubes using SSAS to analyze the business condition of the sales.
  • Wrote MDX queries and expressions for use in Front End BI Applications.
  • Created KPI Objects in line with Requirement Docs.
  • Optimized cubes for better query performance and aggregated cube with 40 performance for better performance.
  • Processed cube to perform incremental updates.
  • Wrote MDX expressions to create name sets and calculated members
  • Wrote complex queries for the drill down reports and used conditional formatting using SSRS.
  • Scheduled and monitored all maintenance activities of SQL Server 2008 R2 including database consistency checks and index defragmentation.
  • Created Parameterized, matrix and drill down reports and dashboards using SSRS 2008 R2.
  • Used SSIS to transfer data from various sources like SQL Server, MS Access to be used for generating reports using SSRS 2008 R2.
  • Used complex expressions to group data, filter and parameterize reports.
  • Performed various calculations using complex expressions in the reports and created report models.
  • Designed and optimized indexes, views, stored procedures and functions using T-SQL
  • Helped designing and implementing processes for deploying, upgrading, managing, archiving and extracting data for reporting.
  • Performed maintenance duties like performance tuning and optimization of queries, functions and stored procedures.
  • Deployed the generated reports created using SSRS 2008 R2 on to the server.

Confidential

Sr.SQL Server Developer/SSIS/SSRS/SSAS Developer

Project Environment:

Windows 2008 R2/2003 Server, MS SQL Server 2008 R2/2005, BIDS, ASP .NET, XML, SSIS, SSRS, SSAS, Service Broker

Responsibilities:

  • Worked in creating complex Stored Procedures, triggers, cursors, tables, views, joins and statements for applications. Developed complex T-SQL code for the application.
  • Involved in designing the physical databases model on SQL Server 2008 R2 RDBMS using different Data Definition and Data Manipulation languages DML/DDL implementing constraints and triggers for data integrity in development database for Warehouse system.
  • Extensively used T-SQL to manipulate and architect to produce results for users.
  • Performance tuning of Queries and Stored Procedures.
  • Worked with development teams in the design of physical databases and in modification.
  • Creating Tabular, Matrix reports also called as crosstab or pivot , Charts and graphs as per customer requirements Using SSRS.
  • Experience in Microsoft Reporting Service SSRS with Report authoring, Report management, Report delivery and Report security.
  • Created and developed query for Drill Down and AD Hoc Reports using SQL Server 2008 R2 Reports Services SSRS .
  • Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SSIS and DTS.
  • Proficient in SSIS process design architecting the flow of data from various sources to target.
  • Used SSIS to create ETL packages .dtsx files to validate, extract, transform and load data to data warehouse databases and process SSAS cubes.
  • Designed SSIS Templates for developing SSIS Packages in such a way that they can be dynamically deployed into Development, Testing and Production Environments.
  • Generated and Deployed ETL SSIS packages both design and code to process data to target databases.
  • Developed complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Exceptional ability in calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
  • Used efficient task objects/connections/work flows in packages based on data volumes and data sources.
  • Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance

Confidential

SQL Server Developer/SSIS/SSRS/SSAS Developer

Project Environment:

SQL Server 2008 R2 Enterprise Edition, .Net 3.5,SQL BI Suite SSAS, SSIS, SSRS , Enterprise manager, PPS, XML, MS PowerPoint, MS Project, MS Access 2003 Windows Server 2003, Oracle, Crystal Reports, Cognos, Business Objects ,SharePoint,MOSS 2007

Responsibilities:

  • Developed various complex reports and manage those using SQL Server Reporting Services SSRS 2008 R2 .
  • Generated Custom ETL scripts using SSIS 2008 R2 and develop and unit test SSIS load processes for performance check.
  • Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
  • Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
  • Involved in development and implementation of SSIS, SSAS and SSRS application solutions for various business units across the organization.
  • Used SSIS for ETL processes, SSRS for Reporting needs and SSAS for Analytics reporting including SharePoint integration.
  • Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Fuzzy Grouping, Script Components, error handling.
  • Created Tabular reports, Matrix reports, List Chart reports, Parameterized reports, Sub reports, Ad-hoc reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
  • Designed SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
  • Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
  • Wrote and integrated stored procedures to generate the special reports according to client's need.
  • Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.
  • Deployed designed PPS dashboards reports in MOSS site using PPS Dashboard viewer Web Part for web based access for multiple end users.

Confidential

SQL/SSIS/SSRS/SSAS Developer

Project Environment:

MS SQL Server 2005/2000, DTS, T-SQL, XML, Flat File, SQL Server Reporting Services, Visio, IIS, Windows XP/2000

Responsibilities:

  • Created complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications following SQL code standards.
  • Understand user requirements and Data Model defined and developed by the business analysts and data architects.
  • Extract, Transform and Load source data into respective target tables to build the required data marts.
  • Performed DBA tasks like Backup, Restore of tables and Stored Procedures and Refreshing Database on weekly basis.
  • Implemented different types of constraints on tables.
  • Designed and applied entity and attributes description and definition for the models.
  • Managed indexes, statistics and tuned queries by using execution plan for optimizing the performance of the databases.
  • Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler.
  • Migrated data from SAS environment to SQL Server 2005 with SQL Server Integrated Services SSIS .
  • Created ETL process using SSIS to transfer data from heterogeneous data sources.
  • Developed logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
  • Migrated DTS objects to SQL Server Integrated Services SSIS environment.
  • Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
  • Proficient in gathering business requirements to create business user reports.
  • Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2005.
  • Developed optimal stored procedures and queries to create data sets for reports.
  • Designed and implemented stylish report layouts.
  • Generated Reports using Global Variables, Expressions and Functions for the reports.
  • Responsible for scheduling the subscription reports with the subscription report wizard.
  • Played a Content Manager role on report server.
  • Worked on performance tuning on existing stored procedures and existing reports for the faster processing of reports.

Confidential

MS SQL Developer/SSRS, SSIS Developer

Project Environment:

MS SQL Server 2005, MS SQL Server 2000, Windows 2003 Server, T-SQL, SSIS, SSRS,SSAS, ASP .Net, VB.net.

Responsibilities:

  • Extensive use of Stored Procedures. Created new stored procedures and modifying existing ones.
  • Tested backup and recovery strategies in a test environment before and after moved to production environment.
  • Optimizing Database Queries for performance enhancements and Writing T-SQL Views and triggers.
  • Monitored and scheduled existing/new jobs on production environment.
  • Database and Log Backups Restoration, Backup Strategies, Scheduling Backups. Backing up master system databases and restoring them when necessary.
  • Created groups, roles, users and assigning access privileges to users.
  • Designed and Created databases, tables, views, stored procedures and triggers.
  • Installation of MS SQL enterprise servers on test and development boxes.
  • Migrated data from SAS environment to SQL Server 2005 with SQL Server Integrated Services SSIS .
  • Developed ETL process using SSIS to transfer data from heterogeneous data sources.
  • Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
  • Responsible for Deploying, Scheduling Jobs, Alerting and Maintaining SSIS packages.
  • Responsible for gathering business requirements to create business user reports.
  • Created Parameterized, Cascaded, Drill-down, Cross-tab and Drill-through Reports using SSRS 2005.
  • Extensive Knowledge in SSAS storage and partitions, and Aggregations, calculation of queries with MDX, Data Mining Models, developing reports using MDX and SQL.
  • Designed OLAP cubes with star schema and multiple partitions using SSAS.
  • Understanding the OLAP processing for changing and maintaining the Warehousing Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
  • Involved in writing MDX queries and performance optimization of the SSAS cubes for calculated members and measure groups.
  • Implemented cell level security in cubes using MDX expressions to restrict users of one region seeing data of another region using SSAS.

Hire Now