Sap Bi Consultant resume examples

Choose and edit as your own

Get inspired by the best resume examples picked for your profession and create your!

Add pre-written phrases

Describe yourself as a professional just in 2 clicks! All the phrases you need are prepared by us

Save and Download your Resume

Save it in PDF format. Ready-to-sent to you employer!

This resume is created in 7 minutes.
Professional Summary
  • Experienced Solution Architect with deep expertise in handling data from consumption till retirement
  • Proven expertise in data preparation,validation and visualization for analytics and data exploration from structured,semi-structured data in an enterprise data lake
  • Deep understanding of Datawarehouse and Business Intelligence concepts and solutions
  • Dedicated and hard-working with passion for Big Data and Analytics
Skills
  • Data Architecture
  • Data Modeling
  • Data Analytics
  • Data Preparation
  • Data Governance
  • Data platform management
  • Data analysis & validation
  • Data visualization & discovery
  • Metadata programming
  • Hadoop
  • AWS
  • Ab Initio (Query IT, GDE)
  • PL/SQL
  • Tableau
  • PowerBI
  • SAP Lumira
  • IBM Datastage
  • SAP Business Objects
Work History
Solutions Architect, Big data & BI applications, 10/2015 to Current
TATA Consultancy Services Singapore

Customer - Singapore Airlines

 

  • Solution architecture for Big data applications, to ingest data from 30+ structured sources and 5+ unstructured sources
  • BI consultant and advisory, working with data strategist to create and maintain an enterprise data strategy
  • Subject matter expert in exploratory data analysis for analytical use cases
  • Data preparation from the raw data lake to extract insight for analytics and data discovery, using Ab Initio (ETL) on HDFS (on AWS)
  • Design and maintenance of data lake ingestion,obfuscation for security and data validation using metadata driven programming, reducing code changes and increasing turn around time for delivery
  • Data visualization through interactive dashboards and visuals in Tableau, PowerBI
  • Data modeling to establish a data schema and business metadata for the data prepared
  • Working with IT team to craete a data governance framework for the enterprise data lake
  • Participate in RFP activities such as solutioning, proof-of-concepts building and data architecture design and presentation
  • Assistance in Hadoop platform management using Amabari
  • Tools used: HDFS on AWS for data storage, Ab Initio Graphical Development Environment (GDE) and SQL for ETL and data preparation, Ab Initio Query IT for data federation/virtualization, Tableau, MS Excel, PowerBI for data visualization




Data Architect and SME, DW BI applications, 10/2011 to 09/2015
TATA Consultancy Services Singapore

Customer - Singapore Airlines

 

  • Create and maintain a Next- Gen Datawarehouse and Business Intelligence application roadmap for the customer
  • Participate in requirements meetings to understand business needs and formulate functional and technical specifications
  • Solution architecture and data models based on business requirements
  • Develop and implement interactive reports created using SAP Business Objects
  • Review and optimize existing DW BI application architecture
  • Recommend data standardization rules to ensure data integrity
  • Mentor junior team members in domain and technology
  • Architected the solution for the migration activities in upgrading SAP Business Objects from XI to SAP Business Intelligence 4.1
  • Developed and implemented proof-of-concepts for fast data transfer and created management dashboards using data from SAP BW cubes and SAP Business Objects
  • Reduced the Datawarehouse applications incidents by 15%
  • Tools used:  SAP Business Objects BI4.0, SAP BW 7.0, SAP Lumira, Tableau 9.1 & 10.0 for data visualization and reporting, IBM Datastage 11.5 for ETL, IBM DB2 1.0 and Oracle 10g for data storage

 

Developer, DW BI applications, 03/2009 to 09/2011
TATA Consultancy Services Chennai, India

Customer - Singapore Airlines

 

  • Build data pipelines to transport data between source to Enterprise Datwarehouse using ETL jobs
  • Build SAP Business Objects semantic layers(universe) to facilitate adhoc reporting
  • Create physical data model in IBM DB2 and Oracle 10g as per the technical design, arrived from the business requirements
  • Optimize ETL/ SQL jobs for improved data transfer to the data marts
  • Document and maintain functional and technical solutions
  • Ongoing support and maintenance of Datawarehouse and Business Intelligence applications
  • Tools used:  IBM Datastage 8.5 for ETL, BO6.5, SAP Business Objects BOXI R2/R3 for reporting,IBM DB29.7and Oracle 10g for data storage


Trainee, DW BI, 12/2008 to 02/2009
TATA Consultancy Services Chennai, India


  • Trained in Datawarehouse and Business Intelligence concepts, tools and techniques
  • Trained in data modeling techniques like dimensional modeling and snowflake schema
  • Trained to draw out data architecture for BI applications to build a data pipeline for data copy from source to data marts or enterprise datawarehouse
  • Trained to develop a data mart from requirements to deployment
  • Tools used:  ERWin, MS Visio, MS Excel



 

 


Recognitions
  • Recogized and appreciated by TCS & customer for assisting analytics project with data understanding in an effecient and expert manner
  • Appreciated for modeling and delivering mini data marts for data access from the enterprise data lake
  • Appreciated and badged as 'Star performer' by TCS for completing the proof-of-concepts in data lake and metadata programming as part of RFP response for customer
  • Acknowledged for establishing an efficient method of reporting data from SAP BW in SAP Business Objects, eliminating data movement
  • Appreciated by customer for solutioning SAP BO service pack upgrade, to mitigate migration costs and ensure smooth reporting with no disruptions to business 
  • Recognized for grooming and mentoring team members on Datwarehouse and Business Intelligence concepts 

 

 

