We provide IT Staff Augmentation Services!

Sql/ssrs/ssis Developer Resume

Jersey City, NJ

Professional Summary:

  • 8 years of strong experience in the IT industry as a BI Developer and SQL Server Developer in financial, insurance and health domain.
  • Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
  • Experience in MS SQL Server 2008R2/2008/2005 with OLTP/OLAP and Business Intelligence delivery using SQL Server Integration Services and SQL Server Reporting Services.
  • Expert in Microsoft Business Intelligence technologies like SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), and SQL Server Analysis Services (SSAS).
  • Strong in ETL, Data warehousing, Operations Data Store concepts, data marts and OLAP technologies.
  • Strong knowledge of Data Warehousing methodologies and concepts, including star schemas, snowflakes, ETL processes, dimensional modeling and reporting tools.
  • Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
  • Experienced in using Business Intelligence Development Studio (BIDS), Graphical User Interface (GUI) to design SSIS (SQL Server Integration Services) packages for Data Management applications.
  • Excellent experience in migration of data from Excel, Flat file, Oracle to Microsoft SQL Server.
  • Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS).
  • Expert in developing and modifying multidimensional cubes using SQL Server Analysis Services (SSAS).
  • Monitor security batch processing jobs in multi-platform shop via Control-M &Tidal Schedulers.
  • Experience working with scheduling tools like JCI and Tidal.
  • Extensively used tidal in setting up DTS packages, DM Express tasks and jobs, FTP jobsto run daily, weekly and monthly.
  • Hands on experience in implementing Key Performance Indicator (KPI) Objects and partitions in SSAS 2005/2008.
  • Experience in Migration of SSRS reports from SQL 2005 to SQL 2008.
  • Adept in designing Stylish Report layout and having Proficiency with drill down reports in SSRS 2008R 2/2008/2005.
  • Experience in using variables, expressions, functions for the reports and in handling Parameterized reports in SSRS 2005/2008/2008 R2.
  • Developed Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder.
  • Generated reports in various formats like Table format and Matrix format using Reporting services (SSRS).
  • Experience in writing sub reports and parameterized Queries for generating reports in SSRS 2008.
  • Versatile in BIDS (Business Intelligence Development Studio), Query Analyzer, Profiler, SQL Server Management Studio, SQL Server Integration/Analysis/ Reporting Services etc.
  • As a key player in the team with strong interpersonal and communication skills, explored and contributed the technical expertise as and when needed by the team.
  • As part of the team, extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects.
  • Good SQL server administration skills including, backups, disaster recovery, databasemaintenance, user authorizations, database creation.
  • Expert in Creating and Deploying SSRS Reports on the portal for user accessibility.
  • Designed and developed enterprise reports (SSRS/Business Objects) using the data from ETL Loads, SSAS Cubes and various heterogeneous data sources.
  • Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2005/2008.
  • Developed Drill through and Drill down reports using with SQL Server Reporting Services (SSRS).
  • Expert in using Bulk Copy Program (BCP), Data Transformation Services (DTS) packages and SSIS (integration services) with MS SQL Server 2000/2005/2008.
  • Highly proficient in the use of T-SQL for developing complex stored procedures, triggers, tables, user functions, user profiles, relational database models and data integrity, SQL joins and query writing.
  • Proficient in T-SQL queries DDL/DML
  • Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
  • Efficient in up gradation and migration from SQL Server 2000 to SQL Server 2005/2008.
  • Hands on experience in Database Installation, Configuration, Maintenance, Monitoring, Backup and Disaster Recovery procedure and Replication.
  • Quick learner and good performer both in team and independent job environments.

Technical Skills:

MS SQL Server 2008 R 2/2008/2005/2000/7.0 , MS SQL Server 2005/2008 Analysis Services (SSAS), MS SQL Server Integration Service (SSIS), MS SQL Reporting Services (SSRS), , Business Intelligence Development Studio (BIDS), BCP, SQL Profiler, Enterprise manager, Management studio, Microsoft Access 2000, Microsoft Visio 10.0/11.0, T-SQL, IIS 4.0/5.0, VB.NET, HTML, XML, XSL, VB script, Oracle 9i/10g, Visual source safe 2005,TFS, MS office 2003/2007, Windows 2000/2003 Advanced Server/Professional, Windows NT 4.0 Server/Workstation.

Projects Summary:

Confidential, Jersey City, NJ

SQL/SSRS/SSIS Developer

