SUMMARY

• Over 11 years of IT experience in Database Development and Business Intelligence Technologies with expertise on ETL process, Reporting and Analyze using MS SQL Server 2008/2005/2000 as a MS SQL Server Developer.
• Experienced in client requirement Analysis, Physical and Logical design and development (using Erwin, normalization, and SQL Server Enterprise manager), Resource Planning, Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications..
• Experience in monitoring SQL Server performance tuning using SQL Profiler (Dead Locks/Long running queries), Query analyzer, Database engine tuning wizard, Index tuning wizard, windows Performance monitor, Client/Server Connectivity, Database Consistency Checks using DBCC Utilities.
• Conducted JAD Sessions prior to specific software development activities to review and document business processes effectively.
• Architect and Designed data warehouses, data marts, and data stores.
• Assist in the delivery of the Organizational Reporting Model.
• Migration of logins, DTS packages into SSIS packages and constructed new SSIS packages to extract, transform and load the data from old data ware house to new data ware house and OLTP and OLAP.
• Extensive experience with Migration of SQL Server 2000 to SQL Server 2005 and SQL Server 2005 to SQL Server 2008.
• Refine the engagement model for requesting and delivering reports and dashboards.
• Expertise in migration of MS SQL 2000 databases to new MS SQL 2005 and MS SQL 2005 to MS SQL 2008.
• Working knowledge on CRM model.
• Work closely with graphic designers to quickly develop feature - rich web applications used by healthcare providers and patients, with a strong focus on usability across the spectrum of end-users.
• Manage and monitor integration database and system performance. That includes optimization and tuning of data loads, extractions, and the recommendation of appropriate changes to ensure and improve system performance and reliability.
• StrongSSISexperience with error handing and package scheduling.
• Involved in all activities related to development, implementation, administration and support of ETL processes for large scale data ware houses using SSIS.
• Involved in Migrating DTS packages to SSIS using Package Migration Wizard.
• Expertise in deploying packages using Deployment Utility, DTUTIL Command Line Tool and SSMS.
• Designed interactive reports and custom built reports in SSRS to provide user interaction.
• Experience with User Acceptance Testing (UAT) and release skill set.
• Experienced in optimizing performance of various long running queries and stored procedures using SQL Profiler, Index Tuning Wizard and Database tuning wizard.

TECHNICAL SKILLS

Databases: MS SQL Server 2008 R 2/2005/2000/7.0/6.5 , MS Access

