SUMMARY

• Database Architecture/Design - Data Analysis
• Database Administration- Requirements Gathering
• Performance Tuning and Engineering- Non-functional design and analysis
• Teradata and Oracle PL/SQL Development- Data migration roadmap design
• Oracle 9i,10g,11g,12c- HP-UX
• Oracle RAC and ASM- Linux (OEL)
• RMAN/Dataguard - AIX
• Teradata- Microsoft Visio 2003,2007
• Hadoop HDFS and Hive- Informatica
• Exadata- IBM Data Stage 11.5
• Presently associated wif Cognizant Technology Solutions - Enterprise Information Management( EIM)- Data on Demand Consulting Practice (DoD) as Lead Data Analyst
• Experienced in defining, designing, integrating and re-engineering the Enterprise Data warehouse and Data Marts in different environments like Teradata and Oracle wif multiple Terabytes of size and various levels of complexity.
• Experience working wif and wrangling very large, disparate and/or unstructured data sets
• Possesses a good understanding of project management methodologies and different phases of the software development life cycle.
• Proficient in data warehouse development practices and processes. She has vivid experience in data migration between file system and databases, strategizing the data migration framework.
• Expertise in database performance engineering - from both application and database perspective, especially for VLDB.
• Has been involved in design, enhancement, and development of applications for OLTP, OLAP, and DSS using dimension modelling wif Teradata and Oracle.
• Has engaged extensively in business analysis through activity and process modeling, data flow diagrams, requirements solicitation, requirements documentation, requirements analysis and validation.
• Oracle Certified Professional - Oracle 11g
• A strategic thinker, implementing solutions for long-term cost benefits of the platform while meeting current requirements
• Excellent analytical, troubleshooting, lateral thinking ability

PROFESSIONAL EXPERIENCE

Confidential

Lead Data Analyst-Developer/ App DBA

Key Responsibilities

• Coordinate wif key stakeholders, subject matter experts, application owners, IT and other analysts for business requirements gathering and analysis.
• Work closely wif project business analysts to understand and assess process requirements to see how they impact data flowing to/from the ODS
• Solicit, ratify, and document stakeholder requirements specific to data source identification, data quality measurements, data duplication, master record creation and data changes for data domains
• Profile and analyze customer data against information quality expectations or specifications, looking for patterns of conformance or deviation. Quantify and quality gaps and potential impact
• Identify ways of building new rules, insights, metrics, and data improvement approaches
• Own the authoring and coordination to deliver key data specific documentation including the ODS data dictionary, source-to-target mappings, HP Quality Center data test cases and plans
• Perform detailed data analysis on large data sets via Oracle SQL Developer to: profile data, perform root cause analysis, verify business data transformation rules in ETL, vet data query performance optimization and verify data model designs
• Review and support data model changes for adherence to their documented source to target specifications (in some instances apply changes to ODS Erwin data models)
• Define, develop and executes source to target mapping test cases to verify data is being extracted, transformed and loaded accurately to-and-from the ODS
• Be on point to triage and identify root cause data defects detected during component integration, system integration and user acceptance testing
• Excelled in defining and managing requirements; nos how to anticipate, extract, translate, constrain, organize, safeguard, simplify, verify and document requirements
• Evaluated existing data models and physical databases for variances and discrepancies. dis halped reduce redundancy of data, improving the way in which it moves from one system to another
• Skilled in data as it is persisted and as it moves, particularly as it relates to integration. dis makes her experts at both defining data structures and at data integration practices—be they for business intelligence or for operational uses
• Built database requirements for Model and Prod environments including server and instance level configuration, storage, instance and network configuration, security, back and recovery as well as logical requirements like accounts, tablespaces and roles
• Analyzed queries used by downstream interfaces for performance, making suggestions for improvement and rewriting queries for better performance
• Established reconciliation approach in Operational Data Store by analyzing the disparate source systems to identify the relationships and build count and key-value based reconciliation queries. Automated execution of these queries on development, SIT and Capacity databases and publish mismatches.
• Used a variety of data sources to identify and analyze trends, variances, and anomalies in data sets in order to develop recommendations for business leaders
• Conducted various analysis both on own initiative and on request from the project
• Highlighted performance issues and gaps, conducts root cause analysis and facilitated performance optimization to reach or exceed these targets
• Served as a data expert for the integrated operational data store (iODS) and has become a data subject matter expert for Retail and Commercial Auto Finance data residing in the iODS
• Created logical and physical data models using best practices to ensure high data quality and reduced redundancy
• Led data quality management effort dat entails the establishment and deployment of roles, responsibilities, policies, and procedures concerning the acquisition, maintenance, dissemination, and disposition of data
• Authored project artefacts including As-Is/To-Be process flows, business requirement specifications, system design documents, business rules, functional requirements and use cases
• Passionate about asking and answering questions in datasets, and able to communicate dat passion to project managers and developers alike

