SUMMARY

• Over 7 years of strong experience in the IT industry as a SQL Server Developer (SSIS, SSRS, SSAS) with sound business analysis skills.
• Experienced in all phases of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation.
• Extensive experience in MS SQL Server 2008/2005/2000 , Business Intelligence in MS SQL Server Integration Services (SSIS), MS SQL Server Reporting Services (SSRS), MS SQL Server Analysis Services (SSAS) .
• Performed Key Role in Logical and Physical Database design and development, Normalization and Data modeling using Erwin and SQL Server Enterprise manager.
• Highly proficient in the use of T - SQL for developing stored procedures, triggers, tables, user defined functions, relational database models and data integrity, SQL joins.
• Acquainted with Visual source safe 2005 as part of version control for Database Objects.
• Expertise in Extracting, Transformation and Loading (ETL) data using various tools including Bulk insert (BCP), Import/Export data and SQL server Integration Services.
• Expert in designing and scheduling complex SSIS Packages for transferring data manually from multiple data sources like SQL Server 2000, Excel, Flat file using SSIS and DTS utility to SQL server 2005/2008.
• Involved in designing and developing more than 100+ enterprise reports (SSRS/Business Objects).
• Experienced in writing Parameterized queries for generating Tabular reports, Formatting report layout, sub reports using Global Variables, Expressions, Functions, Sorting the data, defining data source and subtotals for the reports using SSRS 2005/2008.
• Experienced in creating different types of Tabular Reports, Matrix Reports, Drill-Down, Cross Tab Reports, Ad hoc reports, Summary Reports, List Reports and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business Intelligence Development Studio (BIDS).
• Involved in Maintenance and Deployment of SSIS Packages.
• Design, deployment and maintenance of various SSRS in SQL Server 2005/2008.
• Experience with ad-hoc reporting, regular reporting, parameterized, Custom Reporting and graphical reporting using SSRS for daily/weekly/bi-weekly/monthly reports.
• Experience in creating indexed views, complex stored procedures, effective triggers, and useful functions to facilitate efficient data manipulation and consistent data storage.
• Hands on experience working with Microsoft Dynamics ERP system. Acquainted with various functional areas like Sales, Purchasing, Finance, Manufacturing and Forecasting.
• Designed and created tables, views, triggers, indexes, stored procedures, functions and written queries in SQL.
• Excellent written and oral communication skills with a results-oriented attitude. Good in Collecting, Analyzing and Interpreting Data in an organized way. Versatile in working as an individual and also as part of a team. Proficient with various computer operating systems.
• Proactive team player with demonstrated problem solving and analytical reasoning abilities.
• Excellent analytical and problem solving skills, with strong communication skills and team player.

TECHNICAL SKILLS

Operating Systems: Windows Server 2000/2003, Windows XP/98/95, MS DOS

Languages: C, C++, T-SQL, SQL, PL/SQL, VB.NET, ASP.Net, HTML Script

RDBMS: MS SQL Server 2008, 2005, 2000, Microsoft Access

Front End: MS Visual Basic

SQL Server Tools: Enterprise Manager, Profiler, Query Analyzer, Export & Import (DTS), SSIS, SSRS, EDM, Replication.

PROFESSIONAL EXPERIENCE

Confidential, Boston, MA

SQL Server SSIS/SSRS Developer

Responsibilities:

