SUMMARY

• Over 8 years of IT experience with expertise in analyzing the requirements, application development, Testing, Production support and a major focus on Business Intelligence.
• Expertise in software analysis, design, and development of applications including providing Business Intelligence solutions using SQL Server Business Intelligence Development Studio with tools like SQL Server integration services SSIS, SQL Server Reporting services SSRS, SQL Server Analysis SSAS .
• Good knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP systems (SSIS, SSRS, SSAS) using SQL Server 2000/2005/2008 .
• Extensively worked on system analysis, design, development, testing and implementation of projects (SDLC) and capable of handling responsibilities as well as a proactive team member.
• Extensive ETL experience using DTS/SSIS for Data Extractions, Transformations and Loads.
• Programming skills in using .NET Technologies.
• Excellent Knowledge in RDBMS Concepts and Experience in Normalization of table’s 1NF, 2NF, 3NF.
• Excellent Transact - SQL programming skill in writing SQL Server Stored Procedures, Triggers, User-defined Functions & Views.
• Good working knowledge on performance tuning of Stored Procedures, T-SQL Queries & Implementing SQL Server Indexing.
• Expert in creating cubes and dimensions, handling multi dimensional reports.
• Deploying cubes and Partitioning Cubes, Aggregations, and KPI’s.
• Experience in using tools like Database Engine Tuning Advisor (DTA), SQL Profiler, Index Tuning Wizard and Windows Performance Monitor for Monitoring and Tuning MS SQL Server Performance.
• Expertise in managing Alerts, Operators and Jobs through SQL Server Agent.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services (SSIS).
• Worked with writing the ETL process to implement the hybrid data environment using SSIS and custom query.
• Strong experience in ETL cycle, which includes data analysis, database design, data mapping and conversion and data load.
• Expertise in ETL DTS Packages & SSIS Packages for integrating data from sources (Excel, CSV, Oracle, flat file) by using multiple transformations provided by SSIS such as Conditional Split, Data Conversion, Bulk Insert, merge and union all.
• Expertise in creating ETL packages using SQL Server 2008 Integration Services (SSIS).
• Experience in SQL Server DTS and SSIS (Integration Service) package design, Construction, and deployment.
• Experience in managing Control flow, Data flow in SSIS packages.
• Experience in Performance Tuning in SSIS packages by using Partial Transformations, Block and non-block Transformations.
• Expertise in Reporting Services for MS SQL Server and SQL Server Agent in Support Services.
• Knowledge on reports using SSRS 2008 and Crystal reports. Used table control, matrix control for cross tab reports.
• Experienceingenerating scheduledreportsfor business analysis or management decision using SQL Server Reporting Services.
• Developed reports on Drilldown, Drill Through, Parameterized, Cascaded Parameterized reports in SSRS 2008.
• Involved in design and implementation process for deploying, upgrading, managing data for reporting.
• Experience in using global variables & expressions for the reports.
• Strong capability in defining query for generating drill down reports, handling parameterized reports and creating stylish report layouts in SSRS 2008.
• Expertise in creating the Star Schema, MDX cubes and dimensions.
• Expert in creating cubes and dimensions using SSAS.
• Expertise in creating SQL server Analysis Projects using MS SQL Server 2008.
• Hands on experience in creating OLAP cubes using SQL Server 2008 analysis services (SSAS).
• Expertise in Configuring and managing data sources, data source views, cubes, dimensions with SSAS.
• Expertise in creating Aggregations, partitions in cubes using SSAS.
• Experience in Database Backup, Recovery and Disaster Recovery procedures for large, medium and small database instance.
• Programming skills in using .NET Technologies.
• Exceptionally well organized, strong work and a willingness to work hard to achieve confidence and objective.

TECHNICAL SKILLS

Programming Languages: T-SQL, SQL, VB 6, ASP.Net.

Database Application Software: MS SQL server 2008/2005/2000 , Oracle 8i, 9i/10g, MS Access 97/2000

ETL Tools: SQL Server Integration Services (SSIS)

GUI: DTS Import/Export, SQL Server Integration Services, SQL Server Reporting Services, SQL Server Analysis Services

Application Software: Microsoft Office, Visual Studio.

Modeling Tool: Database Designer, UML, Visio

Operating Systems: Windows Vista/XP/NT/2000.

PROFESSIONAL EXPERIENCE

Confidential, Lenexa, KS

SQL BI Developer / SSIS Developer

Responsibilities:

• Followed the Microsoft recommended best practices in designing, developing, and implementation and testing of the ETL using SQL Server Integration Services.
• Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Used DDL and DML for writing triggers, stored procedures, and data manipulation for automating tasks.
• Defined Check constraints, Business Rules, Indexes, and Views.
• 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.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler
• Import & Export of data from one server to other servers using tools like Data Transformation Services (DTS/ETL).
• Created DTS/ETL packages to schedule the jobs for batch processing.
• Used SQL Profiler and Query Analyzer to optimize DTS/ETL package queries and stored procedures.
• Configured Server for sending automatic mails to the respective people when a DTS/ETL process failure or success.
• Used profiler to monitor the performance, Debug Transact-SQL statements and stored procedures in existing application, to identify slow running query etc.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Implemented change data capture to log the inserts, updates and process the data to different servers.
• Implemented Change Tracking logic using SQL Server functions to work with constant data changes.
• Maintaining complex SSIS packages which play a major role in data transformation and data migration.
• Created SQL Jobs and automated schedules to run the jobs along with error handling and user notification capacity.
• Adjusting the SSIS packages and ETL processes to satisfy the constantly revolving changes.
• Daily meetings and interactions with team members to be updated about project and ready for shift in tasks.
• Working on Data warehouse reports.

Environment: MS SQL Server 2000/ 2005/2008/2008 R2/2012, SSRS, SSIS, SSAS, SharePoint Server 2007, DTS/ETL/SSIS, BIDS.

Confidential, Brecksville, OH

SQL BI Developer / SSRS Developer

Responsibilities:

• Involved in gathering requirements, business rules and deliver them in time
• Actively designed the database to fasten daily jobs and some stored procedure.
• Created complex Stored Procedures, triggers, tables, views and other SQL joins for applications.
• Created Complex Stored Procedures for implementing the business rules, also worked on SQL joins, CTEs (Common Table Expressions), Pivot and Unpivot tables, Materialized Views, Aggregate Conditions.
• Involved in complex Views and other T-SQL code and SQL joins for applications following SQL code standards.
• Used Joins, correlated and non correlated sub-queries for complex business queries involving multiple tables from different databases.
• Worked on Performance Tuning to reduce the runtime and increase performance & efficiency.
• Involved in SSIS packages to bring data from Oracle, Excel and Flat Files using MS Business Intelligence (BI) tool.
• Extensively used SSIS transformations such as Lookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Merge using SQL Server 2008 R2.
• Designed ETL package, with ETL Import/Export wizard for transferring data.
• Imported data from excel sheets and Excel using SQL Server Integration Services (SSIS) 2008.
• Created Drill-through, Drill-down, Cross Tab Reports and Sub-Report using Report Definition Language (RDL).
• Strong Experience in report design with SQL Server Reporting Service (SSRS).
• Designed and developed various Service Management Reports, utilizing Dynamic and Cascading Prompts, sub-reports, charts, parameterized reports, conditional and dynamic reports
• Designed the reports layout for creating tabular and matrix reports.
• Published generated reports.
• Created reports that included formatting options such as Grouping, Sorting, Drill-down, Parameter prompts.
• Developments and provide daily status of current work and take proposals to solve issues.

Environment: SQL Server 2008 R2, SSRS, T-SQL, MS-Excel, Windows NT/XP, MS SQL Reporting Services

Confidential, Jacksonville, FL

Senior SQL BI Developer

Responsibilities:

• Involved in gathering requirements, systems design for the new applications, coordinate the enhancements to the applications and deliver them in time
• Created tables, relationships, triggers and indexes for enforcing Business Rule
• Created Single Value Parameters, Multi-value Parameters to control data in the report.
• Extensively used Joins and Sub-Queries to simplify Complex Queries involving multiple tables.
• Writing Complex SQL queries and optimizing SQL Queries.
• Managed indexes and Optimizing Queries by using Execution Plan for performance tuning the database.
• Automating the database maintenance tasks by creating Jobs and Alerts.
• Bulk Insert was used in SSIS Packages to extract data and load the data to tables.
• Developed SSIS Packages to send mails and information to Finance and gatekeeper applications.
• Migrated DTS packages to SQL Server integration services (SSIS 2008).
• Involved in SSIS packages to bring data from Excel and Flat Files using MS Business Intelligence (BI) tool.
• Created Reports using SQL Server Reporting Services (SSRS) 2005/2008.
• Set up database backup and recovery strategies against data loss.
• Developed the end-user documentation and performed periodic updates of the design documents.
• Created OLAP cubes using SQL Server 2008 analysis services (SSAS).
• Created Aggregations in cubes using SSAS.
• Created data sources, data source views with SSAS.

Environment: SQL Server 2005/2008/2008 R2, SQL Server 2000, DTS, SSIS, SSRS, T-SQL, MS Excel, VB.Net, Windows NT/XP.

Confidential, Bloomfield, CT

MS SQL Server Developer

Responsibilities:

• Involved in Disaster recovery and database maintenance plan.
• Designed and implemented data access stored procedures and triggers for automating tasks.
• Responsible for planning, executing, and maintaining data integration projects and database upgrades.
• Involved in Performance tuning and Query Optimization.
• Written complex SQL statements using joins, sub queries and correlated sub queries.
• Worked on Stored Procedures and Database Triggers. Worked on large number of business analytical functions.
• Fine-tuned the logic in Procedures, Functions and Triggers for optimum performance.
• Used multitask data pump in SSIS/ETL 2008
• Developed SSIS packages to bring data from Oracle, Excel and Flat Files using MS Business Intelligence (BI) tool.
• Involved in Job scheduling and alerts.
• Created many complex stored procedures / functions and used them in Crystal Reports directly to generate reports on the fly.

Environment: Windows XP, SQL Server 2000 / 2005,/2008 T-SQL, MS-Excel, Windows 2000/NT/XP, MS Reporting Services, DTS, SSIS, Crystal Reports.

Confidential, O’Fallon Missouri

SQL Developer

Responsibilities:

• Understanding and articulating requirements from user interviews and then convert them into Business Process documents to develop and maintain applications.
• Worked on Database Connections, SQL joins, Materialized Views, Indexes, Aggregate Conditions and written Stored Procedures and Functions for processing business login in database.
• Implemented Constraints on Tables.
• Tuned SQL to reduce the runtime and increase performance & efficiency.
• Extensively used DTS Packages for bulk data upload.
• Importing and Exporting Excel records to SQL Server Database.
• Designing & Development of Standard Reports, Sub Reports, Cross Tab Reports and Charts using Crystal Reports.
• Used prompts to generate Parameterized and Cascading Parameterized Reports allowing the user to limit the reports to particular cases.

Environment: SQL Server 2000/2005/2008 , DTS, SQL Profiler, Index Tuning Wizard, MS Access, MS Excel, Crystal Reports 10.

Confidential, Addison, TX

SQL Server SSRS SSIS Developer

Responsibilities:

• Monitored performance and optimized SQL queries for maximum efficiency.
• Extensively used SSIS Import/Export Wizard, for performing the ETL operations
• Responsible for creating the reports based on the requirements using SSRS 2005.
• Created detailed reports for the customers to help them decide which property to purchase by showing demographic information based on various parameters.
• Identified and defined the Datasets for the report generation.
• Wrote the queries for the drill down reports.
• Identified and added the report parameters.
• Built effective queries for high-performance reporting.
• Deployed the generated reports on to the server.
• Planned the complete Back-up of various Databases for Disaster recovery scenarios.

Environment: MS SQL Server 2005 (Query Analyzer, SSIS, SQL Profiler), MS SQL Reporting Services 2005.

Confidential, NYC, NY

SQL Server Database/ Reports Developer

Responsibilities:

• Responsible for development of stored procedures, functions and database Triggers.
• Developed Dynamic search queries and results with manipulated data.
• Used Profiler trace for performance tuning
• Imported data from excel sheets and Excel using SQL Server Integration Services (SSIS).
• Involved in migrating DTS Packages to SSIS Packages
• Involved working with .net Technologies (C#).
• Designed DTS/SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2000/2005 environment
• Created indexes and analyzed its role for optimizations
• Created Constraints, Handled errors and used control-of-flow statements.
• Created complex report scripts using correlated sub queries.
• Involved in using the Table variables for performance improvement instead of temporary tables in the stored procedures.
• Responsible for security and roles.
• Created cubes in SSAS reports, which require complex calculations such as calculation of the premium for a particular policy.
• Created reports based on the format specified in the design document
• Involved in creating Dataset in the MS Reporting services (SSRS)
• Involved in creating Sub reports in MS Reporting services (SSRS)
• Passed parameters to the Reports using Report parameter menus
• Used Deployment wizard for deploying the Reports.

Environment: Microsoft SQL Server 2005, Microsoft reporting Services 2005(SSRS), SSIS, SSAS, DTS, C#, Visual Studio .NET 2003, .Net Framework, XML, JavaScript, Web Services.

Confidential, New York City, NY

MS SQL Server/SSRS/SSAS Developer

Responsibilities:

• Gathered Requirements from the end user and checking the structure of the schema.
• Designed and implemented stored procedures and triggers for automating tasks.
• Worked as a developer in creating complex Stored Procedures, SSIS packages, triggers, tables, and views and other SQL joins and statements for applications.
• Created SSIS packages and transferred them to the appropriate destinations.
• Involved in defining Referenced Relationships with the measure groups and fact tables.
• Generated reports using the SSRS 2005 and formatted reports.
• Reviewed cube, changed the cube and documentation according to the requirement based on product valuation and revenue opportunities.
• Created the data source views for security reasons.
• Created SQL server Analysis Projects using MS SQL Server 2005.

Environment: MS SQL Server 2005, MS Analysis Services 2005, MS Access, Import & export data, MS Windows XP.