MS SQL Server Developer Sample Resume Format in Word Free Download

Sample Template Example of Beautiful Excellent Professional Curriculum Vitae / Resume / CV Format with Career Objective, Job Description, Skills & Work Experience for Freshers & Experienced in Word / Doc / Pdf Free Download

Deepak Sundaram

deep.sundaram88@yahoo.com

315 725 3024

SUMMARY

                                                    

• SQL Server Developer with over Seven Plus years of experience in the field of Development of ETL packages, Data Quality, Implementation and Support.
• Expert in designing, maintaining & tuning various RDBMS such as MySQL, T-SQL &

SQL Server 2008/2005/2000/7.0/6.5

• Over 4 years of experience in Experience in Oracle 10g/9i/8i, SQL, PL/SQL Programming, SQL*LOADER, Oracle Discoverer, HTML, VB6.0, .Net, Java.
• Experience in installation, upgrade and configuration of Microsoft SQL Server database.
• Expert in T-SQL, working on DTS, SSIS, SSRS, SSAS, Data Cleansing, Data Scrubbing and Data Migration.
• Used multiple transformations in SSIS to meet the business requirements by collecting data from various sources.
• Transformed data from one server to other servers using tools like Bulk Copy Program (BCP), Data Transformation Services (DTS) and SQL Server Integration Services SSIS 2005.
• Built various packages in SSIS to load the data coming from various interfaces like OMS, Orders, Adjustments, Objectives, FARM and CRIFT.
• Migrated organizational data, orders, adjustments, objectives and Callidus data in various formats like text based files, Excel spreadsheets to SQL Server databases using SQL Server Integration Services (SSIS) to overcome the transformation constraints.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Good knowledge of RDBMS and Data Warehouse concepts, OLTP & OLAP.
• Developed packages, procedures, functions and database triggers using PL/SQL.
• Experience in creating SQL*Loader control programs and PL/SQL validation scripts for validating and pre-import processing legacy data from feeder systems to Oracle Applications.
• Programming and debugging skills in PL/SQL, SQL and UNIX Shell Scripting.
• Extensive knowledge of Database Administration, Triggers, Stored Procedures, Functions, Design, Creation, Migration, Upgrading, Performance Tuning, Logical and Physical Design. Experience in Creating SSIS Packages to automate the Import and Export of data to and from SQL Server 2005. Experience in using SSIS tools like Import and Export Wizard, Package Installation, SSIS Package Designer.
• Experience in report writing using SQL Server Reporting Services (SSRS) and creating various types of reports like table, matrix, and chart report, web reporting by customizing URL Access.
• Developed reports using SSRS and COGNOS. Used table control, matrix control for cross tab reports.
• Experience in Microsoft SQL Server Database Administration including planning, implementing, backup, and recovery strategies.
• Possess Front-end Development (Visual Basic, MS-Access, Developer-2000 Forms, and Reports 2.5/3.0) experience.
• Extensive experience in developing applications using C, C++, Java, J2EE, VBA, VB.Net, C# .Net, ASP.Net and other programming languages.
• Extensive experience in all phases of Project Life Cycle Requirements, Analysis, Architecture, Design, Building, Unit & Integration Testing, Migration and Training, Deployment, Production Support and Help Desk support.

EDUCATION DETAILS

• Bachelor of Technology in Computer science, Jaypee University of Information Technology, Himachal Pradesh, India.

SKILLS/TOOLS