Education
Bachelor of Science: Computer Science & Engineering, 2008
Sri Krishna College of Engg. & Technology,Anna University - Coimbatore
Graduated with 86%


High School Diploma: 2004
Bharatiya Vidya Bhavan - Coimbatore
Graduated with distinction - 95.75 %
This resume is created in 7 minutes.
Summary
IT professional with excellent analytical ability, time management skills and capacity to multitask. Develop, support, and maintain web-based, client-server, batch, and database applications. Thrive on new challenges and excellence in job performance. Excellent interpersonal, communication, and organizational skills with an emphasis on teamwork. Ability to establish and maintain long-term customer relationships while building trust and respect by consistently meeting and exceeding expectations. Strong background in planning, installation, and maintenance of systems. Worked effectively as a programmer/reporting analyst/DBA for many customized systems.
 
Versatile IT professional with vast knowledge of Enterprise Project Lifecycle methodology. Network engineering expert with strong background in project management and product support.
 
IT Manager successful at defining market and customer requirements. Offers [Number] years in project management, including software product releases and hardware design changes.
 
Skills
  • Tableau Desktop,Teradata Enterprise Data Warehouse, DMExpress ETL, SQL Server 2008, SQL Server 2005, SQL Server 2000, SSIS, SSRS, Business Objects, Crystal Reports, SAP Information Design Tool, Epic EHR, ASP.NET, C#, Visual Basic, Mainframe AS/400 iSeries (HCA Patient Accounting), RPG code, CL code, PuTTY, Arthur Architect, Arthur Planning, Winzip, WinSCP, Applix Enterprise 7.5, and Tortoise CVS .
  • Broad Experience with Data Modeling Power Designer, SSAS, Oracle, PL/SQL, UNIX, COBOL, Visual Basic for Applications, Safari Report Writer, Lawson, File Maker, DB Analysis, Systems Analysis, Decision Support Systems, Artiva, Window Server configurations, and VPN Client.
Experience
10/2015 to 04/2017
Senior Clinical Data Analyst HCA - CSG Nashville, TN
  • Responsible for analyzing clinical and related business data in support of operational business initiatives.
  • This includes working with business partners to create metrics that enable measurement of progress toward initiative goals and ensuring that the proper data is being collected for those metrics.
  • Provide clinical data support for improvement analysis for Systems Governance and Operations initiative.
  • Manage and maintain all clinical data for Tableau development and Tableau site administration.
  • Instrumental in Enterprise Tableau upgrade process.
  • Created formalized Technical Reporting Request Intake process to streamline requests from field and team users.
10/2014 to 10/2015
BI Application Engineer/Database Developer HCA
  • Consult with HCA data warehouse architects and BI contacts to follow applicable policies and procedures revolving around Data Modeling processes, data quality and security.
  • Design and build reporting-ready SQL databases for optimal functionality with the BI application(s) selected by H2U for its internal and external clients.
  • Design and build flexible standardized and ad hoc reports as directed utilizing BI toolsets.
  • Serve as technical lead for the BI team and manage the work of junior database developers and BI application engineers, as appropriate, to assure timely and quality work is achieved.
  • Provide technical guidance in cross-functional task groups to identify and resolve infrastructure related issues impacting reporting (data governance).
  • Mentor other team members to develop their skills in all the BI tools the team supports as well as provide guidance to the other team members on how to consult on BI projects.
01/2012 to 10/2014
IT&S * Epic Application Leader Clarity ETL Admin/SQL DBA HCA
  • Responsible for installing and maintaining the Clarity Console that is used to bring data nightly from the Epic Caché database into the Clarity database and ensures that the Extract, Transform and Load (ETL) process is completed daily.
  • Install, configure, and maintain the SQL Server Clarity database to ensure optimal performance and integrity.
  • Established and maintain strong relationships with the entire project team, clinical leaders, business leaders, IT&S leaders, and staff.
  • Collaborate with project leadership and managers on planning, status reporting, issues management, risk management and deliverables for the assigned teams.
  • Lead efforts to develop and implement best practices, project controls, core competencies, frameworks, processes and disciplines for the assigned EPIC teams.
11/2010 to 01/2012
Application Engineer
  • Experience implementing Meditech 6.0 Data Repository technical solutions under tight time, quality, and high performance standards.
  • Provide technical guidance to business owners with technical solutions to promote business activities with utilizing SQL Server Integration Services and SQL Server Reporting Services.
  • Evaluate and analyze reporting requirements to create technical solution designs.
  • Assist other developers to meet corporate development standards.
10/2007 to 04/2017
HCA
10/2007 to 10/2010
Programmer/Analyst HCA Medicare Service Center Hendersonville, TN
  • Assisted in developing, supporting, and maintaining web-based, client-server, batch, and database applications.
  • Complete application development tasks assigned according to project plan and communicate obstacles.
  • Provide technical guidance to business owners with technical solutions to promote business activities.
  • Develop and test solutions in .NET programming environment using C#, VB, T-SQL for creating DTS packages, stored procedures, and SSIS applications.
06/2004 to 10/2007
Programmer/Analyst Dollar General Corporation Goodlettsville, TN
  • Develop and test solutions designed by senior staff.
  • Perform unit level analysis.
  • Support production systems.
  • Review, analyze, and modify programmed RPG code.
  • Test, debug and complete documentation for programs.
  • Support merchandising systems and verify daily production system data.
  • Utilize the AS/400 System functions to effectively create files for reports used by other departments for analysis.
  • Read and initiate UNIX commands to execute day-to-day procedures.
