SUMMARY:

• Certified, Senior Oracle and SQL Developer with excellent analytical and organizational skills, experience in designing and building custom applications using Oracle, SQL databases and tools in UNIX and Windows environments. Achieves goals, objectives, and milestones in an accurate and consistent manner.
• Worked with PL/SQL developer for more than 8 years.  Did procedures, functions, triggers, sequences in my project.  Did performance tuning in my project. Used query optimizer for performance tuning.  Used lot of insert, update and delete statement in my PL/SQL.  Used toad software for creating PL/SQL.
• 15+ years of total experience in the field of Information Technology in Analysis, Design, Development, Testing and Implementation
• 9+ years of experience in writing SQL. TSQL, Created Access Reports, SQL Reports, Crystal Reports 8.5/9/10/XI R2/2008, Crystal Enterprise 8.5/9/10, SAP BO CMC, Crystal Info View XI R2.
• Worked closely with Project Managers, Business Analysts, BI Architect, source system owners, Data Management/Data Quality team to ensure timely and accurate delivery of business requirements
• Hands on experience in creating ETL packages using SQL Server 2005 Integration Services (SSIS).
• Hands on experience with Data Warehouse by getting data from different sources and stored in Relational database for end users. Organized, agreegated and summarized data.
• Extensive experience with Teradata, SQL Server and Confidential - SQL in constructing tables, triggers, user defined functions, views, indexes, user profiles, relational database models.
• Hands on experience in implementing business logic by writing and debugging complex Stored Procedures, effective functions, and appropriate Triggers to assist efficient data manipulation and data consistency.
• Involved in writing complex SQL queries using correlated sub queries, joins, and recursive queries.
• Used Data Modelers Tool like ERWIN.
• Hands on experience in using Teradata SQL Assistant to build SQL Queries.
• Experience in Debugging and Performance Tuning of targets, sources, mappings and sessions.
• Reviewed Informatica ETL mappings/workflows and SQL that populates EDW and data mart Dimension and Fact tables to ensure accuracy of business requirements
• Extensive experience in working with RDBMS including Oracle, MS Access and Microsoft SQL Server.
• Worked for various domains like Human Resources, Banking, Telecom, Utility Industry and Health Care.

TECHNICAL SKILLS:

Databases Environments: Oracle RDBMS V7, 8, 8i, 9i, and 10g, SQL Server, Access

Operating Systems: UNIX, Windows 95/98/NT/2000, Windows XP

Languages: PL/SQL, SQL, HTML, Oracle, COBOL, TSQL

Software: Microsoft Office (Excel, Word, and Access), Visio, Visual SourceSafe, Crystal Report 8.0 - 10.0, Visual Basic, ASP, VB Script, SQL Reporting

Tools: Oracle Forms 10g, 9i, 6i, 6.0, 5.0, 4.5, 3.0, Reports 10g, 9i, 6i, 6.0, 3.0, 2.5, Designer 9i, SQL*Plus, SQL*Loader, Toad

Other: Symantec PC Anywhere, Talend Open Studio

PROFESSIONAL EXPERIENCE:

Confidential, Glenridge Connector, Atlanta

Sr. Application Analyst

• Research issues using Oracle PL/SQL on daily basis.
• Constructing MDB Reports for various companies according to their needs.
• Working on oncalls regarding various server processing job issues during night and day.
• Doing Script and log files for MDBs and doing validation for deployment.
• Validating queries with regard to Traffic move in different Data Centers.
• Doing PL/SQL for Procedures, Functions and Packages.
• Sending files through SFTP Servers with Customer needs.
• Finding out Package errors and fixing procedures and Functions
• Testing the SQL in Development and working on Prod.Database.
• Working with Unix commands in Servers processing.

PROFESSIONAL EXPERIENCE:

Confidential, Alpharetta, GA

Business Analyst/Data Analyst

• Performed data extraction and analysis using ACAMP - Ethority Enterprise systems. Analyzed the data sent by the clients and loaded the data into the database.
• Extracted data from multiple operational sources, transformed, cleansed, and filtered the data, and finally loading the data into one or more target databases.
• Developed batch files in order to run the file Packages and also set up the environment needed for those batch files to run properly.
• Advised the Activation Manger (Project Manager/Product team) about the analysis of the data, testing efforts, state of the system and provide input on system acceptance on daily basis.
• Was a part of Project Management team. Handling escalated import and configuration issues. Adapting to constantly evolving process, documentation, and organizational change.
• Coding and unit testing of Jobs for various stages of ETL. Investigating and documenting software bugs for product development.
• Involved in Data mapping, Column mapping and maintain data dictionaries and Data models.
• Expertise in SQL Server Integration Services (SSIS) and SQL Server Reporting Services (SSRS) with good knowledge on SQL Server Analysis Services(SSAS)
• Excellent High Level Design of ETL DTS packages and SSIS packages for integrating data using OLE DB connection with heterogeneous sources like (Excel, CSV, Oracle, flat file, text format data) by using multiple transformation provided SSIS such as Data conversion, conditional split, bulk insert, Merge and Union all.
• Developing reports on SSRS on SQL Server, sound experience and understanding of SSAS, OLAP cubes and Architecture.
• Writing procedures in TSQL to improve the process.
• Involved in Knowledge Transfer to the peers, Documenting of all the Business logic insuring maintenance is easy for the Peers and Responsible for conducting code reviews in my team.
• Involved in Normailization of the database and bringing it to 3NF.
• Created ER diagrams using Visio.
• Created an automated ETL summary information for all the loading activities done each day and month.
• Monitor and tune SQL scripts. Creating upgrade scripts for production database and supporting it.

