SUMMARY

• 9+ years of strong IT experience in healthcare insurance, finance, banking and retail industry with expertise in Database Design & Development, Database Administration, Data Migration, ETL processes and Business Intelligence Reporting using MS SQL Server 2014/2012/2008/2005 , IBM DB2,Business Intelligent products like SSIS, SSRS, SSAS, business object crystal reports, Power BI.
• Excellent understanding of Relational Database Systems, Normalization, Logical/Physical Data Modeling, ETL and Data Warehousing.
• Hands on Experience in Installation, Configuration, Managing, Monitoring and Troubleshooting of SQL Server 2005/2008/2014 on Windows Environments.
• Excellent SQL programming skills in writing business logic and complex queries to Create Database objects such as Tables, Views, Stored procedures, Triggers and User - Defined Functions.
• Good understanding of Database Architecture concepts related to Pages, Extents, Files, File-Groups, Transaction Logs, Tables and Indexes.
• Experience in using SQL Server Management studio tools such as Profiler, Database Tuning Advisor and Performance Monitor for Query Optimization and Performance Tuning.
• Experience in Database Administration work such as setting SQL Server Agent jobs for Backups, developing high availability solutions through Replication and Database Mirroring, creating Maintenance Plans, Maintaining Database Security etc. Experience in building Data Integration and Workflow Solutions for Extracting, Transforming, and Loading data with SSIS packages, DTS and BCP utility.
• Experience in the core areas likeEDI/ XMLandBizTalk / EDI Configuration,BizTalk Data Mapping usingSAP.Net Connectors EDIFACT, HIPAA 2.0/3.0to implement various EDI transaction such as 834, 835, 837.
• Experience in Implementing various SSIS features like Event Handling, Precedence Constraints, Breakpoints, Check Points, expressions, XML configuration files, Error handling and Logging for Complex SSIS Packages
• Expertise in C# and VB Script in Integration Services Packages while performing various Transformation Operations, file manipulation and multiple file handling.
• Experience in developing Custom Reports and Various types of Tabular, Matrix, Ad-hoc, Drill-down, Lists, Charts, Parameterized and Cascading Reports with multiple formatting using SQL Server Reporting Services (SSRS).
• Experienced in developing various types of midlevel to complex reports using Crystal Reports 2008.
• Experience in integrating custom visuals based on business requirements using Power BI desktop and Power BI Report server. Experience in developing complex calculated measures using Data Analysis Expression (DAX).
• Basic knowledge of developing and extending SSAS cubes, Dimensions, Data source views, SSAS- data mining models including deploying and processing of SSAS objects.
• Good understanding of using version Control Tools such as Team Foundation Server (TFS), Visual source safe (VSS) and PVCS version manager to keep documents and components organized for managing project life cycle.
• Strong analytical and problem-solving skills coupled with excellent documentation, verbal and inter-personnel communication skills including the ability to acquaint to fast changing environments
• Implemented various projects in team environment using AGILE methodology. Experience of using Rally agile central Scrum project.

TECHNICAL SKILLS

Databases & Data warehouse: MS SQL Server 2014/2012/2008/2005 , IBM DB2 9.7, SSIS, SSAS, Erwin Data modeler, BizTalk Server 2010/2013

Reporting Tools: SSRS, Business Objects Crystal Report 2008, Power BI Desktop and Report Server

Scripts: T-SQL scripts, VB.net, C#.net, MATLAB, XML, Unix Korn shell script, Power Shell script

Tools: SQL Server Management Studio client, TFS, Visual source safe, Workload Control Center(Autosys job using JIL), PVCS version manager, IBM Lotus notes, Rally Agile central(for Scrum project) MS Outlook, MS office, MS Visual Studio, MS Access 2007/2003, Windows Server 2007/2003,SSH Client

PROFESSIONAL EXPERIENCE

Confidential, Piscataway, NJ

Lead SQL/ SSIS/SSRS/ETL Developer

Responsibilities:

