SUMMARY

• Over 7+ years of professional experience as a Data Analyst, Configuration Management Analyst in IT Industries.
• Strong Data Warehousing, Data Marts, Data Analysis, Data Organization, Metadata and Data Modeling experience on RDBMS databases.
• Strong expertise in Confidential sector primarily retail, commercial, auto, Secondary Mortgage.
• Extensive knowledge in Designing, Developing and implementation of the Data marts, Data Structures using Stored Procedures, Functions, Data warehouse tables, views, Materialized Views, Indexes at Database level using PL/SQL, Oracle.
• Excellent knowledge of HIPAA (Health Insurance Portability and Accountability Act) transaction codes such as 270/271 (inquire/response health care benefits), 276/277 (claim status), 470 (benefit codes), 835 (payment or remittance advice), 837 (health care claim) and 834 (benefit enrollment).
• Excellent hands on experience in relational data modeling.
• Created views for reporting purpose which involves complex SQL queries with sub - queries, inline views, multi table joins, with clause and outer joins as per the functional needs.
• Good Working experience in Teradata, Ab Initio, Business Objects, Tableau, Crystal Reports, PL/SQL, SAS, MS Excel, MS Access
• Proficient in Teradata SQL coding, using Teradata BTEQ utility, Working Knowledge on Teradata / Parallel Transport utility/TPUMP. (TPT) coding.
• Good hands on experience in UNIX shell scripting.
• Developed and maintained MS Access database.
• Worked with Tableau and SAP Business Objects by creating interactive Dashboards.
• Experienced in QlikView Server and Publisher maintenance - Creating scheduled jobs for QVD extracts and report reloads.
• Good Experience on Data archival process to SAS data sets and flat files.
• Created Datasets using SAS proc sql from flat file, .csv files,, |, etc. through UNIX dev box and Wrote Macros, functions, etc. in SAS 9.2 and SAS 9.3.
• Strong experience on Base SAS, SAS/Stat, SAS/Access, SAS/Graphs and SAS/Macros, SAS/ODS and SAS/SQL in Windows Environment.
• Well versed with HIPAA, Facets, claim adjustments, claim processing from point of entry to finalizing, claim review, identifying claims processing problems, their source and providing corresponding solutions.
• Proficient in design and development of various dashboards, reports utilizing Tableau Visualizations like Pareto Charts, Funnel Charts, Bar Graphs, Scatter Plots, Pie-Charts, Donut Charts, Bubble Charts, Funnel Charts, Heap Maps, Tree Maps, Geographic Visualization and other making use of actions, other local and global filters according to the end user requirement
• Extensive experience in developing reports, dashboards using techniques for guided analytics, interactive dashboard design, and visual best practices to convey the story inside the data by integrating various reporting components from multiple sources.
• Enthusiast and Experienced QlikView developer- the pioneered in-memory Dash boarding tool.
• Maintain ethical standards with databy ensuring databaseintegrityas well as compliance with legislative, regulatory and accrediting requirements.
• Experienced in performance tuning and optimization for increasing the efficiency of the scripts on large database for fast data access, conversion and delivery.
• Experience creating design documentation related to system specifications including user interfaces, security and control, performance requirements and data conversion.
• Extensively Worked in Agile delivery environments and all phases of Software Development Life Cycle (SDLC).
• Team Player as well as able to work independently with minimum supervision, innovative & efficient, good in debugging and strong desire to keep pace with latest technologies.
• Excellent Communication and presentation skills along with good experience in communicating and working with various stake holders.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server

TECHNICAL SKILLS

ETL Tools: Informatica, SSIS, DataStage, Ab Initio

Data Modeling: Erwin

Databases: Teradata, Oracle, MS SQL Server, MS Access, DB2

OLAP Tools: Micro strategy OLAP Suite, Cognos, Business Objects, Tableau

Languages: SQL, PL/SQL, Unix Shell Scripts

Operating Systems: Windows, Unix, Sun Solaris, Linux

Testing Tools: HP ALM and Quality Center

Domain: Banking, Finance, Healthcare

PROFESSIONAL EXPERIENCE

Confidential, Richmond VA

Sr. Data Analyst

Responsibilities:

• Acted as a liaison between the IT developers and Business stake holders and was instrumental in resolving conflicts between the management and technical teams.
• Worked with business users for requirement gathering, understanding intent and defining scope and am responsible for project status updates to Business users.
• Performing analysis and providing summary for the business questions, initiating proactive investigations into data issues that impact reporting, business analysis or program execution.
• Created views for reporting purpose which involves complex SQL queries with sub-queries, inline views, multi table joins, with clause and outer joins as per the functional needs in the Business Requirements Document (BRD).
• Configured workflows, writing jobs in Anthill Pro for performing automated builds and deployments.
• Worked with AWS Cloud platform and its features which includes EC2, VPC, RDS, EBS, S3, CloudWatch, Cloud Trail, CloudFormation and Autoscalling etc.
• Used ANT a build tool on java projects for the development of build artifacts on the source code.
• Involved in performance tuning of slowly running SQL queries and created indexes, constraints and rules on database objects for optimization.
• Developed functions, views and triggers for automation.
• Used AWS command line client and management console to interact with AWS resources and APIs.
• Responsible for building and maintaining SQL scripts and creating Indexes for various fast and efficient reporting processes.
• Worked on AWS Elastic Beanstalk to deploy, monitor, and scale an application
• Create new EC2 instance in AWS, allocate volumes and giving Provisionals using IAM.
• Assisted in mining data from the SQL database that was used in several significant presentations.
• Assisted in offering support to other personnel who were required to access and analyze the SQL database.
• Understanding the requirements from the users. Suggested better way of presenting charts, which are accepted and successfully implemented in the dashboards.
• Performed data analysis and data profiling using complex SQL on various sources systems including Oracle and Teradata.
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Coordinated project activities between clients and internal groups and information technology, including project portfolio management and project pipeline planning and Worked in close collaboration with the Project Management Office and business users to gather, analyze and document the functional requirements for the project.
• Responsible for development of workflow analysis, requirement gathering, data governance, data management and data loading.
• Analyzing and documenting data flow from source systems managed the availability and quality Of Data.
• Root cause analysis of data discrepancies between different business system looking at Business rules, data model and provide the analysis to development/bug fix team.
• Setup the Jenkins jobs for Continuous integration process and to execute test cases.
• Evaluated existing practices of storing and handling important financial data for compliance and Ensured corporate compliance with all billing, credit standards and direct responsibility of accounts receivables and supervision of accounts payable.
• Have setup data governance touch points with key teams to ensure data issues were addressed promptly.
• Responsible for facilitating UAT (User Acceptance Testing), PPV (Post Production Validation) and maintaining Metadata and Data dictionary.
• Responsible for source data cleansing, analysis and reporting using pivot tables, formulas (v-lookup and others), data validation, conditional formatting, and graph and chart manipulation in Excel.
• Actively involved in data modeling for the QRM Mortgage Application migration to Teradata and developed the dimensional model.
• Created views for reporting purpose which involves complex SQL queries with sub-queries, inline views, multi table joins, with clause and outer joins as per the functional needs in the Business Requirements Document (BRD).
• Conducted data cleaning, manipulation, modification and combination using variety of SAS steps and functions. Analyzed, tested, documented and maintained SAS programs and macros to generate SAS datasets, spreadsheets, data listing, tables and reports.
• Responsible for generating Financial Business Reports using SAS Business Intelligence tools (SAS/BI) and also developed ad-hoc reports using SAS Enterprise Guide
• Using Tableau Desktop, created multiple rich dashboards visually telling stories of the business status, strength & weakness, potentials etc. for the client at a glance, also interact with data as necessary
• Scheduled data refresh on Tableau Server for weekly and monthly increments based on the new changes to ensure that the views and dashboards were displaying the changed data accurately
• Utilized advance features of Tableau software like to link data from different connections together on one dashboard and to filter data in multiple views at once.
• Generated guided navigation links for Interactive dashboards in Tableau.
• Worked in coordination with clients for feasibility study of the project in Tableau and drawing up the timelines and DB Teams for designing the database as per project requirement.

Environment: Qlikview,Agile, Teradata, BTEQ, Fast Load, Fast Export, Multiload, Oracle, Unix Shell Scripts, SQL Server 2005/08, SAS, PROC SQL, Tableau 9.x/8.x (Desktop/ Server), MS Office Tools, MS Project, Windows XP, MS Access, Pivot Tables

Confidential, Hartford CT

Responsibilities:

• Perform Daily validation of Business data reports by querying databases and rerun of missing business events before the close of Business day.
• 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.
• Designed and developed Tableauvisualization solutions by connecting to Google Analytics, Oracle and SQL databases.
• Used Amazon IAM to grant fine-grained access to AWS resources to users. Also managed roles including permissions of users to AWS account through IAM.
• Gathered Business requirements by interacting with the business users, defined subject areas for analytical data requirements.
• Developed executive dashboards in QlikView delivered through the web, enabling to measure the performance of the business with analytical capabilities
• Created Datasets using SAS proc sql from flat file.
• Optimizing the complex queries for data retrieval from huge databases.
• Root cause analysis of data discrepancies between different business system looking at Business rules, data model and provide the analysis to development/bug fix team.
• Lead the Data Correction and validation process by using data utilities to fix the mismatches between different shared business operating systems.
• Conduct downstream analysis for different tables involved in data discrepancies and arriving at a solution to resolve the same.
• Extensive data mining of different attributes involved in business tables and providing consolidated analysis reports, resolutions on a time to time basis.
• Responsible for creating reports using Tableau desktop and publishing reports to Tableau server.
• Performed data analysis and data profiling using complex SQL
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Verifying data quality after every deployment and perform extensive analysis for the data variance pre and post implementation.
• Utilize data to prepare and conduct quality control with SAS.
• Provide programming parameters to technical staff for all data extracts.
• Ensure to partner with internal teams to prepare analytics as well as validate results with SAS.
• Conducted data cleaning, manipulation, modification and combination using variety of SAS steps.
• Developed and maintained MS Access database.
• Created an MS Access database to collect data systems in order to provide lists, status reports and management overview reports.
• Managed all data related aspects of multiple directory projects through various stages of production.
• Defined the periodic extraction and performed formatting of data from multiple sources and laid out basic queries and reported required by the customer.
• Analysis of CDE (Critical data elements) in business process, data conversion, data movement and Data integrity check before delivering data to operations, financial analyst for uploading to databases in accordance with IM policy compliance.
• Extensively involved inUser Acceptance Testing (UAT) and Regression testing.
• Verifying data quality after every deployment and perform extensive analysis for the data variance pre and post implementation.
• Involved in Data Reconciliation Process while testing loaded data with user reports.
• Documented all custom and system modification
• Worked with offshore and other environment teams to support their activities.
• Responsible for deployment on test environments and supporting business users during User Acceptance testing (UAT).

Environment: DataStage 8.1, Oracle 10g, DB2, Sybase, TOAD, Tableau9.x/8.x (Desktop/ Server), Cognos 8.0, Business objects,SQL Server 2008, TSYS Mainframe, SAS PROC SQL, SQL, PL/SQL, ALM/Quality Center 11, QTP 10, UNIX, Shell Scripting, XML, XSLT.

Confidential, Indianapolis IN

Data Analyst

Responsibilities:

• Analyze the requirement and prepare the technical spec and develop the SAS program as needed.
• Responsible for gathering data migration requirements.
• Extract theMedical claims RX claims, member data andproviderdatato create analysis data sets and model data sets.
• Identified problematic areas and conduct research to determine the best course of action to correct the data.
• Analyzed problem and solved issues with current and planned systems as they relate to the integration and management of order data.
• Implement data cleansing, validation, reconciliation, transformation and quality assurance using SAS base, Proc Freq/Mean andProc SQL. Data sets manipulation and integration to data analysis and report generation.
• Analyzed reports of data duplicates or other errors to provide ongoing appropriate inter-departmental communication and monthly or daily data reports.
• Monitor for timely and accurate completion of select data elements
• Identify, analyze, and interpret trends or patterns in complex data sets
• Monitor data dictionary statistics
• Developed logical and physical data models that capture current state/future state data elements and data flows using Erwin.
• Extensively used Erwin tool in Forward and reverse engineering, following the Corporate Standards in Naming Conventions, using Conformed dimensions whenever possible
• Involved in data mapping and data clean up.
• Involved with data profiling for multiple sources and answered complex business questions by providing data to business users.
• Involved in analyzing and adding new features of Oracle 10g like DBMS SHEDULER, Create Directory, Data pump, CONNECT BY ROOT in existing Oracle 9i application
• Enhance smooth transition from legacy to newer system, through change management process.
• Archived the old data by converting them in to SAS data sets and flat files.
• Analyzed and maintained SAS programs and macros to generate SAS datasets.
• Trained team members in PL/SQL and provided Knowledge Transfer sessions on Finance and Banking domains.
• Planned project activities for the team based on project timelines using Work Breakdown Structure.
• Created Technical Design Documents, Unit Test Cases.
• Involved in Test case/data preparation, execution and verification of the test results
• Reviewed PL/SQL migration scripts.
• Coded PL/SQL packages to perform Application Security and batch job scheduling.
• Created user guidance documentations.
• Designed and developed Tableauvisualization solutions by connecting to Google Analytics, Oracle and SQL databases
• Developed Tableau dashboards pertaining to Revenue and Sales monitoring using Tableau 8.x.
• Created reconciliation report for validating migrated data.

