Over 7 Years of extensiveexperience inthe software industry, which involves Analysis, Design, Development, testing and implementation of various Web based, Client Server applications & Data Acquisition systems.
Areas of Expertise
Â· 5 years development and testing experience in various Data base and data Warehouse environments like PL/SQL, SQL Server, ETL-SSIS, SSAS, SSRS.
Â· 4 years of experience in Web/Client Server Application development and testing using ASP.Net, C#, ADO.Net, VB.Net, SQL, HP- QC, XML, PL/SQL, UNIX, LINUX and HTML
Â· 4 years of extensive experience in Software Development Life Cycle (SDLC)
Â· 5 years experience in writing Stored Procedures, Views, Triggers, Functions and Complex SQL Queries on SQL Server 2005/2008.
Â· Performance tuning of SQL queries and stored procedures using SQL profiler and index tuning advisor.
Â· Experience creating new Database instance in Cloud system.
Â· Sound Understanding of Data warehousing concepts and Dimensional modeling (Star schema and Snowflake schema), Fact & Dimensional and ODS(Operational Data Store)
Â· Used complex expressions to Calculate, Group, Filter, Parameterize, and Format the contents of the report according to the requirement.
Â· Experience in BI suite – using integration services (SSIS), ETL (Extraction, Transformation and Loading), reporting services (SSRS) for creating different types of reports and analysis services (SSAS) for design and developing complex cubes, SSMS(Query Analyzer).
Â· Worked with SAP BI 7.0 to load the data from SQL and Oracle Servers.
Â· Analyzed Business Requirement Document (BRD), Functional Requirements (FRD) & System Requirement Specification Documents (SRD).
Â· Proficient in executing UNIX commands to view process Log Files to check the status of the process and analyzed output files to validate data.
Â· Root Cause Analysis, Post-Mortem Analysis, & accompanying documentation.
Â· Used MS Visio, Erwin tools to create Data Modeling Functional Spec Process Modeling
Â· Excellent troubleshooting and debugging skills, Knowledge of design, simulation and debugging of web based applications.
Â· Ability to meet deadlines, handle multiple tasks, and work independently under minimal supervision.
Â· Expert working with off-shore and on-shore teams spread across various time zones.
Â· Excellent technical, oral and analytical skills. Admirable interpersonal abilities and an efficient team player.
Education: B. Tech – Electrical& Electronics Engineering M. Tech – Electrical Power Engineering
Client: HP, TX Nov ’12 – Till Date SQL Developer
Project : EPEAT Modification
Â· Working in a team of developers/testers designing and developing a large enterprise application developed in ASP.Net, C#, SQL SSIS, SSRS, ETL, Linux and SQL Server 2008, Java, Oracle 11g. Â· Involved in all SDLC phases to implement the EPEAT Modification project for the DWF. Â· Developed and tested the queries, Stored Procedure which was linked to the EPEAT Modification field. Â· Involved in creating the new Database instance in HP Cloud system. Â· Developed ETL packages with different data sources (SQL Server, SAP, Flat Files, Excel source files, XML files etc) and loaded the data into target tables by performing different kinds of transformations using SSIS. Â· Created various reports using SSRS package like Customer information, Product and EPEAT status etc. Â· Data warehousing involving data warehouse analysis and design, multi-dimensional modeling, multi-dimensional cube design, Star / Snow Flake Schema Design, ODS, OLAP using MS BI (SSIS, SSRS, SSAS) Â· Actively participated in the design and implementation of Data warehouse methodology, metadata designs, schema designs etc. Â· Designed and created cubes in SSAS. Created sophisticated calculated members using MDX queries; designed and created aggregations to speed up queries and improve performance in SSAS. Â· Deployed and processed SSAS cube weekly to update information by using SQL Server Agent. Â· Performance tuning of SQL queries and stored procedures using SQL profiler and index tuning advisor. Â· Developed complex PL/SQL and T-SQL queries and Store Procedures. Â· Defined Indexes, Views, Constraints and Triggers to implement business rules Â· Developed Test Cases, Test plan and mapped requirements to test cases on the basis of Use Cases and Business Requirement Document using HP-QC & Caliber. Â· Used some of the UNIX commands to verify Logs while testing the application. Â· Involved in preparing the Daily Execution Status report and sharing with managers and leads.
Environment: HP – QC, MS Visio, VS2008, NET Framework 3.5, C#, ASP.NET, Oracle DB, SQL Server, Linux, VBScript, tidal scheduler, Erwin, SOA Architecture, Agile.
Client: Tetrapak, Denton, TX Jan ’12 – Oct â€˜12 Database Developer
Project : Data Acquisition System
Â· Work with business stakeholders, application developers, and production team to identify business needs and discuss solution options. Â· Working with various business groups while developing their applications, assisting in Database design, creating E-R diagrams. Â· Designed, developed and implemented the Machine Control DAQ system for Dairy. Â· Reviewed and Analyzed the Project Scope, Architecture, Requirement Specification and Functional Design documents. Â· Created SSIS packages for data Importing, Cleansing and Parsing. Extracted, cleansed and validated data from Excel, Text files and XML files using OLE DB connection. Â· Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases Â· Actively participated in the design and implementation of Data warehouse methodology, metadata designs, schema designs etc. Â· Deployed and processed SSAS cube weekly to update information by using SQL Server Agent. Â· Developed PL/SQL stored procedures, functions, packages, and triggers to implement business rules into the application. Â· Used SQL*Loader to load data from external system and developed PL/SQL programs to dump the data form staging tables into base tables Â· Utilized SSIS and SSRS to produce a Data Warehouse for reporting. Â· Build efficient SSIS packages for processing fact and dimension tables with complex transforms Â· Used ReadDaqData() and WriteDaqData()methods read operation from the DAQ and write to the DAQ Â· Administering the MS SQL Server by creating user logins with appropriate roles, monitoring the user accounts, creation of groups, granting the privileges to users and groups. Â· Used BCP command and T-SQL command to bulk copy the data from Text files to SQL Server and vice versa Â· As a team member I was involved in development and testing DAQ application using Measurement Studio DAQ, ASP.NET, C#, Java, SQL, ADO.NET etc Â· Plan, design, develop and implement application database objects, such as stored procedures, Triggers, user Roles and views etc. Â· Build and maintain SQL scripts, indexes, and complex queries for data analysis and extraction. Â· Prepared the Test Scenarios and Generated Test Scripts for the UAT. Â· Tested applications and resolved complex problems throughout SDLC. Â· Assisted new and existing clients with integration and data conversion activities. Â· Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
Environment: HP-QC, ASP.NET, C#, Java & SQL Server 2005, VS2005, SAP, Oracle, ADO.NET, MS Visio, VBScript, Erwin, Labview, Oracle 9i
Client : Custom Data Solutions, Sterling Heights, MI Dec ’10 – Nov â€˜11
Project : Market Manager Customization
Responsibilities: Â· Reviewed functional specs for phase III of the project and build technical specs accordingly. Â· Developed PL/SQL stored procedures, functions, packages, and triggers to implement business rules into the application. Â· Used advanced SQL features like Inline views, Joins, Decodes, Indexing, Bulk Inserts, Bulk collects and analytical functions Â· Created SSIS packages for data Importing, Cleansing and Parsing. Extracted, cleansed and validated data from Excel, Text files and XML files using OLE DB connection. Â· Used SSIS to create ETL packages (.dtsx files) to validate, extract, transform and load data to data warehouse databases Â· Used format triggers, after/before Pform triggers in the reports. Also worked on PL/SQL charts. Â· Experienced in developing Custom Report and different types of Chat Reports, Tabular Reports, Matrix Reports, Ad hoc reports and distributed reports in multiple formats using SQL Server2005 Reporting Services (SSRS). Â· Created various database objects like tables, views, sequences, functions, and indexes Â· Involved in the data analysis and data discrepancy reduction for the source and target schemas Â· Responsible for application unit testing, Production Support, Version Control, Planning and Training. Â· Develop API’s to do validations and load validated data into database after logging appropriate error, warning and informational messages Â· Enhancing the existing packages for better performance and providing on-going support to existing applications and troubleshooting serious errors when occurred Â· Created detailed technical specifications, developed application and system code, and participated in code reviews and module testing, regression testing and supported ongoing maintenance
Environment: Oracle 10g, PLSQL, SQL Server 2005, Visual Studio 2005
Client : Cliprealty, Sunnyvale, CA Aug ’08 – Nov â€˜10 SQL Developer
Project : Real View
Â· Developed the web pages using ASP.NET, HTML, SQL and ADO.NET. Â· Responsible for testing the corporate Web site and its updates. Â· Involved in the As-Is To-Be process with business stakeholders and other teams Â· Deployed the generated reports directly on the client’s workstation. Responsible for transferring the data using SSIS packages. Â· Written stored procedures, triggers, T-SQL queries in SQL Server. Â· The position involved writing test cases based on functional specification and feature descriptions. Â· Analyzed result files in order to extract data on software failures, reproduce the problems, and report software defects. Â· Worked closely with the Business Users with User Acceptance testing (UAT). Â· Developed Test Plan and Test cases to accomplish SIT and Production testing. Â· Utilized MS Internet Explorer and Netscape Navigator for functional testing. Â· Perform quality assurance and testing of SQL server environment. Â· Ensure best practices are applied and integrity of data is maintained through security, documentation, and change management.
Environment: HP-QC, ASP.NET using VS 2005, C#.NET, & SQL Server 2005
Client: Protel Systems, India June ’06 – July â€˜08 Electrical Engineer
Project : PC Based Instrumentation
Â· Installed NI Device Drivers for Visual Studio: NI-DAQmx, NI – VISA and NI – 488.2 Â· Created Measurement Studio Applications using Windows Forms & Consol applications and with Web Forms Controls and Analysis. Â· Developed custom software using Lab VIEW and integrated data acquisition and instrumentation hardware systems, including analog, digital systems, GPIB, RS-232. Â· Created Measurement Studio NI – DAQmx Applications, Instrument I/O Applications. Â· .NET Class Libraries: Digital Signal Processing, Filtering, Generation, Peak Detection etc
Environment: VB.NET, ADO, SQL, NI Test stand, UNIX, C, C++, ORACLE
Is this your Resume?
Fill out this form to request for your resume to be removed.