• Involved in complete SDLC including Requirement Specifications, Analysis, Design, Development and Unit testing of application. Helped in the design of the Architecture of the Data Mart and in performance tuning of its database.
• Created complex SQL server transactional stored procedures to apply business logic for claims processing, reprising, payment process and data validation. Implemented TRY-Catch-Throw for error handling, common table expression (CTE) for removing duplicates and dynamic SQL to standardize process.
• Participated in Medicare ACO DB design to create schema and relationships using Erwin data modeler and loaded monthly beneficiary and claims data available various ACO clients. Set up Database, SQL objects, ETL processes, folder structure and SQL job for new ACO client.
• Created SSIS Packages using For each loop container, Execute SQL Task, Data Flow Task, Script Task, File system Task, FTP task and applied transformation such as union, Pivot Transformation, script component task, Derived Columns, Condition Split, sort, merge join etc. to generate underlying data for the extracts and to export cleaned data from Excel Spreadsheets, Text file, MS Access and CSV files to data warehouse.
• Developed standard SSIS package to generate ‘dynamic column mapping’ during runtime to generate standard eligibility, members, groups, claims and providers extracts by passing only parameter to configuration file. This package saved development time and reduces maintenance.
• Implemented error handling using ‘On Failure’ precedent constraint and event handler in SSIS package to capture error data and informed user about error data with error description. Prevented SSIS package and SQL job failure when data error.
• Utilized Slowly changing Dimension wizard to implement type 1 and type 2 to load Quality metrics data. Developed incremental loading using MERGE statement.
• Configured Connection Managers, file paths and other dynamic variables for SSIS packages using XML file configuration to dynamically execute SSIS package on UAT and Production server.
• Used Execution Plan and Database Engine Tuning Advisor to optimize queries and stored procedures to enhance the process performance.
• Designed analytical reports through the use of Stored Procedures and reporting tools such as Business Objects crystal reports and SQL Server Reporting Services.
• Developed easy to use deployment tool using C#, to deploy SSIS package and configuration file on different network location for various ACO client.
• Involved in SQL server migration. Performed data quality and feasibility testing in UAT. Upgraded SSIS packages using SSIS package upgrade wizard in SSDT.
• Conducted peer design, code reviews, documentation standards and best practices to develop standard ETL procedures.
• Provided 24/7 on call support for all the Production servers. Analyzed production issues quickly and efficiently during working hours and on call to keep all process running smoothly.
• Deployed, Tested and Scheduled SSIS packages, SQL scripts using SQL Agent job agent.
• Worked as part of an Agile SCRUM team and responsible for iteratively delivering business outcomes.

Confidential, Roseland, NJ

Sr. SQL/ SSIS/SSRS/ETL Developer

Responsibilities:

• Gather requirements from Investment management operation and accounting team to identify data elements, create mapping documents, implementing business logic and analyze business data.
• Lead SSRS report migration project from UVTS (Unit Value Trade System) to PARIS (Plan Accounting Reporting and Information System). Developed SPs and SSIS packages to extract data from source system and load to destination databases. Identified data elements to map with the system.
• Created SSIS package to load data from Flat File to SQL Server 2008 database using various transformation such as Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Create SSIS Package with multiple SEQUENCE CONTAINERS to INSERT and UPDATE the dimension tables using type 2 slowly changing dimension methodology.
• Created XML package configuration to make package configuration dynamics to run in different environment.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Developed Unit Test Plans for SSIS packages for checking the functionality of each component.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Involved in creating alerts for successful or unsuccessful completion of scheduled jobs.
• Worked in setup logging environment to track the status of the events like error raise, task fail.
• Developing, Deploying and scheduling Reports using SSRS and crystal reports to generate all daily, weekly, monthly and quarterly reports.
• Developing Custom Reports and Various types of Tabular, Ad-hoc, Charts, and Parameterized Reports with multiple formatting using Crystal reports. Expertise in writing in crystal report formulas to create richly formatted reports.
• Assist the team on unit test and integration test of application and procedures. Work with other IT teams on issues/tasks related to the application, Autosys batch run and production support.
• Coordinating offshore team to assigning development work, resolving production support issues and performance related issues.
• Responsible for on schedule release each quarter as well as troubleshooting problem related to Plan Accounting and Reporting Information System. Available on call for production support.
• Analyzed existing system and programming logic to provide more efficient operations.
• Providing production support (e.g. critical business requirement, after hours, on call etc.) operations end users and the systems support team as well as conduct periodic application disaster recovery exercise.
• Working with project manager on suitable testing protocol and plan.
• Performing Unit testing and documenting the results.
• Coordination with the deployment team to deploy the new code in production.
• Participated for setting up HADR (High Availability Disaster Recovery) server and feasibility testing.

Confidential, Boston, MA

SSIS/SQL Developer

Responsibilities:

• Responsible for implementing Oracle Accounts Payable (AP) interface to Windward application. Many manual processes will be replaced with automated interfaces and processes for loading information on vendors, claims (invoices), payments, and payment status.
• Designed ETL packages dealing with different data sources (SQL Server, CSV, Flat Files etc) and loaded the data into target data destination by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Create complex stored procedures using temp-tables, joins and CTEs to extract customer personal information from various legacy systems to staging tables.
• Created SSIS Package using MERGE, DATA CONVERSION, LOOKUP, DERIVED COLUMN, DATAFLOW tasks to load customer personal information from staging database to Fact Tables.
• Create stored procedures to INSERT and UPDATE data from MYSQL databases to Fact Tables on the new data warehouse.
• Create VIEWS to de-normalize Fact data using multiple dimensions and lookups tables so as to use these VIEWS in generating business Reports.
• Create SSIS Package to export/import the Flat Files to an external Server through SFTP using WINSCP. This is accomplished using EXECUTE PROCESS TASK and BATCH files as Parameters.
• Create stored procedures comprising of dynamic scripts using BULK INSERT, INSERT and UPDATE tasks to copy data from multiple flat files to SQL SERVER staging tables.
• Created tabular SSRS Reports from SP, VIEWS and other FACT Tables using cascading parameters, drill downs, and other conditional formatting styles.
• Create SQL Server Agent Jobs with multiple TSQL and SSIS steps and setup EMAIL NOTIFICATIONS in case of Job Failure.
• Generate DB scripts for tables, views, stored procedures and Agent Jobs and create batch scripts to run scripts for production deployment process.
• Deploy objects and process to production systems, setup CMD LINE automation with software necessary to SFTP files, convert text file encodings, convert file formats and zip file folders.

