TECHNICAL SKILLS

• DSA, Querygrid
• SQL
• UNIX Shell Scripting
• Erwin
• Net Backup - Tivoli, Taragui
• TASM, Datamover
• Tableau and BI
• ETL, TPT
• Oracle
• Spark, Hive, hadoop
• Pyton, Perl, C, C++
• Oral Communication
• Written Communication
• Time Management
• Questioning
• Availability
• Customer support
• Deliveries/Commitments
• Team Building /Leadership

PROFESSIONAL EXPERIENCE

Senior Technical Architect

Confidential

Responsibilities:

• Track implementation milestone, scope, objectives and deliverables in collaboration with management, client, technical architect and other stake holders for Confidential DBA team.
• 15 years of experience as a Data Architect, Senior Confidential -DBA, Performance - DBA, Technical Lead and Developer.
• Extensive Experience on Tableau reporting, Automation, code review and optimizing the queries.
• Automated the activities through shell scripting like Capacity expansion, parameterized queries, access right and stats cleanup etc.
• Experienced in Confidential utilities such as BTEQ, MultiLoad, Fast Load, TPT, Tpump and Data Mover.
• Experienced in query/scripting languages such as SQL, PL/SQL and UNIX Shell scripting.
• Strong skills in coding and debugging Confidential utilities.
• Experience in all phases of data warehouse development. Requirement analysis, design, development, migration and implementation on Production environment.
• Good experience on backup, data mover, TASM and query grid.
• Good Knowledge on Spark, Hive, Hadoop and Python.
• Established and wrote the company’s standards and best practices document for all Confidential database environments.
• Good experience establishing corporate data architectures; and building enterprise, subject area and application data models for clients. Strong design skills in Logical Data modeling, Physical Data modeling and Metadata Management.
• Well versed in forward engineering Data models and creating Physical Database schema and objects using Data modeling tools. Experienced in production support, fixing bugs and coordinating releases.
• Knowledge on the reporting tools like Microsoft Business Intelligence, CTRL-M and Tivoli Workload Scheduler (TWS).
• Experience on version control tool SVN and good Exposure on the ETL tools like BODS, DataStage, etc.
• Experience in Handling Confidential upgrade projects (14.10, 14.10 to 15.10, 15.10 to 16.10).

Confidential

Senior Technical Architect

Responsibilities:

• Worked extensively on optimizing the queries using Query re-write, PPI, join index and SI.
• Handling the data movement and backup through datamover.
• Automated Ad-hoc STATS process which has improved the query response to greater extent.
• Optimized the Adhoc user queries and addressed millions of CPU burden Confidential server level.
• Extensively worked on procedure and macros. Conducted Performance and Code review through incidents and CR review developed by Dev team.
• Extensive experience on upgrade projects ( Confidential 14 to 14.10 and 14.10 to 15.10, 16.20, Intelliflex)
• Effectively communicate with client and project management, delivery manager and stakeholders in a timely and clear fashion and hold team members accountable for delivery.
• Identify and resolve implementation risks, issues and conflicts within the appropriate team.
• Exposure to SPARK (Python) and Hive building data pipelines and transformation
• Analyze and review the code linked to Kafka, GDPR, SAP and Athena.
• Worked on the Jupyter lab to conduct POC on teradatasql.
• Review the jobs related to Confidential which is linked to Cassandra DB to optimize the jobs related to spark and Hive.
• Analyzed the database and objects and find out the issues related to modelling.
• Automated the activities through shell script like address Key-values which are using nvp and various functions, parameterized queries, Access right and stats cleanup, Aggregate enhancement, Stats collection, clean-up activity, and user creation process to reduce the manual effort.
• Proactively manage changes in project scope, identify potential roadblocks, and devise contingency plans.
• Develop and deliver status reports to management and other stakeholders including issue/action item logs, implementation status, monthly/weekly reports and risks.
• Develop data warehouse architecture and physical implementation standards.
• Develop Functional Design document by understanding the Business Requirement Document.
• Conduct the review meeting to answer the questions from the technical team and the business analyst for the functional requirement. Do technical feasibility analysis in the planning and design phase.
• Involved in Data Analysis to meet the Business requirement. Develop Source to Target mapping in the Enterprise Metadata Repository. Explain the ETL developers on the mapping and business rules.
• Develop logical and Physical model in Erwin as a tool. Worked on database analytics, data infrastructure development, and data mining
• Identify the data requirement to the meet the business requirement. Participate in the requirement meeting to understand the business requirement.
• Review the documents to make sure the organizational standards have been followed.
• Created customs views to meet the report requirement.
• Explain to project Analysts, Developers and DBAs on the requirement. Generate DDL scripts from the Erwin tool and customize to the requirement.
• Guided the team and addressed the performance issue by adding SI, JI and PPI on Confidential and SQL database.
• Addressed the performance issue from the ETL tool BODS and reporting tool MSBI.
• Helps lead Business continuity and disaster recovery exercises.
• Analyze, recommend and Implement the TASM rule-set. Handled the compression activities like BLC, ALC and MVC.

Confidential

Senior Technical Architect

Responsibilities:

• Analyzed source data and Interaction with IT team of the client for the purpose of requirement gathering, understanding requirements and Active involvement in project workgroup meetings to resolve any ambiguity, incompleteness or incorrectness of requirement.
• Actively involved in the Design of the project, Collected & Analyzed business requirements and converted them in to a Technical Specification document.
• Responsible for putting together the Detailed Design documents required for the new development effort and will coordinate the Design & Construction checkpoint review processes.
• Involve in all phases of SDLC including Estimation and Project plan.
• Designed and developed an entire Data Mart from scratch.
• Created various UNIX Shell Scripts for scheduling various data cleansing scripts and loading process.
• Identify and resolve technical problems related to performance, functionality and coordinate with end users as necessary.
• Expertise in Data quality, Data organization, Metadata, and Data profiling.
• Responsible for the Change Management process and in coordinating the Systems Integration & Production Implementation of the new sourcing efforts.
• Handling Primary Production support by monitoring jobs, Defect Resolution and Analysis /Clarification and provide prompt response to job failures.
• Production break-fix INC resolution, automated ticketing incidents and user opened incidents also inclusive of coordination for prod deployment
• Fix on errors - Deployment of code and data fixes by performing root cause analysis, and application performance improvements.
• Enhanced existing Scripts to adhere to new IDR Standards provided and followed by Organization.
• Extensively make use of Bteq Scripting, Utilities such as Fast Export, Multi Load, Fast Load and TPT.
• Helps lead Business continuity and disaster recovery exercises as well as DR backup daily execution.
• Involved in writing Test Plans, Test Cases, Test Scripts and Test Queries. Also worked closely with Users and helped in accomplishing the UAT successfully.
• Provided required support in Multiple (SIT, UAT & PROD) stages.
• Acting as a single point of contact for a Project Manager for all Development resources and deliverables (Business Requirement document, Approach Document, Technical Design Document,
• Coding, Test cases, SDLC documents etc.).
• Handling different calls from Management to discuss periodic updates.
• Training sub ordinates on Advanced Confidential concepts and initiated training for new hires.
• Automating the repeated activities through shell scripts like Stats collection, High cpu users, objects cleanup, server object sync-up, SOX, Aborting long response sessions and user creation.
• Designing of reverse engineering sub-models using modelling tool.