PROFESSIONAL SUMMARY:

• Professional IT Database Developer with over 8 years of experience in the Analysis, Design, Development, Implementation and Testing of applications using Microsoft SQL Server 2008/2008R2/2012 and the Business Intelligence Suite.
• Experience with software development life cycle (SDLC) and Project Management Methodologies in the mortgage industry working for clients including Confidential .
• Extensive experience in using all types of SQL Server Constraints, SQL Server Database design, Database maintenance, developing Transact - SQL queries, Merge using SQL Servers to facilitate efficient data manipulation and data consistency.
• Expertise with T-SQL development skills including Stored Procedures, Indexes, Views, User Defined Functions.
• Experienced in creating SSIS Packages using Lookup, Derived Columns, Conditional Split, Sort, merge Join, Union All, extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc.
• Flexible, enthusiastic and project oriented team player with solid communication and leadership skills to develop creative solution for challenging client needs.
• Experienced in Object Oriented Analysis and Design using UML Methodology.
• Experienced in SW development models like Extreme Programming, Agile, Scrum.
• Good leadership, inter-personal, problem solving, and communication skills
• Experienced in Windows, Apple Macintosh and Unix OS
• Highly experienced with SQL Server 2000 & 2005, MySQL, MS-Access databases.
• Experienced in using various GOF Patterns.
• Experienced in developing technical documentation in various stages of Software Development Life Cycle(SDLC).
• Highly experienced in Leading development teams.

TECHNICAL SKILLS:

Langauges: PL/SQL, SQL, TSQL, Java, Java Developer, Oracle Express / Forms / Reports / Workflow, VB, VB.Net, C, XML, HTML

Web Technologies: ASP.NET, WinForms, WebForms, ASP, VBScript, JavaScript, HTML, DHTML, COM, IIS, UML, XML, XSLT and Java, ADO.NET, ASP.NET.

GUI: Visual Basic, Visual C++, eVC++, MFC, .NET.

Application/Web Servers: IIS Web Server, IIS Server, Wamp Server, Ms Office, MS project, MS Outlook, Microsoft Visio and Enterprise Architect, Oracle SQL develope

RDBMS: Oracle 9i, 10g, 11g, MS SQL, MS Access, IBM DB2

XML & Web related: XML, XSLT, XPath, XQuery, WSDL, XSD, JSON

Operating System: UNIX, Linux, Windows 9x/NT/XP/2000/Vista, OS/2, DOS

Tools: ERWIN, Tool for Application Developer (TOAD), SQL Navigator/Developer, Oracle Developer Suite/Designer/Warehouse BuilderMS Visio/Visual Studio/Office, Rational Clear Case/Quest

PROFESSIONAL EXPERIENCE:

Confidentia, lRichland Hills, TX

Sr. MS SQL Server BI Developer (SSIS/SSRS)

Responsibilities:

• The aim of project was to integrate data from different sources and build a central data repository for reporting, analysis and many other internal operational purposes.
• Actively involved and supported requirements gathering, understating them and create appropriate solutions to meet the business needs.
• Created Packages for Transaction processing using containers as For-Each Loop, Sequence & controlling flow of data using Components like Script Task, Data Flow, File System, and Execute Package.
• Used Event Handlers to debug packages and capture errors and report them to responsible departments.
• Developed SSIS packages for developing a fully-fledged data warehouse solution and deployed them.
• Created jobs to run the deployed packages as per requested schedule.
• Designed the product after analyzing the requirements.
• Gained performance improvement by direct execution of packages on server.
• Experience in creating Drill Through, Drill Down, Tabular & matrix reports.
• Created Ad-hoc Reports directly from Staging and Operational Data Storages for quick test and quality of data.
• Designed, developed and deployed reports in MS SQL Server environment using SSRS.
• Created Filtered reports using report parameters, stored procedures & cascading parameters.
• Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors.
• Wrote User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updating to improve the query performance
• Developed functional and design specifications
• Involved in Database design using SQL 2005 and wrote Stored procedures, triggers etc.
• Actively Involved Business in decision-making process ensuring quality Deliverables. analyze d the functional requirements for gaps, high level and low level designs, develop ed interfaces, unit testing of interfaces, support ed integration testing.
• Documented Technical artifacts
• Developed test plans and participated in code testing to ensure workability, completeness and quality
• Active Code review participation.
• Submitted estimates relating to project planning and technical issues for proper direction.
• Responded to project issues and concerns with logical and immediate action .
• Excellent experience in Requirement elicitation and analysis
• Prepared user guide, operating instructions and other documents required by users and the computer operation staff
• Developing enhancement, modification or customization as required for in house developed software
• Designed and implemented database in SQL(2005,2008,2012)/Oracle9g/11g and wrote complex queries, stored procedures, Triggers etc.
• SQL server. For display and reports used windows forms and Excel reports developed in C#

Technology & Tools: SQL Server 2008R2/2012, SQL BI Suite (SQL Server Integration Services, SQL Server Reporting Services), TFS, SharePoint, MS Access 2007, Excel 2007, XML, .NET Framework 2.0 & 3.0, Rational Rose, VSS, SVN, SQL Server 2005, XML, Python, WPF, Agile Development, . .NET Framework 2.0 & 3.0, ADO.NET, Extreme Programming, C, C++, VC++, C#, Purify, NUnit, CPPUnit, SQL 2000

Confidential, Cincinnati, OH

Sr. SQL Database Developer

Responsibilities:

• Used the SSIS to migrate Databases such as Oracle and Access database, flat files to centralized IT destination.
• Responsible for Developing, Monitoring and Deploying SSIS packages.
• Successfully created dynamic configuration packages in SSIS.
• Used Event Handlers for Exception Handling in SSIS packages. Generated reports on wealth information, account information, research reports using ad-hoc reporting to be used by the clients and advisors.
• Used Team Foundation Server (TFS) for central repository as a versioning control.
• Defined scope, time and cost of the project
• Based on the statistical analysis of the data using SQL Server Reporting Services (SSRS).
• Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors.
• Created User Defined Functions, Triggers to store data into appropriate tables. Conducted performance tuning by using SQL Profiler and index tuning wizard.
• Developed contextual diagram to depict the various integration with other several systems
• Developed Test script and Perform unit and integration test
• Worked as designer and senior programmer and analyzed user specifications for workability, completeness and business flow
• Participated in defining System Design, Architecture and Specifications and performed project and task estimation
• Designed databases and wrote Queries, Stored Procedures in SQL 2000.
• Performed Coding/Programming tasks to specification and in accordance with Development standards
• Documented and coding Technical artifacts and developed test plans
• Performed unit testing using NUnit and did code review

Technology & Tools: MS SQL Server 2008, SSIS, SSRS, T-SQL, Visual Studio 2008, MS Office, SQL Profiler, C#, ASP, ASP.NET, VB.NET, Rational Rose, VSS, SQL server 2000, IIS, XML. .NET Framework 2.0 & 3.0, ADO.NET, Extreme Programming

Confidential, Atlanta, GA

Sr. SQL Developer/Data Analyst

Responsibilities:

• Implementation of MS SQL Server 2008 Management studio to create Complex Stored Procedures, User Defined Functions (UDFs) Views using T-SQL to evaluate result for the reports.
• Responsible for installation and Configuration of SQL Server 2005 and 2008database and configuration of Report manager. Responsible for performing T-SQL tuning, multi-tasking and optimizing queries for reports that take longer time in execution with SQL Server 2008.
• Created Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load. Created SSIS Reusable Packages to extract data from Multi formatted Flat files, Excel, XML.
• Developed, deployed, and monitored SSIS Packages.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source, Excel Spreadsheet to SQL Server 2008.
• Performed operations like Data reconciliation, validation and error handling after Extracting data into SQL Server.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Text format data) to SQL Server. Performed data quality check after the data was extracted from different sources and validated it.
• Performed data analysis for reporting and management purposes.
• Enhance and Support existing applications.

Technology & Tools Used: SQL Server 2008, SQL BI Suite 2008 (SQL Server Integration Services, SQL Server Reporting Services), Windows Server, C, C++, VC++, C#, XML, Rational Rose, Clearcase, Purify,XML, .NET Framework 1.1, 2.0, NUnit, CPPUnit, SQL 2000.

Confidential

Sr. Data Consultant

Responsibilities:

• Worked with senior data developer and created Access tables defining data types and formats.
• Created relationship among the tables to enforce referential integrity.
• Created reports in Access and Excel for analysis purpose.
• Managed to export Excel Datasets into Access.
• Created SQL queries and Developed Access Database.
• Created database objects in Management Studio and Imported Access data into SQL databases
• Utilized Access & Excel applications for reporting.
• Ensured information accessibility by providing appropriate input for documentation.
• Increased effectiveness and efficiency in collaboration with management.
• Identified upgrades and new functionality for development.
• Wrote Queries in Sybase.
• Involved in code review
• Did unit testing and system testing
• Participated in CMMI related activities.
• Wrote Queries and Stored Procedures in SQL 2000
• Did Unit testing using CPP Unit

Technology & Tools Used: MCTS: Microsoft SQL Server 2008, Business Intelligence Development and Maintenance, C#, ASP, ASP.NET, VB.NET, Rational Rose, VSS, SQL server 2000, IIS, XML. .NET Framework 2.0 & 3.0, ADO.NET, Extreme Programming, C, C++, VC++, C#, XML, Rational Rose, Clearcase, Purify,XML, .NET Framework 1.1, 2.0, NUnit, CPPUnit, SQL 2000

Confidential

Data Consultant

Responsibilities:

• Extracted data from various sources like SQL Server 2005, Excel and Text file from Client server and through FTP.
• Involved in creation/review of functional requirement specifications and supporting documents for business systems, experience in data base design
• Process and data modeling process. Created Transformations and Mapping using Data Flow Tasks.
• Created Event Handlers for the package Using Event Handler Tab.
• Handled Performance Tuning and Optimization on SSIS, with Strong analytical and Troubleshooting skills for quick issue resolution.
• The package created included a variety of transformations, for example Slowly Changing Dimensions, Look up, Aggregate, Derived Column, Conditional Split, Fuzzy look up, Multicast, and Data Conversion.
• Involved in Package Deployment by using Deployment Manifest File.
• Studied existing OLAP system(s) and created facts, dimensions and star schema representation for the data mart and where house systems.
• Having good knowledge over creation of cubes.
• Involved to planning and designing SSAS building attribute relationships for optimal MDX query performance of Hierarchies and fact Dimensions.
• Generate the different types of reports as per the Client Requirements.
• Rendering Reports in the form of PDF, Excel, CSV and Word Formats.
• Involved in Technical decisions for Business requirement, Interaction with Business Analysts, Client Team, and Development Team.

Technology & Tools Used: SQL Server 2005/2008 R2, DTS, SSIS, SSAS, SSRS, SQL Server Agent-SQL.