SUMMARY

• More than 10 years of experience in IT, with expertise in Database Programming, Application Development, Reports Development, Dashboard Development, SDLC activities, production and technical support mainly for financial, healthcare and other Domains..
• Involved in complete software development life cycle (SDLC) of various projects including Analysis, Design, Development, Testing, Implementation and production support of integrated application software.
• Strong systems / business Analysis, requirement gathering, interfaced extensively with Management, users and technical teams. Liaison with other project teams and system owners to help define the project requirements.
• Strong understanding of data relationships and Data Warehousing, RDBMS Concept, SQL, Oracle, SQL Server.
• Strong MS SQL Server Developer skills including writing Stored Procedures, User Defined Functions, Triggers, Views, Query writing and SQL Tuning.
• Experience in OLTP/OLAP/ROLAP/MOLAP System study, Analysis and ER modeling.
• Affluent in Web Technologies like JavaScript, VB Script, C#.Net, HTML, CSS, XML, etc.
• Strong modeling skills as well as supporting analytical and reporting needs of Corporate Business needs.
• Extensively worked on Relational Databases like Oracle 10g/9i, MS SQL Server 2012/2008/2005, Sybase 12.
• Strong hands - on experience with various tools, including version control such as PVCS.
• Experience in Creating, Configuring and Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services (SSIS)
• Experienced consultant with good work ethics, effective communication, interpersonal, problem solving, and analytical skills.
• Well Organized, self-motivated, adaptable, quick learner, independent and good team player.

TECHNICAL SKILLS

• Visual Basic 6.0/5.0
• VB.NET
• VBA
• MS Office (Excel
• Power point
• Access)
• SQL
• PL/SQL
• UNIX Shell Scripts
• Perl
• Microsoft Visual Studio 2010/2008
• C#
• Microsoft Visual Interdev 6.0
• Microsoft Visual SourceSafe 6.0
• PVCS
• ASP
• ASP.NET
• VBScript
• Java Script
• HTML
• XML
• COM
• Active X
• ADO
• ADO.NET
• Cognos 10.2 Business Intelligence
• Report Studio
• SAP Business Object Crystal Reports 2011/XI/9.0/8.5/8.0/7.0
• Datawatch
• Emergence Report Manager
• Solimar Rubika
• SOL Fusion
• SPDE
• Oracle 9i/10G/11G
• MS SQL Server 2012/2008/2005/2000
• Sybase 12
• MS Access
• Cognos Framework Manager
• Axiom
• DB Artisan
• Control-M
• Toad
• SQL*Navigator
• PL/SQL Developer
• Autosys
• Crontab
• Erwin
• Sheridian
• Far point Spread
• HP Quality Center
• MS Visio
• UNIX (AIX
• Sun Solaris)
• Linux
• ODBC
• COM
• DCOM
• ActiveX
• Client/Server
• Data Stage
• Microsoft SSIS
• Oracle SQL Developer

PROFESSIONAL EXPERIENCE

Confidential, Rutherford, NJ

Sr. SSIS / DW / Oracle PL/SQL Database Developer

Responsibilities:

• Was involved in all phases of the SDLC, working closely with business users, analyzing specifications provided by the business community and developed Functional Specification documents, Reports and Dashboard as per the business requirements.
• Test case creation and coordination with UAT team.
• Developing complex PL/SQL code, Stored Procedures, functions, triggers, Indexes and views for the application.
• Designed and Developed CoB Analytics Dashboard that will help the management to see the status of Business Impact Analysis, Business Recovery Plan, Crisis Management Plan, Third Party CoB Work Area and Business Functionality Testing With capabilities to visualize data across a map with RAG status with in-depth filtering, allowing the management to focus on areas requiring attention-across Sectors, Regions, Countries, Divisions.
• Analyzing existing transactional database schemas and designing star schema models to support the users reporting needs and requirements.
• Design and develop the metadata models and published the package using Framework Manager
• Involved in Relational and Star schema database design and loading data.
• Responsibilities include Extracting, Transforming and Loading data from various sources Into Data Warehouse and generate reports.
• Designed Standard List Reports, Cross-Tab Reports, Charts, Master-Detail, Map, Drill-through, and Drill-Down.
• Applied Security by controlling privileges for users, groups and roles to the various packages, reports and Dashboards.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Automated Generation of Power point. Slides from Excel report using VBA.
• Automated Generation of Regulatory & Audit Power point slides using Cognos Go Office.

