We provide IT Staff Augmentation Services!

Sql Server Developer, Ssrs/ Ssis/ Ssas Developer Resume

0/5 (Submit Your Rating)

Arlington, VA

SUMMARY

  • Over 7+ years of professional experience in SQL Server database development, extensively worked in Production, Test, Development and Replication & Cluster Server Environments & development databases as a Developer.
  • Hands on experience in creating indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to assist efficient data manipulation and data consistency.
  • Experienced in developing logical and physical data models using data modeling tools such as Erwin and ER/Studio.
  • Efficient in creating joins and sub - queries for complex queries involving multiple tables.
  • Well versed in Normalization/Denormalization techniques for optimum performance in relational and dimensional database environments.
  • Experience in query optimization & performance tuning. Used Performance tools like SQL Profiler, Index Tuning Wizard and Database Engine Tuning Advisor.
  • Expertise in solving Dead Locks/Long running queries using Performance Monitor and SQL Profiler
  • Experience in Crystal Reports, Reporting Services for MS SQL Server and SQL Server Agent in Support Services and MDX technology of the analysis services.
  • Expert in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and BCP.
  • Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Checksum, Conditional Splits and Event Handlers, Error Handlers etc.
  • Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
  • Extensive experience in creating Jobs, Alerts, SQL Mail Agent, and automating DTS/SSIS Packages.
  • Experience in Configuring and Managing Linked Servers, Data transfer between SQL Server and other Heterogeneous relational Databases such as Oracle And DB2
  • Worked with improving the performance on SQL, TSQL and SSRS procedures and provided the recommendation on server related tuning issues.
  • Good experience in working with Agile Methods like Scrum, Open Agile, Lean.
  • Data Warehouse and ODS (Operational data store) usage to create reports.
  • Good experience on KPI (Key Performance Indicators) areas.
  • Good Knowledge of SQL Server Clustering, Replication, Data Mirroring, Linked Servers and Log Shipping.
  • Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
  • Efficiently helped in the Software Development Life Cycle (SDLC) processes including Analysis, Design, Programming, Testing and technical Documentation
  • Good Knowledge of SQL Server 2008, 2012.
  • Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

TECHNICAL SKILLS:

Languages: SQL, T-SQL, PL/SQL, Java, PHP

SQL Server Tools: BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, SSIS, SSRS, SSAS, Index Analyzer

Databases: SQL Server 2014/2012/2008 R 2/2008/2005/2000, MS Access

Operating Systems: Windows Server 2012/2008R1/2008R2/2003/2000 Windows 2007/2008/ NT/95/XP, UNIX

ETL Tools: DTS, SSIS, BCP, Import/Export Wizard, BI Studio

OLAP Tools: SSAS, MS Excel

Reporting Tools: SSRS, MS Excel

Business Tools: Word, Excel, PowerPoint, Access, Outlook.

PROFESSIONAL EXPERIENCE:

Confidential, Arlington, VA

SQL Server Developer, SSRS/ SSIS/ SSAS Developer

Responsibilities:

  • Developed complex programs in T-SQL\PL-SQL, writing Stored Procedures, Triggers and Queries with best execution plan.
  • Rewrote SQL queries to upgrade SQL Server performance using SQL Server 2014/20012.
  • Extensively worked on stored procedures, triggers, Views, cursors, CTE’s, T-SQL scripts, schemas, permissions and performance issues with client/server database design.
  • Involved in performance tuning of T-SQL queries and Stored Procedures using SQL Server 2014, 2012.
  • Developed Query for generating drill down and drill through reports in SSRS 08/12.
  • Uploaded reports on to the report manager and organized them into folders.
  • Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
  • Identified and worked with Parameters for parameterized reports in SSRS 2012/2008.
  • Used ProClarity for accessing and analyzing cubes and dimensions, and also worked on integration of SharePoint with SSRS.
  • Used Excel Power Pivot and Power view to build Scorecards and Dashboards.
  • Responsible for scheduling the subscription reports with the subscription report wizard.
  • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases, and process SSAS cubes to store data to OLAP databases.
  • Designed and developed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files into SQL server 2012 for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
  • Have good hands on experience working with FTP component in SSIS and used Configuration Manager to retrieve the passwords.
  • Designed dynamic SSIS with VB.Net to transfer data crossing different platforms, validate data and data clearing during transferring, and archived data files for different DBMS.
  • Scheduled the SSIS jobs using SQL Server agent for daily, weekly, monthly loads.
  • Worked on transformations such as Checksum in SSIS where all of the rows in table need to compared for an update
  • Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
  • Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
  • Created various Dash Boards using Performance Point Server
  • Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes.
  • Created Linked Servers to connect OLE DB data sources and providers.
  • Administered the SQL server by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
  • Configured replication servers and transactional replication between production & standby server for disaster recovery.
  • Designed and created MDX queries to retrieve data from cubes using SSAS.
  • Experience in SQL database design, architecture, data modeling using Erwin; Data Warehousing and analysis skills: ETL tools, MDX, OLAP (MOLAP, HOLAP, ROLAP), dimensional modeling, star schema and snowflake schema.
  • Identified and Defined Key Performance Indicators in SSAS 2005/2008.
  • Configured MERGE Replication using Snapshot agent and Merge Agent. Created Distribution Databases, updated Publishers, created & managed Publications, managed Replication monitors.
  • Provided day-to-day administration tasks like space and log management.
  • Developed Backup and Recovery Strategies, and Disaster Recovery Plan
  • Perform Capacity Monitoring and short and long-term Capacity Planning in collaboration with development resources and System Administrators.

