We provide IT Staff Augmentation Services!

Sr.sql Developer Resume

NJ

PROFESSIONAL SUMMARY

  • Over Seven years of experience in Software analysis, design and development in Client/Server systems, Data warehousing and Business Intelligence applications
  • Extensive experience in design, development and Maintenance of Database Applications on SQL Server 2008,2005 and SQL Server 2000 / 7.0.
  • Highly experienced in all aspects of SDLC such as requirement analysis, design, development, testing, implementation, deployment & maintenance of Projects.
  • Hands on Experience with Analysis Services (SSAS), Integration Services (SSIS) and Reporting Services (SSRS).
  • Expert in modeling, Extraction Transform Loading (ETL) using DTS and SSIS 2005 and 2008R2.
  • Hands on experience with performing various SSIS data transformation tasks like Look-ups, Fuzzy Look-ups, Conditional Splits and EventHandlers, ErrorHandlers etc.
  • Experience in creating Jobs, Alerts, SQL Mail Agent, and scheduled DTS/SSIS Packages.
  • Expertise on using ETL - Data Extraction, Transformation, Loading tools with heterogeneous sources like Oracle, MS Access, DB2 and SQL Server using SSIS 2008/ 2005 and DTS 2000.
  • Experience in creating SSIS packages. Experience in DTS Migration and Metadata Management: Migrating
  • DTS packages to SSIS, Package Migration Wizard, and Storage Management.
  • Expert in generating Drill down and Drill through reports with Drop down menu option, sorting the data, defining subtotals in SSRS 2008R2.
  • Excellent report creation skills using SSRS 2005/2008 and Crystal Reports and deploying, publishing and developing dashboards.
  • Expertise in creating Ad-hoc reports with Report models and explained end users how to use it in the Report Builder using SSRS 2005/2008. Worked with report builder tool 3.0/2.0/1.0
  • Proficient in handling parameterized reports in SSRS 2008R2.
  • Experience in integrating the SSRS reports into web applications using Report viewer control.
  • Experience in Developing and Extending SSAS Cubes, Dimensions and data source views SSAS-Data Mining Models and Deploying and Processing SSAS objects.
  • Experience with optimizing cube using partitions and aggregations.
  • Worked in Data modeling, creating star and snowflake schemas in SSAS. Also used tools like Erwin.
  • Experience in Excel pivot services.
  • Worked on SQL BI solution integration with Microsoft share point server.
  • Exposure to source safe, version controlling etc
  • Quick learner and good performer both in team and independent job environments.

TECHNICAL SKILLS

Databases

SQL Server 2012/2008/2008 R2, SQL Server 2005, SQL Server 2000/7.1, Access, Oracle 8i/9i/10g, MySQL

Database Tools

SQL Server Management Studio, Performance Monitor, Query Analyzer, Query Optimizer, SQL Profiler, Data Transformation Services (DTS), ETL, Bulk Insert and BCP, Business Intelligence Development Studio(BIDS)(DataTools), SQL CMD.

Languages

T-SQL, MDX, C, C++, PL/SQL, C#.Net, Vb.Net.

Reporting Tools

SQL Server Reporting Services (SSRS), Crystal Reports 9.0/8.5,OLAP

Change Management Tool

Visual Source Safe (VSS), Team Foundation Server (TFS)

Operating Systems

Windows Server 2000/2003, 2008, 2008 R2, Windows NT 4.0

Windows 7/vista/XP/98/95.

EXPERIENCE

Confidential

SR.SQL Developer (SSIS, SSRS)

ROLES AND RESPONSIBILITIES:

  • Involved in all phases of SDLC including Requirements Analysis, Design, Development and Customization of the reports.
  • Involved in database design to create star schema using Dimensional and Fact tables
  • Develop and maintain a real time data warehouse environment and create real time feed to all subscriber application from Data warehouse.
  • Develop and support SQL server database objects and code for BAU Support.
  • Develop and support SSIS integration jobs required to manage integration between application databases and the corporate data warehouse
  • Develop and support SSAS Cubes and related processing tasks.
  • Develop and support SSRS reports on MOSS 2010.
  • Provide and maintain documentation for all developed objects and processes.
  • Use MS TFS (2010) to track all end to end changes and artifacts
  • Follow strict change control process throughout development lifecycle
  • Develop and run test scripts to ensure the quality of code and integrity
  • Follow data designs and architecture as prescribed by SQL team lead and Chief Architect

