Consultant, Data Management Resume

SUMMARY

13 years of Data Management experience.
8 years of COBOL programming and 8 years of SAS programming.
Working knowledge of VISIO, Teradata, SQL Server, Oracle, MySQL, Postgres, MS Access, SAS/BASESAS dataset, Flat Text,Python, Visual Basic, COBOL, ECL, IPF, TSO, JCL and FORTRAN.

PROFESSIONAL EXPERIENCE

Confidential

Consultant, Data Management

Responsibilities:

Optimized the ETL processes to improve efficiency, avoid network congestion, avoid disk I/O congestionand compressed data to save storage space. Hands - on experience on SSAS.
Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like drill down, Conditional, Table and Sub Reports.
Experience in developing, extracting and transforming data using SSIS and Import Export Wizard.
Configured ODBC connections to multiple databases and setup DB-Links in SQL Server to act as gateway to move data between the databases.
Automate reports using SAS and Excel. Wrote macros in Excel to directly connect to the databases to extract data to populate excel tables, do pivots and generate graphs.
Verified data accuracy and insured data integrity before usage for reports by analysts.
Created and modified databases, tables, views, SQL jobs and stored procedures.
Team player, worked with tech team, business analysts, data modelers and forecastersto get data to
"get the job done".
Proficient in working with command line tools to run SQL statements to extract data. Used bulk copy tool to import/export data between multiple database systems. Moved over 100 million rows per day.
Performed daily data extract from clients in Teradata environment (Enterprise Data Warehouse) from multiple schemas, import/export local BI/Analytics SQL Server tables using bulk copy tool.
Ran stored procedures to QC and summarized data for the Analytic team.
Responsible for initial ETL to load raw data to databases. Worked with other team members totransform data into analytics toolslike SAS BI, Tableau, SQL Server Reports and MS Access.
Proficient in writing SQL statements to process data across multiple databases.

Senior Analyst

Wrote SAS codes to interface with other RDBMS for Data extraction, aggregation and reporting.
Executed statistical analyses to meet internal and external client needs.
Performed Digital Marketing campaigns using SQL code and Oracle query pulling data fortarget marketing based on client request.

Confidential

Programmer Analyst

Responsibilities:

Coded and determined cause/resolution of day-to-day programming problems.
Modified existing programs to comply with Y2K date format.
Performed On-call duties for batch cycles.
Responsible for system conversion, up-grade and loading of data to ERISCO claimsprocessingand updates usingTime Sharing Option (TSO).
Designed and coded logical solutions to business needs using COBOL, SAS and JCL.
Prepared and executed test data over new and modified programs.

Confidential

Programmer Analyst

Responsibilities:

Responsible for the coding, testing, documentation, promotion of application programsand modifications to existing COBOL programs.
Analyzed computer applications to determine effect on existing system, hardware,software requirements and time estimates.
Provided specifications for tasks to be completed by other programmers.
Verified program logic and validity by preparing data to test and debug computer programs.
Developed and maintained complex COBOL computer programs, scripts, and ECL runstreams.
Monitored contract programmers including tracking hours worked and ensuring that tasks are completed.

Confidential

Associate Programmer

Responsibilities:

Programmed and documented software applications as assigned.
Provided customer service and support regarding software taught in the training center.
Installed and setup support system for software and hardware.
Assisted other team members in daily support of operations and system cycle.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship