SUMMARY

• Over 26 years of industry experience, with over 14 years of MS SQL Server / Oracle Development experience in Health-care Insurance, Finance, Telecommunications, and Manufacturing avionics and Motor domains with expertise in MS Sql server 2010 and MS SQL Server 2005/2008 suite of products like SSIS, SSAS, and SSRS, MS Silverlight 4.0, Informatica 9.4 associated with Business Intelligence BI reporting and analytics in an agile development utilizing multiple platforms
• Experienced in Data Extraction, Transformation and Loading ETL between Homogenous and Heterogeneous Systems using DTS and SSIS of MS Sql server 2010 and MS SQL Server 2008 respectively. Manage SSRS environment including user access, automating / scheduling reports, Sharepoint Integration for SSRS
• Expert in Creating, direct Configuring configuration or development of BI dashboards and reports by using SSRS and als involved in Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services SSIS .
• Expertise in Developing and Extending MS SQL Server Analysis Services 2007 SSAS Cubes, Data Mining Models, Deploying and Processing SSAS objects, and writing MDX queries.
• Experience in creating Tableau Dashboard and maintaining dynamic web applications by using Java, PHP. Familiar with IBATIS persistence framework and Hibernate Framework.
• Experienced in generating On-demand and Scheduled reports for Business Analysis or Management decisions using MS SQL Server Reporting Services 2005/2008 SSRS .
• Expert in writing Parameterized Queries for generating Tabular reports and Sub reports using Global variables, Expressions, Functions, Sorting data, Defining Data sources and Subtotals for the reports using SSRS 2005.
• Strong experience in Stored Procedure/TSQL and PL -SQL coding, Performance Tuning, and Query Optimization. Conducts ad-hoc analysis and studies for the business as needed in ORACLE as well as SQL server Database. Prepares activity and status reports for active projects as required.
• Experience in collaborates with the business and technical resources necessary t fulfill reporting activities.
• Highly proficient in T-SQL and PL-SQL for developing complex Stored Procedures, Triggers, Tables, User Defined Functions, Relational Database models and Data integrity, and SQL joins.
• Experience in Procedural Object-Oriented Programming OOP in Web-based environment distributed n-tier Client/Server SAP and PeopleSoft Internet Architecture PIA , Relational database RDBMS BORM.
• Experienced in Logical and Physical Database design development, Data Conversion, Normalization and Data modeling using ERwin and SQL Server Enterprise manager and asl familiarity with Ruby on Rails and related technologies. Experience with ASP .NET web application frameworks.
• Involved in all phases of software development life cycle: design, implementation and testing. In-depth knowledge of working and implementation of Crystal Reports, converting Crystal reports t SSRS Reports and in upgrading crystal reports 8.5/9.0/10 t XI.
• Expert in database creation, maintenance, monitoring, backups and recoveries. Specialized in analyzing, coding, implementing and creating complex query reports using Oracle 9i/ 10g/11g, SQL Server 2000/2005/2008 and DB2. Experience on Service quality management tools such as Remedy, JIRA, Mercury QC, and ClearQuest. Experience on configuration management tools such as ClearCase and VSS, PVCS.
• Experience in creating Jobs, Alerts, SQL Mail Agent, and Scheduled SSIS Packages. Good understanding on .NET framework especially in ASP.NET client/Server technology.
• Experience in working multiple projects and complex engineering activities while balancing priorities and schedules

Key strengths include:

• Experience in Business-driven technology planning with experience using Fit Gap Analysis processes on Enterprise Business Processes.
• Big 5 company IT experience
• Excellent problem-solving, technical writing and presentation skills
• Strong ability t work independently and ability t work within a diverse team
• Leadership, Team Building, and Motivation cross-discipline . Experience in giving direction for strategic technical decision making processes and experience in database and systems maintenance, high availability design, implementation and support, performance analysis and tuning, benchmarking and load testing.

TECHNOLOGIES

