SUMMARY

• Over 7+ years of experience as a Data Analyst in a Data warehousing environment in Pharmaceuticals and Healthcare industry.
• Extensive experience on interaction with system users in gathering business requirements and involved in developing projects. Chaired and conducted JAD sessions with business and technical teams.
• Knowledge of the EDI transaction sets such as 837, 834, 835, 270, 271, 276, 277, 999
• Understanding of HIPAA Standards and Compliance issues, HIPAA Privacy policy, opt in/opt out policy.
• Experience in Big Data processing using Apache and Hadoop.
• Strong experience with SQL, Normalized Database creation in relational databases like Oracle, MS - SQL Server, Access DB, DB2 UDB. Expert in writing optimized PL/SQL, SQL, triggers, and cursors in Oracle.
• Knowledge of Business Intelligence tools such as SSRS, Tableau.
• Expertise in building and customizing dynamic reports, interactive dashboards and visualizations, for daily, weekly, monthly KPI report, forecasting/analyzing trends and disseminating business insights, using Tableau, MS PowerBI, and advanced excel.
• Worked in Teradata SQL, Teradata (TD) Utilities (BTEQ, Fast Load, Fast Export, Multi Load Update/Insert/Delete, TD SQL Assistant).
• Expertise in developing, deploying and integrating Salesforce.com CRM solutions.
• Highly skilled in System Analysis, ER/Dimensional Data Modeling, Database design and implementing RDBMS specific features.
• Knowledge of Business Intelligence (BI) tools like Business Objects Modules (Reporter, Supervisor, Designer, and Web Intelligence).
• Facets support systems were used to enable inbound/outbound HIPAA EDI transaction in support of HIPAA 834, 835 /271 transactions.
• Worked extensively with Dimensional Modeling and Data Migration.
• Experience in DBMS/RDBMS implementation using object-oriented concept and database toolkit.
• Worked on integration and implementation of projects and products, database creations, modeling, calculation of object sizes, table spaces and database sizes.
• Experience on building OLAP Cubes in SQL Server Analysis Services (SSAS) and reports on it.
• Rich experience in quantitative analysis and data mining using Excel, SAS and SSAS.
• Experience in hive queries, pig scripts, python with Hadoop eco system and R scrips, programming and tableau visualization and analytics.
• Comprehensive knowledge and rich experience in all phases of the Software Development Life Cycle (SDLC), for different development methodologies.
• Experience with Star schema modeling and knowledge of Snowflake dimensional modeling.
• Experience with SQL, PL/SQL objects. Involved in creating Packages, writing Procedures and Functions. Tuning using various types of Partitioning and Indexes.

TECHNICAL SKILLS

Database: Teradata, DB2, Oracle, SQL Server 2012, Access DB, SOQL

Data Warehouse Concept: Star Schema, Snowflake schema, OLTP, OLAP

Operating Systems: UNIX, MS Windows & NT, MS DOS, LINUX, VMware ESX servers, Window Server

Languages: SQL, PL/SQL, T-SQL, Java JavaScript, Python, Spring Hibernate

ETL & Reporting Tools: SSIS, SSRS, SSAS, Tableau, Crystal Reports

Third party Tools: TOAD MODLER, PLSQL DEVELOPER TOOL VMWARE Desktop Software Visual Studio, Visual Source Safe, TFS, MS Office Suite

Tools: Eclipse IDE, WebSphere server, Apache Tomcat, MS Office Suite, Management Studio (SSMS), Filenet P8, MySQL, PostgreSql, Erwin Data Modeler, Lucid Chart, JIRA,FACETS, TFS, Power BI, Toad, Informatica Power Center, Salesforce, Veeva CRM.

PROFESSIONAL EXPERIENCE

Confidential, Cambridge MA

Data Analyst

Responsibilities:

• Creating Technical Specifications documentsfor the source systems based on inputs provided in terms of data, flow and integration requirements and discussions with the team which includes the Project Manager, Business Analyst, Data Architect, Data Steward and other important stake holders.
• Created Data Flow Diagrams (DFD), ER diagrams, activity diagrams & class diagrams with the use of Lucidcharts and Visio to represent data flows in the enterprise and business level.
• Utilizing data tables in Power BI and Python Scripting to create data load files or target files (logical source-to-target mapping) based on thedata extract (source) provided by the source systems which includes Veeva CRM, Oracle Db,etc. by applying transformation rules and business criteria’s as per the data needs and also create data visualization reports as and when needed.
• Performed data testing on the source data extract and the final load files to make sure the data is clean and has limited to no bugs by coming up with various test scenarios for doing the same and documenting them.
• Assist in achieving desired data quality by creating and executing appropriate test scenarios during the project lifecycle (system end to end testing, unit testing, UAT). Performing the quality assurance and testing database in CRM (Salesforce, Veeva) to ensure data integrity

Confidential - Pittsburgh, PA

Data Analyst

Responsibilities:

• Worked on the Data Warehouse team analyzing data files that had to be compiled from disparate non-production sources and readied them for production. Tasks included: comparing data to requirements documentation, creation of data layouts and data dictionary.
• Developed various T-SQL objects such as Functions, Tables, Views, Triggers, Indexes, Constraints, Stored Procedures and Queries to be used in the project.
• Experiencing with Hadoop eco system - distribute, store and process data in a Hadoop cluster running in the cloud.
• Design dashboard using POWER BI tool in MS Dynamics which are KPI and KRI. A dashboard provides important business insights such as yearly investment, analysis of investment opportunities, and geographical investment
• Optimized the performance of queries with modification in T-SQL queries, creating sub queries, establishing joins and creating indexes wherever necessary.
• Worked on analyzing Salesforce automation, lead management and customer portal functionalities and also administration, configuration, testing and support of Salesforce CRM applications leveraging Force.com platform.
• Participated as member of a project team performing various lifecycle tasks for an intranet application with SQL Server database. Developed logical and physical database models and data dictionary documentation.
• Use Microsoft Dynamics to manage and populate investor’s data, audit plans and budget in CRM on a regular basis.
• Administrated and monitored the company’s Salesforce CRM application.
• Created an in-house fraud detection application to replace a vendor-supplied application, reducing processing time and costs using Hadoop big data models.
• Created adhoc reports to users in Tableau by connecting various data sources.
• Use Microsoft Dynamics for lead generation and perform troubleshooting for platform stability in CRM.
• Created SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.
• Tested complex SQL scripts for Teradata database for creating BI layer on DW for tableau reporting.
• Created Stored Procedure and Views, Indexes, SQL joins and Sub queries
• Worked on generating ad hoc reports, tables and graphs for presentations and data modeling using SAS Web Report Studio.
• Worked with integration services for transferring and reviewing data from different sources like (Flat file, Excel, CSV).
• Experience in troubleshooting and resolving data related issues affecting BI reporting
• Created SQL Server Reports, handling sub-reports and writing queries to perform drill down, drill-through operations in SSRS.
• Generated Daily, Weekly, Monthly reports for the analysis of managers and end users by using SQL Server Reporting Services.
• Imported data from SQL Server and Excel to SAS datasets
• Extracted data from various sources and performed cleansing, compilation, manipulation, aggregation, complex calculation using formulas and organization of data sets for import into BI tools for preparing business insight reports.
• Co-ordinate with different application team to develop and standardize enterprise wide data model, created dimensional data model using Agile Methodology, Designed and developed dimension tables, fact tables, conformed fact and dimension tables.
• Data profiling and Data quality checks along with integration rules determination and documentation.
• Used Business Intelligence (BI)Reporting Tool to create KPIs and Scorecards to improve corporate profitability measures and comparative analysis
• Experience with data mining, data cleansing, data modeling, data manipulation, record matching, table linking, table structures, importing and exporting.
• Used Teradata SQL Assistant and Nexus client tools to access Teradata database and TOAD and SQL Navigator client tools for Oracle database and SQL Query analyzer for SQL Server 2005/2008 database.
• Analyze end user requirements to design report mock-ups specifications and production reports using Tableau and Cognos.
• Created Mapplets, reusable transformations and used them in different mappings.
• Participated in the tasks of data migration from legacy to new database system
• Responsible for creating and modifying the PL/SQL procedures, functions according to the business requirement.
• Created SQL Server Reports, handling sub-reports and writing queries to perform drill down, drill-through operations in SSRS.

