We provide IT Staff Augmentation Services!

Systems/data Analyst Resume

Piscataway, NJ

Professional Profile

  • 9+ years of strong IT experience in Administration and development of SQL SERVER 2008 R2/2005 including Database Engine, Integration Services, Reporting Services and Analysis Services.
  • Microsoft Certified IT Professional in Business Intelligence Developer 2008 and Microsoft Certified Technology Specialist in SQL SERVER 2008 Business Intelligence Development and Maintenance.
  • Architect and managed the SSIS (ETL) Packages for automating all the EDI claim files which are coming from physicians to the clearing house in the HealthCare Domain.
  • Expertise in Extracting, Transforming and Loading (ETL) data from heterogeneous sources like Excel, Flat files, XML file, DB2, ORACLE into SQL SERVER by using BCP utility, DTS and robust SSIS packages.
  • Improved the SSASCUBES for optimal performance generated SSRS Reports using complex MDX queries and populated the data using SSIS in the Data Warehouse Environment.
  • Developed complex reports like Ad hoc, Drilldown, Drill through, Linked, Tabular, Matrix, Chart and Cached reports with cascading parameters and also applied Dynamic Styling to reports using Expression whenever required using SQL SERVER Reporting Services 2008 R2.
  • Responsible for implementing/troubleshooting different types of Replications (Transactional, Peer-Peer) and also ensuring replication is scheduled and optimized.
  • Proven experience in Capacity planning, Performance Tuning, Disaster Recovery, troubleshooting, backup and restore procedures using 3rd party tools like Red-Gates DBA and Developer bundles.
  • Created, administered & maintained SQL Server Databases (Production, Development, Test and Staging Environment) for various groups such as Developer, QA etc. and ensured the availability of the Database Server in a 24X7 Environment.
  • Delivered large scale applications using latest framework technologies like C# 4.0, WCF, WF, LINQ using Visual Studio 2010/2008 and SQL SERVER 2012/2008 R2.

Experience Summary

  • Team Lead (Database)at Infotech Global Inc, Piscataway, NJ from 5th July 2010 to till date.
  • System Analyst at iGate Patni Global Solutions, Virginia, USA from 21st April 2008 to 25th June 2010.
  • Executive Software Developer at Minvesta Infotech Ltd, India from 14th Aug 2006 to 18th April 2008.
  • Software Engineer, Techgene Solutions Pvt Ltd, India from 12th May 2003 to 11th Aug 2006

Technical Skills

Operating Systems

Windows 2008/2003 Server, Windows XP/VISTA/7.

Domain Expertise

US Health Care, Retail Business Finance and HR Domains.

Languages

C#, C++, C, Core Java.

RDBMS

SQL, Dynamic SQL, T-SQL, MDX, SQL SERVER 2012/2008 R2/2005.

Business Intelligence Tools

SSIS (COZYROC Controls), SSRS, SSAS.

Frameworks

.NET 4.0/3.5/3.0/2.0, WCF 4.0/3.5, WF, LINQ.

Web Technologies

ASP.NET, ADO.NET, WEB SERVICES, REST, SOAP.

Markup Languages

jQuery, AJAX, JSON, HTML, XML, Java Script.

Web Servers

IIS 7.5/6.0.

Third Party Tools

Red-Gates, MS Enterprise Library 5.0/4.0, Dev-Express Controls

Collaboration tools

Excel, Word, Microsoft SharePoint Server 2010.

Certifications

  • MCITP (70-452): Business Intelligence Developer2008.
  • MCTS (70-448): SQL SERVER 2008 Business Intelligence Development and Maintenance.

Professional Experience

Project #1:MedConnect Health Care Clearing House Confidential, Piscataway, NJ
Duration: 5th July 2010 to till date

DBA & Team Lead (Database)
MedConnect is a highly secure, sophisticated system which enables physicians to submit their claims electronically. Previous to this, a physician has to manually maintain all the paper submitted claims, claim submission details such as number of claims submitted, payer details, type of claims (primary, secondary, tertiary), COB information, resubmitted claim information etc.., it became tedious work for the physician. Using MedConnect, physicians can submit all claims electronically and ensure (or track) the payer efficiency.

  • Architect and managed the SSIS (ETL) Packages for automating all the EDI claim files which are coming from physicians by processing the same with complex business validation in between and submitting the same to payers in payer specific format.
  • Implemented Transactional Replication for improving the performance of the Reporting Screens and also ensures transactional replication is scheduled and optimized.
  • Responsible for transforming EDI Claim files by designing robust SSIS packages using COZYROC 3rd Party controls like EDI Source, Secure FTP Task, SCP (Secure copy) Task, Parallel Loop Task, Lookup Plus, Distributed Cache Connection Manager and many more.
  • Responsible for Performance Tuning, Query Optimization using Performance Monitor, SQL Profiler and other 3rd party monitoring and troubleshooting tools like Red-Gates.
  • Developed industry best Disaster recovery models using Active Passive Clustering, regular database backups and customizing the entire database Maintenance plans using SSIS packages.
  • Created multi-dimensional CUBES for MedConnect Analytics and used complex MDX queries for KPIs, Calculations, Perspectives and many more.
  • Conducted root cause analysis for database incidents, problems and documented all required database objects for MedConnect application.
  • Handled Fine Tuning Databases System in-coordination with Application owners to utilize the maximum resources for Database and Applications.
  • Diagnosed and Resolved database integrity issues, performance issues, Lock Escalation and deadlocking issues, replication issues, log shipping issues, connectivity issues and security issues.

Project #2:Sales Edge Platform Confidential, VA, USA.
Duration: 21st April 2008 to 25th June 2010

