SUMMARY

• Over 7+ years of IT experience as a MS SQL Server Developer 2014/2 /2000 in various Industry verticals like Finance and Insurance.
• Extensive experience with different phases of software development life cycle (Analysis, Design, Implementation, Testing, and debugging new and existing client - server based applications).
• Experience in Installation and Configuration of SQL Server 2008/2005/2000.
• Excellent knowledge in creating Databases, Tables, Stored Procedure, DDL/DML Triggers, Views, User defined data types, Cursors and Indexes using T-SQL.
• 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.
• 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
• 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.
• Involved to develop the VB Script, C# in SSIS.
• Good at collaboration and interpersonal skills
• Can work as individual as well as a team player

TECHNICAL SKILLS

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

Databases: SQL Server 2012/2008/2005/2000/7.0 , Oracle 9i/8.x, DB2 MS Access,SQL Azure.

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

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

Other Software: MS Office- 2007/2003/2000 , Adobe Professional, SharePoint

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)

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

PROFESSIONAL EXPERIENCE

Confidential, VA Beach, VA

SQL Server/BI Developer

Responsibilities:

• Working with the Business Analysts and Business Users to identify information needs as per our project requirements.
• Analyze the business requirements and develop the process to ensure all components of the application work correctly.
• Involved in complete SSIS life cycle in creating SSIS packages, building, deploying and executing the packages all environments. (QA, Development and Production)
• Created database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008/2012/2014 .
• Involved in the complete development process of both Inbound and outbound file processing and scheduling the jobs using Cisco’s Tidal Enterprise Scheduler.
• Created various Jobs, scheduled & ran jobs and troubleshooted the failed jobs
• Prepared various types of documentation including Backout implementation plans for the code developed used in the deployment process.
• Worked extensively on JIRA and JIRA SDLC for QA and PROD Deployments.
• Developed SQL data migration scripts for application conversion or integration.
• Design ETL Packages with Microsoft SSIS to pull data from various sources like Oracle,SQL Server, Flat Files and other systems into various destinations.
• Loaded/Synced projects with SVN Repository.
• Cleanse Data while loading and write logic to perform different kinds of transformations like Derived Column, Conditional Split, Lookup, Data Conversion etc.
• Migrated DTS Packages from SQL Server /2012/2014 SSIS Packages. Implemented event handlers and error handling in SSIS packages and notified process results to various user communities.
• Initially loaded data into staging tables from Facets using different transformations, control flow tasks, loop containers and data flow tasks, then moved the data into different Schema’s.
• Defined parameters, variables and run time parameters within the SSIS package Execute SQL task and executed stored procedures within the packages by passing parameters and loaded the data into the tables.
• Involved in Unit testing, User Acceptance Testing to check whether the data is loading into target, which was extracted from different source systems according to the user requirements
• Created Oracle packages and called them in SSIS packages to load data from Oracle to 2208 SQL Server.
• Used Oracle SQL Developer and SQL Plus tool to work with the data from Facets - Oracle.
• Experience in writing T-SQL scripts, dynamic SQL, complex stored procedures, functions, triggers.
• Excellent report creation skills using Microsoft Reporting Services (SSRS).
• Experience in creating Tabular reports, Matrix reports, List reports, Parameterized reports, Sub reports, Ad hoc reports (SSRS 2008/2012).
• Configured, built, deployed different reports in PDF, Excel formats according to the business requirement using SQL Server Reporting Services.

Environment: MS SQL Server 2014/2012/2008 , Sql Server Data tools(SSDT), SSIS 2008/2012/2014 , SSRS 2008/2012, MS Visual Studio 2008/2010/2012 , SQL Server Profiler, Windows Sever 2008, SQL Server Management Studio, SQL Server Business Intelligence Development Studio(BIDS),SQL Azure, Oracle SQL Developer, Oracle SQL Plus, Tortoise SVN, JIRA, JIRA SDLC.

Confidential, Corning, NY

SQL Server/Business Intelligence Developer

Responsibilities:

• Analyzed business requirements and involve in design and implementation of Design Documents and Approach Documents.
• Created database objects like Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2005/2008.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Wrote T-SQL statements for retrieval of data and involved in performance tuning of TSQL queries and Stored Procedures.
• Worked extensively with Team Foundation Server, Source Control.
• Created reports using Microsoft SQL Server 2008/2005 Reporting Services (SSRS) with proficiency in using Report Designer as well as Report Builder.
• Created Ad-hoc Reports, Drill-Down Reports, Pivot, Power pivot and Tabular Reports.
• Created complex Stored Procedures for better performance to generate reports.
• Managing the Report Server contents with Admin privileges and Report Manager for Subscriptions, Snapshots and Security Content on the reports
• Helped Quality Assurance Team to generate Test Plans and Test Executions.
• Used SSIS to create ETL packages to validate, extract, transform and load data into data warehouse and data marts.
• Worked Extensively with SSIS to import, export and transform the data between the linked servers.
• Scheduled the packages and jobs to keep extracting the data from OLTP at specific time intervals.
• Handled Performance Tuning and Optimization, with strong analytical and troubleshooting skills for quick issue resolution in large-scale production environments located globally.
• Experience in developing the end to end solution using SQL Server Business Intelligence.
• Used SQL Server Agent for scheduling jobs and alerts.
• Created packages in SSIS with custom error handling as well as complex SSIS packages using various Data transformations like Lookup, Script Task, and Conditional Split, Derived Column, Fuzzy Lookup, and Partition task, For-Each loop container in SSIS; scheduled the same SSIS packages by creating the job tasks.
• Worked with SQL Server Analysis Services (SSAS) that delivers Online Analytical Processing (OLAP) and data mining functionality for business intelligence applications
• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding the Aggregations to the Cube.
• Defined and processed the Facts, Dimensions & cubes using MS OLAP
• Involved in generating Multi-Dimensional Cubes and reports using OLAP Services