Education and Training
February 2015
Masters of Science: Healthcare Informatics David Lipscomb University Nashville, TN Healthcare Informatics
December 2002
B.A: Computer Information Systems Business Administration Middle Tennessee State University Murfreesboro, TN Computer Information Systems Business Administration
Skills
.NET programming, ASP.NET, Accounting, streamline, ad, application development, Applix, Architect, AS/400, BI, Business Objects, CL, client-server, COBOL, Crystal Reports, Client, clients, CVS, Data Modeling, DTS, data warehouse, database applications, databases, database, Decision Support, documentation, ETL, functional, Information Design, Lawson, Mainframe, Meditech 6.0, Mentor, merchandising, C#, SQL Server 2000, Window, Enterprise 7.5, Enterprise, Oracle, DB, PL/SQL, policies, processes, progress, project leadership, quality, Read, Report Writer, reporting, risk management, RPG, SAP, SQL, SQL Server, Systems Analysis, Tableau, Teradata, T-SQL, UNIX, upgrade, VPN, Visual Basic, Visual Basic for Applications, VB, Winzip
This resume is created in 7 minutes.
Professional Summary

Senior IT Professional with passion for proactive data-driven solutions approach. Versatile, resourceful, collaborative problem solver in various domains. Expert user of diverse technologies with emphasis on Big Data, Business Intelligence (Expert knowledge of OBIAA/DAC/ETL) & Data Warehousing (DW).

• Software Engineering including Business Intelligence and Big Data.

• Project Management including Planning, Development, Monitoring and Control.


• Business Automation including Finance, Investment Operations, Technology Operations, Manufacturing, Oil & Gas, Chemicals.

Skills
  • Big Data : Hadoop, HDFS & MapReduce, Pig, Hive, HBase, Sqoop, Spark, Oozie, Zookeeper, IDE (Eclipse)

  • Distribution : HortonWorks, Cloudera

  • BI : Oracle BI, OBIA, Business Objects, SAP, IBM COGNOS, Informatica, ODI, DAC
  • Amazon Redshift, HBase, Hive
  • Oracle SQL Server, DB2, Sybase, Teradata, SQL Anywhere, MySQL, PL-SQL, Transact-SQL, etc.
  • Languages : Programming (R, Java, JavaScript, C, C++, Pig Latin, Hive QL, etc.), Markup (HTML, JSON XML), ABAP  
  • Other Tools : Microsoft Visual Studio, Essbase, SmartView, Erwin, ER Studio, TOAD, SQL Server Mgmt Studio, etc.

  • UNIX Shell scripting, C/Korn shell; Cron; Autosys scheduler
Work History
Senior BI Architect, 01/2012 to Current
Invesco Houston
  • Architected several custom data warehouses, analytics and reporting system providing comprehensive data correlations, trends and many other performance indicators to assist in Investment operations
  • Led team and actively participated in overall project planning, design, development,
and deployment of the solution. Solution included BI, Data Warehousing technologies (Oracle BI, XML Publisher, Informatica ETL, etc.) and Big Data technologies (Hadoop, Pig, Hive, Sqoop, HDFS, etc.) 
  • Installed, configured OBIAA 7.9.6.4/DAC/Informatica 9.5.1 ETL on Windows platform and customized AR/AP/GL/Projects star schemas for performance and to suit Invesco data; customized rpd/webcatalog 
  • Hive development using Partitioning/Bucketing, Data import/export to/from SQL Server/HDFS using Sqoop, Data massaging using Pig, NoSQL databases such as HBase, Cassandra; Lambda architecture; Zookeeper and Oozie for cluster management and workflow management  
  • Architected the overall BI solution and led design team in modeling the BI layer data model based on the source data. Rationalized 5800+ legacy reports to just 100+ during requirement analysis.  
  • Knowledge of AWS EC2, EMR, S3, Redshift

  • Worked, with Data governance teams to establish data standards; with business stakeholders, executives, to establish KPIs, goals; with vendors to monitor/ensure SLAs

  • Excelled in providing architectural solutions to business and IT teams through collaboration and innovation
  • Established/championed best practices and led build teams through implementation. Managed the BI team through the lifecycle of the multi-year program
  • Architected BI solutions for HR, Payroll, Compensation, Financials, AR/AP, etc. in database sizing, datawarehouse design, metadata layer design, ETL design, visualization and security
Senior BI Architect, 01/2000 to 01/2012
Multiple Fortune 500 clients Houston
  • Architected several custom data warehouses, ETL, analytics and reporting systems for various Fortune 500 clients throughout the US. 
  • Designed, architected and built several custom applications/ETL/Datamarts and star schemas/Subject Areas in OBIAA 7.9.x for including HR Recruitment, HR Performance/Talent, HR Staffing, Global Payroll, Assets Under Management, Account Holdings, AR/AP/Projects and others
  • Architected security design in OBIEE with AD/SSO/SAML2
  • Architected migration methodology of RPD
  • Conducted Architectural reviews of ETL design, Datawarehouse/Datamart (star schema) designs and rpd configurations
  • Wrote standards documents for Security, ETL, RPD development, MUD, Catalog, Dev to UAT to Prod migration procedures 
  • Architected and implemented multi-layered MUD for multiple Projects to work in parallel development streams 
  • Mentored team on Datawarehouse concepts, star schemas, migration procedures
  • Configured ODI 11g as part of Oracle Knowledge Management implementation. Created master & work repositories and configured ODI connections for source and target systems in topology
  • Experience in ODI designer, Topology, Operator and ODI Tools and performance Tuning in Oracle Data Integrator 
