We provide IT Staff Augmentation Services!

Sr. Sql Server (ssis, Ssrs) Developer Resume

Naperville, IL

SUMMARY:

  • 8+ years of IT experience in Data Design and Development on Microsoft SQL Server 2012/2008R2/2008/2005, T - SQL, Performance Tuning, Troubleshooting, SSIS/DTS Package Configuration, SSRS, SSAS and Data-warehousing.
  • Strong experience in MS SQL Server 2008 with Business Intelligence in SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS) and SQL Server Reporting Services (SSRS) .
  • Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005 and SQL Server 2008
  • Experience in migration of Data from Excel, Flat file, Oracle to MS SQL Server by using BCP and DTS utility and automation with SSIS
  • Experience in SQL Server Analysis Server MDX Queries
  • Created the datasets based in MDX Queries and implemented performance and analysis reports using SSRS.
  • Worked with OLAP and Data warehouse application and worked with star schema,snowflakes schema dimensions and worked with implementing SSAS, and SSRS tosupport large Reporting needs.
  • Thorough Knowledge of Various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers etc .
  • Worked on creating client reports and custom reports(On demand, Ad-hoc Reports, Frequency reports, Summary Reports, Sub Reports, Drill-down, dynamic grouping, Cross-Tab, graphical, aging reports etc) using SQL Server Reporting Services 2005
  • Experience in creating and managing database objects like Tables, Views, Triggers, Cursors, Stored Procedures, user defined data types and functions
  • Experience in creating Jobs, Alerts, SQL Mail Agent and scheduling DTS Packages
  • Experienced using in FTP and SFTP servers to upload files
  • Migrated data from SQL 2005 to 2008 and solved related issues.
  • Experience with SQL Performance tuning and transactions analysis , thorough understanding of indexes and statistics.
  • Good knowledge in Designing and Building the Dimensions and cubes with star schema using SQL Server Analysis Services (SSAS).
  • Experience in Database administration activities for DB Security (creating users, roles, and assigning permission to them)
  • Excellent T-SQL Programming skills. Experience in Performance Tuning, Query Optimization, Client/Server Connectivity, Database consistency checks using DBCC Utilities
  • Good knowledge in implementing Log Shipping, Database Mirroring
  • Thorough Knowledge of Various SSIS Objects such as Dataflow Components, Control Flow Elements, Connections Managers, Runtime Events, Log Providers etc .
  • Created complex DTS Packages for Data Migration and Transformation
  • Experience in developing and monitoring SSIS Packages
  • Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities independently as well as a proactive team member.
  • Collected business requirements from users and translated them as technical specs and design docs for development.
  • Identified various data sources, formulated data dictionaries, design and developed data models (physical/logical data models) based on the given specs and requirements.
  • Expertise includes FACT & Dimension Tables
  • Good Knowledge in Physical and Logical Data Modeling.
  • Excellent analytical, Interpersonal and Communication skills, fast learner, hardworking and good team player

TECHNICAL SKILLS:

Operating Systems: Windows Server 2000/2003/2008, Windows XP/Vista/7

Languages : T-SQL, C#.Net, VB.Net, ASP.Net, XML, HTML

Tools/Utilities : Enterprise Manager, SQL Server Management Studio(SSMS), Query Analyzer, Business Intelligence Development studio, DTS, Analysis Manager, SQL Profiler, SSIS, SSRS, SSAS, Visual Studio 2005/2008, SQL * Plus, Toad, Ervin

Database : MS SQL Server 2012,2008R2,2008,2005, 2000, MS-Access

Data Modeling Tools : Microsoft Visio, UML.

Software : MS Office, Adobe Dreamweaver, Adobe Photoshop, Ms Excel, MS-Project 2000

Reporting Services : Excel, SQL Server Reporting Services, Crystal Reports, Business Objects


PROFESSIONAL EXPERIENCE:

Confidential, Naperville, IL

SR. SQL Server (SSIS, SSRS) Developer

Confidential ( Confidential ) is the largest customer-owned health insurance company in the United States. Confidential offers a wide variety of health and life insurance products and related services, through its operating divisions and subsidiaries; including Blue Cross and Blue Shield of Illinois, Blue Cross and Blue Shield of Montana, Blue Cross and Blue Shield of New Mexico, Blue Cross and Blue Shield of Oklahoma, and Blue Cross and Blue Shield of Texas The company employs more than 21,000 people and serves more than 14.5 million members.

