SUMMARY

• I do have 8 years of experience with a strong background in Data warehousing projects design, development and implementation with SQL Server 2012,2008R2/2008 in a high transaction and multi server production environment. Self learning ability and Leadership Quality.
• Well - organized, goal-oriented, highly motivated effective team member with excellent analytical, troubleshooting, and problem solving skills.
• Microsoft certified profession in Querying Microsoft SQL server 2012
• Expert in Extraction, Transforming and Loading (ETL) data using SSIS/DTS; creating mappings/workflows to extract data from SQL Server, Excel file, other databases and Flat File sources and load into various Business Entities.
• Expert in writing T-SQL queries, creating clustered and non-clustered Index, working on DTS, Data Cleansing and Data Migration.
• Excellent Knowledge of SDLC, RDBMS, Data Warehouse &Data Modeling concepts
• Expert in creating T-SQL objects, working with DDL/DML, perform most of the SQL Server Enterprise Manager and Management studio functionality using T-SQL Scripts and Batches.
• Experience in writing Distributed Queries between SQL Servers.
• Expert in creating Indexed Views, complex Stored Procedures, effective functions, and appropriate Triggers to facilitate efficient data manipulation and data consistency.
• Complete knowledge in optimization tools such as Index tuning wizard, SQL Profiler and Windows Performance Monitor for monitoring and tuning MS SQL Server Performance
• Experience in transforming unstructured data from various data sources using SSIS Transformations like Conditional Split, Lookup, Merge Join and Sort and Derived Column for cleaning bad data, validating data.
• Handled huge financial data, expert level query optimization and performance tuning experience.
• Experience in creating Jobs, Alerts, setting up SQL server mail agent for SSIS packages.
• Proficiency in Developing SSAS Cubes, Aggregation, KPIs, Measures, Partitioning Cube, Data Mining Models, and Deploying and Processing SSAS objects.
• Expertise skill in Migrating/Re-writing DTS packages to SSIS packages using Upgrade Advisor/Package Migration Wizard.
• Expertise in generating reports using Crystal Reports, SQL Server Reporting Services, and Microsoft Access & Excel spreadsheet.
• Experience in creating various reports like drill down, sub reports, parameterized, multi-valued and various adhoc reports through Report model creation.
• Good SQL Server Administration skills including, Backups, Disaster Recovery Model, database maintenance, user authorizations, Database creation, Tables, indexes.
• Extensive knowledge of thesoftware development life cycle (SDLC)from requirements gathering to programming, testing and maintenance.
• Extensive design and programming experience with web technologies likeHTML, DHTML, Java ScriptandStyle Sheets.
• Strong knowledge ofObject Oriented Design Methodologiesfor data security, reusability and disreputability over a network.
• Expertise in development of FormsusingC#andVB.Net

TECHNICAL SKILLS

• MS SQL Server 2000/2005/2008 r2, 2012
• MS SSRS
• MS SQL SSAS
• MS SSIS
• DB2 SQL syntax
• MS-Access 2000
• C
• C++
• VB 6.0
• Developer 2000
• Oracle 9i/10g
• T-SQL
• PL/SQL
• ASP.NET
• HTML
• XML
• XSL
• Visual Studio 2008
• T-SQL
• PL-SQL
• Crystal Reports
• ODBC
• MS Office
• Windows NT/ 2000 Server/ XP. MATLAB
• MS SQL Server
• Visual Studio

PROFESSIONAL EXPERIENCE

Confidential, Honolulu, Hawaii

MS SQL Developer/SI-base/SSIS Developer

Responsibilities:

• Performed daily tasks including backup and restore by using SQL Server 2005 tools like SQL Server Management Studio, SQL Server Profiler, SQL Server Agent, and Database Engine Tuning Advisor.
• Compressed data files by removing empty database pages and updating index statistics .and monitored scheduled jobs and alerts.
• Migrated data from different sources (text based files, Excel spread sheets, and Access) to SQL Server databases using SQL Server Integration Services (SSIS).
• Worked on various SSIS objects like Data flow components, Control Flow elements, Connection Manager, Event Handling and log providers.
• Extracted data from Flat and migrated into SQL Server 2008r2 using SSIS
• Assist in the creation of general system design and technical specifications for new/replacement/enhancement systems taking into consideration server capacity, limitations and system availability.
• Managed post-sales clientEDIenvironment implementation project from initial requirements call to final production server
• Setup clientEDIenvironment, including file system, file definitions, alert and error notifications
• Created complex Stored Procedures, Functions, Indexes, Tables, Views, SQL joins and other T-SQL code to implement business rules.
• Identified slow running query and optimization of stored procedures and tested applications for performance, data integrity using SQL Profiler.
• Migration is also done using Bulk Insert and dynamically created queries in the job steps.
• Implemented complex business requirement in backend using efficient stored procedures and flexible functions, and facilitated easy implementation to the front end application.
• Involved in creating multiple parameterized stored procedures which were used by the reports to get the data.
• Apply coding and analytical skills in all phases of the system life cycle
• Wrote C# code in Script Component to separate Flat file Data.
• Modified old SSIS package to support ICD10 and ICD9 healthcare version.
• Migration of various small applications from VB 6.0 to .Net 4.0 web applications, and migration of various database access/ SQL7.0 to SQL Server 2008
• Integrate hardware components to communicate with web applications and windows form applications using a combination of WCF services and APIs.

Environment: Microsoft SQL Server 2012,2008R2, SSMS, SSIS,SSAS, Microsoft Visual studio 2008 and 2010,Team foundation server-2008,C#,.Net.

Confidential, Jersey City, NJ

SQL Developer

Responsibilities:

• Defined and Designed data based on business requirement and provided documentation.
• Created SSIS package to load data from XML Files, Ftp server and SQL Server to SQL Server 2012 by using Lookup, Derived Columns, Condition Split, Ole DB Command, Term Extraction, Aggregate, Pivot Transformation, Execute SQL Task and Slowly Changing Dimension.
• Worked with Agile Methodology tracking the product backlog and resolved the defects assigned in daily scrum.
• Designed, developed and supported many Tables, Stored Procedures, and Triggers on Sybase and SQLserver
• Actively took part in Data Modeling/Data Dictionary ODS
• Develop Informatica mapping for load flat file from Ftp server to enterprise database.
• Worked closely with data modeler to create data model for or modified existing datmodel to support different report running on business object and SSRS.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse.
• Developed Validation Plans for SSIS packages for checking the functionality of each component and Code review.
• Planned and executed SSIS Package step process to load data, validate data and Recommending task to resolve performance issue with loading data in to the Data Ware House.
• Modified the existing SSIS packages, Script Component Task to meet the changes specified by the users and adding column to the newly design table and to the existing table.
• Scheduled Jobs for executing the stored SSIS packages, which were developed to update the database on Daily basis using SQL Server Agent.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs. Job overlap alert.
• Worked in setup auditing, logging environment to track the status of the events like error raise, task fail.
• Designed tool to Automatic added Derived column, Parameter and Configuration value to the package.
• Working with Team Foundation Server as the source for version control and project / issue management
• Designed, Developed and Deployed reports in MS SQL Server environment using SSRS-2012.
• Created reports to retrieve data using function, views, cube and Stored Procedures using parameters. Created various database objects like stored procedures, functions, tables, views, and triggers.
• Fine-tuned SQL Queries for maximum efficiency and performance using SQL Profiler and Database Engine Tuning Advisor.
• Provided documentation for all kinds SSIS packages.
• Designed and implemented Stored Procedures and Triggers (DDL & DML) for automating tasks.
• Designed and implemented Data Marts, Facts, Dimensions and OLAP cubes having Star/ Snowflake schema using Dimensional Modeling principles in SSAS.

Environment: MS SQL Server 2012, SQL BI Suite (SSMS, SSIS, SSRS,SSAS), XML,SI-Base, MS Excel, MS Access 2007 & Windows Server 2008, SQL Profiler, Data Analyzer, Erwin r 7.3, .Net 4.0/4.5, TFS 2010.Sybase 15,Informatica9.0

Confidential

SQL Developer

Responsibilities:

• Designed SSIS Packages in SQL Server 2008R2 to handle data migration (ETL Processes) from transaction System to Dimensional Model.
• Performed activities like analyzing and improving the architecture of databases, creation & indexing of the tables.
• Involved in designing the data warehouse and core Database for the system including tables, Stored Procedures, Indexes, UDF and triggers.
• Performed operations such as Fine-tuning queries and stored procedures and providing consultation to other developers. work closely with Data modular to complete the data model
• Scheduled and maintained nightly and weekly loads of data by creating the corresponding job tasks. work closely with cogon's report developer
• Developed functional and technical specifications documents such as the Business Scope Document and High Level Design Document.
• Configured and scheduled packages to be deployed out to a production environment using SQL server Table file configurations in SSIS.
• Configured packages for development, QA and Production environments
• Created views to facilitate easy user interface implementation, and triggers on them to facilitate consistent data entry into the database.
• Used Query Optimization and SQL Server Profiler for tuning report queries and improves performance in SQL Server.
• Worked closely with DBA team to regularly monitor system for bottlenecks and implement appropriate solutions
• Wrote C# code in Script Component To separate data from flat file and loaded into database.
• Configured SQL Mail agent for sending automated alerts/email

Environment: Microsoft SQL Server 2008R2 and 2012, SSMS, SSIS,SSAS Microsoft Visual studio 2008,AS-400,SQL view point, System i-navigator,Cognos10.1,Team foundation server-2008,C#

Confidential

C# .Net Developer

Responsibilities:

• Involved in gathering functional requirements, writing design specifications, prototype and architecting the new application using agile.
• Understanding system requirements by interacting with clients and execution of tasks allocated to maintain and develop Web pages.
• Perform enhancements for web using C# ASP .NET using Visual Studio 2012 andSQLServer 2012.
• Migrated data from csv files toSQLServer.
• Created class diagram, activity diagram and sequence diagrams.
• Worked extensively with cross functional team in an agile scrum environment to achieve the tasks within the given deadline.
• Implemented MVC architecture using C# .Net, HTML.
• Visual Studio 2012 was used as the IDE tool for the development of the project.
• Alongside contributed to developing database stored procedures.
• Stored Procedures, triggers and views for the data access were implemented inSQLScripts and tested.
• Developed LINQ, LAMBDA expressions and ADO .Net Data Services.

Environment: .NET Framework, ADO.NET, Visual Studio, C#, SQL Server 2005,T-SQL, SQL server, Microsoft Technologies .Net Framework …, ETL and Modeling Tools SQL Server Integration Services (SSIS), UML,Reporting Tools Crystal Reports, SQL Server Reporting Services (SSRS), Version Control Tools Team Foundation Server (TFS)

Confidential

Web Developer

Responsibilities:

• Involved in requirement analysis and application designing sessions with team members to outline the proposed project.
• Wrote Algorithms and Data Flow Diagrams considering all requirements and possibilities.
• Created Master Page, Page Layouts, HTML, CCS, JavaScript and designing tools.
• Providing Navigation controls and Login controls.
• Used .Net framework 2.0 and Object Oriented Methodologies for application development.
• Created the database and have written stored procedures using SQL Server.
• Implemented Object Oriented Programming languages (OOPS) concepts abstraction, encapsulationinheritance, polymorphism in C#.
• Used ASP.NET web form controls such as Grid View, Details View, Form View for displaying data.
• Used the Debugging and Tracing features of .Net.
• Documented the code for some of the modules.
• Used ADO.Net to perform Create, Retrieve, Update, Delete operations on the database.
• Participated in database modeling and development using SQL Server, Stored Procedures, Packages and Functions.
• Involved in designing and developing using different controls Component Art Grid View, Data List, TextboxCalendar, List Controls, Dropdown, Validation Controls etc.

Environment: .NET Framework 2.0/3.0, ASP.NET, ADO.NET, Visual Studio 2005/2008, C#, SQL Server 2005/2008, IIS,JavaScript, OOPS, HTML, CSS, HTML5, DHTML, JavaScript, JQuery, XML, AJAX, CSS, JSON, Bootstrap.Databases MySQL, T-SQL, MS-Access, SQL server, Web Services, MVC, LINQ, WCF, Web Forms, ETL and Modeling Tools SQL Server Integration Services (SSIS), UML,Reporting Tools Crystal Reports, SQL Server Reporting Services (SSRS)Version Control Tools Team Foundation Server (TFS)

Confidential

Database Developer/Application Programmer

Responsibilities:

• Analyzing the functionality and coding using C#.NET.
• Designing Screens.
• Taking the requirements from the Client, Solution design based on the requirements.
• Developed the Testing environment for few batch programs using Win forms.
• Designing the front end and back end (database).
• Debugging and fixing runtime errors during Testing and Production support

Environment: MS SQL Server 2005/2008, SSRS/SSIS/SSAS, Microsoft Office SharePoint Server 2007/2010,Crystal reports, T-SQL, Windows 2007,asp.net.