SUMMARY:

• Sr. IT Consultant with 7+ years IT experience in the Healthcare, Banking, and eCommerce Sector
• Understand business requirements to translate into concise deliverables by utilizing RDBMS tools for data analysis, report, and important decision making.
• Experience in Business and Data Analysis
• Proficient in SQL Programming
• Skilled in planning and execution of special projects during assignment.
• Enthusiastic, creative and willing to assume increased and challenging responsibilities.
• Experience in data warehousing and business Intelligence using ETL tools like Informatica, SQL Server, IBM Cognos Framework Manager, Business Objects SSRS, and SSIS
• Adept in writing SQL code in Teradata, Oracle and MS SQL Server
• Proficiently performed Data Modeling and Data Migration using ERwin 3.x/4.0x to demonstrate Dimensional Data Modeling, Star Schema, Snowflake, Fact and Dimension table, and Physical and Logical Data Modeling functionalities.
• Performed Data migration for OLTP applications to a new customized in - house Applications
• Experience with Teradata for creating datamarts (FastExport, Fastload and MultiLoad utilities)
• Adept in working with TOAD, SQL Assistant, and BTEQ tools.
• Experience in working with IBM Cognos Report studio for performance assessment and management.
• Prepared SQL query datasets and generated ad-hoc reports, tables, listings and graphs according to guidelines lay down in statistical analysis.
• Strong knowledge of T-SQL including TRY, CATCH statements to support exceptions.
• Experienced with defining and building Business Intelligence and Dashboards, Balanced ScoreCarding, Query & Analysis reports using Tableau
• Automated Teradata utility scripts using UNIX
• Acquired strong skills in computer and office administration skills and possess vast knowledge of Microsoft Office Suite (Word, Excel, PowerPoint, Access, and Visio)
• Experience in Data Extraction, Transformation, and Loading (ETL)
• Understand Software Development Life Cycle (SDLC) methodologies like Waterfall and Agile (specifically SCRUM)
• Acquired Analytic and Research writing skills when conducting surveys, and analyzing results

TECHNICAL SKILLS:

Operating Systems: Win XP, Vista, 7 Professional, Windows 8, Windows Server 2003, 2008 (32 and 64 bit), UNIX, Ubuntu - Linux (Red hat), Solaris

Databases: SyBase, MS SQL Server 2005,2008 and 2012, Teradata 12/13, Oracle 9i, 10g, 11g, T-SQL, IBM DB2/UDB

ETL/Other Tools: SAS Base 9.x, Informatica Power Center 8.6.1/9, SSIS (Visio Studios 2010 Shell), SSRS, Erwin data Modeler, IBM Cognos 10 BI, IBM Cognos Framework Manager 8

Test Tools: HP Quick Test Professional 10/11, HP Quality Center 10

Query Tools: Microsoft Visual Studio, Oracle SQL Developer, SQL Management Studio, Teradata SQL Assistant, SQL Plus, Teradata-BTEQ

Scripting: SQL, PL/SQL

Language: C#, Java, ASP.NET MVC, Java Script, VB.Net, PHP, C++, CSS, HTML 5.0

Applications: Microsoft Office (word, excel, PowerPoint), Microsoft Access, Microsoft project

WORK EXPERIENCE:

Confidential, Carmel, IN

Sr. EDI Software Developer

Responsibilities:

• Created and modified SQL stored procedures that processed EDI clinical claims for healthcare providers and health plans.
• Reviewed and made recommendations on claims billing, payment and reconciliation process in accordance to EDI format
• Built and modified existing SQL stored procedures that processed members’ eligibility and verification under various health plans
• Generated ad-hoc reports daily that met the requirements of business owners, reconciliations analysts and product delivery managers (PDM) usi ng SSRS.
• Deployed SSIS packages that extracted data from source databases to text files,
• Created numerous Temporary, Volatile, derived and Permanent tables for EDI file processing
• Actively engaged in daily scrum meetings
• Reviewed outbound and inbound EDI files to prevent errors and improve efficiency
• Summarized large amounts of information and presented logical recommendations.
• Created permanent formatted SQL dataset for processing data, data analysis and statistical analysis.
• Analyzed and created the SQL stored procedures/functions that processed data and populated from source to destination tables and vice-versa.