Environment:

SQL Server 2012/2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS),Service Now(ITSM) Data tools 2012, XML,SYBASE,MS Visual Source Safe and Windows Server 2003/2008/2012.

Confidential

SR.SQL Developer (SSIS, SSRS)

ROLES AND RESPONSIBILITIES:

  • Involved in all phases of SDLC including Requirements Analysis, Design, Development and Customization of the reports.
  • Involved in database design to create star schema using Dimensional and Fact tables.
  • Creation of tables, views, Indexes and establishing the relationships between the tables and design the star schema using SQL Server 2012.
  • Created SSIS packages to implement complex business logic.
  • Published SSIS packages and SSRS repots in testing and production server.
  • Created Jobs to execute SSIS packages, on daily, weekly and monthly time periods.
  • Involved in creating complex table, matrix, sub reports and chart reports using SSRS.
  • Mentor offshore team for any technical aspects and test offshore deliverables on both SSIS packages and SSRS reports.
  • Involved in requirements analysis and attended requirements review meetings.
  • Managed offshore team
  • Facilitated meetings involving Development, QA and Business Teams in resolving high priority issues.

Environment:

SQL Server 2012/2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS),Service Now(ITSM) Data tools 2012, XML, MS Visual Source Safe and Windows Server 2003/2008/2012.

Confidential

Sr. SQL Developer

Responsibilities:

  • Associated closely with the team of Business Analysts to gather requirements for Reporting.
  • Worked with Business Analysts to do mapping and to alter stored procedures.
  • Worked as a developer in creating complex Stored Procedures, Triggers, Functions, Indexes, Tables, Views and other T-SQL code and SQL joins for applications.
  • Worked as a developer in creating macros, views and stored procedures in Teradata.
  • Creating the complex stored procedures, user defined functions to meet the business rules.
  • Responsible for creating the reports using the SQL server reporting services and maintained them. Used the various parameter passing techniques to create input for reporting parameters.
  • Wrote the ETL scripts to load the data into database from various source files.
  • Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.
  • Developed User Interactive Sheets & Reports as per business needs in SSRS.
  • Developed complex Stored Procedures to generate various Drill-through reports, parameterized reports, Cascading Parameterized reports, sub-reports and linked reports using SSRS and integrated into the front end.
  • Improved the performance of SQL Queries and stored procedures using SQL Profiler, Estimated Query Plan and Index Tuning Wizard.
  • Developed and maintained maintenance plans, evaluated scheduled jobs and monitored performance during various job runs.
  • Optimized the performance of queries with modification in T-SQL and Teradata queries, normalized tables, established joins and created indexes wherever necessary.
  • Experienced in performing various Data Transformation Tasks in SSIS.
  • Experience in SSIS script task using Visual Basic (VB) and c# scripts.
  • Experienced in development of Test Cases in various scenarios around the SQL Code and SSIS Packages in Dev., QA and UAT environments.
  • Actively participated in gathering and analyzing Business Requirements, Creating Directives, Data Analysis, Design, Development, Conversion, System Testing, Operational Readiness, Documentation, Production support issue

Environment:

Teradata, SQL Server 2008, SQL Server Business Intelligence Development Studio (SSIS, SSRS), MS Visual Source Safe and Windows Server 2003/2008.

Confidential

SQL BI Developer (SSIS/SSRS)