Database Tools: MS SQL Server 2008 R2/2000/2005, MS-Access, SQL Server Integration Services, Data Transformation Services, SQL Server Analysis Services, TOAD,OLAP (Online Analytical Processing, Multi-dimensional Cubes and Business Intelligence & Development Studio

Development Skills: T-SQL, PL/SQL, SSIS/SSRS/SSAS

Languages: T-SQL, PL/SQL, VB.net, VB Script, SSAS, OLAP, HTML, XML, ASP.NET, Java Script, C, C++ and MDX.

ETL Tools: DTS, SSIS (SQL Server Integration Services), SSRS, SSAS

Reporting Packages: SQL Server Reporting Services, Confidential 6.5/XI, Crystal reports 9/10/11, MS Excel.

Tools: /Methodologies: MS Visio, Erwin, MS Project, SQL Profiler, MS Office, TFS, FTP File Zilla, Snag IT 10, Chilkar Components, Read Gate SQL Bundler, S QL Idear Diagnostic Manager, Ulta Edit

PROFESSIONAL EXPERIENCE

Confidential, Norfolk,VA

Sr. MS SQL Server Developer

Responsibilities:

• Understanding the business requirements and designing applications to meet customer needs.
• Expertise in defining the business process flow and gathering business requirements
• Developed and maintained technical documentation from source to target load process and ETL development process.
• Prepared Mapping Documents for Business rules and validation rules.
• Involved in creating and designing packages using SSIS by using the existing tasks and transformations.
• Experience in Worked on FACETS Data tables and created audit reports using queries. Manually loaded data in FACETS and have good knowledge on FACETS business rules.
• Analyzed the mainframe reports for member/eligibility/claims and mapped the fields with FACETS batch jobs and reports.
• Involved in FACETS Implementation, FACETS Providers, billing, enrollment, and Claim Processing and Subscriber/Membership module.

Environment: SQL Server 2008/2012/2014 , T-SQL,Oracle11g,FACET Application, Facet Reporting Tool, (SSIS) SQL Server Integration Services, (SSRS) SQL Server Reporting Services, TIDAL Job Scheduling, Erwin, SQL Profiler, MS Excel 2003, Visual Studio, C#, ASP.Net, Visual Team Foundation Server.

Confidential, Secaucus,NJ

Sr. MS SQL Server Developer

Responsibilities:

• Engaged in the entire database development process, from inception through delivery.
• Drive the day to day production support of major data repositories, managing the support queue and ensuring SLA's are met
• Worked with stakeholders to define business requirements and drive delivery.
• Design, develop, test and implement SSIS packages related to ETL processes.
• Packaged and support new releases
• Monitor and tune databases and direct work of DBA vendors.
• Data warehouse: Design, build, and implement data warehouse environment.
• Performance Tuning: Review monitoring tools and query execution plans to maintain or increase query efficiency. Also performed root cause analysis on query performance issues.
• Logical database design: Leveraged knowledge of database architecture to develop normalized database solutions.
• Database development: Worked with application developers to deliver data through the design of stored procedures, functions, and views.
• Created and Developed Tables, Views, Triggers, Cursors, Dynamic Stored Procedures, User Defined Functions, T-SQL (DDL, DML) statements and other advanced queries for databases by using SQL Server Management Studio.
• Performed all aspects of verification, validation including Functional testing, Unit Testing, System testing, Regression testing, structural testing, Performance, load and Back-End testing manually.
• Created database queries, indexes, and stored procedures, some with high level complexity
• Designed complex physical and logical data models

Environment: SQL Server 2008/2012, T-SQL, PL/SQL Developer Tools, SSIS 2008/2012, Rally, AppDynamics,TFS,ERWIN

Confidential, Baltimore,MD

Sr. MS SQL Server Developer/DBA

Responsibilities:

• Worked with most FACETS modules & have experienced with FACETS data dictionary
• Worked with FACETS team to modify 5.01 software and database in test and staging environments.
• Worked on creating new users and roles.
• Create and maintain standardized, custom and ad hoc MSSQL and BI reports to support internal and external customer requirements.
• Created maintenance plan for good running database health.
• Work with business users to collect requirements and desired outcomes of analyses and reports.
• Use strong analytical skills to produce intuitive dashboards and visualizations for Marketing to explore
• Troubleshoot dashboard functionality and solves technical and analytical problems.
• Deliver ad hoc analysis using Confidential or SQL to answer timely questions
• Experienced in creating Server/Database level SQL Auditing (DDL trigger) Change Data Capture.
• Extensively worked on T-SQL Performance Tuning (query execution plan) applying 80-20% Rule
• Optimizing and Reviewing T-SQL Changes, SQL code deployment, to & from QA, Test, Staging, Archive, data warehouse & Production servers.
• Designing Relational Database objects (SP, function, view, Trigger, Table, Index, Data Type, etc)
• Developed, deployed and monitored SSIS Packages for new ETL Processes and upgraded the existing DTS packages to SSIS for the on-going ETL Processes.
• Enhancing and deploying the SSIS Packages from development server to production server.
• Monitored performance and optimize SQL queries for maximum efficiency.
• Designed dynamic SSIS Packages to transfer data crossing different platforms, validate data during transferring, and archived data files for different DBMS.

Confidential

Lead MS SQL Server Developer

Responsibilities:

• Worked on Data Transformation Activities using SSIS Import/ Export for transferring data between Oracle to SQL Server.
• Moved Data from flat files and Excel sheets using SSIS.
• Created Test Plan documents which describe the features and functions to be tested.
• Used script task in SSIS to design complex SSIS packages using C#.
• Assisted/groomed team members and provided guidance during ETL Testing.
• Migrated DTS to SSIS packages.
• Mocking test data as per the requirements to satisfy test scenarios and data validations.
• Provide 24 X 7 supports to all production, development, staging and clustered servers.
• Design Test Cases, Test Scripts and responsible for executing the Test Cases, Test Scripts, identify and manage defects, documenting the results.
• Document procedural and instructional collateral for the organization to support the utilization of reports and dashboards.
• Created and Developed Tables, Views, Triggers, Cursors, Dynamic Stored Procedures, User Defined Functions, T-SQL (DDL, DML) statements and other advanced queries for databases by using SQL Server Management Studio.
• Created packages to perform looping through the CSV files, Excel files and sheets in a folder.
• Transferred data to XML format for third party vendors.
• Performed all aspects of verification, validation including Functional testing, Unit Testing, System testing, Regression testing, structural testing, Performance, load and Back-End testing manually.
• Used of Indexes to enhance the performance of individual queries and enhanced the stored procedures.
• Worked extensively in performance tuning data cleanups.
• Handled performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, statement and used the TOP operator to limit the Select Statement in certain Queries.
• Created views to restrict access to data in a table for security.
• Scheduled and monitored the SSIS packages for daily load in SQL Server job Agent.
• Involved in Creating Stored Procedures for reports generation.
• Created T-SQL queries, dynamic Stored Procedures that calculate by taking the customer details as input.

Environment: SQL Server 2008/2005/2000 , Windows 2003/2000 Servers, T-SQL, Oracle PL/SQL, MySQL, Shell Scripting, Oracle 9i, PL/SQL Developer Tool, SSIS.

Confidential, Middletown, NJ

Lead Business Intelligence Developer

Responsibilities:

• Migrated MS SQL 2000 databases to new MS SQL 2005 and MS SQL 2005 to MS SQL 2008.
• Migrated MS SQL 2000 DTS packages to MS SQL 2005 SSIS Packages, MS SQL 2005 to MS SQL 2008 and troubleshooting migration issues and compatibility.
• Designing and managing SQL DTS and SSIS Packages.
• Tested Complex ETL Mappings and Sessions based on business user requirements and business rules to load data from source flat files and RDBMS tables to target tables.
• Perform and assist UAT and Integration testing activities.
• Perform security code reviews and penetration testing.
• Provide application security awareness to the organization through delivery of presentations and intranet content.
• Helping guide security requirements for application features;
• Developing SQL stored procedures, views and triggers
• Created and maintained all MS SQL database alerts using SQL alert.
• Managing SQL databases, security, fine tuning of SQL queries, and troubleshooting.
• Developing SQL stored procedures, views, and triggers.
• Built SSIS packages to migrate data from heterogeneous data sources like Excel, Access, Flat files and Oracle to SQL Server 2005.
• Improved Performance of the database by creating clustered and non-clustered Indexes.
• Created custom C# and VB Scripts to download the file from the WEB, to read data from the .PDF files, to convert .PDF files to .TXT files.
• Designed SSIS packages to load the data from various input source files like .xls, .xlsx, .dat, .txt, .csv and pdf files to the destination.
• Performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created T-SQL queries, dynamic Stored Procedures that calculate by taking the customer details as input.

Environment: MS SQL Server 2008/2005/2000 and Oracle, Shell Scripting, TOAD,TSQL, XML, Microsoft Analysis Services and Reporting Services, SSIS, Visual Studio 2008, Team Foundation Server, SVN, SQL Profiler, Idera.

Confidential, Scranton, PA

Lead MS SQL Server Developer/DBA

Responsibilities:

• Participated in gathering business rules to implement functional and technical specifications.
• Participated in JAD sessions to gather the new requirements for the incoming files specifications.
• Designed multiple database using normalization and de-normalization forms in Erwin and then created database in SQL Server.
• Installed and configured SQL Server and 32 bit) on standalone and Microsoft clustered servers and applied the latest service packs, hot fixes and security patches.
• Carried out day-to-day jobs like performance tuning and troubleshot batch jobs, which were very critical to the firm.
• Worked on different types of data mart in data mining concepts and techniques.
• Worked in developing business intelligence data marts.
• Responsible for identifying KPI’s in SSAS 2005 and constructed cubes based on data volumes mostly adhering to star schema.
• Designed and developed ETL processes using multiple SSIS packages to upload tables from different sources into staging database and then to destination database using different SSIS transformation.
• Designed SSIS packages to load the data from various input source files like .xls, .xlsx, .dat, .txt, .csv and .pdf files to the destination.
• Implemented custom C# scripts to download files from the FTP client, to find the latest file, to rename the files, to read data from the file, to delete a file and to archive the files.
• Added custom rows using script component transformation in the data flow task.
• Created packages to perform looping through the CSV files, Excel files and sheets in a folder.
• Emailed error log files and work log notification to individual users as attachments depending on requirement.
• Designed SSIS packages to extract the Emails from the Outlook Server and save in a local folder.
• Built C# scripts to download the Email from the Outlook, flipped the attachments and body into separate folders and dynamically called child packages to load the data from the attachment.
• SSIS packages to unzip the files using both Chilkat components and Script task utilities.
• Worked with chilkat ZIP, MAIL, IMAP components to unzip .ZIP files, sent emails, and extracted emails from the IMAP server besides exchange server to Outlook.
• Migrated and re-designed SQL server 2005 packages to SQL server 2008 packages depending upon requirement.
• Scheduled packages in CISCO TIDAL Enterprise Scheduler.
• Created stored procedure to validate the incoming input file data from the various vendors before loading destination.
• Responsible for the definition,documentationand execution of one or more small-scale projects, actively participated in all phases of the project.
• Created various reports such as complex drill down and drill through reports, matrix reports, sub reports and charts using SQL Server Reporting Services (SSRS) based on Relational and OLAP databases.
• Designed complex reports like reports using cascading parameters, Drill-Through Reports, Parameterized Reports and Report Models and ad-hoc reports using SQL Server Reporting Services (SSRS) based on client requirement.
• Scheduled reports for daily, weekly, monthly, and annually based on business requirement.
• Extensively incorporated testing strategies before promoting new applications.
• Executed UAT scripts to gather sign off on financial applications to meet Business.
• Extensively used triggers to implement business logic and for auditing changes to critical tables in the database.
• Used of Indexes to enhance the performance of individual queries and enhanced the stored procedures.
• Worked extensively in performance tuning data cleanups.
• Handled performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Environment: MS SQL Server 2008, SSIS, SSRS, SSAS, T-SQL, Visual Studio 2008, Shell Scripting,Team Foundation Server, MS Office, VB.NET, C#.NET, Outlook 2007, SAAS, DTS Exchange, XML, TOAD, SQL Profiler, Transactional Replication, Failover Clustering, SQL Lite Speed V4.8,SQL Profiler, Idera, Excel, Access, IMAP,MAPI outlook server.

