SUMMARY

• 5 + years of experience indata analysis with SQL Server using Business Intelligent Tools SSIS, SSAS, SSRS in Financial, Healthcare and Banking industries
• Experience working in Healthcare. Proficient in retrieving data from EHRs.
• Strong hands on experience in writing SQL queries with databases including Oracle, SQL server, and DB2 on Windows/ Unix/ Linux platform.
• Familiar with Software Development Life Cycle(SDLC) methodology like waterfall and Agile and experienced with all phases of SDLC involving requirement analysis, system design, implementation and testing.
• High level knowledge of database management system physical implementation, including tables, joins and views.
• Experienced in performing data profiling of source system and data mapping from source to a data warehouse model.
• Strong experience in creating various types of reports like parameterized, conditional, table, matrix and chart using SSRS.
• Excellent experience in performing ETL process (extract, transform and load data) using SSIS package.
• Experience in designing ETL processes and system development life cycle procedures for many large data warehouse projects.
• Architected ETL and data movement strategies for conversion of large legacy healthcare system.
• Able to read EDI files, especially 837, 835 and files
• Experienced in various Healthcare areas like Enrollment, Benefits, Claims, Medicare, and implementation of HIPAA key EDI transactions.
• Proficient in performing multiple data transformation provided by SSIS such as data conversion, conditional split, merge and union all.
• Experienced in performing data cleansing using SAS and SSIS
• Expertise in using commercial analytics software such as Tableau and SPSS to perform data analysis and pinpoint data discrepancy.
• Expertise in Cognos Business Intelligence reporting and planning.
• Strong experience in assisting the design of testing activities and participating in data validation during QA activities.
• Good knowledge of defect development process, test plan, test criteria, test case, and various test types such as GUI Test, Integration Test, and Beta Test.
• Experienced in cooperating with BA to create business requirement document, functional and non - functional requirement document and use case.
• Experience in business requirement gathering that would best suit the needs of technical architectural development process.
• Identify, analyze, and interpret trends or patters in complex datasets and present complex information in an understandable and compelling manner.
• Strong analytical and problem solving skills with the ability to identify and present solutions and recommendations to both technical and non-technical audiences.
• Uniquely skilled at working in collocated and large distributed teams, participating in global projects, and establishing relationships with varied business and IT functions.

TECHNICAL SKILLS

Operating System: Windows 7, Windows XP, Unix, Linux, MAC OS

Networking: TCP/IP, LAN, VAN, Routers, Switches, Hubs, Servers

Microsoft Office package: Microsoft Word, Excel, Power Point, Outlook, Access

Database: MySQL, Microsoft SQL Server, Oracle

Programming Language: Visual Basic, C, SQL

Project Methodology Management: Waterfall, Agile

Business Intelligent Tools: SSIS, SSAS, SSRS, SAS, Cognos

Statistical Operation: SPSS, Tableau

Mathematics Operation: Matlab

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

Data Analyst/SQL Developer

Responsibilities:

• Extensively used SQL for accessing and manipulating database systems
• Hands-on architecture experience with data base schema design, query design and optimization.
• Conducted meeting with the EDI team and other stakeholders team members to discuss the requirements
• Work with enrollment/claims EDI transactions and file formats (834, 837, 835, 270, and 271), familiarity and experience with data mapping desired.
• Extracted data from various sources and imported into data warehouse
• Profiled source data and pinpointed data discrepancies
• Performed quantitative analysis for financial data and financial statements
• Involved in writing several SQL queries and procedures to provide multiple database services
• Performed data cleansing, data mapping, and data profiling using SSIS
• Performed ETL process using SSIS package
• Assisted in developing ETL standards and best practices.
• Developed reports on SSRS and created multiple types of reports such as parameterized, conditional, table and matrix.

Environment: SQL Server 2014, SSRS, MS Excel, SSIS, Windows 8.

Confidential, Woodland Hills, CA

Data Analyst/SQL Developer

Responsibilities:

• Involved in gathering business requirements from the end users and management
• Provided multiple database services for clients including database analysis, data translation, data archival, and automated database processing and interpretation.
• Provided daily analysis of performance measurements to senior manager
• Responsible for prioritizing IT and business requirements and integrating into single requirement backlog
• Configured and installed the database systems and tools
• Supported the analytic department by producing and coordinating the development of extensive reports
• Participated in product testing activities to ensure traceability of requirements
• Prioritized requirements to be developed according to Agile methodology

Environment: SQL Server 2012, Windows 8, MS Office 2013.

Confidential

Data Analyst

Responsibilities:

• Wrote SQL scripts to manipulate data for data loads and extracts
• Created, designed and developed real time analytic.
• Created migration repository in Oracle SQL Server
• Performed data migration to move data to Oracle database
• Created connections to Microsoft SQL Server
• Created and presented information reports for management based on SQL data
• Collaborated with data management teams and vendors throughout project life cycle
• Facilitated data merging and transformation in preparation for analysis
• Provided support to people who are required to access and analyze the SQL database.
• Assisted in mining data from the SQL database that were used in several significant presentation
• Created daily batch feeds to ingest data from various database resources
• Designed and developed databases with tables, views, and stored procedure
• Analyze and documented the Corporate Data Warehouse system to estimate wide impact from format changes.

Environment: SQL Server 2012, MS Excel, SSIS

Confidential

Data Analyst

Responsibilities:

• Assisted staff and clients in improving the quality and use of data and data system
• Modeled and analyzed data and developed unique tables, charts and other data displays for inclusion in reports to clients and as data support for consulting staff
• Maintained and updated company websites and produced monthly usage reports
• Built out the structure of new sections per user requirements
• Designed and developed scripts to manage data and data files from database
• Coordinated with the development and testing team in the development of fixes
• Used Agile methodology to manage, prioritize, and schedule tasks and projects
• Recorded and updated project incidents, and produce monthly reports from system
• Collected and reviewed business and economic financial information from various sources, and analysis using EXCEL model tools.

Environment: SQL Server 2008, MS office 2010, Windows 7