SUMMARY:

• Deep Rooted Information Technology experience in various phases of Software development life cycle including System Analysis, Design, Development, Implementation and Support of various applications.
• Experience in software engineering techniques such as modular and iterative Agile, Scrum.
• Experience using CASE Tools consuming UML with Rational Rose, Data modeling using Erwin.
• Experience in writing system specifications, translating user requirements to technical specifications, creating/maintaining/modifying data base design documents with detailed descriptions of logical entities and physical tables.
• Experience in area of Application Development using .NET and JAVA along with Custom hardware specific such as mobile and security devices and biometrics devices.
• Experience in RDBMS and Inter - operating technologies, various Programming Languages, Databases and Software and Communication Standards and Tools.
• Knowledge and usage of programming best Practices and naming conventions within programming, also adherence and maintenance of code repository.
• Deep exposure to change management procedures, compliance consideration and configuration management during product development, testing and production environments.
• Problem solving, troubleshooting, IO&M (Installation, Operations and Maintenance) skills in various operating systems, Database Servers, Web Servers, Application Servers.
• Professional Experience in Client-Server and multi-tier/multi-platform Software Product Development and Exposure to cloud computing environment.
• Experience in rapid prototype application development and presentation to Management.
• Variety of Experience with OLTP and OLAP DB Environments.
• Experience defining data warehouse (star and snow flake schema), ODS (normalized schema), fact table, dimensions and cubes.
• Knowledge of Data Warehousing Concepts and tools (MS-SSIS, Informatica).
• Fast and flexible for learning new technologies and tools from anywhere, anytime.

TECHNICAL SKILLS:

Hardware: PC Compatibles, Intel processors based Servers

Software & Programming: Java core, JS/JSP, Servlet, J2EE, Unix Shell Script, C/C++, MS .NET, ASP, Oracle Forms and Reports XML, HTML, DHTML

Software Engineering: Multi-tier/Multi-Platform Product and Technology Development & Testing, CORBA, TUEXDO & other custom Middleware, Object Oriented designing and CASE and all of these at CMMI Level 3

Operating Systems: All MS Windows Client and Server OS, UNIX (Sun Solaris, HP-UX, LINUX), Macintosh OS

Database & BI Tools: Oracle (SQL, PL/SQL), MS-SQL Server, PL/SQL Developer for Oracle, Toad, Erwin, Rational Rose, Informatica PowerCenter/Power Mart and client tools, Microsoft SSIS, Business Objects

PROFESSIONAL EXPERIENCE:

Confidential

Data Architect

Responsibilities:

• Currently engaged with FDA’s EES (Establishment Evaluation System), FDA’s heart of the compliance records managements system.
• Reviewing Data models and database implementation scripts.
• Assisting troubleshooting on oracle database issues as needed basis.
• Performed major database responsibilities on MARCS and FAERS (FDA Adverse Event Reporting system) Programs along with the role of ETL/Informatica Developer.
• Also assumed responsibility to facilitate data migration and synchronization for FAERS and MARCS programs.
• Involved and dedicated team member in analyzing the data, providing data fixes, data mapping, ETL using Informatica Toolset, SQL & PL/SQL programming during implementation/development and post-production support phases.
• Directly involved in business analysis and technical design sessions with business and technical staff to develop requirements document, and ETL specifications and testing and performance and regression testing specifications.
• Participating in all stage of building ODS (Operational Data Store) and Data warehouse such as source & target evaluation, Data warehouse data model review and definition, reviewing conversion rules, gap analysis and data validation and regression testing activities.
• Good experience in SSIS in applying huge applications and also implemented SSIS transformation server and developed SSIS packages and other SQL data loading routines for ETL purpose.
• Coordinating system integration test and UAT and have process tested in variety of ways addition to unit testing.
• Participating & Conducting Oracle database interface design and code review with application teams to make sure database design and implementation are as per FDA’s enterprise standards.
• Doing coordination with DBA group & Middleware group during deployment.
• Defining and ensured validation and verification process at each stage of release cycle and oversee the configuration management for all development and release activities.
• Ensuring the code repository integrity by auditing periodically.
• Managing change control using PVCS tracker database (custom tailored database).
• Producing and performing ad-hoc ETL and data reports upon stakeholders’ request.
• Creating packages, triggers, stored procedures, cursors, tables, indexes and scripts and other database objects in Oracle PL/SQL and Informatica.
• Acting as Local SME to the development group and handles complex technical challenges and database related queries and resolutions.
• Doing Unix Shell Scripting, PL/SQL Development, and Testing and Production environment support under Windows and UNIX operating systems.
• Working on Various Data Sources such as XML Files (E2B (M), E2B (R), HL7) Oracle, MS-SQL, FLAT Files and Semi Structured and Un-Structured Data sources.
• Reverse engineering activities as need basis.
• Performing Informatica Administration on Console, including Repository Backup- Restore Procedures, Creating Users, Folders and Permissions on PowerCenter Server, but not limited to applying patches and upgrades to clients.
• Developing scripts and procedures (in SQL and Unix Shell) for validation and cleanup.
• Documenting Data Mapping/Migration Documentation and Validation Portion of migration activities.
• Analyzing, modifying, writing and maintaining scripts as necessary for Oracle Database and/or Solaris, UNIX.
• Defining and improving programming guidelines and standards among team members and co-ordinate knowledge-share between team members.
• Supporting users of Application, database, ODS (operational Data Store) and data warehouse via helpdesk, for their problems related fixes as and when required.

