Syed

ac7ivx@r.postjobfree.com

646-***-****

Summary:

•Around 10+ years of extensive IT professional experience with expertise in Database Development, Database modeling, Design and Technical Management.

•Extensive experience in migrating Data from Excel, Flat file to MS SQL Server by using MSSQL Server SSIS.

•Hands on experience in SSRS in generating reports of day-to-day transactions.

•Experience in Designing, Creating, and managing multidimensional structures using SSAS.

•Experience in development the Microsoft Analysis services cubes

•Extensive knowledge of Relational Database Management Systems.

•Excellent backend skills in creating SQL objects like Tables, Stored Procedures, Views, Indexes, Triggers, Temporary tables, user defined data types and functions.

•In-depth knowledge of T-SQL, MS SQL (DDL, DML, and DCL).

•Hands on experience in troubleshooting database issues..

•Eexperience in setting and monitoring Backups\Restore, Database Mirroring, Log shipping and Replication.

•Maintained Database authentication modes, created users, configuring permissions and assigning roles to users.

•Experience in installation and configuration of MS SQL Server 2008/2005/2000 Versions

•Used Microsoft Source Safe for version control and configuration management.

•Excellent experience in designing, developing and debugging SAS Programs and SAS Macros to access, extract, merge and analyze data, and output statistical analysis files and reports.

•Experienced in producing Excel, RTF, HTML and PDF formatted files using SAS ODS to produce ad-hoc reports for presentation and further analysis.

•Good team player, strong interpersonal and communication skills combined with self-motivation, initiative and the ability to think outside the box.

Education:

MS(Information Assurance and Cyber Security ) in progress .

Bachelors Degree in Computer Science, Lehman College,City University of New York

TECHNICAL SKILLS:

RDBMS

MS SQL Server 2005/2008, R2, 2012

ETL Tools

SSIS, INFORMATICA POWERCENTER

Database Tools

Query Analyzer, SQL Profiler, Data Transformation Services, Upgrade Wizard, SSIS, SSRS, SSAS,

Programming Languages

SAS, SQL, TSQL,,SP, ASP.NET,C#, HTML, XML,, Java, Python.

Scripts

Java Script, VB Script, HTML

Applications

Microsoft office, vss and Visual Studio

Reporting Tools

SSRS, Tableau, SAS

PROFESSIONAL EXPERIENCE:

Integra Manage Care: June 2018- Todate

Role: Ms sql developer

•Actively involved in writing T-SQL Programming for implementing Stored Procedures.

•Worked with SSIS to import/export and transform the data between the linked servers.

•Create Varity types of reports in SSRS for analysis purposes.

•Designed SSIS Packages to transfer data across different platforms,

•Set up SQL Agent to Automate the sql jobs.

•Created interactive Dashboard for C_level decision making steps.

•Setting up Automated Report subscriptons to our members.

•Actively involved in Creating and Migrating databases across many servers.

•Automate and implemented sql server maintenance jobs.

•In-Depth working knowledge of ODBC.

•Created many complex Stored Procedures / Functions and used them in to generate reports on the fly.

Environment: MS SQL Server 2016, Management Studio, BIDS/SSRS/SSIS, Visual Studio2016,

R R Donnelley Financial Inc: March 2013 – June 2018

RR Donnelley is the Mother company of BOWNE and G-COM, they deal with all shareholders Financial data.

Role: Ms SQL Developer/ SSIS custom preprocessors for our clients to load data into FundSuitARC and SSRS custom report for our clients.

•Design SSIS Packages using BIDS to bring data from different sources to Data Arc

•Create FundSuitArc environment and set up connections for Automation

•Set up data profiler for FundSuitArc for error detection.

•Create Database Objects like Tables, Stored Procedures, Views, Joins, Triggers, and Functions.

• Writing T-SQL Programming for implementing Stored Procedures.

•Create custom report for share holders clients using SSRS

•Environment: MS SQL Server 2008, Management Studio, BIDS/SSRS/SSIS, Visual Studio2010,

•VSS, FoxPro

Bronx Hospital: May 2010- Dec 2011

Role: Ms sql developer/ SAS programmer

•Collect data for NYS Department of Health from Pregnant Women, Infants and Children.

•Provide data to the Bassett and CDC to help create Data Warehouse for data Analysis purpose

•Competent in Quality System and Standard (cGLPs, cGCPs, ICH and cGMPs).

•Proficient in various SAS tools like SAS/Base, SAS/Stat, SAS/GRAPH.

•Excellent working knowledge of statistical analysis of clinical data using SAS Procedures like Proc MEANS, Proc ANOVA, Proc CORR, Proc GCHART and Proc UNIVARIATE.

•Extensively used SAS/MACRO for creating macro variables and macro programs.

•Experience as a SAS Programmer in Windows platforms

•Good experience in storing and manipulating data in SAS files by Merging, Arrays, Formats, Informats, SQL Joins, Proc Datasets and Proc Transpose.

•Excellent experience in designing, developing and debugging SAS Programs and SAS Macros to access, extract, merge and analyze data, and output statistical analysis files and reports.

•Experienced in producing Excel, RTF, HTML and PDF formatted files using SAS ODS to produce ad-hoc reports for presentation and further analysis.

•Excellent communication and interpersonal skills and accustomed to working in challenging and team environments under timelines.