Operating Environments	Microsoft Windows XP/2003/2000/9i/NT, IBM AIX Unix 4.2, Red Hat Linux 8, IBM OS/390 version 2.8, Novell Netware 4.1, Sun Solaris 8 and DOS
Databases	Oracle 10g/9i/8i/7.x, MS SQL Server 2008/2005/2000/7.0/6.5, DB2 UDB, MS Access 2000/7.0, Sybase, and Teradata V2RX.
ETL tools	Informatica Power Center 7.1.3/8.0,DTS (Data transformation services),SQL Server Integration Services(SSIS)
Database Tools:	SQL Profiler, SQL Query Analyzer, Management studio     Index Analyzer, DTS Import/Export, Backup Server, Replication server, SQL Agents, SQL Alerts, SQL Jobs, Visual Source Safe.
BI:	Transact SQL (T-SQL),OROS Analyzer, Performance Point Services (PPS), SAS Performance Management, Microsoft SharePoint Foundation 2010, FAST Search Server 2010 for SharePoint, Microsoft Office SharePoint Server 2007 (MOSS 2007).
Languages	Excel/VBA, SQL, Access/VBA, Visual Basic, Java, SQL, PL/SQL, Unix Shell scripting, HTML, XML, VB 6.0, VB.Net, C#.Net, java, J2EE
Reporting Tools:	SQL Server Reporting Services (SSRS), Crystal reports 8.0/9.0/10.0,MS Excel.
DB Modeling Tools:	MS Visio, Erwin.
Design Tools	SQL Server Management Studio, Enterprise Manager, Query Analyzer, SQL Profiler, Data Base Engine Tuning Advisor, SSIS, SSRS, Business Intelligence Development Studio, Data Transformation Services

WORK EXPERIENCE

BANK OF AMERICA, CHARLOTTE, NC                                                       July 2009 – Till Date

Sr. MS SQL SERVER DEVELOPER

Bank of America is one of the Leading Financial Institutions World Wide. Working for the Statistical Financial Systems (SFS) project, loads the data from source systems and also gets the files from the Legacy systems. SFS captures the statistical financial information in the Oracle database target tables. SFS stores the data into oracle staging tables and finally loads the financial statistics into model tables. The statistical reports are published by using the SFS oracle target table data to perform statistical analysis. SFS inbound starts from loading the data into Oracle staging tables through PL/SQL stored procedures and SQL*Loader. SFS outbound ends with the generation of the financial statistics reports.

Responsibilities:

·        Proven background translating cell formulas in Excel into VBA code and using Excel-based VBA to design, analyze, and deploy programs for finance industry.

·        Designed, coded, and tested a new process enabling the OLTP system to collect daily foreign currency exchange rates from a server on the Internet and perform real-time currency conversion on transactions.

·        Implementation of performance dashboards to analyze and measure performance of 600+ applications supporting large wholesale banking function. System started with Performance Point 2007 and migrated to Office SharePoint 2010, including Performance Point Services, SharePoint and Reporting Services 2008. Also integrating Visio 2010 diagrams with scorecards via Performance Point Strategy Maps. Backend database is SQL Server 2008 Analysis Services and SharePoint lists.

·        Designed , coded, tested and implemented processes to port foreign account information into the OLTP database and allowing these foreign merchants' data to be processed as native accounts.

·        Implemented concurrency control for various applications which are OLTP based.

·        Implemented SharePoint 2010 for document management, collaboration and automation of business processes using workflow.

·      Worked in OLTP & OLAP environment that includes Production (24x7), QA and    development databases in SQL Server.

·        Lead architect of global roll-out of MOSS 2007 and migration from Tibco Portal Builder and Documentum eRoom. Integration between Documentum and SharePoint.

·        SharePoint architect responsible for architecting components of global intranet portal. Utilized Business Data Catalog (BDC) for importing user profile data from Oracle ERP system into MOSS.

·        Currently participating in teams designing, coding, testing, and implementing new features and corrective maintenance updates in the high-performance OLTP financial application

·        Extensively used tools like SQL Profiler, Index Tuning Wizard, and Database Engine tuning wizard, Windows Performance Monitor for monitoring and tuning MS SQL Server performance.

·        Experience in creating Jobs, Alerts, SQL Mail Agent, and schedule DTS/SSIS Packages.

·        Extensive experience in database tuning, server logins and database permissions.

·        Expert in designing Star Schema and snowflake schema with Facts, Dimensions, Measures and Cubes

·        Created error handling mechanisms for various applications which are dependent on databases.

·        Experience in designing, creating, processing of cubes using SSAS.

·        Expert in calculating measures and dimension members using multidimensional expression (MDX), mathematical formulas, and user-defined functions.

