SUMMARY

• An Information technology professional wif more TEMPthan 10 years of extensive IT experience in all phases of software development life cycle including System Analysis, Design, Development, Implementation, Testing, Support, Maintenance in client server and three - tier architecture.
• VeryfamiliarwifIMS and Symphony
• Excellent knowledge of Software Development Life Cycle (SDLC), Adhered to standards/guidelines throughout the development life cycle and maintenance of the models.
• In-depth knowledge of Rational Unified Process (RUP); risk engineering; data modeling and mapping; and design using UML, Rational Rose, and Visio.
• Extensive experience in requirement gathering, writing business and functional specifications, translating user requirements to technical specifications, created/maintained/modified data base design document wif detailed description of logical entities and physical tables.
• Adept Confidential reducing development costs and providing traceability of projects.
• Extensive experience in Process Management and Modeling, Conceptual and Logical Data Modeling.
• Possess strong Documentation skill and knowledge sharing among Team, conducted data modeling sessions for different user groups, facilitated common data models between different applications, participated in requirement sessions to identify logical entities
• Extensive Experience in Relational and Dimensional Data modeling for creating Logical and Physical Design of Database and ER Diagrams wif all related entities and relationship wif each entity based on the rules provided by the business manager using Erwin
• Worked extensively in Forward and Reverse Engineering processes. Created DDL scripts for implementing Data Modeling changes. Published Data model to acrobat PDF files, extensively created Erwin reports in HTML, RTF format depending upon the requirement, Published Data model in model mart, created naming convention files, co-ordinate wif DBAs to apply the data model changes
• Strong understanding of the principals of Data-warehousing using Fact Tables, Dimension Tables, star and snowflake schema modeling.
• Extensive experience in backend programming including Database table design, Stored procedures, Triggers, Indexes, Performance tuning in Oracle 10g/9i/8i.
• Excellent problem solving skills wif a strong technical background and result oriented team player wif excellent communication and interpersonal skills.

TECHNICAL SKILLS

Database: MS SQL Server 7.0/2000, MS Access, Teradata, Oracle 9i/8i/7.0 (SQL, PL/SQL, SQLPLUS, SQL Performance tuning, SQL Loader, Stored Procedure, Triggers, PRO*C)

Analysis Server: Microsoft Analysis Server 2000

Tools: Visual Source Safe, Crystal Reports, Cognos, Visual Interdev, MS Project, MS Office, COM/DCOM

Languages: Visual Basic 6.0/.NET, VBA, ASP, VBScript, RDO, ADO, PL/SQL, Transact SQLCOBOL/400, CL/400, RPG/400, ASP.NET, XML, HTML, ADO.NET, VB.NET, Shell Script

OS: SOLARIS 2.6, IBM-AIX 5L (Ver 5.2), HP-UX 10.x, SCO ODT, UNIX system V, WINDOWS NT/2000

Others: ERWIN 3.5, SQLServer2000 Reporting Services, SAS, TOAD, PL/SQL Developer, MKS TOOLKIT, PC ANYWHERE, Visual Source Safe, Clarify, PVCS Version Manager

PROFESSIONAL EXPERIENCE

Confidential

Business Data Analyst

Responsibilities:

• Analyses Sunshine data requirements as defined in a BRD for various Clients and Interface Agreements, as well as understanding database designs and data relationships.
• Good Understanding of Federal and State Sunshine Transparency Reporting Requirements
• Expertise in Concur data for Federal and State Transparency Reporting, Worked on various Aggregate spend reporting data from various sources like Clinical Trials, Grant, Speaker Programs etc.
• Understanding and reviewing Data required for creating Source to Target Data Mapping and Data Flow Documents.
• Worked wif HCP/Professional data from customer master and updating manual data files for processing. Worked wif prescription data from IMS.
• Liaison between Data Services team and Data Warehouse team to automate various manual processes using new technologies like ETL tool
• Review Data mapping and Business Requirement Documents for clients to migrate processes from SQL Server to Data warehouse
• Extensively working on CRM, Salesforce Data from Veeva Irep (Mobile Application) from Field Reps, Analyzing data so that business rules are implemented.
• Analyzing and Managing Salesforce Data for Various Pharmaceutical client like Universe Creation, Target Accounts, creating Hcp Accounts, Call Activity (Sample and Detail Calls) and Territory Alignment data
• Review and Manage Data extracts are send to various third party vendors for SLN Validation like Knipper and Medpro
• Involved in Analyzing, creating extract and performing Data loads for various types of Pharmaceutical Data like Sales and Marketing Data, Nrx and Trx Data, Shipment Data

Confidential, NJ

Technical Data Analyst

Responsibilities:

• Analyses Sunshine/Transparency reporting data requirements as defined in a FRS and Interface Agreements, as well as understanding database designs and data relationships.
• Understanding of Federal and State Sunshine Transparency Reporting Requirements
• Worked wif IMS and Symphony data.
• Involved in gathering business requirement and creating functional requirement document wif ETL and MDM team.
• Expertise in Concur data for Federal and State Reporting. Worked on various Aggregate spend reporting data from various sources like Clinical Trials, Grant, Speaker Programs etc.
• Understanding ETL and Business Architecture. Involved in creating GAP FRS.
• Involved in daily meeting, work sessions and discussion wif ETL and MDM team, understanding and reviewing Architecture Design Documents and Data Model required for creating Source to Target Data Mapping and Data Flow Documents.
• Review system interface agreements, file formats, functional requirements, and system design to document data flow, data transformations/validation, and traceability to support SIT and UAT testing needs as well as data issue management.
• Document data flow and traceability from several source system feeds into a backend data processing platform ultimately feeding data into an external vendor reporting system (Cegedim AGG360) to meet federal and state Sunshine reporting rules.
• Define deliverables and formats to be reviewed and accepted by IT and business leadership to provide visual representations and data traceability of front to back data flow throughout the system from source system to reports.

Confidential, NJ

Sr. Business Data Analyst/Modeler

Responsibilities:

• Participated and involved in discussions wif clients/users to determine the dimensions, hierarchies and levels, basic measures and key metrics for relational / multidimensional data model for the system, understanding reporting requirements, designing data model.
• Extensively interacted wif user and involved in requirement gathering and analysis, involved in reviewing various documents like Business Requirement Document, Technical Requirement Documents, Database design document, requirement traceability matrices etc.
• Extensively Interacted wif MDM team, understanding MDM architecture and involved in discussion reviewing BRD's and TRD's., Involved in supporting MDM issues.
• Involved in defining and implementing Data Governance processes, worked wif Data Stewards
• Identified and define business deliveries, goals, and information needs and integrate them into the overall Data Architecture.
• Worked wif ETL team and Enterprise architects to validate and refine recommendations for projects including Medicare and Medicaid programs. Also worker wif Health Care Reform (HCR ) Group
• Intensively involved in Design and Development of Enterprise Canonical Data Model, Supported MB&A Program as being part of DA Team, worked extensively on Data mapping for Affinity Gap Analysis Document.
• Worked on Mapping Logical/Canonical Data Model Attributes to Potential Sources and Identify Gaps
• Involve in Business Process Reengineering / Business Transformation in Healthcare
• Developed the logical data model (LDM) and assists in developing the physical data model (PDM). Facilitates JAD sessions to determine data rules, and holds LDM and PDM Reviews wif Data SMEs
• Used Embarcadero as Data Modeling Tool.
• Applied Naming Standards, checks models in and out of Model Repository, and documents data model translation decisions
• Enforced and monitordatastandards to minimizedataredundancies and enhance information quality.
• Ensured consistency and integration wif existingdatastructures in the enterprise logicaldatamodel.
• Worked on creating Data Dictionary, Defining Attributes and Entities adhering to Business Standards
• Use Data Profiling Technologies and Methodologies (Informatica Data Explorer / Data Quality) to profile data for Enterprise Data Model
• Worked wif Off shore - onsite model, worked wif offshore teams on daily basis
• Worked wif third party vendor Data to analyze Social Member Data. Worked wif Predictive analysis of Member Data, Patient Care and behavior Analysis.
• Document List Of Values and Created Source to Target mapping and its documentation.
• Discovery, synthesis, analysis and validation of Data, Process, and Information challenges and recommend the remediation strategies and track through its complete remediation
• Excellent communication, interpersonal and time-management skills.

Confidential

Sr. Business Data Analyst

Responsibilities:

• Participated in Joint Application Design/Development (JAD) sessions and involved in discussions wif clients/users to determine the dimensions, hierarchies and levels, basic measures, derived measures and key metrics for relational / multidimensional data model for the system, understanding reporting requirements, designing star schema data model. Extensively involved in requirement analysis.
• Extensively interacted wif user and involved in requirement gathering, prototyping and prepared various documents like Interface Requirement Document, Customer Requirement document, Data base design document, requirement traceability matrices etc.
• Designed the relational data model for operational data store and staging areas, Designed Dimension & Fact tables for data marts
• Extensively used Erwin to design Logical/Physical Data Models, relational database design.
• Conducted data modeling sessions for different user groups, facilitated common data models between different applications, participated in requirement sessions to identify logical entities.
• Extensively involved in normalization of data using all Normal Forms
• Used Data Abstraction to design flexible data model
• Extensively involved in various data modeling tasks including forward engineering, reverse engineering, complete compare, creating DDL scripts, creating subject areas, creating DDL scripts, publishing model to PDF and HTML format, generating various data modeling reports etc.
• Provided training on data model to different application group across the enterprise.
• Extensively used complex SQL queries for querying and analysis of data and implementing CRUD.
• Worked closely wif application development teams to ensure adherence to design specifications, proposed procedures, practices and standards. Extensively Worked wif DBA's in implementation of databases and data schemas.
• Extensively involved in creating, maintaining, updating documents like requirement document, database design document, System design document, naming standard procedures, SOPs etc.
• Extensively used PL/SQL programming in backend and front end Functions, Procedures, and Packages to implement business logics/rules. Extensively worked in SQL, PL/SQL, Query performance tuning, Created DDL scripts, Created database objects like Tables, Indexes, Synonyms and Sequences.