Systems/Data Analyst
SalesEDGE is a multi-project program to build a new platform for applications utilized by Sales and Marketing, in the retail tobacco business. SalesEDGE will include Offline Application, Online Application, Legacy Replacement (FSI, WSL, TPCS, POS, ONLINE etc..,) and a new Sales Data Foundation (SDF). Objective of this new SalesEDGE platform is to replace the multiple existing systems used for Sales Department.

  • Analyzed the Legacy DB2 Data Model and created\\enhanced the SQL SERVER Wholesale OLTP Data Model.
  • Developed, tested & implemented a robust database backup and recovery strategy with client assistance.
  • Owned the Database Migration for Wholesale module and Error Handling the unmatched data between the legacy and current database. Also developed T-SQL to validate the migrated data.
  • Responsible for Migration\\Transforming data by designing robust SSIS (ETL) packages using Lookup, fuzzy lookup, conditional split, Data Flow, multi cast, Data conversion, Script task and many more.
  • Executed Configuration Manager Role in Sales Edge by identifying, monitoring and controlling all the configurable/non-configurable items in the project and also done configuration audit report for other modules in the project.
  • Chaired the High Level Planning team in creating the most appropriate architecture which suits the Business needs of Sales Edge Platform and designed the High Level Document for Sales EDGE.
  • Managed a team of 10-12 developers which includes overall project tracking and planning activities of the team. Also ensured all the coding guide-lines are religious followed by the team members.
  • Responsible for maintaining scripts, utility jobs or implement needed software for database maintenance.

Project #3:ELLIS Confidential, UK.
Duration: 14th Aug 2006 to 18th April 2008

Module Lead
Ellis is a next generation desktop front office (Front Office: Refers to systems that deal directly with the customer. It provides functionality and data necessary to add Clients, Candidates, configure complex services and provide effective service and support to customers.) Application designed to automate the management of various front office processes and entities - Client, Client Contact, Contract, Candidate, Consultant, Work Order, Tender etc.., the application is highly configurable and facilitates the user to define hierarchy, manage documents, manage day-to-day activities and create customized reports.

  • Part of the ETL Team in Loading\\Transforming the data from the Legacy system to the current database for Client and Client Contact modules in Ellis.
  • Developed complex reports like Tabular, Matrix, Sub reports, Linked, Snapshot, Ad hoc, Drilldown, Drill through reports with/without parameters and also responsible for deploying all the reports to Production report server and trouble shooting for any kind of issues.
  • Designed the key components of Service Oriented Architecture for Ellis.
  • Involved in implementation of Web Services for Ellis and also had major contribution in securing the web services using SOAP Headers.
  • Responsible for Migration\\Transforming data by designing robust SSIS (ETL) packages using Lookup, fuzzy lookup, conditional split, Data Flow, multi cast, Data conversion, Script task and many more.
  • Implemented custom authentication and state management modules using HttpModule with minimal overhead for each request processing.
  • Managed a team of 7-9 developers including overall project tracking and planning activities of the team.

Project #4:Master Data Management Confidential, Norway.
Duration: 3rd Jan 2005 to 11th Aug 2008

Senior Data Analyst
Wilhelmsen Marine Services (WMS) offers logistics solutions and maritime services through a worldwide network embracing some 13,300 employees at just over 350 offices in roughly 70 countries. WMS-MDM provides a single view of customer within BUSS & across other various business areas to enable Cross-selling. WMS-MDM avoids duplicate customer/vessel records with in a system and provides consistent definition of a customer across the business. It is an application developed to target admin users of the client. Its basic functionality is to fetch, gather and maintain the master data of the client services. Besides, it keeps updating the target system about the new changes/subscriptions additional enhancements etc.

  • Part of the ETL Team in Loading\\Transforming the data from the Legacy system to the current database for Client and Client Contact modules in Ellis.
  • Responsible for Migration\\Transforming data by designing robust SSIS (ETL) packages using Lookup, fuzzy lookup, conditional split, Data Flow, multi cast, Data conversion, Script task and many more.
  • Developed complex reports like Tabular, Matrix, Sub reports, Linked, Snapshot, Ad hoc, Drilldown, Drill through reports with/without parameters and also responsible for deploying all the reports to Production report server and trouble shooting for any kind of issues.
  • Designed the key components of Service Oriented Architecture for Ellis.
  • Involved in implementation of Web Services for Ellis and also had major contribution in securing the web services using SOAP Headers.
  • Implemented custom authentication and state management modules using HttpModule with minimal overhead for each request processing.

Project #5:SMART Confidential, UK.
Duration: 14th July 2003 to Nov 25th 2004

SQL Developer
A web based project management tool, developed to ease the tasks of day-to-day activities and drawing different reports. SMART is information backbone for the Lloyds Banking Group account. It serves as the focal point in the day-to-day operations of the account by hosting a mosaic of functions ranging from Lloyds project management to reporting those are critical to the success of the account. Input data for this system is fetched from BFS PMO (which is centralized database system of Cognizant) using SSIS and inserted into SMART's database after certain business validations and transformations.

  • Part of the ETL Team in Loading\\Transforming the data from the Legacy system to the current database for Client and Client Contact modules in Ellis.
  • Responsible for Migration\\Transforming data by designing robust SSIS (ETL) packages using Lookup, fuzzy lookup, conditional split, Data Flow, multi cast, Data conversion, Script task and many more.
  • Developed complex reports like Tabular, Matrix, Sub reports, Linked, Snapshot, Ad hoc, Drilldown, Drill through reports with/without parameters and also responsible for deploying all the reports to Production report server and trouble shooting for any kind of issues.
  • Designed the key components of Service Oriented Architecture for Ellis.
  • Involved in implementation of Web Services for Ellis and also had major contribution in securing the web services using SOAP Headers.

Academic Credentials

  • Graduated Bachelor of Engineering (B.E.)

Hire Now