•Actively involved in writing T-SQL Programming for implementing Stored Procedures.

•Worked with SSIS to import/export and transform the data between the linked servers.

•Designed SSIS Packages to transfer data across different platforms,

•Designed and implemented user log in and security.

•In-Depth working knowledge of ODBC.

•Created many complex Stored Procedures / Functions and used them in to generate reports on the fly.

•Environment: MS SQL Server 2008, Management Studio, BIDS, Visual Studio2010, SSIS, SSRS, T-SQL, ETL, SAS 9.0.

Eztech: Eztech is an IT consulting firm, they have 15-20 developer who work on any database project from small to large company.

Role: SQL Server Developer August 2008 – May 2010

Responsibilities:

Developed the databases for the individual departments of the hospital and the central database, which contains information about all the departments.

•Created Database Objects like Tables, Stored Procedures, Views, Joins, Triggers, and Defaults, Rules and User Defined data types and Functions.

•Created Triggers, checks and constraints to maintain data integrity.

•Developed complex T-SQL code for the application conversions.

•Designed and implemented user log in and security.

•Generated server side T-SQL scripts for data manipulation and validation and created various snapshots and materialized views for remote instances.

•Used SQL Profiler to estimate the Slow Running queries and performance tuning purpose.

•Actively involved in migration of DTS packages to SSIS packages.

•Responsibilities:

•Write and review good quality SQL in order to change/fix data in a Production environments.

•To liaise with Support and the Business and provide SQL Reports from Production data.

•Create Daily SQL scripts to address production data problems.

•Created Database Objects like Tables, Stored Procedures, Views, Joins, Triggers, and Functions.

•Run SQL scripts against production data during maintenance windows. Create Daily SQL

•Subscription’s to address Production Business reporting requests for analysis.

•Replicated a Database and its entire object to a different Server and changed the SQL jobs to point to the new Server.

•Built Drill Down, Drill through and sub reports using SSRS 2008.

•Actively involved in writing T-SQL Programming for implementing Stored Procedures, Dynamic queries and Functions for different tasks.

•Worked with SSIS to import/export and transform the data between the linked servers.

•Designed dynamic SSIS Packages to transfer data across different platforms, validate data during transferring, and archived data files for different DBMS.

•Environment: MS SQL Server 2008, Management Studio, BIDS, Visual Studio, SSIS, SSAS, SSRS, T-SQL, ETL, SQL Profiler, Tuning Advisor, Windows 2003.

Ahyaan Trade International Inc. New York

SQL Developer August 2006- May 2008

Responsibilities:

•Design, Create, Ms SQL Database

•Created Database Objects like Tables, Stored Procedures, Views, Joins, Triggers, and Functions.

•Run SQL scripts against production data during maintenance windows. Create Daily SQL

•Subscription’s to address Production Business reporting requests for analysis.

•Replicated a Database and its entire object to a different Server and changed the SQL jobs to point to the new Server.

•Built Drill Down, Drill through and sub reports using SSRS 2008.

•Actively involved in writing T-SQL Programming for implementing Stored Procedures.

•Worked with SSIS to import/export and transform the data between the linked servers.

•Designed dynamic SSIS Packages to transfer data across different platforms, validate data during transferring, and archived data files for different DBMS.

•Managed and delegated the work to offshore team.

•Environment: MS SQL Server 2008, Management Studio, BIDS, Visual Studio2008, SSIS, SSAS, SSRS, T-SQL, ETL, SQL Profiler, Tuning Advisor, Windows 2003.

NYS Department of Health

SQL/ SAS Developer April 2003-May 2006

Responsibilities:

•Collect data for NYS Department of Health from Pregnant Women, Infants and Children.

•Provide data to the Bassett and CDC to help create Data Warehouse for data Analysis purpose

•Competent in Quality System and Standard (cGLPs, cGCPs, ICH and cGMPs).

•Proficient in various SAS tools like SAS/Base, SAS/Stat, SAS/GRAPH.

•Excellent working knowledge of statistical analysis of clinical data using SAS Procedures like Proc MEANS, Proc ANOVA, Proc CORR, Proc GCHART and Proc UNIVARIATE.

•Extensively used SAS/MACRO for creating macro variables and macro programs.

•Experience as a SAS Programmer in Windows platforms

•Good experience in storing and manipulating data in SAS files by Merging, Arrays, Formats, Informats, SQL Joins, Proc Datasets and Proc Transpose.

•Excellent experience in designing, developing and debugging SAS Programs and SAS Macros to access, extract, merge and analyze data, and output statistical analysis files and reports.

•Experienced in producing Excel, RTF, HTML and PDF formatted files using SAS ODS to produce ad-hoc reports for presentation and further analysis.

•Excellent communication and interpersonal skills and accustomed to working in challenging and team environments under timelines.

•Actively involved in writing T-SQL Programming for implementing Stored Procedures.

•Worked with SSIS to import/export and transform the data between the linked servers.

•Designed SSIS Packages to transfer data across different platforms,

•Designed and implemented user log in and security.

•In-Depth working knowledge of ODBC.

•Created many complex Stored Procedures / Functions and used them in to generate reports on the fly.

•Environment: SAS 9.0, SQL Server 2000/2005, VB.NET, Windows 2000 and 2003, Management Studio, Business Intelligence Development Studio.

Contact this candidate