SUMMARY:

• I am a Business Intelligence Consultant with over ten (10) years of experience in Information Technology.
• His primary area of emphasis is within the collaboration between business users and technical staff in the Business Intelligence area.
• He has experience within the areas of data analysis, requirements analysis, requirements gathering, Business Intelligence reporting, data warehousing, agile development, data masking and data modeling. He is proficient in requirements gathering, analysis, conversion, traceability, development and deployment of reports. Quickly learning database logic has given him the abilities to analyze, map, extract, transform and load efficient data structures.
• While integrating his experience and knowledge in the Business Intelligence area with his excellent documentation and communication skills, he is an efficient and effective liaison between business users and technical staff.

TECHNICAL SKILLS:

Operating Systems: Windows 8/7/10/Vista/XP/2000, Unix

Languages: T - SQL, HTML, Java, J#, C#, C++, Python, Perl

Databases: MS SQL Server, Netezza, DB2, Oracle, Teradata

Tools: Cognos, Business Objects, Informatica, MicroStrategy, Crystal Reports, Visual Studio 2003/2005/2008, Eclipse, Jcreator, Netbeans, Bluebird, Adobe Photoshop 7.0-CS5, QTP, Microsoft Office Suite, Quality Center

PROFESSIONAL EXPERIENCE:

Confidential

Business Intelligence Business Analyst

Responsibilities:

• Completed initial profile of deposit account source system data using Informatica Analyst
• Assisted with data mapping for a Moody’s application POC to satisfy Liquidity Cash Reserves federal reporting requirements
• Assisted with data mapping for a parallel effort to understand the cost to develop a similar solution internally
• Worked with a modeling resource to conform source system deposit account data into Teradata-provided Financial Services data model
• Established generic template for source to target mappings leveraged by EDW team
• Gathered and documented requirements to map source system data into a data warehouse and into an outbound data extraction layer
• Developed intermediate data model to translate between data warehouse model and third-party reporting solution model
• Designed and developed test plans and test cases for system and integration testing phase
• Coordinated timelines between testing and development teams and reported status of deliverables to management
• Created mappings for 493 data elements across 12 source systems
• Conducted root cause analysis and defect resolution during SIT and UAT
• Engaged with Data Governance to consolidate regulatory reporting requirements from several projects into a discrete set of critical data elements
• Led the iterative process to define transition requirements to move from a temporary customer data system into an enterprise MDM/party solution
• Supervised a team of fellow analysts and coordinated project activities to meet project deadlines Confidential .
• Provided scoping estimates for redevelopment of a large query and associated business rules

Confidential

Responsibilities:

• Worked with subject matter experts to expand the list of desired “business rules” for reporting from 32 rules to 46
• Worked with Confidential reporting and ICC resources with banking experience to define the business value and relative complexity of each business rule
• Developed 10 reports in Cognos Report Studio from existing source system data
• Conducted 16 interviews with 22 SMEs to collect requirements and sample reports
• Produced comprehensive meeting notes for the 16 SME interviews
• Created Business Strategy document to capture reporting requirements and data availability from source systems for 14 source systems
• Completed 21 Report Technical Specifications documents and associated wireframes based on business rules and reporting requirements
• Formulated a short-term and long-term reporting strategy for Confidential, including many best practices recommendations to enhance reporting capabilities and improve value driven to customers
• Performed an initial survey and mapping of key data within source systems

Confidential

Responsibilities:

• Conducted interviews with business subject matter experts to define requirements for four reports and two dashboards
• Documented the existing and desired business processes for reporting
• Created documents for the business, technical, and functional requirements based on business reporting need
• Conducted a knowledge transfer of business processes and requirements to the reporting development resource

Confidential

Responsibilities:

• Coordinated the mapping and standardization of seven source files from five external vendors
• Expanded a list of four existing business rules to thirty five business rules
• Communicated the business rules, business logic, and any approved decisions to the ICC team, business, data warehouse, and testing teams to ensure a clear understanding across the organization
• Used an agile approach to elicit, document, and obtain sign-off on requirements for an Enterprise Report, Enterprise Dashboard, and ad-hoc reporting solution
• Facilitated communication between the business, external vendors, and data warehouse staff
• Created traceability documentation for ETL processes from source files to target databases
• Designed and developed business process flows for new business processes
• Maintained scope defined in the SOW, and managed timelines to hit appropriate releases
• Performed data analysis on the source files sent by external vendors to ensure the appropriate data was contained and would match with existing reports for User Acceptance Testing

