PROFESSIONAL SUMMARY:

• Over 8+ years of IT experience in Health Care and Retail industry. Was involved in analysis, designing, developing, data mapping and testing of reports and business applications using Microsoft products SQL Server 2012/ 2008R2/2008/2005, SAS, Teradata, and DB2.
• Extremely efficient in Software Development Life Cycle (SDLC) from analysis, design, development, testing and implementation in diverse range of software applications.
• Worked extensively on SQL server management studio, SQL server 2012/2008R2/2008/2005, Business Intelligences Development Studio, Teradata, DB2, MS Access Database.
• Proficient in data modeling concepts and formalized database design including creation of tables, indexes, and enforcing data Integrity.
• Experienced in maintaining change data capture in SQL Server 2008R 2/2008/2005.
• Implemented business logic and developed the database using stored procedures, views, user defined functions, cursors and triggers, indexes using T - SQL. Write the SQL code for developing the stored procedure.
• Good exposure to relational database management systems.
• Experienced in supporting very large databases (VLDB) and troubleshooting the problems.
• Experience in data and metadata management and Business Intelligence solutions using SSIS, SSRS. Expert in development, implementation, administration and support of ETL processes for large-scale Data Warehouses using Data Transformation Services (DTS) and SSIS with MS SQL 2008/2005.
• Experienced in migrating and testing DTS packages to SQL Server integration services.
• Experienced in data and metadata management and Business Intelligence solutions using SSIS, SSRS.
• Developed the DTS packages/SSIS to import data from different format. Good exposure to creating dynamic SSIS to transfer data crossing different platforms validate data during transferring and archived data files for different DBMS.
• Involved in creating SSIS packages by using different transformations like conditional spilt, Aggregate, Slowly changing dimensions, etc.
• Scheduling and maintaining SSIS Packages and batch jobs thruSQL Server Agenton a weekly basis
• Strong Knowledge and Extensive experience in data transformations, data loading, and performance tuning.
• Knowledge and understanding of SSAS, OLAP cube and Architecture.
• Extensive experience in report writing, designing and handling using SQL Server Reporting Services 2008R2/2008/2005 (SSRS) and in creating various types of reports like tables, matrix, chart report, Spark line, Gauge, web reporting by customizing URL Access.
• Created and deployed reports and managed security for reports using SSRS.
• Experience in Performance Tuning and Query Optimization.
• Good Experiences on SAS Reporting by SAS/ENTERPRISE GUIDE. Expertise in using different versions of SAS (from SAS 6.1 to SAS 9.1) data conversions and PROC SQL.
• Strong Teradata SQL, ANSI SQL coding skills. Knowledge and experience in Teradata Database like Bteq, Macros, Functions, views, Tables.
• Experiences in creating the Macro, Views, Procedures, Bteq in the TERADATA Data sources. Designed and Developed the SSRS reports from TERADATA Data sources.
• Developed UNIX shell scripts and used BTEQ, FastLoad, Multiload, and Fast Export utilities extensively to load to target database.
• Developing the SSRS reports using the Teradata data sources tables, view and macros.
• Good exposure in creation of jobs, schedulers, alerts using SQL Server agent and notifications using SQL mail and database mail.
• Extensively involved in Unit, System Integration testing and functional testing.
• Expertise in using ticketing system.
• Responsible for Production support.
• Knowledge about the VB script and HTML.
• Knowledge and Experiences on SharePoint website creation.
• Excellent communication, interpersonal skills and has a strong ability to work as part of a team and as well as handle independent responsibilities.

SKILL:

Operating Systems: Windows(XP, 98,00, NT, VISTA), UNIX, Mainframes

Database Management tools RDBMS/DBMS: MS SQL SERVER, MS Access, DB2, Oracle, T-SQL, Teradata

Administration Tools: SQL Server Enterprise manager, Query Analyzer, Client Configuration Utility, SQL server Profiler