Responsibilities:

  • Interacted with business users in collecting the requirements, solving issues and making changes as required.
  • Created database objects like tables, indexes, stored procedures, views, user defined functions, cursors and triggers.
  • Managed indexes and optimized queries using execution plan.
  • Used temporary tables, table variables and common table expressions (CTE) for the better performance of the queries according to the requirement.
  • Involved in performance tuning of queries and SSIS packages which increases the performance and runs faster.
  • Extracted large volumes of data from different data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
  • Created ETL packages to get the data from XML raw files and used XSD files to convert the raw file to desired format.
  • Created complex packages and performed the ETL to load the Dimension Tables in using SSIS.
  • Used C#.Net and Vb.Net in Script tasks in order to validate the files and to get the latest files.
  • Used Script component using C#.Net to perform row by row transformations in data flow tasks.
  • Implemented the concepts of incremental data load, Slowly Changing Dimensions for updating and maintaining the history of the records.
  • Upgraded SSIS 2005 packages to 2008 packages.
  • Involved in testing the performance of SSIS packages over different servers in collaboration with platform labs.
  • Created data flow tasks for logging the audit data of the packages.
  • Used Event Handlers to handle errors in the packages.
  • Deployed the SSIS Packages from development server to production server.
  • Used script task to produce HTML reports and mail using SSIS.
  • Created SSRS reports by Report designer for the users and deployed onto the report server.
  • Parameterized and cascaded reports are also used to make the reports interactive with the users.
  • Supported multiple projects at a time.

Environment:

SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), XML, MS Visual Source Safe and Windows Server 2003/2008.

Confidential

SQL BI Developer (SSIS/SSRS/SSAS)

Responsibilities:

  • Involved in complete Software Development Life Cycle (SDLC).
  • Experienced in writing complex SQL Queries, Stored Procedures, Triggers, Views, Cursors, Joins, Constraints, DDL, DML and User Defined Functions to implement the business logic and also created clustered and non clustered indexes.
  • Involved in Normalization and De-Normalization of existing tables for faster query retrieval.
  • Involved in upgrading from SQL Server 2005 to SQL Server 2008.
  • Advised optimization of queries by looking at Execution Plan for better tuning of the database
  • Designed and developed SSIS Packages to import and export data from MS Excel, SQL Server 2005 and Flat files.
  • Involved in daily loads (Full & Incremental) into Staging areas, troubleshooting process, issues and errors using SQL Server Integration Services (SSIS) 2008.
  • Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages in both the environments (Development and Production).
  • Used various Transformations in SSIS Dataflow, Control Flow using for loop Containers, and Fuzzy Lookups etc.
  • Implemented Event Handlers and Error Handling in SSIS packages.
  • Configured the loading of data into slowly changing dimensions using slowly Changing Dimension Wizard. Also implemented checksum SCD method to load the data into date warehouse.
  • Developed SSAS cubes with multiple fact measures and multiple dimension hierarchies based on the OLAP reporting needs
  • Involved in building Data Marts and multi-dimensional models like Star Schema and Snowflake schema.
  • Calculated measures and dimension members using multi-dimensional expression (MDX).
  • Improved the performance of the cube by creating Attribute Relationships, Partitions, and Aggregations, getting rid of unused attributes and by changing the attribute hierarchy options in SSAS.
  • Understanding the OLAP processing for changing and maintaining the Warehousing, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
  • Created reports using stored procedure and Experience in building Reports on Analysis Services cubes (SSAS).
  • Advanced extensible reporting skills using SQL Server 2008 Reporting Services (SSRS).
  • Developed a High level dashboard using SSRS 2008.
  • Developed various types of complex reports like Drill Down, Drill through, Cross tab reports.
  • Involved in scheduling, creating snapshots and subscriptions for the reports using SSRS 2008.
  • Involved in designing Parameterized Reports and Report Models for generating Ad-Hoc reports as per the client requirements.
  • Defined Key Performance Indicator metrics to create scorecards.
  • Involved in creating report models and applying row level security filters for report model.

Environment:

SQL Server 2008/2005 Enterprise Edition, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), .Net framework, Microsoft Office Share Point Server, XML, MS Visual Source Safe and Windows Server 2003.

Confidential

SQL BI Developer

Responsibilities:

  • Responsible for documentation of system related activities.
  • Created complex Stored Procedures, Triggers, Cursors, Tables and other SQL Joins and Statements for Applications by using T-SQL.
  • Used Joins and sub-queries for complex queries involving multiple tables from different databases.
  • Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.
  • Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
  • Developed DTSX packages to extract, transform and load into the Campaign database from OLTP database using of SQL Server Integration Services (SSIS).
  • Experience in Developing and Extending OLAP Cubes, Dimensions and data source view.
  • Assisted in production OLAP cubes, wrote queries to produce reports using SQL Server 2005/2008 Analysis Services (SSAS) and Reporting service (SSRS)
  • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
  • Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
  • Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different environments for the SSAS cubes.
  • Involved in Analyzing, designing, building &, testing of OLAP cubes with SSAS 2008 and in adding calculations using MDX.
  • Designed and implemented data mart, facts, dimensions and OLAP cubes using dimensional modeling standards in SQL Server 2005/2008 that maintained data. Involved in the complete data warehouse development life cycle. Actively supported business users for change requests.
  • Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
  • Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
  • Involved in creating calculated members, named set, advanced KPI’S for the SSAS cubes.
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.
  • Daily support of system wide replication tasks including monitoring, alerting, and problem resolution.
  • Worked on PROCLARITY to create OLAP data sets and queries are created directly from the Unified Dimensional Model.
  • Actively participated in interacted with users, team lead, DBAs and technical manager to fully understand the requirements of the system.

