SUMMARY

• Data Quality professional with extensive experience in data profiling, data standardization, data enrichment, data matching, data deduplication, data monitoring & data migration.
• Mainly worked as Data Integration Engineer, Data Quality Architect, Lead Data Quality Analyst & ETL Developer for companies in Payroll and Insurance domain.
• Has comprehensive grasp on Data Quality/Data Integration & ETL tools such as SAS/ DataFlux DF Power Studio 8.2.2, SAS Data Management Studio/Server 2.6, Informatica Powercenter.
• Remarkable ability to work independently and as a part of the team.
• At present working with Confidential. a recognized leader in Payroll, human resource and benefits outsourcing at Rochester, NY.

TECHNICAL SKILLS

Data Quality/Data Integration: DataFlux DF Power Studio 8.2.2, SAS DataFlux Data Management Studio 2.6, Data Management Server 2.6 (SAS Toolset for data quality)

Data Migration (ETL): DataFlux Data Management Studio, Talend Open Studio.

Database: Oracle, DB2

Languages & Tools: DataFlux Expression Engine Language.

Testing: Manual Testing & ETL (Extract, Transform & Load) Testing

Other: SOAPUI, Winscp, Putty, GIT Bitbucket, Jira, ServiceNow

Functional Domain: Payroll, Insurance, Banking and Finance.

PROFESSIONAL EXPERIENCE

Confidential

Responsibilities:

• Provide planning, guidance and direction on various data integration efforts at Confidential .
• Build various data extract SQL queries.
• Perform data profiling analysis.
• Build data migration jobs using SAS - DataFlux Data Management Studio.
• Perform Data quality analysis and report various data quality issues to stakeholders.
• Establish data monitoring using SAS-DataFlux Data Management Studio.
• Partner with Confidential ’s Capacity, Performance and Data services team to evaluate capacity on target database and performance of data migration processes.

Confidential

Responsibilities:

• Perform user data profiling using SAS-DataFlux Data Management Studio.
• Report key data quality issues with Confidential Flex user data team.
• Perform User/Person/Worker matching analysis that require use of SAS-DataFlux proprietary Fuzzy match codes.
• Set up record survivorship rules using SAS DataFlux Data Management Studio.
• Build data migration jobs in DataFlux Data Management studio.
• Set up Linux scripts to execute various batch jobs.
• Partner with Product management, architecture, development and data services for successful completion of the overall effort.

Confidential

Responsibilities:

• Design and develop USPS address verification service using SAS-DataFlux Data Management Studio.
• Partner with development team and provide consultation on consumption of real time USPS Address Verification Service.
• Partner with Confidential Automation group to set up automated process for download and installation of USPS data packs on SAS-DataFlux Data Management Server.
• Cleanse and standardize existing client delivery addresses to USPS CASS certified format.
• Design and develop a process to add/update USPS standardized addresses in production database.

Confidential

Responsibilities:

• Perform data profiling analysis corresponding to Confidential client and worker demographic data.
• Build various data extract SQL queries to extract Client and Employee demographic and pay component data.
• Design and develop DataFlux data Jobs to execute data extraction queries.
• Design and develop data cleansing job for client and employee data cleansing.
• Perform data enrichment using SAS-DataFlux Data Management Studio which provides additional info such as Geo codes, County name, population and MSA.

Confidential

Responsibilities:

• Test and deploy new license files to DataFlux Data Management Studio/Server.
• Keep Data management software up to date with latest version and necessary patches.
• Set up various data connections.
• Manage logging thresholds for server log files.
• Test and install newer version of SAS-DataFlux Quality Knowledge Base.
• Handle all server configuration changes for DataFlux Data Management Server.
• Coordinate with SAS technical support for new updates, licenses, issues with existing software etc.

Data Quality (DQ) Analyst

Confidential

Responsibilities:

• Analyze and scope the requirements.
• Coordinate with business partners for detail business requirements on data quality.
• To define different data quality checks using SAS DataFlux for data elements where data quality is not controlled by application.
• Carry out data profiling and create different profile reports using DataFlux.
• Carry deduplication reports based on comparison of cluster ids.
• Carry out data cleansing based on data reported in data quality reports.
• Unload data from reference master environment tables and load it in to different ECS test environments.
• Code different architect jobs for transformation of data and accordingly migrate the data in different environment tables.
• Set up different DataFlux Architect jobs using DataFlux for processing different files containing business data and accordingly load/migrate data in production database tables.
• Set up data monitoring jobs using SAS DataFlux accordingly send different reports to SMCs using DataFlux email utility.
• Promote and schedule different architect jobs on remote integration server(Unix Server) for creating different weekly and monthly data quality reports.
• Coordinate with DataFlux Admin for setting up different data sources, repositories & macros.
• Represent project team for setting up of DataFlux test environments and integration servers by coordinating with DataFlux admin team.
• Share & analyze different findings and errors occurred during running of DataFlux jobs in production environment.
• Prepare Unit Test Cases (UTCs) for testing and validating different architect jobs in SAS DataFlux.
• Maintain quality standards in each work product delivered to client.