Senior Principal Consultant, 01/1991 to 01/2000
Various Fortune 500 Clients Houston
  • Architected solutions for Chemical companies for MM and SD modules in SAP; implemented ABAP, workflows and Archiving solutions to streamline SD and MM
  • Oversaw a team of developers in various SAP projects
  • Architected Warehouse solutions as a Sybase DBA in multiple client sites for a Big Six firm
  • Implemented several Oil&Gas projects implementing Access, PowerBuilder, C with Sybase, UNIX Shell scripts​
Education
Master of Science: Computer Science Sam Houston State University - Huntsville

Bachelor of Science: Electrical Engineering Texas A & M University - College Station
Personal Information
  • Willing to travel 
  • US Citizen
This resume is created in 7 minutes.
Professional Summary
Experienced IT Technician committed to maintaining cutting edge technical skills and up-to-date knowledge. Seeking a position in Information Technology and Customer Service where my extensive experience will be further developed and utilized. And to obtain a position that will enable me to use my strong organizational skills, educational background, and ability to work well with people.
Skills
  • Excellent problem-solving abilities
  • Website and portal monitoring
  • Network maintenance
  • System upgrades
  • Oral Communication
  • System backups
  • Data backup and retrieval
  • Remote access technology
  • Attention to Detail
  • Excellent communication skills
  • QA tools
  • Enterprise technologies
  • Excellent diagnostic skills
  • Customer Service
  • Quality assurance
  • Fast learner
  • Skilled multi-tasker
  • Skilled in HTML, HTTP and IP
  • Rapid data entry skills
  • Goal-oriented
  • Self-sufficient
  • People-oriented
  • Positive
  • Excellent time management skills
  • Detail-oriented
  • Network development and administration
  • System development and administration
  • Hardware and software installation
  • Servers expertise
  • Operating Systems
Work History
Network Engineer, 09/2018 to Current
B&D Consulting Inc. / DISA Montgomery, Alabama
  • Design, build, test, deliver, and maintain networks systems, including work with Cisco, Juniper and Palo Alto.
  • Plan, commit, deliver and improve sprint after sprint.
  • Contribute to existing tech stack and actively research and advocate for new tools, technologies and methodologies.
  • Configure and build lab environment to mirror production environment.
  • Solid experience with Cisco, Juniper and Palo Alto devices
  • Experience with packet capture and analysis tools, WireShark, TCPDump
  • Experience with routing protocols (BGP, OSPF, VRF, MPLS, EIGRP)
  • Understanding of protocols including: Qos, Cos, RADIUS, TACACS+SNMP DNS, HTTPS, NETFLOW
  • Experience with Access-Control List, Firewall policies, Route Filters and other permission methods
  • Conduct/Coordinate Communication LOB Incident Break-Fix Response
  • Provide Communication LOB reporting to Computing Ecosystem C2
  • Manage ASI & Change process
  • Gather & Analyze Data for Service Improvement
  • Ensured continuity of operations by introducing the automation of monitoring system for 24/7 network systems.
  • Analyzed and defined network requirements, configurations, optimization, and support for network servers, routers and switches.
  • Configured, managed and evaluated multi-protocol network elements to ensure effective end-to-end communications.
System Administrator, 09/2016 to 06/2018
Vectrus Baghdad, Iraq
  • Daily administration of Exchange 200X servers, Outlook Web Access, and Microsoft SCCM.
  • Extensive knowledge of UNIX operating systems, UNIX shells, standard utilities, and common UNIX security tools
  • Trained with Information Assurance Officers on eMASS & RMF
  • Performed ACAS Scans
  • Deep system administration knowledge and skills for Solaris version 8 and 9 such as experience in building, deploying, configuring, and troubleshooting Solaris
  • Managed a Cyber Security and an Information Assurance program, protecting and defending information systems to ensure confidentiality, integrity, and availability 
  • Performed Information Assurance duties that include strategic planning, capital planning, workforce planning, policy/standards development certification requirements, investment analysis and open storage facilities management 
  • Ensured open storage facilities are operated in compliance with DoD regulatory guidelines
  • Maintained awareness of Federal, DoD, and DA regulatory policies, guidance and procedures that relate to Information Assurance. 
  • Maintain Systems Availability and perform regular maintenance on equipment.
  • Proficient at hardware maintenance and troubleshooting of various vender Server platforms including Dell, HP.
  • Optimized system security and performance with proactive changes.
  • Ensured network, system and data availability and integrity through preventative maintenance and upgrades.
  • Conducting security assessments through vulnerability testing and risk analysis
  • Performing both internal and external security audits
  • Experience in configuration management, trend analysis, customer training and developing customer user manuals.
  • Analyzing security incidents to identify the root cause
  • Creates logon and email accounts using Microsoft Exchange Server and User Manager.
  • Manages Network Services with Server Manager, Print Queue.
  • Operates and maintains all aspects of server administration to include but is not limited to Microsoft 200X Active Directory, WINS, DNS, DHCP, print queues etc.
  • Installs, configures, and maintains DOD-approved communications software on government computers and configures the network to allow proper user access.
  • Installs and configures network printers.
  • Joins client computers to Microsoft Active Directory domains.
  • Configures Microsoft Outlook and manages personal folders in all versions of Outlook.
  • Installs, configures, and maintains security software on military computer systems.
  • Repairs and maintains desktop and laptop hardware.
  • Maintaining antivirus / security requirements by the US Army standards and regulations.
  • Provides user and Microsoft Exchange account maintenance as required.
  • Provided documentation on start-up, shut down and first level troubleshooting of processes to help desk staff.
  • Resolved issues and escalated problems with knowledgeable support and quality service.
  • Worked with users to determine areas in need of improvement.
  • Configured, tested and maintained network equipment.
  • Experience reviewing my own information technology-related work or data and have been asked by others to review their work or data to ensure accuracy, completeness, and consistency with standards.
  • Experience maintaining relationships with customers, assessing current information technology needs of customers, and developing or identifying information technology products and services that are tailored to meet customer needs.
  • Briefing mid-level management and IT staff on the status of information technology systems, projects, or daily operations, including the communication of technical information to a non-technical audience.
  • Identifying alternatives to address complex information technology-related issues by gathering and applying information from a variety of sources that provide a number of potential solutions.
