SUMMARY

• Over 8 years of IT experience in Database Design, Development, Implementation and Administration in SQL Server 2012/2008/2005 and providing ETL/Business Intelligence solutions using Microsoft components.
• Experience using highly complex TSQL queries and SQL Scripts to perform efficient data load based on complex business rules and produced results for users.
• Experience in Implementation of Microsoft Business Intelligence (BI) platforms including SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS)
• Strong technical knowledge in MS SQL Server development including DTS, Performance tuning, Reporting, Designing logical/physical databases and Troubleshooting.
• Expert level skills in Objects creation such as Tables and Views, Table Normalization, User created Data Types, user functions, views, user profiles, data dictionaries, data integrity, Performance tuning, Indexes and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Supported team in resolving SQL Reporting services and T - SQL related issues and Proficiency in creating different types of reports such as Cross-Tab, Conditional, Drill-down, Top N, Summary, Form, OLAP and Sub reports, and formatting them.
• Strong understanding of RDBMS concepts and Data Modeling Concepts.
• Experience with SQL Server and T-SQL in constructing triggers, tables, user functions, views, indexes, user profiles, relational database models, data management, data dictionaries, and data integrity.
• Experience with production, development, and test databases including access controlling, performance monitoring and tuning, capacity planning.
• Extensive experience in ETL design/development using MS DTS and SSIS including data extraction and transformation between multiple data sources (Oracle, MS Access, and MS Excel).
• Experience in Creating and Deployment and Administration of SSIS and SSRS packages.
• Experienced in report generation using SQL Server Reporting Services (SSRS) and Excel spreadsheet.
• Experience in generating drill down Reports, handling parameterized Reports in SSRS 2005.
• SQL Server 2005 OLAP Database Development including KPIs, Data mining, working with changing dimensions.
• Experience of Bulk Insert, BCP utilities and scripts for data transforming and loading.
• Experience in implementing different types of Replication models like Snapshot, Merge and Transactional.
• Experience with software development life cycle (SDLC) and project management methodologies.
• Excellent communication and interpersonal skills, self motivated, quick learner and determination to learn new technologies, strong troubleshooting skill and good Team player with excellent interpersonal and team work skills.

TECHNICAL SKILLS

