SUMMARY

• 8 years of IT experience in the Analysis, Design, Development, Implementation and Testing Client/Server applications using Microsoft SQL Server 2005/2008/2008 R2/2012 and MicrosoftBusiness Intelligence Suite.
• Extensive experience in T - SQL to write: stored procedures, triggers, functions, tables (including Partitioned Tables), views, indexesand 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, Teradata 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 with 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 the data, Defining Data Source and subtotals for the reports using SSRS 2012/2008R 2/2008/2005.
• Create MDX queries and calculation to support ad-hoc business needs and Strong knowledge of OLAP concepts and multidimensional data.
• Used to have Data Access with the help of Multi-Dimensional Expressions(MDX)
• Experienced in using Data Analysis Expressions (DAX) to creating custom calculations inPowerPivot for Microsoft Excel workbooks and Analysis Services tabular model projects.
• 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 with 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 within 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),Report Builder

Business Intelligence Tools: SQL Server Integration Services (SSIS), Export & Import (DTS), SQL Server Analysis Services (SSAS), SQL Server Reporting Services (SSRS), Data Analysis Expressions (DAX), Multi-Dimensional Expressions(MDX)

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, Waltham, MA

MS SQL SSIS Developer

Responsibilities:

• Proficient in Migrating and building ETL packages using Microsoft SSIS in 2005, 2008, 2008 R2 and 2012.
• Experience with SSIS Integration and in Analyzing data, find problem areas, and providing solutions
• Responsible for gathering and assessing business information needs and preparing system requirements
• Experience extracting data from a large variety of sources, transforming and loading to a SQL Data warehouse.
• Provide production support of existing ETL processes
• Documented steps needed to migrate database objects between various environments including Development, UAT, Staging, and Production
• Used customer requirements to improve functionality (speed, performance / usability).
• Conduct system tests, Unit testing, troubleshoot customer issues andcorrect database defects.
• Respond quickly to bug fixes and enhancement requests and Supported maintenance of local databases
• Participate in special projects as needed and performsother duties as assigned.
• Worked in a team environment and Worked on multiple assignments concurrently underaggressive deadlines
• Enhancing and deploying the SSIS Packages from development server to production server.
• 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.Consult with the business to determine logical design for new business solutions
• Performing code reviews, analyze execution plans, andre-factor inefficient code
• Following data standards, resolve data issues, completeunit testing and system documentation for ETL processes
• Developing error checking and resolution routines
• Collaborate with business analysts, subject matterexperts, and other team members to determine data extraction andtransformation requirements
• Collaborate with IT operations and testing organizations to ensure timely releases of projects and make sure databaseenvironments are sustainable
• Strong business writing and interpersonal skills necessary for customer contract.

Environment: MS SQL Server, T-SQL, SQL Server Management Studio, Visual Studio, Crystal Reports, MS SQL Reporting Service (SSRS), MS SQL Integration Service (SSIS), MS ExcelT-SQL, MS Access.

Confidential -Reston, VA

MS SQL SSIS/SSRS Developer

Responsibilities:

• Designed, Developed and Deployed reports in MSSQL Serverenvironment using SSRS
• Created Parameterized, Drill down and Drill through reports, cross tab reports, Sub Reports, Summary Reports and charts using variables and expressions.
• 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.
• Enabled Check points in SSIS package. Created break points in order to view the status of data, variables and over all status of SSIS package.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Collaborate with IT operations to perform root causeanalysis
• Developed and Deployed different types of Reports like List, Matrix, and Chart and Sub Reports etc.
• 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 the whole SSIS process workflow.
• Developed Windows form application using C#.Net and SQL Server to extract the patient demographics.
• Working experience on Medicare/Medicaid/QNXT environment.
• Developed programs using C#.Net, Business Objects and Entity spaces according to the business logic provided by the clients.
• Involved in discussions with the clients to understand the project requirements.
• Involved in complete Software development life cycle (SDLC) of the 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, Kansas City, MO

MS SQL Server Database Developer

Responsibilities:

• Work closely with 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) with Report authoring, Report management, Report delivery and Report security.
• Created Parameterized, Drill down and Drill through reports, cross tab reports, Sub Reports, Summary Reports and charts using variables and expressions.
• 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 the 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 the Business requirements.
• Configured with checkpoints, package logging, error logging and event handling to redirect error rows and fix the errors in SSIS
• Developed custom components in SSIS Using C#.
• Worked with 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 the 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 the 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.
• Created MDX Queries and used calculation to support ad-hoc business needs and strong knowledge of OLAP concepts and multidimensional data.
• 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, Multi-Dimensional Expressions(MDX),MS Visual Studio.Net, C#, VB, Microsoft Visio, SQL Profiler, Enterprise Manager, Windows 2008 Server OS.

Confidential, Pittsburgh, PA

MS SQL Server SSIS/SSRS/BI Developer

Responsibilities:

• Involved in all the phases of Software Development Life Cycle.
• 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.
• Experienced in using Data Analysis Expressions (DAX) to creating custom calculations inPowerPivot for Microsoft Excel workbooks and Analysis Services tabular model projects.
• Used DDL and DML Triggers, Stored procedures to check the 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.
• Experienced in using Data Analysis Expressions (DAX) to creating custom calculations inPowerPivot for Microsoft Excel workbooks and Analysis Services tabular model projects.
• Created SSIS Package configurations for executing in different environments.
• Enabled Check points in SSIS package. Created break points in order to view the status of data, variables and over all status of SSIS package.
• Extensively involved in designing the SSIS packages to export data of flat file source to SQL Server database.
• Enhancing and deploying the 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 with 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 with an ability to drill down into details.

Environment: .NET 3.0, MS SQL Server 2005, SSIS, SSRS, Data Analysis Expressions (DAX) T-SQL,Visual Studio 2005, MS Office 2003, SQL Profiler, Windows 2003/2008.

Confidential, Pittsburgh, PA

MS SQL Server SSIS/SSRS/BI Developer

Responsibilities:

• Responsible for Requirements gathering for Solution design.
• Involved in the 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 the 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.
• Involved in merging existing databases and designed new data models to meet the requirements.
• Performed daily database backup & restoration and monitor the 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 the purpose of application development.
• Responsible for the designing the advance SQL queries, procedure, cursor, triggers, scripts.
• Collaborated with the application developers in data modeling and E-R design of the systems.
• Also created, modified, maintained and optimized SQL server database.
• Maintained the documents and create reports for the business analysts and end-users.
• Responsible for the management of the 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.