SUMMARY

• Microsoft Certified Professional with Six years of IT Experience in Database Design, Development and Implementation of Microsoft SQL Server 2005/2008/2008 R2 in Development, Test and Production Environments with various business domains such asFinancial, Retail and Healthcare.
• Experience in working on full Software Development Life Cycle (SDLC).
• Knowledge in the .Net Framework.
• Integrated SQL Server 2005 reporting services with Microsoft Share point Portal Server.
• Experienced in working in cross - functional teams and tight schedules.
• Experienced in working in Agile/Scrum setup.
• Worked in tandem with the end users for understanding the business requirements and recommending feasible solutions.
• Excellent communication skills and team player.
• Ability to grasp new technologies/concepts.
• Experience in developing optimized SQL using best practices.
• Expertise in writing dynamic-SQL, complex stored procedures, functions and views.
• Hands on Experience in performance tuning using execution plans, SQL Profilerand DMVs.
• Incorporated complex business logic into stored procedures and functions for reusability.
• Experience in creating packages, jobs, sending alerts using SQL Mail and extended stored procedures.
• Experience in Configuring and Managing Linked Servers, data transfer between SQL Server and other heterogeneous relational database such as Oracle and DB2.
• Strong debugging skills and the ability to solve complex problems.
• Experience in Creating and Updating Clustered and Non-Clustered Indexes to keep up the SQL Server Performance.
• Experience in Creating and Updating Statistics to improve the SQL Server Performance.
• Experience in Extracting, Transforming and Loading (ETL) data from Excel, Flat file, Oracle to MS SQL Server by using BCP utility, DTS and SSIS services.
• Experience in creating SSIS packages using with Error Handling.
• Experience in enhancing and deploying the SSIS Packages from development server to production server.
• Experience in working with row, partially blocking and fully blocking transformations and adept at performance tuning of SSIS Packages.
• Adept at capturing the execution errors in SSIS for analysis purposes.
• Experience in sync processes between two databases using SSIS.
• Experience in importing/exporting data between different sources like Oracle/XML/Excel etc. using SSIS/DTS utility.
• Experienced in working with C#.Net in SSIS.
• Experience in creating configuration files to deploy the SSIS packages across all environments.
• Strong experience in generating drill-down, drill-through and cascaded-parameterized reports on top of relational databases and cubes.
• Created stored procedure for generating reports using SQL Server Reporting Services (SSRS).
• Experienced in creating various SSRS Reports involving variety of features like Charts, Filters, Sub-Reports and Multi-valued parameters.
• Experience in administrating the created reports and assigning permission to the valid users for executing the reports.
• Experience in deploying created reports to report server.
• Good Understanding in development of cubes using SQL Server Analysis Services (SSAS).
• Experienced in designing and developing ETL logic for moving data into data warehouses
• Involved in collaborating with Database Architects for basicData Warehouse Design.
• Good understanding of star schema and snowflake schema.

TECHNICAL SKILLS

Languages: C, C++, T-SQL, C#.Net, VB.Net

RDBMS: MS SQL Server 2005, 2008, 2008 R2, MS-Access 2007, Oracle 10g, DB2.

Web Technologies: HTML, XML

Reporting Tools: SQL Server Reporting services (SSRS), Crystal Reports

ETL Tools: DTS, SQL Server Integration Services (SSIS)

Data Modeling Tool: ER Studio, Microsoft Visio

Operating System: Windows 2000 Advanced Server, NT, 2003, 2008

PROFESSIONAL EXPERIENCE

Confidential, Brecksville OH

SQL Developer

Responsibilities:

• Gathered business requirement from the end users.
• Involved in creating complex stored procedures according to business logic and also for the creation of RDL for reporting.
• Worked with nested Stored Procedures and Functions.
• Involved in the performance tuning of the existing SQL code.
• Coded with complex customer data related to events such as Delinquency, Bankruptcy, and Collections etc.
• Created objects like tables and views and developed SSIS packages to load data.
• Created SSIS packages for moving data between databases.
• Implemented Package Level Error Logging for the SSIS Packages to move Data.
• Developed SSIS Packages with Error Logging and proper send Mail Task incorporated.
• Created mock-up data for testing the reports.
• Involved in the performance tuning of table valued functions.
• Responsible for creating reports using SSRS.
• Created Drill Down, Drill Through and Cascaded Parameterized reports according to the customer requirement.
• Dealt with several kinds of errors encountered in drill through reports.
• Incorporated complex expressions in the report for features such as colors, page breaks, pdf export etc.
• Worked with tabular and matrix reports.
• Developed complex stored procedure using T-SQL to generate ad hoc reports using SSRS.
• Created SSRS reports using Report Parameters, Drop-Down Parameters, Multi-Valued Parameters Debugging Parameter Issues, Matrix Reports and Charts.
• Created templates for the reports as per customer demand.
• User Acceptance Testing - Developed test cases and compared the Data against the Real data.
• Used Application Life Management Software (ALM Version 11.0) for raising any tickets and addressing them immediately.
• Coordination with other teams of IT department and TESTING Department.
• Served as a Production Support and addressed the Tickets depending on Level of Priority and Time.
• Immediately addressed any issues related to Data Returned to SSRS.
• Able to build SSRS Reports over aggregated Data and incorporating Dynamic SQL for bringing in the non-aggregated data to the report.
• Suggested way to improve the rendering time of the reports by aggregating the data before Drill through and returning Detail Data based on the Dynamic SQL Code. Thereby improving the performance of the Reports.
• Used different Data Sources in SSRS: SQL Server, SharePoint List.
• Based on the business requirement able to create new SSRS Reports that is a replica of the existing .net application.
• Able to deliver efficient work independently in the fast pace environment prior to the deadlines.
• Modified existing reports and improved their performance and rendering time by performance tuning the existing code and modifications in RDL to render efficiently.
• Created new functions (Table valued and Scalar) and also modified existing Views to improve performance.
• Better understanding of Data Marts (Star schema) and Working on report to build over data in data mart.
• Adept in Documentation of the process or objects used and with detail description of functioning of the report.

Environment: Microsoft SQL Server 2008, T-SQL, SQL Server Integration Services, SQL Server Reporting Services, Microsoft Team Foundation Server.

Confidential, Miami, FL

Programmer Analyst

Responsibilities:

• Actively involved in all the phases of Software Development Life Cycle (SDLC).
• Created detailed design and requirements documents with logic to help team members understand the requirements and design.
• Involved in the high level design of the ETL process.
• Reported progress to team and other higher ups in daily scrum.
• Created architectural data models of the destination warehouses/marts.
• Identified different kinds of relationships between the various entities in the data warehouse.
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data into enterprise data warehouse (EDW).
• Dealt with a variety of data sources including OLEDB Oracle Source, XML sources and Flat File Sources.
• Implemented incremental loading into the destination.
• Created alerts for both success and failure of jobs.
• Designed ETL for implementing Slowly Changing Dimensions in order to maintain historical data.
• Created configuration files to deploy SSIS packages across all environments.
• Used SSIS Script Task to write C# Code Snippets to generate error reports to be sent out.
• Coded in C#.Net for Assigning Values to objects dynamically and checking for conditions.
• Created the complex stored procedures, user defined functions to encapsulate the business logic.
• Createdviews, indexes, and user defined data types and implemented the cursors, triggers as needed.
• Followed best practices in writing T-SQL queries as a regular daily routine.
• Involved in the de-normalization of tables in order to make query retrieval faster.
• Involved in performance tuning of queries using query execution plans, SQL Profiler and also DMVs.
• Responsible for creating the reports using the SQL server reporting services.
• Created various types of reports including drill-down, drill-through, cascaded parameterized reports and sub-reports.
• Incorporated intuitive graphs/charts in the report as per customer need.
• Dealt with the enhancement of some existing reports.
• Incorporated global variables, expressions and functions for the reports.
• Deployed the reports to the report server.
• Designed and implemented the database replication for reporting database.
• Knowledge Transferred to co-workers &prepared Technical Documentation.
• Used Visual Source Safe for version control.
• Worked extensively on the data changes as per the user specified improvements on each release of the application build.
• Created numerous test cases for testing the application.
• IntegratedSQL Server 2005 reporting services with Microsoft Share point Portal Server to deliver automatically generated reports to the Share Point Site.

