SUMMARY

• Over 8 years of excellent experience in the IT industry as a SQL Server/BI Developer.
• Proficient in MS SQL Server 2005/2008/2008 - R2/2012 suite of products.
• Expert in writing parameterized Queries for generating reports, formatting report layout, sub reports using global variables, expressions and functions in 2005/2008/2008- R2/2012.
• Expert knowledge and extensive experience using SQL Server Integration Services (SSIS) to perform ETL and data integration processes.
• Extensive experiencein managing and automating control flow, data flow, events and logging programmatically using Microsoft .NET framework for SSIS packages.
• Expert experience in developing SSIS package framework (storage, deployment and management) for solutions across theprojects using design best practices.
• Experience in developing Custom Reports and different types of Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Extensively used Report Wizard, Report Builder for developing and deploying reports in SSRS.
• Extensive SQL Server database experience and expert knowledge in scripting stored procedures, triggers and user-defined functions in T-SQL.
• Strong experience in writing complex Stored Procedures, Triggers, Cursor, Linked Server Query, UDF, and other SQL Server objects using T-SQL.
• Hands on experience in troubleshooting database issues.
• Expertise indeveloping reports usingSQL Server Service Broker.
• Expert in designing and scheduling complexSSIS Packagesfor transferring data manually from multiple data sources to SQL server.
• Experience in creatingJobs, Alerts, SQLMail Agentand schedulingDTS Packages
• Experienced using inFTP and SFTP serversto upload files.
• Performed data migration between different versions of SQL Servers 2005/2008/2012.
• Worked on administration tasks such as data loading, batch jobs, data unloading, back up &Recovery, user and application table management, upgrades, creating databases/file groups/files/transaction logs.
• Highly experienced on BCP, Jobs and linked servers for MS SQL Server/Oracle.
• Capable of forming and maintaining positive and productive working relationships in internal/external team environments by positive attitude and strong communication skills.

TECHNICAL SKILLS

Operating Systems: Windows Server 2000/2003/2008 Windows XP/Vista

Languages: T-SQL, PL/SQL, C#.Net, VB.Net, ASP.Net, XML, HTML, Java Script

Tools: /Utilities: Enterprise Manager,SQL Server Management Studio(SSMS), Query Analyzer, Business Intelligence Development studio, DTS, Analysis Manager, SQL Profiler,SSIS, SSRS, Visual Studio 2005/2008, SQL * Plus, Toad, Erwin

Databases: MS SQL Server 7.0/2000/2005/2008, Oracle10g/9i, MS Access

Data Modeling Tools: Microsoft Visio, UML, Erwin

Software: MS Office, Adobe Dreamweaver, Adobe Photoshop, Ms Excel, MS-Project 2000

Reporting Services: Excel, SQL Server Reporting Services, Crystal Reports, Business Objects, OBIEE

PROFESSIONAL EXPERIENCE

Confidential, Buffalo, NY

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Create and maintain various databases for Development and Testing Environment using SQL Server 2012/2008R 2/2008/2005/2000 and involve in actual Relational Database Design for high OLTP environment.
• Worked with Client/Server tools like SQL ServerEnterprise ManagerandQuery analyzertoadminister SQL Server.
• Created a database model by using Erwin 4.0 and also designed automated scripts in T-SQL, DTS, and BCP to import data from various ODBC sources into SQL Server databases to maintain the consistency and data integrity.
• Created scripts for tables,stored procedures, andDTSandSSIS, (SQL 2K5) tasks.
• Physical Implementation and application of Schema changes to SQL Server database using Power Designer View.
• Actively monitored performances of querieson SQL server usingSQL Profilerand optimized it by creating appropriate indexes using Index Tuning Wizard by using SQL Data manipulation language.
• Good experience on working with Extract, Transform and Load (ETL) tool.
• Develop/customize UNIX shell scripts to automate routine DBA tasks of exports, space usage monitoring and others
• Exposed to data conversion from different data sources to SQL server 2008 usingSSIS.
• Using Import/Export wizard to move data from flat files and Excel sheets to SQL Server usingSSIS.
• Developed a Database Maintenance Planner for the Performance of SQL Server, which includesRe-indexing,Database Integrity Checksand Update Database Statistics.
• Created Jobs, Alerts and scheduled DTS Packages and SSRS to generate reports.
• Created stored procedures to create dynamic SQL Queries to adopt dynamic environment.
• Administrative task including full and differential backups, database security by creating users and roles for login authentication and validating permissions
• Executed UNIX shellscripts to test the nightly batch jobs.
• Successfully migrated data to new location usingSnapshotReplication, and implementedMerge Replication.
• Experience with third party tools like Embarcadero, AR Remedy system to access the SQL Server.