Environment: MS SQL Server 2008/2005, SSIS 2008, SSRS 2008, SSAS 2008, MS Visual Studio 2008/2010, Visual Studio Team Foundation Server, SQL Server Profiler, Windows Sever 2008, SQL Server Management Studio, SQL Server Business Intelligence Development Studio(BIDS), Oracle SQL Developer, Oracle SQL Plus.

Confidential, Agoura Hills, CA

SQL Server BI Developer

Responsibilities:

• Involved in complete Software Development Life Cycle.
• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Designed and created SQL Databases, tables, indexes, and views based on user requirements.
• Create joins and sub-queries for complex queries involving multiple tables
• Created User Defined Functions, Stored Procedures, and Triggers.
• Created database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Experience in creating complex SSIS packages using proper control and data flow elements.
• Created ETL packages with different data sources (SQL Server, Flat Files, Excel source files, Oracle,DB2etc) and then loaded the data into destination tables by performing different kinds of transformations using SSIS packages
• Created data loads and Performed Data validations
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• 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.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• Monitoring the jobs in case of heavy data loads and high memory usage. .
• Worked on SSRS to generate reports for various user groups and developer groups.
• Created Tabular reports, Matrix reports, Parameterized reports, Sub reports, Cascaded parameterized reports, Drill down reports as well as interactive reports according to business requirements in time restricted environment.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Generate various ad hoc reports using MS Reporting services.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Used MS Team Foundation server for Code Check -in and check out.
• Prepared documentation related to database design, Low-Level-Design Documents, Service Level Agreement and Unit testing plan and scripts.

Environment: SQL Server 2012/2008R2/2005, Query Analyzer, Enterprise Manager, TFS, SSIS, SSRS, T-SQL, Windows 2000/XP, SharePoint server 2007.

Confidential

SQL Server BI Developer

Responsibilities:

• Worked with the application developers and provide necessary SQL Scripts using T-SQL.
• Created database maintenance plans for the performance of SQL Server including database integrity checks, update database statistics, re-indexing and data backups.
• Created User Defined Functions, Stored Procedures, and Triggers.
• 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 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
• Created packages in SSIS with error handling.
• Worked with different methods of logging in SSIS.
• 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.
• Created the automated processes for the activities such as database backup processes and SSIS Packages run sequentially using SQL Server Agent job.
• 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.
• 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 in time restricted environment.
• Created SSRS Report Model Projects in BI studio and created, modified and managed various report models with multiple model objects, source fields and expressions.
• Generate various ad hoc reports using MS Reporting services.
• Created various Weekly and Monthly reports showing detailed information.
• Deployed and generated reports on to the server using the Reporting Services Report Manager.
• Worked with various Delivery mechanisms of Reports including Email /PDF/Schedules etc
• Deployed and uploaded the SSRS reports to SharePoint Server for the end users and involved in enhancements and modifications.
• Implemented Unit Tests and Integration Tests.
• Prepared documentation related to database design, objects security and rules.

Environment: SQL Server 2008R2/2005, Query Analyzer, Enterprise Manager, DTS, SSIS, SSRS, T-SQL, Windows 2000/XP, SharePoint server 2007.

MS SQL Server Developer

Responsibilities:

• Involved in different stages of Project Life Cycle.
• Actively participated in gathering Business Requirements and System Specifications.
• Created new Databases, tables, established relationship among tables in a database.
• Created stored procedures and functions to support efficient data storage and manipulation.
• Created views to display required information on user interface, and triggers to validate consistent data entry into the database.
• Defined Constraints, Indexes.
• Used SQL Server System Catalog to find Stored Proc, UDF, Triggers, indexes and constraints on existing databases.
• Implemented batch processing using Jobs and DTS.
• Migrated data from Flat files to SQL server 2000 using DTS (Import and Export Wizard)
• Created and Scheduled DTS packages to pull data from SQL Server and exported to Excel Spreadsheets and vice versa.
• Scheduled Jobs using SQL Server Agent.
• Identified, tested, and resolved database performance issues (monitoring and tuning) to ensure database optimization.
• Maintaining jobs for data messaging from development server to test server for generating daily reports for financial and marketing team.
• Designed and implemented several complex reports.
• Developed Reports to generate daily, weekly, monthly, quarterly, yearly Reports using crystal Reports.
• Created different user level groups, and assigned appropriate permission level to the database.
• Preparation of project documentation.

Environment: SQL Server 2000/2005, DTS, MS Access, MS EXCEL, T-SQL, Windows 2000 server.