Vijay Verma Email & Phone Number

Los Angeles, California, Us

• Database Oracle 10g, Oracle 8i/9i, Oracle 11g, SQL Server, MS Access,• Software / Tools: JavaScript, VBScript SQL Server. Knowledge of BI Publisher. Microsoft Visio, People Soft Enterprise EV4, SQR (Reporting Tool). PL/SQL, Oracle Fusion Middleware, Oracle Forms 10g, Oracle Forms 6i/9i, reports 6i/9i, Jdeveloper 10g, IBM RAD 7.0, Eclipse, IBM Rational Clear Case, Visual Source Safe, PVCS, Toad, SQL Plus Editor, PostgreSQL, ERWIN, SQL Developer, VB.NET, ADO.NET, XML, HTML.• Operating System: Windows 2000/NT, UNIX, LINUX, Window XP Professional,• Server: Oracle Internet Application Server, Weblogic Server, Windows NT/2000 server, IIS.• Experience with other enterprise-class IWMS programs may be considered Additional Qualifications• Programming experience in any language, hands on Experience in JavaScript programming• Good to have integration experience with Web Services, Middleware Solutions such as TIBCO, J2EE, J2ME, JSP, Servlets, Java Scripts, JDBC, AJAX, XML, SQL Server 2008 R/2012, Oracle 9i/10g/11g, MS-Access, My SQL, EDI, XSLT, .Net or other integration technologies• Knowledge of Salesforce or other cloud platform architecture, scoped application development and complex platform integrations• Mobile web application experience• Waterfall• Experience with Java development• Experience in automating UI testing using tools like Selenium• Working knowledge of web accessibility guidelines, data object and page optimization practices, etc.• Strong knowledge and experience with T-SQL & PL-SQL, SQL Server,• SQL Server Integration Services (SSIS), and Microsoft Business Intelligence Studio (BIDS)

Los Angeles, California, Us

• Experience in Data Analysis, Data Migration, Data Validation, Data Cleansing, Data Verification and identifying Data Mismatch.• Extensive experience in writing complex SQL Queries and PL/SQL scripts.• Have tested several complex reports generated by Business Intelligence tools Cognos, Business Objects BOXI, MicroStrategy, Cognos including dashboards, summary reports, master detailed, drill down and score cards.• Expertise in test management using HP Quality Center, Microsoft TFS and maintained Versioned objects using Rational ClearCase.• Excellent skills in overall Defect Management/Problem Solving, which includes reporting and tracking bugs using HP Quality Center, Rational ClearQuest, Bugzilla.• Experienced in interacting with Clients, Business Analysts, UAT Users and Developers.• Understanding of Data Models, Data Schema, ETL and created extensive store procedures, SQL queries to perform back-end data warehousing testing.• Experience in testing reconcile (initial) and delta (daily) ETL loads.• Good experience in Data Migration testing and Web Interface testing.• Good experience using Informatica Workflow Manager for running/managing workflows and Informatica Workflow Monitor for monitoring the workflows and checking the session logs.• Strong experience in UNIX shell scripting, writing UNIX wrapper scripts and monitoring the UNIX logs to check for any errors.• Extensively worked on Batch Scheduling tools Autosys to run and monitor ETL jobs.• Knowledge on the phases of agile methodology and scrum Methodology.• Excellent interpersonal, communication, documentation and presentation skills.

• Adv SQL Developer & Data Mining Analysis• CHR Solutions (BSS/OSS) to NetCracker and ICOMS• Migration for ICOMS for following category: Customer, House, Equipment’s, Customer Service, Telephone, Directory Listing, Features, Circuit, Customer Party, Bill with Relations, Bill to Address, Promotion , Ledger and Non- Standard• Planning and Analysis: An in-depth process for modeling, mapping, and validation to ensure efficiency in the migration process.• A Clean Process for Migration and Consistency: Executing an optimized cycle of extract, transform, load, test, and cleansing enables delivery of complete data and the cleanest level of data.• Post Process Validation and Mapping: Once migration has been completed, validating across primary keys, other data, object references, and related associations.• User Validation and Testing: Ensuring that the ultimate users of the data are satisfied with the outcome of the process.• Database Mining with Data Extraction from Omnia E to NetCracker Technology ICOMS• Advance PL/SQL code, Advance level SSIS, SSRS, Excel , Meeting Notes• Generate SQL and PL/SQL scripts for model automation, scheduling and deployment throughout the enterprise.• Day to Day meeting with NetCracker and implements there ICOMS mapping requirements.• Output Fixed Width Format Files, CSV, XLS etc.• Enterprise Mining Algorithms into a workflow using the SQL Query node

Houston, Tx, Us

• SQL Developer DATA Migration • CHR Solutions (BSS/OSS)- contractor• Worked on OSS migration of Omnia 360 to Omnia 360 NextGen.• Created overall migration flowchart for customer presentation.• Worked on source data – Analyze, Extraction, Joining, Mapping, Target API models.• Implemented PL/SQL codes for XML Extraction.• Reverse engineer the XML schema library that needed to extra data into table structure.• Used SSIS tools to generate flat files.• Had weekly call with the customer on project issues and updates.• Analyst the API models from source and destination application to import the data.• Successfully helped migration to Omnia 360 Next Gen with minimal fallout.

Los Angeles, California, Us

• Optimized company website and blog increasing its organic search traffic by 200% and revenue share by 23%.• Performed a keyword research that refined for the top 20 keywords from 500 keywords that contributed most traffics to company's website.• Collaborated with Web Design, IT, and Merchandising departments on SEO and online marketing agendas.• Optimized and changed the loading time on the home page from 8 seconds to less than 1 second by reducing images on the home page, reducing the bounce rate from 65% to 32%.• Managed Instagram and Facebook feeds maintaining a steady flow of content and engagement with followers.• Developed on-page and off-page organic search strategy with several locations that increased organic traffic 34% over three months.• Assisted with the management of an extensive Google AdWords account comprised of over 400,000 SKUs, and over one hundred organized campaigns and Ad Groups.• Successfully increased open rate on emails from 14% to 35% by testing email titles and changing the times the emails were sent out.• Redesigned URL structure, on-page content, navigation, and linking strategy.

