We provide IT Staff Augmentation Services!

Ms Sql Server / Ssis Developer/ Etl Developer/ Ssrs Developer Resume

3.00/5 (Submit Your Rating)

Nashville, TN

SUMMARY

  • Over 8+ years of IT experience with database development experience, Business Intelligence and have Software Development experience.
  • Over 8 years of experience in database design and development using MS SQL Server 2012/ 20
  • Experienced in Data Extraction, Transformation and Loading (ETL) between Homogenous and Heterogeneous Systems using DTS and SSIS of MS SQL Server
  • Expert in Creating, Configuring and Fine - tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
  • Expertise in Developing and Extending MS SQL Server Analysis Services (SSAS) Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.
  • Experienced in generating On-demand and Scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services (SSRS).
  • Expert in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, and Functions, Sorting the data, Defining Data sources and Subtotals for the reports using SSRS.
  • Strong experience in Stored Procedure/TSQL coding, Performance Tuning, and Query Optimization.
  • Highly proficient in the use of T-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
  • Experienced in Logical and Physical Database design & development, Data Conversion, Normalization and Data modeling using ERwin and SQL Server Enterprise manager.
  • Excellent experience in Designing, Maintaining & Tuning various RDBMS like T-SQL & MS SQL Server, MS Access databases and strong knowledge of SDLC principles.
  • Involved in all phases of software development life cycle: design, implementation and testing.
  • In-depth knowledge of working and implementation of Crystal Reports, converting Crystal reports to SSRS Reports and in upgrading crystal reports.
  • Expert in database creation, maintenance, monitoring, backups and recoveries.
  • Specialized in analyzing, coding, implementing and creating complex query reports using Oracle, SQL Server, Sybase and DB2.
  • Excellent interpersonal communication, problem solving, documentation and business analytical skills.

TECHNICAL SKILLS

  • MS Server 2000/2005/2008/2012
  • SQL Server management studio and SSIS and SSRS Reporting Services 2005
  • Cognos
  • SQL Server Analysis Services 2005
  • SQL Server Integration Services
  • Attunity CDC
  • SSMS
  • CRYSTAL REPORTS
  • MS Access/Word/Excel
  • Dimensional Data Modeling
  • Star Schema Modeling
  • SQL Profiler
  • ERWIN 4.1
  • ODBC
  • HTML
  • Team foundation Server
  • BIDS
  • Visual Source Control
  • Crystal Reports
  • VB.Net
  • XML
  • UNIX platform
  • Win XP/2000/2003
  • C
  • Share point
  • Performance point server
  • C#
  • Web Service
  • ECG
  • FTP
  • SFTP
  • Sales Force.

PROFESSIONAL EXPERIENCE

Confidential, Nashville, TN

MS SQL Server / SSIS developer/ ETL developer/ SSRS Developer

Responsibilities:

  • Responsible for design and implement SQL database for creating a data warehouse.
  • Involved in development phase meetings for Business Analysis and Requirements Gathering.
  • Writing ETL process from the scratch and performance analysis using stored procedures.
  • Working with large volume of data performance issue for SSRS reports.
  • Working as a production support, find and solve the production issues.
  • Working with production tickets to fix the issues.
  • Working with data profiling.
  • Building visualization report Using Tableau.
  • Creates and manage data warehouse.
  • Studied the data requirements and the impact analysis on the existing schema.
  • Designed high level ETL architecture for overall data transfer from the source server to the Enterprise Services Warehouse which encompasses server name, database name, accounts, tables and direction of data flow, Column Mapping, Data dictionary and Metadata.
  • Normalized and De-normalized entities for the Data Warehouse.
  • Work on performance tuning on existing SSIS packages.
  • Recognized the fact and dimension tables from the OLAP database
  • Work on creating various such as Tableau, dashboard reports.
  • Create and deliver daily ad-hoc report.
  • Created linked reports, sub reports as well as drill-through reports in support of management.
  • Closely work with the business users to gather business requirements.
  • Design, coding, testing, debugging and documentation of applications.
  • Working with QA team for testing SQL codes.
  • Managed and coordinate with remote user for change request and optimization of application.
  • Scheduled jobs, alerts and designed and implemented user log in and security.
  • Generated various reports like Cascade type reports, Tabular reports, and Drill down reports.
  • Created Store Procedures, Functions and Triggers for retrieval and update of data in the database.
  • Actively participated in the meetings to meet the goals.
  • Tested SQL Statements using Indexes using stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
  • Maintained database for inventory, billing and invoice systems and Created dynamic stored procedures to retrieve the customer details, connection details, payment history by giving the related parameters.
  • Developed approaches for data warehouse implementation and data acquisition.
  • Optimized the embedded application T-SQL code as well as the stored procedure that is used to feed reports.
  • Efficiently completed maintenance task like checking database integrity, history cleanup, Maintenance cleanup, rebuild indexes, reorganize indexes, update statistics etc.