Confidential

Responsibilities:

• Assisted in an assessment of the enterprise-wide reporting environment to baseline against industry best practices
• Interviewed 130 business stakeholders to ascertain the current state and common pain points of the Business Intelligence environment within Battelle
• Created documentation around the “As-is” architecture of the reporting organization
• Inventoried 80 dashboards and 96 reports to perform a gap analysis on Battelle’s information needs and the existing offering
• Assisted in creating a five-year roadmap based on Battelle’s specific information needs, organizing manageable projects and directives in a five-year timespan after weighing complexity and business value
• Managed and met deadlines for over 200 pages of documentation around the above process

Confidential

Responsibilities:

• Interviewed business stakeholders to identify business questions and business terms
• Helped set up and lead the approval process for standardizing business definitions to establish a data dictionary
• Prototyped four legacy reports in Microstrategy, with supporting design documentation

Confidential

Responsibilities:

• Created requirements to enhance and alter current reporting utilizing Maximo and Excel into concise reporting utilizing Crystal Reports.
• Met with business users and department managers to distinguish the essential elements for reporting. These requirements encompassed new features, enhancements and deletion of irrelevant reporting information.
• Defined and documented the ten key performance indicators from the business and provided document source target and mapping for effective and efficient reporting.
• Utilized Quality Center to upload necessary requirements for new reporting and worked alongside with the report development team to ensure satisfaction and completion.

Confidential

Responsibilities:

• Broke down 43 source systems in order to provide necessary documentation for 17 financial reports to provide the Federal government. The Federal government required specific transformation data in order to comply.
• Worked with SME’s for each source system to define essential information for proper execution of each report.
• Provided detailed mapping documentation and display information for clear process of report origination from source system data to federal reports.
• Worked as a liaison between data architects and SME’s to provide detailed mapping and source to target information.
• Troubleshot report generation issues and defined root cause from the data warehouse. Reports were executed utilizing the MicroStrategy tool kit.

Confidential

Database Developer/Functional Analyst

Responsibilities:

• Responsible for change requests for Informatica mappings. Responsibilities include navigating change requests, coding for changes and updating all necessary documentation to reflect change requests.
• Performed data discovery on five data warehouse applications housing over 25TB of data.
• Coordinated with Subject Matter Experts to identify sensitive fields and define masking rules for over 200 tables.
• Created a high-level and low-level design document detailing the masking process and received sign-off from SMEs.
• Created mappings to execute the defined masking rules and performed unit testing to ensure compliance and validity.

Confidential

Data Administrator/Functional Analyst

Responsibilities:

• Achieved Service Manager 7.x Certification through HP Partner Portal.
• Assisted in defining roles and responsibilities for sustaining data administration.
• Standardized and implemented conversion of assignment groups from legacy tool into Service Manager.
• Facilitated operator loads for testing, training, and production readiness.
• Participated in input sessions from customers to survey data needs.
• Assisted with Early Life Support for rollout of HP Service Manager System in production environment.

Confidential

Level 3 Compute Server Engineer

Responsibilities:

• Performed over 35 virtual assessments on more than 2500 target servers.
• Decreased cycle time for virtual assessments from 35-45 days to 3-6 days.
• Reduced unnecessary or extra server backups generating $500,000 per year in savings.
• Created an automated dashboard to track future candidates for backup cost-out.
• Performed a proactive virtual assessment with a 97% pass ratio, resulting in $1.7million per month in possible savings opportunities after virtualization.

Confidential

Unix System Administrator

Responsibilities:

• Lead project to standardize new Network Time Protocol servers.
• Piloted and changed tools for Unix patching, reducing the number of overall errors and decreasing the time commitment for system administrators.
• Modified and documented a Python script to track defects in the environment.
• Updated the weekly server detail report with necessary changes to track defects.
• Created a script that checked errors in software/hardware on newly built servers.