SUMMARY:

• 7.5 Years of experience in Information Technology in Data Warehouse and ETL Technologies.
• Strong Experience in Informatica Power Center 8.1,8.6 and 9.1,9.5.9.6.1, 10.2,10.4, ETL DataStage
• Experience in Teradata 15/13/12/V2R6.2/V2R5, Data Load utilities like BTEQ, TPT, FastLoad, MultiLoad, Tpump, FastExport and Teradata Viewpoint.
• Strong experience in scheduling tools Maestro (IBM Tivoli Workload Scheduler) and ESP.
• Strong UNIX Shell Commands knowledge.
• Experience in Hadoop IBM Big Insights Big Sql and Hive Technologies.
• Experience in CA Harvest Software Change Management tool.
• Extensive experience in analysis, design, development and implementation of Data warehouse applications in Health Care, Auto Insurance, Travel and Transport Industry
• Involved in creating, monitoring, modifying, & communicating the project plan with other team members.
• Designing and configuring landing tables, staging tables, base objects, lookups, custom queries, hierarchies and foreign - key relationships.
• Supported the BI team by extracting operational data from multiple sources, merging and transforming the data to facilitate enterprise-wide reporting and analysis and delivering the transformed data to coordinated data marts.
• Executed software projects for Insurance Industry. SME, providing best technological support to the client, mentoring team members to enhance project team competency and individual capabilities.

TECHNICAL SKILLS:

Databases:: Teradata 14.1, Orace 10g/9i, Netezza,IBM Big Insights Big Sql and Hive, DB2,MS SQL server

Languages:: SQL, and UNIX scripting

ETL and BI Tools:: Informatica 7.1/8.1/8.6/9.1, 9.5,9.6.1, 10.2,10.4 ETL DataStage

Tools: Toad, Teradata SQL Assistant, Squirrel,SQL Server

Schedulers:: Maestro (IBM Tivoli Workload Scheduler), ESP, Tidal

Operating Systems: Windows XP/NT, MS DOS, and UNIX.

Software Change Management: CA Harvest 12.1

PROFESSIONAL EXPERIENCE:

Confidential

Data Specialist/ Onsite Lead

Project Responsibilities

• Create ETL DataStage Design and develop ETL DataStage jobs and execute the ETL DataStage jobs in sequence to perform testing and verify the results. Make sure ETL DataStage jobs executes without error and meets the functional and business results.
• Deploy ETL DataStage code to Production environment, with the help of DataStage administration team, after obtaining sign-off from users during User Acceptance Testing (UAT).
• Pro-actively collect the performance statistics from DataStage server and SQL server to retrieve long running or obsolete processes and fine tune the environment regularly. Create archive procedures within DataStage to compress and archive the files to save disk space.
• Test the DataStage services, UNIX services and SQL server services after the UNIX patches are applied on the server. Compare the before and after execution times to confirm no major performance issues reported.
• Support ETL DataStage jobs in production environment. In case of ETL DataStage job failures, check the DataStage logs to find out the root cause of the failure. Fix the failure within the SLA (Service Level Agreement) timelines. Provide the steps taken to fix the job failure in the support management center (SMC) incident.
• Perform impact analysis on existing SQL Server repository for each deployment and create list of tables or columns need to be added or modified. Share the list with Database Administration (DBA) team to make SQL Server changes ahead of each release.
• Review ETL DataStage code developed by the team to ensure they meet functional and business requirements before deploying them into production environment. Provide ETL code review comments to developer based on deviation from requirements and ETL best practices and follow up to closure of review comments before the code is moved to production environment.
• Work on the ETL defects raised by users on Team Foundation Server (TFS). Perform analysis and get the list of ETL DataStage jobs need to be changed and come up with story points or estimation and update it on TFS. Upon completing all the changes related to the defect, execute the modified code in test environment to obtain sign-off from the user and close the defect in TFS.
• Update Application Information Document (AID) after every product release to add the list of ETL DataStage jobs added to ETL DataStage repository along with the change to architecture of existing system and maintain them in the SharePoint tool.

Confidential

Data Specialist

Project Responsibilities

