Data Developer
Resume:
Swapnasish Mohanty
*************@*****.***
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