Sr. Solution Architect

Responsibilities:

• Worked on APS Data Warehouse aimed for strategic reporting and analysis services for the Research Group at J&J and Group of Companies.
• Interacted with evaluator to demonstrate the value to the business.
• Wrote Requirements Specifications, Functional and Technical Specifications for APS Activities.
• Source and Meta-Data identification and primary analysis according to requirements.
• Defined the Flexible and Unified Dimensional Data Model for integrating different sources within the same META DATA Definition.
• Ensured ODS Logical Model aligns with the Logical Model, updating Logical Model as required and reviewed ODS Physical Model for conformance to standards.
• Determined system Model View Control Model and Developed Class Diagrams and Method Specifications and Data Flow Diagrams from Source to Transformations to Targets.
• Used ETL (SSIS) to develop jobs for extracting, cleansing, transforming and loading data into data warehouse.
• Conducted and participated in reviewing the Informatica ETL mappings, Data Lineage and Control Models to ensure business rules and policies are reflected to satisfy the business requirements.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Created databases and schema objects including tables, indexes and applied constraints, connected various applications to the database and written triggers, functions and stored procedures.
• Developed the Multi-layered (Index-Aggregate-Source-Report) Web Service Application to provide convenient reporting facility for business users with drill down and export import features with customizable User Management and Permissions.
• Implemented SSIS transformation server and developed SSIS packages and other SQL data loading routines for ETL purpose.
• Automated validation procedure for loaded data into ODS and Data warehouse.
• Prepared SQL indexes and cache tables for high performance web querying consumer services.
• Provided extended consultancy services to business users to identify use cases and drill down methodologies and hidden pattern research by advanced segmentation and frequency generation.

Sr. Database Application Developer

Responsibilities:

• Documented Requirements, Functional and Technical Specification documents for changes and enhancements to Product Inview. (Data Warehouse for Pharmaceutical client).
• Performed Data Modeling as necessary after designing CORE Architecture using ERWIN.
• Worked with heterogeneous sources such as: FLAT FILE and IMS, NDC, WKH (Pharmaceutical Data Vendor), MS SQL, DB@ and FLAT Files.
• Wrote Linux Shell Scripts using bash shell for data cleansing and sorting before lading into Data Marts.
• Improvised frequency of loading cycle to optimum level and reduced the load times with keeping highest standards data quality.
• Automated PRE-LOAD Quality Checking routines and Error Reporting procedures for FLAT FILES.
• Used Informatica administration utilizes for monitoring and managing workflows and other Informatica PowerCenter server related trouble shootings.
• Performed development, unit testing and integration testing, regression testing of Mappings, Workflows and Worklets in Informatica PowerCenter.
• Worked as DBA for Maintenance of OLTP Databases installed on Red-hat Linux and Windows 2000 advanced Server platform that includes Databases such as MS-SQL Server, ORACLE and MySQL Databases.
• Wrote Pre-Post Shell Scripts and SQL Scripts to perform clean-up operations.
• Also Mapped the Stages for exported FLAT Files from staging server to check Integrity of De-Identified sequenced Data for Pre-Load Quality Assurance Procedures.
• Migrated the mapping to the testing and production departments and introduced the concepts of Informatica Velocity methodology for Data warehouse development.
• Established and tracked Change Control System for change requests and enhancements based on Velocity methodology.
• Involved with Business Object Reporting Team for Enhancing BO Universe Meta Data Definition for Report Performance Improvements.
• Knowledge and working experience of Security Compliance Auditing and HIPAA Compliance Laws and Privacy Practice.