Environment: MS SQL Server (2012/2008), T-SQL, SQL Server Integration service, Oracle 11g,Data Stage, Cognos (10.2.1), Cognos Go Office, Framework Manager, SAP Business Objects, MS Visual Studio, Oracle PL/SQL, HP Quality Center 10.0,VBA,Adobe Acrobat, MS Excel, MS Power point, Oracle SQL Developer

Confidential, Edgewood, NY

Sr. Systems Analyst / Sr. Database Developer

Responsibilities:

• Played an instrumental part in successful completion of several critical projects while being involved in all phases of the SDLC.
• Worked closely with business users to obtain and collect the requirements of the business community.
• Translated business needs into data analysis, business intelligence data sources and reporting solutions for different types of information consumers.
• Developed complex T-SQL code such as Stored Procedures, functions, triggers, Indexes and views for the application.
• Used Joins, correlated and non-correlated sub-queries for complex business queries involving multiple tables & calculations from different databases.
• Used advanced features of T-SQL in order to design and tune T-SQL to interface the database and other applications in most efficient manner.
• Created many complex Stored Procedures/Functions and used them in Reports directly to generate reports on the fly.
• Created SSIS package to load data from Files and SQL Server by using Lookup, Fuzzy Lookup, Derived Columns, Condition Split, Term Extraction, Aggregate, Pivot Transformation, and Slowly Changing Dimension.
• Used SSIS to create ETL packages to Validate, Extract, Transform and Load data to Data Warehouse and Data Mart Databases.
• Modified the existing SSIS packages to meet the changes specified by the users.
• Scheduled Jobs for executing the stored SSIS packages which were developed to update the database on Daily basis using SQL Server Agent.
• Designed, Developed and Deployed reports in MS SQL Server environment using Data Watch Emergence Reporting Tool.
• Generated Sub-Reports, Cross-tab, Conditional, Drill down reports, Drill through reports and Parameterized reports.
• Created reports to retrieve data using Stored Procedures that accept parameters.
• Involved in a full test cycle, production support and maintenance.

Environment: MS SQL Server, T-SQL, SQL Server Integration service, Data Transformation Services, Cognos (10.2/8.4), Crystal Reports, Crystal Enterprise, Data Watch Imergence Reporting Tool, Query Analyzer, Index Tuning wizard, SQL Profiler Windows server 2003,MS Visual Studio (2010/2008), Oracle PL/SQL, C#.NET, HP Quality Center 10.0,MS Visio 10

Confidential, New York, NY

Sr. Database Analyst

Responsibilities:

• Getting Report Requirements by meeting with Business users in various groups like Risk Management, Fixed Income Research Analysts, Traders and Portfolio Managers.
• Analyze, Design, develop and implement several reports using Crystal Reports for various Fixed Income Systems like Minerva/Apex.
• Support Fixed Income Trading Desk and Interacting with portfolio managers and Traders to gather functional specification and translate them into technical design specs and design the reports.
• Developed the Stored Procedures and Views to be able to customize the reports according to specifications.
• Migrated Reports from Crystal 9.0 to XI.
• Download the data from 1010 data Vendor using Perl API into a flat file then into an Oracle database using SQL Loader for use by the applications.
• Created database objects like tables, views, Constraints, Synonyms etc.
• Created Shell scripts to execute stored procedures, functions and triggers to apply business logic according to user specification.
• Used Crystal Management Console (CMC) tool in Crystal Enterprise to schedule the report instances based on the event, publish the reports on the web portal in various formats.

Environment: Crystal Reports (9.0,XI,2008), Crystal Enterprise (9.0,XI,2008), Oracle 9i/10G,PL/SQL, SQL Server 2005,SSIS,Sybase 12.5, Sun Solaris Unix, Perl, Linux, Control-M, PVCS, Visual Basic 6.0

Confidential, Hopewell, NJ

Developer / Consultant

