Business Intelligence Consultant Resume Irving, TX - Hire IT People (2024)

SUMMARY

• Software Professional with around 10 years of expertise in software engineering, which encompasses complete SDLC, design, development, maintenance and post - implementation support of web-based enterprise solutions.
• 10 years of experience in professional application and database development in multi-tier and web based solutions.
• Extensive experience in Data Modelling, Database design and performance monitoring.
• Hands on experience in writing Stored Procedures, User Defined Functions (UDF), Cursors, Views and Triggers.
• Experienced in client requirement Analysis, Physical, Logical design, development Coding, Debugging, Testing, Deployment, Support and Maintenance of business applications.
• Hands on experience on Hive, Impala for data retrieval from Hadoop big data environment.
• Hands on experience on Sqoop for ETL from MySQL RDBMS database environment to Hadoop Distributed File System.
• Experience in Replication as Disaster Recovery Solution and strong knowledge on MM-ring architecture.
• Very good knowledge on Clustering, Replication, Backup/Recovery, Troubleshooting and Problem Solving, Capacity Management, Disaster Recovery Planning.
• Proficient in writing complex SQL queries and performance tuning.
• Hands-on experience on developing ETL jobs using IBM’s Ascential Datastage and SQL Server Integration Services (SSIS) tool.
• Solid hands on skill on data migration from DB2 to MYSQL and data warehousing.
• Hands-on experience on UNIX shell scripts to generate reports and to create batch jobs to cater to various business needs.
• Strong knowledge on Unix Shell scripting and excellent knowledge on Unix advanced commands like awk, sed and xargs
• Hands-on experience on Jenkins to create scheduled batch jobs.
• Conceptual knowledge on Hadoop Big data framework.
• Experience in enhancing an enterprise application using Core Java.
• Good knowledge and experience in object oriented concepts.
• Experience in working with production on 24X7 call environments.
• Proficient in translating business requirements into technical requirements, preparing impact analysis, design documents, project plans, HLDs and LLDs.
• Very good knowledge on core retailing concepts
• Ability to work with business functions to understand business requirements and develop technical specifications.
• Excellent communication, Team work, inter-personnel and presentation skills, fast learner and organized self-starter.
• Experience in interacting with Clients, Collection of Requirement Specifications from the client site, performing Requirement Analysis and Designing and maintain productive working relationship with management, Clients and team members.
• Exposure to all phases of software development life cycle (SDLC) with in-depth knowledge of agile methodology, enterprise reporting life cycle, MySQL migrations, change control rules, source controls, problem solving skills and escalation procedures.
• Capable to learn new technology and adapt to a new environment quickly.

TECHNICAL SKILLS

Database: MySQL, Db2,SQL Server

Big Data: Hadoop Distributed File System

Database Tools: Toad, SQL Yog, MySQL Workbench, IBM Control Center, DB Visualizer, Hive, Sqoop, Impala, SQL Server Management Studio

Programming Languages: UNIX,SQL, Java

Case Tools: MS Office 2010/2003, MS Excel 2010/2003, MS Outlook 2010/2003, MS Visio, SharePoint Server 2007

Other tools: Graphite, Jenkins, Dynatrace

Operating Systems: Windows Based PCs, UNIX

IDE: Eclipse

Version Control: SVN

ETL Tools: Ascential Datastage Enterprise Edition 7.5.2, SSIS

Issue Tracking: JIRA

PROFESSIONAL EXPERIENCE

Confidential, Irving, TX

Business Intelligence Consultant

Responsibilities:

• Interact with client to gather reporting requirements that caters to the product needs and for continuous production support.
• Work with architecture and UI teams to develop reports and ETL jobs that would meet both short term & long term reporting needs of the customer.
• Design and develop ETL jobs on SSIS to migrate data from source files and databases to target databases.
• Design and develop stored procedures which would return data to the Rapid Results application which uses the data to create charts for data visualization.
• Creating re-usable queries for data analytics.
• Coordinating and prioritizing tasks that to be done from offshore on a daily basis and ensuring that the tasks are completed in a timely manner.

Environment: SQL Server Management Studio 2008/2012, SSIS, T-SQL

Confidential, Redwood City, CA

Database Engineer

Responsibilities:

• Monitoring DB which includes identifying DB locks, analyzing slow queries (identified through Dynatrace) and optimization for improving performance.
• Worked as a single point of contact for any DB related issues which need to be actionized on priority.
• Responsible for requirement collection, analysis, design, development and maintenance of SQLs and Scripts
• Involved in migration of data from DB2 to MySQL environment.
• Worked on Data Modelling of TRMS (transaction risk management system).
• Wrote stored procedures to archive tables which are huge in terms of number of rows, data and index size.
• Used Hive, Impala for data retrieval from Hadoop big data environment.
• Used Sqoop for ETL from MySQL RDBMS to Hadoop Distributed File System.
• Debugging, fixing errors, removing redundant code, improving query performance of existing queries.
• Wrote triggers to capture updates on field values. The delta was used for incremental SOLR indexing
• Wrote stored procedures for ID generation which is the one of the most critical components in the used by OMS ID generation service.
• Created DB designs and implemented them to support new features.
• Coordinated with DBA on reviewing self-proposed database changes and obtaining approval.
• Coordinated with DBA for DB deployment on pre-production and production environments.
• Coordinated development of scheduled jobs for data migration from live to data warehouse schema.
• DB level tuning by estimating the cost of the query using explain plan and creating indices on fields. wherever appropriate
• Created adhoc reports as per business needs from MySQL/DB2 queries being invoked through Unix and java (using Apache POI API). The jobs would be scheduled on Control M.
• Used Tools like graphite to monitor CPU usage and other statistics.
• Worked on Analysis, Data mapping, implementing the business rules and logic as per the BRD requirements and Data Dictionary.
• Created automated jobs to keep the data up to date in the preproduction environments.
• Created automated jobs to purge stale records across schema in the PROD environment.
• Experience with MySQL Workbench tool to create ER diagram.
• Reviewed and tuned a lot many number of queries as a part of Holiday readiness activities.
• Created Unix based scripts to migrate Data from DB2 to MySQL environment.
• Created SQL scripts for bulk data correction.

Environment: MYSQL, SVN, UNIX, DB2, JAVA

Client: Confidential Holdings Management Corporation

Location: Redwood City, CA

Duration:

Role: Technology Lead

Project Summary: SPIN stands for Confidential Product Information Network. SPIN is a PIM (Product Information Manager) system consisting of a new data model, database, and GUI tool interface. SPIN is replacing a number of tools, systems, processes, interfaces, and databases in the Confidential network of systems. SPIN will be the catalog database for all Confidential ’s online assets. Functionalities like inventory, order management, item creation, deals and promotions is achievable through SPIN. Vendors and merchants will create and manage their assortment (products for sale). Website taxonomies can be created and managed using SPIN Application. Creation of marketing relationships between items is also possible through SPIN.

Responsibilities:

• As part of supporting the application, addressed issues/tickets raised in the form of JIRAs by re-producing the issue, data analysis and routing to the appropriate development counterpart if required, and communicating updates to the business in a timely manner.
• Leaded an offshore team, prioritized the tasks for them and ensured that the tasks are completed within the expected timeline.
• Worked on creating adhoc reports as per the requirements from business.
• Coordinated development of scheduled jobs Jenkins for data migration from live to data warehouse schema.
• Developed file processing tools based on UNIX, error reports etc. to cater to the daily support activities.
• Used Tools like graphite to monitor CPU usage and other statistics.
• Created SQL scripts for bulk data correction.

Environment: MYSQL, SVN, UNIX

Confidential

Technology Analyst

Responsibilities:

• Co-ordinate with onsite team to gather requirements and understand the processes.
• Leaded a team and acted a single point of contact to the onsite team in delivering the task assigned
• Good experience with onsite and client when working on a project
• Responsible for requirement collection, analysis, design, development and maintenance of DataStage jobs/ SQLs and Scripts
• Involved in designing data model of TCN.
• Created jobs in DataStage to process data from heterogeneous sources like MySQL, DB2 andFlat files.
• Created datastage jobs to Migrate data from TCN which is a MySQL environment to WCS DB2 environment.
• Good Knowledge on IBM WCS tables and Java utility BODL(business object data load) for the data load of each table.
• Enhanced IBMs BODL to support bulk insert of data.
• Experience in using Datastage director to validate, run, and schedule/monitor datastage jobs
• Data loading for WCS (WebSphere Commerce Server) tables using DataStage as the ETL tool.
• Fine-tune DataStage jobs for optimal performance.
• Performance tuning of existing SQL queries.
• Worked on creating adhoc reports as per the requirements from business.
• Developed file processing tools based on Unix, error reports etc. to cater to the daily support activities.
• Coordinated with Operations team to schedule the Jobs on Control M
• Prepared scripts for Database operations.
• Used UNIX shell scripts to support ETL process.

Environment: MYSQL, UNIX, DB2, Java, ASCENTIAL DATASTAGE 7.5.2

Confidential

Software Engineer

Responsibilities:

• Co-ordinate with onsite team to gather requirements and understand the processes
• Responsible for requirement collection, analysis, design, development and maintenance of DataStage jobs/ SQLs and Scripts
• Wrote ETL jobs in Datastage to support full and incremental data load from source to target environments.
• Involved in designing data model for new systems.
• Created ETL jobs in DataStage to process data from heterogeneous sources like DB2 and Flat files.
• Experience in using Datastage director to validate, run, and schedule/monitor datastage jobs
• Fine-tuned DataStage jobs for optimal performance.
• Performance tuning of SQLs used for data extraction in the ETL jobs.
• Prepared scripts for Data manipulation operations.
• Used UNIX shell scripts to support ETL process.

Environment: UNIX, DB2, ASCENTIAL DATASTAGE 7.5.2