Confidential, Alpharetta, GA

Application Developer and Production Support Analyst

Responsibilities:

• Worked as a Developer and Support Analyst in Production using Oracle and Access.
• Sent Daily, Weekly and Monthly Reports by doing SQL on daily Basis
• Worked with Mylogins to find our various stages in Requests the customer is doing and finding out the results using SQL and communicating them
• Created new sequels, procedures and functions
• Ran Access Report everyday which uses queries, tables, macros and modules and investigating those records which are ‘failed’ and ‘processing’ and know the reason why they are not completed’.
• Monitored the servers everyday about working using ‘CAM CONFGURATION APPLICATION MONITOR’
• Worked on TOAD and SQL developer to find the fields in various table in Oracle
• Used SSH File Transfer Client and Teradata SQL Assistant for supporting production
• Done ‘On Calls’ once in 3 months to support the system
• Used ‘Bitvise Tunnelier’ for uploading profiles in the system
• Used Teradata in my project and doing queries in Teradata during on calls
• Used Share Point, Visio, Outlook, Word and Enterprise Manager
• Used my expert knowledge in Oracle, Excel, Access, and SQL.

Confidential, Marietta, GA

Business Intelligence Analyst/ Application Developer

Responsibilities:

• Working as a Business Analyst using Oracle, Business Object and Crystal Report XI for various Departments such as Power Control, Safety, Finance and Bills.
• Generating Sub Reports, Standard, Mailing Labels, cross Tab Reports and Graph Reports by using Chart Expert of Crystal Reports
• Using Shared and Global Variables across Crystal Reports
• Experience in creating functions like WhilePrintingRecords, WhileReadingRecords etc
• Migrate Crystal Report Older Version to newer Version, and from Dev to production
• Expert in creating Complex Crystal Reports (Ad Hoc Reports, Frequency Reports, Summary Reports, Drilled-down, Dynamic Grouping, graphical and aging Reports
• Expert in creating various PL/SQL Stored Procedures, Views, Functions and temporary tables for data input to the Crystal Report
• Used Index to allow SQL statements to execute more quickly against Tables.
• Created Nested Table to support columns contained multivalued attributes (example: Columns that can hold an entire sub tables.
• Used Oracle XML DB to high- performance hadling of XML data: storing, generating, accessing, searching, validating, transforming, evolving and indexing.
• Created External Tables.
• Extensive knowledge in pre predefined functions like string, date, numeric, conversion and null functions of Crystal like isnull, in repeated groupheader, monthtodate, lastfullmonth and lastfull week tec.
• Enhance/modify existing reports by creating new Parameters, Formulas etc
• Create test data by creating views/procedures for reporting purpose
• Provide call support after reports are deployed to production
• Export reports in various formats like MS Excel, PDF, MS Word, Text and CSV
• Accessing BI Reports from BI Launch pad by Infoview
• Used SAP Business Object XI 3.0 Information Portal to link to info view
• Experience in accessing Business Object Infoview, logging, selecting, searching, viewing and scheduling the report including to see history of the report
• Used Tomcat to restart Business Objects with the help of PuTTY.
• Used Business Objects Dashboard Builder.
• Used Talend as the ETL tool for Extraction, Transaction and Load the data
• Experienced in designing the OLAP systems for datamart application using SQL Server analysis 2000 and 2005(SSAS)
• Designed and buitlt OLAP cubes to meet reporting needs.
• Designed Cubes with Star Schema using SQL Server analysis Services 2008 (SSAS)… created several Dashboards and Scoreboards with key performance indicators (KPI) in SQL Server.
• Understanding OLAP process for changing and maintaining the Warehouse, Optimizing Dimensions, Hierarchies and adding Aggregations to the Cube.
• Hand on experience in creating STAR Schema and Snow Flake schemas.
• Used Central Management Console
• Used Xcelsius and Query As a web Service