Thursday 2 February 2017

SQL Developer looking for new project last project Completed Yesterday.....

Sushma
 developermaxm@gmail.com                                                                                       302-355-2347

PROFESSIONAL SUMMARY

  • 9+ years of experience in Design, Development, Implementation and Maintenance of Data warehouse applications as an ETL/OLAP and OLTP Developer in MS SQL Server 7.0/2000/2005/2008. 
  • Experience in designing and implementing ETL environments using ETL strategies as well as tools like SQL Server BI Tools (SSIS and SSRS).
  • Extracted data into Data warehouse Facts and Dimensions tables using SQL SERVER 2000/2005 Integrated Services (DTS/SSIS).
  • Very good experience and knowledge on SCD Types (Type1, Type2) and Change Data Capture (CDC).
  • Exposure in Data Modeling using Star/Snowflake Schema Design, Data Marts, Relational and Dimensional Data Modeling, Fact and Dimensional tables, Physical and Logical data modeling using Erwin.
  • Experience in Microsoft SQL 2005 Server migrationfromSQL Server 2000, Integration Service (SSIS), Crystal Reports and Reporting Service (SSRS).
  • Excellent in High Level Design of ETL SSIS Package for integrating data from sources (Excel, CSV, flat file, Text Format Data).
  • Expert in Creating, Implementing, Configuring and deploying the SSIS Packages from one server to other.
  • Expert in migrate the DTS Packages to SSIS Packages by using Package migration Wizard.
  • Expert in Designing SSIS Packages to Extract, Transform and Load (ETL)/ DTS data into the data warehouse from heterogeneous databases such as Oracle, DB2, MS Access.
  • Extensive experience working with repositories such as Team Foundation Server (TFS), and Cheetah.
  • 24/7 on call Production Support.
                                         
TECHNOLOGY

Languages/ Web Tools:T-SQL, Visual Studio 2005/2008/2010/2012/2014,VB.NET,C#, VBScript.
Databases/ RDBMS:   SQL Server 2008R2/2008, 2005/ 2000.
Operating Systems:    Windows XP/ 2000/ NT 4.0/ 98/ 95, and UNIX
Version Control:Team Foundation Server (TFS), Cheetah Tracking System
Other Packages/ Tools:MS Visio, SSIS (ETL), SSRS, Erwin, and Microsoft Office SharePoint Server 2007, Microsoft Office Access, Microsoft Excel.


PROFESSIONAL EXPERIENCE

Scottrade, St. Louis, MO        Jan 2015 - Till date
Role: Senior Database Developer

Responsibilities:
  • Gathered requirements from business analysts and documented them based on functional specifications.
  • Created design document for the package that needs to be developed which includes the name, description and mapping information of the package.
  • Worked on SharePoint 2007 for storing the design documents and documentation.
  • Developed ETL package with different data sources (SQL Server, Flat Files, Excel Source files, etc.) and loaded the data into target tables by performing different kinds of transformations using SQL Server Integration Services.
  • Integrating heterogeneous data from sources such as DB2, Oracle,flat files and MS Excel to SQL Using SSIS.
  • SSIS Components used extensively in the project are Merge join, Derived Columns, Look UP, Conditional Split and Multicasting.
  • Designed and developed various packages using various task like For Each Loop, File System Task, Execute SQL task, Execute Process Task, Execute Package Task, Send Mail Task.
  • Used SharedObjects to configure the SSIS package.
  • Performed activities like analyzing and improving the databases objects.
  • Performed Index analysis for tables and came up with more efficient solutions to use Clustered and Non-Clustered Indexes for significant performance boost of the existing product databases.
  • Created complex Stored Procedures for validation process & for loading data from the staging area to the product database in SQL 2008.
  • Developed Complex Stored Procedures views, tables and generated TSQL script for application.
  • Customized & optimized the existing stored procedures according to the Technical specifications and performed troubleshooting on the existing stored procedures.
  • Used TFS to work on SSIS packages, Database objects and to write unit test cases for the stored procedures written.
  • Replaced old back office AS400/iSeries source files with stored procedures for new back office system.
  • Recreated packages with the new source as stored procedure to meet the requirement.
  • Transformed end data into xml format and sends it to message queue through SSIS packages.
  • Created rollout script for all the packages and objects that are to be deployed to QALAB and QFinal.
  • Fixed various issues raised in testing environments.
  • Created documentation for each and every package that has been worked on.
  • Provides status updates to supervisor on weekly basis.
  • Maintained technical knowledge through trainings and other measures.

