PROFESSIONAL SUMMARY:

• More than Seven Years of IT experience in MS SQL Server Development experience in Finance, Production & Marketing, Telecommunications and Health Insurance domains with expertise in MS SQL Server 2000 and MS SQL Server 2000/ 2005/2008/2008 R2 and Microsoft’s suite of products like SSIS, SSAS, and SSRS.
• Strong experience with SQL Server, T - SQL (DDL and DML) and excellent Developer Skills including writing Stored Procedures, User Defined Functions, Views, Triggers, Tables, indexes, user profiles, Relational Database models, query writing and SQL joins.
• Good knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP
• Reviewed Reporting Requirements and Created Aggregated Tables and Stored Procedures for the Dashboard for Health Management systems.
• Expertise in developing Parameterized, Chart, Graph, Linked, Dashboard, Scorecards, Report on SSAS Cube using MDX, Drill-down, Drill-through And Cascading reports using SSRS.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and dashboard reports.
• Used SSRS to Create Dashboard and Sub reports using charts including Parameterized and Cascading parameterized reports
• Involved in all phases of data warehouse project life cycle. Designed and developed ETL Architecture to load data from various sources like DB2 UDB, Oracle, Flat files, XML files and MS SQL Server into Oracle, XML, and SQL server targets
• Developed dashboard reports using SQL Server Reporting Services (SSRS), Report Model and ad-hoc reporting using Report Builder.
• Expertise in developing Parameterized, Chart, Graph, Scorecards, Report on SSAS Cube using MDX, Drill-down, Drill-through And Cascading reports using SSRS.
• Designed Scorecards and Dash board reports using Micro Strategy, Performance Point.
• Reviewed Reporting Requirements and Created Aggregated Tables and Stored Procedures for the Dashboard for Health Management systems.
• Generated Dashboards, Action Items and KPIs based on business requirement.
• Created various SSRS reports such as drill through, linked reports, drill down reports, dashboards and charts to meet the end user requirements.
• Designed developed and deployed reports and dashboard in Cognos portal and made available to render them in HTML and PDF formats.
• Created parameterized, drill down, drill through and aggregation type of reports, charts and dashboards in SSRS.

TECHNICAL SKILLS:

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

Tools: and Packages: SQL Server Management studio, SSIS, SSRS, SSAS, DTS, Microsoft Visual Source Safe,SQL Query Editor

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

Operating Systems: Windows vista/XP/2003/2000/NT 4.0/9x, MS-DOS

Web Technologies: HTML, XML, XSL, IIS(4.0/5.0/6/0)

Application Packages: MS Office, MS Outlook (Microsoft Office Suite)

BI Tools: SQL Server Reporting Tools (SSRS), SQL Server Integration Services (SSIS), SQL Server Analytical Services (SSAS), Performance Point Server 2007

PROFESSIONAL EXPERIENCE:

Confidential, Jacksonville. FL

Sr SQL Server/ SSIS/SSRS Developer

Responsibilities:

• Working with various business groups while developing their applications, assisting in Database design, creating E-R diagrams.
• Designing Logical and Physical Data Model with Erwin tools.
• Worked with installing, designing and managing MS SQL Server 2008.
• Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Created SSIS packages to populate data from various data sources.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, OLEDB to SQL Server.
• Developed a Tabular Reports, ad-hoc reports using SSRS Report Designer.
• Running DBCC consistency checks and fixing data corruption in application databases.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Worked with Meta-Data Driven SSIS Packages to pull the data from different Sources and load to Data mart.
• Migrated SSIS Packages from SQL Server 2005 to SQL Server 2008.
• Developed complex SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
• Built ad-hoc reports using SQL Server Reporting Services (SSRS).
• Designed and developed OLAP Cubes and Dimensions using SQL Server Analysis Services (SSAS).
• Work with project teams for upgrading SQL Server 2005 to SQL Server 2008.
• Involved in fine Tuning and Performance and Query optimization of the Database as required by the application.
• Conducted data import and export operations using the DTS wizard.