MCC SAP Operator, 03/2014 to 09/2016
Hyundai Information Service North America Montgomery AL
  • Coordinates the needs of functional departments and establishes priorities for MES requirements gathering, system design and implementation.
  • Works on complex MES recipe configurations to meet requirements of manufacturing and QA users.
  • Responsible for MES documentation
  • Review of company documentation including SOPs, SPECs, Batch Sheets and/or Manufacturing Records to assess MES impact.
  • Works with Validation and Quality Assurance departments to ensure MES is implemented following development life cycle approach.
  • Provides end-user support for the MES including troubleshooting problems at the application server level.
  • Windows 7 Migrations from Windows XP
  • Hardware & Software troubleshooting and updates

IT Field Technician, 12/2013 to 04/2014
GDH Government Services – Alabama Department of Corrections Montgomery AL
  • Post-sale installation, optimization, maintenance, and management of mobile communication systems.
  • Focuses on maintaining optimal performance levels across an integrated system.
  • Windows 7 Migrations from Windows XP
  • Hardware & Software troubleshooting and updates
  • Performs system hardware and software installation and optimization.
  • Manages system availability through routine system maintenance and performance monitoring.
  • Provides primary point of contact for 2-5 customer sites that require end-to-end performance monitoring and management.
  • May also be dedicated support providing system maintenance or management for a single customer.
  • Coaches others in troubleshooting with computer based tools.
  • Understands technology, system interfaces, and functionality of the system.
  • Understands requirements of system optimization, verification, and audit testing in ensuring system performance.
  • Advanced knowledge of computer systems and Intermediate knowledge networking.
  • Ability to use computer to perform diagnostics remotely or locally across a network.
  • Ability to learn to use computer operating systems and common application for characterizing and resolving issues for multiple technologies. (Example: Unix, DOS, NT, Windows 98 and 2000).
  • Intermediate knowledge of hardware and software tools available for both RF and Networking.
Pit Boss/Supervisor, 10/2010 to 05/2013
AFNETOPS Enterprise Service Desk ESD Montgomery AL
  • Provide prompt and courteous customer service
  • Provide end-user, Client Support Admin (CSA) and Network Computer Center NCC) phone support
  • Experience/familiar with Active Directory
  • Create, modify, move and assign mailboxes
  • Create, modify, move, delete and restore distribution lists
  • Experience/familiar with Remedy trouble ticketing
  • Provide user orientation on desktop hardware and software
  • Analytical/technical troubleshooting skills in hardware and software
  • Experience troubleshooting hardware, software and network connectivity issues
  • Remotely diagnostics and troubleshooting client workstations
  • Apply VPN Service Experience with Windows Server 2003, XP, OS X, and MS Office XP/03/07/08, Vista
  • Understand network topologies Installs, configures and troubleshoots systems, laptops, servers, printers and networks
  • Provided continued maintenance and development of bug fixes and patch sets for existing web applications.
  • Ensured network, system and data availability and integrity through preventative maintenance and upgrades.
  • Provided documentation on start-up, shut down and first level troubleshooting of processes to help desk staff.
  • Implemented company policies, technical procedures and standards for preserving the integrity and security of data, reports and access.
  • Consistently met deadlines and requirements for all production work orders.

Tier 2 Helpdesk Technician, 06/2009 to 09/2010
EDS Montgomery AL
  • Ensuring effective and accurate maintenance of database.
  • Entrusted with assisting assessors with important files.
  • Consistently provided the highest standards of service.
  • Answered inbound calls in support of customer needs.
  • Conveyed in a reassuring manner step by step instructions to resolve application issues.
  • Performed queries in multiple databases.
  • Adhered to government monetary regulations.
  • Developed and implemented complex Internet and Intranet applications on multiple platforms.
  • Established compatibility with third party software products by developing program for modification and integration.
  • Ensured network, system and data availability and integrity through preventative maintenance and upgrades.
  • Implemented company policies, technical procedures and standards for preserving the integrity and security of data, reports and access.
  • Developed work-flow charts and diagrams to ensure production team compliance with client deadlines.

