SUMMARY:

DBMS/RDBMS: MS-SQL Server 2008 r2/2005/2000, Oracle Database 11g/10g/9i , T-SQL, PLSQL,SQL Loader.

BI ETL Reporting Tools : SQL Server Integration Services SSIS ,SSAS ,SSRS, QlikView Tool in Target Pro 4.7 ,Microstrategy,T-SQL using Stored Procedures, indexing, aggregation, pivot queries, query optimization.

Tools: Visual Studio 2008/2005/2003, Toad Reporting Services.

Database Connectivity: ADO.NET, OLEDB, and ODBC.

Front End: ASP.net, C .

Version Control Tools: - TFS,VSS,SVN.

Languages: C, C , PL/SQL.

Web Knowledge: XHTML, XML.

Systems: Windows 7, XP, Vista, UNIX, Windows 2000, Windows NT, DOS.

WORK EXPERIENCE

• Having good experience in BI suite - using integration services SSIS for ETL Extraction, Transformation and Loading , reporting services SSRS for creating different types of reports using SQL query's and analysis services SSAS for design and developing complex cubes and MDX query's.
• Well versed with the knowledge of RDBMS concepts and experience in writing joins, sub queries indexes, views, store procedures and function using SQL Server, data warehousing i.e. OLTP OLAP systems.
• Expertise in creating index , views, Joins, complex stored procedures, effective functions, and appropriate triggers to facilitate efficient data manipulation to maintain data consistency.
• Experience in extraction, transformation and loading ETL of data flows using SSIS with complex integration of SQL Server, Oracle.
• Expert in writing T-SQL, data migration for DTS 2000 Data transformation services packages to SQL Server 2005/2008 using ActiveX script task to support business logic in packages, data cleansing, data scrubbing.
• Expert in understanding and querying complex Oracle databases 10g/11g as well as an ability to understand the business rules that apply to the data.
• Sound knowledge of SQL server administrative skills including, backups, disaster recovery, database maintenance, user authorizations and database creation.
• Good in dimensional data modeling using SSAS, cube partitioning, optimization, creating aggregations
• Created formatted cross-tab, conditional, drill-down, top n, summary, form, sub reports, Ad hoc reports, parameterized reports, interactive reports custom reports
• Experience in providing SSRS server level, item level security accessibility to various reports in multi-user environment.
• Good in creating dashboards, scorecards and building reports.
• Manage and retrieve data from a variety of sources and perform statistical analysis using SAS and SPSS.
• experience in PL/SQL, Sybase, Oracle Apps, Oracle SQL plus, Forms Reports 6i, 9i 10g SQL Server 2005/2008, Toad tool, SCM tools, VSS, HTML, XML, and JIRA tracking tools, analysis, design, implementation and administration of business intelligence solutions with Microsoft SQL server 2008/2005/2000 in development, testing production.
• Exposure to all phases of software development life cycle SDLC with in-depth knowledge of agile methodology, enterprise reporting life cycle, SQL server migrations, change control rules, problem solving skills and escalation procedures.
• Excellent communication, analytical skills, self-learning abilities and leadership quality.
• Excellent analytical and problem solving skills in designing, developing, and implementing innovative business process and providing system solutions using new approaches, technology and training.
• Thorough subject knowledge, Strong analytical skills to solve complex technical issues and Troubleshooting skills with an ability to perform in a challenging environment.
• Solid understanding of PL/SQL and ability to write scripts to automate and manage data, performance tuning, SQL Query optimization and Drive to automate process and procedures which are manual.
• Experienced in interacting with business users/ partners/ Stakeholder to analyze the business process and requirements and transforming requirements into screens, designing database, documenting and rolling out the deliverable.

WORK EXPERIENCE

• Currently working with Fusion Global Solution since
• Worked as a Software engineer in Hexaware Technologies Ltd. since May-2011 to Aug-2012 .
• Worked as a Developer in ABM Knowledgeware Limited since Jun-2008 to Jan-2011 .
• Worked as a Developer in Nippon Data Systems Ltd. since July-2007 to May-2008
• Worked as a Software engineer in Sanvik Computer Consultant Pvt. Ltd. since Sep-2005 to July-2007

PROJECT EXPERIENCE

Sr. Business Intelligence

Application and tools: SQL Server 2008 , BI tool SSIS/SSRS/SSAS .

Confidential

Description: Confidential Medicare Medicaid programs and assist the nation's elderly to meet hospital medical and other health cost. Medicare is available to most 65 years of age and older who are receiving disability benefits from social security or railroad retirement board and those having end stage renal disease. Medicare types of plans used for enrollment Part A Hospital Insurance , Part B Medical Insurance , Part C Medicare Advantage Plans and part D Prescription Drug Coverage .

