PROFESSIONAL SUMMARY:

• Over 7 years of working experience in IT as Data Analyst/SQL Server Developer in various domains, such as Healthcare and Financial Service Industries.
• Expert in Data Warehouse development starting from inception to implementation, with strong understanding of BI application design and development principles.
• Extensive experience in creating Tables, Views, Indexes, Stored Procedures, Complex Inner and Outer joins, Sub Query, Nested Query as well as analyzing and debugging existing Complex stored procedures.
• Hands on experience in using all kinds of SQL Server Constraints (Primary Keys, Foreign Keys, Defaults, Check, Unique etc.).
• Highly experienced in SQL querying with SQL Server 2008/2012, and excellent knowledge in Data Validation, Data Cleansing, Data Verification and identifying data mismatch for sense, consistency, accuracy and compliance standards.
• Experienced in writing SQL queries to validate data movement between different layers in data warehouse environment.
• Performed Data analysis and Data profiling using complex SQL on various sources systems.
• Excellent experience in troubleshooting test scripts, SQL queries, ETL jobs, data warehouse/data mart/data store models.
• Extensive experience in writing Complex Transact SQL Queries, Sub queries, Co - related sub queries, and Dynamic SQL queries etc.
• Expertise in designing SQL Server SSIS packages to import and transform data between databases and external data sources.
• Strong experience in Business and Data Analysis, Data Profiling, Data Migration, Data Conversion, Data Quality, Data Governance and Data Integration.
• Good knowledge of Data Marts, OLAP, Dimensional Data Modeling, Star Schema Modeling, Snow-Flake Modeling for Fact and Dimensions Tables using Analysis Services, with clear understanding of RDBMS concepts and constructing Relational Database according to business requirement.
• Experienced in various phases of Software Development life cycle (Analysis, Requirements gathering, Designing) with expertise in documenting various requirement specifications, functional specifications, Test Plans, Source to Target mappings, SQL Joins.
• Working knowledge of Teradata Financial Services Data Mode (FSDM).
• Good understanding of Medical claims data.
• Experience in creating Ad-hoc reports, data driven subscription reports by using SQL.
• Hands on experience in Normalization and De-Normalization techniques for optimum performance in relational and dimensional database environments.
• Experience in implementing Data warehousing solutions involving Dimension modeling and Snow flake schema implementation (3 NF).
• Analysis of functional and non-functional categorized data elements for data profiling and mapping from source to target data environment. Developed working documents to support findings and assign specific tasks.
• Have good exposure on working in offshore/onsite model with ability to understand and/or create functional requirements working with client. Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities.
• Strong experience in interacting with stakeholders/customers, gathering requirements through interviews, workshops, and existing system documentation or procedures, defining business processes, identifying and analyzing risks using appropriate templates and analysis tools.
• Excellent interpersonal skills and leadership abilities. Fast learner with excellent analytical and communication skills.

TECHNICAL SKILLS:

Languages: T-SQL, PL/SQL, SQL, R, C, C++, XML, HTML, DHTML, HTTP, Shell Scripting, Matlab

Databases: SQL Server 2014/2012/2008/2005/2000 , MS-Access, Oracle 11g/10g/9i and Teradata

DWH / BI Tools: SSIS, SSRS, SSAS, Business Intelligence Development Studio (BIDS), Visual Studio, Crystal Reports, Informatica 6.1.

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

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, Crystal Reports, Power Pivot, ProClarity, Microsoft Office, Excel Power Pivot, Excel Data Explorer, Tableau .

PROFESSIONAL EXPERIENCE:

Confidential, Cary, NC

Data Analyst

Responsibilities:

• Supported multiple OLTP / transactional and data warehousing development projects.
• Document the complete process flow to describe program development, logic, testing, and implementation, application integration, coding.
• Performed Data Analysis, Data Migration and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Manipulating, cleansing & processing data using Excel, Access and SQL.
• Responsible for loading, extracting and validation of client data.
• Analyzing raw data, drawing conclusions & developing recommendations and writing SQL scripts to manipulate data for data loads and extracts.
• Involved in the Analysis, design, testing and Implementation of Business Intelligence solutions using Data Warehouse, ETL, OLAP, Client/Server applications.
• Involved in Troubleshooting, resolving and escalating data related issues and validating data to improve data quality.
• Conducted data profiling to insure that the available data could support business needs.
• Used Erwin model mart for effective model management of sharing, dividing and reusing model information and design for productivity improvement. Used Model Manager Option in Erwin to synchronize the data models in Model Mart approach.
• Worked on Informartica Data Quality tool for monitoring Production systems for Data Anomalies and resolve issues.
• Designed ER diagrams (Physical and Logical using Erwin) and mapping the data into database objects.
• Developing data analytical databases from complex financial source data, as well as performing daily system checks. Data entry, data auditing, creating data reports & monitoring all data for accuracy. Designing, developing and implementing new functionality.
• Monitoring the automated loading processes. Advising on the suitability of methodologies and suggesting improvements.
• Liaising with end-users and 3rd party suppliers.
• Involved in defining the source to target data mappings, business rules, and data definitions.
• Responsible for defining the key identifiers for each mapping/interface.
• Responsible for defining the functional requirement documents for each source to target interface.
• Document, clarify, and communicate requests for change requests with the requestor and coordinate with the development and testing team.
• Coordinate with the business users in providing appropriate, effective and efficient way to design the new reporting needs based on the user with the existing functionality.
• Document data quality and traceability documents for each source interface.
• Involved in Data warehouse and Data mart design.
• Experience with various ETL, data warehousing tools and concepts.
• Worked with internal architects and, assisted in the development of current and target state data architectures.
• Worked with project team representatives to ensure that logical and physical ER/Studio data models were developed in line with corporate standards and guidelines.
• Also worked on reducing impact of low quality and/or missing data on the performance of data warehouse client.
• Identified design flaws in the data warehouse.

