SATHISH SOUNDAPPAN JAYAKUMAR ac1xu9@r.postjobfree.com

A multi-skilled solution architect in Manufacturing & related business process, with good all-round ability to juggle multiple projects and meet deadlines, whilst at the same time comprehending complex and interdependent business processes.

RESIDENTIAL STATUS – PERMANENT RESIDENCY

SUMMARY OF QUALIFICATIONS

Customer-focused Solutions Expert with 10 + years of leadership experience in improvement-based technical Data Warehouse project management and business analysis.

Extensive experience in all versions of MS SQL Server, Business Intelligence in MS SQL Server Integration Services(SSIS) & RED WhereScape ETL tool.

Proven skills in T-SQL, Performance tuning, Data migration, Data warehousing techniques, Data Analytics & Modelling and cubes.

Knowledge on Big Data concepts. – Sqoop, Hive, Impala and other related tools.

Expertise in SSRS, Tableau, Power BI & Crystal reports.

Strong technical exposure to C#.net, SharePoint and Business Connectivity Services.

Demonstrated ability in Solution Architecture, Team management & Client management.

Working experience in onsite-offshore model with changing priorities. EDUCATION

Masters of Computer Applications, Bharathiyar University, India.

Bachelor of Computer Science, Bharathiyar University, India. CERTIFICATIONS

PROFESSIONAL EXPERIENCE

Project Lead Feb 2010 - Present

Essentra, Bangalore, India (UK based MNC) http://www.Essentra.com MSBI:

Gather and analyze business requirements and translate business needs into long-term business intelligence solutions leveraging the Microsoft technology platform (SSIS, SSAS, and SSRS)

Configure SQL Reporting Services (SSRS), including data-driven subscriptions.

Create packages using multithreading enabling the parallel processing property of SSIS.

Work with Data Architects to instill industry best practices and generally accepted procedures.

Develop TSQL queries and support ad-hoc requests /reports.

Lead a team of SQL developers / consultants.

Development of database architecture and its roadmaps. WhereScape RED – ETL :

Creating & Supporting of Data Warehouse for all three regions.

Creating Load, Staging, Data Store and Fact tables from various data sources including AS400, Lotus Notes, SQL Server & csv files.

Help Cognos team on scheduling the Cognos cube builds within the scope of WhereScape using “Host Script”

Scheduling of SSRS Reports Subscriptions within WhereScape ensuring the daily subscriptions are reaching customers immediately after the daily jobs.

SharePoint Online & Power BI:

Create, Deploy & Manage Business connectivity services (BCS) for on-premises databases facing internet to be available on Cloud.

Create SharePoint External & Content types based on On-premises tables.

Scheduling of data sync jobs between SQL Server and SharePoint hosed on O365 environment.

Create & deploy Enterprise gateways for Power BI reports to display data available on-premises.

Design & Deploy Power BI reports to be available on cloud and on various devices including iPhones, iPads etc.,

Tailor solutions for Management dashboards, Financial Reporting and Operational Business Intelligence.

Identify and troubleshoot business process and or data quality issues on new or existing reports. Crystal Reports:

Define Crystal Reports layout and conduct formatting, organize data in Crystal Reports by grouping and sorting, Use Formula and Parameters to develop report.

Create Charts and drill-down chart/reports, Cross-tab report and Sub-Report. Software Engineer Aug 2008 – Jan 2010

Softbrands, Bangalore, India (US based Product dev. Org. rebranded to Infor) http://www.softbrands.com

Worked on ERP, a product aimed at the SMB segment.

Built customizations using, VB.net, C#.net, ASP.Net, VB 6.0, MS-SQL Servers, SSRS, Crystal Reports & Infragistics Tools based on customer requirements, after discussions with them. Software Engineer Dec 2006 – Jun 2008

Shlok, Coimbatore, India (Global Product dev. Org.) http://www.shloklabs.com

Worked on logistics & health product related applications using VB.net, C#.net, ASP.Net & VB 6.0 & SQL Servers, Crystal Reports, Component One & Infragistics Tools.

Responsible for System Study, Code development, Unit testing and Bug Fixing of prototype cum live production system.

REFERENCES

Available based on request

Contact details:

G6-103, Provident welworth city, Marasandra, Doddaballapura road, Bangalore – 561203, India.

+91-991******* / +91-80-495*****.

Contact this candidate