• Analyze, Design, develop and implement several reports using Crystal Reports.
• Developed the Stored Procedures and Views to be able to customize the reports according to specifications.
• Download the data from a flat file received from Mainframe into an Oracle database using SQL Loader for use by the applications.
• Created database objects like tables, views, Constraints, Synonyms etc.
• Created SQL, PL/SQL & Shell scripts to create stored procedures, functions and triggers to apply business logic according to user specification.
• Migrated Crystal Reports From Version 9.0 to 10.0.
• Used Crystal Management Console (CMC) tool in Crystal Enterprise to set up users, security levels and to publish reports.
• Created various customized reports using Crystal reports.

Environment: Crystal Reports (8.5, 9.0, 10), Crystal Enterprise (8.5, 9.0), Oracle 9i, Unix, Auto sys, VBScript, JavaScript, ASP, ASP.NET

Confidential, New York, NY

Developer / Consultant

Responsibilities:

• Replaced COM calls and other code within VBA Wrappers with correspondent methods of a new class called PositionItem.
• Modified stored procedures.
• Modified Macro module in the AddIn to activate the new Pricing Subsystem.
• Imported the existing Modules and class modules.
• Generation of Pricing Spreadsheets using Excel VBA.
• Did Performance Tuning for the spreadsheets to reduce calculation time when a value is changed.

Environment: Visual Basic for Applications (VBA), Excel 97, Sybase 12, Visual Source Safe 6.0, TIBCO

Confidential, Newtown, PA

Developer / Consultant

Responsibilities:

• Analyze, design, develop, test and implement applications for new clients using Visual Basic.
• Support and enhance existing applications for various clients
• Download the data from a flat file received from clients into an Oracle database using SQL Loader for use by the applications.
• Created database objects like tables, views, Constraints etc.
• Created several class modules. Some class modules retrieved data from the Oracle database using ADO.
• Created SQL, PL/SQL & Shell scripts to create stored procedures, functions and triggers to apply business logic according to user specification.
• Created dll files and ActiveX controls using Visual Basic.
• Used Crystal Management Console (CMC) tool in Crystal Enterprise to set up users and security levels.
• Created various customized reports like Disposition, Net Sales, Performance Reports etc for each client using Crystal reports and Excel Spread Sheets

Environment: Visual Basic 6.0, Crystal Reports (8.5), Crystal Enterprise 8.5, Oracle 8i (8.1.7), HP-UX Unix, Reflection(8.0), Visual Source Safe, Excel 97, Access 97

Confidential, Morris Plains, NJ

Developer / Consultant.

Responsibilities:

• Involved in design, development and testing of web based Internet application using ASP as Scripting Language and Oracle as database.
• Involved in creating COM Components provides data access and business rules processing
• Involved in deploying COM Components in MTS.
• Created triggers, stored procedures, functions and packages to apply business logic according to user specifications.
• Used Erwin for Reverse Engineering Access 2000 (Erwin) and Forward Engineering to Oracle.
• Created a macro in Access to export all Access tables to flat files at once.
• Migrated data from Access 97 to Oracle database. Converted Access Reports to Crystal Reports
• Involved in creation of complex grouped and sub-reports as well as many ad hoc reports using Crystal Reports.
• Created COM objects, dll files and ActiveX controls using Visual Basic.

Environment: Visual Basic 6.0, VBA, Active Server Pages ASP 2.0 (Ms-Visual Interdev 6.0), HTML, XML, VBScript, JavaScript, COM with MTS, IIS 4.0, Crystal Reports(8.5), Oracle8i(8.1.6), Access(97), Lotus Notes

Confidential, New York, NY

Developer / Consultant

Responsibilities:

• Involved in Business Analysis, Design and Development.
• Performed Normalization and Logical Database Design.
• Created Stored Procedures, Functions and Packages to manipulate the database and to apply the business logic according to user specifications.
• Involved in hard coding of SQL & PL/SQL scripts.
• Performance tuning for rapid execution of SQL & PL/SQL Scripts.
• Involved in developing various Forms, Reports, Procedure, Functions and the PL/SQL Libraries to support the GUI application.
• Transfer of data for testing of master data and reports from old system in DEC to Oracle Tables using SQL*Loader and Database Triggers.
• Granting relevant privileges to different users by use of roles.
• Migration of system from development database to UAT, production database on different server using Export/Import utility.
• Created database objects like tables, constraints, views, synonyms, indexes etc.

Environment: MS SQL Server (7.0), Oracle8i (8.1.6), Visual Basic (6.0), Third Party Controls, Crystal Reports (8.0), Unix, Windows NT, Lotus Notes