SUMMARY:

• Database counseling with more than 10 years of experience and additional knowledge of in Multi - Tier Technologies, Business Intelligence/SQL Report developer and relational Database Management System (RDBMS) including MS SQL Server 2014, 2012, 2008 and 2005.
• Data tools like SSRS SSIS. Good in writing performance efficient Views, Stored Procedures, Triggers,
• Expert in business data analysis to aid with accounting and audit processes to resolve data related issues.
• Having knowledge develop data exports / imports using SSIS to enable data integration across heterogeneous systems.
• Experience in Normalization, De-normalization and indexing database objects.
• Extensive knowledge in tuning T-SQL (DDL and DML) queries to improve the database performance and availability.
• Experience in creating SSIS packages to manage SQL server databases and SQL server objects between instances of SQL server.
• Experience in RDBMS Concepts, Database Management Systems, Database Physical and Logical design,
• Good understanding of Database Installation, Configuration, Support, Space management, and User management, Backup, Recovery, SQl Performance Tuning in the production database environment.
• Extensive experience in developing and implementing Microsoft SQL Server Integration Services (SSIS) and Reporting Services (SSRS).
• Excellent knowledge in RDBMS concepts and constructs along with Database Objects creation such as Tables, User Defined Data Types, Indexes, Stored Procedures, Views, User Defined Functions, Cursors and Triggers.
• Having knowledge in Extraction, Transforming and Loading (ETL) data flows using SSIS; creating mappings/workflows to extract data from SQL Server and Flat File sources and load into various Business Entities.
• Experienced in the complete life cycle of DTS/SQL Server Integration services (SSIS) Packages (Developing, Deploying, Scheduling, Troubleshooting and monitoring) for performing Data transfers and ETL jobs across different servers.
• Experience in Performance Tuning in SSIS packages by using Row Transformations.
• Extensive knowledge using Microsoft SQL Server Reporting Service (SSRS) with report designer, report manager and report server.
• Experience in Data Modeling (Logical and Physical Design of Databases), Normalization and building Referential Integrity Constraints.
• Extensive knowledge in Complex ETL Packages using SSIS to extract data from staging tables to partitioned tables with incremental load.
• Extensive knowledge of Designing, Developing and deploying various kinds of reports using SSRS using relational and multidimensional data.
• Created database objects like Tables, Views, Sequences, Synonyms, Stored Procedures, Functions, Packages, Cursor, Ref Cursor and Triggers.
• Generated Database Objects like Stored Procedures, Triggers, Functions, Indexes, Views and Constraints by using T-SQL environment to create complex scripts and batches.
• Used ER diagram and MS-Visio to design the basic database diagram.
• Good interpersonal, analytical and communication skill.

TECHNICAL SKILLS:

Databases Tools: SQL Enterprise Manager, Query Analyzer, SQL Server Management Studio, Business Intelligence Development Studio, SQL Profiler.

ETL Tools: Data Transformation Services (DTS) - Export/Import, SQL Server Integration Service (SSIS).

Database: MS SQL Server, Operating Systems Windows … Windows … Server, Windows XP, Windows Vista

• Excellent interpersonal and teamwork skills
• Solid verbal and written communication skills
• Excellent analytical and problem solving skills
• Willingness to learn new technologies and responsible, dependable, quick learner
• Demonstrated ability to adapt to new technology
• Preferred willingness to relocate nationwide in the US for projects.
• Self-motivated SQL Developer Business Intelligence (BI) Database
• Data management Created and Deployed SSRS and SSIS. Packages Reports in

PROFESSIONAL EXPERIENCE:

Confidential, Fairfax, VA

Senior data counseling

Responsibilities:

• Creating Database objects - Tables, Views, and Functions and developing procedures for implementing application functionality at the database side for Performance improvement.
• Performs information includes application, petitions, forms, supplemental documentation DHS decisions, and other documents.
• Performs data entry tasks in an accurate and timely fashion according to team production standards.
• Complete work assignment within the system.
• Perform standard data entry tasks according to team minimum production, accuracy standards and examine data records.
• Assisting and respond to request from customer with preformatted response document or create files and document based on research of the issue.
• Review File Requests and Ready for routine appropriates responded.
• Use online document tracking system to receive e-mail, distributed work assignment and completed work in system.
• Updating files in CIS and NFTS within time frame.
• Searching electronic databases, accessing tracking systems to determine the location of a file, physically searching for misplaced file, contacting other offices, updating systems, staging for delivery or pickup, and completing logs related to this processes.
• Updating the surrender status of the alien resident card into CIS for each naturalized citizen.
• Creating mapping documents. (Expert, lead....)
• Developed Sub Reports, Snapshot Reports and Drill down Reports
• Developed Line, Columns and Pie Charts for an easy and fast analysis of required reports data.
• Collected business requirements from users and translated them as technical specs and design docs for development.
• Performance tuning which include extraction of show plan, statistics and performing re-indexing, setting up new indexes
• Experience and expertise in taking business requirements and translating them into accurate actionable tasks which deliver results
• Strong ability to understand and analyze data relationships.
• Created Dynamic packages using variables and package configuration
• Self-motivated individual with strong Technical & Analytical skills. Always keen and eager to face up to challenges by means of novel and innovative ideas
• Create reports and Views and other database objects to implement Business Requirement.