• Involved in all phases of SDLC, and gathered business requirements from business people.
• Identified various data sources, formulated data dictionaries, design and develop data models (physical/logical data models) based on the given specs and requirements.
• Created Stored Procedures, Triggers, Indexes, User defined Functions, Constraints etc. on various database objects to obtain the required results.
• Created various kinds of reports like f004, f006, f003, Aging, Summary lane reports.
• Automation of creating Accounting code module for each bill.
• Creating dashboards for different departments.
• Bulk data migration using SSIS from flat files.
• Transferred data from various data sources/business systems including MS Excel, MS Access, Flat Files etc. to SQL Server using SSIS/DTS using various features like data conversion etc. Created derived columns from the present columns for the given requirements.
• Bulk data migration using SSIS from flat files.
• Created Complex ETL Packages using 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 for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports (Hyperlink) etc.
• Created different Parameterized Reports (SSRS 2005/2008) which consist of report Criteria in various reports to make minimize the report execution time and to limit the no of records required.
• Report parameters included single valued parameters, multi-value parameters which also consist of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Worked on all types of report types like tables, matrix, charts, sub reports etc.
• Created Linked reports, Ad-hoc reports and etc. based on the requirement. Linked reports are created in the Report Server to reduce the repetition the reports.
• Designed models using Framework Manager and deployed packages to the Report Net Servers.
• Created pages in the reports to display depend on Prompt values.
• Developed Chart Reports, Drill Through Reports, Master Detail Reports and Multiple Reports.
• Implemented security to restrict the access to users and to allow them to use only certain reports.

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

Confidential, Columbus, OH

SQL Server SSIS/SSRS/SSAS Developer

Responsibilities:

• Performance tuning, and optimization of procedures and queries.
• Experienced in participating meetings with business users to gather the requirements.
• Interacted with business users and collect the required information (BRD) for creating Data Model.
• Created complex Stored Procedures, triggers, cursors, tables, views and other SQL joins and statements for applications by using T-SQL.
• Extensively used T-SQL in constructing user functions, views, indexes, user profiles, relational database models, data dictionaries, and data integrity.
• Worked with development teams in the design of physical databases and in modification.
• Running DBCC consistency checks, and fixing data corruption in application databases.
• Configure and manage database maintenance plans for update statistics, database integrity check and backup operations.
• Created packages in SSIS with error handling.
• Developed DTSX packages to extract, transform and load into the Campaign database from OLTP Database using of SQL Server 2008 Integration Services (SSIS).
• Experience in creating complex SSIS packages using required Control and Data flow elements.
• Created Package Configurations to deploy packages from development to production server.
• Designed cubes with star schema using SQL Server Analysis Services (SSAS).
• Experience in creating reports with Report Builder and Report Server Project & Report Server Project Wizard using SSRS.
• Generated the complex reports, using Cube as a source.
• Experience with building cubes and dimensional modelling.
• Deployed Cubes and SSRS Reports in SharePoint Server.
• Responsible for document sharing in Microsoft Office Share point Server 2007 (MOSS 2007).
• Used System tables, System Stored Procedure, DBCC commands for Database maintenance.
• Implemented computational sensitive queries Stored Procedures.
• Involved in a team to extract the data from Oracle Enterprise Application.
• Developed database monitoring and tuning strategies.
• Developed and modified PL/SQL code to make enhancements or resolve problems.

Environment: MS SQL Server 2008, SQL Server Integration services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), OLAP, Oracle 10g and MOSS 2007.

Confidential, Portland, OR

Sr. SQL Server SSIS/SSRS Developer / DBA

Responsibilities:

• Design and normalize the databases and created different objects like tables, views, Stored Procedures, UDF’s, indexes rules and defaults on MS SQL server.
• Involved with Transact SQL (T-SQL) Coding, writing queries, cursors, functions, views, & triggers.
• Created Complex ETL Packages using 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 for Scheduling Jobs, Alerting and Maintaining SSIS packages.
• Generated multiple Enterprise reports (SSRS/Crystal/Impromptu) from SQL Server Database (OLTP) and SQL Server Analysis Services Database (OLAP) and included various reporting features such as group by, drilldowns, drill through, sub-reports, navigation reports etc.
• Responsible for fine tuning of the database, troubleshooting, memory management.
• Maintained databases with DBCC (Rebuilding Indexes, Integrity Checks)
• Created reports based on database usage and perform capacity planning.
• Responsible for creating user groups and assigning permissions.
• Optimized stored procedures and indexed query using Index Tuning Wizard.
• Performed DTS for data transfer from Oracle, Teradata, FTP, MS Excel and text file to SQL Server 2000.
• Created DTS packages to transfer objects from development server to production.
• Provided analysis and recommendations for setting up a comprehensive Backup and Recovery Strategy for SQL Servers.
• Setup and Maintained Snapshot Replication across multiple server environments.
• Experience in working with KPIs & calculations.
• Worked on large data warehouse Analysis services servers and developed the different reports for the analysis from that servers.

