SUMMARY

• Conversant with all phase of Software Development Life Cycle (SDLC) involving Systems Analysis, Design, Development and Implementation
• Experience in the IT industry as a BI Developer and SQL Server Developer in Healthcare insurance domain.
• Extensive experience in MS SQL Server 2000/2005/2008 R2 and hands on Experience in installing, configuring, managing, monitoring, troubleshooting, up gradation and migration SQL Server 2005/2008.
• Highly Proficient in the use of T - SQL for developing complex stored procedures, cursors, triggers, tables, user functions (UDFs), materialized views, user profiles, relational database models and data integrity, Data validation rules/logic, SQL joins, Table expression, complex data & XML manipulation and query writing.
• Expert in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS). Created SSIS Packages using Derived Columns, Condition Split, Term extraction, Aggregate, Execute SQL Task, Data Flow Task, and Execute Package Task etc to generate underlying data for the reports and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Worked on TFS Installation & setup for Application source control.
• Experience in data migration between heterogeneous systems using ETL tools such as DTS, SSIS from disparate data sources, Batch Processing & Automation of Production Packages using SQL jobs.
• Extensive experience supporting 24/7 production IT operation.
• In-depth knowledge of T-SQL, SQL (DDL, DML, and DCL), PL/SQL. Experience in performance tuning, query optimization, client/server connectivity and database consistency check using DBCC.
• Database and table design and implementation for data warehouse/Datamart and related ETL processes.
• Extremely diligent, strong team player with an ability to take new roles, ability to work under pressure in a highly visible role.

TECHNICAL SKILLS

• RDBMS/DBMS MS SQL Server 2012/2008 R2/2005/2000
• DTS & SSIS
• Export & Import (DTS)
• T-SQL
• VBscript
• ASP.Net
• HTML
• VB.NET & C#
• C++
• SQL Profiler
• SQL Query Analyzer
• SQL Debugger
• SQL Agents
• SQL Alert
• SSAS & SSRS
• Microsoft Visual Studio
• Oracle 8i
• Oracle 9i
• Oracle 10g
• VB6/VBA
• Crystal Reports
• TFS 2013
• Oracle Developer 6i/2000 (Forms & Reports6i)
• MS Office Suite (Ms- Word
• Excel
• Ms Access
• Power point
• Outlook)
• Ms Visio
• TOAD
• Lotus Smart Suite
• MS Sharepoint
• Adobe Photoshop
• Windows XP/2000
• Windows Vista
• Windows7
• Digital Unix Tru64

PROFESSIONAL EXPERIENCE

Confidential, Matawan, NJ

Database Developer

Responsibilities:

• Worked on SQL stored procedures, functions, views, indexes, Table Partitions T-SQL queries.
• Worked on data quality reports (Data comparison) after data cleansing steps/process (including postal process of data and applying business rules).
• Create/Extend new ETL programs using either Pervasive or SSIS toolset. Worked on Development/modification of business rules for client data extracts.
• Worked on NCOA (National Change of Address) ’d data periodically to update with latest data along with address verifications steps.
• Provides QA analysis and support to Data Processing and Analysis team in various testing phases of the project. Performs QA functions & Data Reconciliation to ensure accuracy of business rules defined and data presentation.
• Write ad-hoc queries to extract data as per Business Requirements. And processed periodic client extract in accordance with Layout, Data Dictionary.
• Work closely with the business users to understand the requirements and converting them into project level technical capabilities.
• Analyze samples of client data for quality before and after processing, checking data cleanliness and ensuring the ability to use data in existing processes. And worked on resolution of data quality issue for various file formats.
• Developed/maintained complex SSIS package to load data from various sources to MS SQL databases.
• Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary.
• Perform Ad Hoc projects as needed.
• Worked on project management tool JIRA, version control tool Git, Documentation tool Wiki.
• Worked on various datamarts deployments.

Confidential, Clifton, NJ

Database/ Application Developer

Responsibilities:

• Worked on data load from various sources to MS SQL databases, validating data through Postal requirements (NCOA, CASS, TNT, Generating postal documents) per the specifications.
• Worked on data preparation for printing using BCC Software.
• Set up TFS for Application Source control.
• Worked on ETL process, involves Importing data from various sources as excel, flat file,CSV into database using SSIS packages/export data to various formats from databases.
• Creating schema objects and implementing rules for data integrity Export & Import specs for the generation of data files.
• Worked on SQL stored procedures, functions, views, T-SQL queries.
• Data Reconciliation to ensure accuracy of business rules defined and data presentation.
• Analyze samples of client data for quality before and after processing, checking data cleanliness and ensuring the ability to use data in existing processes. And worked on resolution of data quality issue for various file formats.
• Strategic & Analytical reports development in SSRS, experience managing MS Reporting Server subscriptions using SQL DMO, security, and data connections.
• Design, create specifications, Code Development and perform testing of ETL/database application projects.
• Recommend corrective action when necessary to improve performance, capture exceptions, and maintain scheduled jobs.
• Assist in troubleshooting /Application bug fixing, modifications, and slight extensions. Releasing code to Production using TFS and sending release note to relevant group.
• Perform Ad Hoc projects as needed.
• Software installation, applying updates and set up.
• Support production processes on daily basis.

Confidential

SQL Database Developer

Responsibilities:

• Worked on Claims eligibility files EDI 834 Files (Benefit Enrollment & Maintenance) from variety of sources & to load into SQL Databases .
• Contributed in all phases of SDLC and analyzing the Tech documents in the current project.
• Prepared Tech design High level/Low level design specification documentations.
• Comprehensively involved workflow management system in Code development, Testing, support and Trouble shooting.
• Written complex queries, Stored Procedures, triggers, user defined functions and views using MS SQL Server 2005/2008 R2.
• Worked on Data Modeling, Data Flow Diagram, Flowcharting of Application work flow.
• Troubleshoot and debug issues using SQL profiler.
• Created Winform UI in the application.
• Design and development of Data Access Layer using ADO.net objects like SQL data adopter, Dataset and Data reader.
• Created Tables, stored procedures, functions and triggers in SQL to implement business logic at databases

Confidential, Saddle River, NJ

Database Developer/Engineer

Responsibilities:

• Developed DTS and SSIS packages to load data from various sources to MS SQL databases.
• Automate the package to pick up files from clients FTP sites to load data into our data warehouse using BIDS. Development of SQL jobs.
• Work with business analysts to identify the appropriate data elements (data mapping to datamart) for required capabilities.
• Provides QA analysis and support to Data Processing and Analysis team in various testing phases of the project. Performs QA functions & Data Reconciliation to ensure accuracy of business rules defined and data presentation.
• Analyze samples of client data for quality before and after processing, checking data cleanliness and ensuring the ability to use data in existing processes. And worked on resolution of data quality issue for various file formats.
• Assist in developing and maintaining documentation on all data and metadata and supports clarification and usability communication.
• Assists Data Processing and Analysis Team in constructing data cleaning, loading and distribution requirements as well as building process to transfer and integrate new data development projects into the existing maintenance project schedule. And handle specific case resolution ticketing/bug tickets system.
• Write ad-hoc query batches and stored procedures to assist in analyzing, cleaning, checking and processing data to ensure the maximum possible integrity and quality. Worked on processing Ad-hoc data request.
• Review and optimize SQL queries, stored procedures, views and triggers to achieve maximum efficiency and scalability.