Languages: SQL, T-SQL, PL/SQL,.Net(C#,VB)

SQL Server Tools: BCP, DTS, Import/Export Wizard, SQL Mail, SQL Server Management Studio, SSIS, SSRS, SSAS, Index Analyzer

Databases: SQL Server 2008R 2/2008/2005/2000 , MS Access

Operating Systems: Windows Server 2008/2003/2000

ETL Tools: DTS, SSIS, BCP, Import/Export Wizard, BI Studio

OLAP Tools: SSAS, MS Excel

Reporting Tools: SSRS, MS Excel

Business Tools: Word, Excel, PowerPoint, Access, Outlook.

PROFESSIONAL EXPERIENCE

Confidential, New York, NY

MS SQL Server/SSIS/SSRS Developer

Responsibilities:

• Planned, Defined and Designed data based on business requirement and provided documentation.
• Gathered data and documenting it for further reference and designed Database using Erwin data modeler.
• Created SSIS package to load data from Flat Files and SQL Server 2008/R2 to SQL Server 2012 a using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.
• Worked in setup logging environment to track the status of the events like error raise, task fail.
• Generated parameterized reports, sub reports, tabular reports using SSRS 2012.
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports using SSRS 2012.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Scheduled the monthly/weekly/daily reports to run automatically onto the Dashboard
• Responsible for Monitoring and Tuning Report performance.
• Created various database object like stored procedures, functions, tables, views
• Configured the report viewing security for various users at various levels using Report Manager
• Deployed the generated reports on to the server.
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Provided documentation for all kinds of reports and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.

Confidential, New York, NY

SQL Server/SSIS/SSRS Developer

Responsibilities:

• Created SSIS Packages for import and export of data between MS SQL Server database and others like MS Excel and Flat Files and Oracle databases.
• 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 2008
• 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 Triggers (Instead Of and After) for Auditing Purpose.
• Created Views and Indexed Views for the Performance Tuning.
• Created automated T-SQL scripts to process summary database transactions that run off-hours.
• Created Linked Servers to retrieve data from other databases.
• 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.

Confidential, Boston,MA

SQL Server SSRS/SSIS Developer

Responsibilities:

• Developed indexed views, complex stored procedures, CTE’s, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Monitoring execution plans to enhance the performance of the queries.
• Created complex SQL codes using Views, temporary tables, triggers and stored Procedures.
• Performed tuning of T-SQL procedures, triggers and other database objects.
• Involved in development and implementation of SSIS and SSRS application solutions for various business units across the organization.
• Formulated and documented ETL process design based on business requirements and system specifications including source to target mappings, data dictionaries and transformations.
• Directly responsible for the Extraction, Transformation and Loading of data from Multiple Sources to Data Warehouse.
• Created highly complex SSIS packages using various Data transformations like conditional splitting, Fuzzy Lookup, For Each Loop, Multi Cast, column conversion, Script Components, error handling.
• Generated Custom ETL scripts using SSIS 2005 and develops unit test SSIS load processes for performance check.
• Database migration is done from SQL Server 2005 to SQL Server 2008 to enable the applications to run better and reduce the amount of time you need to spend managing them.
• Created various complex reports and manage those using SQL Server Reporting Services (SSRS 2008/2005)
• Migrated Database from SQL Server R2 by using side by side migration.
• Involved in migration and Conversion of Reports from SSRS .
• Created Tabular reports, Matrix reports, List & Chart reports, Parameterized reports, Sub reports, Ad-hoc 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.
• Highly involved in creating, structuring, formatting using Report Designer and Report Builder.
• Wrote and integrated stored procedures to generate the special reports according to client’s need.
• Worked on various complex requirements of developing monitoring dashboards with multiple KPIs in Performance Point Monitoring Server 2007, Share point.

Confidential, Englewood Cliffs, NJ

SQL Server SSIS/SSRS Developer

Responsibilities:

• Used highly complex TSQL queries and SQL Scripts to perform efficient data load based on complex business rules and produced results for users.
• Used SQL profiler and Execution Plan to view index performance and thereby eliminate table scan.
• Created stored procedures, views, triggers, user defined functions to in corporate the flow of business.
• Assisted project manager in project planning schedule for database module.
• Involved in upgrading the instance of development environment of SQL Server 2000 service to SQL Server 2005 with latest service pack.
• Extracted data fromOLTPtoOLAPusingSSISusing complex data transformations.
• Developed packages for getting data from SQL Server, Flat files and MS Access data of Sales, Returns and Employee.
• Developed the SQL Server Integration Services (SSIS) packages to transform data fromSQL 2000toMS SQL Server 2005as well as created interface stored procedures used inSSISto load/transform data to the database.
• Successfully created Snapshots Report, Report Subscription, Data Driven Subscription and Report caching using Report Manager
• DTS used to load data from extracts coming from Mainframe systems
• Worked with Dynamic SQL, and developed procedures utilizing the functionality.

Confidential, NYC,NY

SQL Server Developer/SSIS/SSRS

Responsibilities:

• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into data warehouse
• Involved in the Migration of Databases from SQL Server 2005 to SQL Server 2008
• Migrated Database from SQL Server R2 by using side by side migration.
• Involved in Performance tuning of ETL transformations, data validations and stored procedures
• Developed SSIS Packages to perform Data loads from various types of sources files (EXCEL, Access, Flat files)
• Database migration is done from SQL Server 2005 to SQL Server 2008 to enable the applications to run better and reduce the amount of time you need to spend managing them.
• Created SSIS Packages using Fuzzy Lookup, Derived Columns, Pivot Transformation, 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 SSIS package to transfer data between OLTP and OLAP databases using Incremental Load.
• Involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008 in Business Intelligence Development Studio (BIDS)
• Scheduled tasks to run every day to update changes in the base tables
• Designed and developed various types of reports using SSRS
• Worked on formatting SSRS reports using the Global variables and expressions
• Created parameterized reports, Drill down and Drill through reports using SSRS
• Deployedanduploaded the SSRS reportstoSharePoint Serverfor the end users and involved in enhancements and modifications
• Published reports on to Share-Pointandcreated Web Parts in Share-Pointto show various reports generated fromExcel andSSRSin one Page.

Confidential, Round Rock, TX

Database Developer

Responsibilities:

• Transformed data from various data sources using OLE DB connection by creating various DTS packages.
• Database migration is done from SQL Server 2005 to SQL Server 2008 to enable the Applications to run better and reduce the amount of time you need to spend managing them.
• Migration of databases from MS SQL Server 7.0 to MS SQL Server 2000.
• Involved in Data modeling to develop the database design using Erwin 4.0
• Installation and configuration of MS SQL Server on Windows 2000/2003 Server.
• Involved in designing of Conceptual Logical Model and Physical Model.
• Created new database objects like Sequences, Procedures, Functions, Packages, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2000.
• Developed Database Triggers to enforce Data integrity and additional Referential Integrity.
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks.
• Used SQL Profiler and Query Analyzer to optimize DTS package queries and stored procedures.
• Scripting the Database Consistency Checks (DBCC), scheduling the scripts to run daily and weekly basis.
• Scheduling transfer of backups and log files to different servers.
• Creation of schema objects, rules and granting of roles to the users.
• Testing and implementing Database Backup Procedures, Restoration Procedures, Disaster Recovery procedures and Contingency plans.