·        Good experience in Designing Aggregations and pre-calculating the same in SSAS 2005.

·        Excellent hands on experience in creating groups and measures, KPIs.

·        Expertise in generating reports using MS Reporting Services 2008/2005/2000

·        Maintaining records in Excel Spread Sheet and exporting data into SQL Server Database using SQL Server Integration Services.

·        Create VBA programs to automatically update Excel workbooks, encompassing class and program modules and external data queries.

·        Develop GUI interfaces using Open Database Connectivity (ODBC) to connect to Oracle and Sybase Relational Database Management Systems (RDBMS).

·        Utilized knowledge of the Sharp (C#) programming language to build and maintain new and existing applications.

·        Created the SSIS /DTS packages and scheduled them.

·        Modifying DTS scripts to handle automated tasks for Data (SSIS ) Loading/Extraction and Transformation (ETL)

·        Created SSIS package to get data from different sources, consolidate and merge into one single source.

·        Built a lot of data linkages by utilizing the related data values in the data to make the linkages together in different ways.

·         Restructured the data by using these data relationships in the data as linkages in order to change the structure to model these new relationships.

·        Worked on many layers of Grid and Web Services: from high level (adaptive orchestration of services) to low level (performance of XML parsers)

·        Assisted with automation of finance department's manual processes by writing VBA code and using macros and formulas to speed processes and maximize accuracy.

·        Configure the SSIS package for Server name, database name, User name and Password

·        DDL Scripts for generating Tables, Views, Functions.

·        Written and executed complex T-SQL queries using SQL Management Studio for back end data validation testing.

·        Expert in Advanced Excel and its features like Pivot Tables, Charts, Functions, Scenarios, Goal Seek etc.

·        With Excel/VBA and MS Access Implemented, developed, and supported financial applications regarding Fixed Income, Derivatives, Risk Management, Futures, Options, and Interest Rate Swaps.

·        Focus on distributed and multi-threaded parallel processing:  SOAP/WSDL/XML web services, deadlock avoidance, robust error recovery, scalable high performance, security, extensibility, component architectures, design patterns & anti-patterns, and object oriented design.

·        Developed complex T-SQL code for creating applications like SSIS packages, cursors, tables, and triggers for automating tasks.

·        Responsible for creating Databases, Tables, Cluster/Non-Cluster Index, Unique/Check Constraints Views, Stored Procedures, Triggers, Rules and Defaults using T-SQL.

·        Developed SQL Scripts to Insert/Update and Delete data in MS-SQL database.

·        Scheduling Jobs, Backup and Restore database

·        Created both automated and manual reports using SSRS (SQL Server Reporting Services)

·        Working on Client/Server tools like SQL Server Enterprise Manager and Query Analyzer to Administer SQL Server.

·        Reporting OLAP cubes built with SQL Server Analysis Services using Business Objects as a front end.

·        Developed custom reports using SSRS/SQL Server BI studio.

·        Created custom and Ad hoc reports using SSRS.

·        Created reports that call Sub reports in SSRS.

·        Performance tuning, query optimization and execution plan of queries for better performance.

·        SSRS installation and report server configuration.

·        Configured IIS and Deployed Reports and Analysis Project in to server.

·        Extended Data to XML and Excel Spread Sheet.

·        Successfully loaded data from an EXCEL, Access into a SQL Server database Table.

·        Created Tables, Views, Synonyms, Sequences and Indexes. Monitored Object fragmentation

·        Involved in the design, development, and import of invoice tables into Oracle.

·        Designed and created Report templates, bar graphs and pie charts based on the financial data.

·        Generated reports using Pro*C and PL/SQL packages.

·        Deployed the jar files in the EJB container and Web Container on the Web Logic Server.

·        Responsible for coding all the JSP, Servlets used for the User Module.

·        Developed the User Interface using JSP including the frameworks JSF and AJAX.

·        Used EJBs in the application and developed Session beans to implement business logic at the middle tier level.

·        Wrote java utility classes common for all of the applications.

·        Developed 

L, DHTML, and JavaScript for various client side functions.

·        Wrote scripts to import customer information from legacy system using SQL*Loader and PL/SQL.

·        Created and run Batch files on regular basis.

·        Used UNIX Shell Script for invoking Reports.

Environment: MS SQL Server 2008/2005, T-SQL, MDX, Web Services, C#, Visual Studio 2005, Oracle 10g/9i,Excel VBA, Microsoft SharePoint Foundation 2010, FAST Search Server 2010 for SharePoint, Microsoft Office SharePoint Server 2007 (MOSS 2007), Windows SharePoint Services 3.0 (WSS 3.0),Performance Point Services (PPS), SAS Performance Management, SharePoint Portal Server 2003, SharePoint Portal Server 2001, SharePoint Team Services, SQL Server Management Studio, OLTP, OLAP, Stored Procedures, SQL Server reporting services (SSRS), J2EE 1.4, Web logic 9.0, SQL Server Integration Services (SSIS), SQL Server Analysis Services (SSAS), Crystal Reports, Office, Excel, Windows XP, Unix (AIX).

 

BAXTER CORPORATION,IL                                                             MAY2008 – JULY2009

Sr. MS SQL SERVER DEVELOPER

Baxter offers a wide range of services from individuals and small businesses to corporations and government entities. The scope of the project is to get various data feeds of transactions/information and analyse the data and determine the compensations for the customers. And I was part of their Data warehousing initiative group that involved in Data Migration, Integration and Reporting needs of their users.

Responsibilities:

• Created and executed SQL Server Integration Service packages to populate data from the various data sources, created packages for different data loading operations for many applications.
• Created SSIS Packages using SSIS Designer for export heterogeneous data from OLE DB Source (Oracle), Excel Spreadsheet to SQL Server 2005.
• Developed and implemented web based Business Performance Reporting (BPR) system providing the company with high level decision support framework. Interfaced with Executive, Operational, Financial and Business Intelligence groups to develop and foster partnering across diverse teams.
• Managed technical and functional analysts supporting Planning and Operating departments for the entire company.

·        Implemented concurrency control for various applications which are OLTP based.

·        Created error handling mechanisms for various applications which are dependent on databases.

• Facilitated definition of BPR system utilizing “Balanced Scorecard” methodologies, including strategy mapping and goal alignment to technical data sourcing issues. Coordinated efforts with all Operating departments from executive level to team leads. Bridged communication and data sourcing efforts with Technology.

·        Migrated SharePoint 2003 corporate intranet to MOSS 2007 medium server farm. Set up extranet for clients using forms based authentication (FBA) and ADAM. Deployed SQL Server Reporting Services for generation of reports. Developed InfoPath forms, custom workflows, web parts and event handlers.

·        Proof of concept (POC) SharePoint business intelligence solution for tracking Human Resources InfoPath forms developed using SharePoint 2003, SQL Server Reporting Services, InfoPath 2003.

• Investigated how BPEL4WS (Business Process Execution Language for Web Services) can be adapted for use in OGSI and WSRF.
• Worked extensively on identifying key performance bottlenecks in the design and implementation of SOAP toolkits, and other issues such as evaluating of security overhead in Web services, authorization framework, streaming validation of SOAP digital signatures, and design of binary XML for scientific application.
• Migrated DTS 2000 packages to SQL Server Integration Services (SSIS) and modified the packages accordingly using the advanced features of SQL Server Integration Service.
• Designed ETL packages dealing with different data sources (SQL Server, Flat Files, and XMLs etc) and loaded the data into target data sources by performing different kinds of transformations using SQL Server Integration Services (SSIS).
• Quantitative Portfolio Risk Analysis Developer performed detailed calculation of the VaR value based on different models using Excel/VBA. The role involved catering to Ad-hoc requests which were sensitive in nature and driven by the needs of senior management.
• Created a macro to send email alerts, notifications and attachments through Outlook. These emails were automatically sent when VaR value approached the thresh hold value.
• Hands on experience in creating OLAP cubes using SQL Server 2005 analysis services (SSAS).
• Built MDX queries and Data Mining Expression (DMX) queries for Analysis Services & Reporting Services.

• Ability to define and develop Report Structure with data definition, report layout and report definition language.
• Designing User interface Units in Forms, Reports, Graphics. Experience in configuring report Printing Options(HTML Printing, Printing from PDF Document, Client- Side Printing)
• Extensive  experience in report writing using SQL Server Reporting Services and also creating
• Various types of reports like table, matrix and chart report, web reporting by customizing URL Access.
• Created HELP prompts using MsgBox in Excel/VBA for making user friendly applications.

• Experience in  Integration with Windows Security and Custom Security (Authentication and Authorization)
• Responsible for writing T-SQL code for creating cursor and handling data validations.
• Created stored procedures, views, triggers, user defined functions to incorporate the flow of business and called various stored procedures
• Developed PL/SQL Procedures and UNIX Scripts for Automation of UNIX jobs.
• Created complex queries to automate data profiling process needed to define the structure of the pre staging and staging area.
• Scheduled Cube Processing from Staging Database Tables using SQL Server Agent.
• Wrote MDX queries and expressions for use in Front End BI Applications.
• Created KPI Objects in line with Requirement Docs.
• Optimized cubes for better query performance.
• Extracted data from XML files.
• Aggregated cube with 40% performance for better performance.
• Processed cube to perform incremental updates.
• Wrote MDX expressions to create name sets and calculated members.
• Created reports by dragging data from cube and wrote mdx scripts.
• Created reports by extracting data from cube.
• Developed Unix Shell Script as required.
• Used multiple join statements to retrieve data from several tables
• Used highly complex TSQL Queries and SQL Scripts to perform efficient data load based on complex Business rules.

• Experience in creating multiple reports (SSRS) in Drill mode using tables, financial tables, crosses tabs and charts
• Design, deployment, and maintenance of various SSRS Reports in SQL Server 2005.
• Designed and implemented Parameterized and cascading parameterized reports using SSRS.
• Developed custom reports using SSRS/SQL Server BI Studio.
• Created Stepped and Block reports using SSRS
• Created Drill Through and Various Cross tabbed reports using SSRS.
• Modified stored procedures to meet current design and used them in SQL Server Reporting Services directly to generate reports on the fly.
• Responsible for creating summary Reports, Sub Reports, Drill Down Report, dynamic grouping
• Created indexed views and appropriate indexes to cut the complex query time. Implemented new indexing system reduced report processing time by average of 28%.Used SQL Profiler for troubleshooting, monitoring, and optimization of SQL Server and non-production database code as well as T-SQL code from developers and QA.
• Backing up, restoring system & other databases as per requirements, and also scheduled those backups.
• Managing the security of the servers, creating the new logins and users, changing the roles of the users.
• Involved in developing logical and physical modeling of the database using Erwin.
• Developing stored procedures, triggers, views, and adding/changing tables for data load and transformation, and data extraction.
• Used SQL Server Profiler to trace the slow running queries and tried to Optimize SQL queries for improved performance and availability.
• Involved in optimizing code and improving efficiency in databases including re-indexing, updating statistics, recompiling stored procedures and performing other maintenance tasks.
• Involved in installation and configuration of SQL Server 2000 and SQL Server 2005 with latest Service Packs
• Developed presentation layer (user interface) using ASP.NET, CSS, XHTML.
• Worked with ASP.NET Web Forms, ASP.NET State Management, ASP.NET Caching features, Securing ASP.NET Web Applications.
• Used custom .NET assemblies for Script Task in SSIS. (sn.exe, Gacutil.exe)
• Developed presentation layer (user interface) using ASP.NET, CSS, XHTML.
• Worked with ASP.NET Web Forms, ASP.NET State Management, ASP.NET Caching features, Securing ASP.NET Web Applications.
• Provided 24/7 production support for the production database and also to the code deployed into the production environment.

Environment: MS SQL Server 2008,SQL Server 2005 Enterprise Edition, OLTP, OLAP,T-SQL, MDX, Web Services, Excel VBA, Microsoft SharePoint Foundation 2010, FAST Search Server 2010 for SharePoint, Microsoft Office SharePoint Server 2007 (MOSS 2007),Performance Point Services (PPS), SAS Performance Management, Oracle 10g, ASP.NET, MS Access 2007, T-SQL, and SQL Server 2005 Manager  Studio, T-SQL, SQL Analyzer and Enterprise Manager and SQL Agent.

COX COMMUNICATIONS, GA                                                                      JAN 2007-APR 2008 MS SQL SERVER DEVELOPER

Cox Media Group, Inc., a subsidiary of Atlanta-based Cox Enterprises, is an integrated broadcasting, publishing and digital media company that includes the national advertising firms of Cox Reps.  Campaign Fulfillment Center (CFC) Analytics project was implemented to automate the calculation and presentation of KPI relevant to the five departments that make up the CFC. The objective of this project is to provide an enterprise class reporting tool for the Campaign Fulfillment Center that can be expanded on as needs arise and supporting data is made available.

Responsibilities:

• Designed and Developed Option pricing software using Excel/VBA.
• Implemented the Black-Scholes Derivative Pricing Model using Excel VBA to fulfill trading needs in various financial sectors.
• Implemented VaR (Value at Risk) model for hedged portfolios in VBA/Excel using Monte Carlo Simulation.
• Computed various derivative prices, for instance, Forward, Swap, Interest rate swap.
• Create SSIS Packages to move the data from flat flies into sql server database
• By using SSIS For Each loop task move all the flat files into sql sever database
• Before loading the data to Sql server count the number of rows from flat flies and write to file status table
• Configure the SSIS package for Server name, database name, User name and Password
• Create the batch file of the SSIS package to run form command line and other third party
• Log all the errors generated by SSIS package into Sysdtslog90 table

• Involved in creating Web Services on the Reporting Server and consumed web services in the Web Forms to generate Web based Analysis Reports using MS SQL Reporting Services 2005
• Rectifying and performance tune the diamond data feed process. Debug, Performance tune and enable the DTS packages for error logging. Tuned the DTS packages which take minutes rather than hours load the same amount of data.
• Used custom .NET assemblies for Script Task in SSIS. (sn.exe, Gacutil.exe)
• Created Unit Test Plan, Test Scripts and participated in Testing during the UAT Testing
• Performance Tune the Stored Procedures, User Defined Functions and long running queries.
• Backing up system & other databases and restoring them as per requirements.
• Create Roles, logins, assigning rights and permissions.
• Worked with building OLTP application using Power Builder GUI/Case tools
• Created PL/SQL packages, Crystal Reports 9, and modifying existing PowerBuilder 10reports and user interface.
• Worked with tuning the application and reusing the component using Power Builder tool
• Developing, deploying reports using SSRS.
• Developed custom reports using SSRS
• Created Tabular and Matrix reports using SSRS
• Applying various release from time to time.
• Designed and Developed the User Modules using ASP.Net
• Designed and developed various forms and screens using ASP.Net
• Monitoring the Server, Diamond feed process and Disk space on production server. Maintaining the server to perform optimally.
• Used Performance Monitor and SQL Profiler to find long running queries and then optimize the queries to enhance the performance of database server.
• Involved in creating Web Services on the Reporting Server and consumed web services in the Web Forms to generate Web based Analysis Reports using MS SQL Reporting Services 2005
• Used custom .NET assemblies for Script Task in SSIS. (sn.exe, Gacutil.exe)
• Created Unit Test Plan, Test Scripts and participated in Testing during the UAT Testing
• Performance Tune the Stored Procedures, User Defined Functions and long running queries.

Environment: Windows NT, Power Builder, Excel VBA,MS SQL Server 2005, SQL, T-SQL, .NET, SQL Query Analyzer, Profiler, XML, Web logic, Java, Cognos, JavaScript, Erwin, VSS.

CELGENE PHARMACEUTICALS                                                               DEC 2005- DEC 2006 MS SQL SERVER DEVELOPER

Clients use Celgene's applications to sell complex goods and services over intranets, extranets, and the Internet. Infotech's software helps clients develop and deploy online sales channels that guide their customers through the selection, configuration, pricing, and fulfillment process for consumer goods, loans, and insurance. The software also suggests optimum product configurations (based on sales objectives, marketing information, and product constraints). Celgene primarily serves clients from the manufacturing, retail, and consumer goods sectors. Worked as a lead Oracle developer,  responsible for requirement analysis, design, document, development, enhancement and support of the reporting data warehousing application.

Responsibilities:

• Implemented SSIS for data transformation logic process.
• Created SSIS packages for the data cleansing/transfer and transformation.
• Worked with SSIS for data integration in SQL 2005/2008 environment.
• Using Data Transformation Services (DTS) an Extract Transform Loading (ETL) tool of SQL Server to populate data from various data sources, creating packages for different data loading operations for application.
• Installation and configuration of MS SQL Reporting Services (SSRS)
• Used Reporting Services (SSRS) to schedule reports to be generated on predetermined time.
• Developed Custom Selection of reports ordering using SQL Server Reporting Services. (SSRS).
• Good Experience in designing, building and deploying the Cubes with SSAS.
• Performed data imports from Oracle and Teradata databases.
• Tuned SQL queries using TOAD.
• Sketched Entities, Attributes and designed integrated, accurate De-normalized Object Oriented Multi-Dimensional Star Schema, Data Model (Conceptual, Logical and Physical) to fit the objective of business being automated using ERwin designer.
• Installation of Replication Server, Configuration and Monitoring the replication between two sites, implemented Transactional Replication, writing scripts for automation, for creating publications, articles and running the snapshot agent job, so that the same scripts can be used from system test to production.
• Running DBCC consistency checks, and fixing data corruption in application databases.

Environment: MS SQL Server 2005, MS Office, Visual basic 6.0, XML, (Enterprise Manager, Query Analyzer), SSIS, SSRS, SSAS, Windows 2000/XP.

InXStech, HYDERABAD, INDIA                                                                       MAR 2003 –APR 2005

ORACLE DEVELOPER/SPECIALIST

InXStech provides innovative, practical and quality solutions that are cost effective and flexible, addressing the technology needs of the 21st Century organisations. The company is committed to provide high quality customer services resulting in lasting customer relationships. The solutions are designed with a special insight into using innovative processes and software technologies that provide best-in-class solutions to clients while enabling enterprises to fulfill their business needs and compete successfully in the global market place.

Responsibilities:

• Identifying functional requirements, analyzing the system, providing suggestions, and design as per requirements and testing the design.
• Coordinated with team members in business requirement analysis.
• Design and development of the application. Created Database Objects (indexes) to boost the performance of the Application.
• Extensively involved in coding of Triggers, Packages in the Application Level at each and every Transaction.
• Developed reports for purchase orders, sales orders, and goods issued and goods receipt. Coded database procedure to calculate average purchase price of material for current financial year for costing purpose.
• Database Triggers, Cursors were used for the Data Validation at every Transaction level. Created Oracle instance, table space and UTL settings. Developed, Tested and Migrated the Oracle PL/SQL scripts to Production. Developed, Tested and Migrated Unix Shell Scripts.

·        Coded well-tuned PL/SQL procedures at server side. Performed loading of data to the Oracle tables using SQL* Loader Scripts.

• Developed conceptual design document with prototyping of User Interface, involved in estimation and detailed scheduling of various modules.
• Identifying database requirements and was involved in designing the database for various banking modules.
• Created stored procedures, functions and packages for applying the business rules.
• Performance tuning and optimization achieved through the management of indices, table partitioning and optimizing the SQL scripts.

Environment: Oracle 8i/7.x, MS SQL Server 6.5/7.0/2000, T-SQL, PL/SQL, SQL, UNIX, SQL*Loader, HTML 4.0, VB 6.0, Windows 2000/XP.

Download Resume Format