SUMMARY

• 9 years of experience in Data Modeling, Database Design, Programming, Development and Implementation of Client - Server Applications & Database systems using SQL Server 2005/2008/2008 R 2/2012/2014.
• Experience in system and Business Systems analysis in Health care, withFACETS/QNXTand extensive interaction with client
• Extensive work knowledge in handling huge databases and worked on performance tuning and query optimizations.
• Extensively worked with various database tools like TOAD, SQL Developer & PL/SQL Developer
• Implemented PL/SQL advanced topics like Bulk Collect, Ref Cursors, Dynamic SQL, Collections, and UTL FILE to read and write the files.
• Extensive experience in using Microsoft BI studio products like SSIS, SSAS, SSRS for implementation of ETL methodology in data extraction, transformation and loading.
• Expert in Data Warehouse development starting from inception to implementation and ongoing support, strong understanding of BI application design and development principles.
• Highly experienced in whole cycle of DTS/SQL server integration services (SSIS 2005/2008) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL Purposes across different servers.
• Experience in providing Logging, Error handling by using Event Handler, and Custom Logging for SSIS Packages.
• Experience in Performance Tuning in SSIS packages by using Row Transformations, Block and Unblock Transformations
• Scheduling and Monitoring ETL Processes using DTS Exec utilities and batch files.
• Expertise in generating reports using SQL Server Reporting Services, Crystal Reports, and MS Excel spreadsheets and Power Pivot.
• Expert in designing Enterprise reports using SQL Server Reporting Services (SSRS 2000/2005/2008 ) generated drill down reports, parameterized reports, linked reports, sub reports, matrix dynamics and filters, charts in SSRS 2005/2008.
• Experience in creating Ad-hoc reports, data driven subscription reports by using Report Builder in SSRS.
• Created Dashboard pages in SharePoint Server that use different types of web parts and excel services for reports
• With the ease of TFS, managed user permissions among team projects and also, further made it easy to identify any missing permissions
• Good knowledge about macro configuration and the installation process
• Has very strong background in a disciplined software development life cycle (SDLC) process and has excellent analytical, programming and problem solving skills.
• Good team player, Excellent interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.
• Expertise in defining the business process flow and gathering business requirements.

TECHNICAL SKILLS

Languages: T-SQL, PL/SQL 11g, Dynamic SQL, MDX, C, C++, C#, ASP (.NET), XML, HTML, DHTML, HTTP, Shell Scripting, OOPS, JAVA/J2EE

Databases: MS SQL Server Denali,2014,2012,2008R2,2008,2005,2000

DWH / BI Tools: SQL Server Integration Services (SSIS), SQL Server Reporting Services (SSRS), SQL Server Analysis Services (SSAS), Facets, Business Intelligence Development Studio (BIDS), Informatica, Visual Studio, Cognos, Crystal Reports.

Database Design Tools and Data Modeling: MS Visio, ERWIN 4.5/4.0, Star Schema/Snowflake Schema modeling, FACT& Dimensions tables, Physical & logical data modeling and De-normalization techniques, Kimball & Inmon Methodologies, QNXT

Packages: MS Office, Microsoft Office Suit, Microsoft Office SharePoint Server (MOSS) 2007, Microsoft Performance Point Server 2007

Tools: and Utilities: SQL Server Management Studio, SQL Server Enterprise Manager, SQL Server Profiler, Import & Export Wizard, Visual Studio .Net, Microsoft Management Console, Visual Source Safe 6.0, DTS, Business Intelligence Development Studio (BIDS),Crystal Reports, Power Pivot, ProClarity, Microsoft Office(MS), Lotus Notes, Excel Power Pivot, Excel Data Explorer, Tableau, SQL Developer, TOAD

Operating Systems: Windows Vista/XP/2003/2000, NT & Windows 9x, MS-DOS and UNIX.

PROFESSIONAL EXPERIENCE

Confidential - LONG BEACH, CA

SQL / SSIS Developer

Responsibilities:

• Created stored procedures, scripts, views in SQL Server database and SQL server tables, indexes, and views.
• Migrated data from different sources (text based files, Excel spreadsheets, legacy systems and Access) to SQL Server databases using SQL Server Integration Services (SSIS)
• Designed and developed SSIS packages using various control flow and data flow items to transform and load the data from various databases and into server integrations services (SSIS).
• Worked in Agile Methodology to efficiently deliver the project on time
• Maintained the Version, Labeled Versions and Backups of the source using Team Foundation server (TFS)
• Created ad-hoc queries and reports as requested and provided an ongoing analytical support for these requests
• Extensively worked on Deployment, Performance tuning of SSIS packages, data transformations like Aggregate, Sort, Multicasting, Conditional Split, Derived column, Lookup etc.
• Knowledge in provider module environment in QNXT
• Worked on loading the data into QNXT and extracting the data from QNXT into other staging databases.
• Involved in designing and development of tables, views, user defined functions and complex stored procedures using T-SQL and CTE
• Created Clustered and Non-Clustered Indexes on tables for performance optimization of complex stored procedures.
• Worked extensively with T-SQL queries, created complex Stored Procedures using T-SQL and called them in SSIS packages
• Used For-Each Loop Container, Sequence Container, Script task, Expressions, Execute SQL task, Variables, Send Mail Task, Package Execution task to achieve business needs.
• Responsible for performing SQL tuning, multi-tasking and optimizing long running queries.
• Performed data analysis on daily, weekly, and monthly scheduled data refreshes based on the business or system change that have happened to ensure that the developed dashboards are displaying accurate and up-to-date.
• Interacted with vendors, developers and customers to manage the business requirements.
• Verified business requirements and functional specifications.

Environment: SQL Server 2014/2008R2 Enterprise Edition, SSIS, SSRS, SSAS, Autosys, C#, Visual Studio 2010/2013, QNXT, TFS.

Confidential - VIRGINIA BEACH, VA

SQL / SSIS Developer

Responsibilities:

• Involved in FACETS Implementation, FACETS billing, enrollment, and Claim Processing and Subscriber/Membership module.
• The healthcare system was a proto type of FACETS.
• Created stored procedures, scripts, views in SQL Server database and SQL server tables, indexes, and views.
• Created User Defined Functions to encapsulate frequently and commonly used business logic making the system more modular, secured and extensible.
• Worked on SDLC JIRA and CNR system as a tracking tool and for deployment of the code.
• Used SVN Tortoise for version control.
• Worked on CTU Tool for deploying code into QA and Prod.
• Created different database objects like Tables, Cluster/Non-Cluster Index, Unique/Check Constraints, Views, Stored Procedures and User Defined Functions etc.
• Created Control Flow tasks, Data Flow tasks, Variables, Configuration Files and used various Transformations in several packages of SSIS.
• Improved SSIS packages performance using check points.
• Created varieties of Reports using SSRS 2008 like standard, drill down, multi tab,crosstab, matrix style layouts, parameterized reports, performance issues handling, Sub Reports, and Ad-hoc Reporting framework design.
• Scheduled reports daily, weekly, monthly for executives, Business analyst and customer representatives for various categories and regions based on business needs using SQL Server Reporting services (SSRS).
• Developed complex queries on Database and developed PL/SQL Procedures to give in nice strategic plans to higher level of management.
• Followed Workgroup for Facets Electronic Data Interchange standards for testing that need to comply with the HIPAA guidelines.
• Involved in testing different interfaces and web application forFACETS.
• Analyzed the mainframe reports for member/eligibility/claims and mapped the fields withFACETSbatch jobs and reports.
• Tested the changes for the front-end screens inFACETSrelated to following modules, test theFACETSbatches (membership).
• Conducted Business validations for different FACETS modules Providers, Claims, enrollment and Membership
• Worked on Member Management, Eligibility, Claims and Billing modules within FACETS.

Environment: SQL Server 2012/2008R2 Enterprise Edition, SSIS, SSRS, SSAS, Control-M, C#, Visual Studio 2010, Erwin, FACETS.

Confidential - Hopkins, MN

SQL / SSIS Developer

Responsibilities:

• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written functions, stored procedures and triggers.
• Monitoring SQL Server performance using SQL Server Profiler to trace the slow running queries and optimized query execution with the use of Index Tuning Wizard and Rebuild indexes if necessary.
• Expertise level of knowledge as a data analyst in data conversion and data cleansing from the raw data sources.
• Created Custom reports and datasets for reports using global variables, expressions and functions in SSRS.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Involved in migrating the ExcelPowerView Reports toPOWERBIDesigner Reports.
• Involved in writing PL/SQL packages, procedures, and functions.
• Developed variousPL/SQLstored procedures and functions as a part of requirement.
• Hands on experience in controlling Jasper repositories and handed data processing.
• Involved in gathering reports requirements and then generated reports on Jasper.
• Hands on experience working with SSIS, for ETL process ensuring proper implementation of Event Handlers, Loggings, Checkpoints, Transactions and package configurations.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc.) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Generated Reports using Global Variables, Expressions and Functions for the reports.
• Implementing all high availability techniques like clustering, log shipping, replication.
• Working experience with Column store indexes, table partitioning in SQL SERVER 2012.
• Performance Tuning of multiple databases by fixing indexes, table partitioning, usage of temp tables, cte’s, redesigning schemas and many more.
• Created checks and constraints to maintain data integrity.
• Worked closely with the team in meeting the deadlines pertaining to design and development deliverables.

