SUMMARY

• A Seasoned Sr. Architect/BI & EDW Architect/Data Modular/ETL Developer/Data Analyst/Database Developer consultant with 11+ years of experience.
• Excellent Business Knowledge in Retail Banking, Trade Finance, Pharmaceutical, Insurance, Power Industries and Health Care.
• Good Knowledge in Amazon Elastic Compute Cloud (Amazon EC2 & S3) and MS Azure.
• Hands - on experience implementing Big Data technologies (Pig, Hive, Hbase) solutions, Data Analysis Using Pig, Hive, Hbase and Impala with Hadoop.
• Good Knowledge in Columnar database i.e. Redshift.
• Expert knowledge in oracle forms/reports, IBM Informix, Mongo DB 2.6 & Teradata 15.
• Expert knowledge in BI tools like Cognos, Business Objects XI, Oracle BI Suite, SSRS & Tableau.
• Experience Upstream Data Modeling Using Erwin, Embarcadero ER/Studio, Oracle SQL Developer Data Modeler and MS-Visio Data Modeling Tools.
• Well versed in Kimball and Bill Inmon data warehousing methodology
• Expert Experience and Knowledge in Master Data/Metadata Management (MDM), Data Quality and Data Governance implementation.
• Extensive experienced in Data Conversion and Migration from legacy system into Oracle database.
• Extensive experienced in SQL tuning, PL/SQL tuning, Application tuning.
• Expertise in ETL using Oracle, Informatica, SQL SERVER, SSIS, OWB & Talend
• Great depth of knowledge in planning and implementing physical and logical structures of a very small database to very large databases.
• Extensive experienced in Unix Shell Scripting and Perl scripting.
• Expert knowledge of Web Based applications and knowledge of .Net Architecture, J2EE Architecture.
• Excellent experienced of clinical life science data i.e. Clinical Trials.
• Excellent experienced of Treasury Transaction in Banking like Conversion of Multi Currency, Foreign Exports & Imports Transaction, Deposits, Loans and Running Packing Credit etc,.
• Experience in testing - Unit, Functional and Integration and possess a commitment to Quality.
• Expert knowledge in Project Management process and a PMP candidate.
• Strong knowledge and use of development, methodologies (LEAN, AGILE, SCRUM), standards and procedures.
• Self-motivated, highly committed to responsibilities, ability to work independently and perform well within cross-functional teams.

TECHNICAL SKILLS

RDBMS: Oracle 12c/11g/10g/9i, SQL Server 2008/2012/2014 , SybaseASE 12.x

DBMS: MS Access 2010/2013, FoxPro 2.6,dBASE III+

BIG DATA: Apache Hadoop 2.x, Teradata 15, Mongo DB 2.6, RedShift

Graph DB: Neo4j

CLOUD: Amazon AWS, MS Azure

GUI: Oracle Forms 9i, Reports 9i, Visual Basic 6.0, ASP 2.0

BI Tools: Cognos 10, Business Objects XI, Oracle Discoverer 9i, Tableau 9

ETL Tools: Informatica 7.x/8.x/9.x, OWB 10g, MSBI, Talend

Programming Lang.: Core JAVA SE 6, 7, 8

O/S: HP Unix 11.x, Solaris V9x/10x, Red Hat Enterprise Linux 6.x/7.x, Windows NT 4.0, Windows 2000/2005 Server

Scripting: VBScript, JavaScript, Unix Shell Script, Perl script

ERP: Peoplesoft, Finacletm, SAP

Other Tools: Toad 9.7/11/12, SQL Navigator 4.0, Erwin 7.x/9.x, Webmethod 6.5, Crystal Reports 6/9/XI, Oracle SQL Developer, Visio 2003, Autosys 4.0, MS Office 2003, Clear Quest, PL/SQL Developer, Enterprise Architect 4

Internet Tools: MS Project Plan, PVCS, Clear Case, MS VSS, Mantis, MS Share point, Bugzilla, SVN, JIRA, GIT

Designing Tools: HTML,XML, Corel Draw 8/9, Adobe Photoshop 5.0/6.0

PROFESSIONAL EXPERIENCE

Confidential, Chicago IL

Sr. Data Architect/Data Modeler

Responsibilities:

• Developed a high performance, scalabledata architecturesolution that incorporates a matrix of technology to relate architectural decision to business needs.
• Lead the development and implementation of thelogical data model and physical datadesign utilizingdata architecture and modeling standards.
• Defineinformation architecture, data interfaces for serving to dashboards,ETLprocesses,data models, schemasfor high performance distributed processing and analyzeoffunctionalandnon-functionalcategorized data elements fordataprofilingandmappingfrom source to target data environment.
• Advanced information management and newdataprocessing techniques may be applied to extract the value locked up in thisdatacalledHadoop (HDFS)along with processing largedatasets in parallel across aHadoopcluster and the utilization ofHadoop MapReduce framework.
• Presented thedatascenarios via,Erwin logical modelsand excelmockups to visualize thedata better and usedErwinandVisioto create3NFand dimensionaldata modelsand published to the business users andETL / BIteams.
• Dealing with Business analysts inagilemethodologyto understand the business challenges anddatafor reporting.
• Responsible for interaction with business stake holders, gathering requirements and managing the delivery, covering the entireTableaudevelopment life cycle.
• Worked onAWSRedshiftandRDSfor implementing models anddataonRDS and Redshift.
• Handled importing data from various data sources, performed transformations usingHive, Map Reduce, and loaded data into HDFS
• CreatingSASprogramsand performed data validation on raw data sets and created data set for analysis and Capable of utilizing data management techniques like Merging, concatenating, interleaving ofSASdatasets usingMERGE and SET statements in DATA step.
• Provide delivery support forWorkdayHuman Capital Management applicationsto our clientsand developedWorkdayintegrations with other internal and external systems as per the design spec.
• Involved withdata profilingfor multiple sources and answered complex business questions by providing data to business users and worked with data investigation, discovery andmapping toolsto scan every single data record from many sources.
• DevelopTSQL scriptsto create database objects and performDMLandDDLtasksand wrote and executedunit,system,integrationandUATscriptsin adatawarehouseprojects.
• Architectedanddesignedsolutions for complex business requirements, includingdata processing, analytics and ETL and reportingprocesses to improve performance of data loads and processes.
• Designed theER diagrams,logical model(relationship, cardinality, attributes, and, candidate keys) andphysicaldatabase (capacity planning, object creation and aggregation strategies) forOracleandTeradataas per business requirements usingErwin 9.6andtroubleshoottest scripts,SQL queries,and ETLjobsanddatamart/datastoremodels.
• UsedInformaticato extractdatafromWorkdayto staging and then loading thedatatoEDWdata warehouse anddatamart, EDW built onNetezzadatabase andWorkdayHR-Payroll system.
• Processed the data usingHQL (like SQL) on top of Map-reduce.
• Extensively usedETLmethodologyfor supportingdataextraction, transformations and loading processing, in acomplexEDWusingInformaticaand create Databases,Tables, Indexes, Stored Procedures, Views, database management policies andConstraints, Defaults, Rules, Functions, Triggers, Cursors and Dynamic SQL queries.
• Worked onSASforDataAnalysisand involvedinimportingandcleansingof data from various sources likeTeradata,Oracle,flatfiles,Netezza,SQLServerwith high volume data.
• Involved in extensiveDATAvalidationby writing severalcomplexSQLqueriesand Involved in back-end testing andworked with data quality issues and resolveddataissues and updates for multiple applications usingSQLqueries/scripts.
• Identified allERPfields, tables and relationships for sales, Finance, Management reporting.
• Developedreports usingSQL Server Reporting Services (SSRS) and involved in the validation of theOLAPUnit testing and System Testing of theOLAPReport Functionality and data displayed in the reports.
• Populate or refreshTeradatatables usingFast load, Multi load & Fast exportutilities for user Acceptance testing and loading history data intoTeradata.

Environment: ERWIN r9.x, MS Excel, PL/SQL, SQL Server, SSRS, SSIS, Java, Business ObjectsXIR2, ETL Tools Informatica 9.5, Oracle 12c, Tableau, Teradata V2R12, ERP, BigData, Agile, SAS, Workday, MongoDB, AWS, Cassandra, Teradata SQL Assistant 12.0, NetezzaAginity, UNIX, Hadoop, Hive, HBase, Pig, SQL, T-SQL.

Confidential, NYC

Data Architect / Sr. Data Architect

Responsibilities:

• Worked with the business analysts to understand the project specification and helped them to complete the specification.
• Defined user requirements, developing the dataflow diagrams, process models, entity relationship diagrams.
• Participated in full Software Development Life Cycle (SDLC) following Agile Methodology (SCRUM)
• Gathered business requirements and build/modify the Conceptual & Logical Data model
• Analyzed business requirements build/modify data mart (star/ snow flow schema data mart).
• Build the Conceptual & Logical & Physical data modeling Enterprise Business Intelligent with new analytics for next generation data warehouse using Erwin and ER-Studio Data Modeling tools
• Build/Design/implement the Master Data/Metadata Management(MDM), Data Quality and Data Governance Process for Upstream business
• Build/Design/implement the Business Intelligent applications/Reports/Dashboard using Business Objects & Cognos tools.
• Extensively developing and tuning Stored Procedures, Triggers, Packages and Functions in PL/SQL for OLTP applications.
• Query Optimization & SQL tuning.
• Performed unit testing accordance with unit test plan
• Performed source code review
• Participated in product meeting.
• Implemented the MDM, Metadata, Profiling, Data Governance and data Quality in Projects
• Implemented the Kimball and Bill Inmon data warehousing methodology
• Capacity planning, performance tuning and problem resolution for OLTP, ODS & EDW databases
• Worked with client governance bodies to define reference architectures for business intelligence, reporting and data integration
• Implemented slowly changing dimensions and data transformations using informatica, SSIS.
• Supported Data Warehouse application and databases
• Developed informatica packages and deploy it in Development/Testing and production server
• Tune application database system performance by analyzing data, making recommendations and implementing application database tuning improvements.
• Prepare IQ/OQ documents, Functional Specification documents, System Design Specification documents, Requirements Traceability Matrix documents, Quality Assurance Plan documents, Cross Reference Design documents, Configurations Items List documents etc.

Environment: Red hat Enterprise Linux 5, ORACLE 10g, PL/SQL, SQL*Loader, Unix Shell, JAVA SE 6, Scripts, Star schema, ODS schema, Informatica 8.x, Erwin 7.x, Enterprise Architect(UML Tool), TOAD V9.7, Sql Developer, Webmethod 6.5, Eclipse BIRT, Mantis, MS Share point, MS SQL Server (SSAS,SSIS, SSRS) and MS-VSS.

Confidential, NJ

Lead Database Developer / Lead ETL Developer

Responsibilities:

• Work with data analyst to handle with data design, data mapping and data mining.
• Handle with data mart to maintain clinical trials for testing different levels and events.
• Handle with separate data mart in order to measure the metrics of time cycle.
• Maintain and modify CORE database to extract data from different application such as CTMS, CTS, SPIDER, RDR and CDR.
• Create Objects, Packages, Procedures, Functions and SQL queries to manipulate CORE data.
• Resolve data integration issues across systems, which are integrated with CORE database.
• Periodically monitor CORE database for performance and logs.
• Periodically design and execute database performance measures, e.g., partitioning, query tuning, re-indexing, analyzing etc.
• Wide use of PL/SQL for extracting, transforming, loading data from OLTP database into OLAP database in oracle.
• Implementing the MDM, Metadata, Profiling, Data Governance and data Quality in Projects.
• Maintain CORE database documentation.
• Work with Reporting Services to deliver COGNOS reports via accessing CORE database.
• Prepare IQ/OQ documents, Functional Specification documents, System Design Specification documents, Requirements Traceability Matrix documents, Quality Assurance Plan documents, Cross Reference Design documents, Configurations Items List documents etc.
• Setup deployment steps and procedures with UNIX deployment team for IT/UAT and production environments.

Environment: HP-Unix 11.x, Oracle 9i /10g, Informatica 8.x, SQL Plus, PL/SQL, UNIX shell script, AWK, Perl Script, Erwin 4.x, Toad 8.6, SQL Navigator 4.x, MS Office, TIBCO Web Service.

Confidential

Sr. Oracle Consultant

Responsibilities:

• Worked with the data analyst to understand the project specification and helped them to complete the specification.
• Defining user requirements, developing the dataflow diagrams, process models, entity relationship diagrams.
• Developed and tuned Stored Procedures, Triggers, Packages and Functions in PL/SQL.
• Query Optimization & SQL tuning.
• Created Materialized Views
• Automate UNIT testing for PL/SQL packages.
• Written UNIX shell scripts to handle tasks like background processes.
• Extensively used PL/SQL for extracting, transforming, loading data from OLTP database into OLAP database in oracle.
• Analyzing and testing the loaded data in OLAP database.
• Extract the data from OLAP database and published into business objects tool, which helps the business analysts to analyze the business related queries for specific period.
• Generating reports based upon user requirements using PL/SQL.
• Monitoring and optimizing the performance of the Database through Database Tuning - SQL Tuning, PL/SQL Tuning using EXPLAIN PLAN, Oracle Hints, Bulk Collections and native PL/SQL compilation method

Environment: Sun Solaris 9.x, Oracle 10g/9i, informatica 7.x, SQL Plus, PL/SQL, UNIX Shell Script, Apache 2.0, MQ Series, J2EE, Crystal Report XI, Erwin 4.x, Autosys 4.0, MS Office, Toad 8.6, PVCS.