The Confidential is to automate and enhance the e Max Premium Integrity Department’s (the business) premium analysis Process. The business has shifted their reconciliation approach from reconciling to zero dollars to identifying, categorizing, and tracking discrepancies over a period of time in Order to better allocate premium recovery efforts and resources. The purpose of capitation data Maintenance system (CDMS) is to automate and enhance the inflow of capitation data into AMERIGROUP. The business has identified several units which currently import the various Capitation data files and perform varying analysis. The CDMS system shall import the capitation data, allow for quality control checks and edits, perform some common categorizations, and publish the data to the AMERIGROUP data warehouse for consumption by other analysts and systems

Responsibilities:

  • As part of the team, extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects.
  • Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
  • Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008.
  • Created and used tables, views, indexes, stored procedures, triggers, used joins to retrieve data from tables.
  • Monitor security batch processing jobs in multi-platform shop via Control-M &Tidal Schedulers.
  • Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers
  • Extensively designed the packages and data mapping using Control flow task, Sequence container task, Dataflow Task, Execute SQL Task, Data conversion task, Derived Column task and Script Task in SSIS Designer
  • Created packages in SSIS with error handling.
  • Worked with different methods of logging in SSIS.
  • Experience in creating complex SSIS packages using proper control and data flow elements.
  • Involved in the overall SDLC including inception, elaboration, construction and deployment.
  • Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
  • Created SSIS Packages to move the data from tab delimited flat flies into SQL database. Made dynamic SSIS packages which did data scrubbing, including data validation checks.
  • Used SSIS and T-SQL stored procedures to transfer data from OLTP databases to staging area and finally transfer into data warehouse and performed action in XML.
  • Extensively used tidal in setting up DTS packages, DM Express tasks and jobs, FTP jobsto run daily, weekly and monthly.
  • Created SSIS packages and transferred them to the appropriate destinations.
  • Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, tables, and views and other SQL joins and statements for applications.
  • Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule SSIS Packages
  • Created SSIS packages for data Importing, Cleansing, and Parsing etc. Extracted, cleaned and validated.
  • Involved in performance tuning of the database and T-SQL queries using Explain Plan.
  • Created SQL server configurations for SSIS packages.
  • Responsible for creating reports based on the requirements using SSRS 2008.
  • Writing queries to generate reports for analysis of data using SQL Server Reporting Services, Developed and implemented Stored Procedures, Views, and Functions.

Environment: MS SQL Server, SSAS 2008, SSRS 2008, SSIS 2008, ProClarity, T-SQL, XML, ETL, Data Analyzer, MS Access, Excel, SQL Profiler, Windows XP, Win SQL, SQL Server2000, SQL, Tidal.

Confidential , San Jose, CA

MS SQL Server/ SSIS/ SSAS/ SSRS Developer

The project was to integrate the data contained in various heterogeneous file systems to SQL Server database and creation of SSIS packages. Reports have been generated using SSRS 2008.

Responsibilities:

  • Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, working in conjunction with the data warehouse architect on the development of logical data models.
  • Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users.
  • Installed and configured MS SQL Server 2008 along with Visual Studio on a network domain system.
  • Tested the reports and fixed bugs in the stored procedures.
  • Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
  • Established backup and recovery of SQL server 2008.
  • Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
  • Used ADO .NET objects such as data reader, data adapter and dataset to fetch and handle user data with store procedures from SQL Server 2008.
  • Created OLAP cubes and dimensions for the analysis of sales in specific areas using SSAS.
  • Developed and maintained a combined data store for reporting purposes.
  • Generated reports using Global Variables, Expressions and Functions using SSRS 2008.
  • Identified the database tables for defining the queries and defined datasets for report generation.
  • Implemented performance tuning of slow running queries and stored procedures using SQL Profiler and Execution plan.
  • Created SSIS packages to pull data from SQL Server and exported to various data sources like Excel Spreadsheets, Flat File etc. and vice versa.
  • Scheduled SQL jobs to run SSIS packages on a daily, weekly, monthly basis using MS SQL Server Integration Services (SSIS).
  • Used various control flow tasks like FTP, File System task, for each loop container and data flow tasks.
  • Created Excel including pivot tables, macros, and lookup functions to format a data set from the various SQL sources
  • Created complex stored procedures, triggers and user defined functions using joins to apply business rules to data imported using SSIS packages.
  • Deployed SSIS packages from Dev/Staging/Prod using SQL Server table configurations.
  • Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2008.
  • Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2008.
  • Worked with .net Developers for developing custom codes for reporting and excel services as well as for creating SQL Server Objects.
  • Generated daily, weekly and monthly reports for the managers.
  • Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008.
  • Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.

