Data Sql Server
Resume:
Bhakti Naik
***** ******* ******* ****, ****, TX 77494
ac1wqc@r.postjobfree.com
Summary
12+ years of programming experience in analysis, design, development, research, implementation, testing deployment and support of several Client/Server, integration, windows and web based real time Application Systems. Domains worked in include Automotive, Health care, Supplier Integration Management, Product Data Management, Newspaper
Computer skills
●Has extensively worked in Client server and programming technologies like VB.NET, ASP.NET, ADO.NET, C#.NET, Win Forms Windows Services, VB 6.0, ASP, PERL, Crystal Reports, SSRS, SSIS, SSAS, ActiveX, IIS, Apache, HTML, JavaScript, VBScript, XML, AJAX,WPF, Telerik tools, Tidal schedular
●Sharepoint administration experience and building Dashboards using Performance point services.
●Experience with BI – building cubes using SSAS and extracting reports with SSRS and Sharepoint dashboards and scorecards.
●Proficient in DBMS and RDBMS including MS-SQL Server & Oracle, IBM DB2, MS ACCESS, Perl databases. ODBC connections.
●Performed development work adhering to Software Development Life Cycle Activities (SDLC) and using UML diagrams and adhered to Object Oriented Methodologies
●Experience in Version Controlling tools like Visual Source Safe, Rational Clear Case, Team Foundation Server
Experience
Professional Experience:
Insight Global posted at Houston Chronicle, Feb 2015 – Present
IT Professional, Katy, Tx
Worked on multiple projects for circulation, advertising, publication teams. Migrating all web applications,services and processes to the Amazon cloud AWS and Azure. Understanding the current architecture and participate in designing new environments.Help configure and deploy systems and databases to new environments on AWS cloud and Colo.Conversion of multiple systems to new NCS.
Development of various processes and translations in SSIS 2008 R2,SSIS 2012,SQL 2012.Training users in translations and interfaces. Data analysis, SQL, TSQL,stored procedures, agents and monitor SQL servers.
Implementing some quick solutions for HR for benefits to employees. Application prints to a printer and emails HR. Maintain and enhance websites internal and external and enhancements.
Work with various teams circulation,advertising,publication,HR,finance on their systems.
Developing new web applications for cloud migrations compatibility.
Communicating with vendors and developing various translations for them.
SQL server database admin activities, data analysis for various teams. More than hundreds of integration packages develop, test, deploy,work with various teams and vendors.
Tools used: Ms.Visual Studio, BIDS, SQL Server,Ms.Lync, Ms Office, TFS etc.
Ingenesis, Feb 2014 – Dec 2014
Software Consultant, San Antonio, Texas
InGenesis has achieved national recognition as one of America’s fastest growing HR companies. Ingenesis specializes in innovative web-based workforce systems, high caliber recruiting and commitment to customer.
Developing web applications, reports help and support the multiple applications, customer facing. Developing quick solutions for customers to automate their processes for ADP and Billing Assignments using SQL procedures, SQL Agents jobs, batch files, excel transformations, Asp.net web forms, SSRS reports creation and deployment to webserver and Sharepoint. Manage the SSRS server.Helping create various SSRS reports and support Sharepoint. testing and logging results. Documentation at each stage. Tools used Ms.Visual Studio 2013, 2010, .Net Framework 4.0, Ms.SQL 2012, BIDS 2008 R2, Ms.SQL 2008 R2, HTML5, CSS3 and Javascript,Jquery with Entity framework used. Followed a 3 tier architecture DAL,BLL,UI logic, LINQ
Biobridge Global previously South Texas Blood and Tissue Centre, US Dec 2013 –Feb 2014
Team Lead, San Antonio, Texas
Biobridge Global/South Texas Blood & Tissue Center (STBTC) is a not-for profit community blood center specializing in a variety of services. Blood Services provides blood, plasma, platelets and other blood components to 100 hospitals and clinics in 43 South Texas counties.
Use of Team Foundation server 2010 for version control and branching, documents management and version control in all projects.
Business Intelligence project using SharePoint 2010 dashboard designer using Pivot services and Performance point services. Designed the common database warehouse and importing data from old blood system databases.
Building OLAP cubes from fact and dimensions tables, publishing cubes. Building KPI,charts, dashboards reports and scorecards from OLAP cubes on sharepoint.
Guide and help team members in their tasks.
Jira – Configure items in Jira, add and assign team tasks, add projects,resources, dashboards, boards,user management,build reports for management.
South Texas Blood and Tissue Centre, US Feb 2012 – Dec 2013
Application Developer II, San Antonio, Texas
Developed a windows client Application called eEMS using WPF, ADO.Net Entity Framework, LINQ and Telerik controls, SQL for tablet machines for electronically managing the company documents. Application build to work on windows and tablets.Developed windows services for the same project. Building Ticket generations, notifications, watchdog windows services in C#. Testing, deploying bat scripts, documentation, support.
Sharepoint 2010 administration tasks.
Various SSRS reports developing, deploying, internal IT testing, QA validation,support.
Various integration projects using SSIS.
South Texas Blood and Tissue Centre, US Feb 2010 – Feb 2012
Application Developer, San Antonio, Texas
Windows and web applications using C#.NET 4.0, WPF,Visual Studio 2010 Ultimate ALM, Oracle 8i,9i,10i and SQL 2008 databases, SSRS, SSIS,SSAS,BIDS and SSIS 2008, Access VBA reports, VB 6,Crystal reports, FTP. Follow the complete SDLC,company SOP. Supporting all existing systems, Convert MS Access 2003 and Crystal 9 reports to SSRS 2008 R2 reports.
Creating batch files / scripts for installing software on various machines. Administering IIS.
Administering Sharepoint and creating webparts
Developed a web application using C# 4.0 for blood systems search engine called as Lookback system to search using SSRS reports in a common data warehouse.writing scripts to Extract data from 4 old systems and transform and Load in datawarehouse Lookback system.
Running several queries daily for management and business.
Creating manuals, design, test plan and test case documents.
Tata Technologies Ltd / INCAT US Mar 07 – Jan 09
Client: - Chrysler LLC, Detroit, MI Integrated Collaborative Data Exchange: Senior Consultant
Worked as a Product Data Management consultant and supplier chain management software consultant at Chrysler LLC, Detroit. The systems included data exchange with North American and European Suppliers and Daimler Germany. Developed intranet website for data exchange using JSP and using DB2. System involved communication with more than 120 North American suppliers, more than 130 European suppliers and internal Chrysler users and China suppliers.
Responsibilities:
Developed web application modules and performed unit and integration testing.
DB2 databases and using HTML, CSS, JavaScript, Java, JSP, Developed PERL, C, Shell scripts for data exchange with suppliers, Created a web services for Chrysler web service which finds the Supervisor information
Scheduling CRON on UNIX, Monitoring daily production CRON jobs and generating daily job data transfer reports, Writing and using stored procedures
Creating user manuals and technical documentation, data flow and entity relationship diagrams
Troubleshooting jobs : Finding out failures in failed transfers and finding solutions for the same
Administration of the Product data management tools used in Chrysler eg. SWAN Web,Autoweb
Monitoring data transfers to German Daimler and Auto web American users
Working with the supplier integration team to setup Chrysler Data exchange mailboxes for data exchange, Past System Viewer setup at supplier locations.
Support all data exchange activities using Chrysler ticketing system in Mainframes.
Manual Testing of complete web system with test cases and generating test plans and reports
Team member in server migrations and replacements – Applause by client
Onsite project co-coordinator for offshore team.
Environment: WSAD 5 and WSAD 6, JSP, Rational Clear case, DB2, XML, Web Services, C, PERL, UNIX, CRON JOBS, UNIX SHELL, SWAN –WEB, AUTOWEB Websites, HTML, CSS, JavaScript, Lotus Notes
Tata Technologies Ltd, Pune, India Jan 04 – Mar 07
Client: - Tata Motors Ltd, India
Euro III/ IV Engine Test Data Capture and End of Line Operations: Senior Developer and Module Lead
This complete real time integrated huge system involved various windows and web based real time applications and dll components. An automated system which involve users right from employees, managers to shop floor workers in automotive field. System selected Best project of Quarter and nominated for Best Project of the year. This real time system consists of various sub -projects windows as well as web.
Windows modules varied for every vehicle type at end of line operations.
Creating requirements and design documents, user manuals
Designed & developed the web based application in ASP.NET, web pages and connecting with backend SQL databases, using AJAX ATLAS control toolkit,Scheduling jobs with DTS, Win Forms controls like progress bar, Serial port communication for Bar code scanners etc,Crystal report used in .NET 2.0,Develop Active X DLL components using C# which were used in all panels PC,Creation of database scripts which involve table creation, constraints, and database queries and stored procedures, triggers
Environment for web applications: Microsoft Visual Studio 2005, ASP.NET 2.0, SQL Server 2000, JavaScript, and AJAX, Framework 2.0 ATLAS control toolkit for AJAX, SQL Server 2000
Engineering Research Content Management System: Senior Developer
This web based utility was designed and developed for the managers and employees of research departments in Tata Motors. The administrator manages users for the system. Employees are given rights to upload specific files on server to be used for flashing ECU at end of line. Managers approve the files and then files are ready to be used for production. The system uses FTP for uploading the files on server and managers can download files or even disapprove at any time.
Prepared technical design specifications with flow and E-R diagrams
Designed and developed the web based application in ASP.NET using .NET Framework 2.0
Report generation, Used Ajax controls like Auto complete, Drop down Panel etc.
Database scripts and implemented stored procedures in SQL and implemented triggers
Hosted the intranet website using IIS
Environment: Visual Studio.NET 2005, VB.NET, ASP.NET 2.0, Rational Clear case, IIS6, ADO.NET, Ms Front Page, SQL Server 2000, JavaScript, and AJAX control toolkit.
Tata Technologies Ltd, Pune, India Apr 04 – Dec 04
Client :- Tata Motors Ltd, India
Smart Biz: Tata Business Excellence Model – A Data Warehousing site: Developer
Developed a centralized data warehouse which provides useful data & information to process owners. Reports generation from the data warehouse data for the users to compare the organizations performance measures in different categories. KPI’s.
Designed and Developed intranet website in ASP.NET 1.1
Implemented stored procedures & triggers, Integrated front-end web pages with back-end database engine in SQL
Wrote scripts for scheduling jobs or packages using DTS (Data Transformation Services), alerts, notifications and logs for failed DTS
Created OLAP cubes & generated graphs using Microsoft SQL Pivot Table Services
Environment:, HTML, CSS, JavaScript, Visual Studio.Net 2003 (ASP.NET), SQL server 2000, Analysis Services, Pivot Table Services, DTS, Reports from OLAP cubes.
Tata Technologies Ltd, Pune, India July 03 – Mar 04
Client:- Tata Motors Ltd, India
Intranet Search Engine: Developer and Lead Group
This project was implemented as part of the final year Designed & developed an “Intranet Search Engine”. The engine enables users to perform searches of words & phrases in ASCII & binary files with extensions like PDF, XLS, and DOC on UNIX & Linux platforms across various intra-departmental clusters. Clients could access the search engine through a departmental webpage. Completed the project on-time & met all deadlines.
Environment: UNIX (AIX) / Linux 8.0 / Windows, Perl -CGI, JavaScript, VB Script, Perl Database
EDUCATION
Bachelor of Engineering, Information Technology, Pune University, India – Distinction holder 2004
Trainings:
VB.Net Certification from NIIT, India
Ms.Sharepoint Server 2007 training course included MOSS and WSS
Visual Studio 2010 Ultimate ALM tools.
Sharepoint 2010 Business Intelligence
Awards/Achievements:
Biobridge / STBTC – uMatter awards and appreciations
Applause received from Chrysler LLC for Data Exchange
Brainbench Test Certification for RDBMS
Tata technologies EURO III project selected as ‘project of the quarter’ & nominated for ‘project of the year’.
Appreciations from Tata Motors for work on Euro III / IV project
Contact this candidate