SUMMARY

• Over 7 years of IT experience in Data Design and Development onMicrosoft SQL Server 2008/2005/2000, T - SQL, Performance Tuning, Troubleshooting,SSIS/DTSPackage Configuration, SSRSand Data-warehousing.
• Experience in using Business Intelligence tools(SSIS,SSRS) in MS SQL Server 2008
• Extensive experience with T-SQL in constructingTriggers,Tables, implementingstored Procedures, Functions, Views, User Profiles, Data Dictionaries and Data Integrity.
• Extensive knowledge ofNormalizationandRelational Database Management Systems.
• Hands on experience on various SQL Server Services like Integration Services (SSIS) and Reporting Services (SSRS).
• Hands on Experience in Installing, Configuring, Managing, monitoring and troubleshootingSQL Server2008/2005/2000.
• Great ability to create and manage various database objects like tables, views.
• Excellent T-SQL development skills to write complex queries involving multiple tables, great ability to develop and maintain stored procedures, triggers, user defined functions.
• Experience inPerformance Tuning and Query Optimization.
• Experienced in using ETL tools in (SSIS) MS SQL 2008,MS SQL 2005 and DTS in MS SQL 2000.
• Data Loading Experience inSQL Server 2008using SSIS ETL and Experience in developing packages in SSIS and DTS according to task.
• Data analysisanddata migrationby transferring them using SSIS packages.
• Expert in creating simple and parameterized reports and also complex reports involving Sub Reports, Matrix/Tabular Reports, Charts and Graphs usingSSRSinBusiness intelligence development studio (BIDS).
• Hands on experience in creating reports usingCrystalReports.
• Extensive knowledge inmaintenance and optimizationof Database and Server using various SQL tools (SQL Profiler, Indexes, Statistics, File Groups, DBCC).
• Experience in writing expressions in SSRS and Expert in fine tuning the reports. Created many Drill through and Drill Down reports usingSSRS.
• Experience in optimization tools such asIndex tuning wizard, SQL ProfilerandWindows Performance Monitorfor monitoring and tuning MS SQL Server performance.
• Capable of forming and maintainingpositive and productive working relationshipsin internal/external and team environments.

PROFESSIONAL EXPERIENCE

Technical Skills: Microsoft SQL Server 2005/2008/2008-R2, SQL Server Management Studio (SSMS), SQL Server Business Intelligence Development Studio(BIDS), SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), MySQL, MS-Access, MS-Excel, SQL, T-SQL, HTML, DHTML, ASP, ASP.NET, VB, VB.NET, XML, Visual Studio 2005/2008, Crystal Reports, SQL Profiler, MS Visio.

PROFESSIONAL EXPERIENCE

Confidential, Scranton, PA

BI Developer (SSRS/SSIS)

Responsibilities:

• Created SQL Server Reports usingSSRS 2005.Identified the data source and defined them to build the data source views.
• As a member of BI/Database team, involved in Requirement gathering, Technical Design, Development, Testing and Implementation of BI Analytics needs.
• Supported Users for various Reporting and Analytics requirements across multiple Business Units and departments.
• Involved in the analysis and profiling of source data, creating prototypes and sample reports to help with requirements and design.
• Used SSIS to unite data from existing system and performed transformations on MS SQL 2005.
• Extract Transform Load (ETL) development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
• Experience in creating complexSSIS packagesusing proper control and data flow elements with error handling.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Performed Documentation for all kinds of reports and DTS and SSIS packages.
• Used various ETL tools like SSIS/DTS for data flow from source files like XML, Excel, Tables, and Views to other databases or files with proper mapping.
• UsedDDLandDMLfor writing triggers, stored proceduresto check the data entry and payment verification.
• UsedLookup Transformationto get the data from reference data sets
• MigratingSQL Server 2000 databases into SQL Server 2005.
• Conducted Data Analysis and did Data Modeling and Created the ER diagrams usingLogical Schema andStar Schema.
• Generated ad-hoc reports using MS-Excel andCrystal Reports.
• Created reports in SSRS with different type of properties likechart controls, filters, Interactive Sorting, SQL parametersetc.

Environment:SQL Server 2005/2008, SSIS, VBScript, XHTML, XML, MS SQL Query Analyzer, SQL Profiler, SQL Crystal Reports, MS SQL Server Integration Services(SSIS), MS SQL Server Reporting Services(SSRS), MS SQL Server Analysis Services(SSAS).

Confidential, NY

SQL Server SSIS SSRS Developer

Responsibilities:

