Danusree Srinivasan adyuy1@r.postjobfree.com
Business Analyst 757-***-****
IT Professional experience with faster and reliable data integration solution for Healthcare Data warehouse/Data Mart's Projects that includes clear vision, strong leadership, management, business acumen and technical skills to offer organizations. Proven track record of delivering high quality work product with measurable business and monetary results.
Education
M.Phil.,
P.S.G College of Arts and Science, Bharathiar University, Coimbatore
Master of Computer Application
Kumaraguru college of Technology, Anna University, Coimbatore, Tamil Nadu
Bachelor of Computer Technology
Sri Ramakrishna Engineering college, Anna University, Coimbatore, Tamil Nadu
Work History
Business Analyst at Conduent 2022 -08 – till date
Providing Production Support for existing clients, including analyzing bugs/defects, performing root cause analysis, working on new enhancements, and supporting training and documentation of new features for new releases.
Supports functional departments and lines of business operational reporting.
Analyzes business processes and performs needs assessments
Writes business specifications and forwards to technical staff.
Reconciles regularly scheduled payment cycles and data loads.
Creates, presents to the State customer, and manages the resolution of technical change requests.
Monitors Reference/Data Management related system defects and tests defect fixes.
Interprets business needs and translates them into system requirements.
Provides technical expertise in identifying, evaluating, and developing systems and procedures.
Performs ad hoc data queries or other research requested by the State.
Processes payout and accounts receivables requests submitted by the State customer.
Demonstrates good judgment in selecting methods and techniques for obtaining solutions.
ETL Informatica developer at Infinite Computer Solutions 2022 -01 – 2022-08
Client : Conduent
Performed Data profiling on various data pattern that includes Pharmacy claims, Drug, Diagnosis, Managed Markets to design mapping pipeline and data flow to load data into Datamart’s from Data warehouse
Used Microsoft suite for daily day today project needs to MS Word (Requirement gathering and Business rules) to Development Team, MS Excel (validate data, to ensure Business rules are implemented) and provide approvals to Change requests that was performed by QA and UAT teams.
Understand the business needs and Developed ETL logics on Informatica power center Mappings using various Transformations like Expression, Filter, Joiner, Router, Data transformation, source Qualifier, Indirect file loading, Target, SQL, Aggregator, Sorter, Rank for data flow and designed multiple pipelines with multiloading.
Built and load datamart to store data for various reporting needs.
Fixing the production job failures with the support teams.
Prepare Source-To-Target (S2T) Mappings as required from changes or additions to the extract process utilized for TMSIS.
Modify the Informatica ETL process, Mapping and developing missing values in T-MSIS data based on updated S2T.
Test recent changes to the extract process and migrate the codes to production.
Prepare Member, Provider, TPL, CLAIMS-IP, LT, OT, RX TMSIS files on monthly basis submit to CMS.
Monitor updates on CMS websites related to T-MSIS.
Analyze TPI and errors and data quality issue published in CMS portal and coordinate with state and functional SME to provide analysis to CMS.
Developed UNIX shell scripting to handle files FTP, SFTP and trigger informatica from control-M.
Creating the Unit test plan for the new functionalities.
Write SQL queries in oracle to generate adhoc reports
Writing PL/SQL blocks to load data into oracle database
Used Visio to facilitate scheduling in control M, Autosys for job scheduling, workload automation and for operational flow.
Performed Unit Testing to match the results as per Technical Requirement Document.
Reading Detail Specification Document (DSD) and creating Technical Specification Document (TSD) to suffice development needs.
Assisting Code migration and Code Validation.
ETL Informatica developer at Boson Labs 2015 -2017-Feb
Fixing the production job failures with the support teams.
Write SQL queries in oracle to generate adhoc reports
Built ETL mappings using Informatica Powercentre components / Transformations like Expression, Filter, Joiner, Router, Data transformation, source Qualifier, Indirect file loading, Target, SQL, Aggregator, Sorter, Rank for data flow and designed multiple pipelines with multiloading.
Developed UNIX shell scripting to handle files FTP, SFTP and trigger informatica from control-M.
Perform Unit Testing and Code Migration.
Support SIT, UAT and Production.
Technical Skills:-
Tools
Informatica Power Center (10.5), TOAD, SQL Developer, MOVEit, Control-M, Autosys, IBM clear Quest.
Relational Database / Various Source types
Oracle, SQL Server Management, SQL, DB2, Flat files, CSV files, XML Files, Basics of snowflake and redshift.
Operating Systems
Windows, UNIX, Linux