Environment: MS SQL Server 2012, SQL Server Integration Services (SSIS), 8/7.1.2, SQL Server Reporting Services (SSRS), Cognos, SQL Server Analysis Service (SSAS), SVN (Sub-version), Visual Studio 2012, ASP.Net 2.0

Confidential, Nashville, TN

MS SQL Server /Data Warehouse/SSIS /SSRS developer

Responsibilities:

  • Design and develop Integration Services solution in MS Business Intelligence Development Studio (BIDS).
  • Responsible for running, maintaining, trouble-shooting daily production jobs.
  • Create dashboard reports using Tableau.
  • Creates ETL process for data migration TSQL script and SSIS
  • Studied the data requirements and the impact analysis on the existing schema.
  • Responsible for creating ad-hoc reports for daily/ weekly/ monthly basis.
  • Responsible for creating SSRS, CRYSTAL report.
  • Create MDX cubes from scratch.
  • Created partitions, KPIs, calculated members, schema and file groups for fact tables and cubes integrating SSAS with pro clarity 6.3.
  • Normalized and De-normalized entities for the Data Warehouse.
  • Tuned SQL Statements using Indexes using stored Procedures and Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard.
  • Maintained database for inventory, billing and invoice systems and Created dynamic stored procedures to retrieve the customer details, connection details, payment history by giving the related parameters.
  • Scheduled jobs, alerts and designed and implemented user log in and security.
  • Generated various reports like Cascade type reports, Tabular reports, and Drill down reports.
  • Created Store Procedures, Functions and Triggers for retrieval and update of data in the database.
  • Actively participated in the meetings.
  • Actively participated in troubleshooting and resolving database integrity issues, performance issues, blocking and deadlocking issues, replication issues, log shipping issues, connectivity issues, security issues etc. Create Performance Tuning, Query Optimization, using Performance Monitor, SQL Profiler and other related monitoring and troubleshooting tools.
  • Create of backups, restores, recovery models, database shrink operations, DBCC commands, Clustering, Database mirroring, Replication.
  • Worked on production issue tickets.

Environment: MS SQL Server 2012/2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS). SQL Server Analysis Service (SSAS), Visual Studio 2012, Tableau, TFS.

Confidential, San Francisco, CA

MS SQL Server Developer/SSIS /SSRS/Data warehouse developer