• IBM PC/compatibles, windows XP, IBM AIX, HP6200, Dec alpha UNIX machine, sun Solaris Server, Subversion, Windows NT/XP, MS windows
• HARDWARE:
• SOFTWARE:
• Peoplesoft 8.4, SQR, SAP, people tool, MS Sql-server 2010,MS Visual Studi 2010, MS SQL Server 2000/2005/2008, Informatica 9.4, T-SQL, Silverlight 4.0, ODBC, DTS, SSAS, SSIS, SSRS, Ibatis Framework, hibernate framework, Crystal Reports XI, Business Object XI, MS Access-97/2000, Excel, MS Visio, Erwin Platinum, HTML, XML, Windows NT/2000/XP/2003 server. Subversion, APEX IBM Rational Rose , PDM/Engineering tools, Unix, ADA, Python, C, C , ADA 95, D 178B, ARINC 664, ARINC 429, Visual Basic, OpenGL, HTML, ASP .NET, Java, J2ee, Relational databases such as, Oracle 9i/10g, Sql-server 2000/2005, TCP/IP, API, Flash, SQL, Doors, Crystal Reports XI, Visio, MS Project, MS Office, ASP .NET, Ftp and Visio, PDM Data warehouse, Clear-case, UML, Business Process Workflow, Use Case, Eclipse.

EXPERIENCE

Confidential

Web Content Developer /Automation Engineer

Responsibilities:

• Managing, maintaining, developing and deploying applications and databases in response t business needs.
• Perform database administration and development, as well as web development.
• Als involved in Data Extraction, Transformation and Loading ETL between Homogenous and Heterogeneous Systems using DTS and SSIS of MS Sql server 2010 and MS SQL Server 2008 respectively. Manage SSRS environment including user access, automating / scheduling reports, Sharepoint Integration for SSRS
• Involved in Creating, direct Configuring configuration or development of BI dashboards and reports by using SSRS and als involved in Fine-tuning ETL workflows designed in DTS and MS SQL Server Integration Services SSIS .
• Work with the business t add functionality t existing databases in production and als working on data extraction, Transformation and Loading ETL between Homogenous and Heterogeneous Systems using DTS and SSIS, SSAS and SSRS of MS Sql server 2010 and MS SQL Server 2008 respectively.
• Developed various Cubes by using SSIS and SSAS services and als created various reports drill down, summary, graphs, charts by using SSRS reporting services.
• Contributed t the overall development with the web development team and perform maintenance and updates t existing websites as requested.
• Assist team members with large-scale application development projects up t 6 months duration . Required t assist with documentation, planning and client liaison.
• Manage small-to-medium-sized projects for Domains/ Web developments, payment gateway integrations, interfacing with other applications.
• Support of existing applications, with phone support and other interaction with our clients.

Environment: Visual Studi 2010, C , ASP, .NET, Sqr, Crystal Reports XI, SQL-Server 2010, SQL/Plus, Toad, Application Manager, Oracle 10g, SQL, excel spreadsheet, xml tree, java, j2ee, crystal reports, spufi, Visio, MS Project, Ms.-access 2008, MS Office, insight, edi, import manager.

Confidential

Sr. Systems Engineer

• Responsibilities include migration from legacy systems t ASP .Net Platform with an Oracle 11g and SQL Server 2008 database on the backend.
• Involved in developing Stored Procedure/TSQL coding, Performance Tuning, and Query Optimization. Conducts ad-hoc analysis and studies for the business as needed in ORACLE as well as SQL server Database. Prepares activity and status reports for active projects as required.
• Implemented/migrated data from various different platform int a new Oracle application by using Informatica. Gather the new requirements for data integration. Involved in supporting the daily data movement. Informatica Data Archive improves application performance with large data volumes in key transaction tables through the use of Smart Partitioning.
• Involved in database administration and development - coordinated with businesses t improve the current system and add new functionalities t existing databases in production in the environment using DTS and SSIS, SSAS and SSRS of MS SQL Server 2008 and MS SQL Server 2010 respectively.
• Design and developed various Cubes by using SSIS and SSAS services of SQL -SERVER 2010 and als created various reports drill down, summary, graphs, charts by using SSRS reporting services.
• Analyze and fixed the bugs present in already existing reports. Developed many Matrix Reports, Drill Down Reports and Charts using SQL Server Reporting Services SSRS .
• Identified and worked with Parameters for parameterized reports in SSRS 2005. Generated Reports using Global Variables, Expressions and Functions for the reports.
• Deployed the generated reports directly on the client's workstation. Created many multi valued parameters in the reports.
• Created many Cascaded parameters in the reports using MDX and T-SQL. Improved Report Performance and performed unit testing. Built effective queries for high-performance reporting and rendered them t HTML, XML, PDF and Excel formats using Reporting Services. Optimized the performance of queries with modifications in T-SQL queries, removed unnecessary columns, eliminated redundant and inconsistent data, normalized tables, established joins and created indexes whenever necessary. Created the structure of the model and cube in MS Analysis Services 2008 .
• Analyzed and designed software and database solutions. Support existing data warehouse reporting platform and applications t ensure operational availability and scalability. Work directly with functional analysts and business users in understanding the information needs of the business and developing new data warehouse/BI functionalities or tools t meet these requirements.
• Assess existing and available data warehousing technologies and methods t ensure our Data warehouse/BI architecture meets the needs of the business unit and enterprise and allows for business growth. Provide recommendations on evolution of the architecture.
• Research, define and deploy BI improvement opportunities and streamline the business intelligence
• processes. Create detail design, work on development and perform code reviews. Analysis implementation of better performance strategies.

