SUMMARY:

• Information Technology Engineer and An Oracle 11g SQL Certified, Oracle 11g PLSQL Certified, Sun Certified Java Developer.
• Comprehensive skills & experience in PL/SQL (Stored Procedures, Functions, Packages, Triggers), SQL*PLUS, TOAD, SQL* Loader, DB Artisan, SQL ADVANTAGE, Java 1.4/1.6, OOPS, Servlets, JSP, ANT, JBuilder, Eclipse IDE, Tomcat Server, Autosys, ERWIN, Business Objects reports, Universe concepts. Versioning system tools like ClearCase, CVS, Perforce, Git bash and extensions Versioning Tool, Jenkins, Redshift, Aqua Data Studio, Data Warehousing solution using Oracle PLSQL and Microstrategy reporting tool. Experience with Operating Systems including UNIX, Solaris Windows NT/2000/ XP/ 7.
• Over 14 years of extensive IT experience in all aspects of Systems, Business Analysis and complete project Life Cycle including data modeling, Data warehousing, understanding data dictionary, gathering requirements, Information flow , Analysis, Business Intelligence tools such as Business Objects, Microstrategy 10.2/10.4 ,Application Support, Application Deployment, effective Client interaction, Estimation, Design, Development, Implementation, Testing and Functional documentations.
• Experience on executing project in agile fashion in multiple Capital Market, Operational, Risk domain applications such as RCSA, Risk Vision, TFR, Supplier Risk, Business Continuity, Information Security and magazine domain . Expertise in workflow or ordering applications.
• Strong knowledge of data warehouse concepts, design techniques such as Star, Snow Flake schemas, multi - dimensional data model analysis using OLAP, Physical and Logical data modeling.
• Expertise in implementing and maintaining Dashboards, Documents and Reports on the web and on Developer.
• Expertise in Extraction and migration of web and canned reports from business objects to Microstrategy 10.2/10.4. Trained business users and end users on Microstrategy tool including generation of reports and dashboards on Web. Trained team on Microstrategy Web and Developer on various dashboards, visualizations, and documents.
• Experience in development of ETL process using PLSQL in order to stage raw data in warehouse and in development of different data marts such as fulfillment, Revenue etc. Also, possess expertise in QA Testing cycle planning and execution, UAT Testing cycle planning and execution, Regression systems testing, Integration testing.
• Accomplished Performance Monitoring, Tuning in MicroStrategy reporting environment. Involved at all stages of the data warehousing project, setting up the schema and architecture, developing reports, security and deploying in an agile environment.
• Implemented Analytical-level SQL, such as rank, dense rank, windowing functions and OLAP concepts.
• Expertise in implementing Agile/Scrum/Sprint methodology in project Development/estimation/client feedback, giving project release in incremental fashion instead of waterfall model.
• A Project Leader, Scrum owner, onsite coordinator
• Sun Certified Java Developer. Implemented Utilities for migration of legacy applications using Core JAVA API, Reflection API. Also, Developed components using OOPS (Object Oriented concepts) such as overloading, overriding, Multithreading.
• Experience with large client and vendor managed projects. Experience in scheduling and monitoring autosys jobs for functional analysis.
• Knowledge of Programming in Python, Big Data technologies.
• An effective communicator, team player with analytical, problem solving & organizational abilities. Possess a flexible & detail oriented attitude.

PROFESSIONAL EXPERIENCE:

Confidential, Stamford, CT

Senior System Analyst

Technology: MicroStrategy 10.2/10.4, Oracle 11g/10 g, Data Warehousing solution

Responsibilities:

• Responsible for implementing and leading data warehousing solution in support of Revenue, Fulfillment, client invocing, accounting, audit of core magazine and club line of business.
• Experience in ETL and data mart development using PL-SQL/SQL and development of reports in Microstrategy 10.2/10.4 reporting tool.
• Experience in performance tuning of procedures and long running reports and proposing solutions
• Expertise in requirement gathering, documenting functional specification, analyzing raw data, drawing conclusions, estimation, development, unit testing, deployment, UAT support, code review and development of historical correction scripts in PLSQL/Unix Shell script.
• Design and build MicroStrategy project, schema objects, application objects, reports, dashboards and documents
• Propose solutions by understanding requirements and by using strategies such as object prompts, filters, hierarchies, transformation in Microstrategy 10.2/10.4
• Experience in migrating from reporting database/platform/Legacy applications/data centers to newer
• Experience in migrating existing reports from Business Objects to Microstrategy 10.2/10.4
• Worked in an agile environment of 3 to 4 week sprints
• Trained business users on functionality of reports and dashboards and supported Onsite-Offshore Model
• Expertise in creating user stories with acceptance criteria, tracking progress by creating task in Rally
• Experience in Git bash and Git Extensions tool for code checkin-checkout, merge with master and resolving conflicts.
• Responsible for data validation, data cleansing, data integration of reporting datasets
• Experience in deployment of code between different environments using Jenkins
• Experience in monitoring, scheduling jobs in Control-M
• Experience in debugging production issues related to Reporting and Audit
• Expertise in integration testing with People soft for generating Invoices
• Responsible for interaction from leads of transactional systems in support and implementing of reporting requirements and enhancements
• Develop impactful reports and dashboards using MicroStrategy Developer and WebDesign layout of reports and determine the best way to present data to end users.
• Document reports clearly and concisely for end-userGenerate and implement MicroStrategy Schema objects and Application objects by creating facts, attributes, hierarchies, reports, filters, metrics and templates using Microstrategy Desktop
• Worked extensively on creating Application Objects like Metrics and Compound metrics, Filters, and Custom Groups for complex reports.
• Created Transformations to use in comparative reports like Sales this year to Sales last year.
• Created reports for sales and marketing with the drill down methodology in all options.

Environment: Oracle 11g, SQL,PL/SQL, Git, F-Secure, Password keeper, Toad, Linux, Business Objects, Microstrategy 10.2/10.4, Rally, Control-M, Yammer, Slack, Skype for Business, Aqua data Studio, Redshift

Confidential, Mamaroneck, New York

Lead Consultant

Responsibilities:

• Responsible for Supplier Risk program/Business Continuity program/Information security program application requirements gathering, interaction with client, (Business stakeholders, technology stakeholders). Also, expertise in development of application and data warehousing in support of user reporting requirement and norms.
• Expertise in analyzing raw database data, drawing conclusions, developing recommendations to users, extracting, analyzing production issues, business impact implications of defects/development via SQL/PLSQL, canned and web reports in business objects reporting tool.
• Expertise in debugging and resolving reporting issues of business objects reports.
• Document functional specification, Work Flow Diagrams, Visio diagram using Rational Rose.
• Implemented methodology (Scrum/Sprint/Agile/Waterfall) in project depending on scope/complexity of requirement and client expectation.
• I worked as Lead Analyst in estimation cycle using traditional/agile estimation models such as T Shirt Size.
• Expertise in SQL, PLSQL and Core Java in order to migrate legacy applications.
• Expertise in performance tuning of complex packages/procedures of PLSQL/SQL
• Propose solutions for complex problems while taking into considering project scope, budget, timelines, internal needs and client needs.
• Experience in defining project scope, objectives, managing solution scope, changes to requirements, conflicts and development of project plans, Reviewing BRD (Business Requirement Document) with client and conducting Agile/scrum/status/Management meetings.
• Responsible for identifying and presenting proposal of automation scope in new/changed requirements. Strong Data modeling (Star/snowflake) and data warehousing (stage raw data and marts).
• Developed a positive and trusting relationship with key business leaders and their teams that are relevant to the specialist's specific area of responsibility
• Responsible for test case planning, test scripts review, peer reviews and execution of QA testing, integration testing, regression testing, UAT (user acceptance testing) support, load testing, black box testing, deployment and post turnover support. Usage of JIRA and HP Quality center.
• Perform oversight of application deployment/implementation.
• I also worked in the capacity of onsite coordinator, leading onsite-offshore model. Also, Worked in client managed projects and also in vendor managed projects
• Strong technical background in database, SQL/PLSQL, Shell, Java, OOPS, DB Objects (inline queries, procedures, cursors, views, triggers) for business logic, data validation, data analysis and SDLC Processes.
• Leading and supporting L1,L2 team and monitoring all autosys jobs.
• Analyzed legacy application migration process from one oracle platform (SYFACT) to another using core Java 1.4

Environment: Java 1.4, Oracle 11g, SQL,PL/SQL, Perforce, Putty, SQL Advantage, DB artisan, Visio, HP Mercury QA, JIRA

Confidential

Senior Developer

Responsibilities:

• Expertise in business analysis, requirements gathering, development, estimation, design and unit testing.
• Experience in development of Use cases, sequence diagrams development supporting low level design in Rational Rose/MS word. Actively involved in all project related quality initiatives and SDLC Processes
• Developed components using OOPS (Object Oriented concepts) such as overloading, overriding, Multithreading
• Actively involved in preparing quality documents and Migrating documents from harmonized PAL to One PAL.
• Developed code as per timelines using core java API ( 1.4/1.6), Reflection API.Analyzed and fixed bugs in procedures, Cursors, Triggers, Functions. Strong data analysis skills. Quality assurance support and management
• Developed utility using shell scripting to read logs for specific information.Enhanced core of the application as per compliance. Expertise in PROD Issue analysis.
• Analyzed, developed validation rules in different regions globally and integrated with existing framework.
• Developed good understanding of ordering application and how an application interacts with interfaces.

Environment: Java 1.4/1.6, XML, SOAP Messages, Java Mail API, Eclipse, Oracle, Shell scripting, SQL, Exceed

Confidential

Senior Developer

Responsibilities:

• Involved in development and enhancement of order entry system whose architecture applies model-view-controller design pattern.
• Involved in incorporating design patterns such as service locator, session façade, and singleton.
• In MVC architecture, Responsible for development and enhancement of ordering flows such as placing new order. Participated in analysis of requirements, estimation, design, development of use cases high level designing, low level designing for several ordering flows in Rational Rose.

Confidential

Developer

Responsibilities:

• Developed java component using multithreading and singleton design pattern named self management that manages credit transfer service application. Experience in overloading, overriding and multithreading.
• Also, developed component to automate Connection Manager start and stop facility from GUI.
• Experience in analysis of reducing network latency and implementing design patterns like session façade .
• Developed work flow, sequence, state diagrams for Low level design in Rational Rose. Developed controller for effective and secure credit transfer service. Responsible for development of several admin screens using JSP for WEB-CLIENT and integrating the same with the project framework.
• Played key role in developing authentication service using beans for SMPP and web client.

Environment: Core java, Servlets, Apache Tomcat, JBuilder, XML, SQL, JDBC, Eclipse, Shell Scripting,SQL Developer