Responsibilities:

  • Experienced in writing system specifications by collecting the business requirements, translating user requirements to technical specifications.
  • Developed applications in accordance with System Development Lifecycle.
  • Defined data definitions, and created target tables in the database.
  • Analyzed the business requirement and functional specifications provided by the data analyst.
  • Create various reports (ad-hoc, Tableau, drill-through).
  • Used MS SSIS as the main ETL tool
  • Developed, created and managed complex stored procedures and UDF in SQL Server 2008
  • Created various database objects like Indexes, Views, Triggers and User-defined functions depending upon business rules and optimized them.
  • Used SQL Profiler along with Data Tuning Advisor for optimizing complex T-SQL code Ensured the integrity on the database by creating triggers and constraints to make sure that the data is always stored in consistent way at any given point of time.
  • Played a major role in optimizing large tables by creating indexes (clustered and non-clustered indexes) and partitioning the table depending upon the no of records coming in from the front-end application.
  • Designed Staging Database using ER-win.
  • Created dimensions and fact tables based on the business requirement.
  • Designed complex ETL strategies to pull data from different sources, like SQL server, oracle, flat files and load it to the destination database after using multiple transformations
  • Implemented the Master Child Package Model for easier maintenance and better performance
  • Optimized ETL packages by increasing the memory buffer size and by increasing the Max Concurrent Executable.
  • Implemented Attribute Relationships and Hierarchies to design more aggregations in order to improve summarization performance of queries. Created several tables, views using SQL Server.
  • Created several databases in various Development and Test server by using SQL Server 2005.
  • Performed data cleansing activities and managed proper data entry into SQL Server by taking care of data type compatibility issues.
  • Administrated interface to organize reports and data sources, schedule report execution and delivery, subscription of reports and track reporting history.
  • Generated daily, weekly and monthly trigger based reports regarding assigned projects to designated managers and clients.
  • Applied security to web server and database server that affects report server installation. Managed role-based security to reports and reporting resources.
  • Responsible for back up and restoration of SQL Reporting Service.
  • Provided Documentation support on SSRS 2005 as assigned.

Environment: MS SQL Server 2005, Pro clarity 6.3,MS SQL Server Reporting Services 2005, SSIS, Oracle 9i, MS Office, Windows XP/NT. Report Builder, BIDS, Visual Basic 6.0.ERWIN 4.1,SQL Profiler.

Confidential, San Francisco, CA

SQL Developer

Responsibilities:

  • Experienced in writing system specifications by collecting the business requirements, translating user requirements to technical specifications.
  • Developed applications in accordance with System Development Lifecycle.
  • Defined data definitions, and created target tables in the database.
  • Analyzed the business requirement and functional specifications provided by the data analyst.
  • Create various reports (ad-hoc, Tableau, drill-through).
  • Used MS SSIS as the main ETL tool
  • Developed, created and managed complex stored procedures and UDF in SQL Server 2008
  • Created various database objects like Indexes, Views, Triggers and User-defined functions depending upon business rules and optimized them.
  • Used SQL Profiler along with Data Tuning Advisor for optimizing complex T-SQL code Ensured the integrity on the database by creating triggers and constraints to make sure that the data is always stored in consistent way at any given point of time.
  • Played a major role in optimizing large tables by creating indexes (clustered and non-clustered indexes) and partitioning the table depending upon the no of records coming in from the front-end application.
  • Designed Staging Database using ER-win.
  • Created dimensions and fact tables based on the business requirement.
  • Designed complex ETL strategies to pull data from different sources, like SQL server, oracle, flat files and load it to the destination database after using multiple transformations
  • Implemented the Master Child Package Model for easier maintenance and better performance
  • Optimized ETL packages by increasing the memory buffer size and by increasing the Max Concurrent Executable.
  • Implemented Attribute Relationships and Hierarchies to design more aggregations in order to improve summarization performance of queries. Created several tables, views using SQL Server.
  • Created several databases in various Development and Test server by using SQL Server 2005.
  • Performed data cleansing activities and managed proper data entry into SQL Server by taking care of data type compatibility issues.
  • Administrated interface to organize reports and data sources, schedule report execution and delivery, subscription of reports and track reporting history.
  • Generated daily, weekly and monthly trigger based reports regarding assigned projects to designated managers and clients.
  • Applied security to web server and database server that affects report server installation. Managed role-based security to reports and reporting resources.
  • Responsible for back up and restoration of SQL Reporting Service.
  • Provided Documentation support on SSRS 2005 as assigned.

Environment: MS SQL Server 2005, Pro clarity 6.3,MS SQL Server Reporting Services 2005, SSIS, Oracle 9i, MS Office, Windows XP/NT. Report Builder, BIDS, Visual Basic 6.0.ERWIN 4.1,SQL Profiler.

We'd love your feedback!