• Work on ongoing enhancement requests - follow all Software development life cycle activities for enhancement and new functionality work requests.
• Track progress of requests assigned. - Using rational clear quest tool, make sure status of requests is up to date. Ensure all artifacts are tracked in rational Portfolio manager and are available within timelines given for each phase.
• Responsible for leading a project team in delivering solution to our customer in the healthcare sector.
• Deliver new and complex high-quality solutions to clients in response to varying business requirements
• Establish Quality Procedure for the team and continuously monitor and audit to ensure team meets quality goals.
• Generating new reports as per business requirement and documenting & tracking logs in defect prevention sheet to establish better standards of code quality enhancement.
• Application support for BCBS-MA - Monitoring jobs, resolve issues and ensure normal job flow.
• Ensure Availability of different jobs. Resolve data issues, technical failures.
• Work on ongoing enhancement requests - follow all Software development life cycle activities for enhancement and new functionality work requests.
• Track progress of requests assigned. - Using rational clear quest tool, make sure status of requests is up to date. Ensure all artifacts are tracked in rational Portfolio manager and are available within timelines given for each phase.
• Analyze BRS (Business Requirement Specifications) and prepare ROM (Rough order of Magnitude), SRS (System Requirement Specification), and CRS (Component Requirement Specification).
• Structuring and prioritizing Business requirements and communicating plans with stakeholders for review and approvals.
• Open tickets when new defects found and Conduct reviews of each project phase artifacts such as designs and test scripts to ensure artifacts meet the baseline requirements before release.
• Provide technical solutions for transforming the Client’s Legacy Mainframe Systems to newly proposed DLAP systems.
• Develop mappings with Source qualifier, Union, Aggregator, Connected & unconnected lookups, Filter, Router, Expression transformations to transform data using Informatica Power Center.
• Creating necessary stage tables in oracle and develops shell scripts to verify source files and to SFTP files to target location.
• Perform Unit testing and integration testing. Extensively used SQL queries for data validation and backend testing.
• Building, publishing customized interactive reports and dashboards, report scheduling using Tableau server.
• Created action filters, parameters and calculated sets for preparing dashboards and worksheets in Tableau.
• Restricted data for particular users using Row level security and User filters.
• Developed Tableau visualizations and dashboards using Tableau Desktop.
• Developed Tableau workbooks from multiple data sources using Data Blending.
• Requirement gathering, Requirement analysis, documentation, consolidation of documents on SharePoint, creating system guidelines and manuals for the organization.
• Deployment of completed work requests. Write SQL queries with the help of Data Mapping Sheet and BR/Technical Design Documents and execute them on SQL Server database for data validation.
• Provide status to client and present solutions. Answer the questions raised and resolve issues if any.
• Coordinate/execute promotion from development to quality assurance environment and implementation of break/fix code into the production environment. Provide solutions to issues raised during testing/production.
• Communicate Service Incident resolutions through customer defined processes and perform and document root-cause analysis and, if warranted, present options to customer for the elimination of repeated issues through an enhancement or project.
• Co-ordination of work requests. - Co-ordinate work requests assigned to multiple resources.
• Knowledge management activities - Ensure Application Information Documents are up to date by timely updating for any new knowledge gained on application.

Environment : Informatica 9.1, DB2, Hadoop, Unix, HBase, Python, Apache Spark,Tableau

Confidential

Data Specialist

Project Responsibilities