Responsibilities:

  • Worked for Financial Operations data quality team to validate data
  • Created Stored Procedures, Common table expressions, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic .
  • Created appropriate Triggers to assist efficient data manipulation and data consistency.
  • Involved in creating, building, deploying and executing the SSIS packages .
  • Developed dynamic SSIS packages for I ncremental Data Loading.
  • Used query optimizer to enhance the ETL architecture performance
  • Created SSIS package to get data from different sources consolidate and merge into one single source.
  • Used the SSIS ActiveX script task, look up, cached look up, Fuzzy group transformations and data flow tasks.
  • Created package configuration using environment variables.
  • Used power pivot for massive data analysis
  • Involved in fine tuning queries and stored procedures using Sql Profiler and Execution plan in Sql Server.
  • Involved in creation of complex SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries .
  • Worked with HP Quality Center and resolved defects in production.
  • Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
  • Involved in designing Parameterized Reports for generating Ad-Hoc reports as per the client requirements.
  • Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
  • Performed T -SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query.
  • Used data compression techniques for Back Up.
  • Performed CDC and Change tracking on OLTP systems .
  • Created Linked Servers for data retrieval using OLE DB data sources and providers.
  • Ensured best practices are applied and integrity of data is maintained through security and documentation.
  • Worked with project teams for upgrading SQL Server 2008 to SQL Server 2012.
  • Have used many new function like TRY CONVERT, PARSE and TRY PARSE for resolving data quality issues

Environment: MS SQL Server 2008 R2/2012, Team Foundation Server (TFS), Microsoft SharePoint Server(MOSS 2007), SQL Server Integration Services (SSIS), SSRS, T-SQL, VB.Net, ASP.Net

Confidential, Glen Burnie, MD

SR. SQL Server (SSIS, SSRS) Developer

Responsibilities

  • Worked on converting reports from HEALTHsuite to QNXT
  • Created Stored Procedures, Common table expressions, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic .
  • Created appropriate Triggers to assist efficient data manipulation and data consistency.
  • Involved in creating, building, deploying and executing the SSIS packages .
  • Used query optimizer to enhance the ETL architecture performance.
  • Worked on various tasks and transformations like Execute Sql Task, Execute Package Task and conditional split, Script Component, Merge and Lookup while loading the data into Destination.
  • Implemented Event Handlers and Error Handling in SSIS packages .
  • Used SSIS to create packages to get data from sources and merge into a single source .
  • Developed VB# scripting for packages using Script task.
  • Scheduled packages to run using SQL Server Agent Job .
  • Configured and maintained Report manager and Report Server for SSRS.
  • Performed documentation for all kinds of reports, DTS and SSIS packages.
  • Created and managed subscriptions, report snapshots for the reports.
  • Worked with data driven subscriptions to distribute reports to a fluctuating list of subscribers.
  • Created packages using SSIS for data extraction from Flat files, Excel files, OLE DB to SQL Server.
  • Created Drilldown-Reports, Summary Reports, Parameterized Reports, Sub Reports, List Reports and Matrix Reports in SSRS.
  • Converted crystal reports to SQL Server reports using Reporting Services (SSRS) .
  • Created AD-Hoc reports using Report Builder and maintained Report Manager for SSRS.
  • Published reports and dashboards on WEB.
  • Created report parameters, query parameters, filters and expressions for interactive reports.
  • Report parameters included single valued parameters, multi-value parameters which also consisted of different parameter types like hidden, internal, default (queried and non queried parameters).
  • Maintained the table performance by following the tuning tips like normalization, creating indexes and collect statistics.
  • Implemented security to restrict the access to users and to allow them to use only certain reports.

Environment: MS SQL Server 2008 R2, Team Foundation Server (TFS), SQL Server Integration Services (SSIS), (SSRS) SQL Server Reporting Services, T-SQL, VB.Net, Crystal Reports

Confidential, Long Beach, CA

SQL Server (SSIS, SSRS) Developer

Confidential has been a leader in providing quality healthcare to those who depend on government assistance. For more than 25 years, Confidential has been providing access to quality health care and serving the needs of families and individuals through no-cost and low-cost programs. It serves as a health plan providing a wide range of quality health care services to families and individuals who qualify for government-sponsored programs, including Medicaid and the State Children's Health Insurance Program (SCHIP).

