Sr. Data Warehouse Architect/Analyst Resume New York - Hire IT People (2024)

SUMMARY

• 15+ years of extensive experience in developing software applications, data warehouse and big data solutions as software and information architect as well as project manager with most up to date technologies.
• 4+ years of online e - commerce and retail, 4+ years in digital cable, media, advertising, 5+ years in mobile telecom and 1+ years’ in healthcare insurance industry experience.
• 6+ years of project leading and people and project management experience.
• 5+ years of experience in Big Data solution in MPP systems especially in Netezza appliance and Teradata Aster.
• 2+ years’ experience in no-sql database in Hadoop platform especially to load data into HDFS and analyze data in HIVE.
• 12+ years of experience of OLTP, data warehouse (star and snowflake schemas) and dimensional modeling in Erwin, ER Studio, SD-PRO, Sybase Power designer, Visio and 3+ years of experience in object oriented design in Visual Paradigm. 5+ years of experience working for data profiling, data governance, data stewards;
• 12+ years of experience in Oracle application development and application DBA. 6+ years of experience in Oracle RAC environment and Parallel Query server.
• 3+ years of experience Microsoft SQL server including Azure cloud solution implementation
• 6+ years in shell, perl scripting, 3+ years of in Informatica for ETL development, 6+ years of experience in report developments.
• 4+ years of experience of PVCS, 2+ years in SVN for document check in version control. 4+ years in Autosys and 2+ years Appworx scheduling tool. 4+ years in JIRA, MANTIS for issue and bug tracking.
• 3+ years of expertise in developing secure Internet and Intranet applications using Struts, Ajax, JSP, Servlet, Jakarta Tomcat, Asp.Net, IIS, VB Script, JavaScript, CSS.

TECHNICAL SKILLS

Environment: s: Windows, UNIX, Linux, Hadoop, Netezza, Aster data, Oracle, MSSQL

Languages: C, C#, Java, Shell, Perl, JavaScript.

Object Oriented Modeling: Rational Rose. Visual Paradigm.

Database: Design, ModelingErwin, ER-Studio, Oracle Designer, Sybase Power Designer, SD-Pro, Toad, PL SQL Developer, VisioVersion ControlPVCS, CVS, SVN

Bug Tracking Tool: JIRA, MANTIS.

Analysis: Confluence, Wiki, Caliber RM.

PROFESSIONAL EXPERIENCE

Confidential, New York

Sr. Data Warehouse Architect/Analyst

Responsibilities:

• Analyze retail sales and digital data in Cloudera Hadoop ecosystem using Apache HIVE and load data into HDFS.
• Object oriented and relational data model design for email marketing.
• ETL design, development using Perl, shell-script in Teradata-Aster.
• Analytic datamart design, development for web logs, coremetrics, and customer digital activity logs.
• Architect, design, and develop cubes in MPP platform with best practices for Business Intelligence solution.
• Object and data architecture design in MPP systems both in Netezza and Teradata-Aster.
• Team lead and project manager for online, retail sales and pricing analytics solution.
• Relational data modeling using ER-Studio, ETL development with Inventory, Online and Retail sales integration for Supplier-Vendor Portal application in Netezza Environment.
• Provide guidance to consider industry standard best practice concepts for analytics.
• Develop Pl/SQL, packages and procedures in Oracle 11G environment,
• Develop custom mapping and workflow using perl and shell script.
• Schedule jobs in Autosys environment.
• Develop in-memory data processing java applications in netezza environment.
• Implement algorithm for online and retail customer behavior analytics and pricing recommendation strategies.
• Database administration of 20 TB data in Netezza and 60 TB in Asterdata environment

Environment: Linux, ER-Studio 7.6, Visio, Oracle 11i RAC,, Aster-Data, Hadoop, Microstrategy, Oracle PL/SQL, Perl, Shell script, Aqua Studio, Aginity, TOAD, SQL Developer, SQL Plus. PVCS, Netezza, Informatica, Visual Paradigm, Autosys.

Confidential, New York

Business Intelligence, Analytics Consultant

Responsibilities:

• Work closely with VP, data scientists and project managers for understanding requirements and provide meaningful design for analytic data mart.
• Design predictive data model algorithm using NLP techniques.
• Design and develop flat entity structure for supporting in-memory data cube for spot-fire analytic tool.
• Develop customer and household metric for analytic reporting.
• Provide guidance to consider industry standard best practice concepts for analytics.
• Object oriented UML, and relational database design using ER-Studio and Visual paradigm.
• Design and develop objects, nzsql, nzplsql, nzload, nzmigrate in Netezza environment.
• Develop Pl/SQL, packages and procedures in Oracle 11G environment,
• Develop mapping and workflow using Informatica 8.6 powercenter.
• Develop in-memory data processing java applications in netezza enviornement.
• Used netezza analytic functions, SQL analytic functions, n-gram, and colocation methods for predictive analytic technique.
• Develop shell script for production implementation.
• Develop effective code using shell script, pl/sql packages, and DBMS scheduler jobs to transfer data from Oracle to Netezza.