IT Service Desk Administrator, 11/2008 to 10/2009
ERS Solutions Montgomery AL
  • Evaluate eligibility and process client
  • Educate customers and services / product
  • Recommend additional products
  • Attend training to keep informed Assist with billing and technical skills.
  • Established compatibility with third party software products by developing program for modification and integration.
  • Coordinated with systems partners to finalize designs and confirm requirements.
  • Provided documentation on start-up, shut down and first level troubleshooting of processes to help desk staff.
  • Implemented company policies, technical procedures and standards for preserving the integrity and security of data, reports and access
  • Designed strategic plan for component development practices to support future projects.

IT Service Desk Administrator, 08/2008 to 10/2008
EDS Montgomery AL
  • Deliver world class customer service and build customer satisfaction and loyalty.
  • Provide effective and timely resolution of a range of customer inquiries.
  • Strive for one-call resolution of customer issues.
  • Accepted assignments with an open, cooperative, positive and team-oriented attitude.
  • Utilized multiple call center support applications to efficiently assist customers and agents.

Education
Bachelor of Science: Business Administration, 2016
Alabama State University - Montgomery AL

Certifications

CompTIA Advanced Security Practitioner (CASP)
CompTIA Server +

ITIL v3

DISA ACAS

DISA HBSS Admin

CCNA: Routing & Switching

Security Clearance

 Interim  Secret Clearance 10/18  - Present 

This resume is created in 7 minutes.
Summary
8+ years of experience in design and development in Enterprise Data Warehouse system. *Have 2+ years of experience working in Apple Production Support as a Production Support Analyst supporting ETL activities in terms of maintenance, production migration, analysis of issues reported in production, code review and impact analysis, performing RCA and providing permanent solution. *Proficient in Teradata 13.0, Teradata 14.0, hands on experience in Oracle 11g,12c. *Good experience in SAP Business Objects. Experience in creating reports in WEBI using functionalities such as Master/Detail and Formula, Slice and Dice, Drilling, Cross Tab and Charts. *Working knowledge of creating Tableau Desktop reports comparing various data sources, data blending and visualization using filters, crosstab, charts and calculations. *Expert level experience in Teradata SQL query writing comprising multiple transaction tables and dimension table for pulling ad hoc reports, writing PL/SQL programs for data loading and reporting and for troubleshooting. *Extensive experience in using Teradata utilities like BTEQ, TPUMP, FASTLOAD, MULTILOAD, TPT, Fast Export, Fast Import. *Have designed and developed multiple Stored Procedures in Teradata for loading the data from various sources to semantic layer in a data mart for SAP Business Objects Reporting purpose applying complex BI logics. *Designed and developed shell scripts to extract and load data from one TERADATA environment to multiple environment which reduced multiple ETL processes by converting to replication process. The set up process is developed is driverless which needs just the table names and a few meta data information. *Have good experience in SQL performance improvement methods, SQL query tuning, concepts of database design, Normalization and Denormalization concepts and principle, SCD, Primary Keys, Surrogate Keys and data modeling, Star schema and Snow flake schema design approach *Good understanding of Teradata indexes, partitioning and query tuning objects (indexes, PPI, UPI, NUPI, and USI). *Extensive experience in ETL application development. Have experience in Informatica PC 9.5 developing workflows for data extraction. *Have experience in writing complex Unix shell scripts for automation tools, validation scripts to do data comparison and validation between two different sources like between Oracle and Teradata and sending email post validation with the results through automation script. *Experience in Business Analysis and Data Analysis, User Requirement Gathering, User Requirement Analysis, Data Cleansing, Data Transformations, Data Relationships, Source Systems Analysis and Reporting Analysis. *Have been working in Linux OS environment for 3 years. Good understand of FS volumes and mounts, Isilon mount concepts, file system maintenance activities. *Have good understanding of CRON job set up in Linux hosts for running file system clean up jobs and other monitoring scripts for host health monitoring. Have developed many automation shell scripts. *Expert level experience in SDLC methodologies. Key responsibilities include Requirement Gathering, Requirement Analysis, Requirement playback, Gap Analysis, Functional Documentation, Development, Test Planning, Testing, and UAT support, Production deployment and warranty support. *Have expertise in representing business requirements in the form of UML diagrams, Data analysis in the form of meaningful reports in MS Excel, PowerPoint. *Have very good understanding of Business Data Analytics, KPIs and converting the data into meaningful measures to provide more insight into data. *Proficient in analysis of SAP Business Objects reports that are being used in Decision Support Systems. *Have hands on experience in Power Designer Data Modeling tool. *Expertise in performance engineering, troubleshooting, and production support to quickly resolve major issues from the application level to the network and o/s level. *Have thorough experience in in using ticketing tools like Espresso (Apple ticketing tool), Service Now central station ticketing tool. *Experience in using confluence for project management, announcements, knowledge management. *I have experience of working in a 24 x 7 model while working as a production support analyst attending to priority 1 critical tickets, resolving issues that required initiating call and participation from various teams in case of global system breakdown. I have experience driving production issues to closure and doing the RCA and implementing the permanent fix. I have been awarded by my client on many occasions.
Skills
  • Operating System: UNIX, Red Hat Linux.
  • Scripting Languages: UNIX shell scripting
  • Scheduler : Autosys Job Schedule , Cron
  • Database: Teradata 13.0, Teradata 14.0, Oracle
  • Programming languages: Teradata SQL, PL/SQL
  • Reporting Tool: Business Objects XI R3, Business Objects XI R4 Domo Centerview Dashboard Builder, Tableau Desktop
  • ETL Platform: Informatica PC 9.5, STORM
