PROFESSIONAL SUMMARY:

• Over 8+ years of IT experience as a MS SQL Server Developer 2014/2012/2008 R2/2008/2005 in various Industry verticals like Health Care,Telecommunications, Pharmaceuticals.
• Experience in Installation and Configuration of SQL Server 2014/2012/2008 /2005/2000.
• Good knowledge in Normalizing and De - normalizing the tables and maintaining Referential Integrity by using Triggers and Primary and Foreign Keys.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in using profilers, Index Tuning Wizard and performance monitor to monitor SQL Server.
• Highly experienced in complete cycle of SQL Server Integration Services (2005/2008), Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing data transfers and ETL purposes across different servers.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS) (2005/2008).
• Extensively used Control Flow and Data Flow transformations like Execute SQL Task, FTP Task, Send Mail Task, Conditional Split and Fuzzy Lookup.
• Extensively used ETL methodology for performing Data Migration, Extraction, Transformation and Loading using SSIS and designed data conversions from wide variety of source system.
• Extensive experience with different phases of software development life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client-server based applications).
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• Experience in creating SSIS packages using Active X scripts and with Error Handling.
• Experience in providing Logging, Error Handling by using event handlers and custom logging for SSIS Packages.
• Experience in Scheduling and Monitoring ETL processes using DTS Exec utilities and batch files.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations.
• Highly Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform roll-up and drill down operations in SSRS 2005
• Good at collaboration and interpersonal skills.
• Hands on Experience in effectively using the BO universe for crystal reporting needs.
• Experience in creating complex drill down reports, parameterized reports, dropdowns and images, charts using SSRS 2005/2008, Crystal Reports and MS Excel for the analyzation of the data at an enterprise level.
• Knowledge in creating Ad-hoc reports and data driven subscription reports by using Report Builder (version).
• Expertise in creating Cubes with dimensions and Facts Tables in MOLAP Warehouse using SQL Server Analysis Services (SSAS).
• Involved in designing, deploying and processing OLAP Cubes using SSAS for the analysis of data with pre-calculated aggregations and also in summarized fashion which can be modeled into a report accordingly.
• Can work as individual as well as a team player

TECHNICAL SKILLS:

Languages: SQL, T-SQL, PL/SQL,C, C++,C#, VB 6.0,CSS, HTML, XML, MHTML

Databases: SQL Server 2014/2012/2008 R2/2008/7.0, Oracle 9i/8.x, Toad for Oracle 11g

Reporting Tools: SQL Server Reporting Service (SSRS), Crystal Reports XI/10/9,SAP BO

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

Other Software: MS Office- 2010/2007/2003/2000, Adobe Professional,SharePoint, Visual studio 2010/2008.

Operating Systems: Windows / 98/2000/2003/ XP/Vista/2008, Unix.

Database Tools: SQL Query Analyzer, SWIFT Tool,ERWIN,SQL Enterprise Manager, SQL Server Management Studio(SSMS), SQL Server 2005 Query Editor, Solution Explorer, Analysis Manager, Reporting Server, Business Intelligence Development Studio(BIDS), OWB

Methodologies: Logical and Physical Database Design, UML, Database Design and Normalization, Data Modeling

PROFESSIONAL EXPERIENCE:

Confidential, NY

SQL Server ETL Developer

Responsibilities:

• Created database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Designed and created SQL Databases, tables, indexes, and views based on user requirements.
• Create joins and sub-queries for complex queries involving multiple tables
• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Created User Defined Functions, Stored Procedures, and Triggers.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, XML files etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS/DTS packages
• Created data loads and Upgrade scripts for data migrations and validations
• Worked with different methods of logging in SSIS.
• Building out Crystal Reports from BO Universe for finance team for claims reporting.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Created packages in SSIS with error handling.
• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Used Active-X scripting in SSIS for transformation of data into staging tables and also to extract data from database tables and write the data to text files.
• Experience in Error Handling using TRY and CATCH blocks and performance tuning using counters in SSIS
• Have deployed packages on different servers by configuring it.
• Worked on SSRS to generate more than 60+ reports for various user groups and developer groups.
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Cascaded parameterized reports, Drill down reports as well as interactive reports according to business requirements.

