SUMMARY

• Senor Solutions Architect with experience in Enterprise Data Warehousing, project management and software development. Background includes Enterprise Data Warehouse Architecture, Design and Application Development in Manufacturing, Telecommunications, Hospitality Travel & Transportation, Banking & Finance, Healthcare, and Retail and Airline industry sectors.
• Excellent team player and mentor with positive attitude and a proven track record of meeting critical deadlines.
• Experience includes evaluation of Hadoop clusters for Big Data initiatives, including feasibility study, capacity planning and ROI analysis. Evaluate the new open source technologies utilizing NoSQL databases like MongoDB, Cassandra etc., for Big Data analytics

PROFESSIONAL EXPERIENCE

Confidential, Dallas, TX

EDW Architect/DBA (Consultant)

Responsibilities:

• Migration Strategy and architecture around deployment of MS SQL server 2014 EDW for migrating from Teradata
• Administration of the SQL server and Teradata databases for both EDW and Master data management.
• Architect solutions around Apache Kafka, Hadoop, Spark for the Logistic related analytics and IoT strategies

Confidential, Dallas, TX

Senior Teradata/Big Data Architect/DBA (Consultant)

Responsibilities:

• Provide the architectural guidance on the Teradata and its components for optimal performance on BI analytics around Teradata and Big Data components
• Work with the development teams and provide architectural solutions on the self service model utilizing the Teradata Unity eco system along with the NoSQL databases.
• Teradata performance tuning and related support.
• Manage and co - ordinate the development teams and production support teams on the analytics and self service teams
• Mentoring and guiding the Teradata DBA teams for the system management and administration.

Confidential, Dayton, Ohio

Senior Solution Architect

Responsibilities:

• Support the Sales Team to meet and achieve the sales targets.
• Architect and lead the POC efforts by providing the required configurations and roadmap for the analytics.
• Discuss and mentor the customer teams for the Big Data Initiatives on how to bring together the structured and unstructured data using Hadoop
• Provided guidance on Data lake efforts involving Hadoop, Teradata.
• Assisted in the upgrade of the Hadoop platforms (from 1.3 to 2.2) and in the installation/configuring the Hadoop, Map Reduce, Spark for data access across multiple platforms in eco system with other databases
• Architected the enterprise wide solutions for Big data/Hadoop architecture involving various platforms like Discovery/ Big Data (Hadoop, Aster), Integrated DW (Teradata), NoSQL databases like MongoDB, Cassandra (Datastax) and SAP.
• Performed capacity analysis based on performance, CPU, IO utilizations, space needs in conjunction with future roadmap and provided the appropriate configurations to customer.
• Provided guidance on the workload management settings and architected the solutions around Advanced analytics utilizing the eco systems
• Provided capacity planning and configuration of the Teradata systems for optimal performance and storage needs in conjunction with other systems like Hadoop/Aster and SAP BW/ECC.
• Addressed the required upgrade plans for various tools including ETL tools (Informatica, Data Stage, Ab- Initio, BODS etc.), BI and Visualization tools (Cognos, BO, Micro strategy, Tableau etc.), and analytic tools like SAS at customer sites.
• Managed the onsite-offshore development, managed services ETL, and Database teams for the deployment of DW solution for the clients and assist on Day to day production support

Lead Senior Consultant

Responsibilities:

• Managed the onsite-offshore development ETL teams and Database teams for the deployment of DW solution for the clients.
• Defined Workload management strategies for the Enterprise Data Warehouse based on the Service Level Goals of the client needs
• Architected the performance tuning strategies for troubled applications and tactical query response times.
• Helped clients generate revenue off of the data warehouse by making use of available data.
• Recommended the BAR strategies per the client needs.
• Provided technical guidance and recommendations in setting up the database, TASM settings, Account strings, Roles, Profiles as per the security needs.
• Provided Architectural recommendations in ETL strategies using various tools like AbInitio, Informatica and Data Stage.
• Delivered recommendations, best practices and architected the Data Warehouse implementation process, strategies in regards to the setting up of the Database hierarchy, ETL process, tools, data quality, Master data management, Data Governance and data migration strategies.
• Managed the offshore ETL team for delivering the architected solution in a timely manner.

Confidential, Dallas, Texas

Lead Database Administrator

Responsibilities:

• Provided the Architectural solutions for the Active data warehouse and Disaster Recovery needs.
• Worked on data security by data encryption and various access mechanisms.
• Mentored the Data Warehouse development team on use of the appropriate tools and migration processes using version control tools and other utilities.
• Developed Capacity Planning strategies by collecting and Analyzing usage trends to make sure that hardware met current and future DASD & desired response times.
• Fine tuned the Tactical Query application (web based / java) used by the Customer service representatives for the optimal and consistent query response times.
• Architected the Data Privacy / Data security for Flight in Trouble situations to meet federal regulations.

Confidential, Fort Worth, Texas

DW ETL Team Manager / Database Administrator, Data Warehouse

Responsibilities:

• Managed and directed team of Data warehouse developers on ETL strategies and design.
• Designed the process for operational data capture as a step towards the integration of Warehouse with Meta Data services.
• Database administration and related performance tuning