• Involved in Migration ofSSRS 2005 to SSRS 2008.
• Created Triggers, Views for Audit and security purposes.
• Created different types of User-defined functions.
• Used Package Configurations to make use of same SSIS package in Dev/Testing/Prod Environments.
• Created basic reports using Crystal Report Writer.
• Responsible for analyzing and fine-tuning slow running queries and stored procedures.
• IntegratedSQL Server 2008reporting serviceswith MOSS (Microsoft Office Share Point Server) to automatically deliver reports to theShare Pointportal
• Created mapping tables to find out the missing attributes for theETL process.
• Used the row count transformation and event handlers control flow to populate the special Log tables withhigh level SSIS packageexecution results
• Creating source and target table definitions usingSSIS. Source data was extracted from Flat files, SQL Server and DB2 Database
• Extract Transform Load (ETL)development using SQL Server 2005, SQL 2008 Integration Services (SSIS).
• Created SQL Jobs to scheduleSSIS Packages
• Worked with various tasks of SSIS include Transform Data Task, Execute SQL Task, Active Script Task etc.
• Configured and deployed SSRS reports to Share point
• Configured Active/Active and Active/Passive clustering for failover
• Scheduled the SSIS packages to run at different intervals to load the data.
• Useddata profiling task in SSIS 2008to identify poor data and repair it.
• Createdreport snapshotsto improve the performance ofSSRS.
• Improved the accuracy of the source data by implementing data validation on the source Data for reporting
• Created subscriptions in SSRS to deliver reports to a shared file.
• Implemented logical and physical modeling usingERWIN data modeler
• Experience in creating Tablix Reports, Matrix Reports, Parameterized Reports, Sub
• Reports usingSQL Server Reporting Services 2008
• Applied conditional formatting inSSRSto highlight key areas in the report data.
• Involved in migration of crystal reports to SSRS 2008.
• Hands on experience in using different transformations like fuzzy lookup, derived column
• Created Complex reports using IREPORTS tool.
• UsedSub Reports, Graphing, Data Drill-Down, and Data sorting/grouping and created various dynamic reports using SSRS.
• Designed reports and tuned them for optimal performance when using multiple Parameters
• Used Report Manager to assign roles, permissions and to create report schedules.

Environment:SQL Server 2005/2008, Microsoft SharePoint Server (MOSS), T-SQL, SQL Crystal Reports, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, ETL, MDX, Erwin, SQL Profiler, MS Excel 2003, MS Visio, Visual Studio 2008-2005, .Net

Confidential, El Segundo, CA

SQL Server (SSIS, SSRS) Developer

Responsibilities:

• Responsible for building and supporting Patient Access applications such as: Patient Registration, Payer Contracting, and Insurance Verification.
• Designing Logical and Physical Data Model with Erwin tools.
• Worked with installing, designing and managing MS SQL Server 2008.
• Creating and managing schema objects such as tables, views, indexes, stored procedures, and triggers & maintaining Referential Integrity.
• Created SSIS packages to populate data from various data sources.
• Created packages using SSIS for data extraction from Flat Files, Excel Files, and OLEDB to SQL Server.
• Developed tabular reports, ad-hoc reports using SSRS Report Designer.
• Running DBCC consistency checks and fixing data corruption in application databases.
• Configured SSIS packages using Package configuration wizard to allow packages run on different environments.
• Worked with Meta-Data Driven SSIS Packages to pull the data from different Sources and load to Data mart.
• Migrated SSIS Packages from SQL Server 2005 to SQL Server 2008.
• Developed complex SSRS reports using multiple data providers, Global Variables, Expressions, user defined objects, aggregate aware objects, charts, and synchronized queries.
• Deployed reports, created report schedules and subscriptions. Managing and securing reports using SSRS.
• Built ad-hoc reports using SQL Server Reporting Services (SSRS).
• Work with project teams for upgrading SQL Server 2005 to SQL Server 2008.
• Involved in fine Tuning and Performance and Query optimization of the Database as required by the application.
• Conducted data import and export operations using the DTS wizard.

Environment:MS SQL Server2005/2008, Team Foundation Server, Microsoft SharePoint Server(MOSS 2007), Crystal Reports, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, Visual Studio 2005, Windows XP, T-SQL, VB.Net

Confidential

SQL Developer

Responsibilities:

• Interacted with the users for understanding and gatheringbusiness requirements.
• Involved in theanalysis, design, development, testing, deploymentanduser training of Analytical and transactional reporting system
• Used stored procedures, wrote new stored procedures, modified existing ones, and tuned them such that theyperform well.
• Used advanced features ofT-SQLin order to design and tune T-SQL to interface with the Database and other applications in the most efficient manner and createdstored Proceduresfor the business logic using T-SQL.
• Usedindexestoenhance the performanceof individual queries and enhance the Stored Procedures.
• Managed all indexing, debugging, optimization and performance tuning usingSQL ProfileandSQL Server Agent.
• Designed, developed, and tested stored procedures, views andcomplex queriesfor Reports distribution.
• Developeddatabase triggersand stored procedures using T-SQL cursors and tables.
• Effectively usedviewsto prevent unauthorized access.
• Tuned SQL queries usingexecution plansfor better performance.
• Optimizedby assigning relative weights to the tables in the Catalog and Query Performance.
• CreatedDTS packagesfor transforming data from various data sources.
• Discussed business requirements and mapped business needs.
• Used Query forad hoc ReportsandUsers design Custom Queries.
• Developed variousCharts and Graphslike bar charts, line charts, pie charts etc. by using Chart expert

Environment: MS SQL Server 7.0/2000, Windows 2000/NT/XP, DTS, Query Analyzer, SQL Profiler and Enterprise Manager