Environment: Linux, ER-Studio 7.6, Visio, Oracle 11i RAC, Informatica, Microstrategy, Oracle PL/SQL, Shell script, TOAD, SQL Developer, SQL Plus. PVCS, Netezza, Informatica, Visual Paradigm.

Confidential, New York

Technical Lead Consultant - Data Modeling, Data Architect, ETL, Oracle

Responsibilities:

• Requirement analysis with customers and stakeholders for health insurance and member and provider project implementations.
• Manage day to day ODS development activities includes Java application development, ETL development, Oracle development, Data and web service development.
• Provide strategic directions for consuming payer and clinical data into enterprise reporting (Business Objects) and financial reporting platform.
• Helps defining service oriented architecture for supporting patient engagement and care management portal applications.
• Team Lead and provide technical direction and hands on Oracle development (PL/SQL, packages, procedures, triggers using collections, object type and oracle supplied package) and Informatica ETL development and engaged in managing provider projects and clients.
• Ensure development activities follows SDLC process and maintain required artifacts.
• Provide strategic directions for consuming CDA (Clinical Document Architecture) data.
• Create mapping document and worked with BSA for preparing FRD document.
• Data modeling for Health Information Systems and Operational Data Store using Erwin.
• Design Enterprise Common Object Model using Visual Paradigm.
• Object oriented analysis and design using Visual Paradigm of ESB (Enterprise System Bus) for Care management and Patient Engagement solution.
• Relational data modeling for ODS, Care Engine, Care Team and Active Advise applications using Erwin.
• Resource management and help in budgeting for VP.
• Ensure data model stored required data for data mart and financial reporting.
• Ensure MDM (master data management) and CDC (change data capture) process captures and manage patients and providers entity for different practices, hospitals, carriers (insurance company) and doing appropriate aggregation.
• Ensure ODS stores HIE (Health Information Exchange) data in RDBMS so that possible to maintain and communicate data to external parties with standard C32 V2.5 L3 compliant CCD (Continuity Care Document) documents.

Environment: Linux, ERWIN, Visual Paradigm, Visio, Oracle 11i RAC, Informatica Powercenter 9.1, Oracle PL/SQL, Shell script, Perl, TOAD, SQL Developer, SQL Plus. PVCS, Remedy, Mantis, JBoss, J2EE and J2SE.

Confidential, New York

Lead Data Architect/Oracle, ETL Developer Consultant

Responsibilities:

• Team lead provides direction for data sourcing, data consumption and data transformation.
• Lead data architect designs data architecture and ensures data integrity and data quality.
• Conceptual, logical and physical fimensional data modeling for fact, slowly changing dimensions using star and snowflake schema.
• Data profiling for important attributes for cable and advertisem*nt data.
• Data Analysis and data quality control of setup box data and advertisem*nt and event trigger data.
• Develop Oracle pl/sql package, procedures, and functions for OLTP and OLAP database using oracle collections.
• Use hints for select, insert and parallel query and hash join.
• Design database objects (index, table) with parallel multiple degree and multiple instances for RAC environment.
• Work with Oracle support for unpublished bug fix for oracle error in RAC environment.
• Performance tuning of optimizing oracle sql query for Oracle 11g using TKPROF, trace file, explain plan, rebuilding and analyzing indexes.
• Oracle objects creation using optimized tablespace configuration, PCTUSED, PCTFREE, logging, parallel mode.
• Materialized view creation and maintenance for supporting microstrategy reports.
• Use DBMS Scheduler and Appworx for scheduling jobs.
• In depth experience in Business Analysis product and program management of tribune data for different channels and programs.
• Business system analysis and design of VOD and DVR data consumption and integrate with reporting platform.
• Deploy release notes and scripts into PVCS for version control.
• Provide 2nd level production support. Analyze production problems and escalate with appropriate priorities.
• Optimizing Microstrategy report query, testing and QA of reports.
• Use Informatica 8.6 for data loading from Oracle 11g to Netezza database.
• Develop complex business logic in informatica mapping using different transformations like source qualifier, expression, aggregator, lookup, joiner, router, sorters.
• Create workflow from workflow designer using mapping parameters and variables for mappings.
• Scheduled jobs for informatica workflow.
• Export and import objects from xml file in repository managers in Informatica.
• Design and develop database objects, stored procedure by nzsql in Netezza database.

