We provide IT Staff Augmentation Services!

Sql Developer (ssis Ssrs) Resume

2.00 Rating

Jacksonville, FL

SUMMARY

  • 8 years of experience in IT industry as SQL Developer in MS SQL Server 2008/2005/2000 in various domains like Health care, Banking, Mortgage, e - commerce and Supply chain.
  • Extensive work experience on system analysis, design, development, testing and implementation of projects with full SDLC (Software Development Life Cycle).
  • Expert level skills in Data Mapping, Normalization, Batch jobs, Troubleshooting, Data migration, Data collation, Data cleansing, Entity Relationship Design (ERD) model and application oriented design.
  • Experience in PERFORAMNCE TUNING and Optimization using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor and Query Execution Plans.
  • Working experience in creating Database Objects like tables, Constraints (Primary key, Foreign Key, Unique, Default) Views and Indexes.
  • Experience in developing the applications using T-SQL Programming (DDL, DML, and DCL).
  • Expertise in writing T-SQL Queries, Complex Stored Procedures, creating Triggers, Cursors, User-defined functions, Joins and Common Table Expression (CTE).
  • Experience in design of ETL Packages using SSIS for integrating data from heterogeneous sources (Excel, flat file, Oracle, Access, DB2, Xml format) using multiple transformations.
  • Hands on experience in creating SSIS packages with Error handling, Logging, Package configurations and by implementing Break Points, and Check Points as well.
  • Experienced using various methods to Execute SSIS packages and Deploying through different modes.
  • Experience in creating Jobs, Alerts and scheduling SSIS Packages using SQL Mail Agent and Control M.
  • Expertise in managing project versions and source code changes using source control tools like Visual Source Safe, Team Foundation Server and TortoiseSVN.
  • Skillful in Creating, Managing and Delivering Reports using SSRS and integrating with share point.
  • Experienced in generating on-demand (ad-hoc) reports for business analysis or management decision using SQL Server Reporting Services and Report Builder.
  • Experience in using variables, expressions, functions for the reports and in handling Parameterized reports.
  • Experienced in sorting the data, defining data source and subtotals for the reports.
  • Possesses excellent skills in Data Modeling using Star and Snowflake Schemas.
  • Experience in designing and building the Dimensions and cubes and Deploying and Processing cubes using SQL Server Analysis Services (SSAS).
  • Experience working with large volume of database and storage modes like ROLAP/MOLAP/HOLAP.
  • Hands on experience in administration tasks like installing, configuring, upgrading, Log shipping, troubleshooting, scheduling, partitioning, backup & recovery, transaction logs.
  • A multitasking analytical thinker with ability to work on fast paced Environment either independently or as a team member.
  • Shown strong analytical, administration, leadership qualities and problem-solving skills in delivering the projects within client’s time frame by meeting their standards.
  • Experience in interacting with business analysts and other front end developers for better results.

TECHNICAL SKILLS

Operating Systems: Windows Server 2008/ 2003/Vista/XP/2000/98.

Relational Databases: Server (2000, 2005, 2008, R2), Oracle, DB2, MS Access.

Reporting Tools: Sql server reporting services (SSRS), Report builder.

ETL Tools: SQL server Integration Services (SSIS), DTS.

Modeling Tools: SQL server Analysis Services (SSAS).

Development skills: Transact SQL (T-SQL), SQL.

Programming Languages: C, C++, C#, Vb.Net.

Application Software: Microsoft Office, Macros, Adobe Photoshop, Acrobat Reader/Writer, Visual Studio,Ms Outlook (Microsoft Office Suite), Visio, Lotus notes

Others: Share point, Team foundation server, Agile, Visual Source Safe, SSMS,SQL profiler, Query analyzer, Index tuning wizard, TortoiseSVN, Control M

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

SQL Developer (SSIS SSRS)

