*Hi All,* *Hope you are doing well…..*
*Please send resumes to v...@hclglobal.com <v...@hclglobal.com>* *ROLE* *Sr SQL Developer* *LOCATION* *Lansing MI* *DURATION* *LONG TERM* *RATE* *$65/HR ON C2C* *CLIENT* *DIRECT* *INTERVIEW TYPE* *In-Person Only* *State Experience Highly Preferred* *U.S. Citizens and those authorized to work in the U.S. are encouraged to apply* *Note: For H1 While submitting I need consultant I 797 OR ID Proof.* *The Application Software Engineer must have the following skills and expertise* · Application Software Engineer with 8 or more years of demonstrable working experience in application software design, development, and implementing of medium-to-large scale applications. · The ability to work with a technical team and business experts in: · analysis and design of reports and integration packages in a CRM Dynamics environment, · The ability to translate complex business into complex queries and stored procedures in T-SQL, · Experience with Microsoft Azure and Service Bus for Windows, · Development, testing, debugging and SSRS reports and SSIS packages, · Experience integrating two disparate systems · Ability to execute and validate test plans for reports, · Use programming knowledge to design and develop complex stored procedures and reports, *Skills Preferred * The Application/Software Engineer is preferred to have the following skills and expertise: · Expert Skills Visual Studio 2012 · Expert in writing complex queries and stored procedures in T-SQL · Expert in writing reports with SSRS. · Experience managing source code via Team Foundation Server *Experience Required * The Application Software Engineer must have the following experience: · Application Software Engineer with 8 or more years of demonstrable working experience in application software design, development, with SSRS and SSIS experience. · Eight years’ experience programming in client/server applications · Five years’ experience analyzing business requirements, generating project specifications and in turn developing code, and applying knowledge of computer programming techniques and computer languages · Five years unit testing and performing peer reviews of developed code to insure conformity to standards and design best practices. · Five years’ experience programming in SQL and/or Transact-SQL. · Two years’ Experience with CRM Dynamics utilizing SSIS · Expert level skills in MS Project, MS Excel, MS Word, MS PowerPoint *Experience Preferred * The Application Software Engineer is preferred to have the following experience and expertise: · Minimum five years’ experience, developing stored procedures using SQL, in an enterprise environment. · Minimum five years’ experience developing SSRS reports and SSIS packages. · 3 years’ experience writing reports in a CRM or like type environment. · Education Required This position requires a Bachelor's Degree in Computer Science, Information Systems, or other related field. *Years of Experience* Advanced experience in the IT industry and as a programmer analyst. *Skills* *Required* *Years Used* *Last Used* 8 or more years of demonstrable working experience in application software design, development, with SSRS and SSIS experience *8 Years* Two years’ Experience with CRM Dynamics utilizing SSIS *2 Years* Five years’ experience programming in SQL and/or Transact-SQL *5 Years* Experience with Microsoft Azure and Service Bus for Windows *1 Years* The ability to work with a technical team and business experts in Development, testing, debugging and SSRS reports and SSIS packages *1 Years* Five years unit testing and performing peer reviews of developed code to insure conformity to standards and design best practices *5 Years* Ability to execute and validate test plans for reports *1 Years* Use programming knowledge to design and develop complex stored procedures and reports *1 Years* Expert Skills Visual Studio 2012 *1 Years* Expert in writing complex queries and stored procedures in T-SQL *1 Years* Expert in writing reports with SSRS *1 Years* This position requires a Bachelor's Degree in Computer Science, Information Systems, or other related field. *Position Description * The Programmer Analyst will perform analytical programming assignments pertaining to the development, enhancement and maintenance of reports and integration packages and procedures in a CRM Dynamic environment. The position also involves the utilization of project management and systems design in a technical development environment. The P/A will need to be familiar with SQL, SSRS and SSIS languages. The P/A will need to understand the strategic direction of the Michigan Department of Corrections (MDOC) and the supporting IT systems and architectures. The ASE is responsible for adhering to state of Michigan standard development methodologies - the State Unified Information Technology Environment (SUITE), Systems Engineering Methodology (SEM), and Project Management Methodology (PMM). The position also involves the utilization of project management and systems design in a technical development environment. *Job Description* Includes descriptions detailed earlier as well as programmer analyst experience in specialized IT technologies which may not be widely used or are new to the industry. Plans, develops, tests, and documents computer programs, applying knowledge of programming techniques and computer systems. Evaluates user request for new or modified program, such as for financial or human resource management systems, clinical research trial results, statistical study of traffic patterns, or analyzing and developing specifications for bridge design, to determine feasibility, cost and time required, compatibility with current system, and computer capabilities. Consults with user to identify current operating procedures and clarify program objectives. Formulates plan outlining steps required to develop program, using methodologies such as structured analysis and design or object-oriented development. Work involves assisting in analyzing systems outlines to develop programs for computer applications, writing solution programs, documenting the methods and procedures used in program development, and testing and correcting programs. Works under moderate supervision with limited latitude for the use of initiative and independent judgment. Develops block diagrams and machine logic flowcharts to represent operations and data flow for applications. Captures requirements using industry standard development frameworks and tools. Designs reports, forms and letters along with computer terminal screen displays to accomplish goals of user request. Reviews screens, reports, forms and letters designs with users. Converts project specifications, using industry standard tools, such as object-oriented tools and code generation, into sequence of detailed instructions and logical steps for coding into language process able by computer, applying knowledge of computer programming techniques and computer languages. Enters program codes into computer system. Enters commands into computer to run and test program. Reads computer printouts or observes display screen to detect syntax or logic errors during program test, or uses diagnostic software to detect errors. Replaces, deletes, or modifies codes to correct errors. Analyzes, reviews and alters program to increase operating efficiency or adapt to new requirements. Writes documentation to describe program development, logic, coding, and corrections. Writes manual for users to describe installation and operating procedures. Assists users to solve operating problems. Recreates steps taken by user to locate source of problem and rewrites program to correct errors. May use computer-aided software tools in each stage of system development. May train users to use program. May oversee installation of hardware and software. May provide technical assistance to program users. May install and test program at user site. May monitor performance of program after implementation. May specialize in developing programs for business or technical applications. Please send the below details for submission process with updated Resume Full Name: Phone: E mail: Skype Id: LinkedIn: Interview Availability: Rate: Location: Re Location: Availability: Visa Status: Visa Expiry: Date Of birth: Last 4 Digits of SSN: Thanks & Regards *Ram Chapala*|Technical Recruiter *HCL Global Systems Inc.* 24543 Indoplex Circle, Suite #220 Farmington Hills MI 48335 Phone: 248 473 0720 Ext:175 Fax: 248 473 0721 Email Id: v...@hclglobal.com Gtalk: ram.ch...@gmail.com Certified MBE |www.hclglobal.com *Note:** This is not an unsolicited mail. If you are not interested in receiving our e-mails then please reply with subject line Remove*