Environment: MS SQL Server 2008/2005, SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), Business Intelligence Development Studio (BIDS), MS Excel, Windows XP, Crystal Reports.

Confidential, NY

MS SQL Developer/ Reports Developer

Responsibilities:

• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.
• Used Logility demand planning software to forecast the demand.
• Generated database monitoring and data validation reports in SQL Server Reporting Service (SSRS).
• Created report models for Report Builder and managed reports using Report Manager.
• Responsible for creating complex reports like Drill down and Sub Reports.
• Created ad-hoc queries from SQL Server databases for custom reporting needs.
• Created Tabular, List, Matrix, Charts, Ad-hoc reports using SSRS.
• Created Data Warehouse Cubes using SQL Server Analysis Service (SSAS).
• Creating Static Reports using MDX queries and creating MDX Base Report Definition.
• Implemented Security by created roles by using the SSAS.
• Involved in Designing, Developing and Testingof the ETL(Extract, Transformation and Load) strategyto populate thedatafrom various source systems feeds usingSSIS.
• Deployed SSIS packages and Reports to Production Servers.
• Maintained system monitoring jobs and provide high availability support.
• Created partition tables for very large database for better performance.
• Participated Databases Architecture and Data Modeling design.
• Reported all events and requirements through established reporting mechanisms in SSRS.
• Fully supported change management procedures.
• Reviewed and modified, developed Data models and database designs with development teams.
• Wrote stored procedures for some job automations.
• Generated test data and tested database to meet the functionalities deliverables in the project documentation and specifications.
• Provide24 X 7 supportsto all production, development and staging.

Environment: MS SQL Server 2005, MS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS), MS SQL Server Analysis Services (SSAS), C#.Net, OLAP, UML, SSIS, BIDS.

Confidential, Iselin, NJ

SQL Server Developer SSIS/SSRS

Responsibilities:

• Developed database objects such as Stored Procedures, Functions, Tables, Triggers, and Indexes using T-SQL, SQL Analyzer and Enterprise Manager.
• Involved in migrating the database from SQL Server 2000 to SQL Server 2005.
• 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.
• Implementing various SSIS packages having different tasks and transformations and scheduled SSIS packages.
• Created user variables, property expressions, script task in SSIS.
• Managed test data and their updates between development and production databases and migrated stored procedures and database objects.
• Developed reports using SQL Server Reporting Services and utilizing complex SQL queries and stored procedures.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Configured and maintained Report Manager and Report Server for SSRS
• Used SSRS to create reports, customized Reports, on-demand reports, ad-hoc reports and involved in analyzing multi-dimensional reports in SSRS.
• 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.

Environment: SQL Server 2005, T-SQL, Active X Script, VB Script, .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 

SQL Server Developer

Responsibilities:

• Installed SQL Server Management tools using SQL Server Setup Program.
• Tested the Installation of SQL Server.
• Worked on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.
• Created Database Maintenance Planner for the Performance of SQL Server which covers Database Integrity Checks, Update Database Statistics and Re-indexing.
• Worked on Complete Backing up of Database and Restored the Database from Disaster Recovery.
• Upload data in database by using SSIS & DTS package (SAP, Flat Files, HTML files and SQL Server).
• Worked on DTS Package, DTS Import/Export for Transferring data from Heterogeneous Database.
• Data migration (import & export - BCP) from Text to SQL Server.
• Created Triggers to enforce data and referential integrity.
• Created and executed SSIS packages to populate data from the various data sources
• Created packages for different data loading operations for many applications
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
• Used DTS to migrate the tables to the Data Warehouse. Handled Different DSS (Decision Support System) for various applications.
• To setup, implement, and maintain industry standards in database management.
• Monitoring SQL server performance using profiler to find performance and dead locks.

Environment: SQL Server 2000 Enterprise Edition, T-SQL, Enterprise manager, Query Analyzer, SQL Profiler, BCP, OSQL, DTS, Oracle 8i, MS-ACCESS, VBS, MS Office & Windows 2K platform.