SUMMARY:

• 8+Years of Experience as an Oracle PL/SQL Developer with Proficiency in Oracle 11g/10g/9i/8i, SQL, Oracle PL/SQL,BI Tools. Software Development Life Cycle (SDLC) involving Design, Development, Integration, Implementation and Testing of applications in Client/Server, N - tier Architecture based on Microsoft .NET technologies and SQL Server.
• Experience in MicroStrategy report creating and report testing.
• Analysis and understanding of client business process and requirement.
• Ability to perform extensiveQualityAssurance(QA)on MicroStrategy reports.
• Resolving skillsof user-identified functional and technical issues relating toMicroStrategy reporting services.
• Good understanding ofStar Schema modeling, Snowflake modeling, Fact, Lookup and Dimensions Tables.
• Worked on MicroStrategy report objects, MicroStrategy API, MicroStrategy Integrity Manger.
• Expertise in VB6.0,VB.Net, C#.Net Application programming along with Hands on Experience in writing Complex Stored Procedures in T-SQL under SQL 2005/2008 Server, Oracle 10g/11g.
• Database design and programming experience using Netezza, Redshift, SQL Server, Oracle, Sql Developer etc. databases and tools.
• Expertise in creating PL/SQL packages, Procedures, Functions, Triggers and Views to retrieve, manipulate and migrate complex data sets in Oracle Databases.
• Extensive experience in business and systems Developer roles identifying problems and/or opportunities and defining solutions through direct involvement in all facets of the software development project lifecycle and thorough experience in client interaction.
• Experienced in variousproject managementmethodologies like SDLC, Agile, SCRUM and Water Fall based.
• Worked with query tools like Toad, SQL*Plus, PL/SQL Developer,Sql Developer.
• Enforcing experience in data integrity using integrity constraints and database triggers.

SUMMARY OF TECHNOLOGIES:

BI Tools: MicroStrategy Desktop 9.4, Integrity Manger, Crystal Reports

Languages: C#, Visual Basic, PL/SQL,VB.Net

Databases: Netezza, Redshift, SQL Server, Oracle 11g/10g/9i/8i.

Database Tools: SQL developer, TOAD, SQL * Loader, SQL*Plus, PL/SQL Developer, AWS CLI, Aginity

.NET Platforms: .NET Framework

Version Control: Microsoft Visual Source Safe (VSS), Jira

WORK EXPERIENCE DETAILS:

Confidential, VA

Microstrategy Report Developer

Responsibilities:

• Created report including Filter, Prompt, Drilling, Templets.
• Worked on report Objects likeMetrics and Compound metrics, Filters, Consolidations, and Custom Groups, Promptsfor report.
• Knowledge of Microstrategy features like Dashboard, Complex Filter, Intelligent cube,OLAP.
• Work with database migration from Netezza to Amazon RedShift.
• Data unloading from Netezza database, Moving data file to S3 bucket and load data from S3 Bucket to RedShift database.
• Experience in AWS CLI.
• Experience in Microstrategy API for report data servies.
• Involved introubleshootingMicrostrategy Prompts, Filters, Templates, Consolidations in an enterprise data warehouse team environment.
• Involved in automation report testing using Integrity Manger withFree Form SQL Queriesand SQL Generated by Microstrategy analytical engine.
• Performedbeta and regression testing,test plancreation and Quality Assurance to ensure the right outputs for the reports.
• Worked and coordinated with offshore QA team from Poland, India, and Canada.

Environment: Microstrategy Desktop 9.4, Netezza, Redshift, AWS CLI, Aginity, SQL Developer, Jira, SCRUM.

Confidential, VA

BI Report Developer

Responsibilities:

• Involved indesignof prototype ofreports, documents and dashboardsbased on requirements.
• Created MicroStrategySchema objectsandPublic objectsusing MicroStrategyDesktop.
• Created Attributes, Facts, and Hierarchies, logical views, advanced filters, custom groups, consolidations, prompts, metrics (simple, compound, derived, summary and level) and report templates.
• Used grids, graphs and grid-graphs and various formatting techniques in development ofreport service documents.
• Used different types ofselectors, graphs, bars and widgetsin the development ofdynamic dashboardsfor stunning visualizations of data.
• Usedapply functionslike apply simple; apply comparison to meet the report requirements wherever necessary.
• UsedFree-form sqlfor complex report creation.
• Used advancedsorting,smart totals, page-by and different functionalities.
• Applied OLAP functions to calculate metrics.
• Worked withMicroStrategy enterprise manager and Integrity manager.
• Performed extensivetesting both functional and system on development objects.

Environment: MicroStrategy Desktop 9.2.1/9.01, MicroStrategy Architect, MicroStrategy Intelligence Server, MicroStrategy Web, ER Studio, WinSql and Netezza..

Confidential, NC

Oracle PL/SQL Developer

Responsibilities:

• Worked as Oracle Developer performing data analysis and data conversion. Developed custom reports.
• Gathered the requirements from the business users, analyzed and translated into detailed technical specifications.
• Written complex SQL queries and developed PL/SQL Stored Procedures, Functions, Packages, Triggers, Materialized Views.
• Extensively used SSIS transformations such asLookup, Derived column, Data conversion, Aggregate, Conditional split, SQL task, Script task and Send Mail task etc.
• Worked on SSIS Package, DTS Import/Export for transferring data from Database (Oracle and Text format data) to SQL Server.
• Tuned the SQL queries to improve performance.
• Responsible for enhancement of standard and custom reports using Oracle Report Builder.
• Created control files for data loading. Used SQL loader tool to load the data.
• Did unit testing of customizations.
• Responsible for the technical and user documentation of the customizations.

Environment: ERStudio 8.x, Abinitio, ITIL, Oracle 8i,9i,10g,11g, Oracle Enterprise Manager, Oracle Grid control, PL/SQL, TOAD, SQL *Plus, SQLServer 2005, 2008R2

Confidential, San Jose, CA

Oracle PL/SQL Developer

Responsibilities:

• Worked with Business Analysts to understand the Business requirement details.
• Did technical analysis for deciding the approach to implement these requirements using Oracle database as backend.
• Designed and modified the Data Model to add new Tables and modify existing tables as per new business requirements in the Project.
• Created new database objects such as Tables, Views, Indexes, Sequences, Grants and Synonyms, DB Links as per the requirement.
• Did designing and development of new PL/SQL Code as well as enhanced the existing PL/SQL Code which involved creating new PL/SQL Packages, Functions, Data types and Objects.
• Worked on setting up new database schemas in Development environment.
• Created PL/SQL Cursors, Ref Cursors.
• Did Exception/Error Handling using Named and Un-named Exceptions and defined Exceptions.
• Performed Unit Testing of developed code.
• Did performance tuning of SQL queries and PL/SQL scripts with help of oracle tools like explain plan.
• Worked with Quality Analysts to identify the defects existing in already developed PL/SQL code and fixing the bugs to work as per business test cases.
• Created Kintana Packages and lines for Production Code Release.
• Offshore team Co-Ordination.
• Prepared Technical and Release documentation.

Environment: Oracle 11g, SQL, PL/SQL, TOAD, PVCS, Kintana, Windows 7, MS office.

Confidential

Developer

Responsibilities:

• Involved in Complete development, maintenance, and integration of Pipe, Glass and Transport Industry base ERP.
• Involved in Complete development and integration Infrastructure inventory management system.
• Gathering the functional requirements from users and converting them into Technical requirements.
• Perform gathering requirements, design high level and low level design documents.
• Design and implement presentation layer and Sql server and Oracle backend database.
• Experience in designing & creating databases in Oracle 10g.
• Created complex database packages, procedures, functions, triggers, views, materialized views using Oracle, SQL and PL/SQL.
• Optimize and test the final product and implement at user side (Ametek Process Instruments - THERMOX, Kopp Glass Inc., Art and Glass EVERGREEN, FUSO, TPRS, GLAXY etc...).
• Used SQL* Loader and export/import mechanism for data migration for bulk upload.

Environment: SQL Server 2005, Oracle10g/ 11g, TOAD, VB, Visual Studio 2010, C# .net, Crystal Reports.