Summary

• Several years of mendustry expermeence as a Data Engineer specmealizmeng men Business Intelligence, Analytics, and Agmele process/Scrum methodology.
• BS men Confidential Scmeence (2003) & MBA from Confidential . of Connecticut (2009).
• Currently workmeng as a Data Engineer men Microsoft, handling hmegh mempact projects with aggressmeve deadlmenes.
• Prevmeously worked for Bank of America, Morgan Stanley, Fmeserv, Yahoo, GE Capital & meGATE men the smemilar capacity.

Technical Skills

• Data Warehouse: Data Architecture, ETL, Dimensional Modeling, Data Governance
• Big Data: System design, Hive, Hadoop, Spark, Streaming Analytics, Data Integration
• Business Intelligence: Tableau, Cubes, Power BI, QlikView, QlikSense, Micro strategy
• Computer Programmmeng: Oracle, PL/SQL, SQL, Unmex shell scripting, mentroductory knowledge of C/C++ and HTML/CSS/JavaScript, Python
• Others tools: Busmeness Objects, Cognos, ALM tools like JIRA, MS Offmece/Vmesmeo/Project, Sharepoment
• Software Architecture: Cloud computmeng, REST & RESTful Web servmeces, Mmecroservmeces, n - Tmeer architecture, Unified Modeling Language (UML), Devops mencludmeng Cme/CD pmepeline, Git/SCM repositories
• Test Methodologmees: Test Driven Development, Unit & mentegration testing, Regressmeon testing, User Acceptance Testing
• Project Management: SDLC Methodology - Agile & Waterfall, Sprint planning, Managing Technical debt
• Documentation: Requirement collection & documentation, Use Case documentation, UI mockups/Wireframe diagrams

PROFESSIONAL EXPERIENCE

Confidential, Seattle WA

Data Engineer

Responsibilities:

• Worked on near real time datawarehouse using Cutting edge technologies in credit domain. Extensive experience on data transformation tools and big data technologies. Expert in building data analytics platforms from groud up using cutting edge big data technologies like pig, hive
• Involved in building a complex process to create xml data feed, encrypt and add a digital signature using openssl
• Architected/implemented reusable encryption framework
• Built data pipe link for fraud offline analysis of UK customers, saving ~10KUSD/day to start with
• Built a reusable framework to generate merchant settlement reports using big data eco system

Confidential, New York NY

Sr ETL Engineer

Responsibilities:

• Coordinate various enterprise efforts dat effect business applications, with a focus on data dat moves through teh enterprise.
• Key member of Data Architecture & governance program & Participating in Core Banking Re-platform Program.
• Data Architecture and Design for Enterprise Transaction Data Store.
• Successful implementation of MongoDB (NoSQL/Document based) data environment in teh Bank.
• Developed complex data pipelines for MongoDB documents for supporting Microservices architecture for new & modern enterprise Customer Relationship application.
• AWS Cloud Data Migration Strategy
• Build Enterprise Strategy for Test Data Management.
• Constantly monitor, refine and report on teh performance of data management systems.
• Define Data Warehouse Standards and Best Practices.
• ETL (Informatica) Development.
• Linux and Python Scripting for batch data processing.

Confidential, New York, NY

ETL Architect

Responsibilities:

• Working on Dodd Frank Compliance and CRM Interaction Reporting
• Monitor, support and fix Informatica Production ETL and Autosys jobs.
• Gathering requirements from Business, coordinating work with teh team, developing universe and reports in Business Objects, QlikView Dashboard and managing delivery.
• Communicate with teh Business Users, Business Analysts and Client to fully understand teh requirements
• Co-ordinate teh requirements with teh development team making sure dat all teh requirement information is clearly communicated.
• Address any Production issue or Ad-hoc user queries.
• Work with teh development team on teh requirement analysis and feasibility study
• Communicate teh development effort and delivery dates with teh Client.
• Design and update Data Warehouse.
• Read teh data from teh transaction data from teh transactional database through MQ Queries and load it into teh data warehouse using Informatica (ETL) workflows.
• Develop new Business Objects Universe, Reports and Schedules.
• Update existing Reports, Universes, Informatica (ETL) workflows and database changes as required
• Follow-up with teh development team at offshore on their status and update teh client.

Confidential, Norcross GA

Sr. ETL Developer

Responsibilities:

• Designed lending solution with Fiserv server hosted in-house (at Fiserv data center) and at client premise. Performed requirement gathering with PM, Business Analyst & stakeholders for teh implementation of bank lending portal project.
• Developed test scenarios to perform regression testing as part of project execution during QA & UAT. Designed process model in MS Visio to offer lending solution for teh banks loan customers and integrated teh bank customers’ needs with Fiserv Account Processing System.
• Handled change request and its implementation for teh client requested changes in JIRA.

Confidential, New York NY

Sr. ETL Developer

Responsibilities:

• Worked with teh Business Analysts and Business Users to understand teh requirements
• Performed teh feasibility study and provide teh effort estimations
• Developed and Maintained Dashboards in QlikView and applied set analysis at different levels
• Monitored QlikView Services and reload jobs.
• Granted and revoked user access
• Troubleshoot reload failures by reading and analyzing teh reload logs
• Create Ad-Hoc Reporting solution in QlikView
• Creating complex dynamic recurring QlikView Scheduled Jobs using NPrinting
• Work with teh infrastructure team to setup a new QlikView Environment.
• Write queries in SQL Server Management Studio and compare query output with QlikView Dashboard output.

Confidential, Revenue New York NY

Data Engineer

Responsibilities:

• Developed account insights & competitive trends for top advertisers through interaction with regional Directors, Account Managers & Sales Rep using historic data with teh focus to increase firm’s revenue
• Analyzed all teh advertising methods display & search ads and analyzed revenue generated by revenue models like cost per click, cost per visitor, cost per thousand impressions etc.
• Interacted with Directors, Account Managers, and Sales Rep to get their estimates on teh revenue by advertisers. Generated forecast report by region and by advertiser.
• Prepared automated quarterly forecasting sales metrics for each of teh Directors & Regional VP’s.
• Implemented dashboard to publish forecast & target revenue numbers on teh weekly/monthly/yearly ba s i s in Access DB & Cognos.

Confidential,

Sr . Software Engineer

Responsibilities:

• Collected user requirements & designed tech specs to implement historical data load from DB2 source to UNIX flat files to staging area and finally to Enterprise DW of teh warehouse system.
• Developed Informatica mapping to extract/transform data from DB2 (UNIX flat files) to staging area and later to Enterprise Data Warehouse.
• Created sessions & workflows to automate ETL operations.
• Monitored workflows, performed data validation and maintained load status & session logs.
• Performed Unit test in dev environment and worked closely with QA team for fixing issues.