SUMMARY

• 8 years of IT experience in teh Analysis, Design, Development, Implementation and Testing Client/Server applications using Microsoft SQL Server 2005/2008/2008 R2/2012 and Business Intelligence Suite.
• Extensive experience in T - SQL to write: stored procedures, triggers, functions, tables (including Partitioned Tables), views, indexes and relational database models.
• Experience developing and monitoring ETL Packages and DTS packages using SQL server Integration Services (SSIS), developing reporting solutions using SQL Reporting Services (SSRS), creating cubes for analysis using SQL server Analysis Services (SSAS).
• Created SSIS packages to perform Extract, Transform and Load data from various heterogeneous sources and destinations like Excel, Access, CSV, SharePoint, Oracle, Tera data and flat files using tasks and transformations provided by SSIS.
• Expertise in extracting, transforming and loading (ETL) of data using SSIS/DTS Packages and BCP Utility for importing and exporting data wif format files.
• Hands on experience in creating OLAP cubes and developing complex calculations, Aggregations, implementing dynamic security model using MDX functions in SSAS.
• Extensive experience in data migration between homogeneous & heterogeneous systems using various tools (Bulk Insert, BCP, DTS and SSIS).
• Experienced in writing Parameterized Queries for generating Tabular reports, Formatting report layout, Sub reports using Global Variables, Expressions, Functions, Sorting teh data, Defining Data Source and subtotals for teh reports using SSRS 2012/2008R 2/2008/2005.
• Created Parameterized, Drill down and Drill through reports, cross tab reports, Sub Reports, Summary Reports and charts using variables and expressions.
• Extensively used performance monitor/SQL profiler to solve dead locks/long running queries.
• Experience in creating Jobs, Alerts, SQL Mail Agent, Database Mail and Scheduled DTS and SSIS Packages based on Business or application needs
• Experience in migration of Data in Excel, Flat file and Teradata to and from MS SQL Server by using SQL Server SSIS
• Good experience using SQL server data tools.
• Thorough understanding of OOPS programming style wif respect to C# language.
• Thorough understanding of each phase of software development life cycle(SDLC)
• Excellent verbal and written skills and ability to document based on target audience (Managerial, functional, technical users)
• Experience and ability to coordinate/Communicate wifin team and outside team based on project requirements

TECHNICAL SKILLS

Languages: T-SQL, C# .Net, C, C++, Java

Databases: MS SQL Server 2012/2008/2005 , PL/SQL, MS Access, MS SQL

SQL Server Tools: SQL Server Management Studio(SSMS), Business Intelligence Development Studio(BIDS)

Business Intelligence Tools: SQL Server Integration Services (SSIS), Export & Import (DTS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS)

Applications: MS Word, Excel, Power Point, Outlook

Web: HTML,XML, ASP.NET, VBScript

IDE’S: SQL Server Management Studio, Eclipse, Net Beans, Visual Studio

Methodology: Agile, Object-Oriented Analysis/Design, UML

PROFESSIONAL EXPERIENCE

Confidential - Reston, VA

Software Developer

Responsibilities:

• Imported and Extracted data from various sources such as flat file, access, SQL server and loaded those data into SQL server to build various reports.
• Developed Complex Queries using different SQL joins and T-SQL Queries.
• Creating Tabular, Matrix reports (also called as crosstab or pivot), Charts and graphs as per customer requirements Using SSRS.
• Used BCP utilities, Data Transformation Services (DTS), Extract Transform Loading tool (SSIS) to populate data from various data sources, created packages for different data loading operations for application.
• Created configuration Tables, Stored Procedure, User Defined Function in SQL Server Management Studio to support teh whole SSIS process workflow.
• Designed, Developed and Deployed reports in MSSQL Serverenvironment using SSRS
• Developed Windows form application using C#.Net and SQL Server to extract teh patient demographics.
• Working experience on Medicare/Medicaid/QNXT environment.
• Developed programs using C#.Net, Business Objects and Entity spaces according to teh business logic provided by teh clients.
• Involved in discussions wif teh clients to understand teh project requirements.
• Involved in complete Software development life cycle (SDLC) of teh project including Analysis, design, develop, deployment, test, implement and production.

Environment: MS SQL Server, T-SQL, SQL Server Management Studio, Visual Studio, Business Objects, Entity Spaces,, MS SQL Reporting Service (SSRS), MS SQL Integration Service (SSIS), MS SQL Analysis Service (SSAS), MS Excel, T-SQL, UNIX, MS Access.

Confidential, Pittsburgh, PA

MS SQL Server Database Developer

Responsibilities:

• Work closely wif application developers in database design.
• Wrote SQL Queries, SQL Stored Procedures, Views, Functions and Cursors as needed.
• Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases, data mart databases.
• Converted ETL from DTS to SSIS.
• Used SSIS packages, DTS, and bulk inserts for importing and exporting of data.
• Performed daily backups and restoring of data whenever necessary.
• Good understanding of Microsoft Reporting Service (SSRS) wif Report authoring, Report management, Report delivery and Report security.
• Performed efficient tuning of SQL source queries for data load/ Usage of stored procedures for performance.

Environment: MS SQL Server 2005/2008, Windows 2003/2008, SSIS, SQL Server, Management Studio, SQL Server Business Intelligence studio, Microsoft Excel and Access.

Confidential, Dover NH

