Ms Sql Server Developer/ssis/ssrs Resume
SUMMARY
- Over 8 years of strong experience in the IT industry as a MS SQL Server 2008/2005/2000 Developer/BI Developer in various domains likes financial services, insurance and banking. Maintained positive communications and working relationship at all levels. An enthusiastic and goal - oriented team player possessing excellent communication, interpersonal skills with good work ethics
- Experienced in Installing, Upgrading and Configuring Confidential SQL Server 2008/2005/2000 .
- Experienced in client requirement Analysis, Physical, Logical design, development (using Erwin, normalization and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications using SQL Server 2008/2005/2000 , SSIS, SSAS and SSRS 2005/2008.
- Expert in TSQL, creating and using Stored Procedures, Views, User Defined Functions, implementing Business Intelligence solutions using SQL Server 2000/2005/2008.
- Installation of SQL on VM.
- Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating Effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
- Expert in SQL Server Import/Export wizard to migrate the Heterogeneous databases such as Oracle and MS Access database, flat files to SQL server 2005.
- Proficient in designing reports using SQL Server Reporting Services (SSRS) and Excel Pivot table based on OLAP cubes which make use of multiple value selection in parameters pick list, cascading prompts, matrix dynamics reports and other features of reporting service.
- Successfully designed complex reports like reports using Cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and ad hoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
- Excellent experience in data Extraction, Transformation and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), DTS, Bulk Insert and Bulk Copy Program utility.
- Worked on net backup application to use point time recovery for particular database.
- Experienced in Designing, Developing and Maintaining Web Applications using Visual Studio.
- Expert with SharePoint and Performance point server.
- Highly experienced in creating, configuring and scheduling the Dynamic SSIS packages using containers and variables.
- Experienced in creating many complex SSIS packages with complicated transformations using SQL Server Integration Services (SSIS).
- Expert in developing and deploying cubes using MS SQL Server 2005 Analysis Services involving multidimensional data.
- Worked extensively in Query Optimization and Performance Tuning using tools SQL Profiler, Index Tuning Wizard and database Engine Tuning Advisor.
- Experienced in working with HPQC Tool.
TECHNICAL SKILLS
- MS SQL SERVER 2008/2005/2000
- SQL Server Integration Services (SSIS)
- SSRS
- SSAS
- DataTransformation Services MS SQL SERVER Management Studio
- SQL SERVER Business Intelligence Development Studio (BIDS)
- Confidential
- Confidential ++
- SQL
- T-SQL
- MS VISUAL STUDIO 2005/2008
- MS ACCESS 2007/2003
- Crystal Reports 8.5/ 9/10
- ERWIN 7.
PROFESSIONAL EXPERIENCE
Confidential
MS SQL Server Developer/SSIS/SSRS
Responsibilities:
- Involved in the Migration of Databases from SQL Server 2000 to SQL Server 2008.
- Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures.
- Wrote data retention process for reporting database to keep 60 days report history.
- Worked on recursive CTE, to work with hierarchical data sets.
- Designed SSIS Packages to transfer data from flat files to SQL Server using Business Intelligence Development Studio.
- Developed, deployed, debugged and monitored SSIS Packages.
- Loaded flat files (4GB) data into database using SQL Server Integration Services (SSIS) after applying various transformations likeDerived column, Data Conversion, Script Task etc.
- Used SSIS Package configuration to export various package properties to make package environment independent.
- Created Merge queries to handle insert/delete/update flags from CDC inflow data and updating target table accordingly.
- Created Job monitoring Dashboard for higher management to keep track of daily job status to monitor Dev, UAT, Prod job using SSRS report.
- Created several financial reports providing advanced functionality like drill down, matrix, drill through, etc.
- Created COGNOS reports as per business requirements.
- Designed complex SSAS solutions using multiple dimensions, perspectives, hierarchies, measures groups and KPIs to analyze performance of Strategic Business Units as well as corporate centers.
- Extensively worked on excel report to deliver cube data to end-user.
- Wrote VBA MACRO for formatting in drill through Excel reports.
- Used SSAS cube as source in various SSRS reports.
- Loading data from AS 400 server to Hadoop using scoop command using hive.
- Writing Store Procedure on Oracle using Toad for Oracle 11.6.
- Worked on composite studio to virtualized object from IBM, SQL server.
- Worked on creating queries from composite instead of doing open query on IBM server.
- Work on Toad Data Analyst 3.0 to write composite virtualized object query.
- Introductory training for Golden Gate, Data Stage, ODI (Oracle Data Integrator).
Confidential, Huston, TX
MS SQL Server Developer/SSIS/SSRS Developer/DBA
Responsibilities:
- Team member of agile project and responsible for project planning for sprints, participated in story building for multiple sprints.
- Involved in designing the data warehouse and core Database for the system including tables, Stored Procedures, Indexes, UDF and triggers.
- Performed operations such as Fine-tuning queries and stored procedures and providing consultation to other developers.
- Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
- Used Query Analyzer and SQL Server Profiler for tuning report queries and improves performance in SQL Server.
- Designed SSIS Packages in SQL Server 2008 to handle data migration (ETL Processes) from transaction System to Dimensional Model.
- Implemented SSIS (ETL) to extract and transform data from RDBMS and Flat files/CSV, SQL Server 2005 instances and to load into staging and then to DW for further Data Analysis and Reporting by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
- Migrate a data from different sources like DB2, MySQL, OLEDB, flat files, Excel file to load into sql server management studio and data ware house.
- Scheduled and maintained nightly and weekly loads of financial data by creating the corresponding job tasks.
- Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions.
- Created complex scripts to do chucking and massaging of legacy data in staging area of SSIS package.
- Dropped and recreate Index on the DSS system while data migrating.
- Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.
- Used highly complex TSQL queries and SQL Scripts to perform efficient data load based on complex business rules and produced results for users.
Confidential, Omaha, NE
Responsibilities:
- Upgraded databases from SQL Server 2000 to SQL Server 2005.
- Streamlined the server/database level security by creating the Windows and SQL logins with the appropriate server/db. Roles and object level permissions.
- Successfully migrate the DTS and SSIS packages from one server to another.
- Worked with various business groups while developing their applications, assisting in database design, installing SQL Server clients, phasing from development to QA and to Production environment.
- Install Sql on virtual server.
- Used Data Transformation Services (DTS)/SQL Server Integration Services (SSIS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
- Configure the post installation step on new server to make the server ready for migration.
- Setup Database Maintenance Plans to reorganize indexes, re-indexing and update the index statistics on the production databases.
- Worked extensively on database administration, storage maintenance, software upgrade, installation, replication monitoring, backup &recovery planning, partition tables, indexes, and performance tuning.
- Rebuilding the indexes at regular intervals for better performance.
- Migrate the existing logins from one server to another server; avoid the logins, which are not in active directory.
- Designed and implemented comprehensive Backup plan and disaster recovery strategies Implemented and Scheduled Replication process for updating our parallel servers.
- To provide 24x7 production support for SQL Server databases on Clustered Servers with sizes ranging from 1 to 2 Terabytes to achieve maximum performance and uptime in production environment.
- Conducted various meetings and conferences with application teams to meet corporate milestones for database consolidation and data migration. Security and architectural planning issues met as well as testing and training.
- Created dynamic reports using SSRS for the monthly connections and details of all locations, generated report models using report builder for the end users.
- Involved in scheduled reports on a weekly basis that was generated every Friday containing the details of weekly sales for our location for assessing the business for that week.
- Involved in restoration of point time recovery using net backup.
- Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views in the centralized SQL database.
- Configure the security policy as per company on the particular server for restricted users only to avoid
- Improved Performance of the database by creating Clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
Confidential, Redmond, WA
Responsibilities:
- Performed data cleansing by creating tables to eliminate the dirty data using SSIS.
- Handling Live site issue and monitoring night jobs.
- Responsible for Deploying the SSIS packages and scheduling the package through Jobs in all Tiers including Dev., UAT and Prod, Setting the Configuration files which is done in the specified tables and created technical specs documents for all the enhancements.
- Use of .Net Scripts in various packages and reports.
- Create Reports using SharePoint as a backend.
- Deploy SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
- Imported data from text files and excel spreadsheets intoSQL Server2008 database using SSIS package.
- Used system tables like sys.sysreferences, sys.objects, sys.tables to identify required tables from the database.
- Worked with T-SQL to create Tables, Views, and triggers (DML and DDL) and complex stored Procedures
- Used Script task for Data Flow and Error Handling in SSIS.
- Wrote complex SQL queries using joins, sub queries and correlated sub queries to retrieve data from the database.
- Created/Updated database objects like tables, views, stored procedures, function, packages,
- Generated Drill down, Drill through, Ad-hoc, Matrix Reports, parameterized reports using SSRS.
- Created Standard and data driven subscriptions for daily report delivery.
- Use power view to create presentation for stakeholders.
- Work with Power pivot to create a report in excel sheet.
- Designed and developed monthly, quarterly and yearly reports.
- Monitored the overall performance of the database to recommend and initiate actions to improve/optimize Performance.
- Worked on standard SQL profiler, tuning advisor, index tuning, troubleshooting methods & techniques
- Used SQL Server Profiler to trace the slow running queries and the server activity.
- Automated and enhanced daily administrative tasks including database backup and recovery.
- Involved in setting up SQL Server Agent Jobs for periodic Backups with backup devices, database maintenance plans and recovery.
Confidential, Harrisburg, PA
MS SQL Server Developer/BI Developer/SSIS/SSRS Developer
Responsibilities:
- Migrated data from Heterogeneous data Sources and legacy system (DB2, Access, and Excel) to centralized SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
- Created packages to validate, extract, transform and load data to a centralized SQL server using OLEDB providers from the existing diversified data sources. .
- Successfully involved in performing incremental loads while transferring data from OLTP to data warehouse using different data flow and control flow tasks in SSIS.
- Involved in maintaining batch log tables and error logging tables to handle errors using event handlers.
- Involved in creating SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending mails upon package deployment.
- Migrated packages from development server to production server using package configuration.
- Involved in creation of fact and dimension tables in the OLAP database and created cubes using MS SQL Server Analysis Services (SSAS).
- Identified and modified the Key Performance Indicators (KPIs), measures in co-ordinance with the requirement.
- Extensively used SQL Server Reporting Services 2008 with relational and multidimensional data.
- Created dynamic reports using SSRS for the monthly connections and details of all locations, generated report models using report builder for the end users.
- Involved in scheduled reports on a weekly basis that was generated every Friday containing the details of weekly sales for our location for assessing the business for that week.
- Developed, tested and implemented Referential Integrity rules and regulations through constraints, triggers and views in the centralized SQL database.
- Performed data cleansing by creating tables to eliminate the dirty data using SSIS.
- Developed User Defined Functions, indexes to generate the distinct data based on the type of the customer base.
Confidential, Wilmington, DE
SQL/SSIS/SSRS/SSAS Developer
Responsibilities:
- Involved in Planning, Defining and Designing data base using Erwin on business requirement and provided documentation.
- Designed SSIS Packages to transfer data from various sources like Text Files, XML Files, SQL Server, Excel and Access to SQL Server.
- Successfully Developed and Deployed reports in MS SQL Server environment using SSRS-2005.
- Designed, reviewed, and created primary objects (views, indexes, etc.) based on logical design models, user requirements and physical constraints.
- Created SSIS (SQL Server Integration Service) packages to extract data from OLTP to OLAP systems and scheduled Jobs to call the packages and Stored Procedures.
- Applied various data transformations like Slowly Changing Dimension, Aggregate, Sort, Multicasting, Conditional Split, Derived column.
- Responsible for optimizing all indexes, SQL queries, stored procedures to improve the quality of software.
- 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.
- Used “SQL Profiler TSQL Duration” template for tracking execution time of TSQL Statements.
- Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor
- Involved in configuration of report server and report manager scheduling, give permissions to different level of users in SSRS.
- Modified the existing SSIS packages to meet the changes specified by the users.
- Documented and prepared project status report updates and audit reports.
Confidential, Milpitas, CA
MS SQL Server Developer/BI Developer/ SSRS Developer
Responsibilities:
- Worked with application developers and production teams across functional units to identify business needs and discuss solution options.
- Successfully Installed and configured MS SQL Server 2008 on the production server.
- Transformed data from various data sources using OLE DB connection by creating various SSIS packages.
- Generated Assessment Reports to analyze the Scope and Complexity of the migration projects.
- Converted the Oracle DB objects to MS SQL Server 2008 DB objects like Tables, Views, and Stored Procedures.
- Designed a new schema for the Data warehouse using Dimensional Modeling and developed it using the Erwin tool.
- Migrated the entire schema as well as data into MS SQL Server 2008 and also validated the migration process to ensure that it has been successfully migrated.
- Created SSIS packages to load data from the OLTP system to a Data mart for analyzing data.
- Performed transformations like Conditional Split, Sorting and included data about the environment using the Audit Transformation.
- Developed and optimized database structures, Stored Procedures, Indexes, Views, Triggers (DDL & DML), Cursors and User Defined Functions (UDF).
- Perform weekly database checkup, shrink database according to instructions, and document weekly database activities.
- Experience in generating reports and deploying it in to the server using SSRS (SQL ServerReporting Services).
- Developed and rendered monthly, weekly and Daily reports as per the requirement and gave roles, user access with respect to security in report manager.
- Created simple query filters, prompted filters and complex filters to restrict data in reports.
- Documented the developed work and production release for future reference.
- Generated dynamic reports from cubes (SSAS) using SSRS.
- Designed a new schema for the data mart databases.
- Implemented SSAS cubes, facts and dimension tables to perform analysis.
Confidential, Framingham, MA
MS SQL Developer /SSRS Developer
Responsibilities:
- Gathered business requirements, definition and design of the data sourcing and data flows, data quality analysis, and working in conjunction with the data warehouse architect on the development of logical data models.
- Designed and implemented complex SSIS package to migrate data from multiple data sources for data analyzing, deploying and dynamic configuring of SSIS packages.
- Created logical and physical data models using Erwin for new requirements after discussion with technical team and application users as per agile methodology.
- Migrated database from SQL server 2000 to SQL server 2005 using SSIS packages.
- Designed high level ETL (Extraction Transformation Loading) architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
- Extensively used SSIS for transferring data manually from DTS packages to SSIS packages using SSIS 2005.
- Developed and maintained a combined data store for reporting purposes.
- Generated reports using Global Variables, Expressions and Functions using SSRS 2005.
- Identified the database tables for defining the queries and defined datasets for report generation.
- Defined report layouts including report parameters and wrote queries for drill down reports using SSRS 2005.
- Created parameterized, drill down and aggregation reports in MS SQL environment using SSRS 2005.
- 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 2005.
- Tested the reports and fixed bugs in the stored procedures.
- Managed the Metadata associated with the ETL processes used to populate the Data Warehouse.
- Established backup and recovery of SQL server 2005.
Confidential, living stone, NY
MS SQL Server Developer
Responsibilities:
- Designed SSIS packages to transfer data between servers, load data into database, archive data file from different DBMS’s using SQL Enterprise Manager/SSMS on SQL Server 2000 environment, and deploy the data; Scheduled the jobs to do these tasks periodically;
- Developed logical and physical database (using ER-win, Normalization, Dimension Modeling and Enterprise Manager).
- Optimized schema, performance, and capacity planning of various data transformation processes related to the reports.
- Made sure that standards and best practices in database development were followed and maintained.
- Scheduled and monitored all maintenance activities of SQL Server 2000 including database consistency checks and index defragmentation.
- Set up database backup and recovery strategies.
- 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 test data and tested database to meet the functionalities/deliverables in the project documentation and specifications.
Confidential
MS SQL Server Developer
Responsibilities:
- Creation, manipulation and supporting the SQL Server databases.
- Involved in the Data modeling, Physical and Logical Design of Database
- Created tables, indexes, sequences, constraints, triggers and procedures.
- Stored procedures and triggers were used to implement business rules.
- Helped in integration of the front end with the SQL Server backend.
- Used DDL and DML for writing triggers, stored procedures and data manipulation.
- Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS).
- Write T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries.
- Managed rollback segments, and table spaces to ensure less space used by the database.
- Created documentation on the all the tables, stored procedures, views and user defined functions.