Confidential, Fairfax, VA

Database developer

Responsibilities:

• Creating an A-data using as many entries as possible and verifying an A-data creation.
• Updating data in the central index system with non-transaction information and verifying a file updates.
• Performs enters information from DHS source documents into various automated systems using formatted input screens such as CIS and NFTS.
• Data base administrator perform data inquires and searches on DHS automated systems; generate records and reports from these systems; and perform name and alien number searches.
• Performs information includes application, petitions, forms, supplemental documentation DHS decisions, and other documents.
• Performs data tasks in an accurate and timely fashion according to team production standards
• Perform standard data tasks according to team minimum production, accuracy standards and examine data records.
• Inspect and record incoming data for completeness, accuracy of codes and other potential problems in processing.
• Ability to responded excellent verbal and written communication skills.
• Ability to performing work under various stressful, time sensitive situations and Strong attention to detail.
• Logging alien resident card (ARC or green card) on the specified log for each applicant as to whether the card was surrendered or not and stamping or otherwise noting the surrender on the N-445 for the file.
• Reviewing the ARC card log for accuracy after the initial logbook entries have been made.
• Completes review of imaged and non imaged documents for capture quality, mark sense accuracy, scan line read rate, document rejects and IDT interface
• Prepares batches and balances transactions by term, type and dollar amount including deposit verification. Reroutes rejected images for manual intervention and resolution. Transmits and validates.
• Balances information to the membership database or exceeds daily, weekly and monthly production and service quality objectives.
• Extensively worked on Data migration, Data cleansing and Data Staging of operational sources using excel reports processes and providing data mining features for data warehouses.
• Provided support for database backup/restore and database transfer activity from test environment to production environment.
• Created external tables to load data from various files supplied by data supplier.

Confidential, Fairfax, VA

General office worker- Office Support

Responsibilities:

• Performing physically interfiling the materials in to paper location within each file.
• Functioning include arranging the material for placement in the file or other disposition.
• Performing attending and assisting with ceremonies common functions contractors do at ceremonies include handing operation audio and video.
• Preparing file for work or retirement by removing paper clips, Staples, local tags and coversheets, or other unnecessary pages.
• Update the naturalization certificate make sure marked with the date and time of ceremony preformed.
• Use claims 4-scheduling interview for N-400&I-485, I-130, I-751 case status and run pick list reports.
• Set up the appropriate audio-visual material system for Naturalization ceremony.
• Responsible for perform daily office tasks such as filing, recording, marinating, records, copying, posting and variety of other office duties
• Use a computer terminal to update DHS automated system.
• Use claims-scheduling interview for N-400&I-485, case status and run pick list.
• Perform all tasks with reviewing all files for current fingerprints name checks and IBIS.
• SNAP all files that need updated fingerprints.
• Route all rap sheets to proper locations and annotating the clerical sheet with update information on the rap sheet.
• Assist distributing files to the appropriate division and retire files as needed.

Confidential, Fairfax, VA

General office worker- Office Support

Responsibilities:

• Provide clerical and administrative support in the processing of forms and applications used in the adjudication and adjustment of status of aliens
• Administer and assess different performance metrics of the operations
• Coordinate with the operations team to suggest improvements to increase performance
• Utilize business intelligence tools such as Mission Control to retrieve data and perform analytical tasks for demand prediction, supply matching, and supply positing
• Create reports for the Chief Executive Officer
• Assist manager with event planning for marketing campaign
• Setting up a profile with the number of files needed or the number of officers along with the number of files per officer.
• Perform all clerical tasks related to naturalization ceremonies, including the scheduling, preparation and distribution of certificates and retrieval of documentation from applicants
• Responsible for the quality assurance of files prior to file retirement
• Responsible to manage file rooms in the areas of file movement for proper identification of its accountability.
• Assists management in developing advertising and communications plans and strategies, which lead to significant customer retention.
• Conducted and analyzed yearly customer surveys and suggested various improvement approaches in improving customer satisfaction.
• Prepares and processes daily analysis each day, logs and reconcile inventory information for different reports
• Verified validity of reports discrepancies by obtaining and investigating information from data base such as customer service and different agency departments.
• Summarized receivables by maintaining reports; coordinating weekly transfer to main reports to verifying accuracy and quality.
• Provides support for the processing of forms and applications used in the adjudication process.