Senior Data Analyst/data Architect Resume
3.00/5 (Submit Your Rating)
SUMMARY
- 10+ years of IT experience in Healthcare and Retail domains
- Created data models (Logical, conceptual, Star and Dimensional Data models), solution designs and data architecture documentation for complex information systems.
- Involved in new database designing and Table structure creation.
- Experience in Data Science /Analytical it includes
- Data Profiling, Data Mining, Data Frequency, Mapping, Unique values & Value level mapping.
- As a Data Analysts involved on million of data and provided solution to the business team for decision making.
- Hands - on experience in Excel to produce the reports with different Pivot types.
- Worked on IDQ (Informatica Data Quality) tool for the Analysis and Identified the data pattern, Golden records and validate the data in different scenarios.
- Co-coordinating and worked with Dev, QA, Business and Production Teams.
- Worked on reporting tools like Tableau.
- BI tools used for analytical - Tableau, IDQ and Excel.
- Created different type of mapping (like Doctor Address) to identify and good data
- Created mapping documents for each table and attribute level.
- Good working experience in Data warehousing ETL development, and database migration.
- Good experience in creating High and Low level design on the application
- Consistently delivered quality projects under stringent timelines and high pressure.
- Working on in Teradata database and Good knowledge in Teradata architecture.
- Thorough understanding of Software Development Life Cycle (SDLC), involved in various phases like Requirements, Analysis/Design, Development and Testing.
- Possess extensive experience in writing system specifications, Analysis specification and mapping specification.
- Technical expertise includes primarily Oracle 9i,10g,11 (PL/SQL) & SQL Server
- Writing Package, Procedure, Triggers, Functions, Created database objects like Tables, views, synonyms, Indexes
- External file concepts
- Understanding of Business logic and ability to work well as a part of a team and as an individual.
- Experienced in writing SQL Queries and fine tuning the queries.
- Worked on SOAP webservices,
- Worked on SQL Loader, External Tables,and UTL FILE.
- Loading data from various data sources and legacy systems into Teradata production and development warehouse using BTEQ, FASTEXPORT, MULTI LOAD, FASTLOAD & TPT (Teradata Parallel Transporter).
- Good technical knowledge in UNIX shell scripting (SH, KSH, Cronjob scheduling and monitored as part of support process).
- Writing Shell Script to automate task from UNIX environment.
- Supported Informatica mappings and workflows.
- Involved in Estimation, Analysis, Design, Development, test Cases preparation, UAT Support and Production support.
- Worked in PowerBuilder application, and supported/ migrated multiple projects.
PROFESSIONAL EXPERIENCE
Senior Data Analyst/Data Architect
Confidential
Responsibilities:
- Involved in system requirement and analysis documentation.
- Created data models (Logical, conceptual, Star and Dimensional Data models), solution designs and data architecture documentation for complex information systems.
- Involved in Data Science /Analytical it includes
- Data Profiling, Data Mining, Data Frequency, Mapping, Unique values & Value level mapping.
- As a Data Analysts involved on million of data and provided solution to the business team for decision making.
- Hands-on experience in Excel to produce the reports with different Pivot types.
- Worked on IDQ (Informatica Data Quality) tool for the Analysis and Identified the data pattern, Golden records and validate the data in different scenarios.
- Co-coordinating and worked with Dev, QA, Business and Production Teams.
- Created different type of mapping (like Doctor Address) to identify and good data
- Created mapping documents for each table and attribute level.
- As a Data Analysts involved on million of data and provided solution to the business team for decision making.
- Hands-on experience in Excel to produce the reports with different Pivot types.
- Co-coordinating and worked with Dev, QA, Business and Production Teams.
- Data profiling for demanding requirements. Worked on Doctor Address types for the address validation.
- Involved in identify the data pattern and mapping between the systems.
- Identifying the GAP between two systems and validated good and bad data.
- Involved in data analysis with different systems ( CATS, SPARCS and HBS)
- Development and Application support, Technical trouble shooting, preparing adhoc reports and Unit testing for the enhancement
- Used SOAP webservices
- Creating report and developing PLSQL packages and procedures.
- Further transformed all requirements to generate attribute mapping documents
- Involve developing job in Informatica application( few)
- Reviewing functional specification documents with the development and testing teams
- Supporting testing teams on data validation and reviewing test cases
- Involved in new stored procedures creation, performed SQL Tuning for production database effectively
- Good analytical skills to understand the problems and able to provide quick and reliable solution to the client in several situations, provided client focused issue management and managed all service requests.
Senior Data Analyst
Confidential
Responsibilities:
- Involved in Data Profiling, Data Mining, Data Frequency, Mapping, Unique values & Value level mapping.
- As a Data Analysts involved on million of data and provided solution to the business team for decision making.
- Involved in system requirement and analysis documentation
- Involved in data analysis with different systems ( Facets, Interrogation and Fazal)
- Data Profiling, Data Mining, Data Frequency, Mapping, Unique values & Value level mapping.
- As a Data Analysts involved on million of data and provided solution to the business team for decision making.
- Worked in FACET application in the following modules Membership (enrollment) and Claims.
- Development and Application support, Technical trouble shooting, preparing adhoc reports and Unit testing for the enhancement
- Data Profiling, Data Mining, Data Frequency, Mapping, Unique values & Value level mapping.
- Mentored the team in GAP analysis documentation catering to the vendor's needs
- Involved in data analysis and provided solution to improve the end result.
- Involved in rephrasing and redefining business requirements after gaining a complete understanding of the requirements from the business users.
- Further transformed all requirements to generate attribute mapping documents
- Monitoring the jobs in Production and involved and provide quick solution if any jobs struck / issues.
- Data profiling for demanding requirements
- Reviewing functional specification documents with the development and testing teams
- Supporting testing teams on data validation and reviewing test cases
- Involved in creating PL/SQL stored procedure and functions.
- Good analytical skills to understand the problems and able to provide quick and reliable solution to the client in several situations, provided client focused issue management and managed all service requests.
Senior Data Analyst
Confidential
Responsibilities:
- Understanding and creating system requirement and analysis documentation.
- Data Profiling, Data Mining, Data Frequency, Mapping, Unique values & Value level mapping.
- As a Data Analysts involved on million of data and provided solution to the business team for decision making.
- Involved in the design and architecture of the system
- Conducted reviews with multiple teams including development and testing teams.
- Perform data profiling in order to understand the nature / quality of the data available.
- Good technical knowledge in UNIX shell scripting (KSH, SH scripting)
- Good working experience in data warehousing ETL development, and database migration.
- Worked on Star Schema and involved in lots of Dimension and Fact records.
- Worked on Sqlloader (sqlldr) and control file.
- Teradata ( Multi-Load, Fast-Load & Teradata Parallel Transporter )
- Involved in creating / designing new application design for Teradata tables and provided analysis on the each table.
- Involve with New database structure creation with Data designer and business application team.
- Most of the scripts are used TPT to load the data in parallel and quick.
- Engaged in complete end to end delivery and Production Rollout
- Interacted with multiple teams on the Client end to ensure quality delivery both on the technical and business front.
- Involved in Application development, Technical trouble shooting, project document preparation and Unit testing for the enhancement
- Executed test cases to verify the report and compared that with database.
- Analyzed and computed statistics to improve response time for queries
- Verified the oracle logs and Teradata loads.
- Developed reports using oracle sql plus reports.
- Interacted with client to gather the requirements and implement the same in the project.
- Performed few SQL tuning for database server effectively.
- Extensively worked on Oracle, SQL, oracle utilities and UNIX files.
- In-depth knowledge in UNIX shell script.
- Developed reports to verify the loaded data.
- Verify the all tables and structure against oracle database, once data migrated.
- In-depth knowledge in data warehousing concepts.
Software Developer
Confidential
Responsibilities:
- Coordinate with onshore System Analyst to work with business users to understand business requirements and convert them into functional requirements.
- Involve in data profiling activity as part of analysis phase and create mapping specification.
- Analyzing Source to Target Mappings
- ADM Developer CustomApps
- Writing Unix Shell Scripts
- Building and Unit Testing
- Validate data during development phase to ensure all requirements have been covered.
- Provide support to testers during system testing and UAT phase.