SUMMARY:

• 10 + years of industry experience in various IT platforms
• Multiple years of experience in managing IT projects in multiple domains
• 5+ years of experience in managing web hosting infrastructure
• 5+ years of experience in managing Healthcare projects
• Expertise in providing and designing solutions based on client’s need
• Multiple years of experience in procurement, writing request for proposals & vendor on - boarding
• Multiple years of hand-on relational databases experience (Oracle, SQL server, Netezza etc.)
• Expertise in Data Modeling, Star Schema/Snowflakes schema, Fact and Dimension
• Multiple years of experience in data extraction, transformation and load (ETL) using Informatica PowerCenter
• 8.6/7.1.4/6.1. x (Source Analyzer, Repository Manager, Data Warehousing Designer, Mapping Designer, Mapplet Transformation)
• Experienced in testing, debugging, validation and performance tuning
• Sound knowledge of healthcare, government sector, hospitality & tourism and telecom
• Excellent communication and interpersonal skills, ability to learn quickly, good analytical reasoning and high adaptability to new technologies and tools

TECHNICAL SKILLS:

DBMS/Data warehousing: Oracle 11g/10g/Oracle 9i/8i, Informatica 6.xx/7.1.4/8.6, Informatica PowerConnect for Netezza 8.1.1.x, Netezza 4.0.2, MS SQL Server, MS Access-VBA, SQL*Plus, CA Erwin, COGNOS, MS SSIS

Hosting: Apache Http, Private cloud, Firewall management, Load Balancing, SLA write-up/negotiation, Domain Services Management, SSL Cert Management, Invoice Mgmt., Vendor Procurement, Software procurement, License Management

Data Mining: Weka 3.5, C4.5, CRISP-DM, MS Excel

Languages: PL/SQL, Core Java 1.5, C, C++

Web Tools: HTML, DHTML, XML

Tools: Oracle SQL Developer, Toad, SoapUI, Winsql, SQL* Loader, Oracle Import/Export, Query Analyzer, Crystal Report 9, WinSCP, MS Visio, MS Project, Matlab, MS Excel, Load Runner, Quality Center, Putty, Google Analytics, Access Log reporting, IBM Initiate, EMC xPression, Oracle OPA, Oracle BPEL

Defect Tracking Tools: JIRA, SharePoint, IBM Rational ClearQuest, Heat 7.0, Unicenter

Operating Systems: Microsoft 8/7/XP/2003/NT, Unix PA-RISC, Linux 4.0, Sun Solaris

Version Control: SVN, MS Visual SourceSafe, IBM Rational ClearCase, PVCS Tracker

PROFESSIONAL EXPERIENCE:

Database Modeler/ Infrastructure Manager & Database Engineer

Confidential, Ellicott City, MD

Responsibilities:

• Documented existing hosting environment and prepared plan for data migration
• Created new Oracle 10g database and migrated data from SQL Server database
• Wrote Request for Proposal(RFP) for new hosting vendor procurement, evaluated responses and awarded project
• Architected and implemented a plan with vendor to upgrade existing hosting environment to meet growing application needs
• Performed data analysis, data cleanup and improved data model based on application needs
• Provided production support, Code deployment, environment monitoring and database administration
• Identified & procured Saas(Software as a Service) vendor based on thorough POC results
• Developed project plan, gathered requirements, created Swimlanes and designed multiple in-house projects based on new legislations
• Maintained health plan benefits in Database to provide easy to read benefit details in award winning Health Connector website
• Actively involved with other enterprise architects in designing new ACA(ObamaCare) website hosting architecture and enterprise architecture
• With the approval and understanding of legal team ; negotiated and developed hosting SLAs with hosting vendor
• Actively participated in Architecture review board to come up with major enterprise architectural decisions
• Actively participated in HIX(Health Information exchange) data model design
• Actively participated in HIX system design sessions
• Heavily involved in writing complex SQL and PL/SQL for temporary reporting needs
• Actively involved in reviewing system design, technical requirements and governance standards
• Well-versed in web services and XML based communication
• Good knowledge of Apache http middleware configuration, F5 BigIP load balancer configuration, firewall configuration and iRules configuration
• Expert in SSL cert procurement and management
• Expert in procuring domains from domain providers and domain management
• Worked on EMC Captiva product for scanning and indexing
• Actively involved in testing & verification of new products
• Moderate knowledge of Unix script, Crontab and vi editor
• Moderate knowledge of Oracle OPA, Oracle BPEL, Oracle data vault, IBM Initiate MDM, EMC xPression

Environment: Oracle 10g/11g, SQL server, MS access, Oracle SQL Developer,, Apache Http server, Jboss 5.0, Vignette 8.1, Java 6, Unix, Oracle Middleware Fusion Stack, Erwin Data modeler 9, Red Hat Linux, Private Cloud

Sr. ETL Developer/Netezza Specialist

Confidential, Ellicott City, MD

Responsibilities:

• Identified components for POC to migrate Oracle 10g environment to Netezza warehouse
• Converted/Migrated Oracle 10g Stored Procedure/Packages into Netezza NZSQL
• Distributed tables based on the Netezza’s Distributing Key
• Automated Netezza jobs using Linux/UNIX scripts
• Developed and fine-tuned Oracle Materialized views to support current environment
• Saved 50% of the load time by implementing Parallel Materialized view & Parallel Indexes
• Created Design Document for new load process
• Developed Prototypes to choose between Sql loader, Export/Import and Informatica
• Used Oracle SQL Loader utility to load Data into oracle from XML & flat file source
• Upgraded and migrated Informatica PowerCenter 7.1.4 environment to 8.6 Version
• Administered Informatica 8.6 user privileges, folder handling, backups and repository tuning
• Created Dev, Test, UAT and Production environment in Informatica folder to
• Scheduled jobs through Informatica Workflow Scheduler and UNIX shell scripts
• Selected important data types to be used in Netezza environment based on Zone maps
• Created Netezza database, users, base table and views following proper distribution key structure
• Created reusable Mapplets, transformations and mappings in Informatica
• Tuned complex queries to achieve faster data loads in Netezza data warehouse
• Fine-tuned slow Informatica mapping based on session log information and performance statistics
• Performed tuning of Netezza queries for quick reporting purpose
• Monitored NPS database for regular tuning & generated statistics
• Documented Netezza POC with results, recommendations, issues, effort estimation and different solutions
• Reversed engineered data model by checking each and every load process from staging to reporting layer
• Documented the current Data model which was in Star Schema with different Data marts
• Documented testing, migration, upgrade process and other reference document

Environment: Informatica PowerCenter 7.1.4/8.6, Oracle 10g, Netezza 4.0.2, Linux Red Hat 4.0, UNIX PA-RISC

Sr. ETL Developer/Netezza Specialist

Confidential, Edison, NJ

Responsibilities:

• Documented /Reverse Engineered data model
• Identified components involved in the migration from MS SQL server environment to Netezza warehouse
• Developed Project specification and Design plan/documentation
• Worked with project managers to design strategy and project plan to implement the migration
• Worked on different key technical difficulties effecting the project plan like Sequence generation/stored
• procedure/reporting table and environment upgrades
• Involved in the distribution of the work to different team members and troubleshooting their problems
• Upgraded and migrated Informatica 6.1.4 environment to 7.1.4 Version and eventually 8.1.1
• Administered Informatica user privileges, folder handling, backups and repository tuning
• Extracted and transformed data from oracle environment as the source into Dimensional warehouse model in
• Netezza database as the target
• Documented all mapping, workflow (metadata) information using repository OPB tables
• Built Netezza environment in accordance with Informatica while using PowerConnect for Netezza
• Selected important data types to be used in Netezza environment based on Zone maps
• Created Netezza database, users, base table and views following proper distribution key structure
• Re-imported source, target and lookup to bring changes for Netezza migration
• Created Mappings for Initial load from MS SQL server to Netezza while performing data cleansing
• Converted SQL Server DTS packages to Informatica mapping to be used with Netezza
• Worked with Memory cache for the better throughput of sessions containing Rank, Lookup, Joiner, Sorter and Aggregator transformations
• Created reusable Mapplets, transformations and mappings
• Tuned complex mappings to achieve faster data loads to the data warehouse
• Created a Migration strategy to migrate from Dev to QA/UAT/Production environment
• Fine-tuned transformation, mapping, sessions and SQL queries
• Scheduled workflow using Linux Shell scripts
• Performed tuning of Netezza queries for quick reporting purpose
• Developed Informatica ETL test plans and Netezza stress testing scripts
• Administered NPS database for regular tuning, generating statistics, Reclaiming space, re-indexing catalog, running diagnostic scripts and taking regular backups
• Involved in NZ-Restore limitation workaround
• Involved in training of new employees and other platform staff
• Documented testing, migration, upgrade process and other future reference documents

Environment: Informatica PowerCenter 8.1.1/7.1.4 , Oracle 9i, Netezza 2.5,4.0.2, Linux Red Hat 4.0, MS SQL Server 2005, Windows 2003 EE

Technical Support Specialist

Confidential

Responsibilities:

• Designing Database tables, views, synonyms and all schema objects in Oracle 9i
• Created Stored Procedure, Functions and Triggers as per the business requirements
• Used SQL * Loader for bulk loading
• Monitored Oracle 9i database in Production environment
• Used Oracle partitioning to improve degraded performance
• Processed telecom CDR(call detail records) to reproduce issues
• Analyzed the queries used in the application and performance tuning
• Configured and maintained sandbox to mimic production environment
• Created database backup shell scripts, maintained user privileges, and created new user accounts
• Created test plan and test cases
• Configured Testing environment and executed Test cases
• Regression Testing and Performance Testing
• Wrote IA(impact analysis) to share with customer before fixing major issues
• Worked with UI(visual basic) team to explain customer requirements
• Providing maintenance and support
• Deployed code through different environment
• Created release notes and version history
• Used Microsoft Visual SourceSafe (MVSS) to maintain version control
• Used ticketing system (HEAT from Frontage) to manage issues
• Interacted with customer on daily issues and developments
• Created user defined reports using Crystal reports

Environment: Oracle 9i, Flat file, SQL* Loader, UNIX, Crystal reports, Windows 2000

System Engineer/Database Engineer

Confidential

Responsibilities:

• Installation, cable laying and setting up of ticket office machines
• Installation of Cisco routers
• Installation and configuration of electronic gates(AFC System)
• Assisted in setting up and installing Oracle 9i
• Assisted in database creation, configuring tnsnames, listener, sqlnet files
• Assisted in creation of table spaces, tables, and indexes
• Created and Monitored daily batch to extract data from OLTP to OLAP for reporting
• Took help of off-shore development team to fix AFC data collection issues
• Reported back to development center for further modification
• Tested AFC application patches
• Monitored all maintenance and support based services(Hardware or software)
• Monitored logs and trace files for analysis
• Created adhoc reports using crystal reports

Environment: Windows 2000, Oracle 9i, Crystal Reports