SUMMARY

• Around 10+ yrs. of experience in Software Development including 7+ yrs. of experience in Data Warehousing, and dimensional modelling
• Working knowledge on Oracle, Sql Server, DB2 and IBM Netezza, Teradata
• Good experience in Extraction, Transformation and Loading (ETL) data from various sources into Data Warehouses and Data Marts using Informatica Power Center (Repository Manager, Designer, Workflow Manager, Workflow Monitor, Metadata Manger)
• Hands on Experience on SDLC process, Requirements gathering, Analysis, Technical specifications, and project related documents
• Worked in mid - scale and large-scale business intelligence projects and effectively analyzed the business integration points, designed the ETL architecture with standards and processes, and developed complex reusable objects/components, collaboration among cross functional teams, proactive in identifying issues and mentoring the project team.
• Provides hands on to the technical team during crisis on the critical path because of the extensive technical knowledge gained throughout the carrier
• Possess exceptionally good experience in the insurance industry, has worked in the same domain for the last 10 years, worked in Financial, Banking, insurance and Telecom domains.
• Results focused, customer service oriented, well-organized individual with proven results in project management, team leadership and client support.
• Strong mentoring skills, capable of leading and motivating individuals to maximize productivity while fostering cohesive teams in a virtual environment.
• Exceptional communicator focused on building strong relationships with peers and clients.
• Executed and worked in Waterfall, RAD, ETL Factory, Master Data Management, Effective Exception Management, Prebuilt EDW mapping, defining canonical model for critical insurance entities
• Has experience in requirement analysis, design, developing and testing various types of reports for various projects ranging from simple to complex reports and dashboards through Tableau.
• Automation of cube builds process and deployments, Automation using shell scripts and batch scripts
• Having Working experience Informatica, SSIS, Business Objects, SSRS, Tableau 10
• Good sql and pl/sql coding skills using Toad and aginity Workbench on Oracle, sql Server, IBM Netezza
• Extensive knowledge in various reporting objects like Facts, Attributes, Hierarchies, data blending, Transformations, filters, prompts, Calculated fields, Sets, Groups, Parameters etc., in Tableau
• Experience in designing and developing end-to-end BI solutions per standard OLAP methodologies using analytical tools like OBIEE, Power BI and Tableau.
• Working experience in Data Modeling using 3NF, Star, Snowflake, Identifying Facts and Dimensions, Physical and logical data modeling
• Played various roles from OBIEE Developer to OBIEE Administrator, Data Analyst, Data Modeler, Business analyst, Technical project Lead.
• Excellent communication, management, and organizational skills with the ability to interact with all levels of management, strong presentation, and collaboration skills.
• Experience in Informatica Power Center 9.x/10.x, Tableau and Power BI
• Experienced in Onsite/Offshore model and Customer facing skills.
• Involved in full project lifecycle: defining scope, gathering requirements, analyzing, estimating, planning, designing, modeling, writing business and technical specifications, developing prototypes, development, testing, deployment, implementation, documentation, and support.
• Good knowledge in AWS cloud migration .

TECHNICAL SKILLS

ETL Tools: Informatica Power Center 10.x, 9.x, Snaplogic, SSIS

MDM Tools: Informatica MDM Hub Console, Informatica RDM accelerated

BI Tools: OBIEE 12c, OBIEE 11g, OBIA 11g, Tableau 10.x, Microsoft Power BI, SSRS

Databases: Oracle 11g/10g/9i/8i, Teradata, DB2 v8.1, SQL Server, PostgreSQL

Operating Systems: Windows 2008/NT/XP, UNIX, MS-DOS

Data Modelling tools: ER Win, MS Visio

Languages: SQL, PL/SQL, T-SQL, UNIX Shell scripting, Java, Python

Desktop Tools: MS Office Suite including Visio, TOAD, SQL Loader, Winsql

Other Tools: Service Now, HP QC, GitHub, Informatica IDQ, Cloud B2B Gateway Data Exchange

PROFESSIONAL EXPERIENCE

Confidential

ETL Architect

Responsibilities:

• Part of the due diligence to understand the existing source systems and different integration points needed for building the data layer
• Built Data integration solution approach, technical architecture document and worked with Enterprise architecture team to build the architecture design document
• Supporting the development group by providing API's and performing middle-tier application development with python code building technique
• Develop framework, metrics and reporting to ensure progress can be measured, evaluated, and continually improved
• Analyze, design, and implement of data Hub Staging for critical Insurance entities (Policy, Billing, Premium and Product)
• Understand existing reports semantic layer, build new reporting and commission layers for smooth transition of data across different downstream points
• Establish standards, process aligning to best practices and lessons leant from the prior project knowledge
• Establish error reports and audit for business evaluation and create incremental data consumption
• Establish standards and build reusable repositories during framework customization
• Prepare summary reports for project stakeholders and keep them well informed on the risk, achievements, progress and needs of the projects
• Establish system and process improvement workshops during the phase of the project by bringing in the entitled participants
• Participate and aid during business analysis and prepare appropriate business process diagrams for better understanding among different project participants.
• Establish and monitor Business Intelligence methodologies and provide suggestion on any utilizing any other protocols and variants of the employer methodologies

Tools: and Technologies: Windows 7, VM Horizon Client, Informatica Power Center 10.2, PostgreSQL Database, IBM Netezza platform, JIRA project management, Tessera ticketing tool, Yellow brick 3.0, Python, MS Visio, WinSQL, Putty, Winscp3, Unix AIX box, Linux and Windows Remote Workstation

Confidential

Senior Informatica Developer

Responsibilities:

• Worked as part of a project team to coordinate database development with schema creation and sizing and determine project scope and limitations.
• Developed, tested, implemented, and debugged new and existing Informatica mapping and mapplets for Enterprise Information Management (EIM) for all internal and external data sources
• Analyzed components to find causes of errors and revise programs as needed to determine technical requirements. Consulted with end user to prototype, refine, test, and debug components to meet needs
• Tuned performance of Informatica jobs to ensure optimal efficiency and performance
• Participated in code review and recommend solutions to enhance ETL programs to project team and management
• Experienced with Cloud B2B Gateway, Data Exchange, Cloud Multidomain MDM and Axon data Governance tools
• Created deployment instructions including failure recovery procedure and monitors successful data load of deployments
• Worked with Quality Assurance team in developing test scripts and test plans for validating the accuracy of ETL jobs and the quality/integrity of loaded data
• Assisted in continuous improvement efforts and enhancing project team methodology and performance
• Analyze, design, and implement Master Data Management system for critical Insurance entities (Agents, Policy and Product)
• Understand existing agent hierarchy, build new reporting, and commission hierarchy data models along with the MDM
• Expertise in creating Mappings, Trust and Validation rules, Match Path, Match Column, and Match rules,
• Merged properties and Batch Group creation on Cloud Multidomain MDM tool
• Worked on Data Profiling using IDE-Informatica Data Explorer and IDQ-Informatica Data Quality to examine different patterns of source data
• Designed and configured core MDM Hub components such as Informatica MDM Hub Console, Hub Server, Cleanse Match, Cleanse Adapter
• Build service layer on top of these components for consumption to reports for end-users

Tools: and Technologies: Informatica IICS technique, Informatica Developer 10.2 HF1, ErWin, Informatica IDQ Cloud integration system, Informatica B2B Gateway, Data Exchange, Cloud Multidomain MDM, Informatica Reference Data model, Azure DevOps collaboration, Azure blob storage, SQL Developer, Github version control

Tableau Developer

Confidential

Responsibilities:

• Understand and analyze business requirements and translate to those to technical deliverables
• Designed, developed, tested, and maintained Tableau functional reports based on user requirements
• Mastered the ability to design and deploy rich graphic visualizations with drill-down and drop-down menu option and Parameters using Tableau
• Converted existing OBIEE reports to tableau dashboards
• Implemented security model for Financial Intelligence application including data level, row level, and report level, managing security privileges for each subject area and dashboards
• Developed Tableau data visualization using cross tabs, heat maps, box and whisker charts, scatter Plots, geographic map, pie & bar charts, and density chart
• Utilized Tableau server to publish and share the reports with the business users
• Involved in administration tasks such as setting permissions, managing ownerships, and providing access to the users and adding them to the specific group

Tools: and Technologies: Windows 7, Azure DevOps collaboration, Azure blob storage, Oracle OBIEE, Data Fabric methodology, Tableau 9.0 data visualization, Tableau server, Tableau Hyper export, Informatica Power Center 9.6, Oracle E-B suite Applications, Service Now ticketing tool, Oracle OEM, RMAN, SQL*Loader