Environment: SQL/Server, Oracle10 &11g, MS-Office, Erwin, Teradata, Enterprise Architect, Informatica, Hadoop, XML, Informatica.

Confidential, Parsippany, NJ

Data Analyst

Responsibilities:

• Worked on Medical claims data from source to integrate into the data warehouse.
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Writing queries and stored procedures in PL/SQL to fetch data from the OLTP system and executed at regular intervals of time. 
• Prepared in scope SQLs for ETL to extract data from Source systems production database to the conversion built environment.
• Wrote and executed SQL queries to verify that data has been moved from transactional system to DSS, Data warehouse, data mart reporting system in accordance with requirements.
• Identified reference data fields from source systems and value map it to the target values.
• Modified PL/SQL scripts to validate and load data into interface tables. The backend was in Oracle and database operations were handled using stored procedures. 
• Gathered the various reporting requirement from the business analysts. 
• Reverse Engineering the reports and identified the Data Elements (in the source systems), Dimensions, Facts and Measures required for reports. 
• Designed STAR schemas for the detailed data marts and Plan data marts involving shared dimensions (Conformed).
• Worked with the ETL team to document the transformation rules for data migration from OLTP to Warehouse environment for reporting purposes. 
• Worked with the Business Analyst, QA team in their testing and DBA for requirements gathering, business analysis, testing and project coordination. 
• Generated comprehensive analytical reports by running SQL queries against current databases to conduct data analysis. 
• Delivered file in various file formatting system (ex. Excel file, Tab delimited text, Coma separated text, Pipe delimited text etc.)

Environment: Erwin 7.2, DB2, Teradata, Informatica8.1, Power Designer, Clear Quest, Cognos, Crystal reports, TOAD, PL/SQL, ER Studio, Lotus Notes Windows 2003, MS Excel, Word and Access

Confidential, Somerset, NJ

Data Analyst

Responsibilities:

• Collaborate with data modelers, ETL developers in the creating the Data Functional Design documents.
• Provide inputs to development team in performing extraction, transformation and load for data marts and data warehouses.
• Worked with Development DBA to assist and support developers with SQL performance tuning, query tuning and code reviews.
• Performed in-depth analysis in data & prepared weekly, biweekly, monthly reports by using SQL, MS Excel, and MS Access.
• Created DML code and statements for underlying & impacting databases.
• Worked on database features and objects such as partitioning, change data capture, indexes, views, indexed views to develop optimal physical data model.
• Interact with computer systems end-users and project business sponsors to determine, document, and obtain signoff on business requirements.
• Document various Data Quality mapping document, audit and security compliance adherence.
• Define the list codes and code conversions between the source systems and the data mart.
• Work with the business and the ETL developers in the analysis and resolution of data related problem tickets.

Environment: MS Excel, MS Access, Oracle 10g, UNIX, Windows XP, SQL, PL/SQL, Power Designer,, Visio, VBA

Confidential, Newark, NJ

Programming Analyst

Responsibilities:

• Involved in the design of the overall database using Entity Relationship diagrams.
• Define the list codes and code conversions between the source systems and the data mart.
• Responsible for defining the key identifiers for each mapping/interface
• Wrote triggers, menus and stored procedures in PL/SQL.
• Involved in developing interactive forms and customization of screens using Forms 4.5.
• Involved in building, debugging and running forms.
• Involved in Data loading and Extracting functions using SQL*Loader.
• Designed and developed all the tables, views for the system in Oracle.
• Designing and developing forms validation procedures for query and update of data.

Environment: Oracle 8.0, SQL*plus, SQL*Loader, PL/SQL, Forms 4.5, Reports 2.5