Environment:MS SQL Server , SSAS 2008, SSRS 2008, 2012 SSIS 2008, ProClarity, T-SQL, Visual studio 2008, DTS, Data Analyzer, MS Access, Excel, SQL Profiler, Windows XP, Erwin 4.2, TFS

Confidential, CA

SQL Server/SSIS/SSRS Developer

Confidential offers health care solutions tailored to fit lifestyle and specific health goals. Beyond health coverage, it also provides impactful community initiatives and leadership in improving

HealthCare. The Confidential are committed to improving the health of California residents and advancing the quality of care received by people. The main project goal was to focus on information delivery about Health care providers and billing for care providers and hospitals and also deals with millions of complex patient records.

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.
  • Developed stored procedures, functions, views and triggers.
  • Created SSIS packages to extract data from OLTP to OLAP systems and Scheduled Jobs to call the packages and Stored Procedures.
  • Converted crystal reports to SQL Server reports using Reporting Services.
  • Used various SSIS tasks such as Conditional Split, Derived Column, 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.
  • Used Merge in development, test and production for changing the reference d 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.
  • Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
  • Configured and maintained Report Manager and Report Server for SSRS.
  • Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
  • Generated ad-hoc reports using MS Reporting services and Crystal reports.
  • 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.
  • Performed Documentation for all kinds of reports, DTS and SSIS packages.
  • Created indexes, constraints and rules on database objects.
  • Ensured best practices are applied and integrity of data is maintained through security and documentation.
  • Experienced in making technical specifications report by gathering information from end user.

Environment: Windows XP Professional, SQL Server 2008/2005,SQL Reporting, Business Intelligence Studio, Visual Studio 2008/2005, ADO.Net, OLE DB, DTS Package, SSIS.

Confidential, Virginia Beach, VA

MS SQL Server BI Developer

This project is to build an architecture to host the survey data from different vendors to do reporting on various tools like Quick view, Visualization and do the sentiment analysis whether the customer feedback is –ve or +ve.

Responsibilities:

  • Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
  • Installed SQL Server 2008 and Management tools using SQL Server Setup Program.
  • Created SSIS packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
  • Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
  • Involved in creating highly interactive score cards and Dashboards using Performance Point Server.
  • Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server 2005 from different environments for the SSAS cubes.
  • Generating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
  • Involved in designing, developing, debugging and testing of reports in SQL Server 2005 Reporting Services (SSRS).
  • Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, SQL Server, Excel and Access to SQL Server using Business Intelligence Development Studio.
  • Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column.
  • Wrote T-SQL queries, Store Procedures and used them to build packages.
  • Handled slowly changing dimensions to maintain the history of the data.
  • Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
  • Designed, reviewed, and created primary objects such as views, indexes based on logical design models, user requirements and physical constraints.
  • Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2008.
  • Generated Sub-Reports, Drill down reports, Drill through reports and Parameterized reports using SSRS.
  • Created reports to retrieve data using Stored Procedures that accept parameters.
  • Used SQL Server profiler for auditing and analyzing the events which occurred during a particular time horizon and stored in script.
  • Planned a complete backup on the database and restored database from disaster recovery.
  • Performed daily tasks including backup and restore by using SQL Server 2008 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.

Environment: MS SQL Server 2008 R2,2008, SSIS 2008, SSRS 2008, SSAS, BIDS, Visual Studio 2005, TFS, Erwin 7.2,MS Office & Windows NT/2003, IIS, Windows , Microsoft .NET framework 3.5

Confidential, McLean, VA

MS SQL Server/ SSAS/ SSRS Developer

Confidential is one of the top credit card issuers in the United States. The company offers Visa and Master Card plastic with a variety of annual percentage rates, credit limits, finance charges, and fees. The project involved developing sales reports and statistics to cover weekly, monthly, quarterly and annual historical information for the Sales department database and creation of the data warehouse using SSAS.