Roles and Responsibilities:

Application Developer.

• Gathering the project requirements during define and analyze phase for Fazal Part D Process.
• Understanding the client requirements and convert the business requirement into technical detailed document.
• Impact analysis on the existing system due to upcoming development and align with the business partner for impact of new changes and identify their scope.
• Managing Data model design and preparing the ETL Mapping details for upcoming changes.
• Create Complex T-Sql Stored Procedure, ETL Packages and SSIS packages to import and export data.
• Writing the Store Procedure based and involves in optimize of the store procedure, tracking the store procedure performance periodically.
• Create new SSIS and SQL Server packages for 2015 Group and Individual enrollment for enrollees to identify the eligibility queue process.
• Creating batch process using SSIS packages for files Send and receive from Infox and DM46.
• extracting data from a large variety of sources, transforming and loading to a SSAS database.
• Involve in OLTP and OLAP data modeling techniques and a demonstrated ability to interpret Entity Relationship Diagrams.
• Involve in the development for upgrade the application functionality and changes, based on the requirement.
• Responsible for managing the project deliverable and schedule.
• Attending onshore/offshore staff meeting and providing updates for Fazal part D project.
• Coordinates with offshore for developments task, and involves in coding, peer review, unit testing and system integration testing in developments phase.
• Responsible to provide data discrepancy report and solution for discrepancy.
• Report and fix the production issues to the client manager and take appropriate action to bring the issues to closure.
• Maintain the best practices and RDMS best concept for writing the store procedure and maintain the ETL tools.

Confidential

Front End: ASP.net, C Application.

Scripting Language: JavaScript, AJAX, JSON, JQuery.

Description: Confidential is a leading provider of high-quality single family residences for rental acrossConfidential. They work on satisfies the each family's individual needs with documented the history of the each owner and tenants details, they provide wide verity and high quality data / information from dataware housing project about owner and tenant all over the Confidential. They work on Property Life Cycle Status Leased, Vacant, Trustee Occupied, For Sale and Property Life Cycle Phase Pending Moving, Eviction, Pre Rehab, Rekey, Inspection, Rent Rate .Based on all property phase and status , data warehouse take care of all the transaction and processing information using dataware house Dim and Fact Tables.

Roles and Responsibilities:

Sr. Business Intelligence

Data warehouse developer

• Gathering the project requirements during define and analyze phase for Construction portal data warehousing projects.
• Understanding the client requirements and convert the business requirement into technical detailed document.
• Impact analysis on the existing system due to upcoming development and align with the business partner for impact of new changes and identify their scope.
• Managing Data model design and preparing the ETL Mapping details for upcoming changes.
• Create Complex T-Sql Stored Procedure, ETL Packages and SSIS packages to import and export data.
• Using SSAS create dimensions, cube partitioning, optimization, aggregations.
• extracting data from a large variety of sources, transforming and loading to a SSAS database.
• Writing Custom MDX query to create SSRS dashboards reports.
• Build Front-end Graphical user interface and report prototyping.
• Involve in OLTP and OLAP data modeling techniques and a demonstrated ability to interpret Entity Relationship Diagrams.
• Involve in the development for upgrade the application functionality and changes, based on the requirement.
• Create summary reports using pivot or crosstabs summary data.
• Responsible for managing the project deliverable and schedule.
• Attending onshore/offshore staff meeting and providing updates for Construction Portal data warehousing projects.
• Coordinates with offshore for developments task, and involves in coding, peer review, unit testing and system integration testing in developments phase.
• Responsible to provide data discrepancy report and solution for discrepancy.
• Report and fix the production issues to the client manager and take appropriate action to bring the issues to closure.
• Writing the Store Procedure based and involves in optimize of the store procedure, tracking the store procedure performance periodically.
• Maintain the best practices and RDMS best concept for writing the store procedure and maintain the ETL tools.

Confidential

Description: Confidential is the Capital market industry's most comprehensive resource for system integration, design, development, implementation, consulting, and customer service operations. My project is involved support and software development.