Environment: MS SQL Server 2008/2005, SQL Server Reporting Services (SSRS 2008/2005), SQL Server Analysis Services (SSAS), SQL Server Integration Services (SSIS), Business Intelligence Development Studio (BIDS), OLAP, XSLT, XML, C#, ASP.Net, MDX, DTS, MS Visio, Erwin.

Confidential, Irving, TX

SQL Developer

Responsibilities:

• Provided estimated time frame for the project by interacting with the other team developers.
• Interacted with the users to get the new requirements as per the treasury rules.
• Analyzed the scripts to make sure the mapping was done as per the data dictionary.
• Created technical specifications for the scripts.
• Wrote SQL*Loader scripts to load data into the Oracle database from excel spreadsheets.
• Altered the existing scripts to pass the loans which were previously failing edit checks when submitted to treasury on a daily basis.
• Redesigned the existing scripts to pick data either from Agent Desktop or MSP (Service Provider) whichever had appropriate data.
• Part of the new architecture code where dispute status is determined based on the count of days when a loan was denied to a borrower and many other factors were designed.
• Used views, procedures and functions to pull data.
• Wrote complex sql queries by using joins.
• Improved the performance of the application by rewriting the SQL queries.
• Wrote many Adhoc queries for testing the old verses new architecture data to determine if the new system could meet the requirement of minimal loan failure.
• Helped in the enhancements to increase the ease of use and efficiency for the end user depending on the client’s functionality.
• Used advanced SQL like analytical functions, aggregate functions for mathematical and statistical calculations.
• Created a new edit rules table set by treasury to check the validity of the borrower to be elected for the HAMP program by validating the data points like borrower FICO, Interest payment, Gross income which is used in calculating the NPV (Net Present Value) by AD team
• These edited rules help in either rejecting or accepting a loan in HAMP program.
• Copied the data from oracle database to an external directory in an XML format.
• Used SVN to version control all the database scripts.

Environment: Oracle 10g, TOAD 10.1, Erwin 4.1, Microsoft Excel 2007, SVN, UNIX, windows 2000, Microsoft project Management, Microsoft Visio

Confidential, NY

BI/SQL Server Developer (SSIS/SSRS)

Responsibilities:

• Developed Query for generating drill down and drill through reports in SSRS 05
• Uploaded reports on to the report manager and organized them into folders.
• Generated and formatted Reports using Global Variables, Expressions and Functions for the reports. Designed and implemented stylish report layouts.
• Identified and worked with Parameters for parameterized reports in SSRS 2005
• Developed, deployed and monitored SSIS Packages including upgrading DTS to SSIS.
• Created parameterized, drill down, drill through and aggregation type of reports, charts and dashboards in SSRS .
• Created shared dimension tables, measures, hierarchies, levels, cubes and aggregations on MS OLAP/ Analysis Server (SSAS).
• Enhancing performance using optimization techniques-normalization, indexing and Transaction Isolation levels, monitoring logs to ensure the completeness of batch processes, scripts and processes. Created Linked Servers to connect OLE DB data sources and providers.
• Administered the SQL server by creating user logins, dropping and locking the logins, monitoring the user accounts, creating groups, granting privileges to users and groups.
• Designed and created MDX queries to retrieve data from cubes using SSIS.
• Worked with Application Developers to design databases and tables to support development activities and achieve optimal efficiency
• Designing Logical and Physical Data Model with Erwin tools
• Creating and Modifying Tables, Stored Procedures, Views, Indexes, User-defined Functions, and Triggers etc as required
• Generated different types of Tabular Reports, Matrix Reports, Chart and Graphs Reports, Ad-Hoc Reports using MS SQL Reporting Services (SSRS).
• Designed and deployed reports with Drill Down, Drill Through, Parameterized and Sub-reports using SSRS.
• Managing security roles in SQL Suite.
• Diagnosing and tuning the server optimal performance using SQL Server 2005 SQL Profiler and Database Engine Tuning Wizards.