Responsibilities:

  • Involved in requirements gathering, analysis, design, development, change management, and deployment.
  • Developed tables, views, indexes, functions and advanced queries for databases.
  • Created complex stored procedures, functions, cursors, and SQL joins for applications.
  • Created Indexes and maintained fill factor for fast and efficient reporting process.
  • Used SQL Server Profiler to monitor for long running queries and tune them to improve performance.
  • Developed SSIS packages to bring data from Oracle, Excel, XML, and Flat Files into SQL db.
  • Worked on tasks like Execute SQL, ftp, Send mail, for each loop container, derived column, conditional split.
  • Used script task to write Vb.net or C# code to satisfy business rules.
  • Created packages with error handling and used package configurations for deployment.
  • Developed packages to send E mail alert and log into SQL table for any issues (on error).
  • Configured XML config files (.dtsconfig files) to change properties of packages dynamically.
  • Scheduled jobs and triggered alerts through job scheduler Control-M.
  • Developed automated scripts to download files from Mainframe.
  • Involved in the full lifecycle of ETL software development - analysis, design, build, documentation and testing for the project.
  • Created complex reports that draw data from SQL and Oracle, and loaded them to Report server URL.
  • Designed and developed Matrix and tabular reports with drill down, drill through and drop down menu options.
  • Generated on-demand reports and scheduled reports for business analysis or management decisions.
  • Formatted reports using global variables, expressions and functions and implemented stylish report layouts.
  • Scheduled reports for daily, weekly through Report subscriptions based on business needs.
  • Regular monitor of servers, which includes backups and troubleshoot all the issues on regular basis.
  • Implementing the data changes, scripts and new releases onto the production servers.
  • Successfully tested all tasks in staging and stored all versions of data using team foundation server (TFS).
  • Participated in project planning sessions with project managers, business analysts and team members to analyze business requirements and outline the proposed solution.
  • Involved in Code reviews and preparing Unit test cases to assure high Data Quality.
  • Provided on call support for production issues.

Environment: MS SQL Server, SSIS, SSRS, Management Studio, Windows NT, Windows XP/ 2003/2000/98 , SQL Profiler, Visual studio, Oracle, Toad, SQL Developer, C#, VB.net, SQL Query Analyzer, TFS, Excel, XML, Adobe reader, T-SQL, MS Office, Control M, Unix, Mainframe.

Confidential, Richardson, TX

SQL Server SSIS Developer

Responsibilities:

  • Created clustered, non-clustered indexes for querying data faster.
  • Creating stored procedures, joins, functions to meet business rules.
  • Normalized tables and maintained Referential Integrity by using Triggers and keys.
  • Carried out performance tuning to optimize the run time of processing.
  • Changed existing stored procedures according to new hierarchy.
  • Used Database engine tuning advisor for creating indexes.
  • Used performance monitor and Sql profiler to enhance performance of database servers.
  • Developed SSIS packages to bring data from Flat Files, Excel files, Oracle and deployed to production server using package configurations.
  • Used For each loop for iterative loading and Send mail task for E-mail notifications.
  • Worked with different methods of logging in SSIS and created jobs.
  • Created SSIS Packages with error handling and implemented breakpoints to check status of package.
  • Used transformations like conditional split, row count, derived column, union all, character map, merge and containers like for each loop, sequence container.
  • Used Script task component to write .Net scripts as a part of data extraction.
  • Implemented Event Handlers in SSIS packages for error notifications.
  • Performed data transfers using BCP and BULK INSERT utilities.
  • Created reports like drill down, tabular reports to check output of data and for testing purpose using SSRS.
  • Created Fact table and Dimension tables and used SNOW FLAKE schema.
  • Used MS VISIO for database design diagram and visual source safe for source control.
  • Worked on Red Gate for comparing different environments(dev and prod)
  • Created documentation for the packages and scripts to migrate data.
  • Followed agile development methodology for further enhancement of the project.
  • Documented and maintained history of changes for future reference.

Environment: SQL server 2005, T-Sql, Visual Studio, SQL Server Integration Services (SSIS), Reporting Services (SSRS), Windows 2008, SQL Server Management Studio (SSMS), Visual Source Safe, EXCEL, AGILE, SQL Server Profiler, .net, MS word, Visio, Red gate, Oracle, Database engine Tuning advisor, Lotus Notes.

Confidential, Los Angeles, CA

SQL Server Developer