Environment: SQL Server 2012/2008R 2/2008/2005/2000, SSIS, SSRS, Windows Server 2003, Visual Source Safe 6.0,ASP.Net 3.0, C#, Vb.Net, Visual Studio 2008,Visual Basic, UNIX.

Confidential, Irvine, CA

MS SQL Developer/BI Developer

Responsibilities:

• Actively involved ingathering and analyzingtheuser requirementsincoordination with Business.
• Performed thescope analysisof the user requirements.
• Identified various data sources, formulated data dictionaries, design and develop data models(physical/logical data models)based on the given specs and requirements.
• Worked as a developer in creating complexStored Procedures, Triggers, Functions, Indexes, Tables, Viewsand otherT-SQL codeandSQL joinsfor applications.
• Extensively usedT-SQLin constructing userfunctions, views, indexes,user profiles, relational database models, data dictionaries, and data integrity.
• Performancetuning, and optimization of procedures and queries.
• Transferred data from various data sources/business systems includingMS Excel, MS Access, Flat Filesetc to SQL Server using SSIS/DTS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.
• Created ComplexETL Packagesusing SSIS to extract data from staging tables to partitioned tables with incremental load.
• Created logging for ETL load at package level and task level to log number of records processed by each package and each task in a package using SSIS.
• Developed, monitored and deployed SSIS packages.
• Responsible forScheduling Jobs, Alerting and Maintaining SSIS packages.
• Generatedmultiple Enterprise reports (SSRS/Crystal/Impromptu)from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such asgroups,sub-groups, adjacent-groups, group by total, group by sub-totals, grand-totals,drilldowns, drill through, sub-reports, navigation reports (Hyperlink)etc.
• Created differentParameterized Reports(SSRS 2005/2008)likestandard parameterreports, cascading parameter reportswhich consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Report parameters includedsingle valued parameters, multi-value parameterswhich also consist of different parameter types likehidden, internal, default(queried and non queried parameters).
• Worked on all types of report types liketables, matrix, charts, sub reportsetc.
• CreatedLinked reports,Ad-hoc reportsand etc based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
• DevelopedChart Reports, Drill Through Reports, Master Detail Reports and Multiple Reports.

Environment: SQL Server 2000/2005, SQL Server 2008 R2, experience in SQL Server Replication, Windows 2003/2000, MS Access, VBScript, VB.Net, ASP.Net, HTML, SSIS, SSRS, XML, Oracle 11g, Erwin.

Confidential, Iselin, NJ

Sr. SQL Server Developer

Responsibilities:

• Developed database objects such as Stored Procedures, Functions, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager.
• Involved in designing ETL solutions to migrate data from flat files, Excel spreadsheets and heterogeneous data to and from SQL Server using DTS and also used BCP and Bulk Insert.
• Created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Developed reports using SSRS and published as PDF, Excel, and CSV formats.
• Increased query performance, necessary for statistical reporting by more than 25% after performance monitoring, tuning, and optimizing indexes using Performance Monitor, Profiler, and Index Tuning Wizard.
• Scheduling Jobs and Alerting using SQL Server Agent.
• Proactive and Reactive tuning of databases in every stage of the project.
• Evaluated database performance and performed maintenance duties such as tuning, backup, restoration and disaster recovery.
• Involved in trouble shooting and fine-tuning of databases for its performance and concurrency.
• Used Performance Monitor and SQL Profiler to optimize queries and enhance the performance of database servers.

Environment: SQL Server 2005, T-SQL, .Net, ADO.Net, ASP.NET, MS SQL Server 2005/2000, MS SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), HTML, CSS Windows XP Pro, Windows Performance monitor.

Confidential, Dallas TX

SQL Developer SSRS/SSIS

Responsibilities:

• Installing and configuring SQL Server 2000 and 2005.
• Designing Cubes and Data models for Data Warehousing Applications.
• Created and scheduled jobs to setup log shipping between production servers.
• Created databases and logins with permissions in SQL Server 2005 as per the developer's request.
• Created Linked Servers between SQL server 2000 and 2005 servers.
• Extracted logs from the UNIX for the defects by retrieving the log files from the server and reported to the developers for better tracking the defect
• Place the hugetable/non-clustered indexon the separate file group toimprove the performance.
• Createdcluster/non-cluster indexeson the tables, create views,stored procedures and triggers. Trace out for any table required anyindexes and determine the type of index on it.
• Involved indatabase designingusingNormalization.
• Monitoring systemperformanceand suggest forsystem upgrade like disk, processor, and memory.
• Schema Changesto the database as perapplication team requirement.
• Database Maintenance byscript/wizard for SQL 2005 and 2000.
• UsedDTS/BCP, BULK INSERTfor data transfer.
• Query Optimization for SQL queries.

Environment: MS SQL Server 2005/2000/7.0, Windows 2000/2003 Server Operating systems, SSIS, SSRS, Clustering, Performance Tuning, UNIX, MS SQL Reporting Services, Change Management System, Remote Desktop, MS Access.

Confidential, Newark CA

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Developed complexT-SQLcode for the application.
• Worked as a developer in creating complex Stored Procedures, DTS packages, triggers, cursors, tables,and viewsand other SQL joins and statements for applications.
• Designed and implemented the stored procedures and triggers for automating tasks.
• Developed SQL Server Stored procedures and DTS packages to extract data from database.
• Implemented constraints on tables.
• CreatedSSISPackages to migrate slowly changing dimensions
• Worked onSSISfor transferring data from Heterogeneous Database (Access databaseand xml format data) to SQL Server
• Created stored procedure for generating reports usingSQL Server Reporting Services (SSRS).
• Experience in creating complexSSIS packagesusing propercontrolanddata flowelements.
• Implementedreplication(transactionalandsnapshot) between Main production server and offsite (disaster recovery) server.
• Testing of applications forperformance,data Integrity
• Database andLog Backupsandrestoration,backup strategies,scheduling backups.
• Generated reports using MS Reporting services.
• Worked oncomplex data loading(implemented the batch data cleansing and data loading).
• Developed stored procedures to transform the data from enterprise datawarehouse to APT data mart to build dimensions and load data to fact tables.
• Created DTS package to schedule the jobs for batch processing.
• Created indexes, constraints and rules on database objects.

Environment: SQL Server 2005, MS Access, DTS, Query Analyzer, SSIS, MS reporting Services, BCP, Erwin, Import & Export Data, Windows 2003 Server.

Confidential, Chicago IL

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Interfaced with Business users for betterunderstanding the reporting requirements.
• Interfaced with the client as part of theRequirements engineering teamto finalize the project scope.
• Involved inDatabase designincluding optimizing the database schema, creating database indexes and coding database procedures/queries.
• Migrated SQL Server 2000 DTS packages to SQL Server 2005SSIS Packages
• ImplementedSSISfor data transformation logic process.
• Designing and building data load procedures, usingMS SQL Server SSIS
• Extracted datafrom various sources likeDB2,Oracle,Flat files,andXML filesand Loaded in to Fact and Dimension tables of data warehouse
• Maintain Operators, Categories,Alerts, Notifications, Jobs,Job Steps and Schedules. Monitor connections, locks andperformance of SQL server.
• DevelopedStored Procedures, FunctionsandDatabase Triggers.
• Developed reports usingSQL Server Reporting Services(SSRS)
• Developed reports andLandscapereports.
• DevelopedComplexreports usingSSRSandcreated a tree view application to view the recentreportsgenerated and a scheduler toschedulea selected report to be run on a particular date.
• UsedReporting Services (SSRS)to schedule reports to be generated on predetermined time.
• Created datasets using stored procedures and reports using multi valueparameters.
• Created sub reports,bar chartsandmatrixreports.
• Developing a Report as per user requirement using MS Reporting Services
• Published reports asPDF formats.

Environment: MS SQL Server 2000/2005, Windows 2000/2003, Sybase, Excel, TSQL, Microsoft Visual Studio 2005,SQL Reporting Services, SQL integration services.