Candidates About

 

Malabika Brahma

PROFESSIONAL SUMMARY

●        10+ years of IT experience in the field of Data Management, ETL Development, Data Analysis, Reporting.

●        Proficient in T-SQL, IBM Netezza SQL, PostGre/SQL, PL/SQL - write blocks, stored procedures and functions

●        Data loading and data integration from external sources (Excel, Flat file) using various tools like BCP, SQL Loader to load data coming from external sources into staging area.

●        Extensive Experience with reporting tools Tableau, MS Excel, Livelink (OpenText) Web Reporting Tool.

●        Experienced with Generating reporting dataset by integrating and blending data from various data sources including MS ACCESS and MS Excel  and create report with summary, bar graphs and charts.

●        Extensive experience in Data Quality, Data Analysis, Data Validation and Data Integration.

●        Experienced in End User Support and training, production issue follow-up and resolution.

●        Good understanding of Relational Database Design, Data Warehouse (Fact tables, Dimension Tables, Slowly Changing Dimensions, Star Schema, Snowflake Schema) and methodologies.

●        Extensive exposure to different phases of SDLC process starting from analysis through evolution in Banking, Municipality, Pharma, Health, Cable Domain.

●        Excellent Communication, interpersonal, analytical skills and strong ability to perform in a team as well as individually.

________________________________________________________________________________________

PROFESSIONAL TRAINING

●   Livelink System Administration Training by Open Text.

●   SumTotal Learning Management System Administration Training.

________________________________________________________________________________________

TECHNICAL SKILL

 

Relational Databases	IBM Netezza, PostgreSQL , MS SQL Server 2000/2005/2012, Oracle 9i/10g/11g,  Sybase, MS  Access
RDBMS Tools	IBM Netezza, Aginity Workbench 4.4, Hive SQL, T-SQL, SQL*Plus, BCP, SQL*Loader, TOAD, UltraEdit, PL/SQL ERWIN
Reporting Tools	Tableau 9.3/10.1/10.3, Livelink (OpenText) Web Reporting tool, Excel
Programming Languages	Visual Basic, C, Korn Shell, Perl
Operation Systems	Windows NT 4.0/95, Windows Server 2003, Red Hat Linux 4, Solaris 10.
Web Server	IIS, HTTP, Oracle Application Server.
Electronic Record Management	Livelink by OPENTEXT
Electronic Learning Management	SumTotal
Pharmaceutical Quality Process	IQ/OQ/PQ, GMP, 21 CFR PART 11, Release Management, Change Management, Validation documentation compliance, Incident Management, Problem Management and Continuity Management

 

_________________________________________________________________________________________

EDUCATION   

●     BS in Computer Science and Engineering

              (Jorhat Engineering College under Dibrugarh University, Assam, INDIA)

 

 

 

 

 

 

 

WORK HISTORY:

 

Comcast Cablevision (Center City Philadelphia)                                                                                           Oct 2016 - Till date

Customer Data Analyst/Tableau Developer

 

As a team member of Customer Service Application Analytics & Reporting team, I have been responsible for understanding the reporting need as placed in  a ticketing system that Comcast uses - Atlassian JIRA v6.4,

getting and blending data from the required reporting database and other data sources and finally create reports in Tableau.

Responsibilities include:

●        Create reports and Dashboards in Tableau (9.3, 10.1, 10.3.4) and publish on Tableau Server as well as Comcast reporting portal.

●        Create various reporting objects like Facts, Attributes, Hierarchies, Filters, Groups, Calculated fields and parameters in Tableau.

●        Create, Execute and Validate queries to obtain required set of data for reporting from various databases in SQL Server, IBM Netezza

●        Create report by blending data from multiple sources.

●        Create Tableau Scorecards, Dashboards using stack bars, bar graphs, trend line graphs, pie charts on single or dual axis

●        Create ad-hoc reports to users in Tableau by connecting various data sources like excel sheets

●        Setup reporting data refresh schedules

 

Technical Environment: Window Server, Tableau 9.3/10.3, IBM Netezza, MS SQL Server 2012, Excel, Hadoop, Hive SQL

 