Environment: MS SQL Server 2014/2012/2008 /7.0, DTS, Windows Server 2008, SSMS, BIDS,SSRS, SSIS, SSAS, Report Builder 3.0,Report Model,, Performance Point Server, ProClarity, SharePoint (MOSS), FTP, MS-Visual Studio,, XML,XSLT, ADO.Net.

Confidential, St Paul, MN

SQL Server Developer, SSRS/ SSIS/ SSAS Developer

Responsibilities:

  • Created complex Store Procedures and tables to load the data on Incremental load logic.
  • Used DBCC Statements to perform maintenance tasks on the database. Executed DBCC commands like CHECKDB before backing up the databases
  • Created an SSIS Package for reading multiple excel files from the source and added validation before loading into destination tables.
  • Created an SSIS Package which can load multiple sheets in an excel work book dynamically.
  • Did an end to end testing of the data in TEST and Production databases after loading the data.
  • Created a store procedure which will validate the results and flags it up at the end.
  • Used TF Send email task to capture to send the successful & failure emails to the end the users after the package executed.
  • Managed the migration of SQL Server 2008 databases to SQL Server 2012.
  • Used Team Foundation Server (TFS) for Deploying Packages.
  • Migrated data from Heterogeneous Data Sources and legacy system (Cognos, DB2, Access, Excel) to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
  • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
  • Involved in the Data modeling, Physical Design of Database using tools like Erwin..
  • Performing Replication (snapshot and transactional).
  • Designed Star schema (identification of facts, measures and dimensions) and Snowflake schema.
  • Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services (SSAS) for analyzing purpose.
  • Enhanced the functionality of OLAP Cube by creating KPI, Actions and Perspective from huge dataset using SQL Server 2008 Analysis Services.
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs
  • Configured replication servers and transactional replication between production & standby server for disaster recovery.
  • Worked with XML Files in generating reports using SSRS
  • Created calculated measures and dimension members using multi dimensional expression (MDX).
  • Experience using REDGATE to compare and synchronize all database objects.
  • Extensively worked on Performance Tuning ofTeraDataSQLusing explain plan and understanding Joins and Data distribution.
  • Performed DBA functions, installing, configuring and supporting SQL Server based database systems
  • Used Toad for retrieving information from database.

Environment: MS SQL Server Management Studio 2012, MS SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), C#, TFS, SSAS. Share point, Toad, Teradata.

Confidential, Fresno, CA

SQL Server Developer, SSRS Developer

Responsibilities:

  • Create User Defined Functions, Stored Procedures, and Triggers.
  • Performed data conversions from Flat files into a normalized database structure.
  • Developed, modified, and optimized complex stored procedures, triggers to handle complex business rules, history data and audit analysis
  • Responsible for creating constraints, Indexes, and Views.
  • Optimized the performance of queries with modification in T-SQL queries, normalized tables, established joins and created indexes wherever necessary.
  • Created triggers, views, user defined functions to in corporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective.
  • Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
  • Developed different types of Tabular Reports, Matrix Reports, Drill Down, Cross Tab Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
  • Implemented Transaction Log Replication for load balancing of data and distributed application user requests on Production servers.

Environment: SQL Server 2005/2008 Enterprise Edition, SSRS 2005,.NET Framework, C#,, T-SQL, SQL Server 2000, SQL Server 2005, Visual Studio, Windows 2000/2003 Advance Server, MS Excel, MS Access, Visual Studio 2005.

CoConfidential, ME

Sr.SQL SSIS/SSRS Developer

Responsibilities:

  • Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages.
  • Developed the packages with monitoring features and logging so that audit information of the packages and their execution results are loaded in to the audit table.
  • Performed incremental data load in BIDS using Lookup Transform, Cache Transform, and Merge Join Transform and worked on Change Data Capture.
  • Automated execution process of packages using SQL Server Agent by creating jobs and error reports using Alerts, SQL Mail Agent and SMTP.
  • Designed and written the queries in the query builder for retrieving the data.
  • Created and worked with drill down reports and identified the report parameters.
  • Used various report items like tables, sub report and charts to develop the reports in SSRS.
  • Deployed and generated reports on to the server using the Reporting Services Report Manager.
  • Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc
  • Defined Granularity with in a measure group and drill through actions.
  • Refreshing the cube to get the latest information updated and deployment of Cubes to the production server.

Environment: SQL Server 2008, SQL Server 2008R2, SSIS, SSRS, SSAS, BIDS, SSDS.

Confidential

SQL Server DBA

Responsibilities:

  • Interacted with Team in Analysis, Design and Develop database using ER Diagram, Involved in Design, Development and testing of the system
  • Developed SQL Server Stored Procedures, Tuned SQL Queries( using Indexes)
  • Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
  • Implemented Exceptional Handling
  • Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
  • Tuned and Optimized SQL Queries using Execution Plan and Profiler
  • Rebuilding Indexes and Tables as part of Performance Tuning Exercise
  • Involved in performing database Backup and Recovery
  • Worked on Documentation using MS word

Environment: Windows 2000 Server, SQL Server 2000, Query Analyzer, Enterprise Manager, Import and Export, SQL Profiler.

We'd love your feedback!