Environment: Windows2003 Advanced Server, ASP.Net, MS SQL Server 2005/20, TSQL, Pl/SQL, Visual Studio 2008,Oracle 11g, Jasper Reports 6.1.0 API, SharePoint 2007/2010, Cognos,, SSRS, SSIS, OBIEE, Informatica, Erwin.

Confidential, Rochester, NY

MS SQL / MSBI Developer

Responsibilities:

• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, and eliminated redundant and inconsistent data.
• Created numerous efficient Stored Procedures to perform data cleansing and loading task when data is loaded into staging area.
• Developed the flow charts and diagrams as well as translation of the detailed designs with Lotus Notes application.
• Worked extensively as PL/SQL programmer, Developed PL/SQL Procedures that handle key business logic.
• Created PL/SQL program units to include DML, DDL statements using Dynamic SQL
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• UsedPowerBICanvas to customize the colors of visualizations and font.
• Wrote stored procedures and User Defined scalar Functions (UDFs) to be used in the SSIS packages and SQL scripts.
• Built connections to/pulling data from AS400, mainframe/db2 and Oracle.
• Developed complex Stored Procedures and views to generate various Drill-through reports, parameterized reports and linked reports using SSRS.
• Created different Power Pivot reports as per the client requirement.

Environment: Windows2003 Advanced Server, ODBC, OBIEE, MS SQL Server 2005/2008/2012, TSQL, PL/SQL 11g, Informatica, Visual Studio 2008, Sharepoint 2007/2010, Qlikview, Lotus Notes, Oracle, SSRS, SSIS, Erwin.

Confidential, Broadway, NY

MS SQL/BI Developer

Responsibilities:

• Created new database objects like stored procedures, Functions, Triggers, Indexes and Views using T-SQL in Development and Production environment for SQL Server 2008.
• Migrated DTS packages from SQL Server 2000 to SQL Server 2008 as SSIS Packages.
• Created efficient, robust SSIS packages for data movement and loading with error checking and well documented code.
• Created SSIS Packages to integrate data coming from Text files and Excel files.
• Created SSIS packages to validate, extract, transform and load data to data warehouse databases.
• Migrated old data from MS Access into SQL Server 2008 using SSIS Packages in Business Intelligence Development Studio.
• Deployed SSIS Package into Production and used Package configuration to export various package properties to make package environment independent.
• Implemented Event Handlers and Error Handling in SSIS packages and notified process results to various user communities.
• Worked on Database Compression for different databases to save space across different environments.
• Wrote many stored procedures for cleaning, manipulating and processing data between the databases.
• Scheduled the Packages in SQL Server Agent on daily/weekly/monthly basis.

Environment: Data Transformation Services (DTS), SQL Server 2008 Enterprise Edition, ODBC, OBIEE, BIDS, Business Objects, Crystal Reports 8.0, XML, ASP.Net, Visual Basic 6.0.

Confidential, Rockville, MD

MS SQL, SSIS, SSAS and SSRS Developer

Responsibilities:

• Worked on extracting, transforming and loading data using SSIS Import/Export Wizard.
• Created Tables, Stored procedures and defined functions. Created SQL scripts for tuning and scheduling.
• Developed physical data models, data warehouse models and created DDL scripts to create database schema and database objects
• Migrated all DTS packages to SQL Server Integration Services (SSIS) and modified the package according to the advanced feature of SQL Server Integration Services.
• Created complexjoinsand implementedConstraintson tables for maintainingData Integrity.
• Involved in creating high levelETLarchitecture for overall data transfer toOLTP, ODSwith the help ofSQL Server 2005, 2008Integration services.
• Involved inrelational database modelinglike, designing the tables, algorithmic diagrams for the input data (entity diagrams), indexes etc.
• Created complex SSIS packages using appropriatecontrol and data flow elementswithSSIS Standards likeerror handling, loggingand working withpackage config files.
• Reduced the overallETL time bySQL Query performanceTuning. Discussed with user interface and external interface teams over the performance issues and provided solutions.

Environment: MS SQL Server 2008R2, SQL Server Reporting Services (SSRS), MS Access, MS Excel, SSIS, BCP, T-SQL

Confidential

SQL Server Developer

Responsibilities:

• Interacted with Team in Analysis, Design and Develop database using ER Diagram, Involved in Design, Development and testing of the system
• Developed SQL Server Stored Procedures, Tuned SQL Queries (using Indexes)
• Created Views to facilitate easy user interface implementation and Triggers on them to facilitate consistent data entry into the database.
• Worked on client requirement and wrote Complex SQL Queries to generate Crystal Reports
• Creating and automating the regular Jobs.
• Tuned and Optimized SQL Queries using Execution Plan and Profiler
• Rebuilding Indexes and Tables as part of Performance Tuning Exercise
• Involved in performing database Backup and Recovery
• Worked on Documentation using MS word