NISHAT PARVEEN

***** * ******* ** • Olathe, KS - 66062 • 816-***-**** • adheb3@r.postjobfree.com

ACCOMPLISHMENTS

** ***** ** ********** ** an ETL Developer/Software Developer and lead projects in software development lifecycle including Internet and e-commerce business solutions.

Experience with Data warehouse technical architectures, ETL/ ELT, reporting and cubes creation.

Extensive database development experience with Microsoft SQL Server 2000/ 2005/2008/2012, writing T-SQL, PL/SQL Scripts and Data Modeling, Designing and Optimization, Tuning and data migration using DTS packages in SQL 2000 and SSIS, SSAS, SSRS in SQL 2005/2008/2012. Experience in Database upgrade from SQL 2000 to SQL 2005/2008.

Ability to apply Database Design Principles.

Translate Business requirements into Data Requirements. Understand the data elements and their domains; understand relationships among those elements and interdependencies between models.

Excellent knowledge in creating Databases, Tables, Stored Procedures, DDL/DML Triggers, Views, User defined data types, functions, Cursors and Indexes using T-SQL.

Project management, technological forecasting and Strategy for technological assessment skills and knowledge for Engineering Projects.

Team Leadership - Manage own workload as well as other programmer and analysts assigned to team by planning, organizing and delegating to meet deadlines and accomplishing objectives

Gather business requirements and translate into technical implementation.

Strong enterprise applications development experience in Web application and Client Server application with Microsoft® .Net Architectures using different tools and technologies including .NET Framework (ASP.NET, VB.NET, ADO.NET, C#, Web Services, AJAX, MVC, MS Office Automation), HTML, JavaScript, VB Script, ADO, IIS, Visual Interdev and Visual Source Safe

Excellent analytical, problem solving and time management skills.

Knowledgeable in Hadoop and currently pursuing Big Data Architect program.

TECHNICAL SKILLS

Operating Systems: Windows 98/NT/XP, UNIX

Programming / Tools: ASP, ASP.NET 2.0/3.5, VB.net, C#, Web services, LINQ, XML/XSLT, MVC, Java, HTML

Databases: SQL Server 2000/2005/2008/2012, Netezza,Oracle 8i/9i, MySQL, MS Access

Applications: MS Office, Project, Visio, Microsoft Visual Studio .net 2003/2005, Subversion, Team Manager, Meeting Room Manager, SharePoint Portal Server 2003, Ultimate Survey, Smart Filter, Photoshop

Networking: Server configuration (Windows NT/XP/2000/2003), MS exchange 2003

EDUCATION

University of Kansas

Master of Science in Engineering Management 2013

University of Missouri - Kansas City, MO

Bachelor of Science in Computer Science

PROFESSIONAL EXPERIENCE

Valuehealth, Leawood, KS 2017 – Present

Business Intelligence/ETL Developer

Designed SSIS Packages to extract, transfer, load (ETL) existing data into SQL Server from different source systems.

Wrote T-SQL queries, stored procedures, CTEs and query tuning

Converted Data Transformation Services (DTS) application to SQL Server Integrated Services (SSIS) as assigned.

Experienced and knowledge using Informatica for cloud applications ETL/ELT processes.

Implemented CDC (Change Data Capture) to allow near real time data load in SSIS

Created reports using IBM Cognos and Qlik for customized and ad-hoc requests.

Implement SSAS cubes for Dashboard performance metrics.

Rebuilt ValueHealth’s SQL Server from ground up after Ransomware attack to restore the data import processes.

Performed database design and data modeling.

Experienced in implementing API/Web services in SSIS and Informatica in XML/JSON formats.

Responsible for rebuilding the indexes and tables as part of performance tuning.

Improved the efficiency of the data load processes for different source systems

Automated and streamlined Business Intelligence tasks and processes previously performed manually.

Knowledgeable in Big Data technologies such as Hadoop and Spark.

Demarche Associates, Overland Park, KS 2013 – 2015

Software Engineer

Implement project management duties utilizing software development technologies

Manage Migration of legacy desktop and web applications written in VB6 to .net technologies

Manage Migration of SQL Server 2000 to SQL Server 2012

Data modeling and optimization of the current SQL Database

Created and Managed OLAP Cubes using SSAS

Research options to improve processes in house for websites and document management.

University of Kansas - Lawrence

Graduate Research Assistant 2011- 2012

Maintained websites for Kansas Transportation Center.

Studied vehicle inventory system to develop, design and model forms, reports and tracking system using VB.net and SQL 2008.

Ascend Media, Overland Park, KS 2007- 2009

Programmer /Business Analyst

Developed new application programs, enhanced and maintained existing application programs using Microsoft .Net 2.0 /3.5 technologies in C# and VB.net with SQL 2005 as back end Database.

Upgraded and migrated the MS SQL 2000 Server to MS SQL 2005 on which all business applications ran.

Wrote and optimized stored procedures/views/queries etc using T-SQL and SSIS packages in SQL 2005.

Process Improvement – Analyzed production programs to isolate problems or determine efficient methods in order to improve operations, decrease turnaround times, streamline work processes, and work cooperatively to provide quality seamless customer service.

Delegated and managed software projects within the team.

Created and customized reports using SSRS (SQL Server Reporting Services) 2005. Also converted old Crystal Reports using SSRS 2005.

Designed and constructed applications to meet the needs of business unit requirements.

Assisted in the design of automated portions of systems; and design program logic to meet specifications and adhere to prescribed standards.

Johnson County Public Library, Overland Park, KS 2004 – 2007

Programmer Analyst

Deployed SharePoint Portal Server 2003 on Windows 2003 Server and carry out all maintenance. Played major role in configuring and deploying library’s Intranet on SharePoint Portal Server 2003. Deployed web modules, configured Active Directory imports, and provided site design/structure.

Developed and implemented code and maintained applications including web-based applications in ASP and ASP.net technologies (VB.net and C#) with backend database as MS SQL server 2000/MS SQL Server 2005. Carried out software configuration and maintenance, code maintenance, and application upgrades.

Wrote and optimized stored procedures /views/triggers/queries using T-SQL in SQL Server 2000 and 2005. Created DTS packages for nightly Database routines.

Performed software development life cycle project management and software engineering, including needs determination, business / technical analysis, design, development, and implementation.

Designed and launched E-newsletter system in ASP. Maintained code to allow subscription processes for newsletters and integration with vendor application (Campaign Enterprise) and MS Exchange Server 2003.

Training/Certications: SharePoint Portal Technologies 2003, Episerver Content Management System, Big Data Architect Program

Contact this candidate