MS SQL Server Database Developer

Responsibilities:

• Worked as part of a team for gathering and analyzing Business Requirements Participated actively in designing teh system database structure.
• Involved in theoptimization of SQL querieswhich resulted in substantial performance improvement
• Write Stored Procedures and triggers as and when needed to convert data logically as per teh business requirements.
• Configured wif checkpoints, package logging, error logging and event handling to redirect error rows and fix teh errors in SSIS
• Developed custom components in SSIS Using C#.
• Worked wif SSIS Execute SQL task, script task, data flow tasks, look up, conditional split, script component, row count, union all, multicast, derived column transformations and written T-SQL and Visual Basic (VB) and ASP.NET scripts.
• Generated Event Detail Report in SSRS 2008 R2 using Global Variables, Expressions and Functions for teh reports.
• Created Cross-Tab, Drill-down and Sub-Report using RDL. Promoted RDLs to Reporting Service Server
• Worked on Report Builder 3.0 to generate canned reports for teh users.
• Designed Action Item Report usingPivot-tables, bar-charts, Line-charts andPie-chartson data from cubes and SQL Server in Excel 2007.
• Generated multiple Enterprise reports using SSRS from SQL Server Database (OLTP) and included various reporting features such as group by, drilldowns, drillthrough, sub-reports, navigation reports (Hyperlink)etc.
• Report parameters includedsingle valued parameters,multi-value parameterswhich also consisted of different parameter types like hidden, internal, default (queried and non-queried parameters).
• Involved in testing ofBusiness Objects Reportsand Fix any ETL issues if exists.

Environment: SQL Server 2005/2008 R2,T-SQL,Analysis Services (SSAS)2008 R2, Reporting Services (SSRS)2008 R2, Report Builder 3.0, Integration Services (SSIS)2008 R2, MS Visual Studio.Net, C#, VB, Microsoft Visio, SQL Profiler, Enterprise Manager, Windows 2008 Server OS.

Confidential, Charlotte, NC

MS SQL Server SSIS/SSRS/BI Developer

Responsibilities:

• Involved in all teh phases of SDLC.
• Filtered bad data from legacy system using complex T-SQL statements, and implemented various types of Constraints and Triggers for Data Consistency.
• Used Stored Procedures for updating Servers.
• Used DDL and DML Triggers, Stored procedures to check teh Data Integrity and verification at early stages before calling them.
• Used SQL Server Integration Services (SSIS) and its tools to Extract, Transform and Load data into Data Ware House.
• Used C# code in Script Task and Script Component.
• Developed, deployed and monitored SSIS Packages. Involved in creating log files for SSIS packages.
• Created SSIS Package configurations for executing in different environments.
• Enabled Check points in SSIS package. Created break points in order to view teh status of data, variables and over all status of SSIS package.
• Extensively involved in designing teh SSIS packages to export data of flat file source to SQL Server database.
• Enhancing and deploying teh SSIS Packages from development server to production server.
• Developed and Deployed different types of Reports like List, Matrix, and Chart and Sub Reports etc.
• Designed and developed parameterized reports, linked reports, matrix and tabular reports wif drill down, drill through and drop down menu option using SSRS.
• Created/ Maintained clustered/ non clustered Indexes for fast and efficient reporting process.
• Used SSRS to create interactive reports wif an ability to drill down into details.

Environment: .NET 3.0, MS SQL Server 2005, SSIS, SSRS, T-SQL,Visual Studio 2005, MS Office 2003, SQL Profiler, Windows 2003/2008.

Confidential, Pittsburgh, PA

MS SQL Server SSIS/SSRS/BI Developer

Responsibilities:

• Requirements gathering - Solution design.
• Involved in teh migration from SQL server .
• Actively involved in Normalization of database.
• Designed DDL and DML for MS SQL Server 2005.
• Created rules, defaults, tables, views, clustered & non-clustered index, user defined data types, and user defined functions.
• Actively designed teh database to fasten certain daily jobs, stored procedures.
• Optimized query performance by creating indexes.
• Involved in writing SQL batch scripts.
• Write T-SQL statements for retrieval of data and Involved in performance tuning of T-SQL.
• Queries and Stored Procedures.
• Involved in merging existing databases and designed new data models to meet teh requirements.
• Performed daily database backup & restoration and monitor teh performance of Database Server.
• Created joins and sub-queries for complex queries involving multiple tables.
• Used DDL and DML for writing triggers, Stored Procedures, and data manipulation.
• Installed and Configure SQL Server 2005 on development server for designing and testing.

Environment: MS SQL server 2008, SSIS, DTS, SSRS, Profiler and Windows Server 2003

Confidential

Junior SQL Developer

Responsibilities:

• Complete analysis, requirement gathering and function design document creation.
• Written various T-SQL Statements for teh purpose of application development.
• Responsible for teh designing teh advance SQL queries, procedure, cursor, triggers, scripts.
• Collaborated wif teh application developers in data modeling and E-R design of teh systems.
• Also created, modified, maintained and optimized SQL server database.
• Maintained teh documents and create reports for teh business analysts and end-users.
• Responsible for teh management of teh database performance, backup, replication, capacity and security.
• Coordinating user acceptance testing amongst business users.
• Developed many T-SQL stored procedures, views, indexed views, UDF for business reporting.

Environment: SQL Server 2000, T-SQL, and Windows XP/2000.