• Developed Adhoc Queries for Finance department. Designed and Developed AR Reports, Daily Payment Reports, Ledger Reports using Oracle Toad Reporting Services for Data Analyst.
• Used SSIS for large Data Migration Tasks.
• Developed Statements, Invoices, Notices and Violations that are sent to SunPass Customers.
• Designed and Developed Toad Reports and Stored Procedures for Audit and Finance departments to suit their needs.
• Integral part of the Production Support Team on a biweekly rotation basis. Modified existing complex analytical and ad-hoc queries to run faster using OLAP approach.
• Analyzed financial data using graphs and pictures in SSRS for predicting future data. The level of automation achieved due to deployment of this project helped the department view the entire MDX Turnpike Authority's financial situation on a daily basis in real time and reduced considerable amount of manual work resulting in huge savings and efficient operations.
• Knowledge in designing and developing data warehouses, data marts and business intelligence using multi-dimensional models such as star schemas and snow flake schema for developing cubes using MDX.
• Deploying SSRS Reports to allow the business users to interact to those reports and implement securities for sensitive reports.
• Create Complex T-SQL Stored Procedure, ETL Packages and SSIS packages to import and export data.
• Create summary T-SQL reports using pivot or crosstabs summary data.
• Developed SQL and Oracle stored procedures and Packages and Scripts for reconciliation purposes for various divisions in MDX and developed Toad and SSRS Reports approx. 240 and deployed to the server. Concerned persons are given access to the location where the reports are on the server so that they can run the reports themselves which helped minimize or eliminate unnecessary delays.
• Designed and Developed SRS Reports and Toad reports and Stored Procedures and Packages and Scripts using Oracle and SQL for Audit and Finance departments to suit their needs. This project helped the department to view the entire SunPass and Authority account's call centers call volumes on a daily basis automatically and reduced considerable amount of manual work to Call Center Managers and Customers Turnpike Authority .
• Designed Collections work flow and developed stored procedures and reports using Oracle and SQL.
• Performed detailed Data Analysis using DI tools to establish trends in current data for traffic and revenue to predict future forecast up to 12 months that helped effective budgeting and efficient resource allocation.

Confidential

Description: Rules driven process intended to create a best price for the firm all accounts will calculate a market value based upon the Best Price regardless of whether it is a Bid or Mid required account as this is required for all of our internal records to consistently value and report firm level data ex. AUM . Performance Composites and other firm level data require that a consistent price is used for all securities regardless of client reporting requirements Securities are priced on the last business day of the month given that client reporting is required on the first business day of the month. Ad hoc valuation reports are done by portfolio managers which require the daily run of the Best Pricing process.

Roles and Responsibilities:

• Analyze the requirement and distribute work among the team.
• Design Develop complex SSRS reports
• Create SSIS packages to data import and export
• Create database objects tables, stored procedures, functions, views
• Deploy SSRS, SSIS objects into UAT/Production environments.
• Create Complex T-SQL Stored Procedure, ETL Packages and SSIS packages to import and export data.
• Create summary T-SQL reports using pivot or crosstabs summary data.
• Reduce Vendor Cost Avoid duplication
• Reduce Operations cost and error Avoid sending prices from system to system
• Minimize exposure Same price from a given vendor for the same security across all systems.
• Improve Quality of Prices Better system for selecting the best price utilizing pricing hierarchies
• Ensures price for each security Every security receives a price even if one or more vendor feeds are not available at a given time.
• Ensure pricing of held securities Avoid unnecessary research on securities that are not held

Description: RGIS Retail Glossary Investment System uses Inventory operations to manage the inventories which are conducted on a day to day basis. RGIS are used by account owners and district offices to manage their inventory cycles, plan their events, schedule their stores and people, enter employee time sheets and approve customer invoicing.

Roles and Responsibilities:

• Developed a menu driven application to facilitate data entry and generate reports using FORMS and REPORT.
• Enhancement on the forms and creating a new forms and new report UI.
• Understanding the client requirements by studying functional document.
• Write SQL queries, Triggers, Functions, Procedures, cursors and Packages.
• Create summary reports using pivot or crosstabs summary data.
• Involved in the preparation of test data and Data setup for UAT support.
• Write the Scripts, compiles and executes.

ABM Knowledgeware Limited

Confidential is stand alone application and is mainly used for marketing purposes. The PAS application allows the user to create a new campaign, modify an already existing campaign, or delete an ended campaign application is mainly work for creating new proposal ,Modify the existing proposal , convert proposal to contract after the second call then convert to Endorsement. Quotation and Proposal creation takes particular standard days converting from Quotation to Proposal and according that Re-Quote and Q2P is processed for further renewal process.

Roles and Responsibilities:

• Understanding the client requirements by studying functional document.
• Enhance Existing forms.
• Write SQL queries, Triggers, Functions, Procedures, and Packages.
• Involved in the preparation of test data and Unit test Plan.
• Write the Scripts, compiles and executes.
• Developed Statements, Notices and Invoices that are sent to Pike Pass customers approx. 500,000 every month automatically.
• Part of the Production support Team. Manage two servers. Taking Backups and scheduling Jobs and Checking the Status of the Scheduled Jobs.
• Take Care of the Online Payments Processing by the customers. Automatic scheduling the payment process every night that post into their accounts. In case of failure sending messages support team automatically.
• Converted number of existing eActuate and Crystal Reports to SRS 2003/2005. Modified and optimized all the existing approx. 75 stored procedures including indexing to suit the coding requirements of SQL Reporting Services SRS .
• Designed and Developed 200 SRS Reports for Payroll, Pike Pass and Toll Divisions.
• Designed and Developed SRS Reports and Stored Procedures for Audit and Finance departments to suit their needs. This project helped the department to view the entire OTA's financial situation on a daily basis automatically and reduced considerable amount of manual work.
• Designed and Developed Work Order in SRS Reporting Services for all OTA staff. This project helped the inventory department to be able to view the status of all supplies in just one report on a daily basis and maintain the stock more precisely and reliably.
• Used OLAP approach for future budgeting and forecasting, Marketing and Sales, Financials Reporting, Management Reporting.
• Developed stored procedures for reconciliation purposes for various divisions and developed Reports and deployed to the server. Concerned persons are given access to the location where the reports are on the server so that they can run the reports themselves.
• Created Automatic Subscriptions to the reports which run and email to the address in the subscriptions at a stipulated time on a daily basis to different departments.

Description Market department provides Market Trade License to various businesses like Sweet Shop, Timber mart, dairy products etc. They also renew this issued license as per defined renewal schedule against license category. It could be year wise, day wise or month wise renewal. Corporation regularly inspect the site even after the license is issued, in case of some deviations found related authority like market inspector can suspend or cancel the issued license after issuing show cause notices. Market department gives permission to carry out certain business/profession in the jurisdiction of corporation, under the Sections defined in Bombay Provincial Municipal Act, 1949. This department also entertains changes in license business name and transfer license to multiple license holders through a service. The department hierarchy is as follows, this system takes care of issuing new license providing duplicate copy of license, renewing the issued license, inspecting the issued license, canceling and changes in business name for the issued license. It maintained the history of all licenses as changes happens against the issued license.

Role and responsibilities: Worked as Software Developer, Understanding the client's requirement and implement module in PL/SQL, Oracle Forms Reports 10g. Prepare Unit test documents of the delivered product.

PLSQL, Oracle Developer Suite 10g Forms Reports, SQL Developer, VSS.

Description: Food License Department provides license to Manufactures, Packers, Sellers, Stores, Distributors, etc. They also draw food samples for testing, which is done by Food and Drug Administration FDA . This department gives permission to carry out certain business/profession in the jurisdiction of corporation, under the Sections defined in Confidential. They also renew the issued license as per defined renewal schedule against license category. It could be year wise, day wise or monthlies renewal. They also inspect the site even after the license is issued, in case of some deviation they can suspend or cancel the issued license after issuing show cause notices. This department also entertains changes in license like, Change in the name of business through service. The department hierarchy is as follows, This system takes care of issuing new license, renewing the issued license, inspecting the issued license site, canceling and suspending issued license. And change in the name of business. . It maintains the history of all licenses as changes for the issued license.

Role and Responsibilities: Worked as Software Developer, Understanding the client's requirement and implement module in PL/SQL, Oracle Forms Reports 10g. Prepare Unit test documents of the delivered product.

Confidential

PL /SQL SUSE Linux Enterprise Server 9, Oracle Developer Suite 10g Forms Reports, Oracle 10g AS

Description : NDS come with the idea about finance ERP Solution and It contain main finance Part divided in three sub module for accounting like below.

• Master Maintenance -Schedule Master, Sub Schedule Master, GL Master, Currency rate master.
• Transaction -Opening Balance, Voucher Entry, Reverse voucher, bill passing, bank statement entry, bill Adjustment against voucher.
• Reports-balance sheet, profit loss Account reports etc.

Role and Responsibilities: Worked as Software Engineers, Understanding the client's requirement Programming on Oracle 10g, PLSQL with Developer 2000 forms 10g, reports 10g. Involve in functionality testing of the delivered product. Implementation of ERP software at different Client sites, giving User Training, Made new business area, modification in reports from Report 10g.

Windows 2003 server, Sybase, Oracle Developer Suite 10g Forms Reports.

Description: Project for the complete software requirement of all the Sahakari Bhandars, shopping malls spread all over India. This software handle purchase, sales monitoring system, Bank transaction, bank reconciliation, Daily cash transactions ,Payment Type, debit credit notes details is maintained and According classification, groupings other masters, reports of parties are generated. Role to understand the forms and the reports modules already created and make any changes as per the requirement of our Client.

Roles and Responsibilities: Extensive interaction with business user for requirement collection and validation of the system Design of the User Interface, Business components developed various modules of application using forms, reports and PLSQL. Extensive system study and evaluation of system specification in consultation with the end user. Participating in the database design group, Continuous interaction with end user throughout software development life cycle.