Los Angeles, California, Us

• Full Stack Project Successes Fully Completed Admin Control Panel• Frond END Dot Net MVC Web App MS SQL Database• J query Bootstrap• Advance JavaScript Ajax Call• Custom Slider• JQgrid Customized as NEED Responsive HTML• HTML5• IIS Setup

Los Angeles, California, Us

• Experience on latest .Net Framework (3/3.5/4/4.5/ CORE 1.0) with N - tier Architecture model and design patterns.• Experience with jQuery, JSON client-side light weight programming language skills.• Excellent knowledge in Remoting, SOAP, XSD, XML, XSLT, XHTML, CSS.• Experienced in a fast-paced Agile Development Environment including Scrum, and Extreme Programming.• Experience with UI skills like HTML, CSS, XML, XSLT, JavaScript, Angular 2/4/5, JQuery, and AJAX.• Providing a better UI with the bootstrap framework, and CSS3• Excellent programming skills and strong in Object Oriented programming (OOP) concepts.• Strong Knowledge in End-to-End Software Development Life Cycle, Application Development Methodology (ADM) and Agile Methodologies, ER Diagram.• Strong Object-Oriented Analysis and Design (OOAD) and C#, VB.NET Programming skills.• Developed Responsive Web designs (RWD) using Media Queries and Bootstrap.• Familiar with MongoDB clusters, Java scripting to load unstructured data into sharding environment.• Proficient in Data Analysis, Design and Data Modeling, using LINQ (LINQ to SQL, LINQ to XML), Entity Framework, ADO.NET and T-SQL in developing• Data Access Layer, writing SQL Queries, Stored Procedures and User Defined Functions. Good experience in SQL Server 2000/2005/2008/2012/2016, Oracle and MySQL• Experience in building Single Page Applications (SPA) using HTML5, CSS3, Bootstrap, AngularJS, ASP.NET MVC, Bootstrap, ASP.NET Web API, Entity Framework.• Expertise in ASP.NET, ASP.NET MVC, ADO.NET, ASP.NET Web Services.• Good Experience in configuring and managing IIS 6.0/7.0- WEB Server.• Extensive working experience in working with Agile (SCRUM), Waterfall and Test-Driven Development (TDD).• 7 years of experience in Analyzing, Designing, Developing, Documenting, Testing and Deploying Web, Windows, Console applications with extensive experience in Microsoft Visual Studio environment using C#, VB.Net, ASP.NET, ADO.NET.

• Created Stored Procedures, Triggers, Functions, Indexes, Views, Joins and T- SQL code for applications.• Managed indexes, statistics and optimized queries by using execution plan for tuning the database.• Responsible for performance tuning and Optimization of stored procedures using SQL Profiler and Database tuning wizard.• Designed and developed data models for the data warehouse using star and snowflake schema.• Used SSIS to create ETL packages to validate, extract, transform and load data to data warehouse and data marts.• Designed SSIS Packages to extract data from various data sources such as Access database, Excel spreadsheet, and flat files and load data into destination databases for further Data Analysis and Reporting.• Experience in using multiple data flow transformations provided by SSIS such as Data Conversion, Conditional Split, Merge and Union all.• Scheduled and executed SSIS Packages using SQL Server Agent. Generated Reports using Global Variables, Expressions and Functions for the reports.• Actively involved in generating Matrix, Sub reports and complex reports with multi value parameters for the analysis of Performance.

• Planned, developed, tested, implemented SQL Server db import/export process.• Created, enhanced, maintained essential Crystal Reports for Operations and HR departments.• Created additional ad-hoc reports using MS Access for Operations Director. Received MS Sharepoint 2010 application development training covering Visual Studio 2010, Sharepoint Designer 2010• Developed plans for Sharepoint 2010 rollout by department.

Los Angeles, California, Us

• Coordinated meetings with subject matter experts to gather requirements for Xerox Contract Database• Designed Contract Retention database using SQL Server 2008 technology Developed data mapping documentation to establish relationships between source and target tables including transformation processes• Developed and implemented SSIS 2008 ETL processes to load data from source files to target tables• Created complex SQL views and stored procedures to join multiple tables for contract data interface files

Los Angeles, California, Us

• SQL Server Database Developer• Recommend and implement database structural changes, security policies and backup/recovery specifications.• Experience in the migration of data from Excel, Flat file and XML to MS SQL Server by using conversions and DTS utility.• Proficient in extracting, transforming and loading of data using SQL Server DTS and SSIS.• Experience writing complex SQL Queries and Procedures. Day to Day included manipulation of XML, CSV and XSL files.• Extended knowledge of using VB.net and VBScript for data manipulation. Exclusively assisted supervisor in managing over 20 real estate clients including HGTV and NYTimes.• Received in house training on Endeca and implemented the software into our systems.

• Developed and maintained a thorough knowledge of key business processes, requirements and key success factors.• Gathered and collected information from existing systems, analyzed program and time requirements.• Created and developed documentation in work assignments such as program code and technical documentation.• Interfaced with other IT groups and customers, both internal and external.• Provided support for testing new releases and products.• Researched and recommended next-generation programming languages and tools.

Bachelor'S Degree, Computer Science, Engineering, Math

Diploma In Oracle Pl/Sql, & T/Sql, Information Technology

Diploma In Software Programming, Computer Programming Language