SUMMARY:

• Over 9+ Years of experience as SQL Developer in MS SQL Server 2000/2005/2008 Development and QA environments.
• Experience in Installing and Configuring SQL Server 2000/2005/2008 /2008 R2/2012.
• Experience in Up gradation of SQL Server 2000/2005 databases to SQL Server 2005/2008.
• Good hands - on working experience with using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Checks, and Unique), Writing Transact SQL (T-SQL) Queries & Dynamic-queries.
• Excellent experience in design and development of Business Intelligence tools like SQL Server 2005 Integration Services (SSIS), Reporting Services (SSRS) and Analysis Services (SSAS).
• Expertise in creating SSIS packages for Extraction, Transformation and Loading (ETL) operations.
• Experience in Import & Export of various data formats using DTS (Data Transformation Services), BCP, Bulk Insert and SQL 2005 Integration Services.
• Experience in migration from DTS Packages to SSIS Packages.
• Created stored procedures to build the Fact tables in the data mart for Multi-Dimensional analysis.
• Expert in performance tuning, query optimization and running database.
• Experience in administrating the reports to assign permission to the valid users for executing the reports.
• Experience in Deploying reports in various sources like Web browser in XML and PDF formats.
• Experience in Analysis Services (SSAS) for designing OLAP Cubes.
• Experience in Designing and Building the Dimensions, Fact Tables with star schema using SQL Server Analysis Services (SSAS).
• Experience in Normalization, De-normalization.
• Extensive experience in using T-SQL (DML, DDL) in SQL Server 2000/20005/2008 platforms.
• Created Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions.
• Experience in taking Backups, managing Alerts, Operators and Jobs through SQL Server Agent.
• Extensively worked in all phases of Software Development Life Cycle (SDLC).
• Worked very closely with Customers, End users and powered users collect requirements and training or resolve any business process related issues. Intensive experience in monitoring.
• Good experience in Implementation of windows & web applications using VB 6.0, ASP, ASP.NET, VB.NET, C#, XML, Crystal Reports, JavaScript.
• Worked synergistically with team members in meeting challenging project goals and deadline.
• Good team player and self-starter with excellent communication skills to work independently or as a part of team in Financial, Insurance & Healthcare industries.

TECHNICAL SKILLS:

Databases: SQL Server 2000/2005/2008 /2012, MS Access 2000, Oracle 9i/10g/11i

Database: Utilities Enterprise Manager, Query Analyzer, SQL Server Configuration Manager, TOAD, Business Intelligence Development Studio (BIDS), SQL Server Surface Area Configuration, Database Engine Tuning Advisor, SQL Profiler

ETL Tools: Export & Import (DTS), SSIS (Integration Services)

BI Tools: SQL Server Analysis Services 2005, SQL Server Reporting Services 2005

Data Modeling: Erwin, Microsoft Visio

Languages: C/C++, JAVA, J2EE, C#, T-SQL, ASP.Net, Visual Basic, PL/SQLWeb Technologies: HTML, XML, XSL, CSS, JavaScript, AJAX

Web Servers: Microsoft IIS, Apache, Apache Tomcat

Operating System: Windows Server 2000/2003, Windows NT/98/XP/Vista, UNIX

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville, FL

SQL/SSIS/SSRS/SSAS Developer

Responsibilities:

• Involved in gathering requirements from the business users and created the Functional Specifications, Technical Specs, Design documents and Approach documents.
• Created Mapping documents for Payment Processing, Power to Sale and Tax Compliance and Operation module which involves discussion of the business logic from Internal Users and applying them on Legacy database to target system.
• Involved in Data conversion of DB2 database to SQL.
• Created SSIS packages to clean and load data to data warehouse using SQL 2012.
• Created packages to migrate data from different data sources to data warehouse.
• Created SSIS Packages using Pivot Transformation, Fuzzy Lookup, Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc. to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Created a program to apply Penalties for Secured and Unsecured Tax Bills.
• Worked on Source Data Analysis, Design and creation of Data Mappings for Extraction of bulk data from sources like Flat files, Excel files etc,
• Developed SSIS packages using various Control Flow and Data Flow items to Transform and Load the Data using SQL Server Integration services (SSIS).
• Extensively used Execute SQL Task, Data flow Task, Look up, Script logic component, Union All etc in SSIS packages.
• Created Stored Procedures, User Defined functions, Views and implemented the Error Handling in the Stored Procedures and SQL objects and also Modified already existing stored procedures, triggers, views, indexes depending on the requirement.
• Implemented Custom Error Handling (Record Level) by using the Script component to generate custom error messages and redirected the error rows to a staging error table.
• Executed the test cases in Quality Center to ensure the quality of the data migration.
• Designed and executed the test cases for Data Migration in Quality Center.
• Used the SSIS Configuration files to make the packages connections, variables etc configurable and maintained the same on Test and Production environments.
• Created interactive reports for sorting, different Parameterized Reports which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required for Tier -1 and Tier 1A Data warehouse.
• Built different types of chart reports using SSRS for the business requirement like Designed and deployed reports with Drill Down, Drill Through, Drop down menu options, Sub-reports in SSRS using BIDS.
• Report parameters included single valued parameters, multi-value parameters that also consisted of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Created complex stored procedures to use as the datasets for the Report Design, to generate Ad hoc reports using SSRS
• Developed Complex SSRS Reports involving Sub Reports (Matrix/Tabular Reports, Charts and Graphs, Bar charts, Column charts and Pie charts)
• Developed SSRS Report Models.

