SUMMARY:

• Seven years of IT experience in Taxation, Financial and Insurance industries , with four years of experience in Application Design, Data Modeling, Development, Implementations of Data Warehousing as an ETL developer and three years as Business Requirements Analysis, Business Development, Data analyst
• Strong experience in data profiling, data migration, data integration and data verification
• Ability to collaborate with peers in both business and technical areas to deliver optimal business process solutions in line with corporate priorities
• Vast experience in interpreting, analyzing and reconciliation of data obtained from a variety of sources
• Ability to collaborate with peers in both, business, and technical areas, to deliver optimal business process solutions, in line with corporate priorities
• Comprehensive experience in executing projects through Agile ,SDLC project life cycle and separating waves based on end user requirements
• Good experience in Data Modeling with expertise in creating Star and Snow-Flake Schemas, FACT and Dimensions Tables and Physical and Logical Data Modeling
• Developed and supported Extraction, Transformation and Load process ETL using Informatica Power Center to populate the tables in Data warehouse
• Motivated self-starter with exceptional team building, leadership, and interpersonal skills
• Proficient in working with stakeholders to elicit, analyze, communicate and validate issues using brainstorming, process flows and JAD expertise in translating business requirements to workflow models, activity charts and swim lane diagrams
• Data Warehousing experience using ETL Informatica Power Center 9.1/8.6 , Data mart, OLAP, OLTP
• Strong knowledge in data mining and validating and presenting the reports along with ETL developers
• Experience in authoring business requirement documents BRD by gathering business requirements and then validating and prioritizing it by performing risk analysis, gap analysis and ROI analysis
• Expertise in coordinating multiple priorities, managing end user expectations, creating partnership with customers and problem solving
• Experienced to work in Development team, Production support teams in handling critical situations to meet the deadlines for successful completion of the tasks/project
• Excellent oral and written communication skills, analytical skills, problem solving, leadership and management capabilities with quick learning abilities
• Experience in interviewing subject matter experts, asking detailed questions and carefully recording the requirements in a format that can be reviewed and understood by both business and technical people
• Experience in performing root level analysis for data problems by identifying the system processes that lead to inaccurate data
• Knowledge in testing the user stories for accuracy and compliance to ensure undisputed acceptance and validation of stories

EXPERIENCE:

Confidential

ETL Developer/ Data Analyst

Responsibilities:

• Coordinate with ETL team to implement all ETL procedures for all new projects and maintain effective awareness of all production activities according to required standards and provide support to all existing applications.
• Working with QA team to support the project life cycle, understanding business and technical needs and assisting the user and other developers
• Involved in getting files from different database such as oracle , integrating and determining the complexity of the data and ensuring to deliver it reporting team
• Responsible for defining the key identifiers for each mapping/interface along with defining the functional requirement documents for each source to target interface
• Perform root cause analysis on all processes and resolve all production issues and validate all data and perform routine tests on databases and provide support to all ETL applications.
• Ensure accuracy integrity of data applications through analysis, coding, writing clear documentation problem resolution.
• Involved in the analysis, design and development of all the interface's using Informatica Power center tools in interface team and interfaced with all the other tracks for business related issues
• Involved in change request design and implementation, and related testing, migration and documentation process. Translated the business process specification into Informatica mappings design for building the DataMart
• Verifying the Fact and Dimension table design Star Schema per design specifications for the Inventory, Product, Sales and Marketing DataMart
• Analyze the historical documentation, supporting documentation, screen prints, e-mail conversations, presented business and wrote the business requirements document and got it electronically signed off from the stake holder
• Involved in defining the source to target data mappings, business rules, business and data definitions
• Preparing artifacts based on discussions with technical leads and migrating it to end users after understanding the epics
• Update weekly progress to PM/senior management- Assisted Project Manager with scheduling and execution of implementation tasks

Creating mappings using Unconnected Lookup, Aggregator and Router transformations for populating target table in efficient manner.

• Translated the business requirements into Informatica mappings/sessions/workflows.
• Coordinate with Business Analysts for requirements gathering and to justify impact on other databases due to new requirements
• Extensively used ETL to load data from multiple sources to Staging area DB2 using Informatica Power Center worked with pre and post sessions.
• Implemented performance tuning techniques by identifying and resolving the bottlenecks in source, target, transformations, mappings and sessions to improve performance.
• Monitored client expectations through client involvement and communication throughout the lifecycle of the project, educate clients and stakeholders on the benefits and risks associated with the project and prepared GANTT charts
• Trained staff members on the new systems implemented and maintained SLA's with optimal utilization of resources
• Involved with Data profiling for multiple sources and answered complex business questions by providing Data to business users
• Worked with managers and users to develop business requirements and to analyze /model current and proposed business process flows.
• Involved with troubleshooting the Mappings for various developers and performance enhancements or change implementation
• Wrote multiple PL/SQL code pieces to perform complex matrix multiplications needed per business rules and updated multiple target tables
• Analyzed Data Specification Documents DSDs and implemented their logic in the form of Informatica mapping design
• Analyzed source system data and implemented the transformation rules per ETL mapping specifications into Power Center Mappings
• Perform root cause analysis on all processes and resolve all production issues and validate all data and perform routine tests on databases and provide support to all ETL applications
• Cross-checked existing mappings according to the business rules and suggested alternate designs to make the mapping design more robust and error-free
• Used various complex Power Center Transformations like Lookup, Joiner, Expression, Router, Update Strategy, Source Qualifier, Aggregator, SQL, Filter, Sequence Generator, XML Generator, Normalizer to accomplish the mapping design
• Effectively manage team on a day to day basis ensuring development processes are being followed, which drives overall health of the project
• Involved in Data mining, transformation and loading from the source systems to the target system

