SUMMARY

• Over 8 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.
• Knowledge on AS 400 platform.

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, IL

Sr.BI/SQL & Web Developer

Responsibilities:

• Involved in complete Software Development Life Cycle (SDLC) process by analyzing business requirements and Understanding the functional work flow of information from source system to destination system.
• Advanced extensible reporting skills using SQL server Data Tool 2012 (SSRS).
• Designed and created Report templates based on the financial data.
• Developed various types of Complex reports like Drill Down and Drill through reports.
• Involved in designing Parameterized Reports for generating Adhoc reports as per client requirements.
• Coordinate with front-end for implementing logic in stored procedure and functions.
• Experienced in writing Complex SQL Queries, Stored Procedure, Triggers, Views, Joins, Constraints, DDL, DML and User Defined Function to implement the business logic and also created clustered and non-clustered Indexes.
• Developed an SCRA web site.
• Developed Questionable, Error Response, Reports and Admin modules for SCRA website.
• Developed secure web application, which includes login form, which will authorize and authenticate the users by retrieving their login names and passwords from the database using ADO.Net.
• Developed User Control according to the requirement. Used ADO.net Connection Oriented and disconnected Architecture for database connectivity.
• Extensively used ADO.Net objects to populate Data sets, Data grid and Repeater controls for display and manipulation of records.
• Created a simple, aesthetic and consistent User Interface with shortcuts, menus, forms and controls in VB.NET.
• Dealt with complex design and maintenance issues for SQL by implementing atomicity, consistency, isolation and durability.
• Used Data Grids, Data Sets, Data Views, and Data Adaptors to extract data from the backend.
• Worked extensively on web forms and data binding controls like Grid View, Data List and drop down boxes and Mapping page fields to the database fields.
• Used Web Forms and Server controls in ASP.Net. Created Dynamic Controls in web pages.
• Developed object interfaces for relational database access from presentation layer.
• Created session objects to maintain session between ASP.NET Pages.
• Successfully developed and deployed .NET applications following all coding standards.
• Validating the whole functionality
• The system was deployed as an ASP.NET web application by using VB.NET.
• Used Agile methodology (SCRUM) for the development

Environment: T - SQL, SQL Server2012, Microsoft SQL Server Management Studio, SQL Server Integration Services (SSIS), SSRS, SSAS, VB.Net 4.5 and ASP.Net 4.5.

Confidential, MN

Sr.BI/SQL & Web Developer

Responsibilities:

• Creating Stored Procedure, User Define Functions, Views, TSQL scripting for complex business logic.
• Extensively used joins and sub-queries for complex queries involving multiple tables from different databases.
• Optimized the database by creating various clustered, non-clustered indexes and indexed views.
• Increased the performance necessary for statistical reporting by 25% after performance monitoring, tuning and Optimizing indexes.
• Created Alerts for Successful or unsuccessful completion of Scheduled Jobs.
• Developed complex Stored Procedures and Views to generate various Drill-through reports and Parameterized Reports using SSRS.
• Designed SQL SSIS Packages to extract data from Various data sources such as Access database, Excel Spreadsheet and Flat files into SQL Server 2008 Database by using multiple transformations provided by SSIS Such as Data Conversion, Conditional Split, Merge and Union all; scheduled and maintained nightly and Weekly load of data by creating the corresponding job tasks.
• Deploying the SSIS packages and SSRS reports on the server.
• Created ASP.Net web pages using VB.Net.
• Worked with Master Pages.
• Design the subpages for Confidential and Dons websites using HTML and CSS for developing Web pages.
• Utilized ADO.NET technology extensively for data retrieving, querying, storage and manipulation.
• The code behind is implemented in VB.net.
• Experience in working on conceptual, Physical and logical data models using Visio Data Modeling.
• Used Grid View, Form view to display data with a rich look and feel.
• Used VSS to manage the source code.
• Used Agile methodology (SCRUM) for the development.

Environment: T - SQL, SQL Server2008, Microsoft SQL Server Management Studio, SQL Server Integration Services (SSIS), SSRS, SSAS, VB.net and ASP.net.

Confidential, MD

Sr.BI/SQL Developer

Responsibilities:

• 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.
• Extensively worked in Oracle SQL, PL/SQL, SQL * Plus, Query performance tuning, Created DDL scripts and Database objects like Tables, Views and Indexes.
• Experience in working on conceptual, Physical and logical data models using Erwin and Visio Data Modeling.
• Used Waterfall methodology for the development.

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

Confidential, MN

Sr SQL Server/BI Developer

Responsibilities:

• 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.
• Experience working as Team Lead.
• 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.
• Experience in working on conceptual, Physical and logical data models using Erwin Data Modeling.

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

Confidential, OH

SQL Server/BI & ASP.NET 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.
• Worked in (3T) User Interface layer, Business Logic layer and also in the Data Access layer with the SQL Server.
• The system was deployed as an ASP.NET web application by using C#.NET.
• Played an active role in analyzing, documenting and designing the application
• Created ASP.Net web pages using C#.
• Worked with Master Pages and Cascade style sheets (CSS) for the web pages.
• Used ADO.NET objects such as Data Adapter, Data Reader, Dataset and Data View for reading/updating records in the database.
• Worked on providing security using authentication and authorization techniques.

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

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.
• Worked with HIPAA 4010 and HIPAA 5010.
• Experience Working with ICD-9 and ICD-10.
• Worked in IBM Open Connect.
• Worked with NASCO mainframes to process the Medical claims like E835,E832 and E837.
• Used Waterfall methodology for the development.

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.
• 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.

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