Environment: MS SQL Server 2008, SQL Server 2012, SSIS/SSRS 2008, Visual Studio 2008, Windows 2003 Server, BIDS, MS Office 2007, MS Access, MS Excel, Framework, VB, ASP.NET, DB2.

SQL Server Developer/DBA

Responsibilities:

• Maintained databases, performed software installations and upgrades, monitored database performance, performed capacity planning on SQL SERVER 2008 & 2008 R2 servers.
• Involved in all phases of SDLC, creating Data Collecting Databases with JSON and XML scripts, creating Staging Databases with desterilized and translated scripts, creating SSIS packages to transfer data from Staging to Data-marts and developed the functions and stored procedures to provide the data required for dashboards.
• Created Execution Logging tables to monitor the execution status and loads in the client side. Implemented Exception Handling methods to capture the irrelevant dataflow.
• Worked with different control flow elements like Data Flow Task, Bulk Insert Task, Active X scripts, Execute SQL Task, Script Task, Send Mail Task, and XML Task.
• Used ADO.Net to fetch the underlying Data from SQL Server 2008 database.
• Used different data flow elements like Flat File, OLEDB, Excel Sources and Destinations, Data Convert ion, Term Extraction, Conditional Split, Derived Column, Pivot etc.
• Created and scheduled SSIS Jobs using SQL Scheduler, SQL Server Agent for daily, weekly and monthly loads.
• Implementation of high availability solutions for mission critical SQL Server databases, including clustering and data replication.
• Worked in Implementation of cross domain transactional replication database.
• Created and developed the stored procedures, triggers to handle complex business rules, history data and audit analysis.
• Define storage, query, and index strategies that assure quick and reliable query results
• Created alerts, notifications, and emails for system errors, insufficient resources, fatal database errors, and security breach.
• Create and maintain automated processes for SQL queries connected to various available SQL databases to gather and manipulate the required data (SSIS).
• Troubleshoot and resolve database issues including performance issues, data integrity issues, logging and storage issues, and problems with executing processes. Supported and resolved various production/test related tickets.
• Error handling and monitoring SQL server for scheduled jobs
• Automated and enhanced daily administrative tasks, including space management and backup & recovery strategies.
• Implemented SQL server Security groups and stream line the privileges and data base roles.

Environment: MS SQL Server Management Studio 2008 R2,T-SQL, MS-Excel, MS-Access, XML, SSIS, SSRS, SSAS, MDX, OLAP, PPS, Windows SharePoint Services 3.0, Visio, Microsoft Visual Studio 2010, Windows 7.

Sr . SQL Server BI Developer

Responsibilities:

• Involved in all phases of SDLC, and gathered business requirements from business people.
• Design/develop database using SQL SERVER 2005/2008.
• Created SSIS Packages for migration of data between MS SQL Server database and other databases like MS Access, MS Excel and Flat Files and Oracle databases.
• Designed and Developed Complex SSIS packages for auditing Interfaces using SQL SERVER 2005 Integration Services.
• Developed SSIS Packages using xml, ADO.NET, OLEDB, file system, Active X script, Look up tasks.
• Designed high level ETL architecture for overall data transfer from the OLTP to OLAP with the help of SSIS.
• Developed custom Reports, Ad-hoc reports by using SQL Server Reporting Services (SSRS).
• Developed Tabular, Drill Down, Parameterized, Cascaded and sub-reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions based on the requirements using SSRS 2005.
• Created Parameterized Reports and Linked reports and thorough knowledge of report serving architecture using SSRS.
• Deployed SSRS Reports in SharePoint Environment.
• Created OLAP Cubes and Dimensions using SSAS in data warehouse environment.
• Creating complex T-SQL Stored Procedures, Functions, Triggers, Cursors, Tables, and Views and other SQL joins and statements for applications.
• Scheduled Complex Stored Procedures using SQL Server Agent.
• Monitored and modified Performance using execution plans and Index tuning.
• Optimized Database Performance and Performed Maintenance duties such as tuning, backup and restoration.

Environment: MS SQL Server Management Studio 2008, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS),MS SQL Server Reporting Services (SSRS),SQL Server Analysis Services (SSAS), SharePoint Moss 2007, Windows XP

SQL Server (SSIS/SSRS) Developer

Responsibilities:

• Involved in requirement gathering and database design using Erwin.
• Created SSIS Packages for import and export of data between MS SQL Server database and others like MS Access, MS Excel and Flat Files and Oracle databases.
• Designed and developed Complex SSIS packages for auditing using SQL SERVER 2005 Integration Services (SSIS).
• Validated and modified the data using different Data Flow Transformations like Send Mail, Web Services, File System Task, Conditional Split, Lookup, Term Extraction, Pivot, Multi-Cast, Derived Column, Audit, and Data Conversion etc.
• Worked with different Control Flow elements like For Loop Container, for each Loop Container etc.
• Scheduled the SSIS packages to run at different intervals to load the data into SQL Server.
• Involved in Maintenance and Deployment of SSIS Packages.
• Developed Custom Reports, Ad-hoc Reports by using SQL Server Reporting Services (SSRS).
• Developed Tabular, drill down, parameterized, cascaded and sub-reports using SSRS.
• Generated Reports using Global Variables, Expressions and Functions based on the requirements in SSRS 2005.
• Created Parameterized Reports and Linked Reports and thorough knowledge of report server architecture using SSRS.
• Used Query Analyzer, Index Wizard, DB Engine Tuning and SQL Profiler for performance tuning.
• Created Complex SQL Queries using Views, Indexes, Triggers, Roles, Stored procedures and User Defined Functions.
• Created Complex Stored Procedures and automated them using SQL Server Agent.
• Created Views and Indexed Views for the Performance Tuning.
• Created automated T-SQL scripts to process summary database transactions that run off-hours.
• Monitored and modified Performance using execution plans and Index Tuning.
• Involved in preparing detailed technical documents.
• Involved in code review and preparing unit test cases.

Environment: MS SQL Server Management Studio 2005/2008, Query Analyzer, SQL Profiler, Index Tuning Wizard, MS SQL Server Integration Services (SSIS),MS SQL Server Reporting Services (SSRS), Microsoft Visual source Safe, SharePoint MOSS, Oracle9i, XML, ASP.Net, Windows 2003/2000

SQL Server BI Developer

Responsibilities:

• Actively involved as a part of a team for gathering and analyzing the User Requirement.
• Modified existing database to fit new business requirement by adding tables and relationships
• Upgraded SQL Server 2000 databases to SQL Server 2005.
• Extensively used SQL Reporting Services and Report Builder Model to generate custom reports.
• Created Custom Reports and Ad-hoc Reports using SQL Server Reporting Services.
• Created jobs using SQL Server Agent and generated SSRS (SQL Server Reporting Services) reports as a part of each job.
• Upgraded DTS Packages to SSIS Packages.
• Involved in Import and Export of data between various sources and destinations using SSIS, BCP and Bulk Insert.
• Created OLAP Cubes and Dimensions and tables using SSAS.
• Managed the legacy data in the data warehouse from various data sources.
• Created Indexed View to optimize query performance by facilitating easy user interface implementation.
• Created Linked Server to retrieve data from other databases.
• Worked on SQL Server 2005 Enterprise Manager and Query Analyzer to administer SQL Server.
• Documented different Stages of Data Transformation, procedures and scripts.
• Created Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults.
• Worked on XML parameters for inserting data into tables using FOR XML, OPEN XML.
• Performed Backups and Restore of the databases.

Environment: Windows 2000 Advance Server, SQL Server 2000/2005, T-SQL, DTS, BIDS, SSIS, SSRS, SSAS