Senior IT Consultant Resume

SUMMARY:

Highly talented and proficient data engineer skilled in creating valuable data analysis/reports for products and services that are of high quality. Possesses strong database management skills, expertise in SQL, Oracle, MIS reports and advanced Excel functions along with first hand international business experience.

COMPETENCIES:

Database: MS SQL, Access, Oracle, Excel

Languages: SQL, T - SQL, PL/SQL

SQL Server Tools: Query Analyser, SSIS

Platforms: Windows, Macintosh SSAS, SQL Server Management Studio

Reporting Tools: MIS, Excel

Development: C, C++, C#, ASP.NET

Frameworks: SDLC, QA methods

EXPERIENCE:

Confidential

Senior IT Consultant

Responsibilities:

Designed, developed and deployed reports in MS SQL Server environment to determine right distribution of funds to relevant non-profits from a budget of $104.5 million.
Created SSIS packages to import data from Excel and Flat files to SQL Databases using SSIS components like Merge, Merge Join, Union All and Lookup.
Performed verification, validation, and transformations on input data (Text files, XML files) before loading it into target database.
Created report schedules and subscriptions; managed and secured reports using SSRS databases to create customized reports.
Created appropriate reports using complicated SQL queries, ETL tools like SSIS, MIS and Excel techniques to answer queries asked in the Parliament of India sessions on ‘Nai Roshni’
Implemented a knowledge management tool within a time frame of 3 months at the PM Unit for this project which helped all the non-profits to train more than 30,000 minority women.
Generated valuable funding insights for the ‘Nai Roshni’ project from in-depth analysis of reports; created these reports on daily, weekly & monthly basis using Excel and Access.
Successfully engaged with different cross-functional teams for requirements specifications, analysis, design, development and testing phases in the SDLC cycle.
Collaborated with Database Development Team for project’s productive testing implementation.

Confidential

SQL Database Developer

Responsibilities:

Installed and configured SQL server, its backup and restoration for 300+ ART centres in 25 states.
Implemented log shipping and resolved complex queries on a daily basis for at least 18000 patients.
Created, managed schema objects such as tables, views, indexes, stored procedures, triggers and maintained referential integrity to ensure accuracy of 300,000 patients’ data for this initiative.
Involved in query optimization, shrinking log files and working with SQL server agent jobs and in generating dynamic stored procedures and triggers for the database development.
Administered MS SQL Server commands to create groups and user logins with appropriate roles, monitor user accounts, and grant privileges to users and groups.
Extracted data using SSIS packages (ETL) from different server locations sources like Excel, CSV, Flat File, Text to load data using Lookup, Derived Columns, Aggregate and Pivot Transformation.
Led important documentation of sensitive project related information; as well as updated timely project status to the client through well drafted status reports.

Confidential

Software Development Trainee

Responsibilities:

Designed and developed the database schema for an employment management system.
Created user friendly application interfaces using ASP.Net and incorporated the coding and troubleshooting feedback from seniors in the modified versions
Captured and analysed critical data needs for the system by collaborating with internal and external clients.

We provide IT Staff Augmentation Services!

We'd love your feedback!

Resume Categories

Client Services

Job Seekers

Visa Sponsorship