Confidential, NJ

Sr SQL Server Developer/DBA

Responsibilities:

• Developed T-SQL Scripts with Indexing, Rank, Joins and Common table expressions (CTE).
• Created User Defined Functions, Indexes to generate the distinct data based on the type of input supplied.
• Created Fail-over Cluster (Active/Active, Active/Passive) environments, depending on the application and business requirements.
• Performance tuning in Database level, T-SQL level, Operating System Level, and Hardware level.
• Analyzed the load on the system, based on that laid out disks memory, processors for Production, UAT and Development servers.
• Implemented SQL coding standards in writing Stored Procedures, Triggers, Views, SQL functions and locking issues.
• Periodically checked all databases with DBCC commands for maintaining data consistency and integrity and was responsible for keeping system and databases up-to-date by making necessary changes.
• Built SSIS packages to migrate data from heterogeneous data sources like Excel, Access, Flat files, and Oracle to SQL Server 2005.
• Designed stored procedures to overcome transformation conflicts while extracting data from source system.
• Analyzed available documentation and existing data marts to leverage and reuse implemented components.
• Was responsible for the analysis, design, and delivery of financial data marts.
• Created C# scripts to extract the date part from the file name and load to the table.
• Implemented FTP task to download and uploads data files from an FTP server to local server.
• Built C# scripts to unzip the Zip files and RAR files in the forecast folder before loading data.
• Wrote MDX Queries for querying data from a Multidimensional Warehouse.
• Ensured data changes in the source system by using Slowly Changing Dimension Transformation.
• Configured Send Mail Task to send the mails upon successful deployment of package using STMP.
• Deployed and scheduled packages using SQL Server Agent Job in Management Studio.
• Used VB code and Batch Script for maintenance of reports.
• Used Script Task as a performance counter in packages.
• Performed package configuration to maintain environmental variables for packages.
• Used Analyzing Services to build the data cubes using SSAS.
• Developed MDX Scripts to create datasets to perform reporting and included interactive drill down reports, report models and ad-hoc reports.
• Improved Performance of the database by creating clustered and non-clustered Indexes.
• Handled performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.

