Big Data Consultant Resume
Minneapolis, MN
SUMMARY
- Results - driven analytics professional with excellent technology background and strong business acumen coupled with 4+ years of working with Big Data technology stack and 7+ years of overall experience in business modeling, requirements gathering and management through all phases of SDLC.
- Demonstrable experience in Big Data space and challenges in multiple verticals (Finance and Healthcare) through a strategic roadmap and thorough data understanding for data collection, transformation, warehousing and analysis.
- Extensive experience in all stages of Software Development Life Cycle.
- Extensive experience leading, facilitating conducting Joint Application Development (JAD) sessions among user community, stake holders and technical management, creating project plans and schedules and managing changes.
- Experience in for requirements gathering, analysis, design in Rapid Application Development (RAD) sessions to converge early toward a design acceptable to the customer and feasible for the developers.
- Interact with stakeholders in various Big Data initiatives, understand the Data needs and define Data Services product requirements
- Provide consulting to customers in identifying Big Data use cases and then guiding them towards implementation of use cases.
- Support development, testing, and operations teams during new system deployments.
- Coordinated with technical team for installation of Hadoop & production deployment of software applications for maintenance.
- Formulated procedures for planning and execution of system upgrades for all existing Hadoop clusters.
- Work with support team on Hadoop performance tuning, configuration, optimization and job processing
- Supported technical team members for automation, installation and configuration tasks.
- Suggested improvement processes for all process automation scripts and tasks.
- Provided technical assistance for configuration, administration and monitoring of Hadoop clusters.
- Participated in evaluation and selection of new technologies to support system efficiency.
- Experience in conducting GAP analysis, System Integrated Testing, User Acceptance Testing (UAT), SWOT analysis, Cost Benefit analysis, ROI Analysis and Requirement Traceability Matrix (RTM).
- Understands the components of running a fiscally successful project.
TECHNICAL SKILLS
Project Management Methodologies: UML, SDLC, RUP, AGILE/SCRUM, WATERFALL
Requirement Management: Requisite Pro, Clear Quest, MS Source Safe, Clear Case, RTM, Test Manager, Quick Test Professional, Load Runner, Rational DOORS
Project Management / COTS: MS Suite (Word, Excel, Access, Power Point, Project), Team Foundation Server, SharePoint 2013
Design Architecture / OS: Windows, Unix
Big Data / Reporting: SQL Reporting Services (SSRS), Tableau, SSIS, Hadoop, HDFS, Pig, Hive, HBase, Oozie, Sqoop, Kafka, Python, R (Beginner)
Industry Standards: HIPAA, Six Sigma, HL7, EMR
Languages: C, C++, Java, SQL, HTML, Perl, XML, JSON
Databases and Testing: SQL, Oracle, DB2, MS Access, Test Director, HP Quality Center, UAT, SIT
Management Techniques: SWOT Analysis, Demand Analysis, Change Control, Incident Management
PROFESSIONAL EXPERIENCE
Confidential, MINNEAPOLIS, MN
Big Data Consultant
Responsibilities:
- Responsible for the installation, configuration, maintenance and troubleshooting of Hadoop Cluster. Duties included monitoring cluster performance using various tools to ensure the availability, integrity and confidentiality of application and equipment.
- Worked on evaluation and analysis of Hadoop cluster and different big data analytic tools including Pig, HBase database and Sqoop.
- Developed PIG Latin scripts to extract the data from the local file system output files to load into HDFS
- Importing and exporting data into HDFS and Hive using Sqoop.
- Collaborated with decision scientist’s team to execute a successful Proof of concept for SOLR search engine to perform indexed fast retrieval of persisted data.
- Responsible for cluster detail layout and performance optimization.
- Created functional design specifications formulating design logic and performance KPIs through active involvement with development team all the way to Production.
- KPI metrics
- Design Logic
- End-to-end platform validation
- Storage and capacity infrastructure needs
- Involved in Hadoop cluster task like Adding and Removing Nodes without any effect to running jobs and data
- Orchestrated strategic processes for setting up data retention and archival policies for compliance and analytical needs.
- Designed a process in Big Data to comply with Compliance and regulatory data integrity needs.
- Installation/Configuration/Maintenance of Hadoop clusters for application development using Hadoop tools like Hive, Pig, Hbase, Sqoop and Flume
- Worked on Migration from Hadoop 2.2 to Hadoop 2.4 via HDP versions.
- Data capacity planning and nodes forecasting.
- Defining the big data platform architecture and Data strategy for ramping up the data ingestion needs without impacting continuous data flow.
- Created SIT test plans and conducted functional/UAT testing in end-to-end lower environments leveraging industry standard process (PDDT) for using PROD data.
- Shared responsibility for administration of Hadoop, Hive and Pig.
- Worked in Data Lake Architecture and converted vast amount of raw data into required data formats and stored into HDFS.
- Performed operations like Delta processing; Validations & Transformations on hive tables and HDFS.
- Usage of Sqoop to import data into HDFS from SQL database
- Load and transform large sets of structured, semi structured using Hive and run analytics on them.
Confidential, NORTH CHICAGO, IL
Analytics Consultant
Responsibilities:
- Involved in analysis, design and development.
- UtilizedAgile Methodologiesto manage full life-cycle development of the project.
- Business requirement analysis by interacting with end-users to understand report requirements.
- Performing detail analysis for the client requirements
- Data gathering, cleansing, processing from sites and aggregation using ESB
- Dashboards of Summary Data on Confidential ts, Tests, Samples, TAT etc.
- Involved in creating Hive tables, loading data, and writing Hive queries.
- Installed and configure Zookeeper service for coordinating configuration-related information of all the nodes in the cluster to manage it efficiently.
- Developed PIG and HIVE scripting for data processing on HDFS.
- Configuring, installing, managing and administrating HBase clusters.
- Create, view and publish standard and custom reports.
- View reports according to data access permissions.
- Maintain and see historical trends for defined periods.
- Supporting Multi-tenancy.
- Addressed integration issues with other components in analytics engine.
- Acceptance testing of all the different applications.
- Account for effectiveness, quality and time lines of project analysis and programming decisions.
- Responsible for conceptual design proof.
- Provide solutions to escalated issues with respect to data integration and BI environment.
Confidential, ST PAUL, MN
Business Systems Analyst
Responsibilities:
- Construct Design specifications for Confidential t Care Device (PCD) data exchange b/w Medical Devices and Hospital/Clinical information systems using proprietary PharmGuard Server Medication Software.
- Requirements management and traceability for end-to-end integrated software including Medication Software, Reporting Module and Interoperability Interface using IBM Rational DOORS and Configuration Management Software.
- Analyze technical components of projects to make time and cost reports to manager.
- Participate in meetings with clients. Research and set up good practices and quality guidelines.
- Analyze and recommend optimization paths for performance of high-end database infrastructure involving thousands of concurrent users/devices.
- Performed Gap Analysis for customization.
- Dump the data from SQL Server to HDFS using Sqoop.
- Experienced in defining job flows with Oozie
- Configured various property files like core-site.xml, hdfs-site.xml, mapred-site.xml based upon the job requirement.
- Helped in the HIVE queries for the analysts.
- Implemented best practices for change control process validating all software change requests.
- Facilitated Software Review Board meetings to escalate potential roadblocks issues in software Critical path.
- Perform migration, customization, upgrading and maintenance (post-production support) on a daily basis.
- Generate customized reports using SQL Server Reporting Services.
- Performed Functional, Integration, System, Regression, Performance and User
- Provide solutions to escalated issues with respect to data integration and BI environment.
Confidential, INDIANAPOLIS, IN
Lead Business Analyst
Responsibilities:
- Standardized the healthcare trading partner’s connectivity mechanism providing web-based real time seamless system interaction as client/server architecture.
- Performed Gap analysis for the modules in production, conducted feasibility study and performed impact analysis for proposed enhancements and also worked on reporting skill set.
- Produced complete data mappings and data conversion documents needed for the Claims application.
- Compiled the Vision Document and composed detailed Use Case Specification Documents in Rational Requisite Pro.
- Used VBA and macros to automate large Excel spreadsheets of 1M + rows of data for easier navigation, data scrubbing, conversion and manipulation.
- Created UML class diagrams, use case diagrams and sequence diagrams to view the system from different perspectives.
- Performed Functional and GUI Testing to ensure that the user acceptance criteria are met.
- Co-coordinated the UAT with the SME’s to make sure that all the Business Requirements are addressed in the application.
- Helped the team to increase Cluster from 25 Nodes to 40 Nodes.
- Maintain System integrity of all sub-components across the multiple nodes in the cluster.
- Monitor Cluster health and clean up logs when required.
- Perform upgrades and configuration changes.
- Created test cases and testing strategies for System Testing (Development Environment), Integration Testing (UAT) and Production in Agile/Scrum environment.
- Implemented the concepts of HTTPS, SSL, and SOAP + MIME functionality to address the security concerns for real time system in Xengine environment (EDIFECS).
- Worked extensively with the users and with different levels of management to identify requirements, use cases and to develop functional specifications.
- Documented Requirement Traceability Matrix (RTM) for requirement elicitation and linkup to deliverables.
Confidential, LOUISIVILLE, KY
Business Analyst
Responsibilities:
- Extracted the business requirements from the stakeholders keeping in mind their need for the application and documented them using Rational Requisite Pro
- Analyzed HIPAA 5010 related to 837,835, 270, and 271. Transactions and performed gap analysis between the 4010 and 5010 focusing on how current transactions and system was going to be effected by the new5010compliance.
- Implemented an integrated RUP solution with complete line of traceability for all the artifacts of web development projects
- Designed and developed Quality Assurance standard and processes to all levels of project team
- Critically evaluated the information gathered from multiple sources during requirement gathering and analysis and responsible for tracking, tracing and managing requirements using Rational Requisite
- Conducted requirement gathering sessions with the purpose of creating and defining theBusiness Requirement Document(BRD) and theFunctional Requirement Document(FRD) using RationalRequisite Pro.
- Documented Requirement Traceability Matrix(RTM) for requirement elicitation and linkup to deliverables
- Created high-levelUse Casesfrom Business Requirements and createdUML diagramslikeUse CaseandActivitydiagrams usingMS-Visio.
- ConductedJAD sessionsto allow different stakeholders to communicate their perspectives with each other,resolveanyissues and come to an agreement quickly.
- ExecutedSQL queriesto test the database for records that detect and submit functional acknowledgement and remittance advice in the claims application.