Responsibilities:

  • Gathered user requirements and analyzed and designed software solution and database.
  • Updated functional specification and technical design documents.
  • Created complex Stored Procedures, DTS packages, triggers, cursors, tables, views and SQL joins and statements for applications.
  • Developed T-SQL (DDL, DML) statements using dynamically generated SQL.
  • Designed an OLAP system with the help of ERWIN to visualize data structure.
  • Extracted data from heterogeneous sources and transferred to OLAP using SQL Server Integration Services (SSIS) 2005.
  • Created ASP.NET web pages and wrote code behind pages using C#.NET.
  • Created SQL server Analysis Projects and created multi-dimensional databases and OLAP cubes and dimensions for the analysis of sales in specific areas using SSAS.
  • Improved query performance by cube partitioning.
  • Reviewed and changed the cubes in the data marts for product valuation based on the revenue opportunities using SSAS 2005.
  • Generated daily, weekly and monthly reports using SSRS 2005.
  • Written code for Database connectivity and interaction using ADO.NET.
  • Implemented the calculations to aggregate physical measures using management studio.
  • Identified and defined the scoped assignments using script commands.
  • Defined Reference d relationships with the measure groups and fact tables.
  • Managed and monitored the system utilization by using the query optimizer and checking the execution plan.
  • Implemented client side and server side validation using java script and ASP.NET validation control.
  • Extensively used Profiler to identify and repair database lockups, deadlocks, and other issues.
  • Established a sound backup and recovery policies and procedures.

Environment: MS SQL Server 2005 Enterprise Edition, MS SSAS 2005, MS SSRS 2005, MS SSIS 2005, DTS, T-SQL, Windows Server 2003,Erwin 4.0.

Confidential, Chadds Ford, PA

MS SQL Server Developer

Confidential is a specialty pharmaceutical company focused on high value branded products and specialty generics in pain, urology, oncology and endocrinology. The main objective of the project was to collect data from various database sources to perform analysis and then integrate the various source databases into a centralized database.

Responsibilities:

  • Created Logical and Physical data models using ERWIN data modeling tool.
  • Developed complex Stored Procedures, Functions, DTS packages, Triggers, Cursors, Tables, Views, Indexes and other SQL joins and statements for applications.
  • Migration of the data from various sources using DTS.
  • Scheduled and performed data transfers using DTS including filtering appropriate to the data mart for data analysis.
  • Compressed data files by removing empty database pages and updating index statistics.
  • Developed and edited many complex reports with Crystal Reports 10.
  • Designed and implemented user login and security.
  • Managed and monitored the system utilization by using the query optimizer and checking the execution plan and worked in Enterprise Manager for job scheduling and batch queries.
  • Planned the complete back-up of databases for disaster recovery scenarios.
  • Worked with .net Developers for developing custom codes for reporting and excel services as well as for creating SQL Server Objects.
  • Reorganized database structures as needed, automated procedures at regular intervals.
  • Optimized long running Stored Procedures and Queries for effective data retrieval.
  • Involved in project planning, scheduling for database module with project managers.

Environment:MS SQL Server 2000 Enterprise Edition, MS Access, DTS, T-SQL, Query Analyzer, BCP, SQL Profiler, Windows 2000 Server, IIS, ASP.NET, Erwin 4.0, Crystal Reports 10

Confidential, Northbrook, IL

MS SQL Server Developer

Confidential including auto insurance, home insurance, life insurance, and commercial insurance and is the second-largest of all personal lines insurers in the world. The project was upgrading of the server from a MS SQL server version 7.0 to the MS SQL 2000 version and generation of reports using crystal reports version 9.0

Responsibilities:

  • Developed logical and physical database using Erwin.
  • Designed DTS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager on SQL Server 2000 environment, and deploy the data, scheduled the jobs to do these tasks periodically.
  • Optimized schema, performance, and capacity planning of various data transformation processes related to the reports.
  • Worked with .net Developers for developing custom codes for reporting and excel services as well as for creating SQL Server Objects.
  • Made sure that standards and best practices in database development were followed and maintained.
  • Implemented client side and server side validation using java script and ASP.NET validation control.
  • Scheduled and monitored all maintenance activities of SQL Server 2000 including database consistency checks and index defragmentation.
  • Set up database backup and recovery strategies.
  • Tuned SQL Statements using Indexes and designed and implemented the Stored Procedures and Triggers for automating tasks.
  • Maintained all records of project status and followed changes as per control procedures.
  • Provided technical support to internal developers and external clients.
  • Generated reports, test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.

Environment: MS SQL Server 2000/7.0, Windows Server, Windows NT, Erwin, Crystal Reports 9.0

Hire Now