Environment: MS SQL Server 2005, SSIS, SSRS, SSAS, T-SQL, MS Office, VB.NET, C#.NET, Outlook Soft 4.2, Visual Studio 2005, SQL Profiler, Excel, Access, Share Point Server 2007.

Confidential, CA

MS SQL Server Developer

Responsibilities:

• Extensive T-SQL Development on SQL Server 2005 for evolving business requirements, enhancement to existing procedures.
• Wrote T-SQL code for creating cursor and handling the data validations.
• Designed and implemented stored procedures and triggers for automating tasks.
• Migrated databases from SQL Server 2000 to SQL Server 2005.
• Designed Star schema (identification of facts, measures and dimensions) and Snowflake schema.
• Created SSIS package to load data from Flat File, Excel and OLEDB to SQL Server 2008 using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used custom .NET assemblies for Script Task in SSIS.
• Deployed and scheduled the packages using SQL Server Agent Job.
• Participated in requirement gathering of the cube design using SSAS.
• Creating complex cubes for seeing business data from different perspectives by slicing and dicing the data
• Handled performance tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Created different type of reports including Cross-tab, Conditional, Drill-down, OLAP and Sub reports.
• Modified report content and exported reports in multiple formats based on user input.
• Developed logical and physical data models, design data access strategies and write SQL code to access and manipulate data stored in relational databases.
• Developed and implemented Stored Procedures, Triggers, and Functions.
• Installed and configured SQL Server 2005, Analysis services, Integration Services and Reporting services for QA and DEV.
• Worked in Data Warehousing and analysis skills including MDX language, OLTP, OLAP (MOLAP, HOLAP, DOLAP, and ROLAP), Relational and Dimensional modeling skills (star schema and snowflake schema).
• Performed Migration of data using Import Wizard tool from Confidential 6.5 to Confidential XI R2.
• Used @functions like @prompt (for user defined queries), @where (for creating conditional filters), and @select to create duplicate objects in the process of building the universes.
• Created master detail and cross tab reports to view the data in an analyzed way.
• Used the drill down/up, slice and dice features to analyze data, set variables, alerts and group values in the reports.