Work History
Technology Lead / BI & DW engineer Infosys Limited
  • Date of Joining : August 2008 till date.
ETL DEVELOPER ETL DEVELOPER & BUSINESS INTELLIGENCE ENGINEER
  • Project Details: Informatica Decommission and ETL migration to Storm framework Project Desc: Huge migration project involving decommission of Informatica and migrating to Storm framework Client Details: Apple Inc.
  • Leading a team of 12 people in migrating extraction interfaces developed in Informatica to STORM.
  • Automated the migration of mapping details from Informatica repository to Storm metadata repository.
  • Developed automated scripts for control file generation.
  • Control files are used for loading utilities like Teradata TPTLOAD and TPTSTREAM.
  • Developed automated validation scripts for validating the data between source and EDW after the migration is done and data extraction is completed using Storm.
  • Developed oracle procedure to load ETL MD tables from files.
  • Developed Unix shell scripts to read text files having the input parameters and passing them as input to the procedure.
  • Planning and execution of the migration process based on criticality of the interface.
  • Migrated 3500 ETL interfaces from Informatica to Storm.
  • Project Details: Great wall China Retail FaPiao Reporting Project Desc: VAT reporting project involving data induction from SAP, building data aggregation layer and SAP business objects reports and universe development.
  • Client Details: Apple Inc.
  • Led a team of 7 members in successfully implementing a VAT reporting application.
  • Developed Informatica workflows for extracting data from SAP and loading in EDW using Teradata utilities like Fastload, Tpump, Multiload.
  • Worked on developing multiple TPT load schemas for replicating the data into other Teradata environments.
  • Developed complex PL/SQL programs in Teradata for loading aggregated tables for BO reporting.
  • Reporting was done at different granular levels and also the volume of data was very high.
  • Required proper designing for maintainability.
  • Performed extensive query performance testing by checking table skewness, CPU utilization and PI distribution and then tune the query to improve the performance.
  • Developed SAP BO Universe for reporting purpose and customized WEBI reports.
  • Helped in tuning ad-hoc reports ran by users.
  • Helped users in scheduling reports in BO.
  • ETL scheduling using Unix Scripts and Autosys Job Control shell script.
  • Worked with the analysts to understand the requirement and then transform the requirements to use case diagrams.
  • Created technical documents and detailed level design document.
  • Supply chain and Logistics reporting application development involving development of 20+ interfaces and user data management screens, building data aggregation layer and SAP business objects reports and universe development.
  • Client Details: Apple Inc.
  • Led a cross functional team in implementing a global freight costing tool.
  • Worked on developing 20+ user data management screens which are used by users for uploading meta data files having information about freight rates.
  • Understanding of the Enterprise Relationship model and source system analysis for the business area.
  • Developed validation programs in Oracle 11g for validating the data in the files by using sql loader to load the files into an intermediate table and then validating the data against the main table before loading.
  • Developed a UNIX shell script to validate the data in a file and then sending the rejected records to user in an email.
  • The shell script will access oracle database and fetch the data uploaded and then do the validation.
  • Developed a UNIX shell script to run a BTEQ script and then store the data in a file and sftp the file to a downstream system.
  • Ad-hoc loading of multiple tables by extracting data from production using Fast Export and then loading the data into UAT system by using Teradata utilities like Fastload,TPump,Multiload.
  • Developed 20+ Informatica interfaces to extract the data from Oracle database and load into Teradata database.
  • EDW core layer is developed in Teradata.
  • Developed complex Teradata PL/SQL programs to load the data into semantic layers by applying multiple costing logics provided by end users.
  • Developed BOBJ universe to prepare the semantic layer for ad-hoc reporting purpose.
  • Created Join Indexes and Secondary Indexes to improve query performance based on DBQL logs from the Database.
  • Data Validation and preparing test case report and providing support during UAT.
  • amp; BUSINESS INTELLIGENCE ENGINEER - INFOSYS 01 JUL 2010 - 31 DEC 2012.
  • Project Details: Global Repository of Information database(GRID) Project Desc: Finance reporting application reporting Billings, Booking and Revenue data.
  • Data validation, correction, ad-hoc reports creation in SAP Business objects, shell scripting, aggregation layer development and SAP business objects reports and universe development.
  • Client Details: Apple Inc.
  • GRID is a financial reporting datamart.
  • Worked as a developer and used Teradata 13.0 in building enhancements and scaling the existing system.
  • Understanding Business requirements and developing the enhancements to meet the business requirements.
  • Used Teradata 13.0 utilities to build /load the database objects for ad-hoc reporting.
  • Worked on implementing a solution to create a reporting database layer decoupled from the primary loading database.
  • Enhanced all existing tables to make them feasible to be replicated to the secondary database by using Teradata TPT load.
  • Created multiple SCHEMA files, control files, data files for developing, testing and deploying the solution.
  • Developed multiple UNIX shell scripts involving BTEQ scripts for data validation purpose and autosys job scheduling.
  • Understand the existing application and doing impact analysis to it in new requirements.
  • Helping QA team to smoothly carry out testing by providing automated scripts.
  • Performed regression testing after changing the existing application.
  • Worked in BOBJ Universe to enhance existing joins, measures, dimensions and WEBI reports to develop multiple reports for users and QA team for validation purpose.
  • Worked in improving the query performance of many existing and degraded BOBJ reports built in Teradata 13.0 by creating indexes, collecting stats , by alternative methods of accessing the tables etc.
  • Leveraging Teradata 3NF architecture in creating the Dimensional model for reporting.
  • Creation of business views for reporting purposes to be imported in the Business Objects Reporting Universe.
  • Created high level design documents, detail level design documents and functional specifications.
  • Deployment activities include the creation of a deployment plan, brainstorming with the QA and the Production teams and deploying the code in a staging environment before production.
  • Coordinate with target and functional teams for Database and ensure successful transfer of knowledge from the Development team.
  • Maintaining and supporting the production using Automated monitor Scripts and email alert mechanism.
  • Scheduling the daily upload Jobs in the AIX server using autosys jobs.
  • Support for the User Acceptance Testing in terms of Webex presence and ON call support.
  • Project Details: Executive Sales Dashboard(ESD) Project Desc: Finance reporting application reporting sales data, aggregation layer development, dashboard development in DOMO Centerview Dashboard.
  • Client Details: Apple Inc.
  • ESD is a sales reporting dashboard.
  • Analyzed business requirements, data analysis, created mock up reports , GAP analysis , came up with feasibility matrix.
  • Created POCs using DOMO Centerview Dashboard builder to see the feasibility of the tool with respect to the requirements.
  • Created database objects in Teradata 12.0 and loaded cooked up data using Fastload scripts and exposed them in the POCs for testing purpose.
  • Developed PL/SQL programs for building aggregated layer and imported them into the dashboard for building customized graphs, KPIs and tables.
  • Worked in many java script plugins for customizing the UI of the dashboard.
  • Developed many UNIX scripts for Autosys job scheduling.
  • Prepared high level design documents and detail level design documents.
  • Leveraged 3NF data modeling architecture and injected hierarchy tables like Organization, Product, Channel from reference warehouse built in Oracle database using Informatica.
  • Worked with a Global Development team across time zones meeting Development deliverables.
  • Support for the User Acceptance Testing in terms of Webex presence and ON call support.
  • amp; BUSINESS INTELLIGENCE ENGINEER - INFOSYS 01 APRIL 2009 - 30 JUN 2010.
  • Project Details: ALCHEMY Project Desc: Ops reporting application reporting production data, aggregation layer development, dashboard development in DOMO Centerview Dashboard.
  • Client Details: Apple Inc.
  • Understanding business requirements and create high level design documents and detailed level design documents.
  • Data modeling, Design and development of database objects.
  • Writing TPUMP, Fastload scripts for loading database tables for adhoc reports, POC and loading cooked up data from csv files for testing purpose.
  • Create KPIs using DOMO centerview dashboard builder by importing the tables.
  • Preparing test plan, scripts and cooking up data in DEV environment to create production scenarios and validate boundary cases.
  • Prepare implementation plan, back out plan and coordinate with multiple teams during production go-live.
  • Support for the User Acceptance Testing in terms of Webex presence and ON call support.