DataWarehousing/MS BI Tools: SQL Server Business Intelligence Development studio DTS, SSIS, SSAS, SSRS, Performance Point Server

Reporting Tools: Crystal Reports, Performance Point Server 2007, Report Builder, WebI, Deski. SSRS, SAS

Teradata Tools & Utilities Query Facilities: Teradata SQL Assistant, BTeq

Version Control Tool: Clear Case and Clear Quest

Programming Languages: C, C++, Java, J2EE, PL/SQL, HTML, XML, VB Script

Secure Copy(SCP): Ultra Edit, WinSCP

PROFESSIONAL EXPERIENCE:

Confidential, Tennessee

Programmer Analyst

Responsibilities:

• Involved in designing the database as per business requirement using SQL server Management studio -SQL server, DB2 and MS access database.
• Involved in gathering the requirements with business users.
• Involved in Software Development Life Cycle (SDLC) from analysis, design, development, testing and implementation in diverse range of software applications.
• Extensively worked on Data mapping from one database to other database.
• Developed automated process for Deriving aggregated summary tables from Database which gives Daily, weekly, monthly, Launch to date views of user’s performance.
• Created and managed database objects such as tables, views, clusters, indexes, stored procedures and triggers and also maintained referential Integrity.
• Created Complex queries and used Functions like, Cursor Functions, String Functions, System Functions, and Date - Time Functions.
• Involved in providing the structure, to store data and to maintain database efficiently, worked extensively in writing complex queries and debugging complex stored procedures, Tables, Views, Function, Triggers and Indexes in the database using T-SQL.
• Created stored procedure, views, temp tables for data manipulation & reporting.
• Optimized SQL queries for efficiency and provided procedures for the front-end application.
• Created recursive and non-recursive queries using Common Table Expression (CTE), joined tables using merge.
• Created the indexes to improve the performances and also rebuilt indexes on tables using various SQL Server commands to reduce fragmentation.
• Involved in extracting, transforming and loading bulk data from different data sources into SQL server.
• Experienced in migration of data using SSIS and DTS Packages, Import/Export Wizard and Copy Database Wizard.
• Strong Knowledge and Extensive experience in data transformations, data loading, and performance tuning.
• Designing the SSIS packages by using transformations like conditional spilt, Aggregate, Slowly changing dimensions, etc. using SQL server intelligence Service.
• Experiences in migrating the reports from SQL server 2005 to SQL server 2008R2 version.
• Knowledge about creating Star schema cubes using SSAS, OLAP cubes and architecture.
• Involved in data loading and develop the SSRS reports using SQL Server Business Intelligence Development Studio.
• Involved in minor enhancement SSRS Reports and Created ad-hoc reports and customized reports to satisfy business and managerial needs.
• Extensive experience in developing, designing and handling SSRS Reports like Tables, Matrix, Bar, Charts, Sub reports and Drill down Reports usingSSRS2008R 2/2008/2005.
• Involved in developing reports using report builder 3.0 and SSRS and published as PDF, Excel, and CVS formats. And creating different types of reports by extracting data from tables, stored procedures into SQL server reporting services. And customizing reports by adding Filters, Calculations, Prompts, Summaries and Functions. Created, deployed and managed security for reports using SSRS.
• Extensive experience in report writing using SQL Server Reporting Services (SSRS) and in creating various types of reports like tables, matrix, and chart report, Spark line, Gauge, web reporting by customizing URL Access.
• Extensive experience in designing and handling SQL Reports, Sub Reports and Drill down Reports.
• Proficient in designing report layout, sorting the data, defining subtotals for the reports usingSSRS2008R 2/2008/2005.
• Responsible for Analyzing report requirements and developing the reports by writing Teradata SQL Queries, Views and macros.
• Working on the Teradata SQL Assistant and created the Tables, macros, views in Teradata database.
• Working on creating the macro in the database where the macros are used to build the SSRS reports.
• Worked and experiences in scheduling the reports weekly, monthly as per the business needs.
• Worked on building PRO SQL, Macro libraries and automation of SAS Codes extensively and developed the SAS report using SAS enterprise guide.
• Configured Reporting Services and Managed Reporting Security by creating groups and granting access to report folders.
• Works on the Documentation to promote the code into production using version control tool.
• Involved in coordinating and promoting code development to production and manages the security of the reports.
• Worked on creating the Web focus reports using the Microsoft visual studio.
• Knowledge on designing Web pages using HTML.
• Experience and Knowledge on SharePoint Internal Website Creation.
• Knowledge and Extensively used VB script for customizing data to display in reporting service.
• Working in maintenance of SQL database, each month vendor will send BCBST a data CD will update to the MDDB files. There are several steps that need to be performed before the files can be used in the monthly MCSource cycle Process by using application tool. Working on the loading the file from the vendor’s website and do the procedures to load the data from the files into the SQL database tables.
• Worked and Knowledge about the HEDIS DB in Teradata.
• Fix few templets issues like incorrect cell mapping, formatting the dollar and percent Values etc.,
• Fixes the issues in the bteq, formats and formulae in Excel/PPT, Methodology related questions. Metric related questions.
• All the bug fixes are worked upon assignment and follows release schedule.
• Strong communication skills and ability to work well in a team

