SUMMARY

• Six years of development experience using SQL Server and OLTP/OLAP models.
• Proficient in Installation, Configuration and migrating and upgrading of data from MS SQL Server and and R2.
• 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.
• Expert knowledge and experience in authoring, managing and deploying reporting solutions using SQL Server Reporting Services (SSRS).
• Efficient in generating parameterized reports, drill down, cascading, sub - reports, and matrix reports using SSRS 2005.
• Astute knowledge in integrating, migrating, converting and cleansing data using SQL Server Integration Services (SSIS).
• Expertise in building Key Performance Indicators (KPIs) using different storage settings for cube designing, writing MDX queries.
• Experience in deploying and enhancing the SSIS Packages from development server to production server.
• Strong knowledge of Data warehousing concepts, including Star schemas, Snowflake schemas and Dimensional Modeling.
• Experience in Oracle 9i/10g, My SQL databases. Developed ASP.net application to communicate with SQL Server Database.
• Experienced in creating Databases based on Functional Requirements and System Design.
• Experienced in creating packages, Jobs, sending alert mails, scheduling and running packages, designing, compiling and testing.
• Involved in migrating DTS packages to SSIS and modified using DTS editor wizard.
• Experience in using tools like Index Tuning Wizard, SQL Profiler, and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance. Worked on Policy Management.
• Hands-on working experience using all types of SQL Server Constraints, T-SQL Queries, User defined Data Types, User Defined Functions and Views.
• Developed complex Stored Procedures, Triggers, Views and Cursors for implementing business logic and process in backend, for data extraction, reports and other client interfaces.
• Experience in Software Development Life Cycle (SDLC) processes including Analysis, Design, Development, Testing and Implementation.

TECHNICAL SKILLS

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

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

ETL Tools: DTS (Data transformation services), Integration Services (SSIS)

Database: SQL Server 2000/2005/2008 , MYSQL, Oracle 8i/9i/10gMS Access

Applications: Microsoft Office Suite, Adobe Photoshop, MS VisioBusiness Intelligence Studio

Reporting Tools: Visual Studio, Report Builder, SSRS

PROFESSIONAL EXPERIENCE

Confidential, Newark, NJ

SQL SSRS/SSIS Developer

Responsibilities:

• Scheduled JAD Sessions and involved in gathering the report specifications by interacting with the business users.
• Developed database objects such as Stored Procedures, Functions, Tables, Triggers and Indexes using T-SQL and SQL Analyzer.
• Migrated data from various sources into SQL Server 2008 using SQL Server Integration Services 2008.
• Developed packages in SSIS for aggregating data files and database sales information and consolidating for reporting & cubes.
• Used multiple transformations in SSIS such as Conditional Split, Bulk Insert, Merge and Data Conversion.
• Created reports using Reporting Services 2008 to retrieve data using database code objects such as stored procedures, views and multiple T-SQL queries.
• Developing Reporting in SSRS Report Viewer Control and integrating to Web application as client side reporting.
• Created complex reports which includes cascade parameters, multivalve parameters and conditional formatting to generate user friendly reports.
• Auto dispatching of simple and complex reports with parameters to different business users using Data driven subscriptions all across the organization based on defined schedules.
• 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.
• Improving query / stored procedure performance for fast generation of reports.
• Created Report Services 2005 Models for different business channels to implement Ad-hoc reporting.
• Interacting with business user groups in selling ideas for improving the user interface and business processes all through the system development.
• Documented all the reports such as technical specifications which include test cases, parameters involved and report running time and so on.

Environment: SQL Server 2005/2008, T-SQL, MS SQL Server Integration Services (SSIS) 2008, MS SQL Server Reporting Services (SSRS) 2008, Stored Procedures, Triggers, Functions, Views, and Microsoft Visual Studio.

Confidential, Warren, NJ

MS SQL Server Developer/SSIS/SSRS Developer

Responsibilities:

• Involved in the Requirement Analysis, Design phase and Development phase of Water Fall SDLC model system.
• Developed T-SQL Dynamic and Static Stored Procedures and Queries to develop Decision Engine.
• Developed User Defined Functions for giving Scores and views for the application.
• Created SSIS packages for Dynamic ETL flow to validate, extract, transform and load data into database.
• Developed, monitored and deployed SSIS packages.
• Performed Incremental load with several Dataflow tasks and Control Flow Tasks using SSIS.
• Maintained Batch logging, Error logging tables and handled errors using Event handlers.
• Created SSIS package to Export and Import data from SQL Server to Access, Text and EXCEL files and Configured SQL mail agent for sending automatic mails.
• Configured Connection Manager files for SSIS packages to dynamically execute on Quality Analysis server and Production server. Created Stored Procedures for that.
• Involved in performing migration of DTS packages to SSIS packages.
• Developed Cascading, Drill-down Reports to get monthly sales details and profits using SSRS.
• Involved in deploying, configuring and managing reports using Report Manager and Report Builder.
• Formatted the reports using the Global variables and expressions.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• Recognized the fact and dimension tables in the OLAP database and created cubes using MS SQL Server Analysis Services.
• Identified and modified the KPIs, measures in co ordinance with the requirement.
• Reviewed and fine-tuned stored procedures and triggers before production migration.
• Improved Performance by creating Clustered and Non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Executed manual test cases by using positive and negative data inputs and verified actual results with expected results. Report results and defects using Quality Center.

Environment: MSSQL Server 2005/2008, SSRS, SSIS, .NET Framework, C#, ASP.NET, Windows 2000/2003 Advance Server, HTML, XML, MS Excel, MS Access Reports

Confidential, New York, NY

SQL Server SSIS/SSRS Developer

Responsibilities:

• Planned, defined and designed data based on the business requirement.
• Worked closely with Business Analysts to produce all required documentation.
• Created various Database Objects - Tables, Indexes, Views, and Roles.
• Created and maintained databases for Dealers, Vehicle Driver, and Vehicle information.
• Developed complex stored procedures and triggers in T-SQL.
• Created SSIS process design architecting the flow of data from various sources to target.
• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Created OLAP models based on Dimension and Facts for efficient loads of data based on Star Schema structure.
• Created calculated fields with MDX code to meet additional measures needs that are calculated from existing measures.
• Constructed Cubes based on data volumes mostly adhering to Star Schema.
• Used SSRS to create various ad-hoc, parameterized, drill-down and drill-through reports weekly and monthly showing detailed information of the Vendors information, Titles Information.
• Installed and configured SQL Server 2005 successfully on Windows Server 2003.
• Reviewed and fine tuned stored procedures and triggers before production migration.
• Fine tuned database objects and server to ensure efficient data retrieval.
• Assisted the front end application developers with their queries.
• Involved in project status report updates/creation of issue items for reviews/updates of technical and transformation files on timely basis.

Environment: MS SQL Server 2005, MS Access 2000, Business Intelligence Development Studio 2005, SSIS, MS Excel, Windows Server 2003/2008.

Confidential, Princeton, NJ

SQL Developer

Responsibilities:

• Installed and configured SQL Server 2005.
• Designed dynamic DTS packages to transfer data between servers, load data into database and achieved data file from different DBMS.
• Created and developed stored procedure, Triggers, functions to handle complex business rules.
• Created users and logins and granted the permissions at server and DB level.
• Developed DTS packages to pull data from data sources.
• Developed packages to extract and cleanse the data.
• Involved in developing different reports in Pdf format.
• Involved in scheduling and monitoring all maintenance activities.
• Involved in database consistency checks and index fragmentation.
• Developed stored procedures, UDF and triggers.
• Involved in tuning system stored procedures for better performance.
• Involved in generating reports from scratch using SQL Server Reporting services.
• Involved in implementing high availability strategies.
• Worked with development teams in the design of physical database and in modification.
• Created clustered and non clustered indexes.
• Involved in tuning of stored procedures for better performance.
• Implemented disaster recovery plans (Log shipping).

Environment: Windows 2003 server, SQL Server 2005, T-SQL, Reporting services, DTS, MS Access, MS Excel.

Confidential 

SQL BI Developer (SSIS, SSRS)

Responsibilities:

• Data transfer between Development, Testing and Production databases.
• Provided support to development staff about database related issues.
• Creating of triggers, stored procedures and indexes.
• Created views and stored procedures to be used from front-end application.
• Alteration of tables and fields as per requirements and recreation of indexes.
• Created ETL processes using Microsoft DTS and SSIS.
• Used SSIS Packages for data import and export data from SQL Server to Access, text and EXCEL files.
• Created calculated measures that fit business logic, using MDX queries.
• Effectively Used SSRS for creating reports for the end users on their specific needs.
• Created custom and standard reports using Reports.
• Evaluate and monitor database performance and carry out maintenance duties such as performance tuning, backup, restoration and disaster recovery.

Environment: SQL Server 2005/2000, SSIS, SSRS, DTS, Access, Windows NT/2000 Server.