Hi, Greetings from HYR Global Source! I am Ramesh and working with HYR Global Source Inc. Please go through the below job description and let me know your interests ASAP. Reply with your updated resume and expected hourly rate.
*Position: Oracle Database back end developer with .Net* *Location: Kansas City, MO* *Duration: 12+ Months* *VISA Status: No Constraints* *Pay Rate: $Open/hr * We have multiple positions, client is looking more data base developer with .Net frond end development. Strong skills on Oracle, SQL Server, T-SQL data base. Expert in creation of data base tables, indexes, views, PLSQL packages and other database related objects · 7 Years of experience in .Net programming, Web programming, Data Analysis, Data Modeling, Database Design, Database programming, Implementation, Development and Testing of Database systems & Client/Server Application using SQL Server and BI environment. · As part of the team, extensively involved through the Software Development Life Cycle (SDLC) from initial planning through implementation of the projects. Capable of handling responsibilities independently as well as a proactive team member. · Extensive experience in working with Visual C#, ADO.NET, ASP.NET, Web Services, Visual Basic, VBScript, Jscript, XML, HTML, Database programming. · Highly proficient in SQL Server 2005/2008/2008 R2 RDBMS database development including T-SQL programming. · Well versed with developing complex Stored Procedures, Functions, Triggers, Views, Cursors, Joins and indexes with T-SQL. · Worked with T-SQL, DDL, and DML Scripts and established Relationships between Tables using Primary Keys and Foreign Keys. · Good working skills in Performance Tuning, Query Optimization and Running Database. · Experience in Up gradation of SQL Server 2005 databases to SQL Server 2008 by applying Service Packs and Hot fixes. · Good experience with data loading and data loading methods like SQL*Loader and DB - links, Import Export and Data Pump. · SQL Server 2008 OLAP database development including KPIs, Data mining, working with changing dimensions. · Strong experience in Microsoft Business Intelligence Tools including Integration Services, Reporting Services and Analysis Services. Configured report subscriptions both data driven and time driven. · Good Knowledge in Full Life Cycle development of Data Warehousing · Developed, monitored and deployed SSIS packages. · Expert in Data Extraction, Transforming and Loading (ETL) implementation using SQL Server Integration Services (SSIS) in OLTP and Data warehouse *Environment:* · Experience in creating Jobs, Alerts, SQL Mail Agent and Scheduled SSIS Packages · Created complex DTS Packages in SSIS for Data Migration from Oracle/Access/Excel Sheets to SQL Server 2005/2008 and Transformation. · Decent Working experience with Informatica 8.6.1. · Worked on Data modeling, creating star and snowflake schemas in SSAS. · Sound knowledge of Dimensional Modeling using Star Schema and Snow Flake Schema for faster, effective querying and Business Analysis Requirements. · Extensive experience in creating and managing reports using MSSQL Server 2005Reporting Services. · Hands on experience in developing Custom reports and different types of Tabular reports, Matrix reports, Adhoc reports and Distributed reports in multiple formats using SQL Server Reporting Services (SSRS) in Business intelligence development studio (BIDS). · Good Working experience in developing different types of Reports in SSRS such as Cross-Tab, Drill-Down, Drill-Through, Cascading, Parameterized and Sub-Reports using global variables, expressions, functions and custom code. · Strong experience in performance tuning and query optimization using tools like SQL Server Profiler, Database Tuning Advisor and Index Tuning Wizard. · Flexible, spontaneous, enthusiastic and project oriented team player with good communication and leadership skills to develop creative solutions. *Created ASP .NET web pages that provide new features and enhanced user experience* · Experienced in working with many complex SQL queries with joins, date functions, inline functions, and sub-queries to generate various reports. · Extensive experience in using T-SQL for developing complex Stored Procedures, Triggers, Tables, Views, User-Defined Functions. · Experience in using all kinds of Constraints, managing Indexes, Locks, troubleshooting deadlocks and handling the Isolation Levels. · Created and maintained Database Objects (Tables, Stored procedures, functions) in SQL. · Worked on various work orders to fix and find solutions to existing ETL code. · Worked with the Business users and the data/system analysts to understand the Business rules and Business requirements and updated the ETL code accordingly. · Conducted SSIS code review meetings and updated the ETL code after taking input from team members. Made sure that the code is in-line, with the set standards. · I got a chance to work with the Finance team created files like General Ledger and files to people soft team for Account Payables Check's and EFT's. · Got a very good opportunity to work on various correspondence parts by pulling out the data and generate letters for respective transactions on a policy. · Worked on conversion loading the data from the client on to our dev regions cycling them and checking for the issues and fixing them, Running metrics for client on bi-Weekly basis. · Automated the ETL jobs using UC4 scheduler and purged the unused objects. · Written and executed ETL test cases as part of testing the code before migrating to Production. · Analyzed the source data and decided on appropriate extraction, transformation and loading strategy. · Integrated with the end users to gather requirements, plan, build, test, deploy, document and apply change control process. · As part of the team, implemented Test Driven Development by working with the SA/DA/Tester before the actual ETL development has started. · Implemented Pair Programming, Code Reviews and Unit testing as part of Agile Methodology. · Handled successful production code fixes with minimum/no impact to business. · Designed and Maintained SSIS Packages for Importing and Exporting Data Migration and Conversion from Legacy Systems to SQL Server 2008. · Created, Maintained & Scheduled various reports in SSRS like Drill down and Drill through & Parameterized Reports using SQL Server Reporting Services SSRS · Configuration and Deployment of all the Reports (RDL, RDS) across various SDLC environments. · Created different reports using complex queries to create the datasets in SSRS · Used expressions in SSRS for various reports. · Responsible for deploying reports to Report Manager and Troubleshooting for any errors occurred during execution Regards, *Ramesh,* HYR Global Source Inc | An ERP Consulting Corp Mail to: [email protected] Work: *913-660-0755* -- You received this message because you are subscribed to the Google Groups "oraapps" group. To unsubscribe from this group and stop receiving emails from it, send an email to [email protected]. To post to this group, send email to [email protected]. Visit this group at http://groups.google.com/group/oraapps. For more options, visit https://groups.google.com/d/optout.
