We provide IT Staff Augmentation Services!

Business Analyst Resume

Jacksonville, FL

TECHNICAL SKILLS

Database & Tools: Confidential, Confidential, Netezza, Hadoop, SQL Server, Sybase, Unix/DB2, MVS DB2, IMS, IDMS, Confidential Access; SQL, COBOL, Standard Analysis Package (SAP) for Data Analysis, Brio, SQL Assistant, Aginity (for Netezza), SAS Enterprise Guide, Toad for Data Analyst, Hue/Impala, Crystal Reports, Visio, PowerPoint, Word, Access, Excel/Pivot, Sharepoint, JIRA, SAFe/Agile, SQL Server Management Suite, RazorSQL, Snowflake training.

PROFESSIONAL EXPERIENCE

Confidential, Jacksonville, FL

Business Analyst

Responsibilities:

  • For Confidential client, as a member of Data Governance, have actively contributed to the establishment of Enterprise Data Governance Office: Was instrumental in the testing and implementation of business glossary tool; have researched and recommended full automated DQ population into glossary tool; have drafted process workflows and SOPs, have submitted LDAP access requests for the team and data stewards; have performed Axon glossary repository SuperAdmin functions such as LDAP synchronization, dropdown configurations, custom fields, system interfaces/lineages, bulk uploads/updates, default workflows.
  • Have validated glossary terms and participated in Stewardship Community working sessions. Have successfully led upgrade to Axon Release 6.3 and migration of workflows to Production. Used Toad Data Point and Data Studio to write/and run SQL queries to validate Reference Data in Sailfish platform.
  • Have designed, and overseen initial development of DGO SharePoint site. Have designed and documented self - training materials, mentored, and helped peers on using Axon and connecting to Sailfish. Successfully completed free Snowflake hands-on lab on personal time.
  • For the bank client, as a Data Warehouse Analyst, effectively and successfully applied business/data analysis techniques to develop and implemented data warehouse ETL application to automate generation of mortgage modeling data for forecasting cash flows and to support analytics.
  • This resulted in faster delivery and more secure process in support of SOX-ITGC.
  • Performed data mapping, data profiling/verification using SQL heavily.
  • Collaborated and worked with business partners to gather requirements into an FRD.
  • Wrote specifications for data modelers and developers, and wrote SQL scripts for testing. Performed testing documented results.

Confidential, Jacksonville, FL

Data Warehouse Analyst- Consultant

Responsibilities:

  • Performed as business, data warehouse analyst, data and quality analyst for Confidential Treasury Data Mart and Enterprise Credit Risk and Deposits/Loans, in a Confidential, Hadoop/HaAs, Confidential and Netezza environment.
  • Used Confidential SQL Assistant, Hadoop HUE / Impala / Hive, Aginity, Toad Data Point, SAS, MS Access, Excel and UNIX tools within a SAFe Agile framework to actively perform business and data analysis.
  • Contributed heavily to data warehouse/data mart integration projects and in the design, development, testing, and implementation of new functionalities and data base architecture. Performed data source identification and mapping with business and technology. Wrote use cases/stories in MS Word and JIRA. Actively contributed to daily team stand-ups.
  • Wrote and ran SQL queries for data analysis and testing, working with developers and other off-shore testers to resolve problems. Recorded defects on JIRA and Excel reported and followed up on defect status.
  • Contributed to planning, estimating, deployment and process improvement.
  • Led meetings to discuss requirements, design, and testing.
  • Tutored and guided developers on application processes and SQL code. Drafted data modeling diagrams.

Confidential, Jacksonville, FL

Data Warehouse Analyst

Responsibilities:

  • For the bank client, used Confidential SQL Assistant, Toad, SAS (Enterprise Guide), MS Access, Excel and UNIX tools to actively perform business data analysis for Confidential -based Confidential Treasury Data Mart and Confidential -based Credit Card risk/charge off data warehouse/data mart integration projects. Contributed to design, development, testing, and implementation of new functionalities.
  • Used SAS Enterprise Guide to validate migrated data.
  • Identified various sources of data and mapped data to new or existing data warehouse database structures. Prepared design documents including data mapping documents and test plans/scripts.
  • Wrote and executed test SQL queries for data analysis and testing; work with developers and other off-shore testers to resolve problems.
  • Recorded test results and defects on Standard Analysis Package (SAP) and Quality Center; reported and followed up on defect status. Contributed heavily in planning, estimating, deployment and process improvement.
  • Created WBS, conducted meetings with stakeholders, and performed other project management tasks.
  • Chaired, led and facilitated Sr. Business Analyst Cross-Team Collaboration meetings

Confidential, Jacksonville, FL

Project Manager/Technical Delivery Manager

Responsibilities:

  • Concurrently managed and implemented multiple IT projects under budget and within schedule, resulting in savings of more than $500K and in increase in user productivity by at least 10%. Teams comprised of in-shore and off-shore members.
  • Helped Service Delivery Managers (SDM) in setting up of project repositories and in calculating financial status and forecast reports, allowing SDM to focus on service delivery planning.
  • Assisted business partners in test planning, test script writing and actual testing, resulting in the completion of project within budget and schedule. Led teams in reviewing deliverables, including use cases and UML-oriented documentation, resulting in error reduction by at least 10%.
  • Contributed actively to PMRs, recommended use of “4-blocker” form of status reporting, and by own initiative, volunteered contribution to the Project Manager Survival Guide used as reference by several teams.

Confidential, Jacksonville, FL

Project Manager/Business Analyst

Responsibilities:

  • Actively planned and tracked a $500K project to develop a Web-based Business Intelligence application using the Agile/Iterative and Feature-driven methodology, resulting in project being under budget and within schedule.
  • Established project repository on Sharepoint, helped organize team and determine infrastructure needs, and established communication process and methods, targeted to facilitate team interaction and increase team productivity by at least 12%.
  • Heavily contributed to JAD sessions with business partners and technology partners, wrote use cases, designed prototype screens, and drafted functional specifications using UML.

Confidential, Jacksonville, FL

Technical Delivery Lead

Responsibilities:

  • Concurrently managed multiple Extract, Transform and Load (ETL) data warehouse projects (Informatica Confidential environment) and implemented them under or within budget and within schedule, resulting in savings of $400K or more; led several efforts for data migration.
  • Established project repositories and stored documentation in those repositories, resulting in better team communication and in increase in project manager productivity by at least 10%. Helped consolidate and define processes within the data warehouse Service Center, resulting in leaner Helpdesk and use of outsourcing and in annual savings of more than $300K.

Confidential, Jacksonville, FL

Data Warehouse Analyst

Responsibilities:

  • Established business rules and data usage standardization around the Confidential enterprise data warehouse, resulting in standardization and reuse of solution and increase in developer and user productivity by at least 10%.
  • Wrote SQL code to generate ad-hoc reports from the Confidential data warehouse, resulting in increased customer satisfaction. Reduced Helpdesk request backlog by 15%.

Confidential, Jacksonville, FL

Data Warehouse Analyst

Responsibilities:

  • Developed Hyperion Brio ad-hoc reports to extract data from Confidential data warehouse on a timely fashion, resulting in increase of customer satisfaction by at least 10%.
  • Performed data analysis and produced timely critical reports for a $52 billion merger/acquisition project.

Hire Now