Environment: MS SQL Server 2000/2008, Informatica 9.4,SQL server Reporting Services 2008, Silverlight 4.0, SQL Analysis Server 2008,Crystal Reports XI, VSS, Microsoft Visual Studio, SQL Server Management Studio, MS Excel, T-SQL, Visual Basic, C , ASP, .NET, Sqr, Crystal Reports XI, SQL-Server 2007, SQL/Plus, Toad, FoxPro, Oracle 11g, UML, Business Process Workflow, Use case, API, CMMI, Six-Sigma Methodology, C/C , SQL/Plus, Toad, UML, MS-Access 2010, QMF, Mercury Test Director, API, BMC Software, SAP, PeopleSoft 8.4, SQR, people tool, Sql-server 2008.

Confidential

Sr. Software Engineer / Application Support

• The primary objective of this project t build a robust and intelligent system that will help Business people t strategize based on analysis of conformed Facts and Dimensions. Designing and implementing the ETL processes which involves collection of data from heterogeneous sources like LotusNotes Databases, Oracle 10g, SQL Server 2000/2005. Provide maintenance support for ETL systems. Creation of Datamarts. Incremental processes, LotusNotes Agents, Report Modeling, Creation of business reports, Dashboard reports, and als the maintenance of web reports using MS Reporting services 2005.
• Overseeing teammates in completion of structural coverage, report generation, and licensing software issues and support t the customers.
• Involved in database administration and development - coordinated with businesses t improve the current system and add new functionalities t existing databases in production in the environment using DTS and SSIS, SSAS and SSRS of MS SQL Server 2008 and MS SQL Server 2010 respectively.
• Design and developed various Cubes by using SSIS and SSAS services of SQL -SERVER 2010 and als created various reports drill down, summary, graphs, charts by using SSRS reporting services.
• Extracted and reviewed data from heterogeneous sources like Excel, CSV, Oracle, flat file, Text Format Data using SQL Server Integration Services SSIS from OLTP t OLAP. Developed logical and physical data models, designed data access strategies and wrote SQL code t access and manipulate data stored in relational databases.
• Implemented MS Analysis Services setup, tuning, cube partitioning, dimension design including hierarchical and slowly changing dimensions. Created calculated measures and dimension members using multi dimensional expressions MDX , mathematical formulas, and user-defined functions. Created different type of reports including Cross-tab, Conditional, Drill-down, OLAP and Sub reports using SQL Server Reporting Services SSRS .
• Gathered user requirements, drafted specifications, designed, documented and wrote test script for testing of all the report.
• Involved in Writing SQL Queries, Views and Stored Procedures on Sql server 2010. Designed databases for applications with requirements for large numbers of transactions, heavy access and high availability. Optimized T- SQL code. MS Silverlight 4.0 Development.
• Programming in MS-DOS Window NT , VMS/VAX Terminal , C Software applications such as Ultra-Edit, Apex ADA environment window and Eclipse 3.11 t modify code and sign-off on work assignments. Familiarity with Simulink software
• System Administration of the Rockwell Collins STS TIS department and Production Workflow and Management Information system PWMIS .
• Involved in design and architect and re-development of an existing VB 6.0 PWMIS with an SQL Server database on the backend. VB.NET application developed using the following layers: Presentation, Business Fa ade, Business Objects, Framework and Data.
• Redesigned SQL backend for new data structure and for normalization a Service-Oriented Architecture.
• Architecting Business functions and processes as services t increase usage across applications and de-couple the dependencies between business layers and published the publication pilot's guides, manuals and service bulletins t the RWEB.
• Involved in network administration for SS TIS department.

