SUMMARY

• Highly motivated SQL server developer with 7+ years of IT experience with database development/Administration on data design, and business intelligence technologies with expertise on ETL process, reporting and support using SQL server 2012/2008/2005, SSIS and SSRS.
• Strong experience in client requirement analysis, physical, logical design development, resource planning, coding, debugging, testing, deployment, support and maintenance of business intelligence applications using SQL Server 2000/2005/2008/2012, DTS, SSIS, SSRS and SSAS 2005/2008/2012.
• Worked on .NET applications.
• Primary knowledge on C# and ASP.NET.
• Expert in writing T - SQL queries, stored procedures, common table expressions (CTEs),user defined functions, indexed views and DDL/DML triggers for data consistency and data manipulation.
• Expertise in performing most of the SQL server enterprise manager and management studio functionality using T-SQL scripts and batches.
• Excellent experience in writing complex SQL queries involving multiple tables’ inner joins and outer joins.
• Expert level knowledge in relational database management system (RDMS) and data warehouse concepts such as tables, user defined data types, indexes and indexed views.
• Strong experience in optimizing various queries by creating clustered, non-clustered indexes, and indexed views.
• Well experienced in writing distributed queries between various SQL servers by creating link servers and federated servers.
• Strong experience in OLTP and OLAP systems.
• Extensively worked on ETL processes using SSIS packages.
• Extensive experience in data extraction, transforming and loading (ETL)using SQL Server Integration Services (SSIS), DTS, Bulk Insert and Bulk Copy Program (BCP).
• Experience in migration management by using SSIS and DTS services cross different databases.
• Proficient in creating and deploying SSIS packages from heterogeneous sources like Excel, CSV, Oracle, flat file, text format data by using multiple transformations in SSIS such as data conversion, conditional split, bulk insert, merge, aggregate, derived column and union all.
• Experienced in designing jobs, alerts, SQL mail agent, and scheduling DTS and SSIS packages.
• Experience in designing, developing, deploying and processing cubes in SSAS.
• Proficient knowledge in designing partitions, aggregations for performance tuning in SSAS.
• Proficient in calculating measures and dimension members using multi-dimensional expression (MDX), and user defined functions.
• Strong experience in developing various types of complex reports like reports using cascade parameters, drill down and drill through reports, matrix reports, sub reports, parameterized reports, Ad-Hoc and charts using SQL Server Reporting Services (SSRS) based on client requirement.
• Hands of experience in implementing different types of replication models like snap shot, merge and transactional on basis of business requirement.
• Expertise in troubleshooting issues related to SQL by using SQL tools, execution plans, trace, statistics, and index tuning wizard.
• Excellent experience in monitoring SQL server performance tuning, installing, configuring, managing and troubleshooting in SQL server 2000/2005/2008/2012 using SQL profiler, query analyzer, enterprise manager, index tuning wizard and windows performance monitor.
• Good knowledge of implementing backup and disaster recovery procedures.
• Good experience in using performance monitor, SQL profiler and optimizing the queries to solve dead locks and long running queries.
• Thorough knowledge in all phases of software development life cycle (SDLC), quality procedures and standards while executing projects.
• Excellent leadership skills with an aptitude of analysis, troubleshooting, problem solving and adopt to work independently as well as in a team.

TECHNICAL SKILLS

Databases: SQL Enterprises Manager, SQL Profiler, Query AnalyzerSQL Server setup, Security Manager, Service Manager, SQL Server Analysis Services (SSAS)

Languages: T-SQL, MDX,HTML, XML, .NET

ETL Tools: Data Transformation Services (DTS), SQL Server Integration Services (SSIS)Import Export Data, Bulk Insert

Reporting Tools: SSRS, Crystal Reports

Data Migration: MSDTS, SSIS, BCP, Data Migration, SQL Loader, Import/Export Wizard

Operating Systems: Windows 98/NT/2000/XP,2003/2008 Server, Windows 7/8, UNIX

Packages: MS Office 2000/2003/2007/2010/2013

PROFESSIONAL EXPERIENCE

Confidential, Chicago

SQL Developer/SSIS

Responsibilities:

• Responsible for maintenance of SQL server 2005/2008 including installation, configuration, security and service pack upgrades.
• Migrated data from MS SQL server 2005 to MS SQL server 2008 R2 by using attach/detach, backup and restore procedures.
• Created databases by following normalization rules.
• Debugged and resolved deployment errors.
• Developed complex SQL queries, heavy stored procedures, batch scripts, triggers, functions using T-SQL.
• Created user defined functions for generic use.
• Developed and integrated user defined functions and stored procedures for reporting services.
• Enhanced the performance by using optimization techniques such as normalization, indexing, transaction isolation levels, monitoring logs to ensure the consistency of batch processes and scripts.
• Created triggers to alert specified users of certain transactions taking place within the database.
• Written scripts for data profiling, reported the risks, issues after running scripts of the running on the source system and used those results in designing the ETL.
• Extensively used different types of transformations such as lookup, slowly changing dimension (SCD), multi-cast, merge, OLE DB command, and derived column to migrate SSIS packages from one database to another database.
• Worked on End-to-End ETL processes.
• Developed SSIS packages to import data from OLTP database to OLAP database and scheduled jobs to call the packages and stored procedures.
• Used SSIS packages for extracting, cleaning, transforming and loading data into data warehouse.
• Performed data integrity checks by scheduling jobs.
• Created a tree view application to view the recently generated reports and scheduling reports to run on a particular date.
• Tuned the performance of stored procedures and functions to improve the report generation time by using SQL server profiler.
• Developed and deployed different reports such as parameterized, cascaded parameterized, matrix, tabular, drill down and drill through reports on reporting server.
• Worked on migrating ASP.NET application to ASP.NET MVC application.
• Configured and maintained reporting server and report manager for SSRS.
• Built in drill down, drill through, linked and sub-reports using SSRS.
• Maintaining and troubleshooting issues related with large (terabyte-sized) clustered databases.
• Developed Backup and Restore scripts for environmental preparation.
• Monitored and analyzed the performance of databases by using SQL query manager.

Environment: MS SQL Server 2005/2008 R2, T-SQL, Enterprise Manager, Query Analyzer, SSRS, SSIS, Visual Studio.Net, Windows 2008.

Confidential, San Diego

Database Developer, SSIS/SSRS

Responsibilities:

• Created new databases and objects such as tables, stored procedures, constraints, and indexes to maintain referential integrity of data.
• Optimized queries by deleting unnecessary columns, eliminated inconsistent data, normalization of tables, developed joins and created clustered/non-clustered indexes wherever necessary.
• Involved in writing various DB objects like user defined functions, triggers, indexes for accomplishing various tasks..
• Participated in all stages of software development life cycle (SDLC) while developing logical architecture for SSIS packages.
• Migrated data from heterogeneous data sources such as flat files, oracle, access, excel etc.., to SQL server 2008 using SSIS packages.
• Utilized various data flow transformations like lookup, derived column, row count, data conversion, conditional split, sort, aggregate, OLEDB command, union all etc.., to migrate data between different data sources according to business requirements.
• Tuning of complex packages to ensure faster data loads and accuracy.
• Performed debugging of SSIS packages using error handling methods like break points and check points.
• Used VB.Net, VB.net Scripts for loading data using SSIS packages.
• Responsible for validation and deployment of SSIS packages from development to QA and production environment.
• Performed daily and weekly data loads by scheduling corresponding ETL jobs in SQL server agent.
• Developed aggregations and partitions in cubes as per business requirement.
• Developed MDX queries and aggregate functions related to cubes, measures, hierarchies, processing cubes and deployment of cubes.
• Designed, deployed and maintained various SSRS reports like parameterized reports, sub-reports, cross-tab, drill-down, drill-through reports using RDL. Created Linked servers to retrieve date from different databases.
• Identified and provided necessary steps to enhance the user response time by checking fragmentation and re-indexing tables for efficient application access and methods.
• Performed security related issues by creating user logins, roles, permissions and granting access to database according to their role.
• Configured snapshot replication to improve the performance of SSRS.
• Documented all processes and tasks of all databases, stored procedures, functions, views for future references and maintenance.

