SUMMARY

• Nine years of experience in the IT industry, includes Software Analysis, Design, Development, Customization and Implementation of various business applications.
• Extensive experience in SQL Server, T - SQL, Oracle and MS Access.
• Experience in the complete life cycle of databases which includes the design a database, populating lookup data, creating Stored Procedures as per front end developer’s requirement and commercial transitions, writing Triggers, creating user defined functions and created views to simplify the complexity of the data structure.
• Experience on T-SQL, Distributed Queries, and Correlated Sub Queries and used most of the systems function.
• Experience in using recursive CTEs, CTE, Temp tables and effective DDL/DML triggers to facilitate efficient data.
• Experience on optimization of the stored procedures, Created indexes on the required tables, Created distributed partition views, and indexed views.
• Experience in Extraction Transformations and Loading (ETL) tools like SQL Server Integration Services (SSIS), Data Transformation Services (DTS), Bulk Insert, and Bulk Copy (BCP).
• Skilled in error and event handling: precedence constraints, Break Points, Check point and Logging.
• Experience in using SSIS tools like Import and Export Wizard, Package Installation and SSIS package Designer.
• Experience in importing/exporting data between different sources like Oracle/Access/Excel etc using SSIS/DTS utility.
• Experience in ETL processes involving migrations and in sync processes between two databases.
• Experience in Microsoft Visual C# in script component of SSIS
• Experience in creating configuration files to deploy the SSIS package across all environment.
• Based on the business requirements,worked onFACT’s and DIMENSIONS.
• Expertise in writing MDX query in OLAP Databases
• Experience in designing Star Schema and snowflake schema with Facts, Dimensions, Measures and Cubes.
• Experience in designing, creating, processing of cubes using SSAS.
• Excellent experience in creating, managing and deploying various types of reports using SQL Server Reporting Services and Report Manager.
• Extensive experience in developing reports using SQL Server Reporting Services (SSRS), Crystal Reports, Oracle Reports and MS Access reports.
• Expert in generating writing parameterized queries, drill through reports and formatted SQL server reports in SSRS 2005/2008/2008 R2 using data from ETL Loads, SSAS cubes and various heterogeneous data sources.
• Experience in database administration and maintenance activities such as Backup and Recovery, monitoring SQL Server.
• Experience in Capacity planning and Disaster Recovery Planning.
• Experience on optimization of the stored procedures, Created indexes on the required tables, Created distributed partition views, and indexed views.
• Intensive experience in monitoring and tuning SQL Server and database performance using SQL Profiler, Index Tuning Wizard and Windows Performance Monitor.
• Monitored and tuned application using the performance Diagnostic tools such as SQL Profiler.
• Experience in maintaining security on multiple servers and multiple databases with Windows authentication and SQL Authentication.
• Experienced in Migrating databases from SQL Server 2005 to SQL Server 2008.
• Knowledge of data warehouse fundamentals,
• Good knowledge of parallel processing used it for faster query processing and loading data.
• Good experience with database designing, creating logical and physical data models using Erwin.
• Ability to handle multiple tasks, Initiative, Adaptable, self-motivated and organized team player with strong problem solving and analytical skills and total commitment to the organization goals.
• Good ability to quickly grasp and master new concepts and technologies.

TECHNICAL SKILLS

Databases: Oracle 10g/9i/8i/8.0, Access, MS-SQL Server.

Tools: /Utility: Enterprise Manager, SQL Server Management Studio(SSMS),SSIS, Database Tuning Advisor, DTS, Analysis Manager, BCP, SQL Profiler, Query Builder, Informatica, Erwin.

Languages: C, C++, SQL, PL/SQL, UNIX Shell Programming, HTML, Visual Basic, Java, XML.

Web Applications: Active Server Pages 2.0.

Testing Tools: Win Runner 7.0, Test Director 8.0

GUI Tools: Forms 5.0/6i/9i, Reports 3.0/6i/9i

Other: MS Word, Excel, PowerPoint, Visio

PROFESSIONAL EXPERIENCE

Confidential, MD

BI/SQL Lead Developer

Responsibilities:

• Worked with team and involved in designing, developing and deploying reports in MS SQL Server environment using SSRS-2008/2012 and SSIS in Business Intelligence Development Studio (BIDS) and SQL Server Data tools (2012).
• Used ETL (SSIS) to develop jobs for extracting, cleaning, transforming and loading data in data warehouse.
• Prepared the complex data mapping for all the migrated jobs using SSIS.
• Designed SSIS packages to transfer data from flat files to SQL Server Using BIDS and SQL Server Data tools.
• Extensively used SSIS transformation such as Lookup, Derived column, Data conversion, aggregate, condition split, SQL task, Script task and Send Mail task etc.
• Created SSIS packages using SSIS Designer for export heterogeneous data from OLEDB Source (Oracle), Excel Spreadsheet to SQL Server 2008 R2/2012.
• Performed operations like Data reconciliation, Validation and error handling after Extracting data into SQL Server.
• Worked on SSIS package, Import/Export for transferring data from Database (Oracle and Text formatted data) to SQL Server.
• Implementation of MS SQL Server 2008 R2/2012 Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) views using T-SQL evaluates result for the reports.
• Involved in designing, developing, debugging and testing of reports in SQL Server Reporting Services (SSRS).
• Created SQL server Reports using SSRS 2008.Identified the data source and defined them to build the data source views.
• Creating reports using SQL Reporting Services (SSRS) for customized and ad-hoc Queries.
• Developed dashboard reports using Reporting Services, Report Model and ad-hoc reporting using Report Builder.
• Experience in creating Parameterized reports and Linked reports with thorough knowledge of report serving architecture. (Table, chart and matrix report).
• Created reports in SSRS with different type of properties like chart controls, filters, Interactive Sorting, SQL parameters etc.
• Applied conditional formatting in SSRS to highlight key areas in the report data.
• Generated SSRS report using Oracle Database.
• Work on projects like Healthy Blue, Medical Loss Ratio and Account Searchlight to generate the reports.
• Creation of the various database objects - tables/views/stored procedures - in SQL Server 2008.
• Performed the optimization, Tuning of the indexes and the queries
• Used the maintenance Plan for SQL databases to recreate indexes and statistics for the performance.
• Development, Stored Procedures, Views, Triggers, Index and SQL Scripts.
• Created reports by extracting data from cube.
• Generated reports using SQL Server Reporting Services 2005/2008 from OLTP and OLAP data sources.
• Improve the performance of a cube by creating aggregations and partition of EGR 3.0 project.
• Create few workflows in Informatica to load the data into Oracle tables.
• Experience working in HIPAA 4010 and HIPAA 5010.
• Generated reports from A.C Cube and Medical Management.
• Good experience in writing the MDX queries to pull the data from the cube.
• Expert in creating Star schema and Snow Flex cubes usingSSAS.
• Created Dimension and Measure for the Cube.
• Deployed the RDL on SharePoint
• Deployed the business documents on SharePoint.
• Generated the reports in SharePoint.

Environment: T - SQL, SQL Server2008/2012, Microsoft SQL Server Management Studio, SQL Server Integration Services (SSIS), SSRS, SSAS, Informatica, Sql and PL/SQL.

Confidential, MN

Sr SQL Server Lead Developer

Responsibilities:

• Worked as a Lead and migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Services.
• Excellent skills in implementing ETL Packages using DTS and SSIS 2008.
• Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.
• Designed and developed the Staging Database and loaded from source to staging and from staging to the Destination tables applying different transformations.
• Experience working with Transfer SQL Object Task which transfer Objects in SQL Server.
• Experience working with Execute Package Task which used to call the Child package or Sub Package from Master Package.
• Worked on several transformations in Data Flow including Derived-Column, Script Data Conversion, Conditional-Split and many more.
• Utilized several Transformations like Lookup, Fuzzy Lookup for implementing the Transformation Logic in the Packages.
• Proficient in implementing all transformations available on the SSIS toolbox, Package Configuration and Logging.
• Experience in importing/exporting data between different sources like Access/Excel etc. using SSIS/DTS utility.
• Excellent knowledge of using variables and expressions in packages.
• Developed complex T-SQL Queries.
• Expert in creating indexes, Views, complex Stored Procedures, user defined functions, cursors and Triggers to facilitate efficient data manipulation and data consistency.
• Created complex conceptual database designs in SQL Server 2008 using various constraints and triggers.
• Schedules the SQL jobs in ZEKE scheduler.
• Experience working with Batch jobs to call .Net Code.
• Increased query performance, necessary for statistical reporting by more than 25% after performing monitoring, tuning, and Optimizing Indexes tasks by using Performance Monitor, Profiler, and Index tuning wizard.
• Experience working with applications like Bloomberg Data which contains information like tax free Municipal Bonds from different region like North and Latin America.
• Performed Unit Testing and Prepared maintenance plans.

Environment: T - SQL, SQL Server2000/2008, Microsoft SQL Server Management Studio, SQL Server Integration Services (SSIS), SSRS, SSAS, DTS.

Confidential, OH

SQL Server/BI Developer

Responsibilities:

• Create SSIS package to clean and load data to data warehouse.
• Create package to transfer data between OLTP and OLAP databases.
• Create SSIS and used the task to import and export files.
• Create, modify,schedule,test and or trouble shoot SQL Server Integration Services
• (SSIS) packages, stored procedures, Tables and Views.
• Experiences in designing, Creating and processing of Cubes using SSAS.
• Scheduling cubes processing from staging Database Tables using SQL Server Agent.
• Aggregated the cubes with 40% Performance for better performance.
• Processed cubes to perform incremental updates.
• Create Reports by extracting data from cube.
• SSRS to create, modify, run, export, print, distribute, deploy, and troubleshoot reports.
• Created Parameterized reports, Cross-Tab reports, Drill down reports & Summary reports by Using SSRS.
• Created report snapshots to improve the performance of SSRS.
• Involved in Unit Testing and System Testing of the application.
• Analysis and trouble shooting of defects.

Environment: T - SQL, SQL Server 2008, Microsoft SQL Server Management Studio, SQL Server Integration Services (SSIS), SSRS, SSAS.

