Swapnasish Mohanty

+1-669-***-****

ac82ol@r.postjobfree.com

Professional Summary:

11+ years of professional experience in IT industry with expertise in design, development, modeling and implementation of data warehousing applications. Strong business knowledge in Finance, Banking and Telecom domain with Extensive knowledge in financial reporting analytics.

Professional Experience:

I have 11+ Years of Professional IT experience as a Data Analyst, Data Modeler and Data Architect with solid understanding of Data Modeling, Evaluating Data Sources and strong understanding of Data Warehouse/Data Mart Design, ETL, BI, OLAP.

Excellent experience in analysis huge volumes of data in industries such as Finance, Banking & Telecom.

Experience in Big Data Technologies using Hadoop, Sqoop and Hive.

Facilitated data requirement meetings with business users and technical stakeholders and resolved conflicts to drive decisions.

Created, documented and maintained logical and physical database models with enterprise standards and maintained metadata definitions for enterprise data stores within a metadata repository.

Experience in testing Business Intelligence reports generated by various BI Tools like Obiee,BO and Tableau Reports.

Extensive experience of gathering requirement, Proof of concept, gap analysis, design, development, and Implementation of the ETL/Data warehouse projects.

Excellent understanding and extensive hands on experience in Informatica development/designing/testing.

Created and maintained software packages to handle database jobs, such as tracking application, storing or retrieving data, or controlling other audit report.

Good understanding of Amazon AWS ecosystems.

Experience with development and deployment in a AWS hosted cloud environment.

Experience working in Waterfall and Agile methodologies.

Technical Skills:

ETL Tool

Informatica Power Center 9.1/9.5/9.6/10.1

Databases

Oracle 12c,11g,10g, Teradata 15.1, MS SQL Server, Hadoop (HDFS)

Programming Language

Teradata SQL,Oracle SQL & PL/SQL, Unix shell scripting, XML,Oracle Forms 6i, Python, Hive and C#.Net

Reporting Tool

Oracle Business Intelligence Enterprise Edition (OBIEE), Tableau 9.3 and Business Objects.

Operating System

Windows 10, UNIX

Tools

Dollar Universe($U), Tidal Enterprise Scheduler (TES),Putty, Toad for Oracle, Oracle Pl/SQL Developer, Project Version Controlling Systems(PVCS), IBM Urban Code Deploy, Remedy, AutoSys,GIT

Employment Summary:

Working as an Associate Consultant in TCS since Oct 2011.

Worked as a Technology Analyst in Infosys Technologies Ltd from June 2010 to Sep 2011.

Worked as an Associate Consultant in ORACLE Financial Services Software Ltd from May 2007 to June 2010.

Work Experience:

Role: Sr Data Warehouse Engineer

Cisco Systems inc (USA)

November 2014 to Till Date

Conducted one-on-one sessions with business users to gather data warehouse requirements.

Analyzed reports from legacy data warehouse and source data to understand the business and data needs.

Lead the development of a data strategy, and works closely with business executives to create and execute Data Roadmap that will enable the most effective, efficient use of data assets, while defining the appropriate services and service costs to achieve economies of scale.

Analyzing the new requirements and creating TSD as per business requirement.

Developed complex mappings to populate dimensions and fact tables as per business logic.

Responsible for code deployment to higher environments like QA and Production.

Automated and fine-tuned ETL jobs and sequences for loading source systems data into warehouse.

To maintain the consistency and quality of the data worked with Data governance, Data Profiling and Data quality team that required managing the master data from all the business units as well as from IT and ensuring data quality standards across the enterprise.

Regularly have team meeting with client and onsite/offshore teams to complete assign task.

Worked on issues resolution during QA and BAT testing.

Role: Data Warehouse Engineer

Cisco Systems inc (USA)

October 2013 to October 2014

Gathered various reporting requirement from the business analysts.

Designed a STAR schema for the detailed data marts and confirmed dimensions.

Created and maintained the Data Model repository as per the standards.

Created ETL Jobs to load data from Source Systems to target data marts.

Defined business rules, aggregations and lookups.

Developed or modify packages/procedures based on requirements.

Developed complex mappings to populate dimensions and fact tables as per business logic.

Did performance tuning for long run mapping to meet SLA .

Regularly have team meeting with client and onsite/offshore teams to complete assign task.

Prepared process models to document data and information flows for sourcing and accessing warehouse data.

Worked on issues resolution during QA and BAT testing.

Monitoring the jobs and involving database and Informatica migrations.

Role: Oracle PL/SQL & ETL Developer

Cisco Systems inc (USA)

April 2012 to October 2013

Performed Source system analysis to identify the source data that needs to be moved into the target tables.

Performed data profiling between source and target systems after daily batch flow completed to compare, analyze and report mismatches.

Created and maintained several custom reports using PL/SQL procedures.

Involved in Estimations of Design and Development by analyzing code based on FSD Doc for the PMC Releases.

Worked with cross functions teams.

Developed mappings,sessions,workflows and reusable objects(mapplets,lookups)

Developed or modify packages/procedures based on requirements.

Developed complex mappings to populate dimensions and fact tables as per business logic.

Involving in performance issues.

Did performance tuning for long run mapping to meet SLA

Regularly have team meeting with client and onsite/offshore teams to complete assign task.

Worked on issues resolution during SIT and QA and BAT testing.

Role: Oracle PL/SQL & ETL Developer

HDFC Bank, India

April 2012 to October 2013

Analyzed the existing functionality of the Payment Gateway product.

Wrote packages, stored procedures for storing the user information.

Created Programme Specification.

Migrated Sql Server business logic to Oracle 11g.

Involved in performance issues.

Wrote validation rule, validating and executing the rules.

Unit Testing and Prepared UTP.

Role: Oracle PL/SQL & ETL Developer

Emerson, China

Jun 2010 to September 2011

Analyzed the I-Migrate Tool which is used for Data Migration.

Worked on Gap analysis and Gap Resolution process succeeding the Logical data mapping.

Worked on source to target mapping between source and target data model for ETL team

Generated Report using automation SQL Script.

Wrote the code for validation and upload of data.

Wrote Store Procedures and Functions.

Debug, troubleshoot, root cause analysis and resolve issues within SLA

Generated Report using automation SQL Script.

Unit Testing and Prepared STP

Role: Oracle PL/SQL Developer

CITI Bank, NA(USA)

April 2008 to Jun 2010

Analyzed the existing Banking Product of Flexcube LD and LT Module.

Created triggers to apply complex business logic and for auditing.

Business Component Development using Oracle SQL and PL/SQL.

Optimized critical queries to eliminate full table scans using explain plan, TKPROF.

User Interface Design & Development

Writing Store Procedure and Packages.

Co-ordinate development activities between offshore and onshore team

Support to IUT, ITR, RT & UAT.

Unit Testing and Prepared UTP.

Role: Oracle PL/SQL Developer

CITI Bank, NA(USA)

May 2007 to Apr 2008

Analyzed the existing Banking Product of Flexcube Loan Syndication (LS) Module.

Business Component Development using Oracle SQL and PL/SQL.

User Interface Design & Development using Oracle Forms 6i

Wrote Oracle Store Procedure and Packages.

Support to IUT, ITR, RT(Testing Phase).

Education

Bachelor of Engineering (B.E) in Electronics and Telecommunications

Biju Patnaik university of technology(BPUT), Odisha, India

Swapnasish Mohanty

Contact this candidate