Environment: SPEEDI (In-house Application), TFS, Microsoft Visual Studios 2012, Microsoft SQL Server 2008, IBM Sterling, Microsoft BIDS, IHIS, Microsoft Office Products (Word, Excel, PowerPoint), ASP.NET MVC

Confidential, Indianapolis, IN

Sr. Business/ Data Reporting Analyst

Responsibilities:

• Observed and gathered business requirements, documented pertinent requirements and performed extensive Data analysis of customers to determine Entity-Relationship between products and service installations and the business process management adhered.
• Created ad-hoc reports daily that met the requirements of the data cleaning crew.
• Setup meetings and conference calls with project manager and business analysts about the roadmap of the project phases.
• Interacted with business analysts to identify information needs and business requirements for Cognos Reports.
• Wrote and analyzed numerous test cases relative to the functionality of the new Application.
• Monitored and administered permissions to various users/groups running the Cognos reports.
• Interacted with business users and UAT team to determine what data was essential to migrate to the new system.
• Engaged OLTP functionalities (Online Transactional Processing) by data analysis and SQL execution.
• Team lead on data mapping and validations that created a more comprehensible data dictionary for data migration.
• Created and Redesigned new, existing report solution using IBM Cognos Frame Work Manager and IBM Cognos Report Studio to improve the performance of the reports.
• Summarized large amounts of information and presented logical recommendations.
• Created permanent formatted SQL dataset for processing data, data analysis and statistical analysis.
• Analyzed and created the T-SQL stored procedures/functions that processed data and populated from source to destination tables and vice-versa.
• Validated the test data in the Sybase database located in the test servers before running SQL queries in the production server.
• Created numerous Temporary, Volatile, derived and Permanent tables.
• Transferred technical knowledge specific to Cognos tools and the existing data model to other team members

Environment: SBN, ASTEA, Microsoft Office Products (Word, Excel, PowerPoint), Microsoft Access, T-SQL, IBM Cognos Connection 10.2.1, IBM Cognos Frame Work Manager 10, SQL Server Management Studio, Oracle SQL Developer, OLTP, API environment, Sybase

Confidential, Sparks, NV

Business Data Analyst

Responsibilities:

• Observed and gathered business requirements, documented pertinent requirements and performed extensive data analysis of consumer data.
• Created reports daily, which was used to improve the outcomes of the department.
• Engaged OLAP functionalities (Online Analytical Processing) by data analysis and SQL execution
• Created ETL processes utilizing Teradata utilities such as Fast-load, Multi-Load, and SQL Assistant.
• Performed data mapping, validation and modeling.
• Developed a planned approach to maintain month long segmentation process.
• Responsible for interacting with business partners to identify information needs and business requirements for Cognos Reports.
• Redesign of reporting solution using SSRS
• Summarized large amounts of information and presented logical recommendations.
• Performed calculations for expected results.
• Created permanent formatted SAS dataset and used SAS/BASE and its tools for processing data, data analysis and statistical analysis.
• Validated the test data in DB2 tables on Mainframes and on Teradata using SQL queries.
• Created numerous Temporary, Volatile, derived and Permanent tables.
• Transferred technical knowledge specific to Cognos tools and the existing data model to other team members
• Interacted with Business Analysts in order to understand their needs for data loading.
• Suggested improvements of table creation to users who had skewed numbers.
• Created BTEQ script automation by using UNIX and FTP.
• Designed data in SQL SSIS and reports in SSRS.
• Conducted Teradata performance tuning.
• Created reports with Cognos at Business Analysts requests.
• Used Agile Methodology in collecting requirements and presenting them on the SCRUM meetings for development.

