We provide IT Staff Augmentation Services!

Datastage Developer /senior Business Intelligence Analyst Resume

5.00/5 (Submit Your Rating)

Philadelphia, PA

SUMMARY

  • Technically savvy, self - directed professional wif hands-on experience in data analysis, data audit and quality, and database administration, including IBM DataStage consulting / engineering and SLQ database creation, maintenance, migration, and cleansing. Stellar performance in positions requiring strong analytical and problem-solving skills.
  • Able to ensure teh integrity of data in extracting, processing, storing, manipulating, and analyzing.
  • Proficient in analyzing data, interpreting results, and formulating written summaries of findings. Strong communication and interpersonal skills, wif

TECHNICAL SKILLS

Platforms: Windows 7, 8, 10; Windows Server 2008, 2012

Programming: PL/SQL, SQL, Python, C#, Visual Basic, Tableau, Crystal Reports

Tools: IBM DataStage, Oracle SQL Developer, Toad, IBM Netezza, SQL Server Management Studio, Tableau Desktop, Jira, Confluence, WinSCP, PowerShell, Active Directory, SAP Crystal Reports, Durkin Impact Reports, Google Analytics, MatchIT Data Quality Suite, ACT v16, Kleopatra, Northwoods Sales Automation Manager & Mail Merge, Microsoft Office, Photoshop, Acrobat, Filezilla, MicroStrategy, Able2Extract PDF Converter

PROFESSIONAL EXPERIENCE

Confidential, Philadelphia, PA

DataStage Developer /Senior Business Intelligence Analyst

Responsibilities:

  • Enable efficient and successful collections activities by providing VP of Collections and Collections managers wif clear, accurate data on delinquent accounts, account statistics, and recommended actions.
  • Collaborate wif Data Architect to continually refine and enhance reporting capabilities, including addition of fields and data cleansing strategies.
  • Utilizing IBM DataStage, created and deployed an automated data cleansing and formatting process that exports files from Oracle and sends teh files to analysts in various formats (Excel, .csv, text) for analysis.
  • Constructed Oracle database for archiving cleansed data. Continue to maintain and manage this database.
  • Created data compiling and formatting macros and queries to enable analysts to work wif greater speed, accuracy, precision, and efficiency.
  • Trained data cleansing team members in use of IBM Datastage and Oracle SQL Developer. Additionally provided training on operational workflows, data governance, and quality control.
  • Enhance Finance team capabilities by providing training on SQL, VBA, and Tableau.
  • Earned accolades from senior leaders for talents in engaging wif business groups and halping management to clearly convey their reporting needs, goals, and objectives.
  • Led redesign of existing reports to more user-friendly and efficient documents.

Confidential, Reston, VA

DataStage Developer

Responsibilities:

  • Utilizing IBM DataStage, created and deployed an automated data cleansing and formatting process that exports files from Oracle and sends teh files to analysts in various formats (Excel, .csv, text) for analysis.
  • Constructed Oracle database for archiving cleansed data. Continue to maintain and manage this database.
  • Created data compiling and formatting macros and queries to enable analysts to work wif greater speed, accuracy, precision, and efficiency.
  • Trained data cleansing team members in use of IBM Datastage and Oracle SQL Developer. Additionally provided training on operational workflows, data governance, and quality control.
  • Earned positive feedback from colleagues and management for strong work ethic, productivity, positive attitude, and collaborative work style.

Confidential, Alexandria, VA

DataStage Developer/ Senior Data Analyst

Responsibilities:

  • Completed comprehensive database upgrade to optimize user experience, resulting in a more dynamic, business-friendly platform and interface.
  • Took on responsibility for database programming, which reduced reliance on third-party vendors, enhanced turn-around time, optimized resources, and minimized expenditures.
  • Utilized IBM DataStage, created an automated data cleansing and formatting process to Import and store sales and revenue data from various formats (Excel, .csv, text) in SQL data warehouse.
  • Consolidated all departments into one database wif increased productivity and improved functionality.
  • Delivered accurate reports on a consistent basis outlining daily, weekly, and monthly sales progress.
  • Instrumental in consolidating numerous data-related procedures to improve accuracy and efficiency.
  • Demonstrated ability to learn tasks and responsibilities of teh position at a faster rate than predecessors.

We'd love your feedback!