SUMMARY

• Over all 9 years of progressive experience in IT, focused primarily on Cloud Computing services like Amazon Web Services, Microsoft Azure. Developed and maintained Oracle technologies like JAVA, J2EE and ETL technologies with Excellent communication and problem - solving skills.
• Extensively worked with Amazon web services in provisioning EC2’s, Load Balancer, Auto Scaling, EBS, setting up VPC, Creating Cloud Watch Alarms, Triggering Lambda functions and other services like Cloud formation, creating IAM roles, setting up S3 policies etc.
• Experienced in Microsoft Azure services in creating virtual machines, functions, creating backups on Bold storage, has hand’s on using Queue Storage for notifications, has experience in monitoring servers using Azure Application insights.
• Performed Project Management activities involving Analyzing information, evaluating end user requirements, and troubleshooting complex information systems.
• Results-driven Business Intelligent professional with significant and progressive experience and expertise throughout the entire Software Development Life Cycle (SDLC).
• Expert in Data Modeling using Star and Snow Flake Schemas using Ralph Kimball and Bill Inmon Methodology, ER Model, De-Normalization, Dimensional Data Modeling, converting Snow-Flake Schema to Star Schema, Dim Hierarchies, Dim Extensions, Physical & Logical Data Modeling.
• Knowledge in ADF Business Components, ADF Faces, task Flow, ADF Web Services, and JSF
• Excellent communication and interpersonal skills.
• Automated web modules using Selenium (automation UI)
• Experienced in tuning Elastic Search for ingest and query performance
• Experience in securing Elastic search and other big data technologies for intelligence community.
• Experienced in making documentation for issues and provided knowledge transfer to other team members to share the work load when we get multiple priority 0 issues at the same time.
• Worked with Monitoring tools like SCOM(AZURE) for internal monitoring.
• Performed regular security monitoring to identify any intrusion like DOS
• Maintain the timely recovery of data lost due to software crash or hardware failure.
• Created users, roles and groups for securing the resources using local operating system authentication.

TECHNICAL SKILLS

Project Methodologies: Agile, Waterfall

Cloud Services: Microsoft AZURE, AWS (EC2, Nginx, Lambda, Cloud FormationCloud Watch, EBS, S3, ELB, VPC, Dynamo DB, RDS, IAM)

J2EE Standards: Java, Servlet, JSP, Java Beans, JDBC, JNDI, JSTL, Java Mail, RMIANT, Struts, Spring, MVC, Hibernate, DHTML, XML Deployment-Descriptors, JSF, JMS, Design patterns, JVM, Java EE 6

Languages: Java, SQL, PL/SQL, UML

Internet Languages: HTML, XML, CSS, JSON(YAML)

Application/Web Servers: Apache Tomcat web server, Web Logic, Web Sphere applicationserver

Testing/Control Tools: Junit, Apache Maven

Scripts/Languages: SQL, PL/SQL, VB, Java, HTML, CSS, XML, C, C++, C#Bash/Shell, Ansible Playbooks.

RDBMS: SQL Server, Oracle, MS Access, MySQL, PostgreSQL

IDE’s & Tools: Eclipse, Net Beans, Subversion, Clear Quest, Maven, Fusion-Jira

Version Controls: Git, SVN, CVS, MKS, Clear Case

Operating Systems: Unix, Linux, windows.

PROFESSIONAL EXPERIENCE

Confidential, Bethesda, MD

DevOps Engineer

Environment: - Windows, Linux, Jasper Soft reports 6.3.1, PostgreSQL 9.6.4, Ec2, Lambda, Cloud Formation, Play Book (Ansible), Cloud watch, SNS, Route 53, Jenkins, Bitbucket, Jira, Confluence, Jasper Server 6.3.0, Nginx 1.10.3, Tomcat 8.5.9, Open AM 13.0.0, OpenIDM, Open DJ, Java 1.8.0, and Ubuntu 16.04

Responsibilities:

• Involved in SDLC Requirements gathering, Analysis, Design, Development and Testing of complex multi-tiered application following AGILE methodology.
• Using Agile methodologies to plan work for every iteration and used Jenkins for CICD.
• Spun up and configured Servers as and when needed.
• Created automated Bash Scripts for auto deployments.
• Created Lambda and used cloud watch rules to trigger the function to stop/start EC2 for every day Server Maintenance to reduce cost.
• Used CLI for handling auto scaling in suspend/resume, as part of daily server maintenance.
• Written a script and created a bucket policy to fetch the files from S3 bucket that automates the ETL process
• Installed and configured entire Production environment setup like, Creating VPC, Auto Scaling Groups, Load Balancer, software installations and setting Alarms.
• Daily Deployments of both UI Code and Reports to SBX, DEV, INT, QA and PROD
• Written Ansible Playbooks for Configuration Management.
• Created Cloud Formation Template for setting up an environment.
• Created IAM Roles and maintained AWS account for things like spot instances and reserved instances.
• Worked on cleaning up the existing environment that includes Removing unnecessary EC2, Identifying the minimum space needed for EC2, and removing unused and unnecessary snapshots and taking care of Elastic IP’s
• Created Documentation for Deployment Plan, Production Environment Setup, Operations and Maintenance Manual and Release Management for final handling to Client for both SSAT and IGCE.
• Performed Technical Review for both IGCE D-Plan and IGCE Production Environment Set-up document
• Created manageable ansible clusters for IGCE environment that deploys all our services.
• Worked on server blocks to host multiple virtual hosts on nginx and worked on HA-Proxy to access database.
• Created Cloud watch for monitoring threshold levels
• Experienced in setting cluster environment for load balancing and high availability of Windows servers.

Confidential, MD

Oracle ADF/Selenium/BI

Environment: - Windows, Oracle JDeveloper 11.1.1.6.0/ 11.1.1.7.0 , OBIEE 11.1.1.9.0/12 c, Selenium, Eclipse Java EE IDE for Web Developers, ETL, section 508, SQL Developer/SQL.

Responsibilities:

• The main goal of this project is to test for the quality of the application, and was a part of DECC
• I have been working on a quality improvement organization team in development
• Worked on the modules like Search Deliverables, Reports repository, QII Management, And
• Deliverable Administration parts of my project.
• Worked with Oracle ADF and the application to make it 508 compliances, such that it will be easy and accessible to the people with disabilities.
• Worked on all the applications using selenium and automated, such that it helps in auto testing the web applications that we created at front end (followed a data driven process).
• We use OBIEE and ETL as separate tools for our data to be pulled in and to make reports.
• Performed ETL operations.
• Worked on all modules, and automated using selenium, such that it helps in auto testing the web applications that we created at front end (followed a data driven process).
• Developed Business Intelligence reports worked on WebLogic console and enterprise manager, and performed ADF deployments.
• Created JRF template to the managed server to deploy and run ADF applications on the server
• Worked on Development, configuration and deployment of ADF applications.
• Worked closely with the oracle support and closed several tickets
• Documented unit testcases and ran the testcases daily at the development end before moving it to uat.

Confidential, MA

Java AWS Developer

Environment: Linux, Java/J2EE, Spring, Hibernate, Web services, Servlets, JavaScript, JSF, JSP, HTML, CSS3, XML, ANT, AJAX, Angular Js, Junit, SOAP, Restful, JDBC, Tomcat, AWS (Amazon Dynamo DB, Amazon SQS, Amazon Cloud Watch, Amazon Lambda)

Responsibilities:

• Involved in various phases of Software Development Life Cycle (SDLC) of the application like Requirement gathering, Design, Analysis and Code development. Developed a prototype of the application and demonstrated to business users to verify the application functionality.
• Involved in developing interface for web pages like user registration, login, registered access control for users depending on logins using AngularJS, HTML and Java Script.
• Involved in using Active Directory (AD) for managing access to key business applications and integrated single sign-on.
• Involved in the integration of spring for implementing Dependency Injection.
• Used No SQL database Amazon Dynamo DB to store data of reporting Application.
• Efficiently handled periodic exporting of SQL data into Elastic search.
• Managed and designed integrated build pipelines using continuous integration workflows such as Jira, Git, Jenkins, Docker.
• Performed server buildup, cloning of Linux servers.
• Wrote JavaScript validations to validate the fields of the user registration screen and login screen.
• Designed a network of web pages, where the user progresses through an application by selecting links, resulting in the next page being transferred to the user and rendered for their use using REST.
• Created continuous integration builds using Maven and SVN control.
• Developed UI with AJAX, DHTML and JavaScript for more interactive web pages.
• Used Amazon Cloud Watch to monitor AWS services and logs.
• To send bulk of emails to users developed Java API to interact with the Amazon SQS and Amazon SNS.
• Implemented Spring MVC architecture and increased modularity by allowing the separation of cross-cutting concerns using Spring AOP.
• Used Beanstalk Elastic Load Balancing for deploying web application.
• Used AWS framework for creating background and multistep workflows.
• Used JMS to send/receive asynchronous data to other applications.

Confidential, NY

Java Developer

Environment: - Java, Enterprise Java Beans, XML, SOAP, ANT Script, UNIX Scripting, WebLogic, Oracle 11g, Eclipse, DB2 Visualizer, agile Methodology, Object Oriented Application Development, Singleton, Spring, Session, DAO, Factory, Windows, SQL server.

Responsibilities:

• I was actively involved during the requirement gathering phase for this developing the platform. During this phase, I was required to understand business requirement from the onsite coordinator, map them to the technology and processes and discuss the functional and technical solution.
• Design and deployment of Webservices using JAVA and Weblogic.
• Involved in writing and reviewing Ant Scripts for building, testing the Application.
• Deployment of application/ Support to UAT, production environments, resolving issues with other deployment and testing groups.
• I was also involved in writing unit test script using JUNIT as a part of Unit Testing of the system and Providing the UAT support to the client.
• Designing and developing stubs for performance testing where backend system was not available.
• Effort estimation & Development planning.
• Coding and hands-on development in Java
• Understand the concepts of agile methodology and implementing the same.
• Doing group review and peer review of the code to identify tuning opportunities/improvements.
• Developed SQL stored procedures and prepared statements for updating and accessing data from database.
• Have created Security setup.

Confidential, NYC

Data Warehouse Developer/OBIEE/ODI

Environment: - Linux, ODI 11.1.1.5.0 , OBIEE 11.1.1.5/11.1.1.6.6 , Apex, ODI 11.1.1.7.0 , SQL.

Responsibilities:

• Have assisted Confidential BI Team through different projects.
• Worked on multi-currency project to estimate the work effort required and built reports.
• Recognize areas of opportunity and make recommendations for improvement.
• Participated in the identification of key performance indicators and methods for data warehouse to assist with operational and strategic planning.
• Analyzing the source systems data and data models.
• Configured and tuned the ELT infrastructure to support the data warehouse solution.
• Worked in development of ETL process utilizing Oracle Data Integrator.
• Hands-on development using Oracle ETL tools and establish standard templates
• Dealt with Apex and created some custom forms, to see how it helps our client to meet their requirements.
• Hands on proficiency in workflow process development for managing load dependencies and automation.
• Attended meetings at RBC to provide solutions to their existing dashboards, and offered solutions.
• Documented the upgrades required for the clients from OBIEE 11.1.1.5.5 & OBIEE 11.1.1.6.6 - latest.
• Created MV (materialized views) and aggregates to maximize performance.
• Created Reports & Dashboards, using features like Pivot, charts and view selector.
• Created user level security for dashboards based on Business Requirement.
• Created logical columns, dimensional hierarchy, calculated measures, and aggregate mappings in the BMM layer as per the business requirements.
• Used various cache management techniques for performance tuning including configuring, defining cache parameters, cache persistence time, cache seeding and purging, and event polling.
• Worked with reports in BI Publisher (XML Publisher) with OBIEE to build reports in word, excel and doc format.
• Participating in research on Flex cube and Big Data.
• I have been working on various portions of this project (Data Modeler, ETL architect, and as an ELT Developer). Created a data model for the business requirement as per the client’s requirement.
• Gathered the source columns, source information to accumulate them in ELT process.
• Created table structures, loaded them with the sample data so as to ensure the data gathered is correct for processing.
• Created interfaces to store this at data warehouse.
• We have used the surrogate keys in our tables, rather than using a natural/primary key from the source systems. This is used to ensure the accuracy and for the longevity of the system that is built. Because if in future the source data is going to be changed then, having its primary key at the data warehouse creates a problem for the data flow, so I have used the surrogate keys at data warehouse.
• And, I have followed the Kimball approach to build my data warehouse, and made some suggestions for the nulls to be displayed at target.
• The most important task for any project is its scope and having the required information to build the system. So, I have worked completely to build this system in both scope and in gathering the requirements. And the result is a good warehouse model with the ETL strategy.
• We also used Golden Gate in our project to get real near time data in to our staging and then from staging, where staging will have the same structure as the source system.
• Worked with Project Manager and Data Architect. Assisted Architect in designing source data analysis, modifying the requirement documents (ETL Data Dictionary), creating source to target mappings.
• Designed the ETL flow trace Intermodal.
• Developed interfaces to load the data from Oracle, SQL Server through GG and then to stage and from stage to ADS.
• Created procedures, to meet the client requirement.
• Developed interfaces for loading the lookup and transactional data.
• Performance tuned the ODI interfaces.
• Performed testing. Created various test cases to ensure the results are as intended.

Confidential, Philadelphia, PA

Informatica Developer

Environment: Informatica power center 9.0.1, OBIEE 11.1.1.5g, Visio, Erwin, Oracle EBS, Finance Module, Oracle 11g, DAC, and Linux, ODI.

Responsibilities:

• Interacted with business analysts and gathered requirements and translated business requirements into technical specifications (MD070).
• Designed end-to-end ETL process from source systems to Staging, from staging to Target.
• Implemented Incremental load for Dimension and Fact tables.
• Used Stored Procedures for data transformation purpose.
• Created Tasks, Workflows, and Sessions to move the data using Workflow Manager.
• Prepared ETL mapping Documents for every mapping and Data Migration document for smooth transfer of project from development to testing environment and then to production environment.
• Tuned mappings using Power Center-Designer and used different logic to provide maximum efficiency and performance.
• Extensively used Source Qualifier Transformation to filter data at Source level rather than at Transformation level.
• Created different transformations such as Source Qualifier, Joiner, Expression, Aggregator, Rank, Lookups, Filters, Stored Procedures, Update Strategy and Sequence Generator.
• Created and monitored workflows and task using Informatica Power Center Workflow Manager.
• Dealt with many functional resources to gather requirements. built the MD070 (Technical Documentation & ETL Documents)
• And Built Data Models for the business
• Prepared ETL Design Documentations for the developers to build the tables at ETL specified the structure and mappings to the targets (created the target tables, so that they are ready to use at RPD)
• Created the subject area with GL Account, Segment, Customer, Lead Project, Invoice, Processed Invoices, Invoice Processing History, Summary, and Time.
• I have been working with another project called Chassis currency, where worked on ODI and created various KMs that are used for with the sources/targets.
• Worked with customized knowledge modules
• Created the mapping and data dictionary for the ELT, and created the Targets tables and some customized tables.
• Created many interfaces to achieve the business requirement.
• And I handled total 3 projects out of which one is Informatica and the other’s is ODI.
• Finally Developed reports.
• I have been included from start to end cycle for this project and worked with 3 developers being an architect.

Confidential

PL/SQL Developer

Environment: - PL/SQL, Oracle9i, SQL Developer, SQL plus, TOAD, Oracle Forms/Reports 6iWindows 2000, UNIX.

Responsibilities:

• Worked with cross-functional teams studying the impact analysis and was involved in converting the business requirements into technical design document.
• Developed Stored Procedures, packages, Functions using PL/SQL to implement day to day modified business rules into the current system.
• Involved in Software Requirement Specification and Technical Design. Development, Testing, Implementation and Training with web Development techniques.
• Processed new accounts for customers and assisted existing customers with account maintenance.
• The front end consists of Oracle Web forms that allow the users to login and enter input the input processing information such as filename, date, month, and year and submit the form for the load process.
• Developed GUI standards for fonts, text box, buttons etc. using visual attributes and property classes through Oracle Forms.
• Worked with SQL Developer 2000 Reports Designer to develop reports for validating data in System tables.
• Adherence to reporting procedures to provide information to Corporate Office from all regions.
• Collecting report requirements from the cross-functional teams and providing the decision
• Supporting reports, performing analysis of the reports and presenting to the managerial staff.
• Implemented triggers to enhance functionality, supplement validation, and default transaction Processing.
• Analyzed the previous Interfaces in production, debugged the issues and modified them for better performance.
• Developed PL/SQL stored procedures for source pre-load and target pre-load to verify the existence of tables.