Environment: SAS EG, Qlikview 10.x, UNIX, Shell Scripting, XML Files, XSD, XML Spy 2010, SAS PROC SQL, Cognos 8.0, Oracle 10g,Teradata, Sybase, Mercury Quality Center 10, QTP 10, Toad, Autosys.

Confidential, Buffalo NY

Data Analyst

Responsibilities:

• Provided Data Analysis, gathered Business requirements and Designed and developed various Business Reports
• Developed various BTEQ scripts to create business logic and process the data.
• Generated weekly, bi weekly, monthly reports with help Oracle, Teradata, SQL, BTEQ, MS Access, MS Excel, SAS.
• Worked on loading of data from several flat files sources to Staging using Teradata MLOAD, FLOAD and Tpump.
• Query optimization (explain plans, collect statistics, Primary and Secondary indexes).
• Assisted IT developers and non IT developers (Database Analysts) with Teradata Utilities.
• Large volume of Mainframes data is extracted and converted into SAS DATA sets and then converted into Oracle tables from remote UNIX and Windows environments by writing the Base SAS programs
• Converted the flat files like text files, excel files into a SAS data sets by writing the DATA step programs in SAS Base
• Monitoring the existing code performance and to change the code for better performance.
• Performed data validations, Data integrity before delivering data to operations, financial analyst.
• Experience in database monitoring and data stewardship.
• Identifying root cause problems and providing solutions..
• Developed SQL queries for Extracting data from production database and built data structures, reports.
• Designed, Developed Ad-hoc reports as per business analyst, operation analyst, project manager data request.
• Performed various data pull from Teradata One View Data warehouse using SQL Assistant and Bteq.
• The SQL Assistant has been used to query the database objects to validate the data quality.
• Designed and Developed Adhoc reports by extracting data from Oracle PCARD Data warehouse using SQL Plus.
• Used Fast Exports to generate Flat files after the Change data capture has been accomplished which in turn creates a loadable file that is used to load the database
• Analyzed data by pulling data from data warehouse into MS Excel and build graphs

Environment: Teradata, SQL Developer, NCR Teradata utilities (BTEQ, FastLoad, Fast Export) 6.01, Oracle, SQL, PL/SQL, DB2,UNIX, Windows 2000/NT UNIX, SAS 9.1.3, SQL Assistant, SAS PROC SQL

Confidential, Memphis TN

Business/Data Analyst

Responsibilities:

• Built the Forms for application using various form modules and windows.
• Participated in gathering Business Requirements and designed the project according to the Business requirement specifications.
• Written PERL scripts and UNIX Shell Scripts for various data comparison and data parsing needs.
• Conducted Bug Review meetings for update on defects from development team and retesting of bug fix. Worked with developers to fix faults found in the structure and functionality of the application.
• Prepared daily/weekly bug status reports highlighting bug fix metrics and tracked the progress of test cycles in Quality Center
• Conducted Training & Knowledge Transfer Sessions on new applications to QA Analysts
• Expertise in code reviews. Expertise in security issues of client/server technologies.
• Designed the screens and layout using Visual Basic 5.0.
• Used SQL*Plus for updating the database and for data retrieval.
• Performed unit testing, manual testing of the processes to check the integrity.
• Involved in the implementation, testing and maintenance of the system.
• Run batch jobs for loading database tables from flat files using SQL*Loader
• Developed UNIX Shell scripts to automate repetitive database processes
• Used Clear Quest for defect tracking and reporting, updating the bug status and discussed with developers to resolve the bugs.

Environment: Oracle, SQL*Plus, SQL, Test Director, TOAD, Rational Clear Quest, Clear Case, SQL Server 2000, PL/SQL, Visual Basic 6.0, XML, XSLT, Java and UNIX, Shell scripting.