SUMMARY

• Around 8+ 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.

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

Confidential

Ms SQL Developer/ SSIS

Responsibilities:

• Load Data into Staging Area for Production Environment Using ETL tools Microsoft BIDS SSIS
• 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, 2012 Management Studio, BIDS/SSRS/SSIS, Visual Studio2012.
• Visual Source Safe for source control.

Confidential

Ms SQL Developer/ SSIS

Responsibilities:

• 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

Confidential

Ms sql developer/ SAS programmer

Responsibilities:

• Collect data for Confidential 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.

Confidential

SQL Server Developer

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.
• CreatedTriggers, checks and constraintsto 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.

Confidential, New York

SQL Developer

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.

Confidential

SQL/ SAS Developer

Responsibilities:

• Collect data for Confidential 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.