Environment:: SQL Server 2014/2012/2008 R2, Query Analyzer, TFS, C#, Enterprise Manager, DTS, SSIS, SSRS,SAP BO,SSAS,T-SQL, Windows 2008/2000/XP, Toad for Oracle 11g,SharePoint server 2010.

SQL Server BI Developer

Responsibilities:

• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects.
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Fine-tuning Stored Procedures to improve performance that was achieved by removing unnecessary cursors and used SQL Profiler to improve performance.
• Designed Star schema (identification of facts, measures and dimensions) and Snowflake schema.
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Generated periodic reports based on the statistical analysis of the data from various time frame and division using SQL Server Reporting Services (SSRS).
• Developed various operational, drill-through and drill-down reports using SSRS.
• Migrated data from Heterogeneous Data Sources and legacy system to SQL Server databases using SQL Server Integration Services (SSIS) to overcome transformation constraints.
• Well experienced in defining, designing, integrating and re-engineering the Enterprise Data warehouse and Data Marts in different environments like Oracle with multiple Terabytes of size and various levels of complexity.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases and data mart databases.
• Involved in the Data modeling, Physical Design of Database using tools like Erwin.
• Used DBCC Statements to perform maintenance tasks on the database. Executed DBCC commands like CHECKDB before backing up the databases.
• Experience in Designing, Building the Dimensions, cubes with star schema using SQL Server Analysis Services
• Troubleshoot system issues, monitored scheduled jobs and set up maintenance plans for proactively monitoring the performance of SQL Server databases.
• Configured replication servers and transactional replication between production & standby server for disaster recovery.
• Creating and Maintaining Users roles groups and granting the privileges to users and Groups and maintaining Security up to date.
• Develop the Perl and Shell scripts to automate the finance billing file.

Environment:: SQL Server 2008R2 /2012, Query Analyzer, C#, Enterprise Manager, DTS, TFS, SSIS, SSRS,Crystal Reports,SSAS, T-SQL, Windows 2000/XP/2008,SharePoint server 2010.

SQL Server BI Developer

Responsibilities:

• Involved in Installation and Configuration of MS SQL Server 2008R2.
• Created Database Objects like Stored Procedures, Triggers and User Defined Functions (UDF) for this project.
• Created Views to maintain security of customer data.
• Created Indexes to get the high level performance.
• Performed ETL operations to support incremental, historical data loads and transformations using SSIS.
• Created SSIS packages to extract data from OLTP to OLAP systems and scheduled jobs to call the packages.
• Created ETL packages with different data sources and loaded the data into destination tables by performing complex transformations using SSIS packages.
• Designed SSIS packages for synchronizing the data between two different servers.
• Created Ad-hoc reports and cascading reports for historical data using SSRS.
• Created and Scheduled jobs for various tasks and also was responsible for maintaining jobs.
• Used various advanced SSIS functionalities like complex joins, conditional splitting, column conversions for better performance during package execution.
• Created SSIS Packages to migrate slowly changing dimensions.
• Designed numerous ad-hoc and custom reports using SQL Reporting Services.
• Developed and Scheduled SSIS Packages for loading Facts and Dimensions.
• Created Partition table for very large database for good performance.
• Configured mail profile for sending automatic mails to respective people when job is failed or succeed.
• Created partition function, schema and file groups for fact tables.
• Involved in the post deployment maintenance of canned reports and cubes.
• Involved in the design, development and maintenance of different cubes using SSAS

Environment: MS SQL Server 2008R2/2005, TFS, Query Analyzer, Windows 2008, SSIS,SSRS, Excel, Oracle10g

SQL Developer

Responsibilities:

• Designed DDL and DML for MS SQL Server 2000
• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Query Optimization by creating indexes.
• Involved in writing SQL batch scripts.
• Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.
• Involved in merging existing databases and designed new data models to meet the requirements and perform daily database backup & restoration and monitor the performance of Database Server.
• Created joins and sub-queries for complex queries involving multiple tables.
• Created Ad-hoc reports and cascading reports for historical data using SSRS.
• Install and Configured SQL Server 2000 on development server for designing and testing.

Environment: SQL Server 2008, T-SQL, T-SQL, SQL Server Enterprise Manager, SQL Profiler.