Environment: SQL Server 2008/ 2008R2/2014, T-SQL, SQL Server Integration Services (SSIS), Microsoft Excel 2007, Visual Studio 2008/2010/2013, SharePoint 2007.

Sentara HealthCare, VA Beach, VAMar 2013 –Jan 2015
Role: SQL(SSIS) Programmer/DBA
.....
.
.
.
.
.

Thanks & Regards,

Bhaskar
Sr. Bench Sales Recruiter|| IT RESOURCES INC ||

Phone: 302-355-2347 || bhaskar@it-resinc.com|| www.it-resinc.com || 220 Continental Dr, Ste#104, || Newark || DE || 19713 ||
Description: Logo


ROR consultant available for new Project.



Satya
302-233-2347
Summary:
·         7+ years of Full-stack design, development and back-end administration for high volume web applications using Ruby, Ruby On Rails, MVC, HTML5, Angular.js, Backbone.js, Twitter bootstrap, JavaScript, CSS, JQUERY and databases like SQL, MySQL, Oracle and noSql databases like MongoDB, Redis. Application Servers (Web sphere, Web Logic) 
·         Proficiency in Front End technologies like HTML5, CSS3, Javascript, jQuery, Angular JS, Node JS, Sass, twitter Bootstrap, foundation, CSS, LESS, SASS, Coffee-script, HAML, Liquid, jade etc. 
  • Strong experience in Object-Oriented Analysis, Design and development of applications using Core Java, Servlets, JSP, JDBC, RMI, Multithreading, Eclipse and Tomcat.
·         Focus on sustainable web architecture using ROR application Framework and Ruby Language
·         Design, build, and maintain efficient, reusable, and reliable Ruby code.
·         Proficiency in Programming Ruby, JAVA, PYTHON and C++ 
·         Designed and developed custom Rails applications specific to client's needs.
·         Expert knowledge of SOA principles including SOAP, REST and  JSON
·         Solid understanding of OOPS and writing reusable ruby libraries publishing GEMS.
·         Expert in MVC concepts, MOCKING, ORM and RESTFUL
·         Implement Persistence layer using JPA, Hibernate & writing PL/SQL queries based on Hibernate criteria API.
·         Using Version One Agile Project management tool to estimate/track/organize deliverables of the project.
·         Configure and deploy the application on Web Sphere application server and involved in writing the build scripts using maven.
·         Using clear case client and views for clear case code repository.
·         Participate in code reviews, troubleshooting, bug fixing, preparing test environments, execute User acceptance testing and providing production support. 
·         Performance tuning of the customized programs during development and post implementation phase.


Client: VMWARE, CA                                                                                                                                                    July ’15 - Till Date
Role: Ruby on Rails Developer     
Roles & Responsibilities:
·         Developed application in agile development methodology using Ruby 2.2.5, Rails 4.2, JavaScript, JQuery, HTML, CSS BDD and pair based programming.
·         Unit tested the code with RSpec and Jasmine tests, and managed the code with Github.
·         Used Restful API in communicating with third parties.
·         Worked in Postgres database on simple queries and writing Stored Procedures for normalization and de normalization.
·         Used Rails 4.2, AJAX, JSON, jQuery, Node JS and Angular JS to design the front end of the application. Back end of the application is developed mainly using Active Records.
·         User Interface for website with ERB, RJS, Ruby for View, Controller, Model in Ruby on Rails Framework on OS X Operating System.
·         Designed and developed few Gems in accessing and managing files on FTP servers of clients along with encrypting and decrypting files as necessary.
·         Project managing upgrade of ASP applications to RoR and build of customer-facing applications.
·         Used MVC framework for the back-end while the front-ends were built using the Blueprint CSS Framework and HTML
·         Created Restful http services to interact with UI and was responsible for building the code to QA and Dev environments daily.
·         Participated actively in preparing the documents for best practices and architecture.
·         Involved in preparing and presenting the ROR boot camps to improve the coding standards of employees according to the client requirements.
·         Liaise with user interface (UI) designers, engineers, and product managers for multi-phase project.
·         Involved in Database Migration using Active Records, also involved in using Action Controller, Active Resources, Fixtures and Action View in Rails.
·         Refactored code as required while working on the features and enhancements.
·         Designed and maintained RoR code. Implement upgrades, patches, code releases, and database changes.
·         Was actively involved in unit and functional testing, debugging, security, and documentation efforts.
·         Collaborated with Product Management and User Experience experts regarding product definition, schedule, scope and project-related decisions.
·         Managed, collaborated and coordinated the work of an offshore development team.
·         Received several appreciations and compliments from users and Client regarding changes to site features.