Environment: MS SQL Server 2005/2008, T-SQL, DTS, BCP, Index Tuning wizard, Enterprise Manager, Query Analyzer, SSRS, SSIS,SSAS, VB.Net, Windows 2008.

Confidential, San Francisco

Sr.SQL Server Developer

Responsibilities:

• Extensively participated in all phases of projects life cycle.
• Helped front end developers in writing SQL queries, approving database changes and designing data models.
• Designed, developed and maintained security of relational databases.
• Involved in managing database integration issues such as migration of data from various databases, integration, database maintenance, disk space planning issues, and new applications.
• Created check constraints to maintain data integrity.
• Performed tracing applications using SQL profiler.
• Optimized SQL queries to develop database objects such as triggers, joins, constraints, cursors, indexes, views, and created stored procedures to automate sequential updates in fewer transactions.
• Performed tuning of SQL server locks, and indexes configurations, administrating SQL server security and maintenance of databases.
• Tuned complex SQL queries, stored procedures and functions to improve the report generation time.
• Designed and developed user defined functions and stored procedures for reporting purposes.
• Migrated data from flat files to SQL server databases by using BCP and SSIS packages.
• Involved in writing MDX queries for analytical and reporting services.
• Generated crystal reports as per client’s requirement.
• Created Ad-Hoc reports using SSRS.
• Monitoring and implementing disk space expansion to ensure that company’s databases are scalable.
• Created data related documentation for project as per business requirement.
• Troubleshooting and resolving access to databases and identifying performance issues.
• Performed testing and implementing of database backup procedures, restore procedures, disaster recovery procedures and contingency plans.

Environment: MS SQL Server 2005, Enterprise Manager, SQL profiler, Query Analyzer, Crystal Reports, Windows 2003/XP.

Confidential

SQL Server Developer

Responsibilities:

• Installation, configuration of MS SQL Server 2005 instances and databases for development and testing purposes using SQL Server setup program.
• Implemented and monitored database application and security.
• Created tables, indexes, views, constraints and stored procedures for modular integrity and application as per client’s requirement.
• Designed and implemented database triggers and stored procedures to check the referential integrity of database.
• Monitored performance tuning of databases and SQL queries using execution plan.
• Tuning and optimization of stored procedures.
• Used data transformation services (DTS) an ETL tool of SQL server to migrate data from various data sources.
• Designed complex SQL queries to fetch data from multiple tables in remote databases using joins and database links.
• Managed disk space, database files, transaction log, and data transfers between various servers using BCP.
• Designed and implemented various complex reports.
• Involved in troubleshooting and performance tuning of database.
• Performed Administrative tasks like managing roles, users, profiles and creating scheduling maintenances and backups to database.
• Troubleshooting problems related with databases, application tools, development tools and minimizing production down issues.
• Involved in development, execution and maintenance of disaster recovery plans using different types of database backups, restore and replication.
• Maintained consistency of database by using database consistency checks (DBCC) at regular intervals and fixed data corruption in application databases.

Environment: MS SQL Server 2005, Transact - SQL, Enterprise Manager, Query Analyzer, Windows 2003

Confidential 

SQL Developer

Responsibilities:

• Interacted with front end developers and managers to analyze the need of business requirement and developed technical specifications.
• Created log shipping on servers for disaster recovery.
• Designed and implemented schema on all databases for different kinds of storage as per the business requirement.
• Optimized databases by creating clustered indexes, non- clustered indexes and views.
• Utilized views such as partition views, parameterized views for complex join queries between multiple tables from different databases.
• Created incremental load packages to load the updated and new data into the enterprise data warehouse.
• Created variables to pass parameterized values into the package which makes the package dynamic.
• Developed triggers, indexes, stored procedures and enforced business rules through checks and constraints.
• Created complex SSAS OLAP cubes by using aggregations, partitions and calculations based on OLAP reporting needs.
• Scheduled full and transactional log backups for the user and system related databases by using database maintenance plan wizard.
• Worked on all kinds of reports, DTS, SSAS and SSIS packages.

Environment: MS SQL Server 2005, Transact - SQL, Enterprise Manager, Query Analyzer, SSIS, SSRS, Tuning Advisor, Windows 2003