SUMMARY

• 12+ years of experience in Information Technology predominantly in the area of Finance, Telecom, Travel, and Marketing domain.
• Expertise managing MPP database like Confidential and other database like SQL Server and Oracle.
• Strong Technical experience in Data Model, Design, Develeopment, Implementation, Customization, maintainence and production support in ETL migration, Integration and Data Warehousing projects.
• Familiar with Hadoop framework.
• ·6+ Years of Experience in Data Warehouse Architecture and Design implementing data warehouses of various domains and sizes. Responsible for designing the Logical and Physical Data Model, implementing the ETL flows that performs initial and incremental batch loads, performing pre - production test, production monitoring etc. Have exposure to Erwin and Database Modeling.
• 9+ Years of Strong SQL coding experience. Strong experience in Confidential and ETL approaches. Big data analysis and advanced SQL techniques using OLAP functions to do the trend analysis, call quality analysis, app usage, fuzzy name matching etc.
• 10 years of experience in Confidential development, Load Utilities. Confidential Certified Professional
• Work with vendors to evaluate the ETL and BI analytical tools like Alteryx, Splunk and Thoughtspot and participate in various platform migration activities.
• Implementing Backups and designing backup scripts, media management and retention planning. Working with the business users to understand the metrics or requirements and design optimal BI semantic layer.
• Understanding of Agile and AWS technologies.
• All the projects which I have worked for are Open Source Projects and has been tracked using JIRA.
• Working with the vendor to plan and independently coordinated installations of hardware/ software upgrades, server migrations, BAR establishment/stabilization, capacity management and planning and review the SOWs.
• Mentoring teams to ensure the appropriate use of technology, coordinating projects with off-shore vendors and managing offshore teams.
• Lead Onshore & Offshore service delivery functions to ensure end-to-end ownership of incidents and service requests.
• Excellent written and verbal communication skills including experience in Business meetings, SOW proposals, project presentations, design solution walkthroughs, publishing regular status reports, conducting status meetings, handling/resolving situations like customer facing issues etc.
• Excellent in documentation skills. Have released Technical Design Documents, Design SPECs, Mapping document, E-R model, DDL scripts documents etc. of precise quality.
• Have performed various testing activities like Unit Testing, Integration-System Testing, Regression Testing, User Acceptance Testing and ensured that the code is ideal.

TECHNICAL SKILLS

• RDBMS V2R6,V12,V13,V14,V14.10,V15.10,V16.10,V16.2
• Cloud
• SQL Assistant (Queryman)
• BTEQ
• MULTILOAD
• FASTLOAD
• FASTEXPORT
• TPT
• TSET
• OLELoad
• Confidential Explain
• PMON
• Confidential Manager
• Confidential Viewpoint
• TARA GUI
• Query Grid
• SQL Server, SSIS, SSAS, SQL Server Management Studio
• Oracle 8i/9i, PL/SQL, TOAD
• UNIX Shell scripting
• CA ERWIN
• CA Workload Automation ESP
• Cognos 8.2 (Transformer/Powerplay)
• Microstrategy
• Splunk
• Thoughtspot
• Alteryx
• Perforce
• IBM Synergy
• JIRA
• Windows
• UNIX - MP RAS
• LINUX

PROFESSIONAL EXPERIENCE

Confidential, NJ

Technology Lead/Data Engineer

Responsibilities:

• Collaborate with functional experts and business users to develop architectural requirements to ensure client satisfaction with solution
• Participate in various POC initiatives and work with vendor, architects to develop use cases to evaluate the BI/AI tool like Thoughspot, Splunk
• Identify the process gaps and redesign the existing application to ensure the data integrity and any data related challenges
• Participate and work with engineering teams and end users to drive the various ETL server migration activities for cost saving purposes.
• Develop dimensional data models and SSAS cubes on SQL Server DB
• Design, develop and maintain Data Warehouse using best practices
• Develop and maintain SSIS/ETL packages
• Design and develop Integration (ETL, ELT, Data Governance, MDM) processes using MS SQL Server 2012 SSIS, DQS, MDM.
• Understand the legacy process/system and lead the Confidential migration activities.
• Identify performance issues and recommend resolutions
• Provide production support related to Confidential ETL schedules, tasks using tools like ESPx, Cognos Powerplay and work with other BI/ IT team members and service desk to resolve data refresh issues
• Lead the onshore and offshore team to provide the ETL support.
• Lead the EOL ETL server migration activtites