Horizon Blue Cross Blue Shield of NJ  (Trenton, NJ)                                                                            Oct 2015  - May 2016

Quality Data Analyst/Report Developer

 

Horizon Blue Cross Blue Shield of New Jersey (Horizon BCBS-NJ) is the state's largest health insurance company.  BCBS-NJ also participates in the government health programs, Medicare and Medicaid.  Functioning as Data Analyst for the  ‘Medicare Star and HEDIS Reporting’  team for Quality Department, I have been extensively involved in  supporting  the team with their business analytical work and reporting needs for quality improvement  projects/activities,  by extracting  HEDIS Medicare (STAR measures) and Medicaid data by writing SQL codes and generating scheduled as well as ad-hoc reports. My responsibility includes:

●      Address data and reporting needs:

o      Analyze the user need, write and run SQL queries to extract data and compile reports as needed

o      Provide compliant/non-compliant data on selected measures for Care/Case management

o      Generate reporting dataset integrating Claims data and HEDIS data

o      Provide data during internal audit process.

●      Data Validation:

o      Develop validation report the MediCaid/Medicare (STAR measures) HEDIS data migration to the new database server by running SQL queries

o      Develop discrepancy reports on compliant /non-compliant member counts on both old and new database

●      Scheduled Reports:

o      Multiple monthly reports to various departments on various measures of their responsibility like maternity, mental Illness, Child Immunization, Breast/Cervical/Colorectal Cancer to help management address the issues behind increased noncompliance count to increase star rating.

o      Generate monthly and yearly YOY Change report for both Medicare and Medicaid population.

●      Ad-hoc Reports:  Any other ad-hoc reports  as requested

●      All reports generated were finally published in MS Excel utilizing its features like Pivot Table, VLookUp, conditional statements, arithmetic and/or grouping functions, different graphs etc.

●      MS Access was used at times to consolidate different data files to create reporting dataset.

 

Technical Environment: Window Server, Microsoft SQL Server 2012, Microsoft Access, MS Excel, SAS

 

Computer Software Inc (Chalfont, PA )                                                                                                          Jan 2013 - Dec 2014

Data Analyst (Backend)

                                                                                                                                                                               

CSI Inc. owns a flagship product called MAGNET Municipal – which is essentially a workflow management system for townships. Functioning as back-end Data Analyst and database developer, I was mainly involved in the development of SQL codes. 

Responsibilities included:

●        Data Quality and Data Validation:  Use SQL code to check incoming data from customers (municipalities) for data quality issues (like valid address, account number and other data integrity issues) and write SQL code to do required transformation before they can be loaded into the data model that supports the MAGNET data model.

●        Data Integration and Data Migration: Design staging area where data from external sources are loaded and write SQL codes to do required transformation (for example look up transformation to pick up standardized codes) before data is loaded into core area. Migrate data from Unit and Test databases to Production databases.

●        Enhancement of the back-end data model to match business requirement: Participate in analysis and design sessions with customer representatives and business analyst and validate against the existing data model and recommend changes to existing data and process model. This was a fairly involved and frequent task since each client had specific requirement and different data structure.

●        Development and maintenance of SQL codes: Responsible for development and maintenance of all data loading, data transformation and data presentation codes consisting of SQL codes and data loading routines.

●        SQL performance tuning: Optimize SQL code, work with DBA to provide input about creation of indexes, partition strategy based on data distribution, database maintenance schedules for performance optimization.

●        Address production support issues like ensuring Service Level Agreement concerning system availability, using SQL code to address support ticket raised by customers, ensuring database performance

➢    As the first responder in the “Call Escalation Process” investigate and identify the source of user complaints/application failures/errors and route the “Help Desk Ticket” to the proper team.

➢    Document and update job abending instructions and call list for mission critical applications.

 

Technical Environment: Window Server, PostGre SQL, MS Excel,  PHP, Linux.

 

***Note: The gap of 8 months from Auxilium was due to a break I decided to take on due to some family situation.

 

Auxilium Pharmaceuticals (Malvern, PA)                                                                                                   Jan 2009 - April 2012

System Support Specialist (Application Data Analyst)

                                                                                                                                                                                 

