SUMMARY

• Over all 5+ years of experience in Programming, Development and Implementation of Client - Server Applications & Database systems using TSQL 2012/2008/2005/2000.
• Experienced in Installing, Upgrading and Configuring of Microsoft SQL Server and Databases.
• Proficient in SQL Server and T-SQL (DDL and DML) in constructing Tables, Normalization techniques on database Tables.
• Expert in creating and using Stored Procedures, Views, User Defined Functions.
• Expert in creating Sub-Queries and Joins for complex queries involving multiple tables and Exception Handlers.
• Excellent experience in creating Indexes, Indexed Views in observing Business Rules and creating effective Functions and appropriate Triggers to assist efficient data manipulation and data consistency.
• Well experience in Data Extraction, Transforming and Loading (ETL) using various tools such as SQL Server Integration Services (SSIS), Data Transformation Services (DTS).
• Experience in maintaining Batch Logging, Error Logging with Event Handlers and Configuring Connection Managers using SSIS.
• Extracted, transformed and loaded data from various heterogeneous data sources and destinations like Access, Excel, CSV, Oracle, flat files using connectors, tasks and transformations provided by SSIS.
• Involved in creating Jobs, SQL Mail Agent, Alerts and Schedule SSIS, DTS Packages.
• Involved in Query Optimization and Performance Tuning using SQL Profiler and Index Tuning Wizard.
• Self-motivated and possess ability for critical thinking, analysis, good interpersonal and communication skills. Team-oriented, technically motivated and creative. User oriented with a desire to learn client's business requirements.
• Strong inclination for finishing job before project deadline. Flexible and versatile to adapt to any new environment and work on any project.

TECHNICAL SKILLS

Operating Systems: Windows NT/98/2000/XP/2003 Server, Unix, Linux.

Languages: T-SQL, CSS, HTML, ASP.NET, C#, .NET Framework, C.

Data Warehouse Tools: SSIS, SSRS, SSMS, Business Intelligence Development Studio, DTS, Enterprise Manager, SQL Profiler.

Databases: MS Access, MS SQL Server 2000/20, Oracle 8i/9i/10g.

Tools: /Utility, Enterprise Manager, SQL Server Management Studio(SSMS), Database Tuning Advisor, DTS, Analysis Manager, BCP, SQL Profiler.

Reporting Tools: Excel, SQL Server Reporting Services 2012, 2008, 2005.

Other Tools: MS Office, Visio, MS Excel, MS-Project 2000.

PROFESSIONAL EXPERIENCE

SQL BI Developer

Confidential, Richmond, VA

Responsibilities:

• Designed and developSSISpackages toExtract transformandloaddata from various data sources into SQL server.
• Automating SSIS Execution using Windows SchedulerusingDTExec Command.
• Createdlogging,custom logginganderror handling packages.
• Grouping,aggregating, andsplittingdata usingSSIS.
• ScriptingusingSSISfor datacleansing, encrypting, decryptingsensitive information.
• Creating Various Reports UsingSSRSfor analysis and managing claim processing.
• DevelopingSSISpackages to automate differentFTP’s filesand emailing to different clients.
• CreatingTabularreports, Matrix reports, List & Chart reports, Sub reports,Ad-hoc reports, Drill down reportsaccording to business requirements in time restricted environment.
• Creating severalComplex Reports(sub reports, graphical, multiple groupings, drilldowns, parameter driven, formulas, summarizedandconditional formatting) using SSRS.
• Developing, maintaining, troubleshooting and updating Reports using Ms Access.

Data Specialist

Confidential, Chicago, IL.

Responsibilities:

• Perform extracting, importing, and exporting of data in various database applications.
• Performed backend research using Microsoft Access to verify providers had updated contracts with no errors
• Responsible for maintaining Premier Provider database with updated Medicaid numbers
• Corrected missing and invalid comp grids based on exception error that kicked out
• Created scripts indicating if new Medicaid number or comp grid value needed to be added to the database and terminate old ones.
• Updated the Medicaid IDs in PPW Applications with NPI Number.

Environment: T-SQL, SQL Server, MS Access, Excel, Word, DB2, PPW.

Programmer Analyst

Confidential, Piscatway, NJ

Responsibilities:

• Developed and designed the business logic based on the requirement using SQL server.
• Used joins and sub-Queries for Complex queries using multiple tables from different databases.
• Implemented the complex Business Logic using the stored procedures, User Defined Functions, Views, TSQL Scripting
• Designed and implemented the SSRS tabbed reports based on the state templates.
• Created reports on SQL server reporting services 2008.
• Built reports through Report Builder 3.0 and Report Designer.
• Createddata driven subscriptionsand managed subscriptions foranural reports for Medicaid and Medicare product.
• Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database
• Created several SQL reports to display data in a summary and a detailed level using stored Procedures
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including status.
• Optimized existing stored procedures to achieve improved performance
• Tuning of SQL Server Configuration (Locks, and Indexes).
• Fine tuned SQL Queries for maximum efficiency and performance.
• Generated necessary documentation through MS Word and Flow charts with MS Visio.