Responsibilities:

  • Responsible for building and supporting Patient Access applications Patient Registration , Payer Contracting, and Insurance Verification.
  • Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity .
  • Created different types of User-defined functions and Stored procedures using T-sql.
  • Used Shared Connection managers and new functions like Left(), replacenull() functions in SSIS 2012
  • Implemented error handling in Sql Server 2012 using the THROW function.
  • ETL, data profiling, data quality and clean ups for SSIS packages.
  • Developed C# scripting for packages using Scrip task
  • Designed Logical and Physical Data Model with Erwin tools.
  • Created SSIS packages to populate data from various data sources.
  • Developed Tabular Reports, ad-hoc reports using SSRS Report Designer.
  • Running DBCC consistency checks and fixing data corruption in application databases.
  • Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
  • Worked with Meta-Data Driven SSIS Packages to pull the data from different Sources and load to Data mart.
  • Migrated SSIS Packages from SQL Server 2005 to SQL Server 2008.
  • Developed SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries .
  • Deployed reports, created report schedules and subscriptions . Managing and securing reports using SSRS.
  • Built ad-hoc reports using SQL Server Reporting Services (SSRS).
  • Work with project teams for upgrading SQL Server 2005 to SQL Server 2008.

Environment: MS SQL Server2008 R2/2012, Team Foundation Server(TFS), Microsoft SharePoint Server(MOSS 2007), Crystal Reports, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, T-SQL, VB.Net.

Confidential NYC, NY

SQL Server / BI Developer

Description: Confidential Education is one of the lifelong learning partners. This addresses virtually every aspect of the education market from pre-K through professional learning using traditional materials, online learning and multimedia tools.

Responsibilities:

  • Involved in Planning , Defining and Designing data based on business requirements and provided documentation.
  • Designed ER diagrams (Physical and Logical using Erwin) and mapped the data into database objects.
  • Upgraded MS SQL Server 2005 database to MS SQL Server 2008 , by using Detach/Attach, Back up & Recovery.
  • Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
  • Develop and support OLAP, star schemas, cubes, and conduct data mining and analysis.
  • Designed and developed OLAP Cubesand Dimensions using SQL Server Analysis Services (SSAS).
  • Used MS Report Designer to provide a Report Data pane to organize data used in the reports.
  • Performed source/target analysis of data structures & content.
  • Used various SSIS tasks such as Conditional Split, Derived Column , which were used for Data Scrubbing, data validation checks during Staging , before loading the data into the Data warehouse.
  • Used ETL to implement the Slowly Changing Transformation , to maintain Historical Data in Data warehouse.
  • Created Calculated Measures and Dimension Members using MDX, Mathematical formulas and User Defined Functions.
  • Used Merge in development, test and production for changing the referenced data.
  • Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers.
  • Created SSIS package to get data from different sources consolidate and merge into one single source.
  • Used the SSIS ActiveX script task, look up, cached look up, Fuzzy group transformations and data flow tasks.
  • Created package configuration using environment variables.
  • Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
  • Generated ad-hoc reports using MS Reporting services and Crystal reports .
  • Created OLAP cubes & wrote MDX queries for user reports.
  • Develop and support OLAP, star schemas, cubes, and conduct data mining and analysis .

Environment: SQL Server 2005/2008/2008 R2, Microsoft SharePoint Server (MOSS), T-SQL, SQL Crystal Reports, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, (SSAS) SQL Server Analysis Services, ETL, MDX, Erwin, SQL Profiler, MS Excel 2007, MS Visio, Visual Studio 2010-2008.

Confidential

SQL Server Developer

Responsibilities:

  • Created triggers for cascading update & delete operations to maintain data integrity
  • Developed and coded applications and wrote complex joins and sub queries in T-SQL
  • Designed and validated the forms according to client requirements using C#
  • Created databases and several DB objects like tables, views, indexes, and stored procedures
  • Worked with ADO.NET objects to connect to the databases.
  • Implemented security for web forms and created validation controls
  • Debugged and fixed the bugs.
  • Provided continuous support for application developers and database users.

Environment: SQL Server 2005, T-SQL, Windows NT 4.0, HTML 4.0, VB 6.0, C#, ASP.NET, ADO 2.0, IIS 5.0, 4.0, ActiveX.

Hire Now