Confidential, NJ

Data warehouse/ Confidential Architect

Responsibilities:

• Reviews database design and integration of systems, provides backup recovery and makes recommendations regarding enhancements and/or improvements
• Built the warehouse backup and DR solution with Confidential cloud. Work with the vendor and responsible for migration of production database to new Confidential platform saving NPRAC costs for the company.
• Conducts performance tuning of indexes, optimization of storage functionality, and databases in general using various Confidential techniques.
• Manage data migration project to analyze the legacy Cobol ETL process, redesign, cleansing, transformation and testing.
• Evaluate and perform POC using data analytics and mining tools like Alteryx for legacy cobol ETL application migration.
• Work with data scientists and operations to meet current and future data management objectives
• Provides oversight for database & server performance including leadership for SQL performance and tuning
• Develop, test, and integrate code for existing data warehouse development in compliance with firm-wide data management principles and security controls
• Head complex Confidential ETL requirements and design

Confidential, NJ

Data Architect/DBA

Responsibilities:

• Part of Confidential EDW team and design the warehouse solution to understand and get the data from the various source systems as per the reporting needs
• Design and Developed semantic layer views working with the microstrategy reporting team.
• Responsible for designing Confidential backup solution, backup scripts, media management and retention planning.
• Head the DBA activities like Configured Confidential Viewpoint for monitoring production and development systems, Configured various portlets to monitor the system usage, capacity, workload analysis, logging, reporting, performance alerting and analyze the system health.
• Responsible for maintaining the development, QA and production Confidential environments by implementing the maintainece tasks such as PackDisk, CheckTable and ScanDisk using the admin tools.
• Responsible for Database Design taks like Aggregate tables Design, Join Index Design, choose appropriate indexes and partition primary indexes for big tables to define optimal access path by understanding the Confidential mobile source data, call quality, outbound usage and CDR Data.
• Worked with the Data modelers and Maintain the Confidential Data Model
• Generation of DDL utilizing ERwin Data Modeler tool

Confidential, NJ

Confidential DBA

Responsibilities:

• Effectively established the administrative approaches for both the production and development environments.
• Establishment and stabilization of backup and recovery processes (BAR) making the
• Primary contact with Confidential support and has independently managed and worked through multiple problems, coordinating resources and ensuring repair activities had minimal impact on business users of the EDW.
• Effectively leverage the offshore resource to manage the overall administration workload.
• Confidential Manager Utilization to monitor performance, skew analysis, alert design and identify any performance issues, advanced query optimization techniques to reduce query resource utilization and workloads.
• Implemented strategies like partition primary index recommendations and multivalue compression to manage data volumes.
• Identified problem workloads and makes recommendations to the developers and SSIS ETL team for design changes to improve performance.
• Creating Confidential stored procedures, macros, UDF’s, SQL, BTEQ, Fastexport, Multiload DDL scripts, collecting STATS etc
• Performance Tuning, Debugging complex queries and monitoring the application.

Confidential

Associate Technical Consultant

Responsibilities:

• Interacting with Business Analysts to understand the BRD for incorporating email mechanism in the exsisting billing system.
• Involved in Confidential physical database design for new physical email structures and updating the existing fact tables and choose indexes.
• Troubleshooting database performance issues, impact analysis and optimizing SQL.
• Updated UNIX shell scripts to execute and optimize the Confidential SQL, Stored Procedures, BTEQ and MULTILOAD jobs.
• Responsible for the Deployment scripts, production support and release document.

Confidential

Senior Software Engineer

Responsibilities:

• Design, Develop ELT process and create UNIX shell scripts to execute Confidential SQL, Stored Procedures, BTEQ, Fastload, and FastExport jobs for QWEST, CNAM and PREPAID/POSTPAID projects.
• Troubleshooting database performance issues and optimizing SQL queries.
• Coordinating with the Testing team (QA) for issue resolution and reviewing the QA team’s test cases for ETL applications.
• Data Migration from Confidential DW to SQL Server using Fastexport and SSIS.
• Responsible for the Confidential Physical Database Design.
• Responsible for writing the Release notes for the ETL processes before the project release.
• Responsible for writing Users manual for the production team.