SUMMARY

• 7+ Years of experience in design, development & analysis of SQL Server 2012/2008 and SQL Server Business Intelligence tools (BIDS) - SSIS, SSRS and SSAS.
• Good understanding on software development life cycle process methodologies and principles(SDLC).
• Proficient in MS SQL Server, Expert Knowledge of Reporting Services (SSRS), Integration Services (SSIS) and Analyst Services (SSAS).
• Expert in data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS) and creating Dynamic packages for Incremental Loads.
• Hands on experience in T-SQL, Designing and Normalization techniques of the database tables.
• Worked extensively on the Business Intelligence Development Studio (BIDS), that includes experience in design, development and implementation of complex data delivery systems using MS SQL Server and various data visualization tools.
• Experience in constructing different objects like Stored Procedures, Indices, Functions, Triggers, Cursors, Tables, Views, and Relational Database Models.
• Experience in Designing, developing and deploying SQL Server Integration Services (SSIS) packages.
• Proficient in creating SQL Server Reports, handling sub-reports and writing queries to perform roll-up and drill down operations using SSRS.
• Experience in creating scheduling Jobs, Alerts, SQL Server Agent mail, and scheduled DTS Packages.
• Transformed data from various data sources using OLE DB / MS AS connection by creating various DTS packages.
• Expertise in Maintaining Database with Backup, Restore Strategies and scheduling those backups using SSIS packages as a Developer.
• Expertise in creating Logins, Roles, Managed security and permissions on different databases.
• Expertise in creating packages using SSIS, Import, Export Data, Bulk Insert and BCP Utilities.
• Excellent work ethics, self- motivated, quick learner and team oriented. Continually provided value added services to the clients through thoughtful experience and excellent communication skills.
• Capable of forming and maintaining positive and productive working relationships in internal/external and team environments.

TECHNICAL SKILLS

Database: MS SQL SERVER /2008 R, MS Access 2013/2010

Operating Systems: Windows, Linux

Programming Languages: T-SQL, PL-SQL, Objective C#

DB Tools: SQL Server Management Studio, SQL BIDS, SSDT, SQL Profiler, SQL Enterprise Manager, Query Analyzer

ETL Tools: DTS, SSIS

Reporting Tools: MS SQL Reporting services (SSRS), MS Access, Microsoft Excel, Crystal Reports

Other Tools: MS Office Suite (Microsoft Word, Power Point, MS Visio, MS Project), ERWIN

PROFESSIONAL EXPERIENCE

Confidential, Allendale, NJ

MS SQL Server/BI Developer (SSIS, SSRS)

Responsibilities:

• Validating, testing and loading Client data according to the pre-defined standards.
• Creating and maintaining objects like Stored Procedures, Functions, etc. required for the automation of data load.
• Created SSIS packages for loading different varieties of files into tables provided by the client.
• Wrote T-SQL procedures to use them in SSIS packages for minimizing complexity of the package.
• Created and maintained automation jobs using SQL Agent Jobs and scheduled according to the files availability in FTP Folders.
• Monitoring existing jobs to make sure data in SQL Server are up to date.
• Involved in bug fixing and testing the existing SSIS Packages.
• Re wrote old DTS packages to new standards (SSIS 2008R2). Tested and validated to make sure everything is perfect.
• Converted SSIS 2005 packages to SSIS 2008 R2 and made required changes for the package to run perfectly.
• Designed and deployed different types of reports like drill-down, drill-through, and Matrix reports using SSRS.
• Contributed significant amount of time testing packages, database objects and applications during migration period ( R2).
• Creating custom views as per the request from applications team.
• Created Crystal Reports on daily, weekly and monthly basis for manger’s review.

Environment: SQL SERVER 2005/2008 R2, SSIS, MS OFFICE, CRYSTAL REPORTS, TEAM FOUNDATION SERVER

Confidential, Alpharetta, GA

MS SQL Server (SSIS/SSRS/SSAS) Developer

Responsibilities:

• Created various database tables and procedures to update and clean the old data.
• Developed Complex Stored Procedures, Views and Temporary Tables as per the requirement.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Developed SQL Queries to fetch complex data from different tables in remote databases using joins, database links and formatted the results into reports and kept logs.
• Designed SSIS Packages in SQL Server 2012 to handle data migration (ETL Processes) from transaction System to Dimensional Model.
• Designed and developed SSIS (ETL) packages for loading data from Oracle and Flat files to SQL Server Database.
• Developed reports and deployed them on server using SQL Server Reporting Services (SSRS).
• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Rendering the reports to PDF formats as per the requirement and printing all the reports in a batch process for Monthly Statements.
• Responsible for creating dashboard and tabular reports using SSRS.

Environment: MS SQL SERVER-2012/2008 R2/2005, SSIS, SSAS, SSRS, T-SQL, DTS, SQL PROFILER, ERWIN, OLAP, OLTP, ERWIN, PERFORMANCE POINT SEVER, MS OFFICE-2007, MS EXCEL

Confidential

SQL Server Developer

Responsibilities:

• Created Stored Procedures, Triggers, Functions, Indexes, Tables, Views, joins and other T-SQL code to implement business rules.
• Designed and implemented data access stored procedures and optimized Stored Procedures and Queries in T-SQL.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Created SSIS package configuration using environment variable to change the value of variables.
• Developed and deployed data transfers packages using SSIS, also maintained the jobs running on Servers.
• Scheduled jobs for executing the stored SSIS packages which were developed to update the database on Daily/Weekly/Monthly basis
• Administered interface to organize reports and data sources, schedule report execution and delivery, and track reporting history using SSRS 2008.
• Fine-tuned SQL queries for maximum efficiency and performance.
• Provided documentation for all kinds of reports and SSIS packages.
• Designed and implemented stored procedures and triggers for automating tasks.

Environment: SQL SERVER 2008, DS 2008, INTEGRATION SERVICES 2008, T-SQL AUTO SYS, WINDOWS XP/2003 SERVER

Confidential

SQL Server Developer

Responsibilities:

• Requirement gathering - Solution design
• Interacted with Team and Analysis, Design and Develop database using ER Diagram, Normalization and relational database concept.
• Involved in the migration from SQL server .
• Designed DDL and DML for MS SQL Server 2005
• Create rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports.
• Used SQL Profiler to trace the slow running queries and optimized query execution with the use of Index Tuning Wizard and Rebuild indexes if necessary.
• Perform daily database backup & restoration and monitor the performance of DB Server.
• Use DDL and DML for writing triggers, stored procedures, and data manipulation.
• Install and Configured SQL Server 2005 on development server for designing and testing.

Environment: MS SQL SERVER 2005, T-SQL, DTS, SQL SERVER ENTERPRISE MANAGER, SQL PROFILER