Environment: Rational Enterprise Suite (Rose, RequisitePro, ClearCase, ClearQuest), Microsoft Office Products (Word, Excel, PowerPoint), T-SQL, Cognos BI Suite, Visual Basic, SQL, SQL Server, Oracle, C#.Net, XML, Teradata, UNIX, OLAP, Power Centre, UAT.

Confidential, Los Angeles, CA

Business / Data Analyst

Responsibilities:

• Involved in all phases of SDLC from requirement, design, development, testing, training and rollout to the field user and support for production environment
• Worked with the Business Analysts and the Quality Analysts team for validation and verification of the development
• Involved in designing relational models for ODS and datamart.
• Performed Data Quality Analysis to determine cleansing requirements.
• Responsible for ETL (Extract, Transform and Load) processes using Informatica power center
• Extracted data from flat files in Sybase, DB2, Oracle and MS SQL Server 2008 and SQL Server 2005/ 2008 to load data into target database.
• Developed stored functions using T-SQL for use in SQL Server databases
• Wrote detailed specifications for various reports generated using Cognos
• Using derived tables, sub-queries, correlated sub-queries to fetch data from different tables on Teradata platform.
• Proficiently used Informatica to load data from fixed width and delimited Flat files.
• Worked with Repository Manager, Designer, Workflow Manager and Monitor to import and load Source Definitions using Source Analyzer and Target Definitions using Warehouse Designer.
• Took the first look on the Cognos report to validate the conformance and provided alternate design solutions to combat the performance issues.
• Substantial report development experience utilizing SQL Server Reporting Services (SSRS), Cognos Impromptu, and Microsoft Excel
• Experience in using SAS to import data into and export data from various tables.
• Complex mappings using corresponding Source, Targets and Transformations like update strategy, lookup, stored procedure, SQL, sequence generator, joiner, aggregate, and expression transformations in extracting data in compliance with the business logic.
• Created SSIS Packages to migrate slowly changing dimensions.
• Extensively used Informatica Power center and created mappings using transformations to flag the record using update strategy for populating the desired slowly changing dimension tables.

Environment: Oracle, Microsoft SQL Server, MS Access 2000, Sybase, Cognos Reporting Studio, SSIS, SSRS, MS Visio,UML, Rational Rose, Requisite Pro, Clear Case 2002, Hyperion, Rational Clear Quest 2002, MS Office suite, MS Visio 2003.

Confidential, Minneapolis, MN

Data Analyst

Responsibilities:

• Performed Data Analysis, created gap analysis document, and performed data quality Checking.
• Created numerous temporary, derived, permanent and volatile tables.
• Used Teradata OLAP functions like random, qualifies, top n, csum, sample and random.
• Teradata SQL performance tuning.
• Reviewed the data model and reporting requirements for Cognos Reports with the Data warehouse/ETL and Reporting team.
• Customized Cognos Connection with appropriate reports and security measures
• Extracted data from existing data stores, Developing and executing departmental reports for performance and response purposes by using oracle SQL, SAS, procedures, packages, functions, database triggers.
• Created pivot tables in Excel by getting data from Teradata and Oracle.
• Created Transformations and Mappings using Informatica Designer and processing tasks using Workflow Manager to move data from multiple sources into targets.
• Maintained data consistency, database integrity and reported instances of data corruption.
• Interacted with end-users and business analysts to identify and develop business requirements and transform it into technical requirements and ultimately responsible for delivering the solution.
• Involved in gathering, analyzing, and documenting business requirements, functional requirements and data specifications for Business Objects reports.

Environment: MS Project, Excel, PowerPoint, Outlook, Access, MS Office, UNIX, Teradata, IBM Cognos, UAT, Windows NT/XP, Oracle SQL, MS SQL Server, Sybase, EVPN, SSAS