Data Quality

DIPANKAR DASGUPTA

773-***-**** **********@******.***

LinkedIn Profile

Expert ETL/Data Warehouse Professional

Finance, Medical Technology, Insurance, Travel and Manufacturing Industry Experience PROFESSIONAL SUMMARY

Professional Data warehouse and ETL development expert with expertise in Data Modeling, Business Process Analysis, and Reengineering. Almost 20-years’ experience architecting and developing data quality solutions, leading the software development lifecycle with Agile/Scrum methodologies, and optimizing SQL queries. Areas of Expertise

Data Warehousing Cross-Functional Team Leadership Off-Shore Development Team Leadership Data Modeling Business Intelligence Reporting ETL Architecture ETL Design & Development Agile & SCRUM Methodologies SQL Queries Data Quality Solutions Design & Test Reviews Project Management

ETL and Database Skills

Informatica Power Center 10x, 9x, 8x, 7x, 6x Informatica Power Exchange Microsoft SSIS SAP BODS 4.2 SQL Server 7.0 / 2000 / 2005 / 2012 Oracle 8 & 9, 10g Software Skills

QlikView Informatica Data Quality SAP data services BO Data Quality XI Microsoft ERWIN

Sybase Powerdesigner Embarcadero Autosys JAMS Python Lawson Financial accounting system Salesforce CRM Qlikview Business Objects PROFESSIONAL EXPERIENCE

Electric Insurance Company, Boston, MA 2006 – Present Lead BI Reporting Analyst (2012 – Present)

Senior BI Reporting Analyst (2006 – 2012)

Recruited by insurance organization owned by General Electric to create ETL design for various Policy, Claims, and Billing systems by leading the development and design of solutions in addition to off-shore resources.

Manage up to 10-person off-shore team and collaborate closely with development team in India and various countries in Europe.

Oversee internal developers and all technical ownership of projects by working with architects, internal staff, and off-shore development teams.

Lead development initiative to adhere Informatica best practices and standards outlined in Informatica's Velocity Methodology.

Define extraction process from mainframe, VSAM files, unstructured files and relational databases.

Develop data quality processes using tools including Informatica Data Quality, BO data quality XI and SAP data services.

Modified Business Objects universes and developed reports utilizing BO WebIntelligence software.

Worked closely with the FP&A teams to deliver financial reports from the Lawson datamarts and helped resolve financial accounting variances.

Key member is migration of financial reports from inhouse to Infor Lawson cloud server.

Direct Capacity Planning for ETL, Database, and Reporting Servers.

Gather business user requirements to understand use cases, complete high-level and detailed document design cases, and review code.

Provide data cleansing using SAP BODS and Data Quality tools and lead SQL development expertise.

Collaborate with end-users to lead design and review sessions with the UAT, and create test cases and test design.

DIPLANKAR DASGUPTA 773-***-**** **********@******.*** Resume, Page 2

Key player in Salesforce implementation from legacy systems applying the data quality standards and best practices.

Developed and documented the Informatica best practices and standards including high-level and detailed design and source to target mappings.

Significant Projects:

Served as key member of data migration team to implement Salesforce using SISS to give business 360-degree view of customers including Qlikview and Business Objects for data visualization and reporting.

Worked with external vendors including GE Synchrony during divestiture to manage data feeds and ensure each employee had uninterrupted benefits coverage in the system conversion.

Improved nightly batch processes by implementing enterprise scheduling on Autosys and JAMS. Independent ELT Consultant 1998 – 2006

Led ETL Data warehouse projects for Fortune 1000 clients across many industries including Mutual of Omaha, Abbott Laboratories, Carnival Cruise Lines, and P&G.

Defined high-level requirements and created detailed design for change processes.

Developed ETL processes and strategies including recovery, backup, and error-handling.

Mentored and trained junior developers and found solutions to technical problems.

Conducted performance tuning and optimization of Informatica mappings and workflows.

Analyzed data flow in existing CRM systems and mapped to Universal data model for transportation.

Created mappings, sessions, and workflow for Operational data store and Enterprise data warehouse.

Performed detailed source-system, source-to-target, and transformation analyses.

Led extraction, transformation, and loading of data from heterogeneous sources and interface into data warehouse with Informatica.

EDUCATION & CERTIFICATIONS

Advanced Diploma (Master’s Equivalent) in Computer Science Informatics India Ltd. Bachelor of Science Bombay University, India

Certifications Include:

Brainbench Certified Data Warehouse Specialist

ICAgile Certified Professional - Foundations of DevOps (ICP-FDO) Certification Datahub 9.x ETL Integration

Datahub 9.x Specification

Professional Development Includes:

Worldwide Salesforce Annual Conference Attendee (2012) PROFESSIONAL MEMBERSHIPS

Active members professional organizations including: Informatica Developers

TDWI - The Data Warehouse Institute

QlikView

Data Warehouse - Big Data - Hadoop - Cloud - Data Science - ETL

Contact this candidate