01/2003 to 01/2009
Restated Revenue Apple Inc
  • Teradata 12.0 Fastload was used to load data from flat files.
  • The data in the flat files were often incorrect as users manually entered them.
  • Validated the data in excel sheet with source data and report the cause of mismatch.
  • To make the figures visible for reporting, I had to make the universe level changes to include new views, classes, sub-classes, measures Training(25-Aug-2008 - 31-Mar-2009) Completed 7 months training in Basic Computer Science subjects, C programing, Java and .Net conducted by Infosys Technologies at Mysore, India.
  • Have attended various management programs organized by Infosys Leadership Institute.
  • The programs mainly dealt with professional etiquette training, interpersonal communication skill development, Business Communication skill trainings, Time Management programs etc.
Education
2008
B.Tech:
Examination Year of Passing Board/University Kalinga Institute Of Industrial Technology ,KIIT University -
2001

CBSE Board - New Delhi
This resume is created in 7 minutes.
Objective

I am looking to work with the student in the Gallatin School of Individualized study.

Skill Highlights
  • Crisis Counseling.
  • Psycho-educational evaluations.
  • Strategic Planning.
  • Leadership Development.
Presentations

Addressing the need for professional mentors among African American and Latino male college students, CUNY Black Male Initiative Conference, June 2015


Education and Training
MA, Mental Health Counseling 2009 Nyack College - New York, NY
BA, Health Science 2002 Binghamton University, State University of New York - Binghamton, NY
Professional Experience
Psychology Instructor Dec 2014 to Current
St John's University - New York, NY
  • Collaborate with the Counseling center to service at risk students.
  • Assist students with course selection during registration.
Training and Policy Consultant Sep 2014 to Nov 2015
NYC Department of Probation - New York, New York
  • Designed a trauma competency training for sixty probation officers.
  • Established protocols for providing services for high risk adolescents.
  • Assisted the Deputy Commissioner in addressing staff conflicts.
Consultant/Facilitator Feb 2013 to Aug 2015
Mary Pender Greene Consulting Services - New York, NY
  • Facilitated De-briefing sessions during the Undoing Racism trainings.
  • Provided leadership coaching for Cure Violence staff members.
  • Facilitated experiential learning activities for the annual staff retreat.
Bi Lingual Trauma Specialist Oct 2011 to Oct 2013
New York Foundling Hospital - New York, NY
  • Provided weekly therapy to fifteen high risk families.
  • Revised the clinic's trauma assessment screenings.
Certifications

Licensed Mental Health Counselor (LMHC), New York, 2011

Languages

Fluent in Spanish, Studying Portuguese.