Environment: TSQL, SQL Server 2008/2012 Enterprise Edition, .NET, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), XML and Windows Server 2003/2008.

Programmer Analyst/ SQL BI Developer

Confidential, Seattle, WA

Responsibilities:

• Interacted with business users in collecting the requirements, solving issues and making changes as required.
• Created database objects like tables, indexes, stored procedures, views, user defined functions, cursors and triggers.
• Managed indexes and optimized queries using execution plan.
• Used temporary tables, table variables and common table expressions (CTE) for the better performance of the queries according to the requirement.
• Involved in performance tuning of queries and SSIS packages which increases the performance and runs faster.
• Extracted large volumes of data from different data sources and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Created ETL packages to get the data from XML raw files and used XSD files to convert the raw file to desired format.
• Created complex packages and performed the ETL to load the Dimension Tables in using SSIS.
• Implemented the concepts of incremental data load, Slowly Changing Dimensions for updating and maintaining the history of the records.
• Upgraded SSIS 2005 packages to 2008 packages.
• Involved in testing the performance of SSIS packages over different servers in collaboration with platform labs.
• Created data flow tasks for logging the audit data of the packages.
• Used Event Handlers to handle errors in the packages.
• Deployed the SSIS Packages from development server to production server.
• Used script task to produce HTML reports and mail using SSIS.
• Created SSRS reports by Report designer for the users and deployed onto the report server.
• Supported multiple projects at a time.

Environment: SQL Server 2008/2012 Enterprise Edition, .NET, SQL Server Business Intelligence Development Studio (SSAS, SSIS, SSRS), XML and Windows Server 2003/2008.

Programmer Analyst

Confidential, Piscatway, NJ

Responsibilities:

• Involved in database development and creating SQLscripts. Also experience writing complex T-SQL queries to support needs from business.
• Involved in Requirement Study, Development, Implementation, code Review, Validation & Testing, Deployment and client interactions.
• Worked closely with customers and IT management and staff to provide application development and production support.
• Responsible for Data Migration of health insurance (Action) from SQLServer using SSIS via Microsoft management studio 2005 and writing some reports using Microsoft SQLServer business intelligence studio.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Analyzing SQL data, identifying issues, and modifying the SQL scripts to fix the issues.
• Review every day applications and make sure they are accepted.
• Tuned and Optimized SQLQueries using execution plan and profiler.

Environment: T-SQL, MS SQL server 2012, MS Power BI, 2008R2, EXCEL

SSIS\SSRS Developer

Confidential, Virginia Beach, VA

Responsibilities:

• Developed and designed the business logic based on the requirement using SQL server.
• Used joins and sub-Queries for Complex queries using multiple tables from different databases.
• Implemented the complex Business Logic using the stored procedures, User Defined Functions, Views, TSQL Scripting
• Designed and implemented the SSRS tabbed reports based on the state templates.
• Created reports on SQL server reporting services 2008.
• Built reports through Report Builder and Report Designer.
• Deployed SSIS packages and Scheduled Jobs with Tidal job.
• Createddata driven subscriptionsand managed subscriptions foranural reports for Medicaid and Medicare product.
• Extensively involved in designing the SSIS packages to export data from flat file source to SQL Server database.
• Created several SQL reports to display data in a summary and a detailed level using stored Procedures.
• Deploying and scheduling Reports using SSRS to generate all daily, weekly, monthly and quarterly Reports including status.
• Optimized existing stored procedures to achieve improved performance.

Environment: MS SQL Server 2000/2005/2008 , MSSQLServer 2008 R2, Visual studio 2008,SSIS, SSRS, JIRAMS SQL Server Reporting Services (SSRS), MS SQL Server Integration Services (SSIS),T-SQL, PL/SQL, Visual Studio 2005, BIDS, Windows 2003/2008 Server.

Junior Programmer Analyst/SQL Developer

Confidential, Fairfax, Virginia

Responsibilities:

• Performed the Creation, manipulation and supporting the SQL Server databases.
• Involved in Creation of tables, indexes, sequences, constraints, functions, triggers, views and joins.
• Created stored procedures for maintaining SQL Server, Written Stored Procedures for Application Developers.
• Planned the Complete Backing up of Database and Restored the Database from Disaster Recovery.
• Written complex T-SQL statements (Queries) for retrieval of data and involved in performance tuning of TSQL queries.
• According to the business requirements made the documentation of the performed tasks.
• Extensively Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Managing the security of the servers, creating the new logins and users, changing the roles of the users.

Environment: Windows 2000 Server, SQL Server 2000, Query Analyzer, Enterprise Manager, Import and Export, SQL Profiler.