SUMMARY

• Around 8 years IT experience with more than 6 years in SQL Server Development, in a Test, Pre - Production and Production Environments.
• Domain knowledge in Mortgage, Banking, Taxation and Advisory Service industries.
• Working experience in Extracting and Transforming data (ETL) from various heterogeneous sources and creating packages using SSIS.
• Hands on experience with performing various SSIS data transformation tasks like Derived Column, Data conversion, Merge, Bulk Insert, Data Mining, Look-ups, Fuzzy Look-ups, OLEDB Command and Conditional Splits.
• Experience in creating SSIS Packages for integrating data using OLE DB connection from heterogeneous sources (Excel, CSV, Oracle, flat file, Text Format Data) by using multiple transformations provided by SSIS such as Data Conversion, Conditional Split, Bulk Insert, merge and union all.
• Sound knowledge and experience in Error handling of SSIS packages using transactions, check points (package restart ability features), break points and Error logging procedures.
• Experience in conversion of packages from legacy systems (DTS SSIS) and migrating, deploying the packages across Dev./UAT/Prod environments.
• Created various SSRS Reports involving variety of features like Reports, Charts, Filters, Sub-Reports, Drill Down, Drill-Through and Multi-valued parameters, Ad-hoc reports.
• Assigned item level permissions and site security roles, created report schedules and subscriptions.
• Experience in Excel data analysis to provide Data cleansing support and validation of data for use in presentations, Metrics and reports of information.
• Experienced in logical and physical data modeling, forward and Reverse engineering using ERwin, Normalization, de-normalization and building Referential Integrity Constraints.
• Experience in creating databases, transactions, tables, indexes, constraints, writing and debugging stored procedures, triggers, views, functions and cursors using SSMS & SQLCMD in Microsoft SQL Server 2008R 2/2008/2005.
• Experience in creating User Defined Functions (UDF).
• Working experience in Relational Database Management systems (RDBMS), Star Schema, Snowflake schema in Multidimensional Data Modeling.
• Hands on experience in Performance Tuning, Query Optimization, Client/Server Connectivity.
• Experience in working with Windows 2000 Advance Server and Windows NT Server - Installation and Administration.
• Involved in Change Control Process (CCP) from time-to-time where requirements change frequently by focusing on high priority issues first.
• Working knowledge of the flow of process through the Software Development Life Cycle (SDLC) from inception to implementation using AGILE methodology and knowledge of RUP and Waterfall methodologies.
• Knowledge of Business Process Flow Charts (BPMN), Use Case Diagrams and Activity diagrams using MS Visio.
• Coordinated with SMEs to document and add relevant Enterprise Content (ECM) to the intranet knowledge portal (MS SharePoint based), after necessary approvals.
• Experience working with Microsoft Team Foundation Server.
• Working experience in MS Excel, PowerPoint, Word, Outlook and knowledge of MS Project.
• Excellent oral, written (email) communication, interpretation and problem solving skills.
• Known to be a good team player and effectively delegated tasks to achieve operational efficiency.
• Exhibited good time-management skills and managed schedules while working with multiple teams.

TECHNICAL SKILLS

SDLC Methodologies: Agile Scrum, Waterfall

Modeling Techniques/Tools: Flow Charts, BPMN, Activity Diagrams, Use case diagrams, Data Modeling, ER Diagrams; MS Visio, Rational Rose

Languages: TSQL,UML, C#, .NET

MS Office Suite: Word, Excel, PowerPoint, Access, Outlook, Project

Defect Tracking: Redmine, JIRA

Testing: HP Quality Center

Reporting Tools: SQL Server Reporting Services (SSRS), MS Excel, MS Access, Team Foundation Server (TFS)

Project Management/Others: MS Visual Studio, MS Project, MS SharePoint, Snipping Tool, WebXtender DMS

ETL: SQL Server Integration Services (SSIS), DTS 2000

RDBMS: MS Access, SQL server 2000/2005/2008/2012 , MS Visual Studio 2008/2010, SQL Server Profiler.

PROFESSIONAL EXPERIENCE

Confidential, Santa Fe, NM

SSIS Developer

Responsibilities:

• Involved in Data Source layer, data transformation layer, data storage and retrieval layer, analytical layer and presentation layer of business intelligence solution.
• Worked on Data cleansing Techniques, Excel Pivot tables, Formulas and Charts.
• Proven background translating cell formulas in Excel into VBA code using Excel code and also design, analyze and deploy a program.
• Used Linked servers to connect to remote OLEDB source and joined the data present in OLEDB source with local data (referred the OLEDB source more than once)
• Used Open Row Set function for one time access of the other OLEDB source data.
• Used data from sources like MS SQL Server, Oracle, Text files and MS Access to extract, transform and load into a Data Warehouse.
• Involved in the design of Star and Snow flake schemas for the DW.
• Handled Inferred and Slowly Changing Dimensions (SDC) while loading Fact and Dimension tables respectively.
• Identified and defined fact and dimension relationships.
• Used SSIS tasks and transformations to accomplish the ETL process.
• Deployed reports on to the Report manager and presented them to the users creating custom VB.Net applications and ASP.Net pages.

Environment: SQL 2008/2012, T-SQL, Query Analyzer, Visual Studio 2010, VB.NET, ASP.NET, SQL Server Profiler, SSMS, BIDS.

Confidential, COLUMBUS, OH

SQL Reporting Developer

Responsibilities:

• Interacted with the client as part of the Requirements engineering team to understand the reporting requirements and finalize the project scope.
• Migrated SQL Server 2000 DTS packages to SQL Server 2005 SSIS by running upgrade advisor tool against DTS packages, troubleshooting issues and converting into SSIS through DTS migration wizard.
• Designing and building data load procedures, using MS SQL Server SSIS
• Extracted data from various sources like DB2, Oracle, Flat files, and XML files and loaded them into Fact and Dimension tables of data warehouse
• Maintain Operators, Categories, Alerts, Notifications, Jobs, Job Steps and Schedules. Monitor connections, locks and performance of SQL server.
• Developed Stored Procedures, Functions and Database Triggers.
• Developed various reports using SQL Server Reporting Services (SSRS) and Landscape reports.
• Developed Complex reports using SSRS and created a tree view application to view the recent reports generated and a scheduler to schedule a selected report to be run on a particular date.
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Created datasets using stored procedures and reports using multi value parameters.
• Created sub reports, bar charts and matrix reports.
• Developing a Report as per user requirement using MS Reporting Services
• Published reports in PDF, Word and Excel formats.

Environment: SQL Server 2000/2005, Windows 2000/2003/2008/2008 R2, C# 3.0, .NET 3.5, Excel, TSQL, MS Visual Studio 2005/2008, SSIS, SSRS.

Confidential

SQL BI Developer

Responsibilities:

• Involved in Performance Tuning, Query Optimization, Client/Server Connectivity, and Database Consistency Checks using DBCC Utilities.
• Involved in Database Normalization, Optimization and Tuning, Data Import/Export, Troubleshooting, Database Objects authorization, DTS, ETL using DTS (SSIS), Objects Creation such as Tables, Views, User created Data Types, Indexes, Stored Procedures, Cursors and Triggers.
• Built various packages in SSIS to load the data and used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Involved in troubleshooting of existing SSIS Packages by reviewing Data Source/Destination Configurations, transformations and data type conversions.
• Worked on designing and building data load procedures, using MS SQL Server SSIS.
• Experience in SQL Server Reporting Services (SSRS).
• Generated reports using SSRS that could be used to send information to diverse group of users.
• Developed ad-hoc reports using Report Builder.
• Developed Report Model so that the end users can create their own reports using Report Builder.
• Developed various kinds of interactive reports like Drill Down reports, Aggregate reports, reports containing parameters and groups. Also, developed Matrix, Chart and Graph reports.
• Published reports in PDF, Excel, CSV formats.
• Scheduled reports to be generated on predetermined time.
• Created and monitored the jobs to perform tasks such as Database cleansing, backups, data loading.

Environment: SQL Server 2005/2008, Windows Server 2003R2/2008/2008R2, .NET, Enterprise Manager, SQL Query Analyzer, SSIS, SSRS.

Confidential

Jr. SQL Developer

Responsibilities:

• Involved in Web Interface Development using HTML, DHTML and ASP.NET.
• Designed DDL and DML for MS SQL Server
• Created and managed schema objects such as Tables, Views, and Indexes.
• Involved in writing SQL batch scripts.
• Created Stored Procedures and functions.
• Created joins and sub-queries for complex queries involving multiple tables.
• Created Triggers to enforce data and referential integrity.
• Created various stored procedures for data manipulation and database triggers.
• Scheduled and maintained routine jobs, tasks and alerts.
• Worked on Application documentation and ER Diagrams.
• Involved in building and deploying applications.
• Involved in Unit testing of the database objects created.

Environment: Windows NT server/2003/2003R2, C# 2.0, .NET 2.0, ASP.NET, SQL Server 2000, Enterprise Manager.