Sr. ETL Architect

Responsibilities:

• Designed and developed Core Architecture of INVIEW Data Warehouse for strategic reporting purposes.
• Analyzed various Source Database Systems and their documentation for Business Information.
• Worked on interpreting Business Level design to Technical Level ETL design.
• Designed entities, attributes and relationships.
• Created Data Flow Diagrams and Maintain repository of related documentation.
• Conducted and participated in reviewing the Informatica ETL mappings, Data Lineage and Control Models to ensure business rules and policies are reflected to satisfy the business requirements.
• Created a database using the physical data model developed from the Source-To-Target mapping, Data Lineage and Control Analysis information.
• Worked with Business Objects (BO) Team to define universe requirements and basic report Meta Data Definition.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Developed different use cases for database interactions and report generation purposes.
• End-to-End ETL development of the INVIEW including EXTRACT, TRANSFORMATION, LOAD, but not limited to Data Cleansing, and monitoring ETL jobs (at production), and ownership of On-Going Change Request and Enhancements.
• Involved in query performance tuning. Used Explain Plan, Hints, Direct and Parallel Loads and Unloads.
• Developed and maintained Data warehouse metadata and related naming standards.
• Worked on Informatica Power Center tools - Source Analyzer, Warehouse designer, Mapping & Mapplet Designer and Transformation Developer, Workflow Manager & Workflow Monitor.
• Good experience in implementing performance and regression testing.
• Created mappings and scripts involved in Post Load Validation and Business Rules Validations.
• Used shell scripts for automating the execution of database Jobs and Backup of Repository.

Software Analyst

Responsibilities:

• Involved innovative phases of dATEC Technology development Life Cycle (Idea and brainstorming, Pilot Proof Concept, More Stable Prototype design, development in different perspectives, testing and deployment and support etc…).
• Gone through lots of Drawing board and Paperbacked Design idea and Patent Documentation.
• Defined Class Diagrams, MVC models in UML, Relational database schema design in Erwin, forward/reverse engineering Diagrams and other Data flow diagrams and brainstormed processing diagrams developed during UML development phase.
• Conducted and participated in reviewing the Informatica ETL mappings, Data Lineage and Control Models to ensure business rules and policies are reflected to satisfy the business requirements.
• Developed Java Servlets and JSP based Web-Services to be used on dATEC Platform.
• Experience using JSTL under JSP to integrate XML and SQL Technologies.
• Developed Java Beans Components for fingerprint scanning security device.
• Used Apache and Tomcat for dATEC on Macintosh and Other Non-Windows Platform.
• Developed .NET and Java libraries for Proprietary XML format and created DTDs and XSDs.
• Used Borland JBuilder for Developing for Java Servlets and JSP Web Development.
• Developed Java Beans (EJB) for Provisioning System using Java Persistence API.
• Developed .NET Libraries to facilitate universal Database Compatibility to XML files.
• Created Proprietary Compression/Decompression and Encryption/Decryption libraries and in Java to manage strings interfacing with various databases and layered within Distributed Computing Environment.
• Also created dATEC SDK, to make JAVA Web Services libraries reusable within Development Team and for commercial SaaS (Software as a Service) providers.
• Worked as DBA for Maintenance of OLTP Databases installed on Red-hat Linux and Windows 2000 advanced Server platform that includes Databases such as MS-SQL Server, ORACLE and MySQL Databases.

Software Development

Responsibilities:

• Worked on DOTSOFT (Billing and Revenue Records Management System Used by BSNL Government Telecommunication Company)
• Participated in application migration and transformation of DOTSOFT to new Web-based billing system, while doing so, applied SOPs upgrades, interface upgrades, performed data migration activities and end user training activates. Also worked on variety of telecom billing interface resided in telecom switches and exchanges.
• Prepared various feed streams for revenue records distribution among MIS and Operational Systems.
• Prepared and executed targeted ETL routines to develop synchronization functionality between old and new systems. Involved and applied variety of data formats and conversion rules using Oracle PL/SQL.
• Lead team of 3 software engineers for systems migration and performed UAT after successful implementation.
• Conducted and participated in reviewing the Informatica ETL mappings, Data Lineage and Control Models to ensure business rules and policies are reflected to satisfy the business requirements.
• Maintained legacy and modern system side by side for various location for auditing purpose.
• Worked with various middleware technologies like CORBA and TUEXDO as well as XML technologies and variety of workflow and data synchronization technologies.