Environment: SQL Server 2008/2005, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), SSRS, Windows Server 2003, DTS, T-SQL, SQL Profiler, SQL Server Agent, Oracle, MS Excel, C, C++, XSLT, Visual Studio 2008, .Net (Asp.Net, C# .Net), Data Explorer.

Confidential, Memphis, TN

SQL Server DBA/Developer

Responsibilities:

• Responsible for creating schema objects like tables, views and indexes
• Used Views, Triggers, and Stored Procedures for updating and cleaning the existing data and also the new data
• Responsible for logical and physical design of database
• Upgraded DTS packages to SQL Server Integration Services (SSIS)
• Migrated SQL server 2000 DTS packages to SQL Server 2005 SSIS packages using SQL Server 2005 Upgrade Advisor.
• Responsible for the design of the SSIS package for updating the data mart from OLTP database and validation of the aggregate data from the ODS and the OLTP Database.
• Used various dataflow and control flow controls for the ETL.
• Develop and support reports built with Microsoft Reporting Services on SQL 2005.
• Designed the usage summary and detailed reports in SSRS 2005 from the requirement document and the old reports Mock-Up in MS Excel.
• Responsible for the reports deployment through SSRS on the Reports Server. Returned the stored procedure and the UDF for the reports.
• Set up database backup and recovery strategies.
• Scheduled and monitored all maintenance activities of SQL Server 2000/2005 including database consistency checks and index defragmentation.
• Work with SQL development teams on optimizing code and long running queries
• Running DBCC consistency checks and fixing data corruption in application databases

Environment: MS SQL 2000/2005, Windows NT/2000/XP, SSIS, DTS, SSRS, SQL Query Analyzer, Enterprise Manager, MS Access

Confidential

SQL Server DBA/Developer

Responsibilities:

• Designed Tables, Constraints, Views, and Indexes etc. in coordination with the application development team.
• Created ERD (Entity Relationship Diagram) using Erwin tool.
• Fine tuned application logic for better performance, developed complex queries, functions, stored procedures and triggers
• Designed and developed and scheduled the various DTS package for data migration, bulk load data using BCP, import/export.
• Responsible for Database backup and recovery such as build the master database if crash recover the master and user database and recover the database in point in time.
• Used Data Modification Language (DML) to insert and update data, satisfying the referential integrity constraints and ACID properties.
• Used DTS-FTP (File Transfer Protocol) task to upload files to FTP Server.
• Import Data from MS-EXCEL, MS-Access Database and XML to SQL Server Database.
• Developed user friendly GUI using HTML and CSS.
• Planned and implemented different SQL queries required to fetch the required data on different VB and JSP forms.
• Performed regular reviews of database security and adjusted accordingly to ensure access and modification only by authorized users and/or applications.
• Involved in migrating the existing DB environment to the highly available Active Passive Clustering SAN DB environment.

Environment: SQL Server 2000, SQL Server 7.0, Windows 2000 Server, DTS, XML, MS-Access, HTML, FTP, Erwin.

Confidential

SQL Server Developer

Responsibilities:

• Interacted with business analysts to understand the business requirements.
• Created logical and physical database design using Erwin.
• Wrote complex T-SQL queries for data extraction.
• Migration of data from text files to SQL Server 2000 using BCP and DTS packages.
• Created T-SQL triggers and Stored procedures encompassing business rules.
• Wrote DTS packages to move data between production, staging and QA environment.
• Programmed SQL Server 2000 Reporting Services using Microsoft Visual Studio 2003.
• Uploaded SQL Server 2000 Reporting Services RDL files to SQL Server 2005.
• Created database objects for improving the performance.
• Fine-tuned Procedures, Functions and Triggers for optimum performance.
• Involved in creating SQL reports.
• Involved in the SQL Query Performance Tuning.

Environment: SQL Server 2000, Windows NT, Access 2000, Query Analyzer, Enterprise Manager, Erwin, Data Transformation Services (DTS)