We provide IT Staff Augmentation Services!

Bi (sql) Developer / Dba Resume

3.00 Rating

NY

PROFESSIONAL SUMMARY:

  • Highly motivated IT Professional with 8 years of experience in Database Development, Design, System Analysis and Support of MS SQL Server 2008/2005/2000 and Business Intelligence Applications
  • Worked with end users/customers to understand business requirements, recommended technical solutions and documented functional requirements
  • Good team player, strong interpersonal and communication skills combined with self - motivation, initiative and quick learner
  • Expertise in writing T-SQL Queries, sub-queries and complex joins for generating Complex Stored Procedures, Triggers, User-defined Functions, Views and Cursors
  • Expert in using SQL Server Agent to Schedule and monitor Jobs
  • Extensive working experience in Normalization and De-Normalization techniques for both OLTP and OLAP systems in creating Database Objects like tables, Constraints and Indexes
  • Extensive experience in using SQL Server Profiler to monitor the SQL server for deadlocks, long running queries and tune the same to improve performance
  • Maintenances plan for consistency check (DBCC) and maintained Index statistics of Database Application
  • T-SQL Programming using DDL, DML, DCL commands for various business applications
  • Experience in Error handling and debugging coding issues and troubleshoot production problems
  • Extensive Experience in RDBMS concepts such as Tables, User Defined Data Types, Indexes, Indexed Views, Functions, CTE, Table Variables and Stored Procedures
  • Experience in SQL Optimizing by using SQL Profiler, Index Tuning Wizard, Database Tuning Advisor, DBCC Commands, DMV’s and Query Execution Plans
  • Proficient in performing DBA tasks including installing and configuring SQL servers and backups/restore and recovery of databases
  • Expertise in implementing efficient Disaster Recovery Strategies and High availability like Snapshot, Transactional and Merge Replication, Log shipping, Clustering (Active/Passive) and Database Mirroring
  • Performing Data transfer between different homogeneous/heterogeneous systems (Excel, MS Access, Oracle and DB2) and SQL Server as a part of Data Migration, Data Maintenance and other ETL tasks
  • Expert in usage of SSIS Control Flow items(for each Loop, Execute package/SQL tasks, script task, send mail task) and SSIS Data Flow items (Conditional Split, Data Conversion, Fuzzy lookup, Union all, Pivot/ Unpivot)
  • Used incremental approach in the Work Flows and Data Flows to integrate source data into warehouse tables using required transformations
  • Expertise in configuring and creating SSIS solutions for ETL and Business Intelligence Process for Data Integration and Migration services
  • Expertise in Merging data from various Heterogeneous sources, Populating Dimension and Fact tables in Data warehouses and Data Marts, Cleaning and Standardizing data loaded into OLTP and OLAP databases using SSIS
  • Expertise in creating and managing Package Configurations, Logging system, Package deployment and User-defined Variables for SSIS Packages
  • Strong Experience in creating Ad Hoc, parameterized reports, Linked reports, Snapshots, Drilldown and Drill through reports using SQL SSRS 2005/2008
  • Expertise in resolving SQL Reporting services and T-SQL related issues and formatting the reports
  • Worked with report manager for deploying the reports across all the environments
  • Expert at developing ETL interfaces using SSIS and enterprise reports using SSRS utilizing latest versions (2005/2008) & features
  • Expert in automating process by creating jobs and error reporting using Alerts, SQL Mail Agent, FTP & SMTP
  • Created various SSRS Reports involving variety of features like Reports, Charts, Filters, Sub-Reports, Drilldown, Drill-Through, Multi-valued parameters etc.

TECHNICAL SKILLS:

Database: RDBMS, SQL Server 2000/2005/2008, MS Access

Languages: C language, T-SQL

Data warehouse Tools: SSIS, SSAS

Reporting Tools: SSRS, Cognos

Operating Systems: Windows NT/98/2000, DOS, Windows Server 2003, Windows Server 2005