Environment: Sql-server 2007, ASP, .NET, SQL, Ada 95, Python, Informatica 9.4,C/C , C , ADA 95, DO178B, ARINC 664, ARINC 429, Visual Basic, OpenGL, HTML Crystal Reports XI, SQL-Server 2000, SQL/Plus, Clear-case, Remedy Software, Oracle 9i, UML, Business process Workflow, SAP Interface, Use case, Subversion, API, Import Manager, Microsoft Visual Studio, C , Six-sigma methodology, PDM/Eng central, SAP, Subversion

Confidential

Sr. ERP Consultant Sr. Software Engineer

• Re-development of an existing VB 6.0 document management application int a VB.NET Win-Forms application with a SQL Server database on the backend. VB.NET application developed using the following layers: Presentation, Business Fa ade, Business Objects, Framework and Data. Redesigned SQL backend for new data structure and for Normalization.
• Involved in Planning, Defining and Designing data based on business requirements and provided documentation. Upgraded MS SQL Server 2000 databases t 2005, using Detach/Attach, Back up Recovery and by Replication. Incorporated the DTS Packages int MS SQL Server 2005 Integration Services by
• using Package Migration Wizard and Execute DTS 2000 Package task.
• Created SSIS packages t extract data from OLTP t OLAP systems and Scheduled Jobs t call the packages and Stored Procedures.
• Created Alerts for successful or unsuccessful completion of Scheduled Jobs.
• Used various SSIS tasks such as Conditional Split, Derived Column etc., which did Data Scrubbing, including data validation checks during Staging, before loading the data int the Data warehouse.
• By using Informatics in PeopleSoft HR- and payroll-sensitive data classification accelerators, which gave team a head start t documenting which data needs t be protected within the applications and als helped how data gets replicated t multiple systems for different business users.
• Used ETL t implement the Slowly Changing Transformation, t maintain Historical Data in Data warehouse. Created Error and Performance reports on SSIS Packages, Jobs, Stored procedures and Triggers. Created Views t reduce database complexities for the end users.
• Created Sub-Reports, Drilldown-Reports, Summary Reports, and Parameterized Reports in SSRS.
• Performed T-SQL tuning and optimization of queries for reports that take longer execution time using MS SQL Profiler, Index Tuning Wizard and SQL Query Analyzer in MS SQL Server 2005. Performed Documentation for all kinds of reports, DTS and SSIS packages.
• Designed and implemented Stored Procedures and Triggers for automating tasks.
• Maintained the table performance by following the tuning tips like Normalization, Creating Indexes etc.
• Used the HTML code t make the Report Manager more functional and customizable.
• Evaluated database performance and performed maintenance duties such as Tuning, Backup, Restoration and Disaster Recovery.

Environment: MS SQL Server 2000/2005, T-SQL, MS SQL Server Integration Services 2005, MS SQL Server Reporting Services 2005, MS SQL Profiler, SQL Query Analyzer, SQL Server Index Tuning Wizard, Visual Studi 2005, Erwin v4.1, Windows XP, MS Office 2003/2007, MS Access, Crystal Reports XI, ADA, Visual Basic, C , ASP, .NET, Oracle 9i, UML, Business Process Workflow, Use case, C , ASP .Net. , Visual Basic 6.0, DB2, UML, FoxPro, Use case, MS-Access 2003, QMF, Mercury Test Director, API, BMC Software, Import Manager.

Confidential

Sr. ERP Software Engineer Consultant

• Extensively analyzed, designed, developed, implemented and maintained ERP based Financials Module - G/L, A/P, A/R, Billing, purchasing
• Tracked and resolved Customer Problems/Issues and conducted user training as required
• Involved in Design and architect of client's software system. Architecting business functions and processes as services t increase usage across applications and de-couple the dependencies between business layers
• Responsibilities include administering, re-development of an existing VB 6.0 with a SQL Server database on the backend. VB.NET application developed using the following layers: Presentation, Business Fa ade, Business Objects, Framework and Data