Environment: MS SQL Server 2005, SSIS, SSAS, BI XI R2, SSRS, SAAS, Windows XP, SQL Profiler, T-SQL, MS Office, C#.NET, ASP.NET, XML, MDX, Outlook Soft 4.2, Visual studio, Excel, Access.

Confidential, Philadelphia, PA

MS SQL Server Developer

Responsibilities:

• Involved in all stages of Software Development Life Cycle from requirement gathering to maintenance of databases.
• Created database objects like Tables, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Implemented one to one and one to many relationships between the tables in the database.
• Identified and implemented the tables with Primary Key, foreign Key and Identity columns.
• Maintained the referential integrity between the tables using Triggers and Stored Procedures.
• Created and manipulated the indexes for faster access of database tables.
• Wrote several SQL Scripts to query the tables to enforce constraints on tables with Identity and Primary Key.
• Migrated databases from SQL Server 2000 to SQL Server 2005.
• Converted DTS packages to SSIS as per client requirements.
• Maintained documentation for overall projects.
• Created indexes on selective columns to speed up queries and analysis in SQL Server Management Studio.
• Reduced the T-SQL overhead successfully by avoiding unnecessary use of The UNION, statement and used the TOP operator to limit the Select Statement in certain Queries.
• Created views to restrict access to data in a table for security.
• Created T-SQL queries, dynamic Stored Procedures that calculate by taking the customer details as input.
• Created views and indexed views to reduce database complexities for the end users.
• Designed and developed SSIS package for loading data from OLTP to Data Warehouse.
• Used ETL to implement Slowly Changing Dimension (SCD) to maintain historical data in Data Warehouse.
• Used GeoCoder tool to address-based geocoding application that assigns geographic coordinates to provider, facility, or ancillary location records.
• Used Bulk Copy Program and Bulk Insert to load data from different data sources to SQL Server.
• Created reports using SQL Server Reporting Services (SSRS).
• Improved Performance of the database by creating clustered and non-clustered Indexes and by optimizing the T-SQL statements using SQL profiler.
• Unit testing and Integration testing for various modules using Test Director.
• Extensively involved in replication and implemented Snapshot Replications
• Wrote detailed scripts to review object permissions in all databases across the servers.
• Worked in mission critical 24x7 production environment.
• Involved in maintenance of the site.

Environment: MS SQL Server 2000,2005, SSIS, T-SQL, Confidential, Geo Access Coder, EAP Expert, MS Office, Visual studio, SQL Profiler, Excel, Access, Windows Server XP, IIS 6.0, Erwin, Test Director.

Confidential

MS SQL Server Developer

Responsibilities:

• Reviewed, developed, and designed data models, in conjunction with the application development team.
• Involved in complete design phase of the project.
• Created complex Stored Procedures, Triggers, Cursors, Tables, Views and SQL Joins and other statements for various applications, maintained referential integrity and implemented complex business logic.
• Extensively worked on SQL Server Business Intelligence Development Studio.
• Worked in 24x7 production environment.
• Handled coding and development of GUI's.
• Created and integrated user defined functions and stored procedures for reporting purposes.
• Managed database integration issues including migration between disparate databases, integration, maintenance/conversion, capacity planning issues, and new applications.
• Assisted development staff with the application design to facilitate effective use of database languages, methodologies and established standards.
• Worked with development staff in approving database changes.
• Recommended the procedures necessary to save, retrieve, and recover databases from hardware and software failures within established procedures.
• Created and maintained database objects.
• Used SQL Server Profiler to tune the performance of the stored procedures and functions to improve the report generation time.

Environment: MS SQL Server 2000, MS Excel 2003, MS Access 2003, MS SQL Query Analyzer, SQL Profiler, ASP.