Confidential, NJ

SQL Server Developer / SSRS Developer

Responsibilities:

• Writing of Stored Procedures and Functions using SQL Server 2008 and T-SQL.
• Creation of the various database objects - tables/views/stored procedures - in SQL Server 2008.
• Performed the optimization, Tuning of the indexes and the queries
• Used the maintenance Plan for SQL databases to recreate indexes and statistics for the performance.
• Development, Stored Procedures, Views, Triggers, Index and SQL Scripts.
• Created SSIS Package to transfer data from various locations using the FTP task. Then loaded the flat file data into the database.
• Experiences in designing, Creating and processing of Cubes using SSAS.
• Scheduling cubes processing from staging Database Tables using SQL Server Agent.
• Processed cubes to perform incremental updates.
• Create Reports by extracting data from cube.
• Experiences in Dimensional Modeling.
• Experiences in Xml scripts.
• Create, modify, test, and troubleshoot SQL Server Reporting Services (SSRS) reports.
• Created reports by extracting data from cube.
• Designed and deployed reports with Drill Down, Drill Through and Drop down menu option and Parameterized and Linked reports.
• Analysis and trouble-shooting of defects.
• Involved in Unit testing and System Testing for the application.
• Create database backups, restore, data replication, and database security.

Environment: Microsoft SQL Server 2005, Microsoft SQL Server Management Studio, T-SQL, SSRS, SSIS, SSAS, Erwin.

Confidential

SQL Server/SSRS Developer

Responsibilities:

• Gather and analyze business requirements
• Create data models to describe data and relationships between the data
• Create data-related documentation (e.g., file descriptions and definitions, entity relationships and attributes, etc.)
• Create new database objects such as Tables, Views, Indexes, Functions, and Triggers using T-SQL in Development and Production environment for SQL Server 2000/2005
• Create SSIS & DTS packages to import/export data to/from data-sources such as flat file, Oracle, DB2, Excel, Access, and XML
• Code Stored Procedures to validate, process data needed to create and update Retail warehouse
• Construct reports using SSRS from OLTP & OLAP Databases
• Validate change requests, prepare effort estimates and make appropriate recommendations
• Database planning in relation to physical and logical data architecture
• Develop and implement database and coding standards, improve performance and maintainability of SQL Server databases
• Provide back-end support for functional testing and performance testing.

Environment: SQL Server 2005, SQL Server 2000, T-SQL, SSIS, SSRS, SSAS, DTS, VBA-Excel,Oracle 8i/9i, VB.Net, VSS, Windows 2000/XP/2003, OS/390, AIX, Linux

Confidential

SQL Developer/SSRS Developer

Responsibilities:

• Involved in Analysis, Design, Development and Testing phases.
• Analyzed the business requirements from the given specifications.
• Writing of Stored Procedures and Functions using SQL Server 2005 and T-SQL.
• Maintenance of the various database objects - tables/views/stored procedures - in SQL Server 2005.
• Performed the Server optimization, Tuning of the indexes and the queries and Consolidation of SQL Server environment
• Used the maintenance Plan for SQL Server 2000 databases to recreate indexes and statistics for the performance.
• Design and implementation of Security Model, policies and procedures.
• Query Optimization using Query Analyzer, Profiler, Show plan, Index Tuning and Stats Time Tool.
• Created Snapshot Replication for the Development and Testing Databases across different Servers.
• Development of DTS Packages, stored procedures, views, triggers, index and SQL Scripts.
• Designed and developed complex SSRS reports.
• Create ad hoc complex management reports as required.
• Design and develop reports using SQL server reporting services
• Configuration of linked servers for user to be used for data exchange.
• Created and scheduled jobs and alerts
• Involved in version management of source code using VSS.
• Analysis and trouble-shooting of defects.
• Involved in designing of reports using SSRS.
• Involved in Unit testing and System Testing for the application.
• Experience working with CTE function.

Environment: Microsoft SQL Server 2005, Microsoft SQL Server Management Studio, T-SQL, Microsoft SQL Server Reporting Services.

Confidential

SQL Developer

Responsibilities:

• Involved in designing of conceptual logical model and physical model
• Created new database objects like procedures, functions, packages, triggers, indexes and views using T-SQL in development and production environment for SQL server 2000
• Fine-tuned the logic in procedures, functions and triggers for optimum performance.
• Developed database triggers to enforce data integrity and additional referential integrity.
• Wrote transact SQL utilities to generate table insert and update statements
• Involved in performance tuning and monitoring of both T-SQL and PL/SQL blocks
• Used SQL profiler and query analyzer to optimize DTS package queries and stored procedures.
• Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances
• Wrote T-SQL procedures to generate DML scripts that modified database objects dynamically based on user inputs.
• Created stored procedures to transform the data and worked extensively in T-SQL for various needs of the transformations while loading the data.
• Involved in performance tuning using indexing (cluster index, non cluster index) tables

Environment: SQL Server 2000/2005, MS Excel 2003/2007, MS Access 2003, Enterprise Manager, Management Studio, SQL Profiler