Web Technologies: HTML, ISS, and XML, XSLT, Dream weaver

Packages / Applications: MS Office, Visual Source Safe, SQL Log Explorer, Visual Studio.NET, MS Visio, Remedy, XML Spy, Microsoft Project, Red-gate Bundle, Ultra edit

PROFESSIONAL EXPERIENCE:

Confidential, NY

BI (SQL) Developer / DBA

Responsibilities:

  • Responsible for maintain and enhance the existing data warehouse, reports and troubleshooting & problem solving of Production database
  • Worked very closely with SAP and Cognos team to analyze the organization’s dashboard, critical reporting requirements of business & end-users
  • Implemented Complex business logic with User-Defined-Functions, Index Views and Clustered & Non-clustered Indexes
  • Installed and configure servers and clients using SQL Server 2008, Upgraded SQL databases
  • Created complex Stored Procedures, Triggers, Functions (UDF), Indexes, Tables, Views and other T-SQL code and SQL joins for the applications following SQL code standards
  • Used Data Manipulation Language (DML) to insert and update data, satisfying the referential integrity constraints
  • Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs
  • Rewrite the existing code for long running queries by replacing cursors with various joins, common table expression (CTE) and indexing
  • Developed DTS/SSIS Packages that loads data files, extracted from SAP and Oracle DB, into SQL database with necessary transformation
  • Created SSIS package using for each loop transformation to load multiple files from same source folder
  • Migrated SQL server 2000 DTS packages to SQL Server 2008 SSIS packages using SQL Server 2008 Upgrade Advisor
  • Developed SSIS Packages that loads data files, extracted from SAP and Oracle DB, into SQL database with necessary transformation
  • Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load
  • Created SSIS packages with error handling and worked with different methods of logging in SSIS
  • Created SSIS packages to retrieve data from Legacy sources and also to retrieve user data from the Flat files on daily, monthly and weekly basis
  • Created jobs to collect status information from various servers and feed them to the Master Server
  • Maintained the physical database by monitoring and optimizing performance, data integrity and SQL queries for maximum efficiency using SQL Profiler
  • Worked on Transactional Replication and replicated thousands of tables from various Databases to different production Server
  • Created database maintenance planner for the performance of SQL Server, which covers Database integrity checks, update Database statistics and re-indexing
  • Performed DBA activities of daily backup and failover restore of database, monitoring/scheduling jobs on different production servers using Red Gate tool
  • Managed SQL user logins, database user accounts, server roles, database roles and its permissions
  • Created data flow model using MS Visio
  • Created maintenance plan for consistency check (DBCC) and maintained Index statistics of Database Application
  • Worked with end users to analyze data flow process and understand requirement for the finance reporting
  • Perform performance tuning, optimization, Bug Fixing and Enhancement during the various quality assurance testing cycles and for the Production dash board report using Database Performance monitoring tools

Environment: SQL Server 2000/2005/2008, Windows Enterprise Server 2003/2008, Enterprise Manager, SQL Server Management Studio, Oracle 10g, SQL Server Business Intelligence Studio, SQL Server Profiler, XML, SAP, MS Visio,, Cognos 8, Excel, T-SQL

Confidential, NJ

SQL Server Developer

Responsibilities:

  • Installed and maintained multiple SQL server 2008 instances in non-production (test, staging) environments
  • Handling installation and creation of new instances of SQL server databases, Managing user creations, assigning roles, security to SQL databases
  • Designed the database and table structure and data partitioning and indexes for optimum query performance
  • Created several tables, views using SQL Server management studio, based upon the functional specifications and primary key & foreign key constraint
  • Deployed database objects from development/testing environment to production environment
  • Design, Develop and Maintain complex queries, views, store procedures, triggers, cursors and SSIS packages
  • Implemented database standards and naming convention for the database objects
  • Extensively used TSQL to manipulate and architect to produce results for users
  • Used multiple join statements to retrieve data from multiple several tables
  • Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance
  • Cleaned dirty data of excel sources using Fuzzy lookup and Fuzzy group transformation and load back to database using SSIS
  • Performed daily tasks including backup and restore by using SQL Server Management Studio
  • Setup profiler traces to support trouble shooting activities in QA environments
  • Created report for policy holders by using Excel pivot table and SQL server Reporting service (SSRS)