Environment:

MS SQL Server2005/ 2008, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), MS Visual Studio.NET# 2008, TFS (Share Point ), Visual Basic6.0/VB.net, VB Script and Windows 2008 Server.

Confidential

SQL BI Developer

Responsibilities:

  • Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
  • Designed and tested (Unit, Integration and Regression) packages to extract, transform and load data using SQL Server Integration Services (SSIS).
  • Transferred data from various OLTP data sources, such as Oracle, MS Access, MS Excel, Flat files, CSV files into SQL Server 2008.
  • Designed packages which utilized tasks and transformations such as Execute SQL Task, Execute Process Task, Send Mail Task, FTP task, Execute Package task, Xml Task, Data Flow Task, Sequence Container, For Each Loop Container, Lookup, Aggregate, Expression, OLE DB Command, and Derived Column.
  • Developed error handling routines for packages using both script tasks as well as in the error handling environment.
  • Created a number of cubes, dimensions and business critical KPIs using SQL Server Analysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance.
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs.
  • Created calculated measures, dimension members using MDX, mathematical formulas and user defined functions, named calculations using SSAS for generation of cubes.
  • Implemented various notifications based upon the scheduling jobs, database monitoring, disaster recovery plans and wrote windows scripting scripts for automation of the tasks.
  • Developed reports by using SSRS and deployed them on web pages using ASP.NET using C#.
  • Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS.
  • Evaluated database performance and performed maintenance duties such as tuning, backup, restoration.
  • Responsible for creating parameterized, cascading, configuration, drill down, rollup reports using SSRS and deploying them into server using report builder.
  • Developed stored procedures, user-defined functions, triggers, indexes, cursors and views in SQL Server, DB2 databases.
  • Developed processes, automation of maintenance jobs, tuning SQL Server, data validations, locks and indexes configurations.
  • Worked on Performance tuning of ETL transformations, data validations and Stored Procedures.
  • Tuned several slow running queries in Production. Implemented Indexes and re-indexed to achieve time performance.
  • Extensive Experience in Migrating Database from SQL Server 2005 to 2008 and 2005 to 2002.
  • Administered SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.

Environment:

Microsoft SQL Server 2000/2005/2008 Enterprise Edition, MS Access, ETL Packages(SSIS), SQL Server Analysis Services(SSAS), MDX, .Net, VB.Net, HTML, IIS, Visual Studio , Visual Source Safe, DTS, T-SQL, Oracle 10g.

Confidential

SQL Developer

Responsibilities:

  • Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
  • Developed and created data dictionary, stored procedures, advanced queries, triggers, views, indices, and functions for databases.
  • Wrote database triggers in T-SQL to check the referential integrity of the database.
  • Created the MS DTS packages for executing the required tasks. Created the Jobs and scheduled for daily running.
  • Created reports from database onto excel spread sheet using DTS.
  • Involved in database management, performance measurement and performance tuning for new databases and existing databases by using SQL Profiler, SQL Analyzer, and SQL Enterprise Manager.
  • Involved in creating maintenance plans in SQL Agent to backup the database.
  • Involved in creating Users and Roles, and managing security and permission of database, managing Jobs and error logs.
  • Worked with development teams in the design of physical databases and in modification.
  • Involved in analyzing MS SQL server (storage, memory, processing) and their dependencies/performance bottlenecks.

Environment:

SQL Server 2005, Windows Enterprise Server 2003, Windows SharePoint Service 2.0, IIS 6, Visual Source Safe 2003, Cryst

Hire Now