Confidential

Data Analyst

Responsibilities:

• Interacting as a liaison between users and the different teams in the collecting data and application development for better understanding of the business and IT processes
• Conducted SMEs meetings and one-on-one interviews at both in-house and client locations gathered requirements, provided analysis/functional specifications as well as liaised closely with both front and middle offices and analyzed requirements using Requisite Pro RUP.
• Cleansing and validating information received from various sources and understanding the eligibility rules along ETL developers
• Document all data mapping and transformation processes in the Functional Design documents based on the business requirements
• Worked extensively through Agile development methodology by dividing the application into iterations and working on each iteration through full SDLC
• Executed various finance projects through DMAIC process and ensured that all the processes and requirements were accurately defined in the projects
• Assisting data modelers in preparing fact tables, dimension tables, star schema modeling and snowflake schema modeling
• Creating report models for ad hoc reporting and analysis and delivering to end users
• Involved in Data Analysis Mapping to track all data elements used in the application from the user interface through different interfaces to the target databases
• Involvement in defining the source to target data mappings, business rules, business and data definitions
• Preparing a data flow diagram in order to visualize the structural design after gathering information from the business analyst
• Proficient experience in working on conceptual, physical and logical data models 3NF using various data modeling tools
• Working with the project team representatives to ensure that logical and physical data models are developed in line with corporate standards and guidelines
• Created dimensional model design for data warehouse and source to target documents that were used by ETL developers to load data
• Giving training to the staff members on the new systems implemented and maintaining SLAs with optimal utilization of resources
• Performance tuning of SQL queries and analyzed major customer Data-related requests
• Data model reviews with internal Data architect, business analysts, and business users with explanation of the Data model to make sure it is in-line with business requirements.
• Lead the critical process mapping project by conforming to bank methodology, identifying risks and controls within the mapped environment and validating those items with the managers
• Performing task decomposition, delegated tasks and monitoring project milestones using MS Project and prepared GANTT charts
• Collaborated with ETL, BI and DBA teams to analyze and provide solutions to Data issues and other challenges
• Worked on the continuous improvement of QA Process for identifying the root causes and by reviewing and evaluating existing practices with standard testing guidelines.
• Involved in identifying the criticality and relevance of project issues and adhere to the appropriate level and degree of escalation, negotiation of issues with business sponsors and technical team, and communicate status accordingly

Confidential

Business Analyst

Responsibilities:

• Reconciled tax payments with supporting reports and documentations on a monthly basis
• Provided operational assistance and support as needed to the fund group during the transition phase of the project
• Developed budget and financial forecast models for efficient working capital management
• Assisted in performing an internal audit of the client's financial control systems prepared recommendations to address areas of audit issues
• Identified financial control and reporting systems needed to streamline reporting of financial data to internal and external clients
• Interacted with underwriters to understand multiple data points. Prepared data flow diagrams using MS Visio for better clarity and to ensure process was streamlined
• Involved in identifying the criticality and relevance of project issues and adhered to the appropriate level and degree of escalation, negotiated the issues with business sponsors and technical team and communicated the status accordingly
• Prepared required documents and worked with developers to validate designs and functional specifications
• Conducted one-on-one meetings and web conferences with different stakeholders analyzed and came up with suggestions for escalation and resolution of issues
• Created functional specification documents for expatriate to file the taxes
• Involved in creating database models using MS Visio and MS Access for supporting back end tax documents
• Ensured that all project timelines, budgets and quality standards for finance were met by the timelines and guidelines set by the line of business roadmap
• Established and cultivated working relationships with project sponsors, business stakeholders and technology, operations and subject matter experts along with many others
• Transitioned pilot projects from US and EMEA provided guidance to the management on matters pertaining to internal controls and process improvements
• Facilitated JAD sessions to collect requirements from system users and prepared business requirements that provided appropriate scope of work for the technical team to develop the prototype and the overall system
• Participated in strategic planning and designed business cases for new product extension
• Reviewed cost and performed a cost benefit analysis report related to business development opportunities