Environment: SQL Server 2008, Windows 2003, SSIS, SSRS, Excel, T-SQL

Confidential, PA

SQL Server Developer

Responsibilities:

  • Performed various SSIS tasks such as Conditional Split, Derived Column on the data retrieved, performed Data Validation Checks during Staging, and then loaded the data into the Data warehouse
  • Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS and DTS
  • Used efficient task objects/connections/work flows in packages based on data volumes and data sources
  • Created SQL Server Reports using SSRS 2005
  • Created detailed reports for the customers to help them to understand detail of products and demographic information based on various parameters
  • Configured XML config files (.dtsconfig files) to change properties of packages dynamically
  • Fine-tuned DML, DDL scripts with lock hints for performance boost
  • Designed and developed Data Warehouses, Data marts and Business Intelligence using multi-dimensional models such as Star Schemas and Snow Flake Schema for developing Cubes using MDX
  • Created complex SSAS cubes with multiple fact measures groups, and multiple dimension hierarchies based on the OLAP reporting needs
  • Extensively worked on Dimensions and measures using SSAS
  • OLAP model based on Dimension and Facts for efficient loads of data based on Star Schema structure on levels of reports using SSAS
  • Used SQL profiler to view indexes performance to mostly eliminate table scan
  • Used highly complex TSQL Queries and SQL Scripts to perform efficient data load based on complex Business rules
  • Created stored procedures, views, triggers, user defined functions to in corporate the flow of business and called various stored procedures from DTS to make the flow of DTS effective
  • Involved in project status report updates/ creation of issue items for reviews/ updates of technical and transformation files on timely basis
  • Extensive Data Modeling skills for Logical and physical database design using Erwin tool
  • Helped Development Team in deploying and testing the application, which uses SQL Server as a database
  • Used DBCC utilities to fix data corruption in application databases
  • Used third party tools like Red gate for compressed backups and easy to restore
  • Documented all the new procedures, troubleshooting issues and solutions, Enhancement and changes in Daily and monthly running processes, and maintain the database for future
  • Involved in administration, performance analysis, and production support for large (VLDB) databases up to 1 TB

Environment: SQL Server 2003/2005, SQL Server Management Studio, SQL Server Business Intelligence Studio, SQL Server Profiler, XML, Erwin, Microsoft Visio 2003, TFS,, UML, XML, C#, T-SQL, ODBC, Excel, SSAS, SSIS, SSRS

Confidential, Kansas City, MO

SQL Server Developer

Responsibilities:

  • Evaluated data storage considerations to store databases and transaction logs, Optimized the physical disk performance through RAID-1, RAID-5 levels for fault tolerant database partitions
  • Worked in the development of complex Stored Procedures, Triggers, functions, DTS packages to support multiple business applications. Developed and maintained Stored Procedures using T-SQL
  • Worked extensively in tuning and optimizing the performance of production databases by creating new indexes and re-writing SQL queries to utilize indexes
  • Participated in Test Plan, test case review meetings and Supported QA activities
  • Extensive experience in trouble shooting of client connections, viewing error log and applications
  • Created application Schema (Database, Tables, Views and Indexes) and implemented various SQL, Transact-SQL statements, stored procedures and UDF (User Defined Functions) according to the requirements of the project
  • Used DBCC utilities to fix data corruption in application database
  • Followed the Microsoft recommended best practices in designing, developing, and implementation and testing of the ETL using SQL Server Integration Services
  • Created the Data Model for the Marketing Information System Team using Erwin
  • Created and modified procedures, triggers and functions
  • Writing and Scheduling Execution of Scripts to update converted data from the Holding Tank data, to validate the converted data
  • Managing logins, roles, assigning rights and permissions. Created views to implement security
  • Used profiler to monitor the performance, Debug Transact-SQL statements and stored procedures in existing application, to identify slow running query etc.
  • Used DTS packages to do file operation, to apply business rules
  • Extensively used Ultra-Edit to verify the text file provided by employer/agency and keep trace of files provided by employer/agency
  • Transformed data from text file to SQL server using SSIS
  • Deployed database objects from development/testing environment to production environment
  • Migrated data from legacy system (text based files, Excel spreadsheets, and Access) to SQL Server databases using DTS, SQL Server Integration Services (SSIS) to overcome the transformation constraints
  • Debugging and troubleshooting the technical issues while implementing the applications
  • Created, designed and deployed drill down reports using MS SQL Server reporting services (SSRS)