Confidential, Boston, MA

MS SQL Server /BI Developer

Responsibilities:

• Used the SSIS to migrate databases such as Oracle and SQL Server database, flat files to centralized IT destination.
• Involved in Developing, Monitoring and Deploying SSIS packages and successfully created dynamic configuration packages in SSIS.
• Designed SSIS Packages to transfer data between servers, load data into database, archive data file from different DBMSs using SQL Enterprise Manager/SSMS on SQL Server 2005/2000 environment, and deploy the data. Used Event Handlers for Exception Handling in SSIS packages.
• Used SSIS transformations to implement the Slowly Changing Transformation, to maintain Historical Data in Data warehouse.
• Developed Report Models using report builder and distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS).
• Generated reports on wealth information, account information, research reports using ad-hoc reporting to be used by the clients and advisors.
• Identified and worked with multi valued parameters for parameterized reports in SSRS.
• Created Queries in T-SQL, Stored Procedures, and Views to store the data of clients, advisors.
• Created User Defined Functions, Triggers to store data into appropriate tables as and when data arrives and created indexes to the tables that have least updating to improve the query performance.
• Performed T-SQL tuning and optimization of queries for reports that took longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2005.
• Created many complex Stored Procedures/Functions and used them in Crystal Reports directly to generate reports on the fly.
• Scheduled, maintained, and supported the distribution and access to reports through Crystal Server.

Confidential, Dallas TX

Business Intelligence Developer

Responsibilities:

• Developed various T-SQL stored procedures, triggers, views and adding/changing tables for data load, transformation and extraction.
• Created database maintenance planner for performance of SQLServer which covers database integrity checks, update database statistics and re-indexing.
• Modified stored procedures to implement the complex business needs for generating new customer number, updating user profiles, transaction processing, generating messages with code encryption.
• Responsible for database tuning using normalization and application tuning.
• Developed ETL packages with different data sources (SQLServer, Flat files, Excel source files, XML files) and loaded the data into target tables by performing different kinds of transformations using SSIS.
• Applied various data transformations like Lookup, Fuzzy lookup, Fuzzy Grouping, Aggregate, Sort, Multicasting, Conditional split, Derived column etc.
• Implemented OLAP Cubes, Facts, and Dimensions for providing summarized and aggregate views of large sets of data and used Multi-Dimensional Expression (MDX) to access them.
• Created business critical KPIs usingSQL ServerAnalysis Services (SSAS) representing aggregations in several different ways - hierarchically and using custom groupings that the company will use to analyze performance
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Provided production support for ETL jobs
• Used Cognos 8 to generate different types of ad-hoc reports for Business Intelligence.

Confidential, Middletown, NJ

SQL Server Dev/DBA

Responsibilities:

• Actively participated in developing physical data model of database and implemented requirements on SQL Server 2005. Implemented complex conceptual database design into SQL Server 2005 using Normalization, various Constraint, indexes and Triggers.
• Implemented complex business requirement in backend using efficient stored procedure and flexible function, and facilitated easy implementation to the Front end application.
• Involved in development of automated daily, weekly and monthly system maintenance tasks such as Database backup, Replication Verification, and Database integrity verification and Indexing updates.
• Worked on Linked servers to run Distributed queries between SQL Servers.
• Scheduled Jobs and Alerts using SQL Server Agent.
• Managed Login and User: Adding Logins, Roles, and Groups to the Window NT and MS SQL Server and Maintaining proper security procedures.
• Creating and managing schema objects such as Tables, Views, Clusters, Indexes, Procedures, Triggers and Maintained Referential Integrity.
• Developed DTS Packages to get the Reports, routinely, in the Excel sheets, required by the managers for analysis.
• Expert in planning and implementing MS SQL Server Security and Database Permissions.
• Performance Tuning of SQL queries and stored procedures using SQL Profiler and Index Tuning Wizard.
• Use DTS and T-SQL Stored procedures to transfer data from Different data sources to Staging area and finally transfer into Data warehouse.
• Backing up master & system databases and restoring them when necessary.