Environment: Linux, ER-Studio 7.6, Visio, Oracle 11i RAC, Informatica, Microstrategy, Oracle PL/SQL, Shell script, TOAD, SQL Developer, SQL Plus. PVCS, Netezza.

Confidential

Senior Application Engineer

Responsibilities:

• Project plan, timeline communication, test plan.
• Estimate project cost and risk analysis within timeline, budget and quality.
• Conceptual, logical and physical data modeling using Erwin.
• Database schema and object creation from physical models.
• Implemented Type 1, Type2 and Type 4 concepts in physical model for historical record keeping.
• Developed ASN.1 reader by Java API.
• Extracted data from different sources like Oracle, ASN.1 files, XML files and Flat files implemented business logic and loaded into the target Warehouse (Oracle).
• Created RAID Mappings with different transformations including Source Analyzer, Lookup, Filter, Normalizer. Expression, Rank, Aggregator, Stored Procedure, Look up Transformations and more.
• Created macro and mapplets by XML for reusable transformations to use in multiple mappings.
• Developed web interface by using XSLT and XML, CSS, JavaScript, HTML.
• Used JSP/Servlet/ Ajax for web based search engine of configuration and reports.
• Created data cube by RAID for pulling the data for online reporting and analysis.
• Created different revenue control summary reports by Business Objects 6.5, such as; Master/Detail, Cross Tab and Chart (for historical and trend analysis).
• Use of Prompts, filters, conditions, calculations, slice and dice etc.
• Used Stored Procedures to drop/create indexes as well as disable/able constraints before/after loading the tables.
• Implemented Materialized view for persistent data and for faster processing.
• Implemented FTP file loader from MSC by perl script.
• Command line coding using SQL PLUS.
• Implemented awk, sed, grep command in shell scripting.

Environment: HP UNIX, ERWIN 4.1, Visio, JDK1.5, JSP/Servlet/Ajax, CSS, XML/XSLT, Oracle 10g, RAID ETL, Business Objects 6.1, Oracle PL/SQL, Oracle Reports, Shell script, Perl, TOAD, PL/SQL Developer, SQL Plus.

Confidential

Responsibilities:

• Requirement Analysis and convert into meaningful Use case using Rational Rose.
• Logical and Physical data modeling using Erwin 4.1.
• Design of advanced Model structures -- super/subtypes unbalanced hierarchies etc. for different level of summarized data.
• Design and optimization of the transaction and reference data loads into the warehouse.
• Data staging into intermediate platform before transformation.
• Data cleaning according to business requirements.
• Worked in bulk processing data using REF cursors, collections, DBMS packages.
• Performance tuning - analyzing query plans and query tuning, partitioning using shell script.
• Using Optimizer hints.
• Working with SQL loader, Data pump, Exp/Imp, TKPROF, Oracle scheduler, Advanced Queue, Object management.
• Used Stored Procedures to drop/create indexes as well as disable/able constraints before/after loading the tables.
• Implemented Materialized view for persistent data and for faster processing.
• Created reports using the Business Objects Universes, Stored Procedures as the data providers.
• Generate pictorial views in the form of 2D, 3D & Pie Charts from existing Reports & Chart Wizard
• Generated reports for web users using Web Intelligence.
• Involved in Importing/Exporting the Universes to repository to make it available to the users
• Used Slice and Dice, Drill Down, Filters, Master Details, Cross Tab and formulas and developed Hierarchies to support drill down reports
• Used Web Intelligence for web based query and reporting.
• Used XML/XSLT for customized web report
• Scheduled the reports to be emailed to end users daily in PDF and TXT formats from Infoview
• Gathering and analyzing user requirements, and documenting the same as per Software Development Methodology (SDM).
• Fine Tune SQL statements for maximum efficiency using Oracle Explain Plan, SQL trace and TKPROF.
• Dropping indexes before data insertion and creating B-tree and bitmap index after data insertion into Oracle transaction tables.
• Dimension, fact and aggregate processing daily in the off-peak hour especially at night.
• Creating shell script to deploy the oracle package of commission engine calculation into UNIX system.
• Implemented Perl script for file extraction from different source systems.
• Command line coding using SQL plus.

Environment: HP UX, Windows 2003 server, Erwin 4.1, Oracle 9i, Oracle Pl/SQL, Oracle Reports, XML, XSL, Erwin, TOAD, PL/SQL Developer, SQL Plus, Visio, Shell Script, Perl Script.

Confidential

Responsibilities:

• Implemented Star Schemas while designing Universe by identifying Facts and Dimension Tables.
• Use of Designer Module to implement Universe, Linkages between Tables, create prompts and queries, apply Contexts and Alias Tables to remove cyclic dependencies
• Created derived tables in Universe.
• Extensively used Designer to design various universes for different business groups
• Created Classes, Measure Objects, Dimension Objects, Detail Objects and applied Hierarchies based on Business logic.
• Handled Embedded Functions like @Prompt, @Select, @Where in the Designer to handle User requests for report generators.
• Created complex variables, multiple breaks, sorts in the reports
• Aided in setting up Multi-Dimensional Analysis, the Slice/Dice & Drill using the Hierarchies Editor.
• Used Prompts in the reports as well as the Universe to create more interactive reports for the users.

Confidential

Responsibilities:

• Business system gap analysis of TABS billing system with BSCS billing system.
• Configuration management of TABS billing system.
• Develop unix shell script and Oracle PL/SQL for data validation before pre, in and post migration.
• Helps management to take decision regarding data accuracy level at different control point and recommend for necessary changes and upgrades of system during migration.

Confidential

Responsibilities:

• Team lead of mediation, provisioning, international roaming system support.
• Configure mediation, provisioning business rules in TABS.
• Develop billing solution for international roaming billing system.
• Develop SMS application using Logica JAVA API for push pull services and VAS applications.
• 3rd level production support.
• Communicate with vendors for upgrades and changes in billing system.
• In charge of data verification, validation and negotiation with other telecom operators for interconnect.

Confidential

Database Engineer

Responsibilities:

• Conceptual, logical and physical data modeling by SD-PRO.
• ERD by SD-PRO and DFD design by Visio.
• Front end user interface design by Oracle Forms 6i.
• Create form level, block level and item level triggers in different oracle forms.
• Create alert and message according to severity of downtime.
• Creating customized menus for different logs.
• Block processing, interface event, master detail, message handling, navigational, post query, transactional, validation triggers are used in different forms according to business requirements
• Use different library function of oracle forms.
• Create conditional formatting reports by oracle reports.
• Using a data model for complex query design and fitting the data into layout.
• Used parameter form triggers for complex reports.

Confidential

Responsibilities:

• Involving in total Software development life cycle (SDLC) of the project, including Requirements gathering, Functional and Technical Design, Coding, Testing and implementation.
• Conceptual, logical and physical data modeling by SD-PRO.
• Designing user interface using CSS. Client side validation with JavaScript.
• Implementing business logic using Servlet, JSP and Customized Java framework.
• Implementing Java thread for data parsing from OSS file in Linux environment and integrating with Oracle database.
• Implementing Java mail and SMS based application and integrating with the SMSC server using RMI.
• Implementing reports using JSP, XML, XSL, and Oracle Reports.
• Developing stored procedure in MS SQL Server.

Environment: Windows 2000 server, Oracle 8i, Oracle Application Server, Oracle Pl/SQL, JDK1.4, JSP/Servlet, Struts, RMI, JDBC, CSS, JavaScript, Jakarta tomcat 4.1.24, XSL, MS SQL Server, Linux, Oracle forms and reports, SD-PRO, Visio.

Confidential

Lead Oracle Developer & Data Modeler

Responsibilities:

• Conceptual, logical and physical data modeling by SD-PRO.
• Gathering and analyzing user requirements, and documenting in Borland Caliber RM the same as per Software Development Methodology (SDM).
• Converting the raw requirements into meaningful use cases, and documenting them using Rational Rose Enterprise edition and presenting in Visio.
• Use LOV for lookup, created TAB page in Canvas for easy access.
• Use Built-in packages for Canvas, Menu and Chart.
• Created customized menu and wrote triggers for event handling.
• Use form level, block level and item level triggers.
• Use different library function of oracle forms.
• Generating reports by Oracle Report Builder according to customized requirement from client.
• Generating XML by Oracle PL/SQL for viewing the reports in web browser.
• Writing test plans, test cases, and implementing test strategies.
• Create conditional formatting reports by oracle reports.
• Using a data model for complex query design and fitting the data into layout.
• Created alarts and messages for error handling and warning.
• Use parameter form for reports.
• Design the complex layout for matrix report.
• Created tabular, group above, group left, form like and matrix reports.
• Used summary and formula in page and report scope.
• Used different date and time format mask in both forms and reports.
• Used conditional formatting in reports.
• Wrote header and footer information in the report.

Environment: Windows 2000 server, SD-PRO, TOAD, PL/SQL Developer, Oracle 8i,Oracle Form 6i, Oracle Report 6i, Oracle Application Server, Oracle PL/SQL, SQL Loader, XML, XSLT.