Environment: Windows XP, Windows 2003, Terminal Server, T-SQL, C#.NET, ADO.NET, SQL Profiler, SQL Jobs, SQL Server Management studio, SQL Server 2005, SSIS, SSRS, SSAS

Confidential, Clark, NJ

SQL Server Developer

Responsibilities:

  • Involved in gathering the requirements from the client and converting them in to design specifications
  • Created logical and Physical database design, data structures, primary key, foreign key and implemented large databases using Erwin
  • Involved in extracting the data using SSIS from OLTP to OLAP, Creation and execution of TSQL Scripts
  • Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic email notification and SQL Server backup strategy and automation
  • Used Active-X Scripting in SSIS (SQL Server Integration Services) for transformation of data in to staging tables and also to extract data from database tables and write the data to text files
  • Proper use of Indexes to enhance the performance of individual queries for very fast and efficient reporting process
  • Developed and optimized database structures, Stored Procedures, Indexes, Views, Triggers, 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 Server Reporting Services)
  • Provided back-end support for functional testing and performance testing
  • Organized data from a data warehouse into multidimensional cubes with SQL Server Analysis Services (SSAS) to allow the execution of sophisticated reports and complex queries
  • Monitoring the CPU usage, IO statistics, Memory usage to identify any OS level performance killers, enabling database level trace for performance test
  • Extensively involved in maintaining & updating the database documentation
  • Generated business report for the Different policies, Mutual Funds, Fixed Income ETF etc.

Environment: SQL Server 2000/2005, Windows 2003/XP, Enterprise Manager, SQL Server Management Studio, SQL Server Business Intelligence Studio, C#, .Net 2.0, SQL Server Profiler, SSRS, SSIS, SSAS, T-SQL, PL/SQL MS Visual Source safe

Confidential

SQL Serve Developer/ DBA

Responsibilities:

  • Installation and configuration of SQL Server 2000 on Window 2000 OS
  • UsedT-SQLfor programming forstored proceduresandqueries
  • Handling Database Objects with Enterprise Manager and Query Analyzer
  • High level of expertise in implementing different types of Replication Models such as Transactional, Snapshot and Merge Replication and failover clustering
  • Managing of database objects like Tables, Views, stored procedures, Indexes etc.
  • Maintained login and user management in SQL Server database by managing of users including creation/alteration, grant of system/db roles and permission on various database objects,
  • Developed DTS packages to transfer the data between SQL Server and other database and files
  • Automated the DTS/ETL to import and export data form text/ Excel file, in different format, to SQL Server and vice versa
  • Well experienced with tools like Query Analyzer, SQL Enterprise Manager
  • Used Data Transformation Services (DTS), an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources using the concept of OLE DB
  • Creation and management of database maintenance plan for various database consistency checks
  • Used SQL Profiler to monitor the server performance, debug T-SQL and slow running queries
  • Automation and execution of data transformation scripts
  • Developed T-SQL scripts to enforce business rules and creating reports from OLAP database

Environment: SQL Server 2000, Windows NT, Visual Studios 2005,Visual Basic 6.0, VBScript, Excel, MS Access, T-SQL, SQL enterprise manager, DTS

We'd love your feedback!