Confidential, Jersey City, NJ

Data Analyst

Responsibilities:

• Analyzed the source data coming from Legacy system, Oracle, DB2, sql server, PeopleSoft and flat files. Worked with Data Warehouse team in developing Dimensional Data Model.
• Converted syntax of diverse queries from Oracle to MS SQL Server in order to reach the business requirements.
• Experience in creating scripts for Big Data Analysis using Apache Spark for the data stored in Hadoop.
• Accomplished the data mapping documentations for database updates
• Analyzing the reference of data which is extract from source table and transform to the target table by using the SQL query.
• Facilitated the transition to IT-supported Business Intelligence (BI) Data Mart.
• Transferred data into meaningful, professional and easy to understand formats like BI reports and dashboards for various audiences using MS Power BI and Excel.
• Perform the quality assurance and testing database in CRM to ensure data integrity
• Experiences in Designing, modeling, and creating database and Normalizing or de-normalizing data according to business requirements and Creating Star and snowflake schemas.
• Designed Enterprise reports using SQL Server Reporting Services (SSRS)
• Did Transformation and data cleansing activities use various Control flow and data flow tasks in SSIS packages during data migration
• Developed estimates, project plans (Microsoft project), training material, BI reports using Microstrategy
• Designed Complex reports in SAS Web Report Studio by creating conditional Formatting, Master-Detail.
• Present design of proposed CRM functionality to the team and document the business process, recommend improvement to stakeholders to support company’s growth and strategy.
• Created and managed Event Handlers, Package Configurations, Logging, System and User-defined Variables for SSIS Packages.
• Participated in Complete Formal Design process from initial specifications and requirement. Involved in creating technical design documentation.
• Extracted data from a data source and performed ad-hoc queries.
• Proficient in Sales force SFDC, Force.com and their use in the development of CRM solutions
• 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 analysis and visualization of business data, metrics and measures with Tableau dashboards and Cognos Active Reports.
• Supported presentation and visualization of data through standard tools (e.g. Tableau, Power BI).
• Good experience on installing Hadoop in AWS environment and worked on POC’s to extract data from traditional database to HDFS environment, data transformation and data ingestion.
• Created numerous views with complex SQL statements to retrieve data from the Tables.
• Devising a planned approach to maintain the month-long segmentation process.
• Designed and developed Data warehouse, Data marts, star schemas, fact table, Dimension tables, Slowly Changing Dimension, Staging areas, Operational Data Store.
• Involved in designing, development and testing of Interfaces to communicate with third party data.
• Prepared technical design/specifications for data Extraction, Transformation and Loading.
• Used various transformations like Stored Procedure, Connected and Unconnected lookups, Update Strategy, Filter transformation, Joiner transformations to implement complex business logic.
• Created Stored Procedures, Functions, Packages and Triggers using PL/SQL.
• Implemented restart strategy and error handling techniques to recover failed sessions.
• Involved in designing Universes incorporating all the business requirements and creating hierarchies to support drill down functionalities in reports.

Confidential, TX

Data Analyst

Responsibilities:

• Involved in the entire SDLC of the project. Requirement & Analysis, Design, Development, QA, UAT and Implementation.
• Was part of the requirements workshop and assisted in requirement gathering from the users and creation of BRD. Prepared the FBTR (Functional, Business and Technical requirement document) based on the BRD.
• Gathered required business rules for data transformation
• Utilized Rational Unified Process (RUP) to configure and develop process, standards and procedures.
• Prepared the business requirement document (BRD) and system requirement document (SRD).
• Responsible for checking member eligibility, provider enrollment, member enrollment for Medicaid and Medicare claims.
• Wrote FRDs for the defects and enhancements and got approval from business for the developers.
• Worked on Technical design documentation (TDD) of the claims processing system.
• Documented the dimensional models of ETL system.
• Designed and developed mappings, sessions and workflows for load the data from source to target database using Informatica Power Center.
• Experience with data mapping document(s) in reference to the HIPAA transactions: 270/271, 276/277, 837, 834 and 835
• Wrote Excel Macros/VBA for data validation, data manipulation and generating reports.
• Support maintenance of database schema, tables, procedures and users/user access levels for each segment of database and modify existing databases and database management systems.
• Involved in Data Warehouse design/development.
• Knowledge of Data Warehouse design, Star and Snowflake Schema to develop OLAP CUBE using SSAS.
• Gathered requirements and modeled the data warehouse and the underlying transactional database
• Developed data quality test plans and manually executed ETL and BI test cases.
• Worked with data analyst teams on electronic Medicaid eligibility verification system & the Medicaid & Medicare intermediary along with their roles in claim processing.
• Used VBA Scripts in Excel to automate processes.
• Work as part of a project team to coordinate database development and determine project scope and limitations. Review project requests describing database user needs to estimate time required to accomplish project.
• Used SQL to test various reports and ETL load jobs in development, QA and production environment.
• Worked extensively with client gathering requirements to generate customized SQL reports.
• Performed extensive task which include Data Quality Analysis, Data lineage and Data Standardizations.
• Responsible for the full HIPAA compliance lifecycle from gap analysis, mapping, implementation and testing for processing of Medicaid Claims.
• As part of technical team that focuses on ensuring compliance to the data models, data standards and overall data architecture. Monitored compliance by conducting reviews of the project logical and physical data models.
• Performed Work Product Review (WPR) to ensure that the documentation was up to the standard and without any errors.
• Written SQL queries for validation of ETL Reports from Source to Target system in Java
• Developed ER diagrams and Physical Data-model along with the testing team so as to provide a clear understanding of the system under development and for reference of the testing tem
• Extracted data by running SQL queries, and analyzed financial and customer metadata that gets populated on the web application
• Analyzed, designed, built and tested reports while working directly with end-users.
• Created user Prompts, Conditions and Filters for various reports to specify the reporting parameters as per the business rules and the requirements of the end users.
• Designed the Unit test cases required for Unit testing before migration to the Testing Environment.

Confidential, Virginia Beach, VA

Data Analyst

Responsibilities:

• Wrote advanced SQL queries to extract, manipulate, and/or calculate information to fulfill data and reporting requirements including identifying the tables and columns from which data is extracted.
• Responsible for Data modeling and Mapping through data analysis to extract data elements from various OLTP’s using ETL technique and utilized Business Intelligence Tool (Tableau) for report generation.
• Analyzed and documented the changes in the compliance rules for adverse action redesign.
• Used Data warehousing for Data Profiling to examine the data available (Data Analysis) in an existing database.
• Worked in Teradata to make sure completeness of table structures, data and reference table data.
• Extensive experience in ETL processes in extracting data from Operational and Legacy Systems to Data Warehouse using Informatics.
• Responsible for providing business requirements within an AGILE software development SCRUM environment.
• Extensive experience on usage of ETL& Reporting tools like SQL Server Integration Services (SSIS), Silverer Reporting Services (SSRS).
• Ensure day-to-day EDI transmission, Reject tracking and Reconciliation.
• Run EDI Reconciliation reports daily and document in MS Excel.
• Maintained and monitored project progress and status through MS Project.
• Extracted Data from Teradata using Informatica Power Center ETL and DTS Packages to the target database including SQL Server and used the data for Reporting purposes documentations.
• Used SQL tools like TOAD to run SQL queries to view and validate the data loaded into the warehouse.
• Creating and modifying Business Intelligence analytical reports using Tableau.
• Designed, Developed and Implemented reports in Qlikview BI Dashboard tool - one of the most advanced tools for BI and reports.
• Worked closely with the Enterprise Data Warehouse team and Business Intelligence.
• Used the guidelines and artifacts of the Agile Process to strategize the Implementation in different sprints of the Software Development Life Cycle.
• Performed extensive task which include Data Quality Analysis, Data lineage and Data Standardization data structures, data base design, data warehouses, business.
• Walk-through the business users: Business Object Reports or QlikView reports.
• Data mapping, logical data modeling, used SQL queries to filter data within the Oracle and Sybase.
• Used the Agile methodology to build the different phases of Software development life cycle.