Environment: SQL Server 2008, SSIS, SSRS,T-SQL,Visual studio 2008, C#.NET, XML, VLDB, HTML,ER Studio, Visio, Microsoft Visual Source Safe, Microsoft Share point Portal Server.

Confidential, Oklahoma City,OK

SQL Server Developer

Responsibilities:

• Designed, Developed and Tested ETL logic for moving data from sources that were updated on daily basis.
• Worked with variety of file sources such as flat files, excel files and XML files.
• Incorporated incremental loading into destination database.
• Worked with different types of transformations such as row transformations, partially blocking transformations, fully blocking transformations and involved in performance tuning of SSIS packages.
• Established logging in packages and directed the log files to the concerned authority using Send Mail Task.
• Deployed SSIS packages to different environments such as production and testing in the SDLC.
• Performed VB and C# scripting in script Component.
• Used C# for Error Reporting.
• Involved in Performance tuning, and optimization of procedures and queries.
• Created complex storedprocedures, functions, triggers, and other database objectsfor applications using T-SQL.
• Created tabular and matrix reports based on custom requests from the end user.
• Created Bar graphs and pie charts.
• Created reports using SSRS from OLAP and OLTP data sources and deployed on report server.
• Generated ad-hoc reports using SSRS and Crystal reports.
• Created custom reports using Tableau and evaluated the tool as per client request.
• Constantly updated and maintained statistics for better performance.
• Incorporated complex business logic into functions and stored procedures.
• Created packages in SSIS with error handling.
• Created SQL Server Profiler tracesfor optimum performance of queries.
• Actively involved in Normalization (3NF) & De-normalization of database.
• Rebuilt indexes on various tables as per need.

Environment: Microsoft SQL Server 2000/2005 Enterprise Edition, MS SQL Server Management Studio, MS SQL Server Business Intelligence Development Server (BIDS), Tableau,Microsoft Visual Basic 6.0

Confidential, Chicago, IL

Programmer Analyst

Responsibilities:

• Involved in Installation and configuring of SQL Server 2005
• Created database objects such astables, indexes and designing constraints for data integrity.
• Experience in using T-SQL for creating stored procedures, indexes, cursors and function
• Performed data transfer using BCP.
• Added additional functionality to the specified business logic as per customer demand.
• Created linked servers to connect various OLEDB servers and providers.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Automated SSIS Packages by creating jobs and also created alerts.
• Identified and defined the report datasets.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Maintained referential integrity in the destination data warehouses.
• Modified existing data models as per design changes.
• Wrote stored procedures for report generation in SQL Server2005.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS

Environment: SQL Server 2000/2005, SSIS, SSRS, Crystal Reports,Microsoft Excel

Confidential

SQL Server Developer

Responsibilities:

• Responsible for the study and analysis of the systems design and implementation.
• Responsible for installation and configuration of MS SQL Server 2000 for development purposes.
• Created various database objects including tables, stored procedures and functions.
• Involved in tuning the existing T-SQL code for performance improvement.
• Followed the best practices in writing T-SQL for universal readability and reusability of code.
• Interacted with analysts and other developers in understanding and identifying the business requirements.
• Created stored procedures to hold the business logic.
• Created views as per client requests.

Environment: MS SQL Server 2000, DTS, T-SQL