Environment: MS SQL Server Management Studio 2000/2005/2008/2008 R2, DB2, MS Access, T-SQL, Teradata SQL Assistant, SQL Server Business Intelligence Development - SSIS, SSRS, DTS, Performance Point Server, Crystal reports, Enterprise manager, Client Configuration Utility, Server Configuration Utility, Query Analyzer, ClearCase and ClearQuest, SAS Enterprise guide, Application Tools, Ultra Edit, WinSCP

Confidential, Jacksonville, FL

Programmer Analyst

Responsibilities:

• Involved in gathering the business requirements.
• Created the tables, views, indexes, stored procedure in the database and responsible for maintaining the database.
• Worked on created the complex Queries
• Strong experience in SQL Development, ETL development using Microsoft SQL Server Integration Services (SSIS) and Reporting solutions using Microsoft SQL Server Reporting Services (SSRS).
• Worked on all activities related to the development, implementation, administration and support of ETL processes for large-scale Data Warehouses using SQL Server SSIS.
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS
• Worked on the reports to pull up the finances data of the company by using the Business intelligence SQL server Reporting Services (SSRS).
• Developing Corporate Dashboard Reports using SQL Server Reporting Services (SSRS), Report Model and Ad Hoc Reporting using Report Builder functionality.
• Hands-on in development of Drill down Reports in SSRS and Generated daily, weekly and monthly reports for the manager.
• Developed Sub Reports, Matrix Reports, and Charts using SQL Server Reporting Services (SSRS).
• Experienced in writing parameterized Queries for generating reports, formatting report, layout, sub reports using global variables, expressions and functions in SSRS.
• Experience in up gradation and Migration of SQL Server 2005 to SQL Server 2008.
• Experiences and Worked on migrating the SSRS reports from SQL server 2005 to SQL server 2008 to SQL server 2008R2.
• Worked on minor enhancement project. Involved in redesign, recode and new design layout of the SSRS reports.
• Assisted with various adhoc Query request and built the ad hoc reports.
• Worked and Involved in promoting the code to production.
• Worked on solving issues by doing data recovery in existing database.

Environment: MS SQL Server 2008R2/2008/2005, SSIS,SSRS, Oracle 10 g, VB 6, MS Access, Erwin, SQL Server Profiler, Windows XP, IIS 7.0, UNIX.

Confidential, CA

SQL Server Developer

Responsibilities:

• Created and managed database objects such as tables, views, clusters, indexes, procedures & triggers and maintained Referential Integrity.
• Created Complex queries and used Functions like, Cursor Functions, String Functions, System Functions, and Date - Time Functions.
• Created Stored Procedures, triggers, views, temp tables for data manipulation & reporting.
• Optimized SQL queries for efficiency and provided procedures for the front-end application.
• Created recursive and non-recursive queries using Common Table Expression (CTE), joined tables using merge.
• ETL process development, data sourcing, transformation, mapping, conversion and loading for Customer and Product data from MS Access to SQL database.
• Monitor and fine-tuned the poorly performing Queries and Stored Procedures by implementing the Coding and Design Standards.
• Designed and implemented ETL processes with SSIS packages to make data available for reporting purpose within a data warehouse.
• Created SSIS Packages and jobs to perform filtering operations and import the data on daily basis from the MS Access DB to SQL server R2.
• Worked on Control Flow, Data Flow, Error handling, and performance tuning of SSIS package.
• Experience on various Data Flow Task like Lookup, SCD, Condition Split, Multi task, Catch connection, Derived column, sort, Merge Join etc.
• ETL Development using SSIS packages, stored procedures, materialized views and external tables for transferring data from transactional database into the Data Warehouse environment.
• Design/Build ETL procedures in SSIS using packages to import/export data feeds to/from data warehouse and claim system.
• Generated Sales Ranking reports using SSRS for different products. Designed and developed dashboard reports.
• Develop and deliver dynamic reporting solutions using SQL Server 2008 Reporting Services (SSRS).
• Worked on Tables, Chart, sub report, Matrix, Gauge, Spark line using SQL server 2008 Reporting Services (SSRS).
• Managed and resolved design issues during development. Moved database Schema changes to stage or production. Migrated and upgraded databases from version 8i to 10g.
• Implemented and maintained Change Data Capture in SQL Server 2008 R2. Involved in job scheduling using MS SQL server Agent.
• Configured Reporting Services and Managed Reporting Security by creating groups and granting access to report folders.
• Created technical specification with deliverables to include pseudo code and test cases.
• Developed and tested T-SQL and complex store procedures used for Drilldown reports.
• Analyze data using SQL Developer, Excel and data testing tools.
• Experiences in working on the unit and system test.
• Involved in documentation of the projects and experiences in working on the deployment the reports to production.

Environment: MS SQL Server 2008R2/2008/2005, SSIS,SSRS, Crystal Reports 8.5, Oracle 10 g, VB 6, MS Access, Erwin, SQL Server Profiler, Windows XP, IIS 7.0, UNIX.

Confidential

SQL Developer

Responsibilities:

• Knowledge of Software architectures and development life cycle.
• Involved in designing the database.
• Expert in creating tables, writing and debugging complex stored procedures, Functions, Views and DML/DDL Triggers.
• Created stored procedures to retrieve the customer details, connection details, payment history by giving the related parameters.
• Performed Index analysis for tables and came upwithmore efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost using index tuning wizard. Rebuilding the indexes at regular intervals for better performance.
• Developed DTS packages for transferring the data between MS Excel, Flat Files and SQL Server.
• Extensively used DTS Import/Export Wizard, for performing the ETL operations.
• Involved in migration from MS SQL Server 2000 to MS SQL Server 2005, DTS to SSIS.
• Created the SSIS packages using transformations.
• Wrote scripts for dropping and creating referential Integrity constraints to decrease load time.
• Problem identification, troubleshooting, and index tuning the databases.
• Developed and maintained historical data from various heterogeneous data sources (i.e. Excel, Access).
• Enforced the Business Rules by creating constraints.
• Experience in creating, Developing and Publishing Reports in SQL Server 2005 using SSRS the reports using SSRS reports using SQL server reporting tool.

Environment: MS SQL Server 2000/2005, SQL Profiler, MS Access, Excel, Query Analyzer, windows 2000, Enterprise Manager, Data Transformation Services (DTS).