Lead Data Analyst

Confidential

Key Responsibilities

• Discovering the underlying business need to be addressed and information related to the project requirements, often through joint application development session.
• Analyzes requirements by organizing, specifying and modeling the requirements to ensure they are complete and unambiguous.
• Profiling and analyzing customer data against information quality expectations or specifications, looking for patterns of conformance or deviations
• Heading the Teradata development effort and resolving any implementation/design issues during dis phase.
• Preparing base queries and transformation logic for the target integration/semantic tables and presentation views
• Help specify acceptance criteria for test data.
• Change Requirement study and Impact Analysis.
• Development, documentation and maintenance of data quality goals and standards.
• Reporting to management on the progress of data quality improvement and halping resolve data quality problems through appropriate process design strategies, as well as error detection and correction tests and procedures.
• Support the business users in performing timely analysis to identify data quality issues.
• Led and successfully completed the EDW decommissioning project; the top priority for the client in the past year handling stringent deadlines wif a positive outlook
• Coordinated wif key stakeholders, subject matter experts, application owners, IT and other analysts for business requirements gathering and analysis
• Solicited, ratified and documented stakeholder requirements specific to data source identification, data quality measurements, data duplication and data changes for the domains
• Helped build strategies for data acquisitions, archive recovery and database implementation
• Engaged in importing, cleansing, transforming, validating and modeling data wif the purpose of understanding or making conclusions
• Unwounded the existing logic in SQL Server/ Oracle to fit in to new ICDW model and create source to target mappings for critical originations and servicing attributes
• Worked as part of the Agile requirements team, participating in data compares, working wif the data stewards to understand why the numbers are the way they are
• Part of the team charged wif advising project managers and leaders about how the data points can be changed or improved over time
• Providing consultancy for database migration roadmap/consolidation methodology
• Providing consulting services to the project in data architecture definition
• Engaging wif verticals for project delivery via one of several mechanisms
• Providing expertise to project teams for DB/HA specific technical work like data architecture, modelling, design and review
• Providing tools and methodologies
• Growing technical competency in all areas of Data Architecture and designing High Availability systems
• Provide data architecture and database design expertise
• Provide consultation in Mission-critical problems in the area of Data architecture
• Prepare Data Architecture standards and Best Practices
• As the team lead, being responsible for coordinating wif main stake holders to comprehend project requirements and preparing their detailed definition for implementation
• Build expertise on existing business and prepares low level component design for the same
• Provide proof of concept and competitive analysis and handle prototyping project requisites
• Troubleshooting and managing production database problems which are beyond the scope of Application Support teams including tuning/optimizing non-performing codes
• Head the development effort and resolve any implementation/design issues during dis phase
• Responsible for Change Requirement study and Impact Analysis

Confidential

TA and DBA

Key Responsibilities

• Doing performance review of the application codes, tuning non-per formant codes, providing non-functional sign-off
• Reviewing Design from performance perspective and providing non-functional sign-off
• Resolving performance issues in Live application and database
• Guiding application DBA/support team for better management of the LIVE environment
• Planning/driving Backup & Recovery strategy for the platform
• Non-functional improvement planning and implementation
• Planned several Database upgrades for the platform and successfully coordinated the implementation
• Designed and Developed completely reusable database backup framework for one of the high priority data retention project
• Implemented new methodology (like table casting) for supporting very strict SLA requirements(less TEMPthan a second) for online API queries for database
• Performed non-functional tuning for several live/pre-live applications to improve performance.
• Co-planned re-designing of the backup Infrastructure for the platform and co-ordinated the implementation amongst various operation teams. dis made the entire backup system more robust, scalable and reliable