Environment: Rails 4.2, CSS, HTML5, jQuery, Angular JS, Node JS, Bootstrap, Rspec, JSON, Github, Postgres, LINUX, Virtualization.

.....
.
.
.
.
.

Thanks & Regards,

Bhaskar
Sr. Bench Sales Recruiter|| IT RESOURCES INC ||

Phone: 302-355-2347 || bhaskar@it-resinc.com|| www.it-resinc.com || 220 Continental Dr, Ste#104, || Newark || DE || 19713 ||
Description: Logo


Wednesday 1 February 2017

Lotus Notes Consultant



Ph: 302-355-2347.
Email Id: developermaxm@gmail.com

Summary of Qualifications:
  • 12+ years of experience in Lotus Notes in client and web applications, IBM Certified Application Developer - Lotus Notes and Domino 6 / 6.5
  • 5+ years of Project Management (Leadership) Experience
  • Proficiency in project management, system modeling and business process re-engineering
  • Considerable experience in large scale Lotus Notes infrastructure design and deployment
  • Excellent Communication skills and coordinating with Business users to resolve the issues for different regions.
·         Technically strong in programming languages and operating systems,
  • Expert in developing and testing the applications in client and web environment in agile methodology.
  • Extensive experience in Administration of Tasks like Notes ID creation, recertifying Notes users, Creating Groups, Mail-in Database, Replication and Sametime.
  • Expertise in Software Development Life Cycle, Specifications,Requirements gathering,Designing, Developing, Administering Lotus Notes Workflow applications.
  • Extensive experience with Lotus Notes 9.x, 8.x, 7.x, 6.x, 5.x, Lotus Script, Notes Formula Language, Data Integration LEI, Xpages, OLE, VB Script, Java, Java Script, HTML, DHTML, XML, SQL and CSS
  • Interfaced with host from Lotus Notes to transfer files to IMS server using FTP process
  • Fetching data from DB2 tables by using SQL, Lotus Notes Databases and excel sheets
  • Pushing data from Lotus Notes Database into SQL Server by using SQL and Lotus Notes Databases
  • Lotus Notes Roaming capabilities – designed in Windows scripting
  • Experience in installation, maintenance and troubleshooting the Lotus Domino infrastructure
  • Experience with Team Studio Configuration and its integration to Domino Databases to Control Access towards Design Elements
  • Experience in Handling the Quality Audits and required Document preparations.
  • Experience on Migration from Lotus Notes to SharePoint
  • Experience on Migration from Lotus Notes to .Net
  • In depth Knowledge in Salesforce
  • Well versed in Technical Documentation of Projects
  • Worked individually and also with Small / Large Teams
  • Looking forward for challenging work in demanding time schedules. Well versed in working in a team environment to accomplish common goals

Professional Experience:

PricewaterhouseCoopers (PwC), Tampa, FL                       Jul’13 – Present
Role: Lotus Notes Developer       
Project Description:

PwC has awarded a contract to TCS to assist in the technical enhancements for all the applications in Lotus notes/domino platform at PwC. These applications fall under various line of services like Assurance, Tax, Advisory & IFS (Internal firm services). As part of support to client - we are involved in requirement gathering, analysis, prepare of state of understanding, development of new and existing enhancements, testing and production support for Lotus Notes applications.

Responsibilities:

·         Involve in gathering and analyzing the business requirements. The requirement discussion phase will include extensive interaction with the clients.
·         Performing the impact analysis
·         Estimate the effort needed to execute the application
·         Planning and allocation of work
·         Analyze, design, develop and implement Web based applications
·         Responsible for overseeing the quality procedures related to the project.
·         Built test strategy, test cases and setup environment for testing.
·         Obtain approval from client for specification and test plans.
·         Testing and recording the test results in HP Service Manager.
·         Preparation of delivery document
·         Application Support (Fix high priority/urgent issues)
·         Experienced in Lotus Enterprise Integrator, HTML, Style Sheets, XML, Java Script, XPages, Lotus Script and Lotus Notes Formula Language.
·         Worked in onsite-offshore model and be able to provide technical assistance to offshore team.
·         Flexible & possess excellent communication skills.
·         Able to work as Lotus Notes Tech Lead.

·         Sending weekly status reports & summary report every week on all activities

.....
.
.
.
.
.

Thanks & Regards,

Bhaskar
Sr. Bench Sales Recruiter|| IT RESOURCES INC ||

Phone: 302-355-2347 || bhaskar@it-resinc.com|| www.it-resinc.com || 220 Continental Dr, Ste#104, || Newark || DE || 19713 ||
Description: Logo

QA Rama Profile



Rama Gullapalli
developermaxm@gmail.com                                                                302-355-2347

                                                     PROFESSIONAL SUMMARY
·         12+ years of experience in Information Technology.
·         Extensive experience in the development and testing of various applications based on audio/video, UI and storage.
·         Experienced on Object Oriented Design techniques and hands-on with the entire software development life cycle.
·         Experienced on solid understanding of Data Structures, Algorithms and Object-Oriented design.
·         Developed applications in embedded Linux and Windows environment with C/C++ and GCC, G++.
·         Have working knowledge of storage related protocols and industry wide applications, with respect to SAS/SATA, Fibre channel, RAID, disk drive interfaces and error recovery mechanisms, and server hardware and software.
·         OS knowledge to include Windows Server 2003/2008/2012 and Linux.
·         Ability to write functional specifications and design documents.
·         Creating and executing test plans, test cases, test procedures, test scripts, and defect tracking with the test management tools, such as, Clear Quest and Test Plus.
·         Worked in many applications independently in various phases of design, development, bug fixing, enhancement, unit testing, regression testing, implementation, documentation and maintenance.
·         Experienced working on Windows and Linux architecture.
·         Possesses excellent communication skills and is a team player.

                                                  TECHNICAL EXPERIENCE
Languages:                              C, C++, C#, Java, SMIL, SQL, PL/SQL, XML, HTML and PERL.
Operating Systems:                  Windows, Windows Azure, UNIX, LINUX and Mac.
Databases:                               Oracle 9i and SQL server 2005/2008.
GUI:                                         GTK+
Tools:                                      GDB, KDB, Make, Scon, BREW and VS 2005/2008/2010/2015, Eclipse, JMeter, Source Insight, UML, VMware, Doxygen, Clear Case, Clear Quest, and Meat grinder.
Domain expertise:                    GSM, GPRS, TCP/IP Protocol suite, SIP, RTSP, RTCP, VOIP, HTTP, SMTP, POP3, IMAP, DNS, DHCP, Network Programming and Linux Internals

                                                      PROFESSIONAL EXPERIENCE

SdiRM                                                                                                                               Jun16 – Present
QA Automation Engineer
Client: Hewlett-Packard, Roseville, CA
HPE Software defined infrastructure RM (SdiRM) manages HPE Servers and deploys StoreVirtual VSA nodes and cluster.

Responsibilities:
·         Responsible to develop and execute test cases for RESTful API and functional testing
·         Responsible for both automation and manual testing
·         Responsible to write and run automation regression test cases
·         Responsible to set up the complete test environment
·         Participate in Test Driven Development and Scrum meetings

Environment: VMware vCenter server 6.0, VCSA 6.0, ESXI 6.0, Hypervisor, HPE StoreVirtual, HPE OneView, Git, Java, Selenium web driver, TestNG and Jenkins.