Confidential

Data Analyst /Modeler/ Administrator

Responsibilities:

• Extensively used ERWIN to design Logical/Physical Data Models, forward/reverse engineering, publishing data model to acrobat files
• Involved in DB Schema redesign and suggested and deployed new tables, which were denormalized to hold the vital data of the entire database, the task was accomplished by using optimized queries and the performance increased drastically wif a remarkable decrease in the number of lines of code and simplified business logic.
• Checking database Integrity and Optimizing Data, Reindexing tables for quick processing time.
• Involved in normalization process of Data using 1NF to 3NF
• Performing daily DBA routines such as monitoring the databases, performance tuning, connectivity issues, and upgrade strategies, capacity planning, backup and restoring the databases.
• Installing and Configuring SQL Server 2000.
• Maintaining the development, testing and staging databases.
• Planed and documented the disaster recovery, Backing data to tapes and securing offsite.
• Involved in Creating Securing the database, created Roles and granting privileges.
• Created User and Login, grating and revoking roles and privileges.
• Created DTS Packages and BCP to import data from MS Access, Excel spread sheets and Oracle Database to SQL Server.
• Developed DTS Packages and used Stored procedures for cleaning, transformation of data wif in Data warehouse.
• Developed Data Migration Procedures for replacement of MS-Access system wif newly designed SQL Server tables.
• Created views, triggers and stored procedures in SQL Server.
• Created Jobs, Users, and User Defined Data types in SQL Server for administering databases.
• Analyzing the existing stored procedures and rewrite them using the redesigned database schema.
• Providing technical assistance to troubleshoot Database related problems in Vision system.
• Preparing Data in requested format to be converted to new System.
• Cleaning Data wif Data Cleansing Tools like Accuzip, Mellisa Data.
• Created complex Crystal Reports which generated invoices sent to Members every month for renewal of their membership wif IMA.
• Created Star schema in Analysis server for development of OLAP Cube.
• Created OLAP Cube in Analysis server for Warranty Management System that has 14 dimensions.
• Created Reports using Crystal Reports 10/8.5.
• Developed dynamic report component using VB.Net, ADO.Net and XML, which takes parameters taking queries, stored procedures, layout of report.

Confidential

SQL Server Database Administrator

Responsibilities:

• Created views, triggers and stored procedures in SQL Server.
• Created OLAP Reports for Sales Analysis, Service Analysis, Sales Returns, Target vs. Achievement.
• Performing daily DBA routines such as monitoring the databases, performance tuning, connectivity issues, and upgrade strategies, capacity planning, backup and restoring the databases.
• Maintaining the development, testing and staging databases.
• Installing and Configuring SQL Server 2000.
• Created DTS Packages to import data from Excel spreadsheets.
• Performance tuning and optimization of queries.
• Developing and running scripts to maintain database integrity.
• Planning and implementation of database backup, recovery and support strategies.
• Secure Database wif proper rights and privileges for accessing database.
• Created DTS Packages and BCP to import data from MS Access, Excel spread sheets and Oracle Database to SQL Server.
• Developed DTS Packages and used Stored procedures for cleaning, transformation of data wif in Data warehouse.
• Developed Data Migration Procedures for replacement of MS-Access system wif newly designed SQL Server tables.
• Wrote scripts to migrate data from old database to the newly modified database.
• Possess heavy business requirements extraction and analysis, organizational and time management

Confidential

Data Developer/Designer

Responsibilities:

• Extensively interacted wif user for requirement gathering, Involved in analysis, design and enhancement of current system
• Developed triggers and stored procedures using Transact SQL and maintained database schema
• Created Logical/Physical Design of Database using Oracle Designer 2000.
• Created database objects like tables, indexes in Oracle, Involved in data transfer using BCP, Written utility programs using UNIX shell script
• Migrated data from MS-Access to Oracle and Used Import/Export Utility for Data Migration.
• Performed database administrative job of Security, Backup/recovery, ODBC connections etc.,