Provided administration and user support for two critical applications by pharmaceutical standards used company wide. Performed application data analysis and developed reports for the management to present various metrics considered critical for pharmaceutical industries.  The applications were  Auxilium’s Electronic Content Management System ( from OpenText-Livelink) and Learning Management System (from SumTotal).

Responsibilities included:

●        Worked with the EDW designing team to help design and create the reporting data mart for the supporting applications ( LiveLink, SumTotal)

●        Creation of data extraction routines using T-SQL and PL/SQL for creation of reporting data mart.

●        Created custom T-SQL codes to query underlying MS-SQL server database from Reporting Tools such as MS Excel and Visual Studio to produce various custom reports.

●        Performed requirements gathering for reporting needs and Data Analysis of the back-end application database, and carried out data mapping for reporting needs.

●        Develop Installation (IQ), Operational (OQ) and Performance Qualification Protocols (PQ) for software applications.

●        Develop Standard Operating Procedure (SOP) for the applications.

●        Report development using LiveLink (OpenText) Web analytic reporting interface and Crystal Reports for LiveLink content management system and Sum Total learning Management system.

●        Administration and training support to the users of Livelink and SumTotal systems company wide.

●        Process documentation.

 

Technical Environment:  Oracle 11g, MS SQL Server 2005, PL/SQL, T-SQL, Toad, Red Hat Linux, EMC Storage, Windows Server, IIS, MS Visual Studio 2005, ErWin, Livelink, SumTotal, MS Excel

 

***Note : The gap until the contract with Auxilium was an extended summer break.

 

Union Bank of Switzerland (Banking and Investment Sector) (Secacaus, NJ)                                    May 2005 – July 2008

Programmer Analyst

 

Responsibilities included:

●        Development and maintenance of Stored Procedure and functions using T-SQL for calculation of financial functions and managing data transformation and data integrity issues.

●        Identify performance bottleneck issues and suggest logical as well as physical database layout changes for performance enhancement.

●        Modify or create Sybase Stored Procedure to implement new or enhanced business functionality.

●        Prepare workflow document to document the existing system.

●        Used SHOWPLAN utility to analyze query plan and carry out performance tuning.

●        Used BCP utility to load incoming text data into staging area.

●        Used Cursors to implement complex business logics while creating Stored Procedures.

●        Wrote shell scripts to automate data loading operation by invoking ISQL and BCP utilities.

●        Wrote data extraction utilities to extract data from Production server and move to Unit and Model environment for testing and development.

 

Technical Environment:  Sun Blade 8000 Modular System, Sun-Fire-V490, Solaris 9, Windows  2003  Server, Sybase, T-SQL, SQL Advantage 11.x, UltraEdit-32 professional Text Editor 6.2.

 

NOVARTIS Pharmaceuticals (Life Science Sector)  (East Hanover, NJ)                                               June 2003 - Jan 2005

Programmer Analyst 

Involved in the design and development of a Data Mart for Key Opinion Leader (KOL) to be used for sales report generation.  Responsible for requirement gathering, contribute to data modeling and SQL development for populating the data model. The Data Mart was designed using Dimensional Modeling Technique (consisting of Dimensional Tables and Fact Tables into a STAR schema) for ease of reporting and data analysis.

 

Technical Environment:  RedHat 3, Solaris 8, Oracle 10g Database, Oracle Grid Control, Microsoft server 2003, Microsoft Sql Server 2000, Toad, ErWin, Database Export-Import, Oracle Standby Database.

 

***Note:The gap of 3+ yrs started with challenged pregnancy, followed by market aftermath due to 9/11

 

Bear Stern’s (Financial Sector)  (NYC, Morristown, NJ)                                                                            Dec 1997 – Oct 1999

 

Programmer Analyst (Consultant)

I was involved with Client Management System (CMS) which managed how the firm invested into various financial instrument for their clients. I was involved with CMS as an MS Sql Server developer.

Responsibilities included:

●        Performance tuning T-SQL queries.

●        Writing and modifying database triggers and Stored Procedures to enforce business rules.

 

Technical Environment: Sybase SQL Server 11.x, MS SQL Server 7.x, Visual Basic, T-SQL, BCP, UNIX