Responsibilities:

  • Gathered functional requirements, business requirements and wrote the technical specifications for building Enterprise Data warehouse.
  • Created tables, views, functions and advanced queries.
  • Created stored Procedures, triggers, cursors, and SQL joins for applications.
  • Created common table expression (CTE) for recursive operation.
  • Created Indexes and maintained FILL FACTOR for fast and efficient reporting process.
  • Used SQL Server Profiler for deadlocks, long running queries and tune them to improve performance.
  • Responsible for creating jobs using SQL Server Agent.
  • Ran DBCC consistency checks, fixing data corruption in application database.
  • Created SSIS packages (.dtsx files) using BIDS to validate, extract, transform and load data.
  • Deployed packages to Test and production servers using package configurations.
  • Configuring data flow, configuring individual data flow elements and Monitoring Performance of Package.
  • Involved in writing custom C# codes for SSIS packages.
  • Created packages with error notifications and security.
  • Created parameter based, Chart, Drill down, Drill through Reports using filters and expressions in SSRS.
  • Generated on-demand reports for business analysis using Report builder.
  • Scheduled reports to run on daily and weekly basis in Report Manager.
  • Created Grouping, Sorting columns writing expressions and used features like Charts, Graphs and Filters.
  • Involved in creating Data driven subscriptions for rendering of reports.
  • Constructed OLAP Cubes mostly adhering to Star Schema using SSAS.
  • Processed cube to perform incremental updates.
  • Wrote MDX expressions to create name sets and calculated members.
  • Regular monitor of servers, which includes backup job monitoring and troubleshoot all the issues on regular basis.
  • Perform full backups and transaction log backups; Restore them whenever necessary.
  • Creating backup strategies and scheduling them for execution.
  • Implementing the data changes, scripts and new releases onto the production server.
  • Successfully tested all task in staging and stored all versions of data using Team foundation server (TFS).

Environment: MS SQL Server 2008, SSAS, SSRS, SSIS, Management Studio, Windows NT, SQL Profiler, Visual studio, Report Manager, Db2, .net, C#, Report Builder, SQL Query Analyzer, Xml, TFS, Excel, Adobe reader, MS Office, SQL profiler, Database tuning advisor.

Confidential, Reston, VA

MS SQL Server BI Developer(SSIS/SSRS)

Responsibilities:

  • Developed database objects like tables, stored procedures, triggers, user defined data types and functions.
  • Created and updated clustered and non-clustered indexes to keep up the SQL Server performance.
  • Implemented Error handling through TRY-CATCH method and used CTEs.
  • Responsibilities included fine-tuning the SQL Server to achieve best performance.
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance.
  • Migrated data from heterogeneous sources such as Flat file, Excel and SQL Server using SSIS.
  • Scheduled SSIS jobs using SQL server agent for daily, weekly and monthly loads.
  • Created Tabular, Drilldown, Parameterized, Charts, Sub-Reports using SSRS.
  • Created report models for ad hoc reports and deployed on report server.
  • Involved in Creating Pie Charts, List reports and Matrix Reports.
  • Deployed and Published Reports for different departments.
  • Integrated SharePoint with SSRS uploaded Reports onto SharePoint server and granted access to users.
  • Created and managed users, roles and groups and handled database security.
  • Regularly monitored the system for bottlenecks for CPU, RAM, Disk IO and Networking.
  • Worked in design and implementation of backup, recovery and security.
  • Involved in creating Database Maintenance Plan for the Performance, which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
  • Monitored Log shipping/ Transactional Replication and trouble shooting of errors.
  • Responsible for Data modeling and design of Data Warehouse and Data Marts in Star Schema.
  • Involved in preparing detailed technical documents.
  • Documented all database changes, and release management processes.

Environment: Windows server 2003, MS SQL Server 2005, SQL server integration services (SSIS), SQL server reporting services (SSRS), Report Server, Visual studio, SQL profiler, Report Builder, Share point, Oracle, Visual source safe, Management studio, Microsoft office.

Confidential

Jr. SQL Developer

Responsibilities:

  • Determined the SQL Server 2000 Installation. Installed SQL Server Management tools using SQL Server 2000 setup program.
  • Configuring tuning and optimizing T- SQL. Responsible for performing basic developer task like creating, altering and updating tables.
  • Normalized the tables and maintained Integrity by using Primary and Foreign Keys.
  • Developed simple stored procedures, queries, views, joins and indexes by using T-SQL.
  • Worked on DTS Package, DTS Import/Export for transferring data from Heterogeneous sources.
  • Worked on MS SQL Server tasks such as data loading and batch jobs.
  • Successfully transferred old data from various sources like flat files, and Excel using SSIS.
  • Designed, Developed and Deployed reports in MS SQL Server using Microsoft SQL Server Reporting Services.
  • Performance tuning by tuning existing indexes and creating new indexes where necessary.
  • Used database maintenance plans for backing up the database and transaction log files.
  • Migrated Code across different environments.

Environment: MS Sql server, Windows 2000, Sql Server Management Studio, SSIS, SSRS, MS word, EXCEL.

We'd love your feedback!