SUMMARY

• 3 years of related experience in using the data management tools such as MS SQL Server, Oracle SQL Developer, T - SQL, PL\SQL, SSRS, SSIS, ACCESS, MySQL
• MCP and ORACLE database certificated
• Experience of Data Analysis tools including SAS, MS Excel, Tableau & Power BI (visualization)
• Experience in ETL processes, Data Warehouse Systems, and Relational Database Management Systems (RDBMS)
• Proficient in writing T-SQL queries in SQL Server and PL\SQL in SQL Developer (Merge, Pivot & Unpivot, Window Functions, Partition By, CTE, Temp Table, Regular Expression)
• Proficient in Data Migration from sources like MS Access, SQL server, Text Files, Excel to SQL server 2008
• Proficient in creating Triggers, Tables, Stored Procedures, Functions, Views, Indexes and Constraints in T-SQL to facilitate data consistency in MS SQL Server 2008.
• Experience in Interacting with Business users to analyze the business process and transforming requirements into screens, performing ETL, documenting and rolling out the deliverables.
• Hand on experience in generating on-demand and scheduled reports for business analysis or management decision using SQL Server Reporting Services 2008/2005 and Excel spreadsheet.
• Built effective queries for high-performance reports and rendered them to HTML, XML, PDF and Excel formats using SSRS
• Proficient in advanced MS Excel application ( Pivot Table, VLookup, Nested If function )
• Experience in source control tools such as Source Tree, Bit Bucket, Git and Kelin.
• Experience of project processing control tools like Trello and Agile, well understanding of SDLC.
• Knowledge of SQLServer Analysis Services (SSAS) for designing OLTP Cubes
• Real world experience in data warehouse systems including MySQL, SQL server and Oracle SQL Developer
• Hand on experience of C#, ASP.NET, JAVA, HTML 5, CSS 3, JAVASCRIPT development
• Deep understanding of Relational databases and Object-oriented analysis and design
• Strong analytical and mathematical skills which is evident from engineering background
• Effective team player with excellent verbal and written communication, organizational and interpersonal skills

TECHNICAL SKILLS

Databases: SQL Server 2008/2008R2/2012, ORACLE 11G, T-SQL, PL/SQL, SQL Server Reporting Services (SSRS), SQL Server Integration Services(SSIS), Oracle SQL Developer, MS Access

Data Analysis Tools: SAS, MS Excel, Power BI, Tableau

Programming Technologies: VBSCRIPT, C#, ASP.NET, JAVA, HTML5, CSS3, JAVASCRIPT, VBA.

Operating System: Windows XP Professional, Vista, Windows 7, Windows 8, and Unix

Software Packages: MS Office (WORD, EXCEL, POWERPOINT), MS Visio, NotePad++, WinMerge, PotPeek, LINQPAD4.

PROFESSIONAL EXPERIENCE

Application Developer

Confidential

Responsibilities:

• Completed complicated SQL Queries (Subquery & Correlated Subquery) to implement complex conditional selections.
• Developed complex Stored Procedures and Functions and incorporated them in all kinds of SSRS Reports (Drill down, Drill through, Subreport, etc.) to enable SSRS report generation.
• Completed complex data extraction, transformation, and loading by using different types of transformation (Row Count, Conditional Split, Union All, Aggregate, Pivot, etc.) and connection (OLE DB, FLATFILE, FILE etc.) in SSIS.
• Responsible for developing processes, automation of maintenance jobs, dashboard renew notification and SQL Server backup strategy and automation.
• Completed the web reports & application migration between multiple servers (development, test, production) by using DotPeek & Visual Studio, decompiled the source file in dotpeek and then create the solution file in Visual Studio, completed the configuration on IIS after the report or application was published, upload the source files onto remote source control such as BitBucket .
• Created and configured auto job in Sql Server environment, completed trouble shooting when job failed.
• Modified and updated business dashboard by using data analysis tools such as Power BI & MS Excel.
• Accomplished trouble shooting for all kinds of job failed situations as a member of triage team.
• Classic ASP (vbscript) web application development & updating.

Environment: MS SQL Server 2008/2012, Oracle SQL Developer, Visual Studio 2008, SSRS, SSIS, DTS, T-SQL, PL/SQL, MS IIS(Internet Information Services 8), VBScript, C#, ASP, MS Access, OnTime, IBM Notes, NotePad++, BitBucket, SourceTree, Git, Trello, DotPeek, LINQPAD4, Crystal Report.

Data Analyst/Sql Developer

Confidential

Responsibilities:

• Participated in the development of production database for GTAT.
• Involved in Data analysis and Data Profiling to analyze Data quality and plan approaches for Data cleansing and transformations by using MS Excel and SAS in GTAT.
• Checked and modified production information in SAP to guarantee the efficiency of product line.
• Responsible for automation of daily maintenance jobs such as database backup & update.
• Generated SSRS reports for production information in GTAT.
• Automatic e-mail notification and SQL Server backup strategy and automation.
• Performed ETL-Extraction/Transformation/Loading, Data migration and Data preparation for academic research and industrial projects in ASU.

Environment: MS SQL Server 2008, SAS, MS Excel, T-SQL, MS .NET Framework, Microsoft Visual Basic 6, MS Access, Visual Studio, SSRS, SSIS

Data Analyst/Sql Developer

Confidential

Responsibilities:

• Completed complicated SQL Queries (Subquery & Correlated Subquery) to implement complex conditional selections.
• Implemented data management principles such as joining data set, indexing, data aggregation, record selection, sub-setting, multiple records per case, creation and modification of views, accessing multiple database.
• Used advance features of T-SQL to design and tune T-SQL to interface with the databases and other applications in the most efficient manner.
• Developed complex Stored Procedures and Functions and incorporated them in all kinds of Reports (Drill down, Drill through, Subreport, etc.) to enable report generation on the fly.
• Improved the performance of SQL programming by using triggers (DML, DDL), cursors, transactions & indexes.
• Developed SQL Server Database objects including Tables, Views and Indexes.
• Responsible for developing processes, automation of maintenance jobs, tuning SQL Server, locks and indexes configurations, administering SQL Server security, SQL Server automatic e-mail notification and SQL Server backup strategy and automation.
• Performed ETL-Extraction/Transformation/Loading, Data Analysis, Data migration, Data preparation, Graphical Presentation, Statistical Analysis, Reporting, Validation and Documentation
• Involved in Data analysis and Data Profiling to analyze Data quality and plan approaches for Data cleansing and transformations.

Environment: MS SQL Server 2008, T-SQL, Microsoft Visual Basic, SAP, MS Access, Visual Studio, SSIS