• Gathering requirements & analyzing stored procedures of the source data in earlier process. gathering customer requirements and involve in various business discussions with the end users of the application.
• Analyzed data and created Data Flow Diagrams from source to target.
• Created ETL Technical Design documents.
• Creating Mappings with Source qualifier, Aggregator, Connected & unconnected lookups, Filter, Update Strategy, Expression and Sequence Generator transformations while transforming the data.
• Created Mappings with XML source qualifier transformation.
• Created Mappings with stored procedure transformation to consume data from different database.
• Created Mappings with Transaction Control Transformation to generate different output files.
• Translate customer requirements into formal requirements and design documents, establish specific solutions, and leading the efforts including programming and testing that culminate in client acceptance of the results
• Created new Informatica Mappings with Source qualifier, Union, Aggregator, Connected & unconnected lookups, Filter, Update Strategy, Rank, Stored Procedure, Expression and Sequence Generator transformations
• Worked on Change requests as per the requirements and performed testing on CR’s
• Creating Sessions and Workflows using Workflow Manager.
• Performed unit test based on business logic and created unit test cases
• Created parameter files as per requirements.
• Used UNIX environment to execute sequential workflows
• Creating migration strategy to migrate Informatica code from DEV to QA.
• Performed Integration Testing.
• Generated dynamic parameter files.
• Executed UNIX shell scripts using Windows batch commands and Created various active and passive transformations like Source Qualifier, Lookup, Router, Normalizer, Aggregator, Filter, Joiner, Expression
• Initiating, leading, and Monitoring bridge calls as necessary
• Driving and prioritizing incidents and work effort ensuring that team members are adhering to the M&O Incident Management process.
• Participating and assisting drive incident resolution.
• Ensuring that all M&O communications are sent out in a timely manner and adhere to M&O content and format standards.
• Ensuring that M&O Support turnover at the start and end of their shifts is accomplished in a seamless manner with good reporting and handover of open issues.Implementing and enforcing all standards and regulations established by the M&O Manager

Environment : Informatica 9.1, Teradata, DB2, Unix, Cisco

Confidential

Data Specialist

Project Responsibilities

• Provide development and enhancement solutions for Galaxy Data Warehouse applications using Informatica, Teradata and Unix technologies.
• Monitoring Production Jobs and Taking care of Incidents, Analyzing the production defects and fixing them permanently and Ensure we meet daily/Weekly/monthly SLA's.
• Analysis, design, development, testing, maintenance and implementation of the Data warehouse Auto and Property applications.
• Provide on call Production Support (Providing a temporary or a permanent fix which is required for production abends).
• Responsible for creating designs for development projects, provide performance tuning, support testing & deployment.
• Drive for consistency in format, agility in handling ongoing changes, updates as business demands.
• Implemented the concept of slowly changing dimensions to maintain current and historical data in the dimension. Designed and developed various Informatica mappings using transformations like Expression, Aggregator, External Procedure, Stored Procedure, Lookup, Filter, Joiner, Rank, Router, Update Strategy and
• Worked on data cleansing using the cleanse functions in Informatica.
• Working on ad-hoc report requests from Customer and supporting the clients for User Queries.
• Gathering the Requirements and doing Impact Analysis (Enhancements to the Applications).
• Preparing the Design from the Analysis and Conduct Code Walkthroughs, Code Reviews and Testing Reviews.
• Keep track of status of data, availability at all up level to support monthly reviews.
• Investigate any issues with data quality, consistency, gaps and assisting team in Peer reviews, Audits etc.
• Work independently in meeting the users for requirements gathering and prepare Functional specifications.
• Scheduled, Run and Monitored Informatica flows using scheduling tool Maestro, ESP.
• Involved in performance tuning issues at various levels such as target, sessions, mappings and sources.
• Configured schema, staging tables, and landing tables, base objects foreign-key Relationships, look up systems and tables, packages, query groups and queries/custom queries.
• Used post session success, post session failure commands in the session task to execute scripts for reconciliation, cleanup and updates.
• Involved in writing test scripts, unit testing, system testing and documentation.
• Coordinate with onshore team on Project developments and application support tasks and implement production releases.
• Prepare project related documents like Application Enhancement, design document, technical documents based on the business requirements for the enhancement projects.
• Coordinate with onshore team on Project developments and application support tasks and implement production releases.
• Extracted data from sources like fixed width and Delimited Flat files transformed the data according the business requirement and then loaded into Target Data mart.
• Responsible for understanding the business requirements as per Customer needs.
• To attend regular project status meetings with different teams to discuss the progress of the project, identify any risks in delivering the project on time etc.
• To migrate the code to production and provide postproduction support in the warranty period.
• On Daily basis need to send the status report to client regarding the production flows
• In case of abend in production need to resolve the abend within the given SLA time.
• Experience in resolving Data issues on Hadoop Hive - Big SQL Tables

Environment : Informatica 8.6, Teradata, Oracle, Unix,Maestro,Netezza